11. Temporal Transactions on Multiple Tables
Temporal Managed Objects and Temporal Referential Integrity243
Child Managed Objects243
Parent Managed Objects244
Temporal Referential Integrity: The Basic Diagram245
Foreign Keys and Temporal Foreign Keys247
TFKs: A Data Part and a Function Part249
Temporal Transactions and Associative Tables250
TRI with Multiple TFKs251
Temporal Delete Options252
Temporal Referential Integrity Applied to Temporal Transactions253
A Temporal Insert Transaction253
A Temporal Update Transaction254
A Temporal Delete Transaction254
Glossary References259
In the previous two chapters, we discussed temporal transactions and the temporal entity integrity constraint to which they must conform. We saw that, just as conventional entity ...

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