SQL SERVER 2008 – What is Normalization and Denormalization

Normalization

Check out the article Q100139 from Microsoft knowledge base and of course, there’s much more information available in the net. It’ll be a good idea to get a hold of any RDBMS fundamentals text book, especially the one by C. J. Date. Most of the times, it will be okay if you can explain till third normal form.

Denormalization

As the name indicates, denormalization is the reverse process of normalization. It’s the controlled introduction of redundancy in to the database design. It helps improve the query performance as the number of joins could be reduced.

Reference : Dilip Kumar Jena ( https://sqlexplore.wordpress.com )

Advertisements

One thought on “SQL SERVER 2008 – What is Normalization and Denormalization

  1. Very informative post. Its really helpful for me and beginner too. Check out this link too its also having a nice post related to this post over the internet which is also explained very well about denormalization concept in database…

    http://mindstick.com/Articles/2168d768-017c-41f4-a7a3-ac76faabb48d/?Denormalization%20in%20SQL%20Server

    Thanks

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s