A temporal database management system implemented on top of a conventional database

Abstract

Temporal data models have proven to be convenient to specify applications, allowing the representation of the temporal evolution of data. Several temporal data models were proposed in the last 20 years with this purpose, but no commercial implementation of a Temporal Database is still available. This paper presents an Integrated Temporal Database Environment implemented on top of a conventional database. Using this environment, a user can handle the specification, the data definition and the queries as thought the database implements the temporal data model. The environment performs the mapping from the temporal conceptual schema to the correspondent database, and of the queries expressed in the temporal query language to SQL. Data definition is controlled based on the state transition rules of the temporal data model, keeping thus the temporal integrity of the database. The underlying conventional database keeps transparent to the user. * This work was partially supported by CNPq -Brazil 0-7695-0810-3/00 $10.00 0 2000 IEEE

Adding Time to an Object-Oriented Versions Model1

“…However, very few implemented temporal systems are available. A feasible way of implementing a temporal database is to map the temporal data model to a conventional commercial database [3,16,17,18,20].…”