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

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

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