Re:Oracle Vs Tera Data

2001-02-05 Thread dgoulet 

Surjit,

I think your "hardcore Tera Data" fans are also bigots.  I've a friend at
Fidelity Investments where they swear by SUN  Oracle.  The last time I talked
to him their datawarehouse was fast approaching 2PB without any problems.  They
use all of 8i's datawarehousing stuff like partitioning, hash  star joins,
etc... and haven't had a single problem.  Now if an investment banker can be
happy, why can't your bigots???

There are two basic problems with data warehouses that I've seen  it should
be noted that I'm in the middle of specing a re-wtite of ours.  1) people create
then in a normalized manner, not in the idea of a series of stars.  COnsequently
you end up with too much data in a single table making that table a real bear to
manage.  2) end users have this ungodly desire for speed.  My GOD, if your
searching through 2 or 3 billion rows of data of course it's going to take a
while.

Dick Goulet

Reply Separator
Author: "Surjit Sharma" [EMAIL PROTECTED]
Date:   2/4/2001 4:15 PM


All

I wonder if anyone out there has faced the same dilemma as I am facing
currently. Our database is likely to grow to a couple of Tera bytes.  The
existing hardware is Sun E6500 (8 Gig RAM and 10 CPUs) running SunOs 2.6
and Oracle 8.1.5. There is suspicion amongst certain hard core Tera Data
fans that Oracle can't do the following:

   Start schema in Oracle is not suitable for datawarehouses.
   Oracle is not scalable to deal with Tera bytes databases.
   Oracle partitioning is not good enough to do the job.

I feel  that Oracle has been working fine on a Sun box with about 200-300
Gig of data.
What is the price/performance of say a Sun Box vs Tera Data. I am sure
there is a huge difference.

I appreciate your valuable thoughts.

Regards

Surjit

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Surjit Sharma
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Re:Oracle Vs Tera Data

2001-02-05 Thread bill thater 

On Mon, 5 Feb 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon:

-There are two basic problems with data warehouses that I've seen  it should
-be noted that I'm in the middle of specing a re-wtite of ours.  1) people create
-then in a normalized manner, not in the idea of a series of stars.  COnsequently
-you end up with too much data in a single table making that table a real bear to
-manage.  2) end users have this ungodly desire for speed.  My GOD, if your
-searching through 2 or 3 billion rows of data of course it's going to take a
-while.

i'm currently fighting with damagement over the same issues.  "no
datawrehousing is not the same as creating a production database."  "no i
can't get the warehouse to run as fast as the production database and do it
right."

repeat the above two statments several times a day.;-)

--
Bill Thater Certified ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~
"We are different, in essence from other men.
If you want to will something run 100m.
If you want to experience something run a marathon"
Emil Zatopek
~
How do I love thee?  My accumulator overflows.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).