A generative approach to database federation

  • Uwe Hohenstein
  • Volkmar Plesser
Session 10a: Integration
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1331)


This paper introduces a comprehensive, specification-based approach to database federation, supporting an integrated ODMG-93 conforming access to object-oriented and relational databases. Central point is a set of intuitive specification languages. These languages allow defining ODMG-93 views of existing databases, and building system spanning federated views thereupon. Given concrete specifications defining those views, ODMG schemas are generated automatically due to a generative approach. Heterogeneous databases can be plugged into a federation without implementing adapters for any schema again and again. The generative nature provides flexibility wrt. schema modification of component databases, as new views are implemented automatically. Furthermore, the approach is one of the first to support manipulating federated data seamlessly in C++.


Relational Database Specification Language Object Type Homogenize Schema Semantic Enrichment 
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. [AAK+93]
    J. Albert, R. Ahmed, M. Ketabchi, W. Kent, M.-C. Shan: Automatic Importation of Relational Schemas in Pegasus. In [IMS93]Google Scholar
  2. [BFN94]
    R. Busse, P. Fankhauser, E. Neuhold: Federated Schemata in ODMG. Proc. of 2nd East/West Database Workshop 1994Google Scholar
  3. [BLN86]
    E. Batini, M. Lenzerini, S. Navathe: A Comparative Analysis of Methodologies for Database Schema Integration. ACM Comp. Surveys 1986, 18(4)Google Scholar
  4. [Cas93]
    M. Castellanos: Semantic Enrichment of Interoperable Databases. In [IMS93]Google Scholar
  5. [Cat96]
    R. Cattell (ed.): The Object Database Standard: ODMG-93. 2nd edition, Morgan-Kaufmann Publishers, San Mateo (CA) 1996Google Scholar
  6. [CBS94]
    R. Chiang, T. Barron, V. Storey: Reverse Engineering of Relational Databases: Extraction of an EER model from a Relational Database. Data&Knowledge Engineering 12, 1994Google Scholar
  7. [CzT91]
    B. Czedjo, M. Taylor: Integration of Database Systems Using an Object-Oriented Approach. In [KRS91]Google Scholar
  8. [DaA87]
    K.H. Davis, A.K. Arora: Converting a Relational Database Model into an Entity-Relationship Model. In [ERA87]Google Scholar
  9. [DAT87]
    S.M. Deen, R.R. Amin, M.C. Taylor: Data Integration in Distributed Databases. IEEE Transactions on Software Engineering 13 (7), 1987Google Scholar
  10. [ERA87]
    S. March (ed.): 6th Int. Conf. on Entity-Relationship Approach, 1987Google Scholar
  11. [ERA93]
    12th Int. Conf. on Entity-Relationship Approach. Karlsruhe 1993Google Scholar
  12. [HNS92]
    D.K. Hsia, E.J. Neuhold, R. Sacks-Davis (eds.): Proc. of the IFIP WG 2.6 Database Semantics Conf. (DS-5) on Interoperable Database Systems, Lorne (Australia), 1992Google Scholar
  13. [HFBK94]
    G. Huck, P. Fankhauser, R. Busse, W. Klas: IRO-DB: An Object-Oriented Approach towards Federated and Interoperable DBMS. In: Advances in Databases and Information Systems (ADBIS'94), Moscow 1994Google Scholar
  14. [Hoh96]
    U. Hohenstein: Bridging the Gap Between C++ and Relational Databases. In: Proc. of 10th European Conf. on Object-Oriented Programming (ECOOP'96), Linz (Austria) 1996, Springer LNCS 1098Google Scholar
  15. [HoK95]
    U. Hohenstein, C. Körner: A Graphical Tool for Specifying Semantic Enrichment of Relational Databases. In: 6th IFIP WG 2.6 Work. Group on Data Semantics (DS-6) “Database Applications Semantics”, Atlanta 1995Google Scholar
  16. [HTJC93]
    J.-L. Hainault, C. Tonneau, M. Joris, M. Chandelon: Schema Transformation Techniques for Database Reverse Engineering. In [ERA93]Google Scholar
  17. [IEEE95]
    Legacy Systems. Special Issue of IEEE Software 12(1), 1995Google Scholar
  18. [IMS93]
    Proc. of Conf. on Research Issues in Data Engineering: Interoperability in Multidatabase Systems (RIDE-IMS'93). Vienna 1993Google Scholar
  19. [Joh93]
    P. Johannesson: A Logical Basis for Schema Integration. In [IMS93]Google Scholar
  20. [KDN90]
    M. Kaul, K. Drosten, E. Neuhold: ViewSystem: Integrating Heterogeneous Information Bases by Object-Oriented Views. In: Proc. 6th Int. Conf. on Data Engineering, Los Angeles 1990Google Scholar
  21. [KLK91]
    R. Krishnamurthy, W. Litwin, W. Kent: Language Features for Interoperability of Databases with Schematic Discrepancies. In: [KRS91]Google Scholar
  22. [Kap+94]
    G. Kappel et al.: COMan — Coexistence of Object-Oriented and Relational Technology. In: 13th Int. Conf. on Entity-Relationship ApproachGoogle Scholar
  23. [KRS91]
    Y. Kambayashi, M. Rusinkiewicz, A. Sheth (eds.): Proc. of 1st Int. Workshop on Interoperability in Multidatabase Systems Kyoto (Japan), 1991Google Scholar
  24. [LiM91]
    Q. Li, D. McLeod: An Object-Oriented Approach to Federated Databases. In [KRS91]Google Scholar
  25. [LPL96]
    L. Liu, C. Pu, Y. Lee: An Adaptive Approach to Query Mediation Across Heterogeneous Databases. Proc. of Int. Conf. on Cooperative Information Systems, Brussels 1996Google Scholar
  26. [MaM90]
    V. Markowitz, J. Makowsky: Identifying Extended ER Object Structures in Relational Schemas. IEEE Trans. on Software Engineering 16(8), 1990Google Scholar
  27. [NNJ93]
    B. Narasimhan, S. Navathe, S. Jayaraman: On Mapping ER and Relational Models into OO Schemas. In [ERA93]Google Scholar
  28. [PBT95]
    E. Pitoura, O. Boukres, A. Elmagarid: Object-Orientation in Multidatabase Systems. ACM Computing Surveys 27(3), 1995Google Scholar
  29. [PrB94]
    W. Premerlani, M. Blaha: An Approach for Reverse Engineering of Relational Databases. Communications of the ACM 37(5), May 1994Google Scholar
  30. [RAD+91]
    R. Rafii, R. Ahmed, P. DeSmedt, B. Kent, M. Ketabchi, W. Litwin: Multidatabase Management in Pegasus. In [KRS91]Google Scholar
  31. [Rad95]
    E. Radeke: Efendi: Federated Database System of Cadlab. In: ACM SIGMOD Conf. on Management of Data 1995, SIGMOD RECORD 24(2)Google Scholar
  32. [REC+89]
    M. Rusinkiewicz, R. ElMasri, B. Czejdo, et. al: OMNIBASE. Design and Implementation of a Multidatabase System. In: Proc. of 1st Annual Symp. in Parallel and Distributed Processing, Dallas 1989Google Scholar
  33. [RPRG94]
    M. Reddy, B. Prasad, P. Reddy, A. Gupta: A Methodology for Integration of Heterogeneous Databases. IEEE Trans. on Knowledge and Data Engineering 8(6), 1994Google Scholar
  34. [SCG92]
    F. Saltor, M. Castellanos, M. Garcia-Solaco: Overcoming Schematic Discrepancies in Interoperable Databases. In [HNS92]Google Scholar
  35. [ScS96]
    I. Schmitt, G. Saake: Integrating of Inheritance Trees as Part of View Generation for Database Federations. In: 15th Int. Conf. on Conceptual Modeling (ER'96), Cottbus 1996, Springer LNCS 1157Google Scholar
  36. [ShL90]
    A. Sheth, J. Larson: Federated DBSs for Managing Distributed, Heterogeneous and Autonomous Databases. ACM Comp. Surveys 1990, 22(3)Google Scholar
  37. [SpP94]
    S. Spaccapietra, C. Parent: View Integration. A Step Forward in Solving Structural Conflicts. IEEE Trans. on Knowledge & Data Engin. 1994, 6(2)Google Scholar
  38. [YaL92]
    L.-L. Yan, T.-W. Ling: Translating Relational Schema With Constraints Into OODB Schema. In [HNS92]Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1997

Authors and Affiliations

  • Uwe Hohenstein
    • 1
  • Volkmar Plesser
    • 1
  1. 1.Corporate Research and DevelopmentMünchenGermany

Personalised recommendations