Categories
General Tools

Time and Time Again: Managing Time in Relational Databases, Part 14 – Versioning with Surrogate Keys

Time and Time Again: Managing Time in Relational Databases, Part 14 – Versioning with Surrogate Keys:

Beginning with Version Pattern 6, we will use surrogate version keys in all versioned tables. But note that the phrase “surrogate version keys” should be read as “surrogate keys for versions,” and not as “keys for surrogate versions.” We are recommending the use of surrogate keys for versioned tables. We are not introducing a concept of “surrogate versions.”