Temporal Databases
Outline
Structure of time
The time stamp model
Temporal attribute
The snapshot model
Relational database histories
Temporal database design
Multiple dimensions
Temporal queries
Temporal logic
First order temporal logic
Temporal connectives
First order temporal logic
Examples
Temporal extensions of SQL
SQL/TP Example
Extensions of SQL based on interval based language
Updating temporal databases
Complex structure of time
Beyond…
Conclusion

Complex structure of time
Complex structure of time: more complex than linearly ordered sets of time instants
Natural numbers, integers, reals
Additional structures: durations, temporal distances, periodic sets
Impact on integrity constraints : more complex constraint dependencies
Impact on query languages (use new predicate symbols in the same way the linear order < symbol has been used so far)