Definition
Facts in a bitemporal database may be timestamped by time values that are products of time intervals drawn from two orthogonal time domains that model valid time and transaction time, respectively. A bitemporal interval then is given by an interval from the valid-time domain and an interval from the transaction-time domain, and denotes a rectangle in the two-dimensional space spanned by valid and transaction time.
When associated with a fact, a bitemporal interval then identifies an interval (valid time) during which that fact held (or holds or will hold) true in reality, as well as identifies an interval (transaction time) when that belief (that the fact was true during the specified valid-time interval) was held, i.e., was part of the current database state.
Key Points
In this definition, a time interval denotes a convex subset of the time domain. Assuming a discrete time domain, a bitemporal interval can be represented with a non-empty set of bitemporal chronons or...
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended Reading
Bettini C, Dyreson CE, Evans WS, Snodgrass RT, Wang XS. A glossary of time granularity concepts. In: Etzion O, Jajodia S, Sripada S, editors. Temporal databases: research and practice. LNCS, vol. 1399. Berlin: Springer; 1998. p. 406–13.
Jensen CS, Dyreson CE, editors. 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: Springer; 1998. p. 367–405.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
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). Bitemporal Interval. 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_1424
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1424
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