DIRECT: a query facility for multiple databases

ABSTRACT

The subject of this research project is the architecture and design of a multidatabase query facility. These databases contain structured data, typical for business applications. Problems addressed are: presenting a uniform interface for retrieving data from multiple databases, providing autonomy for the component databases, and defining an architecture for semantic services.DIRECT is a query facility for heterogeneous databases. The databases and their definitions can differ in their data models, names, types, and encoded values. Instead of creating a global schema, descriptions of different databases are allowed to coexist. A multidatabase query language provides a uniform interface for retrieving data from different databases. DIRECT has been exercised with operational databases that are part of an automated business system.

REFERENCES

• 1: C. Batini , M. Lenzerini , S. B. Navathe, A comparative analysis of methodologies for database schema integration, ACM Computing Surveys (CSUR), v.18 n.4, p.323-364, Dec. 1986 [doi>10.1145/27633.27634]
• 2: BOBROW, D. 1981. Browsing in a programming environment In the 14th Hawaii Conferer~ce on System Sczelzce. ACM, New York, 32-44.
• 3: E. F. Codd, A relational model of data for large shared data banks, Communications of the ACM, v.13 n.6, p.377-387, June 1970 [doi>10.1145/362384.362685]
• 4: GOULD, J. 1988. How to design usable systems. In Handbook of Human-Computer Interactwn. 757-789.
• 5: HACKATHORN, D. 1993. Enterpmse Database Connecawty. Wiley, New York, Ch. 7.
• 6: INGRES CORPORATION. 1991. Ingres/StarInformation Integratzon. Ingres Corp.,Alameda, Calif.
• 7: Ravi Krishnamurthy , Witold Litwin , William Kent, Language features for interoperability of databases with schematic discrepancies, Proceedings of the 1991 ACM SIGMOD international conference on Management of data, p.40-49, May 29-31, 1991, Denver, Colorado, United States
• 8: M. Kuntz , R. Melchert, Pasta-3's graphical query language: direct manipulation cooperative queries, full expressive power, Proceedings of the 15th international conference on Very large data bases, p.97-105, July 1989, Amsterdam, The Netherlands
• 9: C. Lecluse , P. Richard , F. Velez, O2, an object-oriented data model, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.424-433, June 01-03, 1988, Chicago, Illinois, United States
• 10: Andreas Christian Lemke , Gerhard Fischer, Design environments for high-functionality computer systems, 1989
• 11: LITWIN, W., AND ABDELLATIF, A. 1987. An overview of the nmltidatabase manipulation language MDSL. Proc. IEEE 75, 5, 621 631.
• 12: Daniel W. Rasmus, Integrating distributed information, BYTE, v.16 n.12, p.247-ff., Dec. 1991
• 13: SEGEV, A. 1991. Special Issue: Semantic Issues in Multi-database systems, SIGMOD Rec 20, 4.
• 14: J. Harvey Trimble, Jr. , David Chappell, A visual introduction to SQL, John Wiley & Sons, Inc., New York, NY, 1989
• 15: Michael David Williams, What makes RABBIT run?, International Journal of Man-Machine Studies, v.21 n.4, p.333-352, Oct. 1984 [doi>10.1016/S0020-7373(84)80052-8]

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages
          Subjects: Query languages

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT

General Terms:
Languages, Management

Keywords:
data models, heterogeneous databases, query languages