Definition
Schema versioning deals with the need to retain current data, and the ability to query and update it, through alternate database structures. (The structure of a database is held in a schema (pl. schemata or schemas). Commonly, particularly in temporal databases, these schemata represent the historical structure of a database but this may not always be the case.) Schema Versioning requires not only that data are not lost in schema transformation but also requires that all data are able to be queried, both retrospectively and prospectively, through user-definable version interfaces. Partial schema versioning is supported when data stored under any historical schema may be viewed through any other schema but may only be updated through one specified schema version – normally the current or active schema. (Schema evolution and schema versioning has been conflated in the literature with the two terms occasionally being used interchangeably.)
Historical Background
Multiple...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Kim W, Ballou N, Chou HT, Garza JF, Woelk D. Features of the orion object-oriented database system. In: Kim W, Lochovsky F, editors. Object-oriented concepts, databases and applications. New York: ACM Press; 1989. p. 251–82.
Madhavan J, Halevy AY. Composing mappings among data sources. In: Proceedings of the 29th International Conference on Very Large Data Bases; 2003; p. 572–83.
McKenzie L, Snodgrass R. Schema evolution and the relational algebra. Inf Syst. 1990;15(2):207–32.
Melnik S, Rahm E, Bernstein PA. Rondo: a programming platform for generic model management. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 2003. p. 193–204.
Miller R, Ioannidis Y, Ramakrishnan R. The use of information capacity in schema integration and translation. In: Proceedings of the 29th International Conference on Very Large Data Bases; 1993. p. 120–33.
Osborn S. The role of polymorphism in schema evolution in an object-oriented database. IEEE Trans Knowl Data Eng. 1989;1(3):310–7.
Penney D, Stein J. Class modification in the gemstone object-oriented DBMS. In: Proceedings of the 1987 Conference on Object-Oriented Programming Systems, Languages, and Applications; 1987. p. 111–17.
Roddick JF. SQL/SE – a query language extension for databases supporting schema evolution. ACM SIGMOD Rec. 1992;21(3):10–6.
Roddick JF, Snodgrass R. Schema versioning support, chapter 22. In: Snodgrass R, editor. The TSQL2 temporal query language. Boston: Kluwer; 1995. p. 427–49.
Roddick JF, Grandi F, Mandreoli F, Scalas MR. Beyond schema versioning: a flexible model for spatio-temporal schema selection. Geoinformatica. 2001;5(1):33–50.
Skyt J, Jensen CS, Mark L. A foundation for vacuuming temporal databases. Data Knowl Eng. 2003;44(1):1–29.
Zdonik S. Version management in an object-oriented database. In: Proceedings of the International Workshop on Advanced Programming Environments; 1986. p. 405–22.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Roddick, J.F. (2018). Schema Versioning. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_323
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_323
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering