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

Taught in

References