| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RE: Manager decrees "his" data warehouse design. Help!
Well, you know the saying, SAME is LAME.
Let's just forget all this database crap. Use a humongous flat file, get yourself the GNU version of grep with the Boyer-Moore search algorithm, add cut, paste and awk.
Who needs an RDBMS anyway?
As for disks getting faster, in the words of James Morle, 'do the math'
Jared
"Ron Rogers" <RROGERS_at_galottery.org>
Sent by: root_at_fatcity.com
02/27/02 12:48 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: RE: Manager decrees "his" data warehouse design. Help!
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).
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).
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:
INET: Jared.Still_at_radisys.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 - 15:53:39 CST
 |
 |