Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Normalization
I'd love to hear comments on the following Q&A (by a well-known Oracle
"expert"). Do list members think that this view prevails today? Am I
correct in believing that the importance of normalization, and the
reasons for that importance, are given short shrift by many DB
designers?
Q: What are the basic guidelines one should keep in mind while designing a database? Is denormalization always good?
Today, I always introduce redundancy into the model whenever it can eliminate an SQL join, but not always. I make my decision based on two criteria:
1 – The size of the redundant item
2 – The volatility of the item (e.g. how often do I need to duplicate updates)
![]() |
![]() |