Encyclopedia of Database Systems

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

Temporal Strata

  • Kristian TorpEmail author
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_409


Layered architecture; Temporal layer; Temporal middleware; Wrapper


A temporal stratum is an architecture for implementing a temporal DBMS. The stratum is a software layer that sits on top of an existing DBMS. The layer translates a query written in a temporal query language into one or more queries in a conventional query language (typically SQL). The translated queries can then be executed by the underlying DBMS. The DBMS returns the result of the query to the user directly or via the stratum. The core idea of the stratum is to provide new temporal query functionality to the users without changing the underlying DBMS. A temporal stratum can be implemented as a simple translator (temporal SQL to standard SQL) or as an advanced software component that also does part of the query processing and optimization. In the latter case, the temporal stratum can implement query processing algorithms that take the special nature of temporal data into consideration. Examples are...

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

Recommended Reading

  1. 1.
    Böhlen MH, Jensen CS, Snodgrass RT. Temporal statement modifiers. ACM Trans Database Syst. 2000;25(4):407–56.zbMATHCrossRefGoogle Scholar
  2. 2.
    Lomet D, Barga R, Mokbel MF, Shegalov G, Wang R, Zhu Y. Transaction time support inside a database engine. In: Proceedings of the 22nd International Conference on Data Engineering; 2006.Google Scholar
  3. 3.
    Slivinskas G, Jensen CS. Enhancing an extensible query optimizer with support for multiple equivalence types. In: Proceedings of the 5th East European Conference Advances in Databases and Information Systems; 2001. p. 55–69.CrossRefGoogle Scholar
  4. 4.
    Stonebraker M, Rowe LA. The design of POSTGRES. In: Proceedings of the ACM SIGMOD International Conference on Management of Data; 1986. p. 340–55.Google Scholar
  5. 5.
    Snodgrass RT. The TSQL2 temporal query language. Dordrecht: Kluwer; 1995.zbMATHCrossRefGoogle Scholar
  6. 6.
    Snodgrass RT. Developing time-oriented database applications in SQL. San Francisco: Morgan Kaufmann; 1999.Google Scholar
  7. 7.
    Torp K, Jensen CS, Snodgrass RT. Stratum approaches to temporal DBMS implementation. In: Proceedings of the International Conference Symposium on Database Engineering and Applications; 1998. p. 4–13.Google Scholar
  8. 8.
    IBM Corp. IBM DB2. ibm.com/software/data/db2, as of 28.6.2014
  9. 9.
    Teradata Corp. Teradata. teradata.com, as of 28.6.2014

Copyright information

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

Authors and Affiliations

  1. 1.Aalborg UniversityAalborgDenmark

Section editors and affiliations

  • Richard T. Snodgrass
    • 1
  • Christian S. Jensen
    • 2
  1. 1.University of ArizonaTucsonUSA
  2. 2.Aalborg UniversityAalborg ØstDenmark