article

Free access

Federated database systems for managing distributed, heterogeneous, and autonomous databases

Authors:

Amit P. Sheth and

James A. LarsonAuthors Info & Claims

ACM Computing Surveys (CSUR), Volume 22, Issue 3

Pages 183 - 236

https://doi.org/10.1145/96602.96604

Published: 01 September 1990 Publication History

PDF eReader

Abstract

A federated database system (FDBS) is a collection of cooperating database systems that are autonomous and possibly heterogeneous. In this paper, we define a reference architecture for distributed database management systems from system and schema viewpoints and show how various FDBS architectures can be developed. We then define a methodology for developing one of the popular architectures of an FDBS. Finally, we discuss critical issues related to developing and operating an FDBS.

References

[1]

ABBOTT, K., AND MCCARTHY, D. 1988. Administration and autonomy in a replicationtransparent distributed DBMS. In Proceedings of the 14th International Conference on Very Large Data Bases (Aug.), pp. 195-205.

Crossref

Google Scholar

[2]

ALONSO, R., AND BARBARA, D. 1989. Negotiating data access in federated database systems. In Proceedings of the 5th International Conference on Data Engineering (Feb.), pp. 56-65.

Crossref

Google Scholar

[3]

ALONSO, R., GARCIA-MOLINA, H., AND SALEM, K. 1987. Concurrency control and recovery for global procedures in federated database systems. In Q. Bull. IEEE-CS TC Data Eng. I0, 3 (Sept.), 5-11.

Google Scholar

[4]

BARKER, Z., AND OZSU, T. 1988. A survey of issues in distributed heterogeneous database systems. Tech. Rep. TR 88-9, Univ. of Alberta Edmonton, Canada.

Google Scholar

[5]

BATINI, C., LENZERINI, M., AND NAVATHE, S. 1986. A comparative analysis of methodologies for database schema integration. A CM Comput. Surv. 18, 4 (Dec.), 323-364.

Crossref

Google Scholar

[6]

BECK, H., GALA, S., AND NAVATHE, S. 1989. Classification as a query processing technique in CANDIDE semantic data model. In Proceedings of the 5th International Conference on Data Engineering (Feb.), pp. 572-581.

Crossref

Google Scholar

[7]

BELCASTRO, V., ET AL. 1988. An overview of the distributed query system DQS. In Proceedings of the International Conference on Extending Data Base Technology (Venice, Italy, Mar.). In Computer Science. Vol. 303, Springer-Verlag, New York, pp. 170-189.

Crossref

Google Scholar

[8]

BERTINO, E., AND HAAS, L. 1988. Views and security in distributed database management systems. In Proceedings of the International Conference on Extending Database Technology (Venice, Italy, Mar.). In Computer Science. Vol. 303, Springer- Verlag, New York, pp. 155-169.

Crossref

Google Scholar

[9]

BLAKEY, M. 1987. Basis of a partially informed distributed database. In Proceedings of the 13th International Conference on Very Large Data Bases (Brighton, UK, Sept.), pp. 381-388.

Crossref

Google Scholar

[10]

BREITBART, Y., AND SILBERSCHATZ, A. 1988. Multidatabase update issues. In Proceedings of the ACM SIGMOD Conference (June), 135-142.

Crossref

Google Scholar

[11]

BRZEZINSKI, Z., GETTA, J., RYBNIK, J., AND STEP- NIEWSKI, W. 1984. UNIBASE-An integrated access to databases. In Proceedings of the l Oth International Conference on Very Large Data Bases (Singapore, Aug.), pp. 388-395.

Crossref

Google Scholar

[12]

CARDENAS, A. 1987. Heterogeneous distributed database management: The HD-DBMS. In Proc. IEEE 75, 5 (May), 588-600.

Google Scholar

[13]

CERCONE, N., MORGESTERN, M., SHETH, A., AND LITWIN, W. 1990. Resolving semantic heterogeneity. Panel at the International Conference on Data Engineering (Feb.).

Google Scholar

[14]

CERI, S., AND PELAGATTI, G. 1984. Distributed Databases--Principles and Systems. McGraw- Hill, New York.

Crossref

