What is Denormalization?

0 votes
165 views
Shikhar Arora asked 06-Dec-2019 in Database by Shikhar Arora
What is Denormalization
Charlotte Turner commented 17-Dec-2020 by Charlotte Turner
This article is an appealing wealth of useful informative that is interesting and well-written. Thanks a million and please keep up the effective work. <a href="https://www.mjackets.com/product/tom-hiddleston-loki-2021-blazer/">Loki 2021 Blazer</a>
       0

1 Answer

0 votes
Rahul Roi answered 15-Dec-2020 by Rahul Roi

What is Denormalization?

If we talk About the Denormalization, it is a database optimization technique in which we add redundant data to one or more tables. It can help us avoid costly joins in a relational database. Attention that denormalization does not mean not doing normalization. This is an optimization technique that is applied after doing normalization.
Via a traditional normalized database, we store data in separate logical tables and attempt to minimize redundant data. We can try to keep only one copy of each piece of data in the database.
For instance, in a normalized database, we might have a Courses table and a Teachers table.Each entry in Courses would store the teacherID for a Course but not the teacherName. If we need to retrieve a list of all Courses with the Teacher name, we would do a join between these two tables.

What is Denormalization?