Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Vs Tera Data

RE: Oracle Vs Tera Data

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Mon, 05 Feb 2001 11:45:12 -0800
Message-ID: <F001.002AAB3E.20010205081714@fatcity.com>

Surjit,

In my experience, Sun storage ( the A5000 stuff, etc. ) does not do the best possible job.

But, then again, you may be on Fujitsu, EMC, or some other good storage vendor.

(Dick, liked your comments about normalization and adjustment  expectations...)

hth

Ross

-----Original Message-----
From: dgoulet_at_vicr.com [mailto:dgoulet_at_vicr.com] Sent: Monday, February 05, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L Subject: Re:Oracle Vs Tera Data

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" <surjit_at_au1.ibm.com> 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: surjit_at_au1.ibm.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:
  INET: dgoulet_at_vicr.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 Mon Feb 05 2001 - 13:45:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US