Skip to main content
SpringerLink
Log in

Chrono: A Conceptual Design Framework for Temporal Entities

  • Conference paper
Conceptual Modeling – ER ’98 (ER 1998)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1507))

Included in the following conference series:

Abstract

Database applications are frequently faced with the necessity of representing time varying information and, particularly in the management of information systems, a few kinds of behavior in time can characterize a wide class of applications. A great amount of work in the area of temporal databases aiming at the definition of standard representation and manipulation of time, mainly in relational database environment, has been presented in the last years. Nevertheless, conceptual design of databases with temporal aspects has not yet received sufficient attention. The purpose of this paper is twofold: to propose a simple temporal treatment of information at the initial conceptual phase of database design; to show how the chosen temporal treatment can be exploited in time integrity enforcement by using standard DBMS tools, such as referential integrity and triggers. Furthermore, we present a design tool implementing our data model and constraint generation technique, obtained by extending a commercial design tool.

With the contribution of Gruppo Formula S.p.A., Bologna, Italy, http://www.formula.it

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. Batini, C., Ceri, S., Navathe, S.B.: Conceptual Database design: an Entity- Relationship Approach. Benjamin/Cummings Publishing Company (1992)

    Google Scholar 

  2. Bergamaschi, S., Sartori, C.: Chrono: a conceptual design framework for temporal entities. Technical Report CSITE-011-98, CSITE - CNR (1998), ftp://wwwdb.deis.unibo.it/pub/reports/CSITE-011-98.pdf

  3. Chen, P.: The Entity-Relationship model - towards a unified view of data. ACM Trans. on Database Systems 1(1), 9–36 (1976)

    Article  Google Scholar 

  4. Elmasri, R., El-Assal, I., Kouramajian, V.: Semantics of temporal data in an extended ER model. In: 9th Int. Conf. on the Entity–Relationship Approach, Lausanne, Switzerland, pp. 239–254 (1990)

    Google Scholar 

  5. Elmasri, R., Kouramajian, V.: A temporal query language for a conceptual model. In: Adam, N.R., Bhargava, B.K. (eds.) Advanced Database Systems. LNCS, vol. 759, p. 175. Springer, Heidelberg (1993)

    Google Scholar 

  6. Elmasri, R., Wuu, G.: A temporal model and query language for ER databases. In: Proc. IEEE CS Intl. Conf. 6 on Data Engineering (February 1990)

    Google Scholar 

  7. Elmasri, R., Wuu, G.T.J., Kouramajian, V.: A temporal model and query language for EER databases. In: Tansel, A., et al. (eds.) [25], ch. 9, pp. 212–229.

    Google Scholar 

  8. 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. IEEE Computer Society Press, Los Alamitos (1985)

    Google Scholar 

  9. Gadia, S.K., Yeung, C.S.: A generalized model for a relational temporal database. In: ACM SIGMOD, pp. 251–259 (1988)

    Google Scholar 

  10. Gregersen, H., Jensen, C.S.: Temporal entity–relationship models a survey. Technical Report TR-3, Time Center (January 1997), http://www.cs.auc.dk/research/DBS/tdb/TimeCenter/publications.html

  11. Guynes, J.L., Lai, V.S., Kuilboer, J.P.: Temporal Databases: Model Design and Commercialization Prospects. Database 25(3) (August 1994)

    Google Scholar 

  12. Jensen, C.S., Snodgrass, R.T.: Semantics of time-varying information. Information Systems 21(4), 311–352 (1996)

    Article  Google Scholar 

  13. Jensen, C.S., Snodgrass, R.T., Soo, M.D.: Extending existing dependency theory to temporal databases. IEEE Transactions on Knowledge and Data Engineering 8(4), 563–582 (1996)

    Article  Google Scholar 

  14. Jensen, C.S., Soo, M.D., Snodgrass, R.T.: Unifying temporal models via a conceptual model. Information Systems 19(7), 513–547 (1994)

    Article  Google Scholar 

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

  16. Klopprogge, M.R., Lockemann, P.C.: Modelling information preserving databases: Consequences of the concept of time. In: Schkolnick, M., Thanos, C. (eds.) vldb, Florence, Italy, pp. 399–416 (1983)

    Google Scholar 

  17. I. Knowledge Based Systems. SmartER - information and data modeling and database design. Technical report, Knowledge Based Systems, Inc. - Austin, USA (1997), http://www.kbsi.com/products/smarter.html

  18. I. Logic Works. Erwin/erx. Technical report, Logic Works, Inc. (1997), http://www.logicworks.com/products/erwinerx/index.asp

  19. Mannila, H., Räihä, K.-J.: The design of relational databases. Addison-Wesley, Reading (1993)

    Google Scholar 

  20. McBrien, P., Selveit, A.H., Wangler, B.: An entity-relationship model extended to describe historical information. In: International Conference on Information Systems and Management of Data (CISMOD 1992), Bangalore, India, July 1992, pp. 244–260 (1992)

    Google Scholar 

  21. Narasimhalu, A.: A data model for object-oriented databases with temporal attributes and relationships. Technical report, National University of Singapore (1988)

    Google Scholar 

  22. Navathe, S., Ahmed, R.: Temporal extensions to the relational model and SQL. In: Tansel, A., et al. [25], ch. 4, pp. 92–109.

    Google Scholar 

  23. F. I. P. S. Publication. Integration definition for function modeling (idef1x). Technical Report 183, National Institute of Standards and Technology, Gaithersburg, Md. 20899 (1993)

    Google Scholar 

  24. Snodgrass, R.T.: The temporal query language TQel. ACM Trans. Database Syst. 12(2), 247–298 (1987)

    Article  Google Scholar 

  25. Tansel, A.U., et al. (eds.): Temporal databases: theory, design and implementations. Benjamin Cummings (1993)

    Google Scholar 

  26. Theodoulidis, C., Loucopoulos, P., Wangler, B.: A conceptual modelling formalism for temporal database applications. Information Systems 16(4), 401–416 (1991)

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. DSI, University of Modena, Italy

    Sonia Bergamaschi

  2. DEIS, University of Bologna, Italy

    Claudio Sartori

  3. CSITE – CNR, Bologna, Italy, Viale Risorgimento, 2, 40136, Bologna, Italy

    Sonia Bergamaschi & Claudio Sartori

Authors
  1. Sonia Bergamaschi
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Claudio Sartori
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. School of Computing, National University of Singapore,  

    Tok-Wang Ling

  2. Department of MIS, Eller School of Management, University of Arizona, 430J McClelland Hall, 85721, Tucson, AZ

    Sudha Ram

  3. Department of Computer Science, National University of Singapore, Singapore

    Mong Li Lee

Rights and permissions

Reprints and permissions

Copyright information

© 1998 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Bergamaschi, S., Sartori, C. (1998). Chrono: A Conceptual Design Framework for Temporal Entities. In: Ling, TW., Ram, S., Li Lee, M. (eds) Conceptual Modeling – ER ’98. ER 1998. Lecture Notes in Computer Science, vol 1507. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-49524-6_4

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-49524-6_4

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-65189-5

  • Online ISBN: 978-3-540-49524-6

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation