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.
Tagged: denormalization. normalization, oracle
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
パピヨネ バッグ
Asking questions are actually good thing if
you are not understanding something completely, except
this article gives good understanding even.
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.
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.