Transaction time
From Wikipedia, the free encyclopedia
In temporal databases, transaction time (TT), like for example the load datetime,[1] is the time during which a fact stored in the database is considered to be true.
This article needs additional citations for verification. (May 2008) |
In a database table, the transaction time is often represented as an interval allowing the system to "remove" entries by using two table-columns start_tt
and end_tt
. The time interval is closed [
at its lower bound and open )
at its upper bound.[2]
When the ending transaction time is unknown, it may be considered as until_changed
. Academic researchers and some relational database management systems (RDBMS) have represented until_changed
with the largest timestamp supported or the keyword forever
. This convention is a technical workaround, and not technically precise.