7. The Basic Scenario
Contents
The Representation of Objects in Time Periods142
Occupied and Represented144
Basic Temporal Transactions: The Mental Model144
Maintaining Asserted Version Tables: The Basic Scenario145
A Temporal Insert Transaction145
A Temporal Update Transaction147
A Second Temporal Update Transaction152
A Temporal Delete Transaction154
Glossary References159
When representing an object in a non-temporal table, the most basic things we can do are to insert a row representing the object, update the row as changes happen to the object, and delete the row if and when the object ceases to exist, or ceases to be of interest to us. Almost always, we don't know in advance if or when any of these things will happen: if or when a row will be ...

Get Managing Time in Relational Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.