Skip to main content
SpringerLink
Log in

A generative approach to database federation

  • Session 10a: Integration
  • Conference paper
  • First Online:
Conceptual Modeling — ER '97 (ER 1997)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1331))

Included in the following conference series:

Abstract

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++.

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

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. J. Albert, R. Ahmed, M. Ketabchi, W. Kent, M.-C. Shan: Automatic Importation of Relational Schemas in Pegasus. In [IMS93]

    Google Scholar 

  2. R. Busse, P. Fankhauser, E. Neuhold: Federated Schemata in ODMG. Proc. of 2nd East/West Database Workshop 1994

    Google Scholar 

  3. E. Batini, M. Lenzerini, S. Navathe: A Comparative Analysis of Methodologies for Database Schema Integration. ACM Comp. Surveys 1986, 18(4)

    Google Scholar 

  4. M. Castellanos: Semantic Enrichment of Interoperable Databases. In [IMS93]

    Google Scholar 

  5. R. Cattell (ed.): The Object Database Standard: ODMG-93. 2nd edition, Morgan-Kaufmann Publishers, San Mateo (CA) 1996

    Google Scholar 

  6. R. Chiang, T. Barron, V. Storey: Reverse Engineering of Relational Databases: Extraction of an EER model from a Relational Database. Data&Knowledge Engineering 12, 1994

    Google Scholar 

  7. B. Czedjo, M. Taylor: Integration of Database Systems Using an Object-Oriented Approach. In [KRS91]

    Google Scholar 

  8. K.H. Davis, A.K. Arora: Converting a Relational Database Model into an Entity-Relationship Model. In [ERA87]

    Google Scholar 

  9. S.M. Deen, R.R. Amin, M.C. Taylor: Data Integration in Distributed Databases. IEEE Transactions on Software Engineering 13 (7), 1987

    Google Scholar 

  10. S. March (ed.): 6th Int. Conf. on Entity-Relationship Approach, 1987

    Google Scholar 

  11. 12th Int. Conf. on Entity-Relationship Approach. Karlsruhe 1993

    Google Scholar 

  12. 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), 1992

    Google Scholar 

  13. 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 1994

    Google Scholar 

  14. 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 1098

    Google Scholar 

  15. 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 1995

    Google Scholar 

  16. J.-L. Hainault, C. Tonneau, M. Joris, M. Chandelon: Schema Transformation Techniques for Database Reverse Engineering. In [ERA93]

    Google Scholar 

  17. Legacy Systems. Special Issue of IEEE Software 12(1), 1995

    Google Scholar 

  18. Proc. of Conf. on Research Issues in Data Engineering: Interoperability in Multidatabase Systems (RIDE-IMS'93). Vienna 1993

    Google Scholar 

  19. P. Johannesson: A Logical Basis for Schema Integration. In [IMS93]

    Google Scholar 

  20. 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 1990

    Google Scholar 

  21. R. Krishnamurthy, W. Litwin, W. Kent: Language Features for Interoperability of Databases with Schematic Discrepancies. In: [KRS91]

    Google Scholar 

  22. G. Kappel et al.: COMan — Coexistence of Object-Oriented and Relational Technology. In: 13th Int. Conf. on Entity-Relationship Approach

    Google Scholar 

  23. Y. Kambayashi, M. Rusinkiewicz, A. Sheth (eds.): Proc. of 1st Int. Workshop on Interoperability in Multidatabase Systems Kyoto (Japan), 1991

    Google Scholar 

  24. Q. Li, D. McLeod: An Object-Oriented Approach to Federated Databases. In [KRS91]

    Google Scholar 

  25. L. Liu, C. Pu, Y. Lee: An Adaptive Approach to Query Mediation Across Heterogeneous Databases. Proc. of Int. Conf. on Cooperative Information Systems, Brussels 1996

    Google Scholar 

  26. V. Markowitz, J. Makowsky: Identifying Extended ER Object Structures in Relational Schemas. IEEE Trans. on Software Engineering 16(8), 1990

    Google Scholar 

  27. B. Narasimhan, S. Navathe, S. Jayaraman: On Mapping ER and Relational Models into OO Schemas. In [ERA93]

    Google Scholar 

  28. E. Pitoura, O. Boukres, A. Elmagarid: Object-Orientation in Multidatabase Systems. ACM Computing Surveys 27(3), 1995

    Google Scholar 

  29. W. Premerlani, M. Blaha: An Approach for Reverse Engineering of Relational Databases. Communications of the ACM 37(5), May 1994

    Google Scholar 

  30. R. Rafii, R. Ahmed, P. DeSmedt, B. Kent, M. Ketabchi, W. Litwin: Multidatabase Management in Pegasus. In [KRS91]

    Google Scholar 

  31. E. Radeke: Efendi: Federated Database System of Cadlab. In: ACM SIGMOD Conf. on Management of Data 1995, SIGMOD RECORD 24(2)

    Google Scholar 

  32. 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 1989

    Google Scholar 

  33. M. Reddy, B. Prasad, P. Reddy, A. Gupta: A Methodology for Integration of Heterogeneous Databases. IEEE Trans. on Knowledge and Data Engineering 8(6), 1994

    Google Scholar 

  34. F. Saltor, M. Castellanos, M. Garcia-Solaco: Overcoming Schematic Discrepancies in Interoperable Databases. In [HNS92]

    Google Scholar 

  35. 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 1157

    Google Scholar 

  36. A. Sheth, J. Larson: Federated DBSs for Managing Distributed, Heterogeneous and Autonomous Databases. ACM Comp. Surveys 1990, 22(3)

    Google Scholar 

  37. 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. L.-L. Yan, T.-W. Ling: Translating Relational Schema With Constraints Into OODB Schema. In [HNS92]

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Corporate Research and Development, Siemens AG ZT AN 4, D-81730, München, Germany

    Uwe Hohenstein & Volkmar Plesser

Authors
  1. Uwe Hohenstein
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Volkmar Plesser
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

David W. Embley Robert C. Goldstein

Rights and permissions

Reprints and permissions

Copyright information

© 1997 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Hohenstein, U., Plesser, V. (1997). A generative approach to database federation. In: Embley, D.W., Goldstein, R.C. (eds) Conceptual Modeling — ER '97. ER 1997. Lecture Notes in Computer Science, vol 1331. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-63699-4_34

Download citation

  • DOI: https://doi.org/10.1007/3-540-63699-4_34

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-63699-1

  • Online ISBN: 978-3-540-69630-8

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation