Representing retroactive and proactive versions in bi-temporal databases (2TDB)

Author

Won, Jongho ; Elmasri, Ramez

Author_Institution

Dept. of Comput. Sci. & Eng., Texas Univ., Arlington, TX, USA

fYear

1996

fDate

26 Feb-1 Mar 1996

Firstpage

85

Lastpage

94

Abstract

Bi temporal databases allow users to record retroactive (past) and proactive (future planned) versions of an entity, and to retrieve the appropriate versions for bi temporal queries that involve both valid time and transaction time. Currently used timestamp representations are mainly for either valid time or transaction time databases. We first categorize the types of problems that can occur in existing models. These are: ambiguity; priority specification; and lost information. We then propose a 2TDB model that allows both retroactive and proactive versions, overcomes the identified problems, and permits the correction of recorded facts

Keywords

query processing; temporal databases; 2TDB; ambiguity; bi temporal databases; bi temporal queries; lost information; priority specification; proactive versions; recorded facts; retroactive versions; timestamp representations; transaction time; transaction time databases; valid time; Computer science; Data engineering; Database languages; Information retrieval; Transaction databases;

fLanguage

English

Publisher

ieee

Conference_Titel

Data Engineering, 1996. Proceedings of the Twelfth International Conference on

Conference_Location

New Orleans, LA

ISSN

1063-6382

Print_ISBN

0-8186-7240-4

Type

conf

DOI

10.1109/ICDE.1996.492092

Filename

492092