What’s a clean way to represent data that changes over time? How could one best model a loan with a variable interest rate? The fluctuating price of one's favorite cereal?

We can model things that change over time (variable attributes) separately from things that don't change (stable attributes). This makes it easy to store and lookup data that changes over time without unnecessarily duplicating information.

In this talk, I'll start by looking at some examples of real-world entities with variable attributes we might want to represent.

Next, I'll go over how my team worked with specific financial entities with variable attributes (like products with changing prices). I'll cover how we modeled those entities in the database to how we displayed those variable attributes to the end-user.

Presented this session virtually during covid (at Code PaLOUsa 2022) but would love the opportunity to give it in person!