In this guide, you will learn the difference between Denormalization and Normalization.
What is Denormalization
Denormalization is a process of adding redundant data to tables in order to get faster response time for read operations. However this better performance comes with a cost of storing redundant data that occupies additional storage in the database.
Denormalization is covered in detail with examples here.
What is Normalization
Normalization is a process of breaking the table into multiple tables in such a way so that the redundant data is reduced. This removes data inconsistencies and helps maintaining DBMS ACID properties.
Normalization is covered in detail with examples here.
Denormalization vs Normalization
|It provides faster data access as costly time intensive join operations are not required.||Data access (or read) is slower as the join operations are required when accessing data from multiple tables.|
|SQL queries are easy to write as it involves less tables.||SQL queries are complex as they usually involve multiple tables.|
|Redundant data is present.||No redundant data exists.|
|Data inconsistencies are present as same data is available at more than one tables due to data redundancy.||No data inconsistencies as normalization removes data redundancy.|
|Data write operations are slower due to redundant data.||Data write operations are faster.|
|Requires more storage.||Requires less storage.|