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 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:
|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.|
Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.
- Denormalization in Databases
- Introduction of Database Normalization
- Normalization vs Standardization
- Normalization Process in DBMS
- Difference between Stop and Wait, GoBackN and Selective Repeat
- Difference between Stop and Wait protocol and Sliding Window protocol
- Similarities and Difference between Java and C++
- Difference between Yaacomo and and XAP
- Difference between VoIP and and POTS
- Difference and Similarities between PHP and C
- Difference between Time Tracking and Time and Attendance Software
- Difference Between Single and Double Quotes in Shell Script and Linux
- Difference between ++*p, *p++ and *++p
- Difference Between DOS and Windows
- Difference between User Level thread and Kernel Level thread
- What’s difference between The Internet and The Web ?
- Difference between Priority Inversion and Priority Inheritance
- What’s difference between Linux and Android ?
- What’s difference between header files "stdio.h" and "stdlib.h" ?
- Difference between HTML and HTTP
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.
Improved By : Groudon