Google Scholar

[15]

CERI, S., PERNICI, B., AND WIEDERHOLD, G. 1987. Distributed database design methodologies. In Proc. IEEE 75, 5 (May), 533-546.

Google Scholar

[16]

CHEN, P. 1976. The entity-relationship model: Toward a unified view of data. A CM Trans. Database Syst. 1, 1 (Mar.), 9-36.

Crossref

Google Scholar

[17]

CHEN, A., BRILL, D., TEMPLETON, M., AND YU, C. 1989. Distributed query processing in Mermaid: A frontend system for multiple databases. IEEE J. Selected Areas Commun. 7, 3 (Apr.), 390-398.

Google Scholar

[18]

CHU, W., AND HURLEY, P. 1982. Optimal query processing for distributed databases systems. IEEE Trans. Comput. C-31 (Sept.), 835-850.

Google Scholar

[19]

CONVENT, B. 1986. Unsolvable problems related to the view integration approach. In Proceedings of the International Conference on Database Theory (Rome, Italy, Sept.). In Computer Science, Vol. 243, Goos, G. and Hartmanis, J. Eds. Springer- Verlag, New York, pp. 141-156.

Crossref

Google Scholar

[20]

CZEJDO, B., RUSINKIEWlCZ, M., AND EMBLEY, D. 1987. An approach to schema integration and query formulation in federated database systems. In Proceedings of the 3rd International Conference on Data Engineering (Feb.), pp. 477-484.

Crossref

Google Scholar

[21]

DATE, C. 1986. An Introduction to Database Systems, Vol. 1, 4th ed. Addison-Wesley, Reading, Mass.

Crossref

Google Scholar

[22]

DAYAL, U., AND GOODMAN, N. 1982. Query optimization for CODASYL database systems. In Proceedings of the A CM SIGMOD Conference, pp. 138-150.

Crossref

Google Scholar

[23]

DAYAL, U., AND HWANG, H. 1984. View definition and generalization for database integration in a multidatabase system. IEEE Trans. Soft. Eng. SE-IO, 6 (Nov.), 628-644.

Google Scholar

[24]

DE 1987. Special issue on federated database systems (mainly transaction management aspects). Q. Bull. IEEE-CS TC Data Eng. 10, 3 (Sept.).

Google Scholar

[25]

DEMO, B. 1983. Program analysis for conversion from a navigational to a specification data base interface. In Proceedings of the 9th International Conference on Very Large Data Bases (Florence, Italy, Oct.), pp. 387-398.

Crossref

Google Scholar

[26]

DEVOR, C., ELMASRI, R., LARSON, J., RAHIMI, S., AND RICHARDSON, J. 1982b. Five-schema architecture extends DBMS to distributed applications. Electron. Des. (Mar. 18), 27-32.

Google Scholar

[27]

DEVOR, C., ELMASR}, R., AND RAHIMI, S. 1982a. The design of DDTS: A testbed for reliable distributed database management. Tech. Rep. HP-82-273: 17-38, Honeywell Computer Sciences Center, Camden, Minn.

Google Scholar

[28]

DP 1988. Special issue on heterogeneous distributed database systems. L. Lilien, Ed. Distrib. Process. Tech. Comm. News. (Q.) 10, 2 (Nov.).

Google Scholar

[29]

Du, W., AND ELMAGARMID, A. 1989. Quasi serializability: A correctness criterion for global concurrency control in interbase. In Proceedings of the 15th International Conference on Very Large Data Bases (Amsterdam, Aug.), pp. 347-355.

Crossref

Google Scholar

[30]

DU, W., ELMAGARMID, A., AND KIM, W. 1990. Effects of local autonomy on heterogeneous distributed database systems. MCC Tech. Rep. ACT-OODS-EI-059-90, Microelectronics and Computer Technology Corp., Austin Tex.

Google Scholar

[31]

Du, W., ELMAGARMID, A., LEU, Y., AND OSTERMANN, S. 1989. Effects of local autonomy on global concurrency control in heterogeneous database systems. In Proceedings of the 2nd International Conference on Data and Knowledge Systems for Manufacturing and Engineering (Oct.).

