Abstract:
We introduced a new approach, termed schema coordination, as an alternative to the wellknown 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. Key words: federated database systems, metadata management, multi-organizational information systems, query translation, schema coordination, schema integration, universal relation An earlier version of the work was presented at the Workshop on Information Technology and Sys...
Citations
|
871
|
Federated database systems for managing distributed, heterogeneous, and autonomous databases
– Sheth, Larson
- 1990
|
|
450
|
A Comparative Analysis of Methodologies for Database Schema Integration
– Batini, Lenserini, et al.
- 1987
|
|
136
|
Classifying schematic and data heterogeneity in multidatabase systems
– Kim, Seo
- 1991
|
|
128
|
A Theory of Attribute Equivalence in Databases with Application to Schema Integration
– Larson, Navathe, et al.
- 1989
|
|
46
|
A Simplified Universal Relation Assumption and Its Properties
– Fagin, Mendelzon, et al.
- 1982
|
|
39
|
A methodology for integration of heterogeneous databases
– Reddy, Prasad, et al.
- 1994
|
|
38
|
Database integration in a distributed heterogeneous database system
– Breitbart, Olson, et al.
- 1986
|
|
35
|
Maximal objects and the semantics of universal relation databases
– Maier, Ullman
- 1983
|
|
34
|
et al. The Pegasus Heterogeneous Multidatabase System
– Ahmed
- 1991
|
|
27
|
An empirically derived model for the adoption of customer-based interorganizational systems. Decision Sciences
– Grover
- 1993
|
|
22
|
Multidatabase Interoperability
– Breitbart
- 1990
|
|
14
|
A universal relation data model with semantic abstractions
– Chang, Sciore
- 1992
|
|
11
|
A Study of Three Database Query Languages
– Greenblatt, Waxman
- 1978
|
|
10
|
Update and retrieval in a relational database through a universal schema interface
– Brosda, Vossen
- 1988
|
|
9
|
Electronic Trading, Interorganizational Systems and the Nature of Buyer-Seller Relationships: The Need for a Network Perspective
– Cunningham, Tynan
- 1993
|
|
5
|
A Survey of the Universal Relation Model
– Leymann
- 1989
|
|
5
|
A universal relation approach to federated database management
– Zhao, Segev, et al.
- 1995
|
|
3
|
Federated database management system: Requirements, issues and solutions
– Kamel, Kamel
- 1992
|
|
3
|
Database Processing
– Kroenke
- 1995
|
|
3
|
A methodology for interschema relationship identification in heterogeneous databases
– Ramesh, Ram
- 1995
|
|
2
|
Commercenet: spontaneous electronic commerce on the internet
– Tenenbaum, Medich, et al.
- 1995
|
|
1
|
Interorganizational information systems: New approaches to global economic development
– Levinson
- 1994
|
|
1
|
A Relation Query Language without Relations
– PIQUE
- 1987
|
|
1
|
Schema coordination in federated database systems
– Zhao
- 1994
|
|
1
|
A coordination-based query processing paradigm for interorganizational information systems
– Zhao, Segev, et al.
- 1996
|
