Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

Transaction Time

  • Christian S. JensenEmail author
  • Richard T. Snodgrass
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1064


Belief time; Extrinsic time; Physical time; Registration time; System time; Transaction commit time


A database fact is stored in a database at some point in time, and after it is stored, it remains current, or part of the current database state, until it is logically deleted. The transaction time of a database fact is the time when the fact is current in the database. As a consequence, the transaction time of a fact is generally not a time instant but rather has duration.

The transaction time of a current fact extends from some time in the past until the (growing) current time. A current fact can be deleted by replacing its growing end time with the fixed time when the deletion occurs.

In the context of a database management system that supports user transactions, the transaction times of facts are consistent with the serialization order of the transactions that inserted or logically deleted them. Transaction times may be implemented using transaction commit times...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Jensen CS, Dyreson CE, Böhlen M, Clifford J, Elmasri R, Gadia SK, Grandi F, Hayes P, Jajodia S, Käfer W, Kline N, Lorentzos N, Mitsopoulos Y, Montanari A, Nonen D, Peressi E, Pernici B, Roddick JF, Sarda NL, Scalas MR, Segev A, Snodgrass RT, Soo MD, Tansel A, Tiberio R, Wiederhold G. A consensus glossary of temporal database concepts. In: Etzion O, Jajodia S, Sripada S, editors. Temporal databases: research and practice. LNCS 1399. Berlin: Springer; 1998. p. 367–405.Google Scholar
  2. 2.
    Kulkari K, Michels J-E. Temporal features in SQL:2011. ACM SIGMOD Record. 2012;41(3): 34–43.CrossRefGoogle Scholar
  3. 3.
    Melton J, editor. ISO/IEC 9075, Database language SQL:2011 part 2: SQL/Foundation; Dec 2011.Google Scholar
  4. 4.
    Snodgrass RT, Ahn I. A taxonomy of time in databases. In: Proceedings of the ACM-SIGMOD International Conference on Management of Data, Austin; 1985. p. 236–46.Google Scholar
  5. 5.
    Snodgrass RT, Ahn I. Temporal databases. IEEE Comput. 1986;19(9):35–42.zbMATHCrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Computer ScienceAalborg UniversityAalborgDenmark
  2. 2.Department of Computer ScienceUniversity of ArizonaTucsonUSA
  3. 3.Dataware VenturesTucsonUSA