Transaction time
From Wikipedia, the free encyclopedia
Transaction time (TT) is a concept used in temporal databases. It denotes the time period during which a database fact is/was stored in the database.
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 Closed". Academic researchers and some RDBMS have represented "Until Closed" with the largest timestamp supported or the keyword "forever". This convention is not technically precise.
- See also Valid time