Constructing superviews

ABSTRACT

A method is described for integrating two or more databases into a conceptual "superview", through a set of schema transformations. Such integration may be useful when it is required to produce a unified view of two databases while preserving their physical independence. Each transformation defines a mapping of queries against the superview into the appropriate set of queries against the underlying databases and imposes a constraint that is checked when the query is evaluated. A program that interactively aids the user in constructing the superview and that performs this query transformation is being developed.

REFERENCES

• 1: D.McLeod and D.Heimbigner; A Federated Architecture for Database Systems; Proceedings of AFIPS National Computer Conference, Anaheim, California, 1980.
• 2: David W. Shipman, The functional data model and the data language DAPLEX, Proceedings of the 1979 ACM SIGMOD international conference on Management of data, May 30-June 01, 1979, Boston, Massachusetts [doi>10.1145/582095.582105]
• 3: Michael Hammer , Dennis McLeod, The semantic data model: a modelling mechanism for data base applications, Proceedings of the 1978 ACM SIGMOD international conference on management of data, May 31-June 02, 1978, Austin, Texas [doi>10.1145/509252.509264]
• 4: John Miles Smith , Diane C. P. Smith, Database abstractions: aggregation, Communications of the ACM, v.20 n.6, p.405-413, June 1977 [doi>10.1145/359605.359620]
• 5: John Miles Smith , Diane C. P. Smith, Database abstractions: aggregation and generalization, ACM Transactions on Database Systems (TODS), v.2 n.2, p.105-133, June 1977 [doi>10.1145/320544.320546]
• 6: E.H.Sibley and L.Kershberg; Data Architecture and Data Model Considerations; Proceedings of AFIPS NAtional Computer Conference, Dallas, Texas, 1979.
• 7: B.C.Housel, V.E.Waddle and S.B.Yao; The Functional Dependency Model for Logical Database Design; Proceedings of the Fifth International Conference on Very Large Data Bases, Rio De Janeiro, Brazil, 1979.
• 8: Peter Buneman , Robert E. Frankel, FQL: a functional query language, Proceedings of the 1979 ACM SIGMOD international conference on Management of data, May 30-June 01, 1979, Boston, Massachusetts [doi>10.1145/582095.582104]
• 9: A.Motro and P.Buneman; Automatically Merging Databases; Proceedings of COMPCON Fall 80 --- Distributed Computing, The 21st IEEE Computer Society International Conference, Washington, D.C., 1980.