Skip to main content
SpringerLink
Log in
Book cover

International Conference on Conceptual Modeling

ER 2001: Conceptual Modeling — ER 2001 pp 208–224Cite as

CASE Tool Support for Temporal Database Design

  • Conference paper
  • First Online:

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

Abstract

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.

This is a preview of subscription content, 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   84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   109.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

Learn about institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. B÷HLEN M., Temporal Database System Implementations, ACM SIGMOD Record, 24(4):53–60, December, 1995.

    Article  Google Scholar 

  2. B÷hlen M., Coalescing in Temporal Databases, Proc. of the 22nd VLDB Conference, Bombay, India, 1996.

    Google Scholar 

  3. 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. 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. 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. 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. 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, 1996

    Google Scholar 

  8. JENSEN C., SNODGRASS R., Temporal Data Management, Technical Report TR-17, TIMECENTER, 1997.

    Google Scholar 

  9. LAI V.S., KUILBOER J-P., GUYNES J. L., Temporal Databases: Model Design and Commercialization Prospects, DATA BASE, 25(3), 1994.

    Google Scholar 

  10. SNODGRASS R., The TSQL2 Temporal Query Language, Kluwer Academic Publishers, Massachussetts, USA, 1995.

    MATH  Google Scholar 

  11. SNODGRASS R., Developing Time-Oriented Database Applications in SQL, Morgan Kaufmann Publishers, USA, 2000.

    Google Scholar 

  12. 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. SVINTERIKOU M., THEODOULIDIS C., The Temporal Unified Modelling Language, Department of Computation, UMIST, United Kingdom, October 1997.

    Google Scholar 

  14. THEODOULIDIS C.I., LOUCOPOULOS P., WANGLER B., A Conceptual Modelling Formalism for Temporal Database Applications, Information Systems, 16(4), 1991.

    Google Scholar 

  15. WIJSEN J., Temporal FDs on Complex objects, ACM Transactions on Database Systems, Vol 24., No.1,Pages 127–176, March 1999

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Institut d’Informatique, University of Namur, rue Grandgagnage, 21, B-5000, Namur, Belgium

    Virginie Detienne & Jean-Luc Hainaut

Authors
  1. Virginie Detienne
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jean-Luc Hainaut
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Ricoh Company, Ltd., Software Research Center, 1-1-17 Koishikawa, Bunkyo-ku, 112-0002, Tokyo, Japan

    Hideko S.Kunii

  2. George Mason University, Center for Secure Information Systems, Mail Stop 4A4, Fairfax, 22030-4444, VA, USA

    Sushil Jajodia

  3. Department of Computer and Information Science, The Norwegian University of Science and Technology, 7491, Trondheim, Norway

    Arne Sølvberg

Rights and permissions

Reprints and permissions

Copyright information

© 2001 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Detienne, V., Hainaut, JL. (2001). CASE Tool Support for Temporal Database Design. In: S.Kunii, H., Jajodia, S., Sølvberg, A. (eds) Conceptual Modeling — ER 2001. ER 2001. Lecture Notes in Computer Science, vol 2224. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-45581-7_17

Download citation

  • DOI: https://doi.org/10.1007/3-540-45581-7_17

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-42866-4

  • Online ISBN: 978-3-540-45581-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation