|This article needs additional citations for verification. (May 2008)|
Transaction time (TT), a concept originated by Richard T. Snodgrass and his doctoral student, is used in temporal databases. It denotes the time period during which a fact stored in the database is considered to be true; example. 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).
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.
|This computer programming–related article is a stub. You can help Wikipedia by expanding it.|