Transaction time

In temporal databases, transaction time (TT) is the time period during which a fact stored in the database is considered to be true. As of December 2011, ISO/IEC 9075, Database Language SQL:2011 Part 2: SQL/Foundation included clauses in table definitions to define "system-versioned tables" (that is, transaction-time tables).

In a database table transaction time is often represented by two extra table-columns StartTT and EndTT. The time interval is closed at its lower bound and open at its upper bound.

When the ending transaction time is unknown, it may be considered as "Until Changed". Academic researchers and some RDBMS have represented "Until Changed" with the largest timestamp supported or the keyword "forever". This convention is not technically precise.

The term was coined by Richard T. Snodgrass and his doctoral student.[1]

See also

References

  1. ↑ Snodgrass; Llsoo Ahn (1986). "Temporal Databases". Computer. 19 (9): 35. doi:10.1109/MC.1986.1663327.
This article is issued from Wikipedia - version of the 8/28/2015. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.