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

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.

Start your free trial