Skip to main content
SpringerLink
Log in

Transaction Time

  • Living reference work entry
  • First Online:
Encyclopedia of Database Systems

  • 115 Accesses

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...

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

Access this chapter

Log in via an institution

Institutional subscriptions

Recommended Reading

  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. Kulkari K, Michels J-E. Temporal features in SQL:2011. ACM SIGMOD Record. 2012;41(3):34–43.

    Article  Google Scholar 

  3. Melton J, editor. ISO/IEC 9075, Database language SQL:2011 part 2: SQL/Foundation; Dec 2011.

    Google Scholar 

  4. Snodgrass RT, Ahn I. A taxonomy of time in databases. In: Proceedings of the ACM-SIGMOD International Conference on Management of Data, Austin; May 1985. p. 236–46.

    Google Scholar 

  5. Snodgrass RT, Ahn I. Temporal databases. IEEE Comput. 1986;19(9):35–42.

    Article  MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Aalborg University, Selma Lagerlöfs Vej 300, DK-9220, Aalborg, Denmark

    Christian S. Jensen

  2. University of Arizona, Tucson, AZ, USA

    Richard T. Snodgrass

Authors
  1. Christian S. Jensen
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Richard T. Snodgrass
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Christian S. Jensen .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, Georgia, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, Ontario, Canada

    M. Tamer Özsu

Section Editor information

  1. University of Arizona, Tucson, AZ, USA

    Richard T. Snodgrass

  2. Aalborg University, Selma Lagerlöfs Vej 300, DK-9220, Aalborg, Denmark

    Christian S. Jensen PhD

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Springer Science+Business Media LLC

About this entry

Cite this entry

Jensen, C.S., Snodgrass, R.T. (2017). Transaction Time. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_1064-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_1064-2

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Print ISBN: 978-1-4899-7993-3

  • Online ISBN: 978-1-4899-7993-3

  • eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering

Publish with us

Policies and ethics

Search

Navigation