Question

In your own word, explain why do designers use Denormalization? What is the limitation of using Denormalization? Name and explain a better alternative approach than Denormalization..

Answer 1

Denormalization has several benefits:

Sometimes doing the join operation between tables is a very costly operation, that overhead is reduced by using denormalization.

It gives a huge boost to the performance of several operations

It minimizes the need to do joins

There are some limitations as well:

It can slow down the update speed of database

It may increase the size of tables

It wastes storage space.

One more approach that is sometimes more beneficial than denormalization is normalisation:

It reduces data redundancy that denormalization does not

Memory space is optimised

It minimises the null values