A Temporal Database Illustration Using TimeDB

Document Type

Project

Authors

Daniel Broten, Grand Valley State University

Lead Author Type

CIS Masters Student

Advisors

Dr. Jamal Alsabbagh, alsabbaj@gvsu.edu

Embargo Period

3-25-2014

Abstract

In traditional databases, the state of the database at any moment in time represents a snapshot of the enterprise of interest. In such databases, historical information can also be stored but requires the designer to explicitly include additional attributes in order to represent the times at which each data value was created, modified, or deleted. Furthermore, SQL queries that attempt to access historical data need to explicitly reference these time attributes. In contrast, temporal databases provide the primitives that abstract the references to time thereby allowing for a more natural interface to the temporal characteristics of data.

This project demonstrates the use of TimeDB [Ste98] as a front-end temporal extension to Oracle 11g.

ScholarWorks Citation

Broten, Daniel, "A Temporal Database Illustration Using TimeDB" (2013). Technical Library. 168.
https://scholarworks.gvsu.edu/cistechlib/168