Categories
General

Time and Time Again: Managing Time in Relational Databases, Part 22 – Original and Temporal Deletes

Time and Time Again: Managing Time in Relational Databases – Part 22: Original and Temporal Deletes:

For the sake of continuity, we repeat the following material from the previous article.
 
If there is a temporal RI dependency from table Y to version table X (not necessarily distinct), then no exposed state of the database is valid in which any row in table Y is not object-RI linked to a row in table X, or in which the effectivity time period of a row in table Y is not wholly contained within the effectivity time period of its parent row in table X. No queries are valid which would expose such a state.