Denormalization: Intermediate Step{5}


by Jasmine C
The article I read about is very informative.  A quick synopsis of the article is that it discusses a lot of information regarding the techniques of denoralization and the pros and cons of normalization vs denoralization.  Today, normalization is the way to designing a relational database.  However, the biggest disadvantage of normalization is that system performance is very poor.  With normalization, data is organized so that there is minimal updating and data is easily accessible.   At the moment, denormalization techniques do not have concrete guidelines to guide the process.   However, denormalization shows a positive effect on a databases’s performance.   It has been proposed that denormalization be used, in addition to normalization, to play as a middle step to help with system performance .  This article describes three approaches that are used to review the donormalization strategies.  Each of the approaches shows how denormalization positively affects databases.

I like this article because it takes into consideration compromise.  Since normalization isn’t perfect, people are finding ways to make it more efficient, hence denormalization.  With denormalization, system performance can be more more efficient  and that is a plus for everyone.  With denormalization, a person needs to know when to use it.  If they use it when it is not needed then instead of helping their system it might just hinder it.  I like the advantages and the disadvantages this article provides in regards to normalized vs denormalized databases.

This article relates to class because we as students can relate it to how we can make sure that our database works efficiently.  When we have to work on our projects, we now know that we are not only restricted to the use of normalized data.  We can also use denormalized data or a combination of the two.

Shin, S. (2002). Denormalization effects on performance of relational database for data warehouse.ProQuest Dissertations and Theses. Retrieved February 5, 2012 from http://search.proquest.com/docview/251638044/fulltextPDF?source=fedsrch&accountid=10357