Temporal databases: model design and commercialization prospects

This article presents a Temporal Enhanced Entity-Relationship (TEER) model, which shows how temporal information can be captured within a conceptual data model and extended to the relational data model. The time elements proposed for the TEER model include both transaction time and valid time. In order to support time-related queries, the query language SQL has been extended for definition, retrieval, and control of historical relations. For the commercialization of temporal databases, several technical and non-technical issues need to be resolved. This article provides a discussion of these issues and evaluates its progress toward commercialization.

[1]  Ramez Elmasri,et al.  A temporal model and query language for ER databases , 1990, [1990] Proceedings. Sixth International Conference on Data Engineering.

[2]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.

[3]  David A. Bell,et al.  Modelling and Managing Time in Database Systems , 1992, Comput. J..

[4]  E. F. Codd,et al.  A Relational Model for Large Shared Data Banks , 1970 .

[5]  llsoo Ahn,et al.  Temporal Databases , 1986, Computer.

[6]  Manfred R. Klopprogge,et al.  TERM: An Approach to Include Time Dimension in the Entity-Relationship Model , 1981, ER.

[7]  Jacov Ben-Zvi,et al.  The time relational model , 1982 .

[8]  Roger G. Johnson,et al.  Extending relational algebra to manipulate temporal data , 1988, Inf. Syst..

[9]  Peter P. Chen.  The Entity-Relationship Model: Towards a unified view of Data , 1976 .

[10]  Peter P. Chen.  The entity-relationship model: toward a unified view of data , 1975, VLDB '75.

[11]  Shamkant B. Navathe,et al.  A Temporal Relational Model and a Query Language , 1989, Inf. Sci..

[12]  David Scott Warren,et al.  Formal semantics for time in databases , 1982, TODS.

[13]  Abdullah Uz Tansel,et al.  Adding time dimension to relational model and extending relational algebra , 1986, Inf. Syst..

[14]  Richard T. Snodgrass,et al.  Temporal databases status and research directions , 1990, SGMD.

[15]  Nandlal L. Sarda,et al.  Extensions to SQL for Historical Databases , 1990, IEEE Trans. Knowl. Data Eng..

[16]  Gio Wiederhold,et al.  Structured organization of clinical data bases , 1899, AFIPS '75.

[17]  Gad Ariav,et al.  A temporally oriented data model , 1986, TODS.

[18]  Alan R. Simon,et al.  Understanding the New SQL: A Complete Guide , 1993 .

[19]  Shashi K. Gadia,et al.  A homogeneous relational model and query languages for temporal databases , 1988, TODS.

[20]  TanselAbdullah Uz.  Adding time dimension to relational model and extending relational algebra , 1986 .

[21]  James Clifford,et al.  On an algebra for historical relational databases: two views , 1985, SIGMOD Conference.

[22]  Helmut Thoma,et al.  Buchbesprechung: Elmasri, Ramez; Navathe, Shamkant B.: Fundamentals of Database Systems, Benjamin/Cummings, 1989 , 1991, Datenbank Rundbr..

[23]  Shashi K. Gadia,et al.  A generalized model for a relational temporal database , 1988, SIGMOD '88.

[24]  Sushil Jajodia,et al.  Temporal Databases: Theory, Design, and Implementation , 1993 .

[25]  Ramez Elmasri,et al.  Fundamentals of Database Systems , 1989 .