Encyclopedia of Database Systems

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

Bitemporal Relation

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


Fully temporal relation; Temporal relation; Valid-time and transaction-time relation


A bitemporal relation captures exactly one valid time aspect and one transaction time aspect of the data it contains. This relation inherits its properties from valid-time relations and transaction-time relations. There are no restrictions as to how either of these temporal aspects may be incorporated into the tuples.

Key Points

In this definition, “bi” refers to the capture of exactly two temporal aspects. An alternative definition states that a bitemporal relation captures one or more valid times and one or more transaction times. In this definition, “bi” refers to the existence of exactly two types of times.

One may adopt the view that the data in a relation represents a collection of logical statements, i.e., statements that can be assigned a truth values. The valid times of these so-called facts are the times when these are true in the reality modeled by the relation. In cases...

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

Recommended Reading

  1. 1.
    Jensen CS, Dyreson CE. A consensus glossary of temporal database concepts-February 1998 version. In: Etzion O, Jajodia S, Sripada S, editors. Temporal databases: research and practice. LNCS, vol. 1399. Berlin/New York: Springer; 1998. p. 367–405.CrossRefGoogle 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

Section editors and affiliations

  • Richard T. Snodgrass
    • 1
  • Christian S. Jensen
    • 2
  1. 1.University of ArizonaTucsonUSA
  2. 2.Aalborg UniversityAalborg ØstDenmark