Advertisement

SQL/TP: A Temporal Extension of SQL

  • David Toman
Chapter

Abstract

Research in the area of temporal databases and query languages has produced a large number of proposals for temporal extensions of SQL; however, none of these proposals has been used in commercial database management systems nor become a basis for foundations of temporal database theory. The failure of these proposals can often be traced to overly complex syntax and unclear, ad hoc, and/or poorly defined semantics.

Keywords

Temporal Attribute Query Language Query Evaluation Temporal Extension Temporal Database 
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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Bibliographic Notes

  1. [Cho94]
    J. Chomicki. Temporal query languages: A survey. In D. M. Gabbay and H. J. Ohlbach, editors, Proceedings 1st International Conference on Temporal Logics (ICTL’94), volume 827 of Lecture Notes in Computer Science, pages 506–534. Springer-Verlag, 1994.Google Scholar
  2. [SBJS96]
    R. T. Snodgrass, M. H. Böhlen, C. S. Jensen, and A. Steiner. Adding valid time to SQL/Temporal. ISO/IEC JTC1/SC21/WG3 DBL MAD-146r2 21/11/96, (change proposal), International Organization for Standardization, 1996.Google Scholar
  3. [Sno95]
    R. T. Snodgrass, editor. The TSQL2 Temporal Query Language. Kluwer Academic Publishers, 1995.Google Scholar
  4. [Tom97]
    D. Toman. Point-based temporal extension of temporal SQL. In 5th International Conference on Deductive and Object-Oriented Databases (DOOD’97), volume 1341 of Lecture Notes in Computer Science, pages 103–121. Springer-Verlag, 1997.Google Scholar
  5. [BSS96]
    M. Böhlen, R. T. Snodgrass, and M. D. Soo. Coalescing in temporal databases. In Proceedings of the 22nd International Conference on Very Large Data Bases (VLDB’96), pages 180–191. Morgan Kaufmann, 1996.Google Scholar
  6. [TN96]
    D. Toman and D. Niwinski. First-order queries over temporal databases inexpressible in temporal logic. In Proceedings of the 5th International Conference on Extending Database Technology (EDBT’96), volume 1057 of Lecture Notes in Computer Science, pages 307–324. Springer-Verlag, 1996.Google Scholar
  7. [AHV99]
    S. Abiteboul, L. Herr, and J. Van den Bussche. Temporal connectives versus explicit timestamps to query temporal databases. Journal of Computer and System Sciences, 58: 54–68, 1999.MathSciNetMATHCrossRefGoogle Scholar
  8. [CT98]
    J. Chomicki and D. Toman. Temporal logic in information systems. In J. Chomicki and G Saake, editors, Logics for Databases and Information Systems, chapter 3, pages 31–70. Kluwer Academic Publishers, 1998.Google Scholar
  9. [Tom98]
    D. Toman. Point-based temporal extensions of SQL and their efficient implementation. In O. Etzion, S. Jajodia, and S. Sripada, editors, Temporal Databases: Research and Practice, volume 1399 of Lecture Notes in Computer Science, pages 211–237. Springer-Verlag, 1998.Google Scholar
  10. [LM97]
    N. A. Lorentzos and Y. G. Mitsopoulos. SQL extension for interval data. IEEE Transactions on Knowledge and Data Engineering (TKDE), 9 (3): 480–499, 1997.CrossRefGoogle Scholar
  11. [Tom96]
    D. Toman. Point vs. interval-based query languages for temporal databases. In Proceedings of the 15th ACM SIGACT-SIGMODSIGART Symposium on Principles of Database Systems (PODS’96), pages 58–67. ACM Press, 1996.Google Scholar
  12. [Tom97]
    D. Toman. Point-based temporal extension of temporal SQL. In 5th International Conference on Deductive and Object-Oriented Databases (DOOD’97), volume 1341 of Lecture Notes in Computer Science, pages 103–121. Springer-Verlag, 1997.Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2000

Authors and Affiliations

  • David Toman

There are no affiliations available

Personalised recommendations