O'Reilly logo

Managing Time in Relational Databases by Randall Weis, Tom Johnston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required