A generalized model for a relational temporal database

Abstract

We propose a generalized relational model for a temporal database which allows time stamping with respect to a Boolean algebra of multidimensional time stamps. The interplay between the various temporal dimensions is symmetric. As an application, a two dimensional model which allows objects with real world and transaction oriented time stamps is discussed. The two dimensional model can be used to query the past states of the database. It can also be used to give a precise classification of the errors and updates in a database, and is a promising approach for querying these errors and updates.

PENDS: an approach to modeling and retrieving “pending” information

“…This paper expands the previous work on temporal data modeling ( [I], [6], [7], [9], [lo], [ll], [5], [8], [4], [7], [2] ) by including the pending (or future-temporal) dimension. We extend the Temporal Extended ER (TEER) Model [4] the GORDAS ER query and update language, and describe how futuristic data can be defined and manipulated.…”

The event matching language for querying temporal data

“…Gadia and Yeung [6] introduced shift(A), an operator that shifts the values taken by an attribute by one instant to the right. Then, the construct ½ ½ A 6 ¼ shift(A) in TempSQL retrieves the instants where there is a change in the value of A.…”

Temporal coalescing with now granularity, and incomplete information

“…The special time now is commonplace in temporal database research [7,14,23,25]. It is used to represent the ever-changing current time.…”