The t4sql temporal query language

ABSTRACT

Time characterizes every aspect of our life and its management when storing and querying data is very important. In this paper we propose a new temporal query language, called T4SQL, supporting multiple temporal dimensions of data. Besides the well-known valid and transaction times, it encompasses two additional temporal dimensions, namely, availability and event times. The availability time records when information is known and treated as true by the information system; the event times record the occurrence times of both the event that starts the valid time and the event that ends it. T4SQL is capable to deal with different temporal semantics (atemporal aka non-sequenced, current, sequenced, next) with respect to every temporal dimension. Moreover, T4SQL provides a novel temporal grouping clause and an orthogonal management of temporal properties when defining the selection condition(s) and the schema for the output relation.

REFERENCES

• 1: Sharma Chakravarthy , Seung-Kyum Kim, Resolution of time concepts in temporal databases, Information Sciences—Informatics and Computer Science: An International Journal, v.80 n.1-2, p.91-125, Sept. 1994 [doi>10.1016/0020-0255(94)90059-0]
• 2: Cindy Xinmin Chen, Jiejun Kong, and Carlo Zaniolo. Design and implementation of a temporal extension of SQL. In Umeshwar Dayal, Krithi Ramamritham, and T. M. Vijayaraman, editors, ICDE, pages 689--691. IEEE Computer Society, 2003.
• 3: Carlo Combi , Angelo Montanari, Data Models with Multiple Temporal Dimensions: Completing the Picture, Proceedings of the 13th International Conference on Advanced Information Systems Engineering, p.187-202, June 04-08, 2001
• 4: Andrew Eisenberg , Jim Melton, SQL standardization: the next steps, ACM SIGMOD Record, v.29 n.1, p.63-67, March 2000 [doi>10.1145/344788.344819]
• 5: Christian S. Jensen et al. The consensus glossary of temporal database concepts - February 1998 version. In Temporal Databases, Dagstuhl, pages 367--405, 1998.
• 6: Fabio Grandi , Federica Mandreoli , Paolo Tiberio, Temporal modelling and management of normative documents in XML format, Data & Knowledge Engineering, v.54 n.3, p.327-354, September 2005 [doi>10.1016/j.datak.2004.11.002]
• 7: James Green and Roger Johnson. ProSQL: A prototyping tool for SQL temporal language extensions. In Anne E. James, Brian Lings, and Muhammad Younas, editors, BNCOD, volume 2712 of LNCS, pages 190--197. Springer, 2003.
• 8: Keith W. Hare. JCC's SQL standards page. (accessed: September 1, 2006). http://www.jcc.com/sql.htm, February, 2006.
• 9: C. S. Jensen , Richard Thomas Snodgrass, Temporal Specialization and Generalization, IEEE Transactions on Knowledge and Data Engineering, v.6 n.6, p.954-974, December 1994 [doi>10.1109/69.334885]
• 10: Gultekin Ozsoyoglu , Richard Thomas Snodgrass, Temporal and Real-Time Databases: A Survey, IEEE Transactions on Knowledge and Data Engineering, v.7 n.4, p.513-532, August 1995 [doi>10.1109/69.404027]
• 11: Richard Thomas Snodgrass, The TSQL2 Temporal Query Language, Kluwer Academic Publishers, Norwell, MA, 1995
• 12: Richard Thomas Snodgrass, Developing time-oriented database applications in SQL, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1999
• 13: Richard T. Snodgrass, Michael H. Böhlen, Christian S.Jensen, and Andreas Steiner. Transitioning temporal support in TSQL2 to SQL3. In Temporal Databases, Dagstuhl, pages 150--194, 1997.
• 14: Jose R. Rios Viqueira , Nikos A. Lorentzos, SQL extension for spatio-temporal data, The VLDB Journal — The International Journal on Very Large Data Bases, v.16 n.2, p.179-200, April 2007 [doi>10.1007/s00778-005-0161-9]
• 15: Esteban Zimányi, Temporal aggregates and temporal universal quantification in standard SQL, ACM SIGMOD Record, v.35 n.2, p.16-21, June 2006 [doi>10.1145/1147376.1147379]

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.3 Languages
          Subjects: Query languages

Additional Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.1 Logical Design
          Subjects: Data models

General Terms:
Languages

Keywords:
sql, temporal query language