Skip to main content

Period-Stamped Temporal Models

  • Reference work entry
  • First Online:
Book cover Encyclopedia of Database Systems
  • 15 Accesses

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Recommended Reading

  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. International Organization for Standardization (ISO). Database language SQL. Document ISO/IEC 9075:2011. 2011.

    Google Scholar 

  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. Kulkarni K, Michels J-E. Temporal features in SQL:2011. ACM SIGMOD Rec. 2012;41(3):34–43.

    Article  Google Scholar 

  5. Lorentzos NA, Johnson RG. Extending relational algebra to manipulate temporal data. Inf Syst. 1988;13(3):289–96.

    Article  MATH  Google Scholar 

  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. Lorentzos NA, Mitsopoulos YG. SQL extension for interval data. IEEE Trans Knowl Data Eng. 1997;9(3):480–99.

    Article  MATH  Google Scholar 

  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. Navathe SB, Ahmed R. A temporal relational model and a query language. Inf Sci Int J. 1989;47(2):147–75.

    MATH  Google Scholar 

  10. Sarda NL. Algebra and query language for a historical data model. Comput J. 1990;33(1):11–8.

    Article  MathSciNet  Google Scholar 

  11. Sarda NL. Extensions to SQL for historical databases. IEEE Trans Knowl Data Eng. 1990;2(2):220–30.

    Article  Google Scholar 

  12. Snodgrass S. The temporal query language TQUEL. ACM Trans Database Syst. 1987;12(2): 247–98.

    Article  MathSciNet  Google Scholar 

  13. Tansel AU. Adding time dimension to relational model and extending relational algebra. Inf Syst. 1986;11(4):343–55.

    Article  MATH  Google Scholar 

  14. Tansel AU. A historical query language. Inf Sci. 1991;53(1–2):101–33.

    Article  MATH  Google Scholar 

  15. Tansel AU. Temporal relational data model. IEEE Trans Knowl Data Eng. 1997;9(3):464–79.

    Article  Google Scholar 

  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.

    Chapter  Google Scholar 

  17. Tansel A, Clifford J, Gadia J, Segev A, Snodgrass R, editors. Temporal databases: theory, design and implementation. Benjamin/Cummings; 1993.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Nikos A. Lorentzos .

Editor information

Editors and Affiliations

Section Editor information

Rights and permissions

Reprints and permissions

Copyright information

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

About this entry

Check for updates. Verify currency and authenticity via CrossMark

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

Publish with us

Policies and ethics