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 via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsRecommended 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