Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Manager decrees "his" data warehouse design. Help!
Stripe And Mirror Everything
--- Michael Cupp <michaelcupp_at_SHONAC.com> wrote:
> S.A.M.E.?
>
> -----Original Message-----
> Sent: Wednesday, February 27, 2002 3:48 PM
> To: Multiple recipients of list ORACLE-L
>
>
> At one of the Oracle Application group meetings it was stated that it
> is better to have large tables and forget normalization. Disks are
> getting faster and you can read a lot more data from one disk reather
> that getting your data from many disk locations. Also it doesn't
> really matter the size of the tables if you use the S.A.M.E theory.
> All disks are treated as one disk farm today. I haven't tried it but
> it sounded reasonable. ROR mª¿ªm
>
> >>> BBellows_at_usg.com 02/27/02 03:08PM >>>
> Also not uncommon when tracking medical data.
>
> Bambi.
>
> -----Original Message-----
> Sent: Wednesday, February 27, 2002 1:53 PM
> To: Multiple recipients of list ORACLE-L
>
> Some of the tables in J.D. Edwards OneWorld have over 200 columns,
> VARCHAR is not used, only NUMBER and CHAR. Makes for some wide
> tables. This product was originally some type of flat file database.
>
>
> Ethan
>
> -----Original Message-----
> Sent: Wednesday, February 27, 2002 1:28 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I think the column limit is now closer to 1000, but like you, I can't
>
> imagine
> willingly designing a table with a column count exceeding 2 digits.
>
> More than 15 or 20 and I start to question the design.
>
> Jared
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
> INET: Ethan.Post_at_ps.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Bellows, Bambi
> INET: BBellows_at_usg.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Michael Cupp
> INET: michaelcupp_at_SHONAC.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: wisernet100_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 Wed Feb 27 2002 - 16:02:10 CST
![]() |
![]() |