Representing retroactive and proactive versions in bi-temporal databases (2TDB)

Bi temporal databases allow users to record retroactive (past) and proactive (future planned) versions of an entity, and to retrieve the appropriate versions for bi temporal queries that involve both valid time and transaction time. Currently used timestamp representations are mainly for either valid time or transaction time databases. We first categorize the types of problems that can occur in existing models. These are: ambiguity; priority specification; and lost information. We then propose a 2TDB model that allows both retroactive and proactive versions, overcomes the identified problems, and permits the correction of recorded facts.

[1]  Curtis E. Dyreson,et al.  Timestamp semantics and representation , 1993, Inf. Syst..

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

[3]  David B. Lomet,et al.  Access methods for multiversion data , 1989, SIGMOD '89.

[4]  Arie Segev,et al.  Retroactive and proactive database processing , 1994, Proceedings of IEEE International Workshop on Research Issues in Data Engineering: Active Databases Systems.

[5]  Umeshwar Dayal,et al.  A uniform model for temporal object-oriented databases , 1992, [1992] Eighth International Conference on Data Engineering.

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

[7]  Ramez Elmasri,et al.  Partitioning of time index for optical disks , 1992, [1992] Eighth International Conference on Data Engineering.

[8]  Ramez Elmasri,et al.  The Time Index: An Access Structure for Temporal Data , 1990, VLDB.

[9]  Christos Faloutsos,et al.  Access Methods for Bi-Temporal Databases , 1995, Temporal Databases.

[10]  Beng Chin Ooi,et al.  The TP-Index: a dynamic and efficient indexing mechanism for temporal databases , 1994, Proceedings of 1994 IEEE 10th International Conference on Data Engineering.

[11]  Christian S. Jensen,et al.  On the Semantics of Now in Temporal Databases , 1994 .

[12]  Richard T. Snodgrass,et al.  The temporal query language TQuel , 1987, TODS.

[13]  Ramez Elmasri,et al.  Temporal database modeling: an object-oriented approach , 1993, CIKM '93.

[14]  Umeshwar Dayal,et al.  A Uniform Approach to Processing Temporal Queries , 1992, VLDB.

[15]  Ramez Elmasri,et al.  Efficient implementation techniques for the time index , 1991, [1991] Proceedings. Seventh International Conference on Data Engineering.

[16]  Ramez Elmasri,et al.  A consensus glossary of temporal database concepts , 1994, SGMD.

[17]  Arie Segev,et al.  Efficient Indexing Methods for Temporal Relations , 1993, IEEE Trans. Knowl. Data Eng..

[18]  Shashi K. Gadia,et al.  A generalized model for a relational temporal database , 1988, SIGMOD '88.