Session Details

Representing and Accessing Data That Changes Over Time

Regular Session

This talk answers the question “What’s a clean way to represent data that changes over time?” We can store the attributes that change over time (variable attributes) on a versioned table and stable attributes on a base table. Storing variable attributes in a versioned table with an effective date range makes it easy to find which version is applicable for a given date. We’ll look at some examples of entities with variable attributes (e.g. a loan, an editable product) how to represent them as versioned records. After coverings the basics of representing versioned records, we’ll go over a few invariants to maintain to ensure a consistent representation of versioned records. To wrap up, I’ll demonstrate how to look up all attributes for a versioned record. This way, when looking up a record, we can get both the versioned and stable attributes in one shot.

A software development conference in the Louisville, KY area on August 18 - 20, 2021 designed to cover all aspects of software development regardless of development stack.

Keep in Touch