Encyclopedia of Database Systems

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

SQL-Based Temporal Query Languages

  • Michael H. Böhlen
  • Johann Gamper
  • Christian S. Jensen
  • Richard T. Snodgrass
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1525

Definition

More than two dozen extensions to the relational data model have been proposed that support the storage and retrieval of time-referenced data. These models timestamp tuples or attribute values, and the timestamps used include time points, time periods, and finite unions of time periods, termed temporal elements.

A temporal query language is defined in the context of a specific data model. Most notably, it supports the specification of queries on the specific form of time-referenced data provided by its data model. More generally, it enables the management of time-referenced data.

Different approaches to the design of a temporal extension to the Structured Query Language (SQL) have emerged that yield temporal query languages with quite different design properties.

Historical Background

A number of past events and activities that included the temporal database community at large had a significant impact on the evolution of temporal query languages. The 1987 IFIP TC 8/WG 8.1...

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

Recommended Reading

  1. 1.
    Allen JF. Maintaining knowledge about temporal intervals. Commun ACM. 1983;26(11):832–43.zbMATHCrossRefGoogle Scholar
  2. 2.
    Böhlen MH, Jensen CS, Snodgrass RT. Temporal statement modifiers. ACM Trans Database Syst. 2000;25(4):407–56.zbMATHCrossRefGoogle Scholar
  3. 3.
    Clifford J, Tuzhilin A, editors. Recent advances in temporal databases. In: Proceedings of the International Workshop on Temporal Databases; 1995.Google Scholar
  4. 4.
    Date CJ, Darwen H, Lorentzos N, editors. Temporal data and the relational model. Morgan Kaufmann Publishers; 2002.Google Scholar
  5. 5.
    Etzion O, Jajodia S, Sripada S, editors. Temporal databases: research and practice. Springer, Volume 1399 of lecture notes in computer science; 1998.Google Scholar
  6. 6.
    Lorentzos NA, Johnson RG. Extending relational algebra to manipulate temporal data. Inf Syst. 1988;13(3):289–96.zbMATHCrossRefGoogle Scholar
  7. 7.
    Rolland C, Bodart F, Lèonard M, editors. Temporal aspects in information systems. In: Proceedings of the IFIP TC 8/WG 8.1 Working Conference on Temporal Aspects in Information Systems; 1987.Google Scholar
  8. 8.
    Snodgrass RT, editor. Proceeding of the International Workshop on an Infrastructure for Temporal Databases; 1993.Google Scholar
  9. 9.
    Snodgrass RT, editor. The TSQL2 temporal query language. Kluwer; 1995.Google Scholar
  10. 10.
    Snodgrass RT. Developing time-oriented database applications in SQL. San Francisco: Morgan Kaufmann Publishers; 1999.Google Scholar
  11. 11.
    Tansel A, Clifford J, Gadia S, Jajodia S, Segev A, Snodgrass RT. Temporal databases: theory, design, and implementation. Benjamin/Cummings: Publishing Company, Inc.; 1993.Google Scholar
  12. 12.
    Toman D. Point-based temporal extensions of SQL and their efficient implementation. In: [5]; 1997, p. 211–37.CrossRefGoogle Scholar

Copyright information

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

Authors and Affiliations

  • Michael H. Böhlen
    • 1
    • 2
  • Johann Gamper
    • 3
  • Christian S. Jensen
    • 4
  • Richard T. Snodgrass
    • 5
    • 6
  1. 1.Free University of Bozen-BolzanoBozen-BolzanoItaly
  2. 2.University of ZurichZürichSwitzerland
  3. 3.Free University of Bozen-BolzanoBolzanoItaly
  4. 4.Department of Computer ScienceAalborg UniversityAalborgDenmark
  5. 5.Department of Computer ScienceUniversity of ArizonaTucsonUSA
  6. 6.Dataware VenturesTucsonUSA

Section editors and affiliations

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