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 (the
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
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.
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
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
[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't
load...
the indexes won't build from load to load
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--
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
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
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
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
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 have large
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: Manager decrees his data warehouse design. Help
13 matches
Mail list logo