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...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Allen JF. Maintaining knowledge about temporal intervals. Commun ACM. 1983;26(11):832–43.
Böhlen MH, Jensen CS, Snodgrass RT. Temporal statement modifiers. ACM Trans Database Syst. 2000;25(4):407–56.
Clifford J, Tuzhilin A, editors. Recent advances in temporal databases. In: Proceedings of the International Workshop on Temporal Databases; 1995.
Date CJ, Darwen H, Lorentzos N, editors. Temporal data and the relational model. Morgan Kaufmann Publishers; 2002.
Etzion O, Jajodia S, Sripada S, editors. Temporal databases: research and practice. Springer, Volume 1399 of lecture notes in computer science; 1998.
Lorentzos NA, Johnson RG. Extending relational algebra to manipulate temporal data. Inf Syst. 1988;13(3):289–96.
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.
Snodgrass RT, editor. Proceeding of the International Workshop on an Infrastructure for Temporal Databases; 1993.
Snodgrass RT, editor. The TSQL2 temporal query language. Kluwer; 1995.
Snodgrass RT. Developing time-oriented database applications in SQL. San Francisco: Morgan Kaufmann Publishers; 1999.
Tansel A, Clifford J, Gadia S, Jajodia S, Segev A, Snodgrass RT. Temporal databases: theory, design, and implementation. Benjamin/Cummings: Publishing Company, Inc.; 1993.
Toman D. Point-based temporal extensions of SQL and their efficient implementation. In: [5]; 1997, p. 211–37.
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
Böhlen, M.H., Gamper, J., Jensen, C.S., Snodgrass, R.T. (2018). SQL-Based Temporal Query Languages. 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_1525
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1525
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