The formal semantics of the timeER model

A wide range of database applications manage information that varies over time. Many of the underlying database schemas of these were designed using one of the several versions of the Entity-Relationship (ER) model. In the research community as well as in industry, it is common knowledge that the temporal aspects of the mini-world are pervasive and important, but are also difficult to capture using the ER model. Not surprisingly, several enhancements to the ER model have been proposed in an attempt to more naturally and elegantly support the modeling of temporal aspects of information. Common to most of the existing temporally extended ER models is that the semantics of the models are unclear. This problem is addressed in this paper by developing a formal semantics for the TIMEER model based on denotational semantics.

[1]  Stephen Ferg.  Modelling the Time Dimension in an Entity-Relationship Diagram , 1985, ER.

[2]  Stefano Spaccapietra,et al.  TERC+ : a temporal conceptual model , 1997 .

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

[4]  Curtis E. Dyreson,et al.  The Baseline Clock , 1995, The TSQL2 Temporal Query Language.

[5]  Vincent S. Lai,et al.  Temporal databases: model design and commercialization prospects , 1994, DATB.

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

[7]  Ramez Elmasri,et al.  Semantics of Temporal Data in an Extended ER Model , 1990, International Conference on Conceptual Modeling.

[8]  Christian S. Jensen,et al.  Temporal Entity-RelationshipModels | a Survey , 1996 .

[9]  Sonia Bergamaschi,et al.  Chrono: A Conceptual Design Framework for Temporal Entities , 1998, ER.

[10]  Christian S. Jensen,et al.  Conceptual Modeling of Time-Varying Information , 2004, CCCT.

[11]  Ramez Elmasri,et al.  An EER-Based Conceptual Model and Query Language for Time-Series Data , 1998, ER.

[12]  Martin Gogolla,et al.  Towards a semantic view of an extended entity-relationship model , 1991, TODS.

[13]  Christian S. Jensen,et al.  Temporally Enhanced Database Design , 2000, Advances in Object-Oriented Data Modeling.

[14]  Heidi Gregersen,et al.  TimeER plus: A Temporal EER Model Supporting Schema Changes , 2005, BNCOD.

[15]  Peter Kraft,et al.  Translation of a High-Level Temporal Model into Lower Level Models: Impact of Modelling at Different Description Levels , 2001, ER.

[16]  Pericles Loucopoulos,et al.  A conceptual modelling formalism for temporal database applications , 1991, Inf. Syst..

[17]  Richard T. Snodgrass,et al.  Augmenting a conceptual model with geospatiotemporal annotations , 2004, IEEE Transactions on Knowledge and Data Engineering.

[18]  Steven P. Reiss,et al.  A Data Model for Object-Oriented Databases , 1992 .

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

[20]  R. Snodgrass,et al.  A Taxonomy of Time in Databases March , 1985 · ' , 1985 .

[21]  Branka Tauzovich,et al.  Towards Temporal Extensions to the Entity-Relationship Model , 1991, International Conference on Conceptual Modeling.

[22]  Benkt Wangler,et al.  An Entity-Relationship Model Extended to Describe Historical Informatopm , 1992, CISMOD.

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

[24]  Ramez Elmasri,et al.  The Consensus Glossary of Temporal Database Concepts - February 1998 Version , 1997, Temporal Databases, Dagstuhl.