Google Scholar

[32]

DWYER, P., AND LARSON, J. 1987. Some experiences with a distributed database testbed system. In Proc. IEEE 75, 5 (May), 633-647.

Google Scholar

[33]

ELIASSEN, F. AND VEIJALAINEN, J. 1987. An S- transaction definition language and execution mechanism. Tech. Rep. No. 275, GMD, Hardenbergplatz, D-1000 Berlin 12, FRG.

Google Scholar

[34]

ELIASSEN, F., AND VEIJALAINEN, J. 1988. A functional approach to information system interoperability. In Research into Networks and Distributed Applications (Proceedings of the EUTECO "88), Speth, R. Ed., Elsevier Science Publishers B.V., North-Holland, pp. 1121-1135.

Google Scholar

[35]

ELLINGHAUS, D., HALLMANN, M., HOLTKAMP, B., AND KREPLIN, Z. 1988. A multidatabase system for transaction autonomy, in Proceedings of the International Conference on Extending Database Technology (Venice, italy, Mar.). In Computer Science, Vol. 303, Springer-Verlag, New York, pp. 600-605.

Crossref

Google Scholar

[36]

ELMAGARMID, A. 1987. When will we have true heterogeneous databases? (A position statement on Transaction Processing). In Proceedings of the Fall Joint Computer Conference {Dallas, Tex., Oct.), p. 746.

Crossref

Google Scholar

[37]

ELMAGARMID, A., AND HELAL, A. 1988. Supporting updates in heterogeneous distributed database systems. In Proceedings on the International Conference on Data Engineering (Feb.).

Crossref

Google Scholar

[38]

ELMASRI, R. 1981. GORDAS: A data definition, query and update language for the entity-category-relationship model of data. Tech. Rep. HR- 81-250, Honeywell Inc., Camden, Minn.

Google Scholar

[39]

ELMASRI, R., AND NAVATHE, S. 1989. Fundamentals of Database Systems. Benjamin/Cummings, Redwood City, Calif.

Crossref

Google Scholar

[40]

ELMASRI, R., LARSON, J., AND NAVATHE, S. 1986. Schema integration algorithms for federated databases and logical database design. Tech. Rep., Honeywell Corporate Systems Development Division, Camden, Minn.

Google Scholar

[41]

ELMASRI, R., WEELDREYER, J., AND HEVNER, A. 1985. The category concept: An extension to entity-relationship model. Data and Knowledge Engineering I (June). North-Holland, The Netherlands, pp. 75-116.

Crossref

Google Scholar

[42]

FAGIN, R. 1978. On an authorization mechanism. ACM Trans. Database Syst. 3, 3, 310-331.

Crossref

Google Scholar

[43]

GARCIA-MOLINA, H., AND KOGAN, B. 1988. Node autonomy in distributed systems. In Proceedings of the International Symposium on Databases in Parallel and Distributed Systems (Austin, Tex., Dec.), pp. 158-166.

Crossref

Google Scholar

[44]

GARCIA-MOLINA, H., AND SALEM, K. 1987. Sagas. In Proceedings of the A CM SIGMOD Conference (May), pp. 249-259.

Crossref

Google Scholar

[45]

GE, L., JOHANNSEN, W., LAMERSDORF, W., REIN- HARDT, R., AND SCHMIDT, J. 1987. Import and export of database objects in a distributed environment. In Proceedings of the IFIP WG 10.3 Conference on Distributed Processing (Amsterdam, Oct.).

Google Scholar

[46]

GLIGOR, V., AND LUCKENBAUGH, G. 1984. Interconnecting heterogeneous database management systems. Comput. 17, 1 (Jan.), 33-43.

Crossref

Google Scholar

[47]

GLIGOR, V., AND POPESCU-ZELETIN, R. 1986. Transaction management in distributed heterogeneous database management systems. Inf. Syst. 11, 4, 287-297.

Crossref

Google Scholar

[48]

HAMMER, M., AND MCLEOD, D. 1979. On database management system architecture. Tech. Rep. MIT/LCS/TM-141, Massachusetts Institute of Technology, Cambridge, Mass.

Google Scholar

[49]

HAMMER, K., AND TIMMERMAN, W. 1989. Automating data conversion between heterogeneous databases. Tech. Rep. ACA-ST-046-89, Microelectronics and Computer Technology Corp.

Google Scholar

[50]

HAYES, S., AND RAM, S. 1990. Multi-user view integration system (MUVIS): An expert system for view integration. In Proceedings of the 6th International Conference on Data Engineering (Feb.).

Crossref

Google Scholar

[51]

HEIMBIGNER, D., AND MCLEOD, D. 1985. A federated architecture for information management. A CM Trans. Of/. Inf. Syst. 3, 3 (July), 253-278.

Crossref

Google Scholar

[52]

HULL, R., AND KING, R. 1987. Semantic database modeling: Survey, applications, and research issues. ACM Comput. Surv. 19, 3 (Sept.), 201-260.

Crossref

Google Scholar

[53]

IEEE 1987. Special issue on distributed database systems. Proc. IEEE 75, 5 (May).

Google Scholar

[54]

IISS 1986. The integrated information support system. Gateway 2, 2. Industrial Technology Institute (Mar.-Apr.).

Google Scholar

[55]

JACOBS, B. 1985. Applied Database Logic II: Heterogeneous Distributed Query Processing. Prentice- Hall, Englewood Cliffs, N.J.

Google Scholar

[56]

JACOBSON, G., PIATETSKY-SHAPIRO, G., LAFOND, C., RAJINIKANTH, M., HERNANDEZ, J. 1988. CALIDA: A knowledge-based system for integrating multiple heterogeneous databases. In Proceedings of the 3rd International Conference on Data and Knowledge Bases (Jerusalem, Israel, June), pp. 3-18.

Google Scholar

[57]

KAUL, M., DROSTERN, K., AND NEUHOLD, E. 1990. ViewSystem: Integrating heterogeneous information bases by object-oriented views. In Proceedings of the 6th international Conference on Data Engineering (Los Angeles, Calif., Feb.), pp. 2-10.

Crossref

Google Scholar

[58]

KIM, W. 1989. Research directions for integrating heterogeneous databases. In 1989 Workshop on Heterogeneous Databases (Chicago, Ill., Dec.).

Google Scholar

[59]

LANDERS, T., AND ROSENBERG, R. 1982. An overview of Multibase. In Distributed Databases, H.-J. Schneider, Ed., North-Holland, The Netherlands, pp. 153-184.

Google Scholar

[60]

LARSON, J. 1983a. Bridging the gap between network and relational database management systems. Comput. (Sept.), 82-92.

Google Scholar

[61]

LARSON, J. 1983b. Granting and revoking discretionary authority. Inf. Syst. 8, 4, 251-261.

Google Scholar

[62]

LARSON, J. 1989. Four reference architectures for distributed database management systems. Computer, Standards and Interfaces, Vol. 8, pp. 209-221.

Google Scholar

[63]

LARSON, J., NAVATHE, S., AND ELMASRI, R. 1989. A theory of attribute equivalence in databases with applications to schema integration. IEEE Trans. Softw. Eng. 15, 4 (Apr.), 449-463.

Crossref

Google Scholar

[64]

LIEN, Y. 1981. Hierarchical schemata for relational databases. ACM Trans. Database Syst. 6, 48-69.

Crossref

Google Scholar

[65]

LITWIN, W. 1985. An overview of the multidatabase system MRDSM. In Proceedings of the A CM National Conference (Denver, Oct.), pp. 495-504.

Crossref

Google Scholar

[66]

LITWIN, W., 1987. The future of heterogeneous databases. In Proceedings of the Fall Joint Computer Conference (Dallas, Tex., Oct.), pp. 751-752.

Crossref

Google Scholar

[67]

LITWIN, W., AND ABDELLATIF, A. 1986. Multidatabase interoperability. IEEE Comput. 19, 12 (Dec.), 10-18.

Crossref

Google Scholar

[68]

LITWIN, W., AND ABDELLATIF, A. 1987. An overview of multidatabase manipulation language MDSL. In IEEE Proc. 75, 5 (May), 621-632.

Google Scholar

[69]

LITWIN, W., AND ZEROUAL, A. 1988. Advances in multidatabase systems. In Research into Networks and Distributed Applications (Proceedings of the EUTECO '88), Speth, R., Ed. Elsevier Science Publishers B.V., North-Holland, pp. 1137-1151.

Google Scholar

[70]

LITWIN, W., ABDELLATIF, A., NICOLAS, B., VIGIER, P., AND ZEROUAL, A. 1987. MSQL: A multidatabase language. Tech. Rep. 695, INRIA, B P 105, 78153 Le-Chesnay, France.

Google Scholar

[71]

LITWIN, W., BOUDENANT, J., ESCULIER, C., FERRIER, A., GLORIEUX, A., LA CHIMIA, J., KABBAJ, K., MOULINOUX, C., ROLIN, P., AND STANGRET, C. 1982. SIRIUS Systems for Distributed Data Management. In Distributed Data Bases, H.-J. Schneider, Ed. North-Holland, The Netherlands, pp. 311-366.

Google Scholar

[72]

LOGAR, T., AND SHETH, A. 1986. Concurrency control issues in heterogeneous distributed database management systems. Tech. Memo, Honeywell Computer Sciences Center, Camden, Minn.

Google Scholar

[73]

MOTRO, A., AND BUNEMAN, P. 1981. Constructing superviews. In Proceeding of the A CM SIGMOD Conference (May), pp. 54-64.

Crossref

Google Scholar

[74]

NAVATHE, S., ELMASRI, R., AND LARSON, J. 1986. Integrating user views in database design. IEEE Comput. 19, 1 (Jan.), 50-62.

Google Scholar

[75]

NAVATHE, S., GALA, S., KAMATH, A., KRISHNAMUR- THY, A., SAVASERE, A., AND WANG, W. 1989. A federated architecture for heterogeneous information systems. In the Workshop on Heterogeneous Database Systems (Chicago, Ill., Dec.).

Google Scholar

[76]

ONUEGBE, E., RAHIMI, S., AND HEVNER, A. 1983. Local query translation and optimization in a distributed system. In AFIPS Conference Proceedings, Vol. 52, National Computer Conference, AFIPS Press, pp. 229-239.

Google Scholar

[77]

Ozsu, M., AND VALDURIEZ, P. 1990. Principles of Distributed Database Systems. Prentice-Hall, Englewood Cliffs, N.J.

Crossref

Google Scholar

[78]

PECKHAM, J., AND MARYANSKI, J. 1988. Semantic data models. ACM Comput. Surv. 20, 3 (Sept.), 153-190.

Crossref

Google Scholar

[79]

PIATETSKY-SHAPIRO, G., AND JAKOBSON, G. 1987. An intermediate database language and its rulebased transformation to different database languages. Data and Knowledge Engineering 2, 1-29.

Crossref

Google Scholar

[80]

Pu, C. 1987. Superdatabases: Transactions across database boundaries, in Q Bull. IEEE-CS TC Data Eng. 10, 3 (Sept.), 19-25.

Google Scholar

[81]

RAM, S., AND CHASTAIN, C. 1989. Architecture of distributed data base systems. J. Syst. Softw. 10, 2, 77-95.

Crossref

Google Scholar

[82]

ROSENTHAL, A., AND REINER, D. 1987. Theoretically sound transformations for practical database design. In Proceedings of the 6th International Conference on Entity-Relationship Approach (New York, Nov.), pp. 97-113.

Crossref

Google Scholar

[83]

RUSINKIEWICZ, M. 1987. Heterogeneous databases: Towards a federation of autonomous systems. In Proceedings of the Fall Joint Computer Conference (Dallas, Tex., Oct.), pp. 751-752.

Crossref

Google Scholar

[84]

RUSINKIEWCIZ, M., AND CZEJDO, B. 1987. An approach to query processing in federated database systems. In Proceedings of the 20th International Conference on System Sciences (Hawaii, Jan.), pp. 430-440.

Google Scholar

[85]

RUSINKIEWICZ, M., OSTERMANN, S., ELMAGARMID, A., AND LOA, K. 1990. The distributed operation language for specifying multisystem applications. In Proceedings of the 1st International Conference on Systems Integration (Morristown, N.J., Apr.).

Crossref

Google Scholar

[86]

RUSINKIEWICZ, M., ELMASRI, R., CZEJDO, B., GEORAKOPOULOUS, D., KARABATIS, G., JA- MOUSS{, A., LOA, L., AND LI, Y. 1989. OMNIBASE: Design and implementation of a multidatabase system. In Proceedings of the 1st Annual Symposium in Parallel and Distributed Processing (Dallas, Tex., May), pp. 162-169.

Google Scholar

[87]

RYAN, K., AND LARSON, J. 1986. The use of E-R models in capability schemas. In Proceedings of the 5th International Conference on the Entity- Relationship Approach (Dijoin, France, Nov.).

Google Scholar

[88]

SELINGER, P., AND WADE, B. 1976. An authorization mechanism for a relational database system. A CM Trans. Database Syst. 1, 3, 242-255.

Crossref

Google Scholar

[89]

SIEGEL, M. 1987. A survey on heterogeneous database systems. Tech. Note 87-174.1, GTE Laboratories, Waltham, Mass.

Google Scholar

[90]

SHETH, A. 1987a. Heterogeneous distributed database systems: Issues in integration. The 3rd International Conference on Data Engineering. IEEE Press, Washington, D.C.

Google Scholar

[91]

SHETH, A. 1987b. When will we have true heterogeneous database systems? In Proceedings of the Fall Joint Computer Conference (Dallas, Tex., Oct.), pp. 747-748.

Crossref

Google Scholar

[92]

SHETH, A. 1988a. Managing and integrating unstructured and structured data: Problems of representation, features, and abstraction. In Proceedings of the 4th International Conference on Data Engineering. pp. 598-599.

Crossref

Google Scholar

[93]

SHETH, A. 1988b. Building Federated Database Systems. In Distrib. Process. Tech. Comm. Newsl. 10, 2 (Nov.), 50-58.

Google Scholar

[94]

SHETH, A., AND GALA, S. 1989. Attribute relationships: An impediment in automating schema integration. In the Workshop on Heterogeneous Database Systems (Chicago, Ill., Dec.).

Google Scholar

[95]

SHETH, A., LARSON, J., AND WATKINS, E. 1988a. TAILOR: A tool for updating views. In Proceedings of the International Conference on Extending Database Technology (Venice, Italy, Mar.). In Computer Science, Vol. 303, Springer- Verlag, New York, pp. 190-213.

Crossref

Google Scholar

[96]

SHETH, A., LARSON, J., CORNELLIO, A., AND NAVATHE, S. 1988b. A tool for integrating conceptual schemas and user views. In Proceedings of 4th International Conference on Data Engineering, pp. 176-183.

Crossref

Google Scholar

[97]

SOUZA, J. 1986. SIS: A schema integration system. In Proceedings of the BNCOD5 Conference. pp. 167-185.

Crossref

Google Scholar

[98]

TEMPLETON, M., LUND, E., AND WARD, P. 1987a. Pragmatics of access control in Mermaid. In Q. Bull. IEEE-CS TC Data Eng. 10, 3 (Sept.), 33-38.

Google Scholar

[99]

TEMPLETON, M., BRILL, D., CHEN, A., DAO, S., LUND, E., MCGREGOR, R., AND WARD, P. 1987b. Mermaid: A front-end to distributed heterogeneous databases. In Proc. IEEE 75, 5 (May), 695-708.

Google Scholar

[100]

TEOREY, T. 1990. Database Modeling and Design: The Entity-Relationship Approach, Chaps. 8-9. Morgan Kaufmann, San Mateo, Calif.

Crossref

Google Scholar

[101]

TEOREY, T., YANG, D., AND FRY, J. 1986. A logical design methodology for relational databases using the extended entity-relationship model. A CM Comput. Surv. 18, 2 (June), 197-222.

Crossref

Google Scholar

[102]

THOMAS, G., et al. 1990. Heterogeneous distributed database systems for production Use. Comput. Surv. 22, 3 (Sept.), 237-266.

Crossref

Google Scholar

[103]

TSICHRITZIS, D., AND KLUG, A. Eds. 1978. The ANSI/X3/SPARC DBMS framework. Inf. Syst. 3,4.

Google Scholar

[104]

TSICHRITZIS, D., AND LOCHOVSKY, F. 1982. Data Models, Chap. 14. Prentice-Hall, Englewood Cliffs, N.J.

Crossref

Google Scholar

[105]

VEIJALAINEN, J., AND POPESCU-ZELETIN, R. 1988. Multidatabase systems in ISO/OSI environment. In Standards in Information Technology and Industrial Control, Malagardis, N., and Williams, T., Eds. North-Holland, The Netherlands, pp. 83-97.

Google Scholar

[106]

WANG, C., AND SPOONER, D. 1987. Access control in a heterogeneous distributed database management system. In Proceedings of the 6th Symposium on Reliability in Distributed Software and Database Systems (Mar.).

Google Scholar

[107]

Yu, C., AND CHANG, C. 1984. Distributed query processing. ACM Comput. Surv. 16, 4, (Dec.), 399-433.

Crossref

Google Scholar

[108]

ZANIOLO, C. 1979. Design of relational views over network schemas. In Proceedings of the A CM SIGMOD Conference, pp. 179-190.

Crossref

Google Scholar

Cited By

View all

Berger CDoherty PRudol PWzorek MDastani MSichman JAlechina NDignum V(2024)A Summary of the RGS⊕: an RDF Graph Synchronization System for Collaborative RoboticsProceedings of the 23rd International Conference on Autonomous Agents and Multiagent Systems10.5555/3635637.3663302(2827-2829)Online publication date: 6-May-2024
https://dl.acm.org/doi/10.5555/3635637.3663302
Gu ZCorcoglioniti FLanti DMosca AXiao GXiong JCalvanese D(2024)A systematic overview of data federation systemsSemantic Web10.3233/SW-22320115:1(107-165)Online publication date: 12-Jan-2024
https://doi.org/10.3233/SW-223201
Dix A(2024)Just Counting – a tool ecology for personal numeric informationProceedings of the 2024 International Conference on Advanced Visual Interfaces10.1145/3656650.3656658(1-5)Online publication date: 3-Jun-2024
https://dl.acm.org/doi/10.1145/3656650.3656658
Show More Cited By

Recommendations

Managing change in heterogeneous autonomous databases
Read More
Database Systems: A Practical Approach to Design, Implementation and Management
Read More
When will we have true heterogeneous database systems
ACM '87: Proceedings of the 1987 Fall Joint Computer Conference on Exploring technology: today and tomorrow

Systems that can minimally qualify as heterogeneous database systems already exist; however, there is a long way to go before we have true heterogeneous database systems. Before we can determine when this will happen, we must agree on what a true ...
Read More

Reviews

Reviewer: David Gary Hill

A federated database system (FDBS) is a set of autonomous and possibly heterogeneous databases that have to work together. This paper provides a thorough review of the issues surrounding federated databases. Architectural issues addressed include both loosely coupled and tightly coupled FDBSs as well as a five-level schema architecture. The authors discuss both bottom-up and top-down methodologies for developing an FDBS. They cover both development and operational issues for an FDBS in depth. The discussion of types of heterogeneity and autonomy is especially well done. Parts of the discussions on transforming processors and component schemas are hard to follow. The paper focuses exclusively on the technical issues, but in the future, FDBSs will be an important subject from the user perspective. Organizations will have to provide access to autonomous, distributed, and heterogeneous databases on an enterprise-wide basis. Individuals will also want to use online systems that can access disparate database systems simultaneously. As a result, the paper serves a valuable purpose as a basis for future research work. The benefits from reading this paper will only be gained by people who have a strong background in database management technology. A shorter version of the paper, with a focus on clarifying the key issues for the computer professional who is knowledgeable about DBMSs but is not an expert, would be valuable.

Access critical reviews of Computing literature here

Become a reviewer for Computing Reviews.

Comments

Information & Contributors

Information

Published In

ACM Computing Surveys Volume 22, Issue 3

Special issue on heterogeneous databases

Sept. 1990

111 pages

ISSN:0360-0300

EISSN:1557-7341

DOI:10.1145/96602

Issue’s Table of Contents

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 September 1990

Published in CSUR Volume 22, Issue 3

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

1,740
Total Citations
View Citations
12,127
Total Downloads

Downloads (Last 12 months)674
Downloads (Last 6 weeks)60

Other Metrics

View Author Metrics

Citations

Cited By

View all

Berger CDoherty PRudol PWzorek MDastani MSichman JAlechina NDignum V(2024)A Summary of the RGS⊕: an RDF Graph Synchronization System for Collaborative RoboticsProceedings of the 23rd International Conference on Autonomous Agents and Multiagent Systems10.5555/3635637.3663302(2827-2829)Online publication date: 6-May-2024
https://dl.acm.org/doi/10.5555/3635637.3663302
Gu ZCorcoglioniti FLanti DMosca AXiao GXiong JCalvanese D(2024)A systematic overview of data federation systemsSemantic Web10.3233/SW-22320115:1(107-165)Online publication date: 12-Jan-2024
https://doi.org/10.3233/SW-223201
Dix A(2024)Just Counting – a tool ecology for personal numeric informationProceedings of the 2024 International Conference on Advanced Visual Interfaces10.1145/3656650.3656658(1-5)Online publication date: 3-Jun-2024
https://dl.acm.org/doi/10.1145/3656650.3656658
Falazi GBreitenbücher ULeymann FSchulte S(2024)Cross-Chain Smart Contract Invocations: A Systematic Multi-Vocal Literature ReviewACM Computing Surveys10.1145/363804556:6(1-38)Online publication date: 22-Jan-2024
https://dl.acm.org/doi/10.1145/3638045
Brahmia ZGrandi FOliboni B(2024)A Literature Review on Schema Evolution in DatabasesComputing Open10.1142/S297237012430001202Online publication date: 12-Jul-2024
https://doi.org/10.1142/S2972370124300012
Konno SYasushi I(2024)Exploration of Fault Identification and Automatic Recovery in Cloud-based FPGA Systems2024 IEEE International Conference on Consumer Electronics (ICCE)10.1109/ICCE59016.2024.10444366(1-6)Online publication date: 6-Jan-2024
https://doi.org/10.1109/ICCE59016.2024.10444366
Yan DLi XYang QLiu R(2024)Key Technologies of Government Data Heterogeneity and Interoperation: A Survey2024 IEEE 7th Advanced Information Technology, Electronic and Automation Control Conference (IAEAC)10.1109/IAEAC59436.2024.10503635(1673-1679)Online publication date: 15-Mar-2024
https://doi.org/10.1109/IAEAC59436.2024.10503635
Li YChen SHwang KJi XLei ZZhu YYe FLiu M(2024)Spatio-temporal data fusion techniques for modeling digital twin CityGeo-spatial Information Science10.1080/10095020.2024.2350175(1-24)Online publication date: 17-May-2024
https://doi.org/10.1080/10095020.2024.2350175
Gutiérrez YSalas JMontoyo AMuñoz REstévez-Velarde S(2024)KD SENSO-MERGER: An architecture for semantic integration of heterogeneous dataEngineering Applications of Artificial Intelligence10.1016/j.engappai.2024.107854132(107854)Online publication date: Jun-2024
https://doi.org/10.1016/j.engappai.2024.107854
Pal K(2023)A Semantic Web-Based Systems Integration to Enhance the Quality of Supply Chain ManagementInformation Logistics for Organizational Empowerment and Effective Supply Chain Management10.4018/979-8-3693-0159-3.ch005(73-107)Online publication date: 5-Dec-2023
https://doi.org/10.4018/979-8-3693-0159-3.ch005
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Abstract

References

Cited By

Recommendations

Managing change in heterogeneous autonomous databases

Database Systems: A Practical Approach to Design, Implementation and Management

When will we have true heterogeneous database systems

Reviews

Access critical reviews of Computing literature here

Comments

Information

Published In

Publisher

Publication History

Permissions

Check for updates

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

PDF

eReader

Get Access

Login options

Full Access

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations