The Historical Relational Data Model (Hrdm) and Algebra Based on Lifespans
26 Pages Posted: 31 Oct 2008
Date Written: June 1986
Abstract
Critical to the design of an historical database model is the representation of the â¬ÂSexistenceâ¬Â?of objects across the temporal dimension -- for example, the "birth," "death," or "rebirth" ofan individual, or the establishment or dis-establishment of a relationship. The notion of the"lifespan" of a database object is proposed as a simple framework for expressing these concepts.An object's lifespan is simply those periods of time during which the database models theproperties of that object. In this paper we propose the historical relational data model (HRDM)and algebra that is based upon lifespans and that views the values of all attributes as functionsfrom time points to simple domains. The model that we obtain is a consistent extension of therelational data model, and provides a simple mechanism for providing both time-varying dataand time-varying schemes.
Suggested Citation: Suggested Citation
Do you have negative results from your research you’d like to share?
Recommended Papers
-
Formal Semantics for Time in Databases
By James Clifford and David S. Warren
-
A Temporal Relational Algebra as a Basis for Temporal Relational Completeness
By Alexander Tuzhilin and James Clifford
-
On Completeness of Historical Relational Data Models
By Albert Croker and James Clifford
-
On Completeness of Historical Relational Query Languages
By James Clifford, Albert Croker, ...
-
Search and Preference-Based Navigation in Electronic Shopping
-
Natural Language Querying of Historical Databases -- the Qe-Iii Language Definition and Examples
-
A Simple, General Structure for Temporal Domains
By James Clifford and Ahobala Rao