Encyclopedia of Database Systems

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

Period-Stamped Temporal Models

  • Nikos A. LorentzosEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_266


Interval-based temporal models


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

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

Recommended Reading

  1. 1.
    Date CJ, Darwen H, Lorentzos NA. Time and relational theory, temporal databases in the relational model and SQL. Morgan Kaufmann Publishers; 2013.Google Scholar
  2. 2.
    International Organization for Standardization (ISO). Database language SQL. Document ISO/IEC 9075:2011. 2011.Google Scholar
  3. 3.
    Jones S, Mason PS. Handling the time dimension in a database. In: Proceedings of the International Conference Data Bases; 1980. p. 65–83.Google Scholar
  4. 4.
    Kulkarni K, Michels J-E. Temporal features in SQL:2011. ACM SIGMOD Rec. 2012;41(3):34–43.CrossRefGoogle Scholar
  5. 5.
    Lorentzos NA, Johnson RG. Extending relational algebra to manipulate temporal data. Inf Syst. 1988;13(3):289–96.zbMATHCrossRefGoogle Scholar
  6. 6.
    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.Google Scholar
  7. 7.
    Lorentzos NA, Mitsopoulos YG. SQL extension for interval data. IEEE Trans Knowl Data Eng. 1997;9(3):480–99.zbMATHCrossRefGoogle Scholar
  8. 8.
    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.Google Scholar
  9. 9.
    Navathe SB, Ahmed R. A temporal relational model and a query language. Inf Sci Int J. 1989;47(2):147–75.zbMATHGoogle Scholar
  10. 10.
    Sarda NL. Algebra and query language for a historical data model. Comput J. 1990;33(1):11–8.MathSciNetCrossRefGoogle Scholar
  11. 11.
    Sarda NL. Extensions to SQL for historical databases. IEEE Trans Knowl Data Eng. 1990;2(2):220–30.CrossRefGoogle Scholar
  12. 12.
    Snodgrass S. The temporal query language TQUEL. ACM Trans Database Syst. 1987;12(2): 247–98.MathSciNetCrossRefGoogle Scholar
  13. 13.
    Tansel AU. Adding time dimension to relational model and extending relational algebra. Inf Syst. 1986;11(4):343–55.zbMATHCrossRefGoogle Scholar
  14. 14.
    Tansel AU. A historical query language. Inf Sci. 1991;53(1–2):101–33.zbMATHCrossRefGoogle Scholar
  15. 15.
    Tansel AU. Temporal relational data model. IEEE Trans Knowl Data Eng. 1997;9(3):464–79.CrossRefGoogle Scholar
  16. 16.
    Tansel AU, Canan EA. Nested bitemporal relational algebra. In: Proceedings of the 21st International Symposium on Computer and Information Sciences; 2006. p. 622–33.CrossRefGoogle Scholar
  17. 17.
    Tansel A, Clifford J, Gadia J, Segev A, Snodgrass R, editors. Temporal databases: theory, design and implementation. Benjamin/Cummings; 1993.Google Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Informatics Laboratory, Department of Agricultural Economics and Rural DevelopmentAgricultural University of AthensAthensGreece

Section editors and affiliations

  • Richard T. Snodgrass
    • 1
  • Christian S. Jensen
    • 2
  1. 1.University of ArizonaTucsonUSA
  2. 2.Aalborg UniversityAalborgDenmark