Transitioning temporal support in TSQL2 to SQL3

  • Richard T. Snodgrass
  • Michael H. Böhlen
  • Christian S. Jensen
  • Andreas Steiner
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1399)


This document summarizes the proposals before the SQL3 committees to allow the addition of tables with valid-time and transactiontime support into SQL/Temporal, and explains how to use these facilities to migrate smoothly from a conventional relational system to one encompassing temporal support. Initially, important requirements to a tdiscussed. The proposal then describes the language additions necessary emporal system that may facilitate such a transition are motivated and to add valid-time support to SQL3 while fulfilling these requirements. The constructs of the language are divided into four levels, with each level adding increased temporal functionality to its predecessor. A prototype system implementing these constructs on top of a conventional DBMS is publicly available.


Valid Time Temporal Database Temporal Support Transaction Time Period Expression 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bair, J., M. Böhlen, C.S. Jensen, and R.T. Snodgrass, “Notions of Upward Compatibility of Temporal Query Languages,” Business Informatics (in German, Wirtschaftsinformatik) 39(l):25–34, February 1997.Google Scholar
  2. 2.
    Böhlen, M. H., C. S. Jensen and R. T. Snodgrass,. “Evaluating the Completeness of TSQL2,” in Proceedings of the VLDB International Workshop on Temporal Databases. Ed. J. Clifford and A. Tuzhilin. Springer Verlag, September 1995, pp. 153–172.Google Scholar
  3. 3.
    Böhlen, M. H. and C. S. Jensen. Seamless Integration of Time into SQL. Technical Report R-962049, Aalborg University, Department of Computer Science, Denmark, December 1996.Google Scholar
  4. 4.
    Gadia, S. K. “A Homogeneous Relational Model and Query Languages for Temporal Databases.” ACM Transactions on Database Systems 13(4):418–448, December 1988.zbMATHCrossRefMathSciNetGoogle Scholar
  5. 5.
    Jackson, M. A. System Development. Prentice-Hall International Series in Computer Science. Prentice-Hall International, Inc., 1983.Google Scholar
  6. 6.
    Jensen, C. S. and R. Snodgrass, “Temporal Specialization and Generalization.” IEEE Transactions on Knowledge and Data Engineering 6(6):954–974, December 1994.CrossRefGoogle Scholar
  7. 7.
    Jensen, C. S., J. Clifford, R. Elmasri, S. K. Gadia, P. Hayes and S. Jajodia (eds). “A Glossary of Temporal Database Concepts.” ACM SIGMOD Record 23(l):52–64, March 1994.Google Scholar
  8. 8.
    Melton, J. (ed.) SQL/Temporal. July, 1997. (ISO/IEC JTC 1/SC 21/WG 3 DBLLGW-013.)Google Scholar
  9. 9.
    Pissinou, N., R. T. Snodgrass, R. Elmasri, I. S. Mumick, M. T. özsu, B. Pernici, A. Segev, and B. Theodoulidis, “Towards an Infrastructure for Temporal Databases: Report of an Invitational ARPA/NSF Workshop,” SIGMOD Record 23(1):35–51, March, 1994. 10. Snodgrass, R.T., I. Ahn, G. Ariav, D.S. Batory, J. Clifford, CE. Dyreson, R. Elmasri, F. Grandi, C.S. Jensen, W. KÄfer, N. Kline, K. Kulkarni, T.Y.C. LeungCrossRefGoogle Scholar
  10. N.
    Lorentzos, J.F. Roddick, A. Segev, M.D. Soo, and S.M. Sripada. “TSQL2 Language Specification,” ACM SIGMOD Record 23(l):65–86, March, 1994.Google Scholar
  11. 11.
    Snodgrass, R. T. and H. Kucera. Rationale for Temporal Support in SQL3. 1994. (ISO/IEC JTC1/SC21/WG3 DBL SOU-177, SQL/MM SOU-02.)Google Scholar
  12. 12.
    Snodgrass, R. T., K. Kulkarni, H. Kucera and N. Mattos. Proposal for a new SQL Part—Temporal. 1994. (ISO/IEC JTC1/SC21/WG3 DBL RIO-75, X3H2-94-481.)Google Scholar
  13. 13.
    Snodgrass, R. T. (editor), 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 Temporal Query Language TSQL2. Kluwer Academic Pub., 1995.Google Scholar
  14. 14.
    Snodgrass, R. T., M. H. Böhlen, C. S. Jensen and A. Steiner. Adding Valid Time to SQL/Temporal, change proposal, ANSI X3H2-96-501r2, ISO/IEC JTC 1/SC 21/WG 3 DBL-MAD-146r2, November 1996, 77 pages. At URL: current November 21, 1996).Google Scholar
  15. 15.
    Snodgrass, R. T., M. H. Böhlen, C. S. Jensen and A. Steiner. Adding Transaction Time to SQL/Temporal, change proposal, ANSI X3H2-96-502r2, ISO/IEC JTC1/SC21/WG3 DBL MAD-147r2, November 1996, 47 pages. At URL: current November 21, 1996).Google Scholar
  16. 16.
    Steiner, A. and M. H. Böhlen. The TimeDB Temporal Database Prototype, Version 1.07, November 1996. At URL: general/DBS/tdb/TimeCenter or at URL: current March 26, 1997).Google Scholar
  17. 17.
    Tsotras, V. J. and A. Kumar. “Temporal Database Bibliography Update,” ACM SIGMOD Record 25(1):41–51, March, 1996.Google Scholar
  18. 18.
    UK SQL Committee, Expanded Table Operations. 1996. (ISO/IEC JTC1/SC21/WG3 DBL MCI-67)Google Scholar
  19. 19.
    Yourdon, E. Managing the System Life Cycle. Yourdon Press, 1982.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • Richard T. Snodgrass
    • 1
  • Michael H. Böhlen
    • 2
  • Christian S. Jensen
    • 2
  • Andreas Steiner
    • 3
  1. 1.Department of Computer ScienceUniversity of ArizonaTucsonUSA
  2. 2.Department of Mathematics and Computer ScienceAalborg UniversityAalborg ØDenmark
  3. 3.Institut fur InformationssystemeETH ZentrumZurichSwitzerland

Personalised recommendations