Denormalization

Problem

A perfectly normalized model may require many expensive joins for extremely frequent reads. Sometimes read performance matters more than eliminating every duplicate value.

Solution — Denormalization

Intentionally duplicate or precombine selected data.

OrderSummary
→ customer name
→ total
→ status

Core idea: denormalization trades additional consistency work and storage for simpler or faster reads.