Skip to main content
SpringerLink
Log in

An interface between object-oriented databases and relational databases

  • Published:
Journal of Systems Integration

Abstract

Currently relational databases are widely used, while object-oriented databases are emerging as a new generation of database technology. This paper presents a methodology to provide effective sharing of information in object-oriented databases and relational databases. The object-oriented data model is selected as a common data model to build an integrated view of the diverse databases. An object-oriented query language is used as a standard query language. A method is developed to transform a relational data definition to an equivalent object-oriented data definition and to integrate local data definitions. Two distributed query processing methods are derived. One is for general queries and the other for a special class of restricted queries. Using the methods developed, it is possible to access distributed object-oriented databases and relational databases such that the locations and the structural differences of the databases are transparent to users.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. R. Amed et al., “The Pegasus heterogeneous multidatabase system”.Computer 24(12), pp. 19–27, Dec. 1991.

    Article  Google Scholar 

  2. M. Atkinson et al., “The object-oriented database system manifesto,” inProc. of the First International Conference on Deductive and Object-Oriented Databases, Kyoto, Japan, pp. 40–57, 1989.

  3. J. Banerjee et al. “Data model issues for object-oriented applications.”ACM Trans. Office Inform. Syst. 5(1), pp. 3–26, Jan. 1987.

    Article  Google Scholar 

  4. E. Bertino and L. Martino, “Object-oriented database management systems: concepts and issues”,Computer 24(4), pp. 33–47, Apr. 1991.

    Article  Google Scholar 

  5. E. Bertino et al., “Integration of heterogeneous applications through an object-oriented interface”.Information Systems 14(5), pp. 407–420, 1989.

    Article  Google Scholar 

  6. B. Bobrow and M. Stefik,The LOOPS Manual, Xerox PARC, Palo Alto, Calif., 1983.

    Google Scholar 

  7. O. Bukhres et al., “Interbase: an execution environment for heterogeneous software systems”.Computer 26(8), pp. 57–69, Aug. 1993.

    Article  Google Scholar 

  8. C. Chung, “DATAPLEX: An access to heterogeneous distributed databases”.Commun. ACM 33(1), pp. 70–80, Jan. 1990. (Corrigendum 33(4), p. 459, Apr. 1990).

    Article  Google Scholar 

  9. C. Chung and K. McCloskey, “A DATAPLEX prototype: an interface between two heterogeneous distributed databases,” Research Report CS-545, General Motors Research Laboratories, Jul. 1987.

  10. C. Chung and K. Irani, “An optimization of queries in distributed database systems,”J. Parall. Distrib. Comput. 3 (2), pp. 137–157, June 1986.

    Article  Google Scholar 

  11. S. Cluet et al., “RELOOP, an algebra based query language for an object-oriented database management system”.Data & Knowledge Engineering 5(4), pp. 333–351, Oct. 1990.

    Google Scholar 

  12. C. Date,An Introduction to Database Systems, 4th Ed., vol. 1. Addison-Wesley, Reading, Mass., 1986.

    Google Scholar 

  13. O. Deux et al., “The O2 system”,Commun. ACM 34(10), pp. 34–48, Oct. 1991.

    Article  Google Scholar 

  14. A. Hurson, S. Pakzad, and J. Cheng, “Object-oriented database management systems: evolution and performance issues”,Computer 26(2), pp. 48–60, Feb. 1993.

    Article  Google Scholar 

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

  16. T. Landers and R. Rosenberg, “An overview of Multibase”.Distributed Databases, North-Holland, pp. 153–184, 1982.

  17. C. Lecluse and R. Richard, “Modeling complex structure in object-oriented databases”, inProc. of the 9th ACM Conference on Principles of Database Systems, Philadelphia, Pennsylvania, pp. 360–368, 1989.

  18. W. Litwin, L. Mark, and N. Roussopoulos, “Interoperability of multiple autonomous databases”.ACM Comput. Surv. 22(3), pp. 267–293, Sep. 1990.

    Article  Google Scholar 

  19. M. Rusinkiewicz, “Heterogeneous databases: Towards a federation of autonomous systems”. inProc. of the Fall Joint Computer Conference, Dallas, Tex., pp. 751–752, Oct. 1987.

  20. J. Schmolze and T. Lipkis, “Classification in the KL-ONE knowledge representation system,” inProc. of the 8th International Joint Conference on Artificial Intelligence, Karlsruhe, Germany, pp. 330–332, 1983.

  21. B. Shriver and B. Wegner (Ed.),Research Directions in Object-Oriented Programming. The MIT Press, Cambridge, Mass., 1987.

    Google Scholar 

  22. M. Templeton et al., “Mermaid: A front-end to distributed heterogeneous databases” inProc. of the IEEE 75(5), pp. 695–708, May 1987.

  23. G. Thomas et al., “Heterogeneous distributed database systems for production use”.ACM Comput. Surv. 22(3), pp. 237–266, Sep. 1990.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Information and Communication Engineering, Korea Advanced Institute of Science and Technology, 130-650, Seoul, Korea

    Chin-Wan Chung

Authors
  1. Chin-Wan Chung
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints and permissions

About this article

Cite this article

Chung, CW. An interface between object-oriented databases and relational databases. Journal of Systems Integration 5, 253–274 (1995). https://doi.org/10.1007/BF01974951

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1007/BF01974951

Keywords

Search

Navigation