A Historical Relational Data Model for Managing Temporal Data

Citation: Amar K. Das and Samson W. Tu and Mark A. Musen. (1992) A Historical Relational Data Model for Managing Temporal Data. In , 1992.

Publication techreport ( Edit )
type	Technical Report
bibtype	techreport
Bibtex basics
author	Amar K. Das and Samson W. Tu and Mark A. Musen
title	A Historical Relational Data Model for Managing Temporal Data
number	KSL-91-77
institution	Knowledge Systems, AI Laboratory
address	San Diego, CA
year	1992
Bibtex more
note	Updated June 1993.
Access Paper
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.

KSL Technical Report ID: KSL-91-77

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 and Samson W. Tu and Mark A. Musen +
Bibtype	techreport +
Has author	Amar K. Das and Samson W. Tu and Mark A. Musen +
Has identifier	KSL-91-77 +
Has publishing details	1992 +
Has title	A Historical Relational Data Model for Managing Temporal Data +
Has year	1992 +
Institution	Knowledge Systems, AI Laboratory +
Ksl tr id	KSL-91-77 +
Note	Updated June 1993. +
Number	KSL-91-77 +
Process note	YES +
Title	A Historical Relational Data Model for Managing Temporal Data +
Year	1992 +