Definition
TSQL2 (Temporal Structured Query Language) is a temporal extension of SQL-92 designed in 1993-1994 by a committee comprised of Richard T. Snodgrass, Ilsoo Ahn, Gad Ariav, Don Batory, James Clifford, Curtis E. Dyreson, Ramez Elmasri, Fabio Grandi, Christian S. Jensen, Wolfgang Käfer, Nick Kline, Krishna Kulkarni, T. Y. Cliff Leung, Nikos Lorentzos, John F. Roddick, Arie Segev, Michael D. Soo and Suryanarayana M. Sripada. The goal of this language design committee was to consolidate past research on temporal query languages, by the committee members as well as many others, by developing a specification for a consensus language that could form a common core for research.
Historical Background
Temporal databases have been an active research topic since 1980. By the early 1990s, several dozen temporal query languages had been proposed, and many temporal database researchers felt that the time had come to consolidate approaches to temporal data models and calculus-based query...
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
Jensen CS, Soo MD, Snodgrass RT. Unifying temporal data models via a conceptual model. Inf Syst. 1994;19(7):513–47.
Melton J, Simon AR. Understanding the new SQL: a complete guide. San Mateo: Morgan Kaufmann; 1993.
Snodgrass RT. editor. In: Proceedings of the International Workshop on an Infrastructure for Temporal Databases; 1993.
Snodgrass RT. editor. The TSQL2 temporal query language. Kluwer Academic; 1995.
Snodgrass RT. Developing time-oriented database applications in SQL. San Francisco: Morgan Kaufmann; 1999.
Snodgrass RT, Ahn I, Ariav G, Batory DS, Clifford J, Dyreson CE, Elmasri R, Grandi F, Jensen CS, Käfer W, Kline N, Kulkarni K, Leung TYC, Lorentzos N, Roddick JF, Segev A, Soo MD, Sripada SM. TSQL2 language specification. ACM SIGMOD Rec. 1994;23(1):65–86.
Snodgrass RT, Ahn I, Ariav G, Batory D, Clifford J, Dyreson CE, Elmasri R, Grandi F, Jensen CS, Käfer W, Kline N, Kulkarni K, Leung TYC, Lorentzos N, Roddick JF, Segev A, Soo MD, Sripada SM. A TSQL2 tutorial. ACM SIGMOD Rec. 1994;23(3):27–33.
Snodgrass RT, Böhlen MH, Jensen CS, Steiner A. Adding transaction time to SQL/temporal. Change proposal, ANSI X3H2-96-502r2, ISO/IEC JTC1/SC21/ WG3 DBL MAD-147r2, Nov 1996.
Snodgrass RT, Böhlen MH, Jensen CS, Steiner A. Adding valid time to SQL/temporal. Change proposal, ANSI X3H2-96-501r2, ISO/IEC JTC1/SC21/ WG3 DBL MAD-146r2, Nov 1996.
Snodgrass RT, Böhlen MH, Jensen CS, Steiner A. Transitioning temporal support in TSQL2 to SQL3. In: Ezion O, Jajodia S, Sripada SM, editors. Temporal databases: research and practice. Berlin: Springer; 1998. p. 150–94.
Snodgrass RT, Kulkarni K, Kucera H, Mattos N. Proposal for a new SQL part – temporal. ISO/IEC JTC1/SC21 WG3 DBL RIO-75, X3H2-94-481, 2 Nov 1994.
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
Snodgrass, R.T. (2018). TSQL2. 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_439
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_439
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