What is the definition of normalized and denormalized view and what are the differences between them

Showing Answers 1 - 5 of 5 Answers


  • Apr 2nd, 2006

  1. what is the definition of normalized and denormali...

sandhya kappagantu

  • Apr 19th, 2006

Normalization is the process of removing redundancies.

Denormalization is the process of allowing redundancies.

  Was this answer useful?  Yes


  • May 13th, 2006

OLTP  uses the Normalization process and

the OLAP/DW uses uses the denormalised process to capture greater level of detailed data(each and every tranaction)



  Was this answer useful?  Yes


  • Jul 19th, 2006

Normalized View-> Process of eliminating the redundencies.

Denormalized View-> process the data where duplication takes place. Which means it is not stop the replication.

  Was this answer useful?  Yes


  • Aug 16th, 2006

I would like to add one more pt. here, as OLTP is in Normalized form, more no. of tables are scanned or referred for a single query, as through primary key and foreign key data needs to be fetched from its respective Master tables. Whereas in OLAP, as the data is in De-normailzed form, for a query the no. of tables queried are less.

For eq.:- If we have a banking appln., in OLTP env., we will have a separate table for customer personal details , Address details, its transaction details etc..Whereas in OLAP env. these all details can be stored in one sinlge table thus decreasing the scanning of multiple tables for a single record of a customer details.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions