[Home] [By Thread] [By Date] [Recent Entries]


"Bullard, Claude L (Len)" <clbullar@i...> writes:

> I seldom see fully-normalized 
> databases because the overhead of getting and 
> opening tables, creating the view, etc. can be 
> prohibitive vs the maintenance of denormalized 
> data.  Otherwise, I would agree.  These aren't 
> legacy databases.  They are practical ones where 
> performance considerations dominate maintenance.

I seldom see databases denormalized because of credible performance
considerations. Most of the time it's because the DBA or the users
can't deal with so much abstraction - different parts of a relation
being in different tables - or can't be bothered to write client code
to reassemble hierarchical structures from the results of a JOIN.

Ari.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member