Distributed and Parallel Databases

, Volume 2, Issue 4, pp 343–370 | Cite as

Applications of object-oriented technology to the integration of heterogeneous database systems

  • E. Bertino
  • M. Negri
  • G. Pelagatti
  • L. Sbattella


The object-oriented paradigm has several features that facilitate the integration of heterogeneous data management systems. One of the main problems in the integration is to provide users with the same data model and language to access very different systems. This problem exists in all kinds of distributed heterogeneous data management systems, independently from their integration architecture (like classical distributed databases, federated databases, multidatabases). This paper shows that the use of an object-oriented data model for building a “uniform” view of several databases can greatly simplify this task, and actually extends the scope of integration towards two directions. The first concerns the integration of data management systems to which traditional integration techniques, based on mappings among data models, cannot be applied. The second direction moves the goal of integration to re-using not only data but to re-using data and application software using these data. In the paper we also briefly discuss some requirements for an object-oriented integrated platform.


Object-oriented data model heterogeneous databases query languages data models distributed systems interoperability architectures non-traditional applications software re-usability 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Ahmed, R. et al., “The Pegasus heterogeneous multidatabase system”,Computer, Vol. 24, No. 12, December 1991, pp. 12–18.Google Scholar
  2. 2.
    Ahmed, R. et Al. “An overview of Pegasus”,Proc. of IEEE Symposium on Research Issues in Data Engineering - Interoperability among Multidatabase Systems (RIDE-IMS), Vienna (Austria), April 19–20. 1993, IEEE Computer Society Press.Google Scholar
  3. 3.
    America, P., “A parallel object-oriented language with inheritance and subtyping”,Proc. of International Conference on Object-Oriented Programming Systems, Languages, and Applications (OOPSLA), and European Conference on Object-Oriented Programming (ECOOP), Ottawa, Canada, October 1990.Google Scholar
  4. 4.
    Atkinson, M., Bancilhon, F., DeWitt, D., Dittrich., K., Maier, D., Zdonik, S., “The object-oriented database system manifesto,”Proceedings of the First International Conference on Deductive and Object-Oriented Databases, Kyoto (Japan), Dec. 4–6, 1989.Google Scholar
  5. 5.
    Batini, C., Lenzerini, M., Navathe, S.B., “A comparative analysis of methodologies for DB schema integration,”ACM Comput. Surveys, Vol. 4, No. 2, 1986.Google Scholar
  6. 6.
    Bertino, E., Negri, M., Pelagatti, G., Sbattella, L., “Integration of heterogeneous database applications through an object-oriented interface,”Information Systems (Pergamon Press), Vol. 14, No. 5, 1989.Google Scholar
  7. 7.
    Bertino, E., Martino, L., “Object-oriented database management systems: concepts and issues,”Computer (IEEE Computer Society), Vol. 24, No. 4, 1991.Google Scholar
  8. 8.
    Bertino, E., “Integration of heterogeneous data repositories using object-oriented views,”Proc. First International Workshop on Interoperability in Multidatabase Systems, Kyoto (Japan), April 8–9, 1991.Google Scholar
  9. 9.
    Bertino, E., Negri, M., Pelagatti, G., Sbattella, L. Object-oriented query languages: the notion and the issues.IEEE Trans. on Knowledge and Data Engineering, Vol. 4, No. 3 June 1992.Google Scholar
  10. 10.
    Bertino, E., Damiani, M., Randi, P., “An approach to integrate multimedia data in a knowledge representation system,”Proc. International Workshop on Advanced Visual Interfaces, Rome (Italy), May 27–29, 1992.Google Scholar
  11. 11.
    Bertino, E. et Al., “A knowledge based information system,”Proc. of 12th IFIP World Computer Congress, Madrid (Spain), September 7–11, 1992.Google Scholar
  12. 12.
    Bertino, E., Martino, L.,Object-Oriented Database Systems — Concepts and Architectures, Addison-Wesley, 1993.Google Scholar
  13. 13.
    Black, A., et. Al., “Distribution and abstract types in Emerald,”IEEE Trans. on Software Engineering, Vol. SE-13, No. 1, 1987.Google Scholar
  14. 14.
    Connors, T., and Lyngbaek, P., “Providing uniform access to heterogeneous information bases,”Advances in Object-Oriented Database Systems, (K.R. Dittrich, ed.), Proc. Second Intl. Workshop on Object-Oriented Database Systems, Bad Munster am Stein-Ebernburg (Germany), Sept. 27–30, Lecture Notes in Computer Science 334, Springer-Verlag.Google Scholar
  15. 15.
    Czejdo, B., and Taylor, M.C., “Integration of database systems using an object-oriented approach,”Proc. First International Workshop on Interoperability in Multidatabase Systems, Kyoto (Japan), April 8–9, 1991.Google Scholar
  16. 16.
    Object Management Group,The Common Object Request Broker: Architecture and Specification, OMG Document Number 91.12.1, December 1991.Google Scholar
  17. 17.
    Elmagarmid, A., and Pu, C., eds., Special issue on heterogeneous databases.ACM Comp. Surveys, Vol. 22, No. 3, Sept. 1990.Google Scholar
  18. 18.
    Gallagher, L., “Object SQL: language extensions for object data management”,Proc, of First International Conference on Information and Knowledge Management, Baltimore (MD), November 8–11, 1992.Google Scholar
  19. 19.
    Goldberg, A., and Robson, D.,Smalltalk-80: the language and its implementation, Addison-Wesley, 1983.Google Scholar
  20. 20.
    Software Engineering Systems Division, Hewlett-Packard Company, “CASEdge: a new architecture for software tool integration,” 1989. Presented at the AICA Workshop onComunicazione fra le Applicazioni, Milano, Feb.15, 1991.Google Scholar
  21. 21.
    Kim, W., and Seo, J., “Classifying schematic and data heterogeneity in multidatabase systems”,IEEE Computer, Vol. 24, No. 12, pp. 12–17, Dec. 1991.Google Scholar
  22. 22.
    Korston, T., and McGregor, J.D., “Understanding object-oriented: a unifying paradigm,”ACM Comm., Vol. 33, No. 9, pp.40–60, Sept. 1990.Google Scholar
  23. 23.
    Litwin, W., Adbellatif, A., “Multidatabase interoperability,”Computer (IEEE Computer Society), 1986.Google Scholar
  24. 24.
    Manola, F., “Applications of object-oriented database technology in knowledge-based integration of integrated information systems”,Proc. of CRAI School on Recent Techniques for Integrating Heterogeneous Databases, Venezia University (Italy), April 10–14, 1989.Google Scholar
  25. 25.
    Mayer, B.,Object-oriented software construction, Prentice-Hall, 1988.Google Scholar
  26. 26.
    Moon, D.A., “The COMMON LISP object-oriented programming language,” InObject-Oriented Concepts, Databases, and Applications, (W. Kim, F. Lochovsky, eds.), pp.49–78, Addison-Wesley, Reading (Mass.), 1989.Google Scholar
  27. 27.
    Motro, A., “Superviews: virtual integration of multiple databases,”IEEE Trans. on Software Engineering, Vol. SE-13, No. 7, July 1987, pp. 785–798.Google Scholar
  28. 28.
    Seo, J., et Seo Al., “Classifying schematic and data heterogeneity in multidatabase systems”,Computer, Vol. 24, No. 12, December 1991, pp. 12–18.Google Scholar
  29. 29.
    Soley, R.M., “Using object technology to integrate distributed applications”,Proc. of the First International Conference on Enterprise Integration Modeling (ICEIMT), Austin (TX), Feb. 17–21, 1993, MIT Press.Google Scholar
  30. 30.
    Snyder, A., Hill, W., Olthoff, W., “A glossary of common object-oriented terminology,” Hewlett-Packard Laboratories, Report STL-89-26, 22 September 1989.Google Scholar
  31. 31.
    Sventek, J., “The distributed application architecture”,Proc. of the First International Conference on Enterprise Integration Modeling (ICEIMT), Austin (TX), Feb.17–21, 1993, MIT Press.Google Scholar
  32. 32.
    Wirfs-Brock, R., and Johnson, R.E., “Surveying current research in object-oriented design,”ACM Comm., Vol. 33, No. 9, pp. 105–124, Sept. 1990.Google Scholar

Copyright information

© Kluwer Academic Publishers 1994

Authors and Affiliations

  • E. Bertino
    • 1
  • M. Negri
    • 2
  • G. Pelagatti
    • 2
  • L. Sbattella
    • 2
  1. 1.Dipartimento di Scienze dell'InformazioneUniversità di MilanoMilanoItaly
  2. 2.Dipartimento di Elettronica e InformaticaPolitecnico di MilanoMilanoItaly

Personalised recommendations