Databases Reference
In-Depth Information
10
TEMPORAL TRANSACTIONS
ON SINGLE TABLES
The Temporal Insert Transaction
Creating an Episode
216
Lengthening an Episode Backwards
Lengthening an Episode Forwards
Merging Episodes
220
The Temporal Update Transaction
222
Restricted and Unrestricted Temporal Transactions
The Temporal Delete Transaction
Deleting One or More Episodes
Shortening an Episode Forwards
Shortening an Episode Backwards
Splitting an Episode
231
Completeness Checks
233
An Allen Relationship Completeness Check
233
A Temporal Extent Transformation Completeness Check
Glossary References
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 how the AVF responds
to each one. Its response has two parts. After performing the edit
and validity checks described in the previous chapter, the AVF
looks to see if applying a transaction would violate temporal
entity integrity (TEI) or temporal referential integrity (TRI). If it
would violate either one, the transaction is rejected.
Otherwise, the temporal transaction is translated into one or
more physical transactions which are then submitted to the
DBMS. If the DBMS finds that applying any of those physical
transactions would violate an entity integrity or a referential
integrity constraint, it will reject that transaction. In response,
the AVF will stop processing the temporal transaction, undo