Open In App

Difference between Normalization and Denormalization

Last Updated : 21 Feb, 2023
Improve
Improve
Like Article
Like
Save
Share
Report

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.

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.

Difference between Normalization and Denormalization:

S.NO Normalization Denormalization
1. In normalization, Non-redundancy and consistency data are stored in set schema. In denormalization, data are combined to execute the query quickly.
2. In normalization, Data redundancy and inconsistency is reduced. In denormalization, redundancy is added for quick execution of queries.
3. Data integrity is maintained in normalization. Data integrity is not maintained in denormalization.
4. In normalization, redundancy is reduced or eliminated. In denormalization redundancy is added instead of reduction or elimination of redundancy.
5. Number of tables in normalization is increased. Denormalization, Number of tables in decreased.
6. Normalization optimize the uses of disk spaces. Denormalization do not optimize the disk spaces.

Like Article
Suggest improvement
Previous
Next
Share your thoughts in the comments

Similar Reads