denormalisation
Deliberately storing a copy of data in a second place, usually to make reads faster by avoiding a join.
In more detail
It trades extra write work and the risk of stale copies for cheaper reads. Do it only for a measured reason, name the source of truth, and make the copy rebuildable with a clear refresh rule. Materialised views in PostgreSQL are one managed form of it.
Related terms
- normalisation — Designing tables so each fact is stored in exactly one place, by splitting repeated data into related tables.
- source of truth — The one authoritative place a fact is recorded, from which every copy is derived instead of being maintained separately.
- materialised view — A stored table of results computed from other data, kept so queries do not have to recompute them.
Taught in
- Normalisation To Third Normal Form — PostgreSQL, Indexing & Relational Data Modeling
- When To Denormalise On Purpose — PostgreSQL, Indexing & Relational Data Modeling