Skip to main content
SpringerLink
Log in
Book cover

International Conference on Conceptual Modeling

ER 2000: Conceptual Modeling — ER 2000 pp 440–453Cite as

Algebraic Database Migration to Object Technology

  • Conference paper
  • First Online:

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

Abstract

Relational database systems represent the current standard technology for implementing database applications. Now that the object-oriented paradigm becomes more and more mature in all phases of the software engineering process, object-oriented DBMS are seriously considered for the seamless integration of object-oriented applications and data persistence. However, when reengineering existing applications or constructing new ones on top of relational databases, a large semantic gap between the new object model and the legacy database’s model must be bridged. We propose database migration to resolve this mismatch: the relational schema is transformed into an object-oriented one and the relational data is migrated to an object-oriented database. Existing approaches for migration do not exploit the full potential of the object-oriented paradigm so that the resulting object-oriented schema still “looks rather relational” and retains the drawbacks and weaknesses of the relational schema. We propose a redesign environment which allows to transform relational schemas into adequate object-oriented ones. Schemas and transformation rules are expressed in terms of a new data model, called semi object types (SOT). We also propose a formal foundation for SOT and transformation rules. This formalization makes it possible to automatically generate the data migration process.

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

Chapter
USD   29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD   84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. S. Amer-Yahia, S. Cluet, and C. Delobel. Bulk loading techniques for object databases and an application to relational data. Proc. Int’l Conf. on Very Large Databases (VLDB), New York, August 1998.

    Google Scholar 

  2. C. Batini, S. Ceri, and S. Navathe. Conceptual database design: an entity-relationship approach. Benjamin/Cummings Publishing Company, Inc., 1992.

    Google Scholar 

  3. C. Beeri. Query languages for models with object-oriented features. In Advances in Object-Oriented Database Systems, NATO ASI Series, chapter 3. Springer-Verlag, 1994.

    Google Scholar 

  4. C. Beeri and Y. Kornatzky. Algebraic optimization of object-oriented query languages. Proc. 3rd Int’l Conf. on Database Theory, Paris, France, December 1990.

    Google Scholar 

  5. A. Behm. Migrating relational databases to object technology. PhD thesis (forthcoming), University of Zurich, Switzerland, 2000.

    Google Scholar 

  6. A. Behm, A. Geppert, and K. R. Dittrich. On the migration of relational schemas and data to object-oriented database systems. Proc. 5th Int’l Conf. on Re-Technologies for Information Systems, Klagenfurt, Austria, December 1997.

    Google Scholar 

  7. M. Blaha and W. Premerlani. A catalog of object model transformations. Proc. 3rd Working Conf. on Reverse Engineering, Monterey, California, November 1996.

    Google Scholar 

  8. M. Blaha and W. Premerlani. Detailed design. In Object-Oriented Modeling and Design for Database Applications, chapter 10. Prentice-Hall, 1998.

    Google Scholar 

  9. G. Booch. Object-Oriented Analysis and Design with Applications. Benjamin/Cummings, 1994.

    Google Scholar 

  10. R. G. G. Cattell. The object data standard: ODMG 3.0. Morgan Kaufmann, 2000.

    Google Scholar 

  11. S. Cluet and C. Delobel. A general framework for the optimization of object-oriented queries. Proc. SIGMOD Int’l Conf. on Management of Data, New York, June 1992.

    Google Scholar 

  12. S. Cluet and G. Moerkotte. Classification and optimization of nested queries in object bases. In Bases de Donnees Avancees, 1994.

    Google Scholar 

  13. J. Fong. Converting relational to object-oriented databases. SIGMOD Record, 26(1), 1997.

    Google Scholar 

  14. A. Geppert, K. R. Dittrich, V. Goebel, and S. Scherrer. The NO2 data model. Technical Report 93.09, Institut fuer Informatik der Universität Zürich, 1993.

    Google Scholar 

  15. J-L. Hainaut, C. Tonneau, M. Joris, and M. Chandelon. Transformation-based Database Reverse Engineering. Proc. 12th Int. Conf. on the ER Approach, Dallas, December 1993.

    Google Scholar 

  16. R. J. Miller, Y. E. Ioannidis, and R. Ramakrishnan. The use of information capacity in schema integration and translation. Proc. 19th VLDB Conf., Dublin, Ireland, 1993.

    Google Scholar 

  17. G. Mitchell, S.B. Zdonik, and U. Dayal. Optimizations of object-oriented query languages: Problems and approaches. In Advances in Object-Oriented Database Systems, NATO ASI Series, chapter 6, Springer-Verlag, 1994.

    Google Scholar 

  18. G. M. Shaw and S. B. Zdonik. A query algebra for object-oriented databases. Proc. Int’l Conf. on Data Engineering, Los Angeles, CA, February 1990.

    Google Scholar 

  19. S. L. Vandenberg and D. J. DeWitt. Algebraic support for complex objects with arrays, identity, and inheritance. In Proceedings of the ACM SIGMOD, May 1991

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Database Technology Research Group Department of Information Technology, University of Zurich, Winterthurerstr. 190, CH-8057, Zurich, Switzerland

    Andreas Behm, Andreas Geppert & Klaus R. Dittrich

Authors
  1. Andreas Behm
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Andreas Geppert
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Klaus R. Dittrich
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Departamento de Ciência da Computação, Universidade Federal de Minas Gerais, 31270-010, Belo Horizonte - MG, Brasil

    Alberto H. F. Laender

  2. Marriott School School of Accountancy and Information Systems, Brigham Young University, 585 TNRB, P.O. Box 23087, UT 84602-3087, Provo, USA

    Stephen W. Liddle

  3. Department of Computer Information Systems, Georgia State University, College of Business Administration, 30302-4015, Atlanta, Georgia, USA

    Veda C. Storey

Rights and permissions

Reprints and permissions

Copyright information

© 2000 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Behm, A., Geppert, A., Dittrich, K.R. (2000). Algebraic Database Migration to Object Technology. In: Laender, A.H.F., Liddle, S.W., Storey, V.C. (eds) Conceptual Modeling — ER 2000. ER 2000. Lecture Notes in Computer Science, vol 1920. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45393-8_32

Download citation

  • DOI: https://doi.org/10.1007/3-540-45393-8_32

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-41072-0

  • Online ISBN: 978-3-540-45393-2

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation