Databases Reference
In-Depth Information
11
TEMPORAL TRANSACTIONS ON
MULTIPLE TABLES
Temporal Managed Objects and Temporal Referential Integrity
Child Managed Objects
243
Parent Managed Objects
244
Temporal Referential Integrity: The Basic Diagram
245
Foreign Keys and Temporal Foreign Keys
247
TFKs: A Data Part and a Function Part
249
Temporal Transactions and Associative Tables
TRI with Multiple TFKs
251
Temporal Delete Options
252
Temporal Referential Integrity Applied to Temporal Transactions
A Temporal Insert Transaction
A Temporal Update Transaction
A Temporal Delete Transaction
Glossary References
In the previous two chapters, we discussed temporal trans-
actions and the temporal entity integrity constraint to which
they must conform. We saw that, just as conventional entity
integrity applies to the non-temporal representations of objects
by those managed objects we call rows, temporal entity integrity
(TEI) applies to the temporal representations of objects by those
managed objects we call episodes and versions. TEI is the con-
straint that, within shared assertion time, no two versions of
the same object may occupy the same effective time clock tick,
and that no two episodes of the same object may do so either.
In short, it is the constraint that no two
representations
of the
same object may occupy the same effective time clock ticks.
In this chapter, we discuss temporal transactions and the
temporal referential integrity constraint to which they must con-
form. Conventional referential integrity (RI), at the level of types
rather than instances, is a relationship between two relational