Synonyms
Application time; Business time Data time; Intrinsic time; Logical time; Real-world time
Definition
The valid time of a fact is the time when the fact is true in the modeled reality. Any subset of the time domain may be associated with a fact as its valid time. Thus, valid timestamps may be sets of time instants and time intervals, with single instants and intervals being important special cases. Valid times are usually supplied by users.
Main Text
While other temporal aspects have been proposed, such as “decision time” and “event time,” closer analysis indicates that the decision and event time of a fact can be captured as either a valid time or a transaction time of some related fact.
For example, consider a valid-time Faculty table with attributes Name and Position (i.e., either Assistant Professor, Associate Professor, or Professor) that captures the positions of faculty members. The valid time then captures when a faculty member held a specific position.
The “decision...
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
Jensen CS, Dyreson CE (eds). 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—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.
Kulkari K, Michels J-E. Temporal features in SQL:2011. ACM SIGMOD Rec. 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; 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). Valid 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_1066
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1066
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