Encyclopedia of Database Systems

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

TSQL2

  • Richard T. Snodgrass
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_439

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 to check access.

Recommended Reading

  1. 1.
    Jensen CS, Soo MD, Snodgrass RT. Unifying temporal data models via a conceptual model. Inf Syst. 1994;19(7):513–47.CrossRefGoogle Scholar
  2. 2.
    Melton J, Simon AR. Understanding the new SQL: a complete guide. San Mateo: Morgan Kaufmann; 1993.Google Scholar
  3. 3.
    Snodgrass RT. editor. In: Proceedings of the International Workshop on an Infrastructure for Temporal Databases; 1993.Google Scholar
  4. 4.
    Snodgrass RT. editor. The TSQL2 temporal query language. Kluwer Academic; 1995.Google Scholar
  5. 5.
    Snodgrass RT. Developing time-oriented database applications in SQL. San Francisco: Morgan Kaufmann; 1999.Google Scholar
  6. 6.
    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.CrossRefGoogle Scholar
  7. 7.
    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.CrossRefGoogle Scholar
  8. 8.
    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.Google Scholar
  9. 9.
    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.Google Scholar
  10. 10.
    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.CrossRefGoogle Scholar
  11. 11.
    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.Google Scholar

Copyright information

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

Authors and Affiliations

  1. 1.Department of Computer ScienceUniversity of ArizonaTucsonUSA
  2. 2.Dataware VenturesTucsonUSA

Section editors and affiliations

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