Chrono: A Conceptual Design Framework for Temporal Entities

  • Sonia Bergamaschi
  • Claudio Sartori
Part of the Lecture Notes in Computer Science book series (LNCS, volume 1507)


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.


Temporal Treatment Conceptual Schema Integrity Constraint Validity Period Temporal Entity 
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.
    Batini, C., Ceri, S., Navathe, S.B.: Conceptual Database design: an Entity- Relationship Approach. Benjamin/Cummings Publishing Company (1992)Google Scholar
  2. 2.
    Bergamaschi, S., Sartori, C.: Chrono: a conceptual design framework for temporal entities. Technical Report CSITE-011-98, CSITE - CNR (1998),
  3. 3.
    Chen, P.: The Entity-Relationship model - towards a unified view of data. ACM Trans. on Database Systems 1(1), 9–36 (1976)CrossRefGoogle Scholar
  4. 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. 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. 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. 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. 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. 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. 10.
    Gregersen, H., Jensen, C.S.: Temporal entity–relationship models a survey. Technical Report TR-3, Time Center (January 1997),
  11. 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. 12.
    Jensen, C.S., Snodgrass, R.T.: Semantics of time-varying information. Information Systems 21(4), 311–352 (1996)CrossRefGoogle Scholar
  13. 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)CrossRefGoogle Scholar
  14. 14.
    Jensen, C.S., Soo, M.D., Snodgrass, R.T.: Unifying temporal models via a conceptual model. Information Systems 19(7), 513–547 (1994)CrossRefGoogle Scholar
  15. 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. 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. 17.
    I. Knowledge Based Systems. SmartER - information and data modeling and database design. Technical report, Knowledge Based Systems, Inc. - Austin, USA (1997),
  18. 18.
    I. Logic Works. Erwin/erx. Technical report, Logic Works, Inc. (1997),
  19. 19.
    Mannila, H., Räihä, K.-J.: The design of relational databases. Addison-Wesley, Reading (1993)Google Scholar
  20. 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. 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. 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. 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. 24.
    Snodgrass, R.T.: The temporal query language TQel. ACM Trans. Database Syst. 12(2), 247–298 (1987)CrossRefGoogle Scholar
  25. 25.
    Tansel, A.U., et al. (eds.): Temporal databases: theory, design and implementations. Benjamin Cummings (1993)Google Scholar
  26. 26.
    Theodoulidis, C., Loucopoulos, P., Wangler, B.: A conceptual modelling formalism for temporal database applications. Information Systems 16(4), 401–416 (1991)CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1998

Authors and Affiliations

  • Sonia Bergamaschi
    • 1
    • 3
  • Claudio Sartori
    • 2
    • 3
  1. 1.DSIUniversity of ModenaItaly
  2. 2.DEISUniversity of BolognaItaly
  3. 3.CSITE – CNR, Bologna, ItalyBolognaItaly

Personalised recommendations