Skip to main content
SpringerLink
Log in

Schema Evolution in SQL-99 and Commercial (Object-)Relational DBMS

  • Conference paper
  • First Online:
Database Schema Evolution and Meta-Modeling (DEMM 2000, FoMLaDO 2000)

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

Abstract

A database schema denotes the description of the structure and behavior of a database. Straightforwardly, (database) schema evolution refers to changes of the database schema that occur during the lifetime of the corresponding database. It particularly refers to changes of schema elements already stored in the database.

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

Access this chapter

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 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. E. Amiel, M.-J. Bellosta, E. Dujardin, and E. Simon. Supporting Exceptions to Behavioral Schema Consistency to Ease Schema Evolution in OODBMS. In J. B. Bocca, Matthias Jarke, and C. Zaniolo, editors, Proc. of the 20th Int. Conf. on Very Large Data Bases, VLDB’94, Santiago, Chile, September 12–15, 1994, pages 108–119. Morgan Kaufmann Publishers, San Francisco, CA, 1994.

    Google Scholar 

  2. Z. Bellahsene. A View Mechanism for Schema Evolution in Object-Oriented DBMS. In R. Morrison and J. B. Keane, editors, Advances in Databases: 14th British National Conf. on Databases, BNCOD 14, Edinburgh, UK, July 1996, Lecture Notes in Computer Science, Vol. 1094, pages 18–34. Springer-Verlag, Berlin, 1996.

    Google Scholar 

  3. J. Banerjee, W. Kim, H.-J. Kim, and H. F. Korth. Semantics and Implementation of Schema Evolution in Object-Oriented Databases. In U. Dayal and I. Traiger, editors, Proc. of the 1987 ACM SIGMOD Int. Conf. on Management of Data, San Franscisco, CA, ACM SIGMOD Record, Vol. 16, No. 3, pages 311–322, ACM Press, 1987.

    Google Scholar 

  4. S. E. Bratsberg. Evolution and Integration of Classes in Object-Oriented Databases. Dissertation, The Norwegian Institute of Technology, University of Trondheim, June 1993.

    Google Scholar 

  5. F. Ferrandina, T. Meyer, R. Zicari, G. Ferran, and J. Madec. Schema and Database Evolution in the O2 Object Database System. In U. Dayal, P. M. D. Gray, and S. Nishio, editors, Proc. of the 21st Int. Conf. on Very Large Data Bases, VLDB’95, Zurich, Switzerland, September 11–15, 1995, pages 170–182. Morgan Kaufmann Publishers, San Francisco, CA, 1995.

    Google Scholar 

  6. S. Guo, W. Sun, and M. A. Weiss. On Satisfiability, Equivalence, and Implication Problems Involving Conjunctive Queries in Database Systems. IEEE Transactions on Knowledge and Data Engineering, 8(4):604–616, August 1996.

    Article  Google Scholar 

  7. S. Guo, W. Sun, and M. A. Weiss. Solving Satisfiability and Implication Problems in Database Systems. ACM Transactions on Database Systems, 21(2):270–293, June 1996.

    Article  Google Scholar 

  8. IBM Corporation. IBM DB2 Universal Database: SQL Reference, Version 7, 2000.

    Google Scholar 

  9. Informix Corporation, Menlo Park, CA. Informix Guide to SQL: Syntax, Informix Dynamic Server.2000, Version 9.2, December 1999.

    Google Scholar 

  10. Ingres Corporation. Ingres Database Administrator’s Guide, Version II, 1999.

    Google Scholar 

  11. International Organization for Standardization (ISO) & American National Standards Institute (ANSI), ANSI/ISO/IEC 9075-2:99. ISO International Standard: Database Language SQL-Part 2: Foundation (SQL/Foundation), September 1999.

    Google Scholar 

  12. Microsoft Corporation. Microsoft SQL Server, Version 7.0, 1999.

    Google Scholar 

  13. G. T. Nguyen. Schema Evolution in Object-Oriented Database Systems. Data & Knowledge Engineering, 4(1):43–67, July 1989.

    Article  Google Scholar 

  14. Oracle Corporation. Oracle8i SQL Reference, Release 8.1.6, December 1999.

    Google Scholar 

  15. R. J. Peters and M. T. Ozsu. An Axiomatic Model of Dynamic Schema Evolution in Objectbase Systems. ACM Transactions on Database Systems, 22(1):75–114, March 1997.

    Article  Google Scholar 

  16. Y.-G. Ra and E. A. Rundensteiner. A Transparent Object-Oriented Schema Change Approach Using View Evolution. In P. S. Yu and A. L. P. Chen, editors, Proc. of the 11th IEEE Int. Conf. on Data Engineering, ICDE’95, pages 165–172. IEEE Computer Society Press, Los Alamitos, CA, 1995.

    Google Scholar 

  17. H. Su, K. T. Claypool, and E. A. Rundensteiner. Extending the Object Query Language for Transparent Metadata Access. In H. Balsters, B. De Brock, and S. Conrad, editors, Database Schema Evolution and Meta-Modeling: 9th International Workshop on Foundations of Models and Languages for Data and Objects (FOMLADO/DEMM 2000), Lecture Notes in Computer Science Vol. 2065, pages 181–200, Springer-Verlag, 2001.

    Google Scholar 

  18. X. Sun, N. N. Kamel, and L. M. Ni. Processing Implications on Queries. IEEE Transactions on Software Engineering, 15(10):1168–1175, 1989.

    Article  MathSciNet  Google Scholar 

  19. M. H. Scholl and M. Tresch. Evolution towards, in, and beyond Object Databases. In K. von Luck and H. Marburger, editors, Management and Processing of Complex Data Structures, Proc. of the 3rd Workshop on Information Systems and Artificial Intelligence, Hamburg, Germany, February/March 1994, Lecture Notes in Computer Science, Vol. 777, pages 64–82. Springer-Verlag, Berlin, 1994.

    Google Scholar 

  20. Sybase Inc. Transact-SQL User Guide, Version 11.0, 1999.

    Google Scholar 

  21. A. Skarra and S. B. Zdonik. Type Evolution in an Object-Oriented Database. In A. F. Càrdenas and D. McLeod, editors, Research Foundations in Object-Oriented and Semantic Database Systems, chapter 6, pages 137–155, Series in Data and Knowledge Base Systems, Prentice Hall, Englewood Cliffs, NJ, 1990.

    Google Scholar 

  22. L. Tan and T. Katayama. Meta Operations for Type Management in Object-Oriented Databases: A Lazy Mechanism for Schema Evolution. In W. Kim, J.-M. Nicolas, and S. Nishio, editors, Deductive and Object-Oriented Databases, Proc. of the 1st Int. Conf., DOOD’89, Kyoto, Japan, December, 1989, pages 241–258. North-Holland, Amsterdam, 1990.

    Google Scholar 

  23. J. D. Ullman. Principles of Database and Knowledge-Base Systems, Volume II: The New Technologies. Computer Science Press, Rockville, MD, 1989.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Swiss Federal Institute of Technology (ETH) Zurich, Institute of Information Systems, ETH Zentrum, CH-8092, Zurich, Switzerland

    Can Türker

Authors
  1. Can Türker
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, University of Twente, P.O. Box 217, 7500 AE, Enschede, The Netherlands

    Herman Balsters

  2. Faculty of Management and Organization, University of Groningen, P.O. Box 800, 9700 AV, Groningen, The Netherlands

    Bert de Brock

  3. Department of Computer Science, University of Munich, Oettingenstraße 67, 80538, Munich, Germany

    Stefan Conrad

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Türker, C. (2001). Schema Evolution in SQL-99 and Commercial (Object-)Relational DBMS. In: Balsters, H., de Brock, B., Conrad, S. (eds) Database Schema Evolution and Meta-Modeling. DEMM FoMLaDO 2000 2000. Lecture Notes in Computer Science, vol 2065. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48196-6_1

Download citation

  • DOI: https://doi.org/10.1007/3-540-48196-6_1

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-42272-3

  • Online ISBN: 978-3-540-48196-6

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation