Semantic assumptions and query evaluation in temporal databases

When querying a temporal database, a user often makes certain semantic assumptions on stored temporal data. This paper formalizes and studies two types of semantic assumptions: point-based and interval-based. The point-based assumptions include those assumptions that use interpolation methods, while the interval-based assumptions include those that involve different temporal types (time granularities). Each assumption is viewed as a way to derive certain implicit data from the explicit data stored in the database. The database system must use all explicit as well as (possibly infinite) implicit data to answer user queries. This paper introduces a new method to facilitate such query evaluations. A user query is translated into a system query such that the answer of this system query over the explicit data is the same as that of the user query over the explicit and the implicit data. The paper gives such a translation procedure and studies the properties (safety in particular) of user queries and system queries.

[1]  Jeffrey D. Ullman,et al.  Principles of Database and Knowledge-Base Systems, Volume II , 1988, Principles of computer science series.

[2]  James Clifford,et al.  On an algebra for historical relational databases: two views , 1985, SIGMOD Conference.

[3]  Drew McDermott,et al.  Temporal Data Base Management , 1987, Artif. Intell..

[4]  Arie Shoshani,et al.  Logical modeling of temporal data , 1987, SIGMOD '87.

[5]  David Scott Warren,et al.  Formal semantics for time in databases , 1982, TODS.

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

[7]  Sushil Jajodia,et al.  Temporal Modules: An Approach Toward Federated Temporal Databases , 1995, Inf. Sci..

[8]  Henry A. Kautz,et al.  Reasoning about plans , 1991, Morgan Kaufmann series in representation and reasoning.

[9]  Abdullah Uz Tansel A statistical interface for historical relational databases , 1987, 1987 IEEE Third International Conference on Data Engineering.

[10]  Sushil Jajodia,et al.  Temporal Databases: Theory, Design, and Implementation , 1993 .

[11]  Sushil Jajodia,et al.  Dealing with Granularity of Time in Temporal Databases , 1991, CAiSE.

[12]  Jeffrey D. Uuman Principles of database and knowledge- base systems , 1989 .

[13]  Jan Chomicki,et al.  History-less checking of dynamic integrity constraints , 1992, [1992] Eighth International Conference on Data Engineering.

[14]  Yoav Shoham,et al.  Temporal Logics in AI: Semantical and Ontological Considerations , 1987, Artif. Intell..

[15]  James Clifford,et al.  On the Semantics of (Bi)Temporal Variable Databases , 1994, EDBT.

[16]  Witold Lukaszewicz,et al.  Reasoning about Plans , 1997, IJCAI.

[17]  Richard Hull,et al.  Safety and translation of calculus queries with scalar functions , 1993, PODS.

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

[19]  Sushil Jajodia,et al.  Temporal modules , 1993, Inf. Sci..