Synonyms
Belief time; Extrinsic time; Physical time; Registration time; System time; Transaction commit time
Definition
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...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
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.
Kulkari K, Michels J-E. Temporal features in SQL:2011. ACM SIGMOD Record. 2012;41(3): 34–43.
Melton J, editor. ISO/IEC 9075, Database language SQL:2011 part 2: SQL/Foundation; Dec 2011.
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.
Snodgrass RT, Ahn I. Temporal databases. IEEE Comput. 1986;19(9):35–42.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Jensen, C.S., Snodgrass, R.T. (2018). Transaction Time. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_1064
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1064
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering