TimeERplus: A Temporal EER Model Supporting Schema Changes

  • Heidi Gregersen
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3567)


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, with varying syntax and semantics, 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 important, but are also difficult to capture using the ER model. Not surprisingly, enhancements to the ER model have been proposed in an attempt to more naturally support the modeling of temporal aspects of information. Common to the existing temporally extended ER models, few or no specific requirements to the models were given by their designers.

With the existing proposals, an ontological foundation, and novel requirements as its basis, this paper defines a novel temporally extended ER model satisfying an array of properties not satisfied by any single previously proposed model.


Entity Type Temporal Aspect Relationship Type Modeling Construct Database Schema 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Bergamaschi, S., Sartori, C.: Chrono: A Conceptual Design Framework for Temporal Entities. In: Ling, T.-W., Ram, S., Li Lee, M. (eds.) ER 1998. LNCS, vol. 1507, pp. 35–50. Springer, Heidelberg (1998)Google Scholar
  2. 2.
    Chen, P.P.-S.: The Entity-Relationship Model – Toward a Unified View of Data. Transaction on Database Systems 1(1), 9–36 (1976)CrossRefGoogle Scholar
  3. 3.
    Dyreson, C.E., Snodgrass, R.T.: Temporal Granularity and Indeterminacy: Two Sides of the Same Coin. Technical Report TR 94-06, University of Arizona, Department of Computer Science (February 1994)Google Scholar
  4. 4.
    Dyreson, C.E., Snodgrass, R.T.: Temporal Granularity. In: The TSQL2 Temporal Query Language, ch. 19, pp. 347–383. Kluwer Academic Publishers, Dordrecht (1995)Google Scholar
  5. 5.
    Dyreson, C.E., Snodgrass, R.T.: Temporal Indeterminacy. In: Snodgrass, R.T. (ed.) The TSQL2 Temporal Query Language, ch. 18, pp. 327–346. Kluwer Academic Publishers, Dordrecht (1995)Google Scholar
  6. 6.
    Dyreson, C.E., Snodgrass, R.T.: Supporting Valid-time Indeterminancy. ACM Transaction on Database Systems 23(1), 1–57 (1998)CrossRefGoogle Scholar
  7. 7.
    Elmasri, R., El-Assal, I., Kouramajian, V.: Semantics of Temporal Data in an Extended ER Model. In: 9th International Conference on the Entity-Relationship Approach, Lausanne, Switzerland, pp. 239–254 (October 1990)Google Scholar
  8. 8.
    Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 2nd edn. The Benjamin/Cummings Publishing Company, INC (1994) ISBN 0-8053-1753-8Google Scholar
  9. 9.
    Elmasri, R., Wuu, G.T.J.: A Temporal Model and Query Language for ER Databases. In: Proceedings of the Sixth International Conference on Data Engineering, pp. 76–83 (1990)Google Scholar
  10. 10.
    Ferg, S.: Modeling the Time Dimension in an Entity-Relationship Diagram. In: 4th International Conference on the Entity-Relationship Approach, Silver Spring, MD, pp. 280–286. Computer Society Press (1985)Google Scholar
  11. 11.
    Gadia, S.K.: A Homogeneous Relational Model and Query Languages for Temporal Databases. Transactions on Database Systems 13(4), 418–448 (1988)zbMATHCrossRefMathSciNetGoogle Scholar
  12. 12.
    Gregersen, H., Jensen, C.S.: Temporal Entity-Relationship Models – a Survey. IEEE Transactions on Knowledge an Data Engineering 11(3), 464–497 (1999)CrossRefGoogle Scholar
  13. 13.
    Gregersen, H., Jensen, C.S., Mark, L.: Evaluating Temporally Extended ER Models. In: Siau, K., Wand, Y., Parsons, J. (eds.) Proceedings of the Second CAiSE/IFIP8.1, p. 12 (June 1997)Google Scholar
  14. 14.
    Jensen, C.S., Dyreson, C.E., Böhlen, M.H., Clifford, J., Elmasri, R.A., Gadia, S.K., Grandi, F., Hayes, P.J., Jajodia, S., Käfer, W., Kline, N., Lorentzos, N.A., Mitsopoulos, Y., Montanari, A., Nonen, D., Peressi, E., Pernici, B., Roddick, J., Sarda, N.L., Scalas, M.R., Segev, A., Snodgrass, R.T., Soo, M.D., Tansel, A.U., Tiberio, P., Wiederhold, G.: The Consensus Glossary of Temporal Database Concepts - February 1998 Version. In: Etzion, O., Jajodia, S., Sripada, S. (eds.) Dagstuhl Seminar 1997. LNCS, vol. 1399, pp. 367–405. Springer, Heidelberg (1998)CrossRefGoogle Scholar
  15. 15.
    Jensen, C.S., Snodgrass, R.T.: Semantics of Time-Varying Information. Information Systems 21(4), 311–352 (1996)CrossRefGoogle Scholar
  16. 16.
    Jensen, C.S., Snodgrass, R.T.: Temporally Enhanced Database Design. In: Papazoglou, M.P., Spaccapietra, S., Tari, Z. (eds.) Advances in Object-Oriented Data Modeling. ch. 7, pp. 163–193. MIT Press, Cambridge (2000)Google Scholar
  17. 17.
    Klopprogge, M.R.: TERM: An Approach to Include the Time Dimension in the Entity- Relationship Model. In: Proceedings of the Second International Conference on the Entity Relationship Approach, Washington, DC, pp. 477–512 (October 1981)Google Scholar
  18. 18.
    Kraft, P., Sørensen, J.O.: Translation of a High-Level Temporal Model into Lower Level Models. In: Kunii, H.S., Jajodia, S., Sølvberg, A. (eds.) ER 2001. LNCS, vol. 2224, pp. 383–396. Springer, Heidelberg (2001)CrossRefGoogle Scholar
  19. 19.
    Lai, V.S., Kuilboer, J.-P., Guynes, J.L.: Temporal Databases: Model Design and Commercialization Prospects. DATA BASE 25(3), 6–18 (1994)Google Scholar
  20. 20.
    Lee, J.Y., Elmasri, R.: An EER-Based Conceptual Model and Query Language for Time-Series Data. In: Ling, T.-W., Ram, S., Li Lee, M. (eds.) ER 1998. LNCS, vol. 1507, pp. 21–34. Springer, Heidelberg (1998)CrossRefGoogle Scholar
  21. 21.
    McBrien, P., Seltveit, A.H., Wangler, B.: An Entity-Relationship Model Extended to describe Historical information. In: International Conference on Information Systems and Management of Data, Bangalore, India, pp. 244–260 (July 1992)Google Scholar
  22. 22.
    Narasimhalu. A: Data Model for Object-Oriented Databases with Temporal Attributes and Relationships. Technical report, National University of Singapore (1988)Google Scholar
  23. 23.
    Roddick, J.F., Craske, N.G., Richards, T.J.: A Taxonomy for Schema Versioning Based on the Relational and Entity Relationship Models. In: Elmasri, R.A., Kouramajian, V., Thalheim, B. (eds.) ER 1993. LNCS, vol. 823, pp. 137–148. Springer, Heidelberg (1993)CrossRefGoogle Scholar
  24. 24.
    Snodgrass, R., Ahn, I.: A Taxonomy of Time in Databases. In: Navathe, S. (ed.) Proceedings of ACM-SIGMOD 1985 International Conference on Management of Data, Austin, TX, May 1985, pp. 236–246 (1985)Google Scholar
  25. 25.
    Snodgrass, R.T.: The Temporal Query Language TQuel. ACM Transaction on Database Systems 12(2), 247–298 (1987)CrossRefGoogle Scholar
  26. 26.
    Snodgrass, R.T.: Böhlen M., Jensen, C. S. Steiner, A.: Change Proposal to SQL/Temporal: Adding Valid Time – Part A. International Organization for Standardization, pp. 40, ANSI Expert’s Contribution (December 1995)Google Scholar
  27. 27.
    Tauzovich, B.: Toward Temporal Extensions to the Entity-Relationship Model. In: The 10th International Conference on the Entity Relationship Approach, San Mateo, California, October 1991, pp. 163–179 (1991)Google Scholar
  28. 28.
    Theodoulidis, C.I., Loucopoulos, P., Wangler, B.: A Conceptual Modelling Formalism for Temporal Database Applications. Information Systems 16(4), 401–416 (1991)CrossRefGoogle Scholar
  29. 29.
    Wiederhold, G., Jajodia, S., Litwin, W.: Dealing with Granularity of Time in Temporal Databases. In: Andersen, R., Solvberg, A., Bubenko Jr., J.A. (eds.) CAiSE 1991. LNCS, vol. 498, pp. 124–140. Springer, Heidelberg (1991)Google Scholar
  30. 30.
    Zimanyi, E., Parent, C., Spaccapietra, S., Pirotte, A.: TERC+: A Temporal Conceptual Model. In: Proc. Int. Symp. on Digital Media Information Base (November 1997)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2005

Authors and Affiliations

  • Heidi Gregersen
    • 1
  1. 1.Department of Marketing, Informatics and StatisticsAarhus School of BusinessAarhus V

Personalised recommendations