Schema coordination in federated database management: a comparison with schema integration

Abstract We have introduced a new approach, termed schema coordination, as an alternative to the well-known schema integration approach for processing cooperative queries in federated database systems. The schema coordination approach is based on the attribute correspondence matrix that links similar attributes in all component databases. In this paper, we compare the schema coordination approach with the schema integration approach for both metadata management and cooperative query processing. We demonstrate that schema coordination offers a much simpler methodology that enables logical data independence and is especially better suited for database federations consisting of many competing databases with ever-evolving metadata.

[1]  Frank Leymann,et al.  A Survey of the Universal Relation Model , 1989, Data Knowl. Eng..

[2]  V. Grover.  An Empirically Derived Model for the Adoption of Customer‐based Interorganizational Systems* , 1993 .

[3]  Jerry Waxman,et al.  A Study of Three Database Query Languages , 1978, JCDKB.

[4]  Edward Sciore,et al.  A Universal Relation Data Model with Semantic Abstraction , 1992, IEEE Trans. Knowl. Data Eng..

[5]  C. Cunningham,et al.  Electronic trading, interorganizational systems and the nature of buyer-seller relationships: The need for a network perspective , 1993 .

[6]  Ronald Fagin,et al.  A simplied universal relation assumption and its properties , 1982, TODS.

[7]  Jeffrey D. Ullman,et al.  Principles of Database and Knowledge-Base Systems, Volume II , 1988, Principles of computer science series.

[8]  Jungyun Seo,et al.  Classifying schematic and data heterogeneity in multidatabase systems , 1991, Computer.

[9]  Venkataraman Ramesh,et al.  A methodology for interschema relationship identification in heterogeneous databases , 1995, Proceedings of the Twenty-Eighth Annual Hawaii International Conference on System Sciences.

[10]  Yuri Breitbart,et al.  Multidatabase Interoperability , 1990, SGMD.

[11]  Jay M. Tenenbaum,et al.  CommerceNet: spontaneous electronic commerce on the Internet , 1995, Digest of Papers. COMPCON'95. Technologies for the Information Superhighway.

[12]  Gottfried Vossen,et al.  Update and retrieval in a relational database through a universal schema interface , 1988, TODS.

[13]  Arie Segev,et al.  A universal relation approach to federated database management , 1995, Proceedings of the Eleventh International Conference on Data Engineering.

[14]  Nabil N. Kamel,et al.  Federated database management system: Requirements, issues and solutions , 1992, Comput. Commun..

[15]  Nanette S. Levinson.  Interorganizational information systems: New approaches to global economic development , 1994, Inf. Manag..

[16]  Amar Gupta,et al.  A Methodology for Integration of Heterogeneous Databases , 1994, IEEE Trans. Knowl. Data Eng..

[17]  James A. Larson,et al.  A Theory of Attribute Equivalence in Databases with Application to Schema Integration , 1989, IEEE Trans. Software Eng..

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

[19]  David Maier,et al.  PIQUE: a relational query language without relations , 1987, Inf. Syst..

[20]  Weimin Du,et al.  The Pegasus heterogeneous multidatabase system , 1991, Computer.

[21]  David M. Kroenke,et al.  Database Processing , 1977 .

[22]  David Maier,et al.  Maximal objects and the semantics of universal relation databases , 1983, TODS.

[23]  Yuri Breitbart,et al.  Database integration in a distributed heterogeneous database system , 1986, 1986 IEEE Second International Conference on Data Engineering.