KSL-91-77 + redirect page
A Historical Relational Data Model for Managing Temporal Data + Has identifier
A Historical Relational Data Model for Managing Temporal Data + Ksl tr id
A Historical Relational Data Model for Managing Temporal Data + Number
| A Historical Relational Data Model for Managing Temporal Data |
Bibtype
techreport
Has publishing details
1992
Has title
A Historical Relational Data Model for Managing Temporal Data
Has where published
KSL-91-77
Has year
1992
Title
A Historical Relational Data Model for Managing Temporal Data
Year
1992
Abstract
In this paper, we develop a historical rel … In this paper, we develop a historical relational data model by extending the standard relational data model with operations on temporal data. The historical relational data model uses the time point as the basis for representing both events and states. We store an event occurrence as an interval bounded by lower and upper time points, and we store a state as an interval bounded by start and stop events. The data model thus provides interval stamping of tuples in the relations for both events and states. We develop a set of temporal operations on time points and intervals as the basis for understanding a proper relational algebra for historical relations. We also show how the operators in the historical relational algebra are used to execute an extended SQL for the historical relational database. QL for the historical relational database.
Note
Updated June 1993.
Address
San Diego, CA +
Author
Amar K. Das and Samson W. Tu and Mark A. Musen +
Has author
Amar K. Das and Samson W. Tu and Mark A. Musen +
Has identifier
A Historical Relational Data Model for Managing Temporal Data +
Institution
Knowledge Systems, AI Laboratory +
Ksl tr id
A Historical Relational Data Model for Managing Temporal Data +
Number
A Historical Relational Data Model for Managing Temporal Data +
Process note
YES +
Categories KSL Technical Report +, Publication +, Technical Report +
|
