Re: platform/version choices

If I did not yet have a piece of hardware to run it ... I would not use Oracle on any of the hardware you are considering. While Oracle can definitely handle terabyte datamarts ... it is not necessarily the optimum solution.

I'd go straight to NCR and explore Teradata. And then do a side-by-side comparison of the two. But hardware wise I'd go with HP or SUN. Compaq is a joke at the terabyte size and IBM too expensive and not at the top of Oracle's bug-fix priority list.

Oracle sells a transparent gateway to Teradata that, in some cases, allows the best of both worlds. Oracle's packages, procedures, and triggers with Teradata's ability to handle massive amounts of data (do not buy the Teradata people's claims about their procedures and triggers ... they are no match for Oracle).

(Just one person's opinion. And BTW you can host Oracle databases on the Non-TPA node of a Teradata machine).

Daniel Morgan

Piet de Visser wrote:

> Group,
>
> As an occasional visitor to the group,
> I may be opening an old discusion.
> Please forgive me.
>
> I'm involved in startup of a Terabyte "datamart" project
> and I'm looking to pick some of your brains on the following questions
>
> 1 - Choice of unix platform; any one of (alphabetical):
> Compaq, HP, IBM, SUN.
> Factors to weigh in:
> - Oracle's best, stable, track record (ora-dev platform)
> - ease of management, scalability.
>
> 2. Version of Oracle, 817 or 90x.
> Factors:
> - Stability
> - Perormance / features
> - ease of management.
> pro v817 : proven technologie, most bugs should be found by now
> pro v90x : more features, possibly better perforance.
>
> Additional factors:
> - A choice sees to be made for informatica/powercentre,
> not sure yet if that locks me in on plantform or version.
> Any info is welcome.
> - Not an issue : we will not consider use of RAC yet.
>
> Looking Fw to some discussions,
>
> PdV
Received on Thu Feb 07 2002 - 14:43:16 CST