Re: Normalizing vs. Denormalizing
From: SSpiars <sspiars_at_aol.com>
Date: 1996/03/26
Message-ID: <4ja7rf$p5b_at_newsbf02.news.aol.com>#1/1
Date: 1996/03/26
Message-ID: <4ja7rf$p5b_at_newsbf02.news.aol.com>#1/1
Both normalized and denormalized designs have their advantages. So the answer here is, it depends! With normalized design you will have less duplication, but more joins. With denormalized you will have some duplication and less joins (if done correctly). You also run the risk of losing data integrity when you have duplicate data in different tables. Your design will also vary if your system is read-only, rather than heavy insert. Normalize when you can, denormalize when you must.
Shawn Spiars, Senior DBA
American General Life Insurance Co.
Received on Tue Mar 26 1996 - 00:00:00 CET