Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
what is the difference between normalization and denormalization?
Solved! Go to Solution.
Hi @waleed111
Sr. No. Key Normalization Denormalization
1 | Implementation | Normalization is used to remove redundant data from the database and to store non-redundant and consistent data into it. | Denormalization is used to combine multiple table data into one so that it can be queried quickly. |
2 | Focus | Normalization mainly focuses on clearing the database from unused data and to reduce the data redundancy and inconsistency. | Denormalization on the other hand focus on to achieve the faster execution of the queries through introducing redundancy. |
3 | Number of Tables | During Normalization as data is reduced so a number of tables are deleted from the database hence tables are lesser in number. | On another hand during Denormalization data is integrated into the same database and hence a number of tables to store that data increases in number. |
4 | Memory consumption | Normalization uses optimized memory and hence faster in performance. | On the other hand, Denormalization introduces some sort of wastage of memory. |
5 | Data integrity | Normalization maintains data integrity i.e. any addition or deletion of data from the table will not create any mismatch in the relationship of the tables. | Denormalization does not maintain any data integrity. |
6 | Where to use | Normalization is generally used where number of insert/update/delete operations are performed and joins of those tables are not expensive. | On the other hand Denormalization is used where joins are expensive and frequent query is executed on the tables. |
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi @waleed111
Sr. No. Key Normalization Denormalization
1 | Implementation | Normalization is used to remove redundant data from the database and to store non-redundant and consistent data into it. | Denormalization is used to combine multiple table data into one so that it can be queried quickly. |
2 | Focus | Normalization mainly focuses on clearing the database from unused data and to reduce the data redundancy and inconsistency. | Denormalization on the other hand focus on to achieve the faster execution of the queries through introducing redundancy. |
3 | Number of Tables | During Normalization as data is reduced so a number of tables are deleted from the database hence tables are lesser in number. | On another hand during Denormalization data is integrated into the same database and hence a number of tables to store that data increases in number. |
4 | Memory consumption | Normalization uses optimized memory and hence faster in performance. | On the other hand, Denormalization introduces some sort of wastage of memory. |
5 | Data integrity | Normalization maintains data integrity i.e. any addition or deletion of data from the table will not create any mismatch in the relationship of the tables. | Denormalization does not maintain any data integrity. |
6 | Where to use | Normalization is generally used where number of insert/update/delete operations are performed and joins of those tables are not expensive. | On the other hand Denormalization is used where joins are expensive and frequent query is executed on the tables. |
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |