Categories
General Tools

Time and Time Again: Managing Time in Relational Databases, Part 7

Time and Time Again: Managing Time in Relational Databases, Part 7: Completing Version Pattern 4 – DMReview

As we saw in Part 6, what distinguishes Pattern 4 from Pattern 3 is bi-temporality. With Pattern 4, the business effectivity begin date of a version can be different than the date the version was physically inserted into its table. This was not possible with Pattern 3.