Versioned relations: support for conditional schema changes and schema versioning

Authors:
Peter Sune Jørgensen;Michael Böhlen
Affiliations:
Faculty of Computer Science, Free University of Bozen-Bolzano, Bozen-Bolzano, Italy;Faculty of Computer Science, Free University of Bozen-Bolzano, Bozen-Bolzano, Italy
Venue:
DASFAA'07 Proceedings of the 12th international conference on Database systems for advanced applications
Year:
2007

Citing 1
Cited 1

A consensus glossary of temporal database concepts

ACM SIGMOD Record

Managing the History of Metadata in Support for DB Archiving and Schema Evolution

ER '08 Proceedings of the ER 2008 Workshops (CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM) on Advances in Conceptual Modeling: Challenges and Opportunities

Quantified Score

Hi-index	0.00

Visualization

Abstract

We introduce the versioned relational data model, which allows a user to apply conditional schema changes to a populated database without breaking applications compiled against an existing schema, and without loss of existing data. Our model is based on keeping a history of conditional schema changes, and converting tuples on demand to fit the correct schema in any schema version. We provide a concrete definition of schema versioning: The ability to specify an operator on any schema version, such that the tuples in the result are unaffected by schema versions created after the specified schema version. Finally, we show that our model supports schema versioning.