CASE Tool Support for Temporal Database Design
| Autor: | Jean-Luc Hainaut, Virginie Detienne |
|---|---|
| Rok vydání: | 2001 |
| Předmět: |
SQL
Relational database Computer science Database schema InformationSystems_DATABASEMANAGEMENT computer.software_genre Data structure Information schema Conceptual schema Temporal database Open Database Connectivity Valid time Relational database management system Schema (psychology) Entity–relationship model Data mining computer computer.programming_language |
| Zdroj: | Conceptual Modeling — ER 2001 ISBN: 9783540428664 ER |
| DOI: | 10.1007/3-540-45581-7_17 |
| Popis: | 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. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|