On the Semantics of Transaction Time and Valid Time in Bitemporal Databases

40 Pages Posted: 31 Oct 2008

See all articles by James Clifford

James Clifford

affiliation not provided to SSRN

Tomas Isakowitz

affiliation not provided to SSRN

Date Written: December 1992

Abstract

Numerous proposals for extending the relational data model to incorporate the temporaldimension of data have appeared in the past several years. While most of thesehave been historical databases, incorporating in some fashion a valid time dimensionto the data model and the query languages, others have been rollback databases, incorporatinga transaction time dimension, or bitemporal databases, incorporating both ofthese temporal dimensions. In this paper we address an issue that has been lacking inmany of these papers, namely, a formal specification of the precise semantics of thesetemporal dimensions of data. We introduce the notion of reference time - the timethat any operation is applied to the database state - and provide a logical analysisof the interrelationships among these three temporal dimensions. We also provide ananalysis of the meaning of various variables such as now and ∞ which have been usedin many of these models without a complete specification of their semantics.

Suggested Citation

Clifford, James and Isakowitz, Tomas, On the Semantics of Transaction Time and Valid Time in Bitemporal Databases (December 1992). NYU Working Paper No. IS-92-42, Available at SSRN: https://ssrn.com/abstract=1289024

James Clifford

affiliation not provided to SSRN

Tomas Isakowitz

affiliation not provided to SSRN

No Address Available

Do you have negative results from your research you’d like to share?

Paper statistics

Downloads
81
Abstract Views
751
Rank
547,134
PlumX Metrics