Skip to main content
SpringerLink
Log in

Transitioning temporal support in TSQL2 to SQL3

  • Chapter
  • First Online:
Temporal Databases: Research and Practice

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1399))

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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. 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. 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. Gadia, S. K. “A Homogeneous Relational Model and Query Languages for Temporal Databases.” ACM Transactions on Database Systems 13(4):418–448, December 1988.

    Article  MATH  MathSciNet  Google Scholar 

  5. Jackson, M. A. System Development. Prentice-Hall International Series in Computer Science. Prentice-Hall International, Inc., 1983.

    Google Scholar 

  6. Jensen, C. S. and R. Snodgrass, “Temporal Specialization and Generalization.” IEEE Transactions on Knowledge and Data Engineering 6(6):954–974, December 1994.

    Article  Google Scholar 

  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. Melton, J. (ed.) SQL/Temporal. July, 1997. (ISO/IEC JTC 1/SC 21/WG 3 DBLLGW-013.)

    Google Scholar 

  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. Leung

    Article  Google Scholar 

  10. 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. 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. 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. 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. 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: ftp://ftp.cs.arlzona.edu/tsql/tsql2/sql3/madl46.ps(version current November 21, 1996).

    Google Scholar 

  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: ftp://ftp.cs.arizona.edu/tsql/tsql2/sql3/madl47.ps(version current November 21, 1996).

    Google Scholar 

  16. Steiner, A. and M. H. Böhlen. The TimeDB Temporal Database Prototype, Version 1.07, November 1996. At URL: http://www.iesd.auc.dk/ general/DBS/tdb/TimeCenter or at URL: ftp://ftp.cs.arizona.edu/tsql/timecenter/TimeDB.tar.gz(version current March 26, 1997).

    Google Scholar 

  17. Tsotras, V. J. and A. Kumar. “Temporal Database Bibliography Update,” ACM SIGMOD Record 25(1):41–51, March, 1996.

    Google Scholar 

  18. UK SQL Committee, Expanded Table Operations. 1996. (ISO/IEC JTC1/SC21/WG3 DBL MCI-67)

    Google Scholar 

  19. Yourdon, E. Managing the System Life Cycle. Yourdon Press, 1982.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Arizona, 85721, Tucson, AZ, USA

    Richard T. Snodgrass

  2. Department of Mathematics and Computer Science, Aalborg University, Fredrik Bajers Vej 7E, DK-9220, Aalborg Ø, Denmark

    Michael H. Böhlen & Christian S. Jensen

  3. Institut fur Informationssysteme, ETH Zentrum, CH-8092, Zurich, Switzerland

    Andreas Steiner

Authors
  1. Richard T. Snodgrass
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Michael H. Böhlen
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Christian S. Jensen
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Andreas Steiner
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Opher Etzion Sushil Jajodia Suryanarayana Sripada

Rights and permissions

Reprints and permissions

Copyright information

© 1998 Springer-Verlag Berlin Heidelberg

About this chapter

Cite this chapter

Snodgrass, R.T., Böhlen, M.H., Jensen, C.S., Steiner, A. (1998). Transitioning temporal support in TSQL2 to SQL3. In: Etzion, O., Jajodia, S., Sripada, S. (eds) Temporal Databases: Research and Practice. Lecture Notes in Computer Science, vol 1399. Springer, Berlin, Heidelberg. https://doi.org/10.1007/BFb0053702

Download citation

  • DOI: https://doi.org/10.1007/BFb0053702

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-64519-1

  • Online ISBN: 978-3-540-69799-2

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation