Skip to main content
SpringerLink
Log in

TimeERplus: A Temporal EER Model Supporting Schema Changes

  • Conference paper
Database: Enterprise, Skills and Innovation (BNCOD 2005)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3567))

Included in the following conference series:

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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. Chen, P.P.-S.: The Entity-Relationship Model – Toward a Unified View of Data. Transaction on Database Systems 1(1), 9–36 (1976)

    Article  Google Scholar 

  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. 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. 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. Dyreson, C.E., Snodgrass, R.T.: Supporting Valid-time Indeterminancy. ACM Transaction on Database Systems 23(1), 1–57 (1998)

    Article  Google Scholar 

  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. Elmasri, R., Navathe, S.B.: Fundamentals of Database Systems, 2nd edn. The Benjamin/Cummings Publishing Company, INC (1994) ISBN 0-8053-1753-8

    Google Scholar 

  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. 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. Gadia, S.K.: A Homogeneous Relational Model and Query Languages for Temporal Databases. Transactions on Database Systems 13(4), 418–448 (1988)

    Article  MATH  MathSciNet  Google Scholar 

  12. Gregersen, H., Jensen, C.S.: Temporal Entity-Relationship Models – a Survey. IEEE Transactions on Knowledge an Data Engineering 11(3), 464–497 (1999)

    Article  Google Scholar 

  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. 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)

    Chapter  Google Scholar 

  15. Jensen, C.S., Snodgrass, R.T.: Semantics of Time-Varying Information. Information Systems 21(4), 311–352 (1996)

    Article  Google Scholar 

  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. 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. 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)

    Chapter  Google Scholar 

  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. 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)

    Chapter  Google Scholar 

  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. Narasimhalu. A: Data Model for Object-Oriented Databases with Temporal Attributes and Relationships. Technical report, National University of Singapore (1988)

    Google Scholar 

  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)

    Chapter  Google Scholar 

  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. Snodgrass, R.T.: The Temporal Query Language TQuel. ACM Transaction on Database Systems 12(2), 247–298 (1987)

    Article  Google Scholar 

  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. 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. Theodoulidis, C.I., Loucopoulos, P., Wangler, B.: A Conceptual Modelling Formalism for Temporal Database Applications. Information Systems 16(4), 401–416 (1991)

    Article  Google Scholar 

  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. 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 

Download references

Author information

Authors and Affiliations

  1. Department of Marketing, Informatics and Statistics, Aarhus School of Business, Fuglesangs Allé 4, DK-8210, Aarhus V

    Heidi Gregersen

Authors
  1. Heidi Gregersen
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Center for Geospatial Science, University of Nottingham, UK

    Mike Jackson

  2. Motorola, Schaumburg, Illinois, USA

    David Nelson

  3. School of Computing and Technology, The Sir Tom Cowie Campus at St. Peter’s, University of Sunderland, SR6 0DD, Sunderland, UK

    Sue Stirk

Rights and permissions

Reprints and permissions

Copyright information

© 2005 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Gregersen, H. (2005). TimeERplus: A Temporal EER Model Supporting Schema Changes. In: Jackson, M., Nelson, D., Stirk, S. (eds) Database: Enterprise, Skills and Innovation. BNCOD 2005. Lecture Notes in Computer Science, vol 3567. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11511854_4

Download citation

  • DOI: https://doi.org/10.1007/11511854_4

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-26973-1

  • Online ISBN: 978-3-540-31677-0

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation