The Historical Relational Data Model (Hrdm) and Algebra Based on Lifespans

26 Pages Posted: 31 Oct 2008

See all articles by James Clifford

James Clifford

affiliation not provided to SSRN

Albert Croker

City University of New York (CUNY) - Paul H. Chook Department of Information Systems & Statistics

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

Clifford, James and Croker, Albert, The Historical Relational Data Model (Hrdm) and Algebra Based on Lifespans (June 1986). NYU Working Paper No. IS-86-19, Available at SSRN: https://ssrn.com/abstract=1290080

James Clifford

affiliation not provided to SSRN

Albert Croker

City University of New York (CUNY) - Paul H. Chook Department of Information Systems & Statistics ( email )

17 Lexington Avenue
New York, NY 10010
United States

Do you have negative results from your research you’d like to share?

Paper statistics

Downloads
128
Abstract Views
1,368
Rank
400,044
PlumX Metrics