Why Varying Arrasy and Nested Tables?
Date: Sat, 05 Oct 2002 14:26:13 -0700
Message-ID: <64mupugprsd7mq1d6a9ns0bae9u3kada79_at_4ax.com>
I've worked with Oracle extensively since version 3 in 1984. In all
that time Oracle preached the glories of normalized data. I'm a
believer. The relational model has held up very well for many years,
and seems very robust to me.
Then comes Oracle 8i and 9i with Nested Tables and Varying Arrays.
Aren't Varying Arrays-presumably a Good Thing, since Oracle has
them-the same thing as repeating fields, which Oracle used to condemn
as a Bad Thing? Didn't we just de-normalize our data? And aren't
Nested Tables just a more complex type of Varying Array?
Both of these things add significnat complexity, it seems to me, to an
already numbingly complex product. What do we gain with the addition
of these things?
Can anybody speak to this? Or point me toward a discussion of the
pros and cons?
tnx
rww
wolfer_at_peak.org
Received on Sat Oct 05 2002 - 23:26:13 CEST