Theoretical Aspects of Schema Merging

A general technique for merging database schemas is developed that has a number of advantages over existing techniques, the most important of which is that schemas are placed in a partial order that has bounded joins. This means that the merging operation, when it succeeds, is both associative and commutative, i.e., that the merge of schemas is independent of the order in which they are considered — a property not possessed by existing methods. The operation is appropriate for the design of interactive programs as it allows user assertions about relationships between nodes in the schemas to be considered as elementary schemas. These can be combined with existing schemas using precisely the same merging operation.

[1]  Anthony Kosky,et al.  Modeling and Merging Database Schemas , 1991 .

[2]  Abraham Silberschatz,et al.  Database System Concepts , 1980 .

[3]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .

[4]  Roger King,et al.  Semantic database modeling: survey, applications, and research issues , 1987, CSUR.

[5]  David W. Shipman,et al.  The functional data model and the data languages DAPLEX , 1981, TODS.

[6]  Jeffrey D. Ullman,et al.  Principles Of Database And Knowledge-Base Systems , 1979 .

[7]  James A. Larson,et al.  Integrating User Views in Database Design , 1986, Computer.

[8]  T. J. Teorey,et al.  A logical design methodology for relational databases using the extended entity-relationship model , 1986, CSUR.

[9]  Peter P. Chen The Entity-Relationship Model: Towards a unified view of Data , 1976 .

[10]  Eugene Wong,et al.  Multibase: integrating heterogeneous distributed database systems , 1981, AFIPS '81.

[11]  Atsushi Ohori,et al.  Semantics of Types for Database Objects , 1988, Theor. Comput. Sci..

[12]  Amihai Motro,et al.  Superviews: Virtual Integration of Multiple Databases , 1987, IEEE Transactions on Software Engineering.

[13]  David W. Shipman The functional data model and the data language DAPLEX , 1979, SIGMOD '79.

[14]  Maurizio Lenzerini,et al.  Cardinality Constraints in the Entity-Relationship Model , 1983, ER.

[15]  Peter P. Chen The entity-relationship model: toward a unified view of data , 1975, VLDB '75.