RE: RE: Manager decrees "his" data warehouse design. Help!

2002-03-16 Thread cjgait
Patrice, You write: "> What is the meaning of "relational" in "relational database" again?" Apparently not what you think. The relational in 'relational database' comes from the term relation--a certain type of mathematical table in set theory. It has nothing at all to do with relationships

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Jared . Still
James Morle, 'do the math' Jared "Ron Rogers" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/27/02 12:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: RE: Manage

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Rachel Carmichael
Stripe And Mirror Everything --- Michael Cupp <[EMAIL PROTECTED]> 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

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread April Wells
rows and columns... you know... like Excel. -Original Message- Sent: Wednesday, February 27, 2002 2:28 PM To: Multiple recipients of list ORACLE-L What is the meaning of "relational" in "relational database" again? Good grief. Regards, Patrice Boivin Systems Analyst (Oracle Certified

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Bellows, Bambi
Relational. Adjective. Of, or relating to, relatives. Generally pertaining to mandatory dinners or inane conversations regarding politics, religion, sex, money or military service. Of necessity, the tables are denormalized, that is, all semblance to normalcy is rejected, especially when discussing

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Michael Cupp
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 l

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Ron Rogers
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

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Boivin, Patrice J
What is the meaning of "relational" in "relational database" again? Good grief. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services--

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Jared . Still
ecipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: RE: Manager decrees "his" data warehouse design. Help! How much do you charge an hour? They want to build a table with 980 columns, because the queries fly if you index it heavily. It won&#x

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Ji, Richard
www.kx.com -Original Message- Sent: Wednesday, February 27, 2002 2:38 PM To: Multiple recipients of list ORACLE-L By taking all the joins out I think they mean basically forcing Oracle to store the row data in the same blocks since you changes the rows to columns or some such. I saw a

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Bellows, Bambi
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

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Post, Ethan
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 reci

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread Post, Ethan
By taking all the joins out I think they mean basically forcing Oracle to store the row data in the same blocks since you changes the rows to columns or some such. I saw a database out there a while back promoted by Joe Celko called KillerDB that does this but the data is still stored in rows.

RE: RE: Manager decrees "his" data warehouse design. Help!

2002-02-27 Thread April Wells
How much do you charge an hour? They want to build a table with 980 columns, because the queries fly if you index it heavily. It won't load... the indexes won't build from load to load if you drop them... but the QUERIES... they JUST F*L*Y! -Original Message- Sent: Wednesday, February 2