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.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
B÷HLEN M., Temporal Database System Implementations, ACM SIGMOD Record, 24(4):53–60, December, 1995.
B÷hlen M., Coalescing in Temporal Databases, Proc. of the 22nd VLDB Conference, Bombay, India, 1996.
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.
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.
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.
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.
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
JENSEN C., SNODGRASS R., Temporal Data Management, Technical Report TR-17, TIMECENTER, 1997.
LAI V.S., KUILBOER J-P., GUYNES J. L., Temporal Databases: Model Design and Commercialization Prospects, DATA BASE, 25(3), 1994.
SNODGRASS R., The TSQL2 Temporal Query Language, Kluwer Academic Publishers, Massachussetts, USA, 1995.
SNODGRASS R., Developing Time-Oriented Database Applications in SQL, Morgan Kaufmann Publishers, USA, 2000.
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.
SVINTERIKOU M., THEODOULIDIS C., The Temporal Unified Modelling Language, Department of Computation, UMIST, United Kingdom, October 1997.
THEODOULIDIS C.I., LOUCOPOULOS P., WANGLER B., A Conceptual Modelling Formalism for Temporal Database Applications, Information Systems, 16(4), 1991.
WIJSEN J., Temporal FDs on Complex objects, ACM Transactions on Database Systems, Vol 24., No.1,Pages 127–176, March 1999
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights 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