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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
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.
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.
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.
S. E. Bratsberg. Evolution and Integration of Classes in Object-Oriented Databases. Dissertation, The Norwegian Institute of Technology, University of Trondheim, June 1993.
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.
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.
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.
IBM Corporation. IBM DB2 Universal Database: SQL Reference, Version 7, 2000.
Informix Corporation, Menlo Park, CA. Informix Guide to SQL: Syntax, Informix Dynamic Server.2000, Version 9.2, December 1999.
Ingres Corporation. Ingres Database Administrator’s Guide, Version II, 1999.
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.
Microsoft Corporation. Microsoft SQL Server, Version 7.0, 1999.
G. T. Nguyen. Schema Evolution in Object-Oriented Database Systems. Data & Knowledge Engineering, 4(1):43–67, July 1989.
Oracle Corporation. Oracle8i SQL Reference, Release 8.1.6, December 1999.
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.
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.
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.
X. Sun, N. N. Kamel, and L. M. Ni. Processing Implications on Queries. IEEE Transactions on Software Engineering, 15(10):1168–1175, 1989.
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.
Sybase Inc. Transact-SQL User Guide, Version 11.0, 1999.
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.
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.
J. D. Ullman. Principles of Database and Knowledge-Base Systems, Volume II: The New Technologies. Computer Science Press, Rockville, MD, 1989.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights 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