"Bullard, Claude L (Len)" <> 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.
