Chapter II: Databases & Data Modeling
Normalization & Denormalization
Reducing redundancy vs. duplicating data to optimize read performance.
In short
Normalization removes redundancy; denormalization re-introduces it to speed up reads.
Loading diagram…
Key takeaways
- Normalization = integrity & fewer anomalies; denormalization = faster reads.
- Normalize first, denormalize hot paths deliberately.