Abstract
The support of schema versioning has been considered only to a limited extent in the literature on temporal databases. In particular, solutions were proposed so far for the management along transaction-time of schema versions, to be used as different interfaces on the same temporal data.
In this paper we investigate the distinct functionalities of new solutions for schema versioning along valid- and transaction-time in a temporal relational environment. The support of schema versioning implies operations both at intensional and extensional levels. Two distinct design solutions (single- and multi-pool) are presented for the management of extensional data in the presence of schema versioning. Moroever, a further distinction is introduced to define synchronous and asynchronous versioning of data and schemas.
The proposed solutions differ in the semantics and in the possible operations they support. The mechanisms for the selection of data through a schema version is strictly related to the particular schema versioning solution, and has also influences on the data definition and manipulation languages at user-interface level. We also show how the temporal language TSQL2, originally designed to support transaction-time schema versioning, can accordingly be extended.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
De Castro C, Grandi F., Scalas M.R.: “Semantic Interoperability of Multitemporal Relational Databases”, in Entity-Relationship Approach–ER ‘93, Lecture Notes in Computer Science, Vol. 823, Springer-Verlag, 1994.
De Castro G, Grandi F., Scalas M.R.: “Management of Schema Versions in Multitemporal Relational Databases”, Proc. 2nd Italian Conference on Advanced Database Systems (SEBD ‘94), Rimini, Italy, June 1994 (in Italian).
De Castro C., Grandi F., Scalas M.R.: “Schema Versioning for Multitemporal Relational Databases”, C.I.O.C.-C.N.R. Tech. Rep. No. 100, Bologna, Italy, July 1994.
De Castro C., Grandi F., Scalas M.R.: “Extensional Data Management in Multitemporal Relational Databases Supporting Schema Versioning”, Proc. 3rd Italian Conference on Advanced Database Systems (SEBD ‘95), Ravello, Italy, June 1995.
Dadam P., Teuhola J.: “Managing Schema Versions in a Time- Versioned Non-First-Normal-Form Relational Database”, Proc. Datenbanksysteme in Büro, Technik und Wissenschaft, GI-Fachtagung, Darmstadt, Germany, April 1987.
Grandi F., Scalas M.R., Tiberio P.: “A History-oriented Data View and Operation Semantics in Temporal Relational Databases”, C.I.O.C.- C.N.R. Tech. Rep. No. 76, Bologna, Italy, January 1991.
Jensen C, Clifford J., Elmasri R., Gadia S.K., Hayes P., Jajodia S. (editors), Dyreson C., Grandi F., Kafer W., Kline N., Lorentzos N., Mitsopoulos Y., Montanari A., Nonen D., Peressi E., Pernici B., Roddick J.F., Sarda N.L., Scalas M.R., Segev A., Snodgrass R., Soo M.D., Tansel A., Tiberio P., Wiederhold G.: “A Consensus Glossary of Temporal Database Concepts”, ACM SIGMOD RECORD, Vol. 23, No. 1, March 1994.
Jensen C.S., Soo M.D., Snodgrass R.T.: “Unification of Temporal Relations”, Proc. 9th IEEE International Conference on Data Engineering (ICDE ‘93), Vienna, Austria, April 1993.
Kline N.: “An update of the Temporal Database Bibliography”, ACM SIGMOD RECORD, Vol. 22, No. 4, December 1993.
Mckenzie E., Snodgrass R.: “Schema Evolution and the Relational Algebra”, Information Systems, Vol. 15, No. 2, 1990.
Roddick J.F.: “SQL/SE — A Query Language Extension for Databases Supporting Schema Evolution”, ACM SIGMOD RECORD, Vol. 21, No. 3, September 1992.
Roddick J.F.: “Schema Evolution in Database Systems — An Annotated Bibliography”, ACM SIGMOD RECORD, Vol. 21, No. 4, December 1992.
Roddick J.F., Snodgrass T.: “Schema Versioning Support’, in [19], ch. 22.
Snodgrass R.T., Ahn I., Ariav G., Batory D., Clifford J., Dyreson C.E., Elmasri R., Grandi F., Jensen C.J., Kafer W., Kline N., Kulkarni K., Cliff Leung T.Y, Lorentzos N., Roddick J.F., Segev A., Soo M.D., Sripada S.M.: “TSQL2 Language Specification”, ACM SIGMOD RECORD, Vol. 23, No.1, March 1994.
Scalas M.R., Cappelli A., De Castro C.: “A Model for Schema Evolution in Temporal Relational Databases”, Proc. of 7th IEEE European Computer Conference (CompEuro ‘93), Paris Evry, France, May 1993.
Snodgrass R.T., Jensen C.S., Grandi F.: “Schema Specification”, in [19], ch. 11.
Soo M.: “Bibliography on Temporal Databases”, Acm Sigmod Record, March 1991.
Tansel A., Clifford J., Gadia V., Jajodia S., Segev A., Snodgrass R.T. (eds.), Temporal Databases: Theory, Design And Implementation, The Benjamin/Cummings Publishing Company, Redwood City, CA, 1993.
Snodgrass R.T. (editor), Ahn I., Ariav G., Batory D., Clifford J., Dyreson C.E., Elmasri R., Grandi F., Jensen C.J., Käfer W., Kline N., Kulkarni K., Cliff Leung T.Y., Lorentzos N., Ramakrishnan R., Roddick J.F., Segev A., Soo M.D., Sripada S.M., The TSQL2 Temporal Query Language, Kluwer Academic Publishers, Nor- well, MA, 1995.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1995 British Computer Society
About this paper
Cite this paper
De Castro, C., Grandi, F., Scalas, M.R. (1995). On Schema Versioning in Temporal Databases. In: Clifford, J., Tuzhilin, A. (eds) Recent Advances in Temporal Databases. Workshops in Computing. Springer, London. https://doi.org/10.1007/978-1-4471-3033-8_15
Download citation
DOI: https://doi.org/10.1007/978-1-4471-3033-8_15
Publisher Name: Springer, London
Print ISBN: 978-3-540-19945-8
Online ISBN: 978-1-4471-3033-8
eBook Packages: Springer Book Archive