Managing Time in Relational Databases

9. An Introduction to Temporal Transactions

Contents

Effective Time Within Assertion Time192

Explicitly Temporal Transactions: The Mental Model195

A Taxonomy of Temporal Extent State Transformations197

The Asserted Versioning Temporal Transactions200

The Temporal Insert Transaction201

The Temporal Update Transaction206

The Temporal Delete Transaction209

Glossary References211

Temporal transactions are inserts, updates or deletes whose targets are asserted version tables. But temporal transactions are not submitted directly to the DBMS. The work that has to be done to manage conventional tables is straightforward enough that we can let users directly manipulate those tables. But bi-temporal tables, including asserted version tables, are too complex to ...