Hi friends,
Can you please explain me What is Denormalization?
Are there any advantages?
Can you give some examples in the real time where denormalizing is required?
Thank You
Suroop
Printable View
Hi friends,
Can you please explain me What is Denormalization?
Are there any advantages?
Can you give some examples in the real time where denormalizing is required?
Thank You
Suroop
Denormalization generally refers to bending the rules of third normal form (3NF) in order to improve performance.
There are many posts that will explain normalization (3NF), but in general, it means
the key, the whole key, and nothing but the key, so help me Codd.
[Edited by dknight on 03-13-2002 at 12:11 PM]
Something interesting on Denormalization:
http://www.firstsql.com/dbdebunk/fp5a.htm