Using Database Versions to Implement Temporal Integrity Constraints

This paper presents the extension of integrity constraint mechanisms for maintaining consistency in temporal databases, when both transaction time and valid time are taken into account. This work is based on the database version model, in which consistency is maintained using adequate integrity constraints called mv-constraints. The issue of describing and classifying temporal constraints and the issue of defining them on top of the database version model, by mapping them to mv-constraints, are both addressed.

[1]  Peter Dadam,et al.  Integration of Time Versions into a Relational Database System , 1984, VLDB.

[2]  Serge Abiteboul,et al.  Transactions and integrity constraints , 1985, PODS '85.

[3]  Michel E. Adiba,et al.  Historical Multi-Media Databases , 1986, VLDB.

[4]  Ilsoo Ahn,et al.  Towards an implementation of database management systems with temporal support , 1986, 1986 IEEE Second International Conference on Data Engineering.

[5]  James Clifford,et al.  A Simple, General Structure for Temporal Domains , 1986, Temporal Aspects in Information Systems.

[6]  Wojciech Cellary,et al.  Consistency of versions in objects-oriented databases , 1990, VLDB 1990.

[7]  Wojciech Cellary,et al.  Consistency of Versions in Object-Oriented Databases , 1990, Building an Object-Oriented Database System, The Story of O2.

[8]  Ramez Elmasri,et al.  A temporal model and query language for ER databases , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[9]  Randy H. Katz,et al.  Toward a unified framework for version modeling in engineering databases , 1990, CSUR.

[10]  Richard T. Snodgrass,et al.  Temporal databases status and research directions , 1990, SGMD.

[11]  Nandlal L. Sarda,et al.  Extensions to SQL for Historical Databases , 1990, IEEE Trans. Knowl. Data Eng..

[12]  Michael D. Soo,et al.  Bibliography on temporal databases , 1991, SGMD.

[13]  Wojciech Cellary,et al.  Maintaining Integrity Constraints across Versions in a Database , 1992 .

[14]  Andreas Reuter,et al.  Transaction Processing: Concepts and Techniques , 1992 .

[15]  Shamkant B. Navathe,et al.  Temporal Extensions to the Relational Model and SQL , 1993, Temporal Databases.

[16]  Sushil Jajodia,et al.  Temporal Databases: Theory, Design, and Implementation , 1993 .

[17]  Umeshwar Dayal,et al.  A Uniform Model for Temporal and Versioned Object-oriented Databases , 1993, Temporal Databases.

[18]  Albert Croker,et al.  The Historical Relational Data Model (HRDM) Revisited , 1993, Temporal Databases.

[19]  Paul W. P. J. Grefen,et al.  Integrity Control in Relational Database Systems - An Overview , 1993, Data Knowl. Eng..

[20]  Arie Segev,et al.  A consensus glossary of temporal database concepts , 1994, SIGMOD 1994.

[21]  Jan Chomicki,et al.  Temporal Query Languages: A Survey , 1994, ICTL.

[22]  James Clifford,et al.  On the Semantics of (Bi)Temporal Variable Databases , 1994, EDBT.

[23]  Stéphane Gançarski,et al.  A Framework for the Manipulation of a Multiversion Database , 1995, DEXA Workshop.

[24]  Richard T. Snodgrass,et al.  The TSQL2 Temporal Query Language , 1995 .

[25]  Jef Wijsen,et al.  Design of Temporal Relational Databases Based on Dynamic and Temporal Functional Dependencies , 1995, Temporal Databases.

[26]  Michael Gertz,et al.  "Temporal" Integrity Constraints in Temporal Databases , 1995, Temporal Databases.

[27]  Jan Chomicki,et al.  Querying TSQL2 Databases with Temporal Logic , 1996, EDBT.

[28]  Anne Doucet,et al.  Integrity Constraints in Multiversion Databases , 1996, BNCOD.