Re:Oracle Vs Tera Data

From: <dgoulet_at_vicr.com>
Date: Mon, 05 Feb 2001 08:02:20 -0800
Message-ID: <F001.002AA8F9.20010205064046@fatcity.com>

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
--------------------------------------------------------------------