Jump to content

Tuple-versioning

Add links
From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Muntfish (talk | contribs) at 09:11, 10 February 2005 (Rewrite first paragraph). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Tuple-versioning (or point-in-time) is a mechanism used in a relational database management system to store past states of a relation. Normally, only the current state is captured.

Using tuple-versioning techniques, typically two values for time are stored with each tuple: a start time and an end time. These two values indicate the validity of the rest of the values in the tuple.

Typically when tuple-versioning techniques are used, the current tuple has a start time and a null value for end time. Therefore, it is easy and efficient to obtain the current values for all tuples by querying for the null end time.

A single query that searches for tuples with start time less than and end time greater than a given time, where null end time is treated as a value greater than the given time, will give as a result the valid tuples at the given time.

For example, if a person's job changes from Engineer to Manager, there would be two tuples in an Employee table, one with the value Engineer for job and the other with the value Manager for job. The end time for the Engineer tuple would be the start time for the Manager tuple.

References

  • Comparison of Access Methods for Time-Evolving Data, by Betty Salzberg and Vassilis J. Tsotras, ACM Computing Surveys, Vol. 31, No. 2, June 1999.
Retrieved from "https://en.wikipedia.org/w/index.php?title=Tuple-versioning&oldid=10126221"