denormalization
n.n. the process of adding repeated data back into a database to make it run faster. While it makes the database larger, it helps the computer find information more quickly because it doesn't have to look in as many places.
n. the strategy of intentionally introducing redundancy into a previously normalized database schema to improve read performance. Often involves combining tables or adding redundant columns to reduce the computational cost of complex join operations.
The team used denormalization to speed up the website's search results.
After noticing that the reporting dashboard was taking several seconds to load, the database administrator decided that some denormalization was necessary for the sales tables.
While normalization minimizes data anomalies by reducing redundancy, strategic denormalization is frequently employed in high-scale distributed systems where read latency is a more critical constraint than storage efficiency.
Formed from the prefix de-, indicating reversal or removal, and the noun normalization. The term follows the established nomenclature of relational database theory, specifically the normal forms proposed by E. F. Codd.
Etymology adapted from Wiktionary, available under CC BY-SA 4.0.
Commonly used in the context of database administration and software engineering.
Last updated July 22, 2026