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

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

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