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.
Original language | English |
---|---|
Title of host publication | Proc of the 20th Int. Conf. on Conceptual modeling - ER 2001 |
Subtitle of host publication | 20th international conference on conceptual modeling (ER 2001) |
Editors | S Hideko, Kunii Sushil, Jajodia Arne |
Place of Publication | Berlin |
Publisher | Springer |
Pages | 208-224 |
Number of pages | 17 |
Volume | 2224 |
Publication status | Published - 2001 |
Keywords
- CASE Tool
- Temporal database design
- Methodology