Skip to main content
SpringerLink
Log in

Managing schema changes in object-relationship databases

  • Reverse Engineering and Schema Transformation I
  • Conference paper
  • First Online:
OOER '95: Object-Oriented and Entity-Relationship Modeling (ER 1995)

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

Included in the following conference series:

  • 151 Accesses

Abstract

Changing a database schema may affect existing data and application programs. Immediate data restructuring is a first usual strategy that transforms the existing database to render it conform to the modified schema, but it does not deal with program adaptation to the changes. An other approach allows the existence of several schema versions for a single database: emulation mechanisms are then used to achieve program adaptation but they cannot avoid data redundancy. Furthermore, both the approaches only considered atomic schema changes. This paper proposes a combination of both the approaches: several facets of the database are virtually maintained: every facet represents the database in conformance to a schema version and only one “reference facet” may be physically stored. Mapping functions among the facets are also maintained: they deliver data items (to a user or to an application program) according to their definitions in a given version of the database schema.

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. Jose Andany, Michel Leonard, and Carole Palisser. Management of schema evolution in databases. In 17th International Conference on Very Large Data Bases (VLDB), 1991.

    Google Scholar 

  2. Gad Ariav. Temporally oriented data definitions: managing schema evolution in temporally oriented databases. Data and Knowledge Engineering, 6:451–467, 1991.

    Google Scholar 

  3. J. Banerjee, H.-T. Chou, H.J. Kim, and H.F. Korth. Semantics and implementation of schema evolution in object-oriented databases. ACM SIGMOD conference, SIGMOD Record, 16(3):311–322, 1987.

    Google Scholar 

  4. Philip A. Bernstein. Database system support for software engineering-an extended abstract-. In 9th Internat. Conf. on Software Engineering, pages 166–178, 1987.

    Google Scholar 

  5. Nacer Boudjlida and Olivier Perrin. A formal framework and a procedural approach for data interchange. In Third Int. Conf. on Systems Integration, pages 476–485, Sao Paulo, Brazil, August 1994.

    Google Scholar 

  6. M. Bouneffa. Gestion des Objects Complexes: Modélisation, Intégration et Evolution. PhD thesis, Université Henri Poincaré (Nancy I), May 1995.

    Google Scholar 

  7. W. Kim and H.-T. Chou. Versions of schema for object-oriented databases. In F. Bancilhon and D.J. DeWitt, editors, ACM SIGMOD Int. Conf. Very Large DataBases, pages 148–59, Los Angeles, CA, 1988.

    Google Scholar 

  8. J.A. Larson, S.B. Navathe, and R. Elmasri. A theory of attribute equivalence in databases with application to schema integration. IEEE transactions On Software Engineering, SE-15(4), 1989.

    Google Scholar 

  9. E. McKenzie and R. Snodgrass. Schema evolution and the relational algebra. Information Systems, 15(2):207–232, 1990.

    Google Scholar 

  10. G.T Nguyen and D. Rieu. Schema evolution in object-oriented database systems. Data and Knowledge Engineering, 4(1):43–67, 1989.

    Google Scholar 

  11. S.L. Osborn. The role of polymorphism in schema evolution in an object-oriented database. IEEE Transactions on Knowledge and Data Engineering, 1(3):310–317, 1989.

    Google Scholar 

  12. D.J. Penney and J. Stein. Class modification in the gemstone object-oriented dbms. SIGPLAN Notices (Proc. OOPSLA '87), 22(12):111–117, 1987.

    Google Scholar 

  13. Amit Sheth and Vipul Kashyap. Sofar (schematically) yet so near (semantically). In D.K. Hsiao et al., editor, Interoperable Database Systems, IFIP Transactions A-25. North-Holland, 1993.

    Google Scholar 

  14. Andrea H. Skarra and Stanley B. Zdonik. Type evolution in an object-oriented database, volume Research directions in object-oriented programming, pages 393–416. B. Shriver, Cambridge, MA, mit press edition, 1987.

    Google Scholar 

  15. Christian Thieme and Arno Siebes. Schema integration in object-oriented databses. In Proc. of CAISE 93, LNCS 685, June 1993.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Centre de Recherche en Informatique de Nancy (CRIN-CNRS), Campus scientifique, B.P. 239, 54506, Vandoeuvre-lès-Nancy

    Mohamed Bouneffa & Nacer Boudjlida

Authors
  1. Mohamed Bouneffa
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Nacer Boudjlida
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Michael P. Papazoglou

Rights and permissions

Reprints and permissions

Copyright information

© 1995 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Bouneffa, M., Boudjlida, N. (1995). Managing schema changes in object-relationship databases. In: Papazoglou, M.P. (eds) OOER '95: Object-Oriented and Entity-Relationship Modeling. ER 1995. Lecture Notes in Computer Science, vol 1021. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0020525

Download citation

  • DOI: https://doi.org/10.1007/BFb0020525

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-60672-7

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

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation