Skip to main content

Database denormalization is the action of adding redundant data to database for performance optimization. This is the opposite to normalization where data is split into separate tables.

Database denormalization is the action of adding redundant data to database for performance optimization. This is the opposite to normalization where data is split into separate tables.

The definition of denormalization in Fundamentals of Database Systems, Elmasri, Navathe, 6th ed:

Denormalization is the process of storing the join of higher normal form relations as a base relation, which is in a lower normal form.

Wikipedia - Denormalization