Time and Time Again – Managing Time in Relational Databases, Part 26: Points in Time and Periods of Time

Time and Time Again – Managing Time in Relational Databases, Part 26: Points in Time and Periods of Time:

Last time, we began looking at original and temporal insert transactions but immediately digressed into a discussion of the problems that can be encountered when matching transactions to target tables. We planned to discuss both temporal entity integrity and temporal referential integrity as they apply to insert transactions in this installment. But we discovered that those discussions require another digression, this time into how we use pairs of dates to represent periods of time.