IRO-DB: Making relational and Object-Oriented Database Systems Interoperable

  • Peter Fankhauser
  • Béatrice Finance
  • Wolfgang Klas
ESPRIT Projects
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1057)


The functionality of IRO-DB can be summarized as follows:
  • IRO-DB provides the ODMG interface at all product layers, i.e., at the interoperable layer, at the communication layer, and at the local layer. The benefit of using an upcoming standard is the foreseeable availability of ODMG-compliant interfaces for many commercial database management systems and as such to provide portability and reusability of applications.

  • The Integrator Workbench offers design support for the definition of the integrated views derived from local database schemas which includes resolving of the various kinds of heterogeneities between existing databases, merging of data, and code generation for the integrated views.

  • The C++/OML interface of IRO-DB transparently integrates heterogeneous database system services with the application programming language making it easy to use for application programmers.

  • IRO-DB is a complete system providing access transparency to heterogeneous databases. It provides global query processing, global transaction management, object management, remote access to the existing databases, and local database adapters providing ODMG interfaces for local database systems.

A first IRO-DB prototype has been developed. It is based on one object-oriented system MATISSE and one relational system INGRES. ONTOS has been selected for this first prototype as the Home OODBMS. In the second phase of the project Local Database Adapters will be developed on top of other OODBMS such as O2 and ONTOS.


Local Schema Local Database Integrate View Heterogeneous Database Federate Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Cattell R., “Object Databases:The ODMG-93 Standard”, Book, Morgan &Kaufman, 1993.Google Scholar
  2. [2]
    Fankhauser P., M. Kracker, E. Neuhold, “Semantic vs. Structural Resemblance of Classes”, Special SIGMOD Record, issue on semantic issues in Multibase Systems, Vol. 20, n∘4, ACM Press, 1991.Google Scholar
  3. [3]
    Gardarin G. and al., “IRO-DB: A Distributed System Federating Object and Relational Databases”, Object-oriented Multibase Systems, O. Bukhres and A. Elmagarmid Ed., Prentice Hall, 1995.Google Scholar
  4. [4]
    Object Management Group, “Object Services Architecture”, OMG document N∘ 92.8.4, OMG Ed., Framingham, USA, August 1992.Google Scholar
  5. [5]
    Sheth A.P., Larson J.A., “Federated Database Systems for Managing Distributed, Heterogeneous and Autonomous Databases”, ACM computing surveys, vol (22):3, 1990.Google Scholar
  6. [6]
    “Data Management: SQL Call Level Interface (CLI), Snapshot, X/Open with SQL Access Group, X/Open Company Ltd.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1996

Authors and Affiliations

  • Peter Fankhauser
    • 1
  • Béatrice Finance
    • 2
  • Wolfgang Klas
    • 1
  1. 1.Integrated Publication and Information Systems InstituteGMD-IPSIDarmstadtGermany
  2. 2.Laboratoire PRiSMUniversité de VersaillesVersaillesFrance

Personalised recommendations