Categories
Practice

Time and Time Again: Managing Time in Relational Databases, Part 4 – Preliminaries to Version Pattern 3 – DMReview

Time and Time Again: Managing Time in Relational Databases, Part 4 – Preliminaries to Version Pattern 3 – DMReview

The first two version patterns, described in Part 3, support a minimal form of queryable history in business databases. But sometimes that isn’t enough. For even if we use Version Pattern 2 – updating in place with logical deletion – there are still two important ways in which history can be lost.