On Data Representation and Use in a Temporal Relational DBMS

James Clifford, Albert Croker and Alexander Tuzhilin
Additional contact information
James Clifford: Information Systems Department, Stern School of Business, New York University, New York, New York 10012
Albert Croker: Statistics and Computer Information Systems, Baruch College, City University of New York, New York, New York 10010
Alexander Tuzhilin: Information Systems Department, Stern School of Business, New York University, New York, New York 10012

Information Systems Research, 1996, vol. 7, issue 3, 308-327

Abstract: Numerous proposals for extending the relational data model to incorporate the temporal dimension of data have appeared over the past decade. It has long been known that these proposals have adopted one of two basic approaches to the incorporation of time into the extended relational model. Recent work formally contrasted the expressive power of these two approaches, termed temporally ungrouped and temporally grouped , and demonstrated that the temporally grouped models are more expressive. In the temporally ungrouped models, the temporal dimension is added through the addition of some number of distinguished attributes to the schema of each relation, and each tuple is “stamped” with temporal values for these attributes. By contrast, in temporally grouped models the temporal dimension is added to the types of values that serve as the domain of each ordinary attribute, and the application's schema is left intact. The recent appearance of TSQL2, a temporal extension to the SQL-92 standard based upon the temporally ungrouped paradigm, means that it is likely that commercial DBMS's will be extended to support time in this weaker way. Thus the distinction between these two approaches---and its impact on the day-to-day user of a DBMS---is of increasing relevance to the database practitioner and the database user community. In this paper we address this issue from the practical perspective of such a user. Through a series of example queries and updates, we illustrate the differences between these two approaches and demonstrate that the temporally grouped approach more adequately captures the semantics of historical data.

Keywords: temporal relational databases; temporal query languages; temporal grouping; temporal relational completeteness (search for similar items in EconPapers)
Date: 1996
References: Add references at CitEc
Citations:

Downloads: (external link)
http://dx.doi.org/10.1287/isre.7.3.308 (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:inm:orisre:v:7:y:1996:i:3:p:308-327

Access Statistics for this article

More articles in Information Systems Research from INFORMS Contact information at EDIRC.
Bibliographic data for series maintained by Chris Asher (casher@informs.org).