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

10. Temporal Transactions on Single Tables
The Temporal Insert Transaction214
Creating an Episode216
Lengthening an Episode Backwards217
Lengthening an Episode Forwards219
Merging Episodes220
The Temporal Update Transaction222
Restricted and Unrestricted Temporal Transactions226
The Temporal Delete Transaction226
Deleting One or More Episodes227
Shortening an Episode Forwards228
Shortening an Episode Backwards230
Splitting an Episode231
Completeness Checks233
An Allen Relationship Completeness Check233
A Temporal Extent Transformation Completeness Check237
Glossary References238
In the previous chapter, we looked at the “specs” of the three types of temporal transactions. In this chapter, we'll take those transactions out for a spin and see exactly ...

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