Resolution of time concepts in temporal databases

Chakravarthy, Sharma; Kim, Seung-Kyum

doi:10.1016/0020-0255(94)90059-0

Cited by 12 publications

(2 citation statements)

References 11 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…A temporal database handling only transaction time is called a rollback database; one handling valid time only is called a historical database; while one handling both transaction and valid time is called a bitemporal database. However [1,7,11] has shown that one additional time dimension may be needed. [t has been called event time in [1,7] and decision time in [11].…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Indexing a transaction-decision time database

Nascimento

Dunham

1996

Proceedings of the 1996 ACM Symposium on Applied Computing - SAC '96

View full text Add to dashboard Cite

Although most of the research found in the temporal database literature recognizes the need to support valid time and transaction time as temporal attributes, only a few papers have recognized the role of decision (or event) time. Moreover, no indexing technique which encompasses decision time has been presented in the literature. We aim to fill this void by presenting an indexing structure that is able to index both transaction time and decision time under the same framework. This structure is based on a B+-tree. An extension to the proposed structure is presented to more efficiently handle the case where non-temporal data is also used in queries.

show abstract

Section: Introductionmentioning

confidence: 99%

“…However [1,7,11] has shown that one additional time dimension may be needed. [t has been called event time in [1,7] and decision time in [11]. We use either term with the same meaning throughout this paper.…”

Section: Introductionmentioning

confidence: 99%

Indexing a transaction-decision time database

Nascimento

Dunham

1996

Proceedings of the 1996 ACM Symposium on Applied Computing - SAC '96

View full text Add to dashboard Cite

show abstract

Data Models with Multiple Temporal Dimensions: Completing the Picture

Combi

Montanari

2001

Notes on Numerical Fluid Mechanics and Multidisciplinary Design

View full text Add to dashboard Cite

There is a widespread recognition that valid and transaction times are the fundamental temporal dimensions of any fact relative to a database. There are, however, temporal aspects of facts that cannot be naturally modeled by means of them. A remarkable limitation of valid and transaction times is that they do not allow one to distinguish between retroactive and delayed updates. A third temporal dimension, called event time, has been proposed in the literature, which makes it possible to model retroactive, on-time, and proactive updates. In this paper, we first refine the notion of event time by showing that one event time does not suffice to model relevant phenomena, and then we introduce a further temporal dimension, that we called availability time, which can be viewed as the information system counterpart of the real-world event time. We conclude the paper by outlining current and future work directions.

show abstract