Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL for Modeling Generalization Hierarchies

Re: SQL for Modeling Generalization Hierarchies

From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Wed, 2 Jun 2004 10:25:01 -0700
Message-ID: <Peovc.18$642.178@news.oracle.com>


<ctcgag_at_hotmail.com> wrote in message
news:20040602125733.647$6f_at_newsreader.com...
> robertbrown1971_at_yahoo.com (Robert Brown) wrote:
> If the main or only goal is to satisfy nosy Nellies, I would either go
> with a auxilliary table of name-value pairs (and another auxilliary table
> with listing allowed or suggested attributes for each job type, or just
> do away with all those tables and make a "free text" clob column on the
> employee table (or call it XML rather than free text, if that type of
> things turns you on).

Yeah, right, make it XML, and watch your performance going down the drain.

If you want "flexible" structure, use auxilliary name-value table. Convert it into nested collection if you have object fever. Received on Wed Jun 02 2004 - 12:25:01 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US