Data Modeling
Posts tagged “Data Modeling”.
- Timestamps Beat a Mutable Status Column
Write-once timestamps can derive current and historical status for one-way lifecycles; repeating transitions still require an event table.
- Your Date Dimension Is Not Static
Calendar attributes are stable, but columns such as IsCurrentMonth depend on query time. Persist the former and compute the latter in the serving layer.