Class Notes for CS240A: Databases and Knowledge Bases

Temporal Databases

Chapter 5. Overview of Temporal Databases

A short History of Calendars and Time
Slides
5.1
A Case Study
5.1.1
Temporal Projection
5.1.2
Temporal Join
5.1.3
Summary
Slides
5.2
The Time Domain
5.3
Time Data Types
Slides
5.4
Associating Facts with Time
5.4.1
Dimensionality
Slides
5.4.2
Underlying Data Model
5.4.3
Representative Data Models
5.5
Temporal Query Languages
5.6
Summary
Slides

Chapter 6. TSQL2

6.1
Time Ontology
6.2
Data Model
Slides
6.3
Language Constructs
6.3.1
Schema Definition
6.3.2
The SELECT Statement
6.3.3
Restructuring
6.3.4
Partitioning
6.3.5
The VALID Clause
6.3.6
The Modification Statements
6.3.7
Event Relations
6.3.8
Transaction-Time Support
6.3.9
Aggregates
6.3.10
Schema Evolution and Versioning
Slides
6.4
Other Constructs
Slides
6.5
Summary
Slides

Chapter 7. Implementation

7.1
System Architecture
7.2
Adding Temporal Support
7.2.1
DDL Compiler
7.2.2
Query Compiler
7.2.3
Run-Time Evaluator
7.3
Minimal Support Needed for TSQL2
7.3.1
Data Dictionary and Data Files
7.3.2
DDL Compiler
7.3.3
Query Compiler
7.3.4
Run-Time Evaluator
7.3.5
Transaction and Data Manager
Slides