Implementing Slowly Changing Dimensions in Postgres
October 21–24
Level: Intermediate
Slowly Changing Dimensions (SCD) are a popular method to model changes of database reference values over time and maintain history data, for example product prices that change over time. When correctly used, they are powerful and provide a structured way to simplify complex data models. This talk will review six types of SCDs and discuss how the most relevant type can be modeled in Postgres, and how JSONB, the daterange data type, and the btree_gist extension can be used to create very elegant and powerful SCD implementations in Postgres.
