Synonyms
Interval-based temporal models
Definition
A period-stamped temporal model is a temporal data model for the management of data in which time has the form of a time period.
Historical Background
There are applications that require the recording and management not only of data but also of the time during which this data is valid (valid time). A typical example is the data maintained by pension and life insurance organizations in order to determine the benefits for which a person qualifies. Similarly, such organizations have to record their financial obligations at various times in the future.
There are also sensitive applications, in which it is important to record not only the data but also the time at which this data was either recorded in the database or deleted or updated (transaction time). This time is recorded automatically by the database management system (DBMS) and it cannot be modified by the user.
Finally, there are applications in which data, valid time, and...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Date CJ, Darwen H, Lorentzos NA. Time and relational theory, temporal databases in the relational model and SQL. Morgan Kaufmann Publishers; 2013.
International Organization for Standardization (ISO). Database language SQL. Document ISO/IEC 9075:2011. 2011.
Jones S, Mason PS. Handling the time dimension in a database. In: Proceedings of the International Conference Data Bases; 1980. p. 65–83.
Kulkarni K, Michels J-E. Temporal features in SQL:2011. ACM SIGMOD Rec. 2012;41(3):34–43.
Lorentzos NA, Johnson RG. Extending relational algebra to manipulate temporal data. Inf Syst. 1988;13(3):289–96.
Lorentzos NA, Johnson RG. TRA a model for a temporal relational algebra. In: Rolland C, Bodart F, Leonard M, editors. Temporal aspects in information systems. North-Holland; 1988. p. 203–15.
Lorentzos NA, Mitsopoulos YG. SQL extension for interval data. IEEE Trans Knowl Data Eng. 1997;9(3):480–99.
Navathe SB, Ahmed R. TSQL: a language interface for history databases. In: Rolland C, Bodart F, Leonard M, editors. Temporal aspects in information systems. North-Holland; 1988. p. 109–22.
Navathe SB, Ahmed R. A temporal relational model and a query language. Inf Sci Int J. 1989;47(2):147–75.
Sarda NL. Algebra and query language for a historical data model. Comput J. 1990;33(1):11–8.
Sarda NL. Extensions to SQL for historical databases. IEEE Trans Knowl Data Eng. 1990;2(2):220–30.
Snodgrass S. The temporal query language TQUEL. ACM Trans Database Syst. 1987;12(2): 247–98.
Tansel AU. Adding time dimension to relational model and extending relational algebra. Inf Syst. 1986;11(4):343–55.
Tansel AU. A historical query language. Inf Sci. 1991;53(1–2):101–33.
Tansel AU. Temporal relational data model. IEEE Trans Knowl Data Eng. 1997;9(3):464–79.
Tansel AU, Canan EA. Nested bitemporal relational algebra. In: Proceedings of the 21st International Symposium on Computer and Information Sciences; 2006. p. 622–33.
Tansel A, Clifford J, Gadia J, Segev A, Snodgrass R, editors. Temporal databases: theory, design and implementation. Benjamin/Cummings; 1993.
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
Lorentzos, N.A. (2018). Period-Stamped Temporal Models. 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_266
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_266
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