CASE Tool Support for Temporal Database Design

  • Virginie Detienne
  • Jean-Luc Hainaut
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2224)


Current RDBMS technology provides little support for building temporal databases. The paper describes a methodology and a CASE tool that is to help practitioners develop correct and efficient relational data structures. The designer builds a temporal ERA schema that is validated by the tool, then converted into a temporal relational schema. This schema can be transformed into a pure relational schema according to various optimization strategies. Finally, the tool generates an active SQL-92 database that automatically maintain entity and relationship states. In addition, it generates a temporal ODBC driver that encapsulates complex temporal operators such as projection, join and aggregation through a small subset of TSQL2. This API allows programmers to develop complex temporal applications as easily as non temporal ones.


Conceptual Schema Entity Type Relationship Type Valid Time Case Tool 
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.
    B÷HLEN M., Temporal Database System Implementations, ACM SIGMOD Record, 24(4):53–60, December, 1995.CrossRefGoogle Scholar
  2. 2.
    B÷hlen M., Coalescing in Temporal Databases, Proc. of the 22nd VLDB Conference, Bombay, India, 1996.Google Scholar
  3. 4.
    ELMASRI R., WEI H., Study and Comparison of Schema Versioning and Database Conversion Techniques for Bi-temporal Databases, Proceedings of the Sixth International Workshop on Temporal Representation and Reasoning (TIME-99), Orlando, Florida, May 1999, IEEE Computer Society.Google Scholar
  4. 5.
    FERG S., Modeling the Time Dimension in an Entity-Relationship Diagram, Proceedings of the 4th International Confernce on the Entity-Relationship Approach, pages 280–286, Siver Spring, MD, 1985.Google Scholar
  5. 6.
    GREGERSEN H., JENSEN C. S., MARK L., Evaluating Temporally Extended ER Models, Proceedings of the Second CAISE/IFIP8.1 International Workshop on Evaluation of Modeling Methods in System Analysis and Design, 12p, K. Siau, Y. Wand, J. Parsons, editors, Barcelona, Spain, June 1997.Google Scholar
  6. 7.
    GREGERSEN H., MARK L., JENSEN C. S., Mapping Temporal ER Diagrams to Relational Schemas, Technical Report TR-39, Aalborg University, Department of Mathematics and Computer Science, December 1998.Google Scholar
  7. 8.
    HAINAUT, J.-L., ROLAND, D., HICK, J.-M., HENRARD, J., ENGLEBERT, V., Database Reverse Engineering: from Requirements to CARE tools, Journal of Automated Software Engineering, Vol. 3, No. 2, 1996Google Scholar
  8. 9.
    JENSEN C., SNODGRASS R., Temporal Data Management, Technical Report TR-17, TIMECENTER, 1997.Google Scholar
  9. 10.
    LAI V.S., KUILBOER J-P., GUYNES J. L., Temporal Databases: Model Design and Commercialization Prospects, DATA BASE, 25(3), 1994.Google Scholar
  10. 11.
    SNODGRASS R., The TSQL2 Temporal Query Language, Kluwer Academic Publishers, Massachussetts, USA, 1995.zbMATHGoogle Scholar
  11. 12.
    SNODGRASS R., Developing Time-Oriented Database Applications in SQL, Morgan Kaufmann Publishers, USA, 2000.Google Scholar
  12. 13.
    STEINER A., A Generalisation approach to Temporal Data Models and their Implementations, Thesis of the Swiss Federal Institute of Technology for the degree of Doctor of Technical Sciences, Zürich, 1998.Google Scholar
  13. 14.
    SVINTERIKOU M., THEODOULIDIS C., The Temporal Unified Modelling Language, Department of Computation, UMIST, United Kingdom, October 1997.Google Scholar
  14. 15.
    THEODOULIDIS C.I., LOUCOPOULOS P., WANGLER B., A Conceptual Modelling Formalism for Temporal Database Applications, Information Systems, 16(4), 1991.Google Scholar
  15. 16.
    WIJSEN J., Temporal FDs on Complex objects, ACM Transactions on Database Systems, Vol 24., No.1,Pages 127–176, March 1999CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2001

Authors and Affiliations

  • Virginie Detienne
    • 1
  • Jean-Luc Hainaut
    • 1
  1. 1.Institut d’InformatiqueUniversity of NamurNamurBelgium

Personalised recommendations