Difference between Normalization and Denormalization

Normalization and Denormalization are used to alter the structure of a database. The main difference between normalization and denormalization is that normalization is used to remove the redundancy in the table, while denormalization is used to add the redundancy which means combining multiple tables so that execute query quickly. In this article, we'll explore the key differences between Normalization and Denormalization and how they impact database design.

What is the Normalization?

Normalization is the method used in a database to reduce the data redundancy and data inconsistency from the table. It is the technique in which Non-redundancy and consistency data are stored in the set schema. By using normalization the number of tables is increased instead of decreased.

Advantages

• Data is reduced in the table.
• Optimized memory.
• Maintain data integrity.

Disadvantages

• The number of tables is increased.
• Consume more resources when using joins expensive operations.

What is the Denormalization?

Denormalization is also the method which is used in a database. It is used to add the redundancy to execute the query quickly. It is a technique in which data are combined to execute the query quickly. By using denormalization the number of tables is decreased which oppose to the normalization.

Advantages

• Execute the query quickly.
• Decreased the number of tables.

Disadvantages

• Wastage of memory because store the duplicate data.
• Increase the number of tables.
• Does not maintain data integrity.

Difference Between Normalization and Denormalization

Conclusion

Normalization and Denormalization both are the method which use in database but it works opposite to each other. One side normalization is used for reduce or removing the redundancy which means there will be no duplicate data or entries in the same table while Denormalization is used for add the redundancy into normalized table so that enhance the functionality and minimize the running time of database queries (like joins operation ).