Interoperability of multiple autonomous databases
- 1 September 1990
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Computing Surveys
- Vol. 22 (3) , 267-293
- https://doi.org/10.1145/96602.96608
Abstract
Database systems were a solution to the problem of shared access to heterogeneous files created by multiple autonomous applications in a centralized environment. To make data usage easier, the files were replaced by a globally integrated database. To a large extent, the idea was successful, and many databases are now accessible through local and long-haul networks. Unavoidably, users now need shared access to multiple autonomous databases. The question is what the corresponding methodology should be. Should one reapply the database approach to create globally integrated distributed database systems or should a new approach be introduced? We argue for a new approach to solving such data management system problems, called multidatabase or federated systems. These systems make databases interoperable, that is, usable without a globally integrated schema. They preserve the autonomy of each database yet support shared access. Systems of this type will be of major importance in the future. This paper first discusses why this is the case. Then, it presents methodologies for their design. It further shows that major commerical relational database systems are evolving toward multidatabase systems. The paper discusses their capabilities and limitations, presents and discusses a set of prototypes, and, finally, presents some current research issues.Keywords
This publication has 12 references indexed in Scilit:
- MSQL: A multidatabase languageInformation Sciences, 1989
- Multiple-query optimizationACM Transactions on Database Systems, 1988
- CALIDA: A System for Integrated Retrieval from Multiple Heterogeneous DatabasesPublished by Elsevier ,1988
- Superviews: Virtual Integration of Multiple DatabasesIEEE Transactions on Software Engineering, 1987
- An overview of the multi-database manipulation language MDSLProceedings of the IEEE, 1987
- Principles and Techniques in the Design of ADMS±Computer, 1986
- Multidatabase InteroperabilityComputer, 1986
- Reference model for DBMS standardizationACM SIGMOD Record, 1986
- A federated architecture for information managementACM Transactions on Information Systems, 1985
- Schema manipulation in self-describing and self-documenting data modelsInternational Journal of Parallel Programming, 1985