Denormalization

Denormalization deliberately introduces redundancy into a schema, for example by copying a value or precomputing an aggregate, to speed up certain reads. It is done knowingly, since you must then keep the copies consistent. It is common in analytics.

Example

Store the customer name in the sales table to avoid a join.

Related concepts

The whole glossary