Significance of De-normalization

De-normalization is adding of  redundant data to already normalized data set to improve performance without incurring additional  data maintenance and sacrificing the integrity of data

Why should you De-normalize?

While normalization makes it easy to input correct data , it also  makes it difficult to get it out. This is why you  should de-normalization your data. The advantages of de-normalization are faster selects & reduced joins at the cost of slower updates and additional storage.

Personally  I have seen up to 300% performance improvement with de-normalization  when complex joins are  involved. I fully support  exploring of de-normalization to dba’s/developers.

Advertisements

Tagged: ,

5 thoughts on “Significance of De-normalization

  1. http://google.com February 14, 2013 at 3:49 pm Reply

    I actually think this amazing blog post , “Significance of De-normalization swerveDBA”, very interesting
    plus the blog post was in fact a good read. Thanks for the
    post-Ollie

  2. ダンヒル 財布 November 12, 2013 at 3:40 am Reply

    パピヨネ バッグ

  3. url shortener bitly October 11, 2014 at 12:48 am Reply

    Asking questions are actually good thing if
    you are not understanding something completely, except
    this article gives good understanding even.

  4. かた焼 June 3, 2015 at 1:11 am Reply

    I blog often and I genuinely appreciate your information.
    This article has really peaked my interest. I’m going to bookmark your site and keep
    checking for new details about once per week. I opted in for your Feed too.

  5. link vao m88 moi nhat July 13, 2015 at 5:30 am Reply

    Hi there, You have done a fantastic job. I’ll definitely digg it and personally recommend to my
    friends. I am confident they will be benefited from this website.

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

%d bloggers like this: