A conceptual modelling formalism for temporal database applications
Information Systems
Temporal databases: model design and commercialization prospects
ACM SIGMIS Database
Temporal database system implementations
ACM SIGMOD Record
Temporal FDs on complex objects
ACM Transactions on Database Systems (TODS)
Developing time-oriented database applications in SQL
Developing time-oriented database applications in SQL
The TSQL2 Temporal Query Language
The TSQL2 Temporal Query Language
Coalescing in Temporal Databases
VLDB '96 Proceedings of the 22th International Conference on Very Large Data Bases
Modelling the Time Dimension in an Entity-Relationship Diagram
Proceedings of the Fourth International Conference on Entity-Relationship Approach
TIME '99 Proceedings of the Sixth International Workshop on Temporal Representation and Reasoning
Research in database engineering at the University of Namur
ACM SIGMOD Record
Data & Knowledge Engineering
| Hi-index | 0.00 |
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.