Abstract
A wide range of database applications manage information that varies over time. The conceptual modeling of databases is frequently based on one of the several versions of the ER model. As this model does not provide built-in means for capturing temporal aspects of data, the resulting diagrams are unnecessarily obscure and inadequate for documentation purposes. The TimeER model extends the ER model with suitable constructs for modeling time-varying information, easing the design process, and leading to easy-to-understand diagrams. In a temporal ER model, support for the specification of advanced temporal constraints would be desiderable, allowing the designer to specify, e.g., that the value of an attribute must not change over time. This paper extends the TimeER model by introducing the notation, and the associated semantics, for the specification of new temporal constraints.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 2nd edn., Benjamin/Cummings (1994)
Gregersen, H.: TimeERplus: A Temporal EER Model Supporting Schema Changes. In: Jackson, M., Nelson, D., Stirk, S. (eds.) BNCOD 2005. LNCS, vol. 3567, pp. 41–59. Springer, Heidelberg (2005)
Gregersen, H.: The Formal Semantics of the TimeER model. In: 3rd Asia-Pacific Conference on Conceptual Modelling, vol. 53, pp. 35–44. Australian Computer Society, Hobart (2006)
Gregersen, H., Mark, L., Jensen, C.S.: Mapping Temporal ER Diagrams to Relational Schemas. Technical report TR–39, TimeCenter (1998)
Gregersen, H., Jensen, C.S.: On the Ontological Expressiveness of Temporal Extensions to the Entity-Relationship Model. In: 1st International Workshop on Evolution and Change in Data Management, pp. 110–121. Springer, Paris (1999)
Gregersen, H., Jensen., C.S.: Temporal Entity Relationship Models - a Survey. IEEE Trans. Knowl. Data Eng. 11, 464–497 (1999)
Gregersen, H., Jensen, C.S.: Conceptual Modeling of Time-Varying Information. In: 2nd International Conference on Computing, Communications and Control Technologies, Austin, pp. 248–255 (2004)
Jensen, C.S., Dyreson, C.E. (eds.): Dagstuhl Seminar 1997. LNCS, vol. 1399, pp. 367–405. Springer, Heidelberg (1998)
Jensen, C.S., Snodgrass, R.T.: Temporally Enhanced Database Design. In: Advances in Object-Oriented Data Modeling, pp. 163–193. MIT Press, Cambridge (2000)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2008 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Combi, C., Degani, S., Jensen, C.S. (2008). Capturing Temporal Constraints in Temporal ER Models. In: Li, Q., Spaccapietra, S., Yu, E., Olivé, A. (eds) Conceptual Modeling - ER 2008. ER 2008. Lecture Notes in Computer Science, vol 5231. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-87877-3_29
Download citation
DOI: https://doi.org/10.1007/978-3-540-87877-3_29
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-87876-6
Online ISBN: 978-3-540-87877-3
eBook Packages: Computer ScienceComputer Science (R0)