A historical relational data model for managing temporal data
From Semantic Portal Wiki
{{#vardefine:category|Publication}}{{#vardefine:templatename|i.publication}}{{#vardefine:package|smwbp_instance_templates}}
| Edit |
Reference: {{#vardefine:pagename|a historical relational data model for managing temporal data }}
- [[]]
bibtex
{{#vardefine:pagename|A historical relational data model for managing temporal data }}{{#vardefine:key| }}
abstract: 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.
download:
- paper:
- slides:
| 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. |
| Address | San Diego, CA + |
| Author | Amar K. Das +, Samson W. Tu +, and Mark A. Musen + |
| Bibtype | techreport + |
| Institution | Knowledge Systems, AI Laboratory + |
| Key | KSL-91-77 + |
| Note | Updated June 1993. + |
| Number | KSL-91-77 + |
| Tag | Computer science + |
| Title | A Historical Relational Data Model for Managing Temporal Data + |
| Tr id | KSL-91-77 + |
| Year | 1992 + |
