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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Implementing different document types with different attribut

Re: Implementing different document types with different attribut

From: John Thomas <oracle_at_toronto.demon.co.uk>
Date: Thu, 07 Aug 2003 06:44:25 -0800
Message-ID: <F001.005C975B.20030807064425@fatcity.com>


If you're on Oracle 9i sounds like a perfect example of the use of hierarchical object types.

Cheers,

John

In message <F001.005C974F.20030807061428_at_fatcity.com>, STEVE OLLIG <sollig_at_lifetouch.com> writes
>how about 2 tables w/ a 1:many relationship? document_types each with many
>document_type_attributes. read up on data modeling. i think several good
>books were mentioned on this list recently.
>
>-----Original Message-----
>Sent: Thursday, August 07, 2003 8:34 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Hello
>
>I've an installation/implementation question!
>We've to analyse 50 document types, in total those 50 has 70 different
>attributes.
>We don't want to put all those document types into one table, because more
>than the half (35) of the attributes are not always used for each document
>type. This will have to much disk space for each record, if most of the
>fields are just blank.
>
>Has anyone suggestions how to build our table-structure?
>I've heart something about FlexFields, what are they?
>Takes every field diskspace, even if it's blank (null)?
>
>Thanks in advance for the response!
>
>Tim
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net

-- 
John Thomas

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Thomas
  INET: oracle_at_toronto.demon.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Aug 07 2003 - 09:44:25 CDT

Original text of this message

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