Denormalization - CI/CD Glossary Definition
Denormalization deliberately duplicates or pre-joins data so reads avoid expensive joins, trading storage and write complexity for query speed.
The trade-off
A denormalized column or summary table must be kept consistent with its source on every write, often through application logic or a backfill, which is the cost paid for faster reads.