Evaluating the Completeness of TSQL2

The question of what is a well-designed temporal data model and query language is a difficult, but also an important one. The consensus temporal query language TSQL2 attempts to take advantage of the accumulated knowledge gained from designing and studying many of the earlier models and languages. In this sense, TSQL2 represents a constructive answer to this question. Others have provided analytical answers by developing criteria, formulated as completeness properties, for what is a good model and language.

[1]  James Clifford,et al.  A Temporal Relational Algebra as a Basis for Temporal Relational Completeness , 1990, VLDB.

[2]  Alfred V. Aho,et al.  Universality of data retrieval languages , 1979, POPL.

[3]  Jan Chomicki,et al.  Temporal Query Languages: A Survey , 1994, ICTL.

[4]  Paolo Atzeni,et al.  Completeness of Query Languages for the Entity-Relationship Model , 1981, ER.

[5]  François Bancilhon,et al.  On the Completeness of Query Languages for Relational Data Bases , 1978, MFCS.

[6]  Christian S. Jensen,et al.  The TSQL2 Data Model , 1995, The TSQL2 Temporal Query Language.

[7]  Shashi K. Gadia,et al.  A homogeneous relational model and query languages for temporal databases , 1988, TODS.

[8]  Gultekin Özsoyoglu,et al.  Temporal and Real-Time Databases: A Survey , 1995, IEEE Trans. Knowl. Data Eng..

[9]  Ramez Elmasri,et al.  TSQL2 language specification , 1994, SGMD.

[10]  Arie Segev,et al.  A glossary of temporal database concepts , 1992, SGMD.

[11]  E. F. Codd,et al.  Relational Completeness of Data Base Sublanguages , 1972, Research Report / RJ / IBM / San Jose, California.

[12]  David Harel,et al.  Computable Queries for Relational Data Bases , 1980, J. Comput. Syst. Sci..

[13]  Elizabeth O'Neil,et al.  Database--Principles, Programming, and Performance , 1994 .

[14]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[15]  Albert Croker,et al.  On completeness of historical relational query languages , 1991, TODS.

[16]  C. J. Date.  Relational Database Writings 1991-1994 , 1990 .

[17]  Hans-Jörg Schek,et al.  Remarks on the algebra of non first normal form relations , 1982, PODS.

[18]  Christian S. Jensen,et al.  Proposal for a Data Model for the Temporal Structured Query Language , 1992 .

[19]  James F. Allen.  Maintaining knowledge about temporal intervals , 1983, CACM.

[20]  Suryanarayana M. Sripada.  Temporal Reasoning in Deductive Databases , 1991 .

[21]  Christian S. Jensen,et al.  Unifying Temporal Data Models via a Conceptual Model , 1994, Inf. Syst..

[22]  Michael H. Böhlen.  The Temporal Deductive Database System ChronoLog , 1994 .

[23]  Christian S. Jensen,et al.  Extending Normal Forms to Temporal Relations , 1992 .

[24]  Richard T. Snodgrass,et al.  The TSQL2 Temporal Query Language , 1995 .

[25]  Richard T. Snodgrass,et al.  Evaluation of relational algebras incorporating the time dimension in databases , 1991, CSUR.

[26]  Richard T. Snodgrass,et al.  The temporal query language TQuel , 1984, TODS.

[27]  Alan R. Simon,et al.  Understanding the New SQL: A Complete Guide , 1993 .

[28]  Michael H. Böhlen,et al.  Temporal Logic in Database Query Languages , 2009, Encyclopedia of Database Systems.