Re: Datawarehouse with Oracle

From: James Williams <willjamu_at_mindspring.com>
Date: Tue, 02 Jul 2002 12:22:39 GMT
Message-ID: <3d219955.8811950@nntp.mindspring.com>

On 2 Jul 2002 00:32:45 -0700, xtanto_at_hotmail.com (Krist) wrote:

There are many products out there. Since you just mention Oracle.

Oracle Warehouse Builder - need an ETL tool unless you RYOC plus metadata.
Oracle Discoverer - AD hoc query tool. Have the admin build EUL and pass off to user.

More and more of the capability of Oracle Express (OLAP) is being added to the RDBMS especially in 9i. You have CUBE, ROLLUP, functions even in 8i so you have a lot of what you need.

Also, you need good diminsional modeling skills. Fact tables and dimensions are the norm in warehouses. So is denormalization. Also, read the Oracle data warehousing guide. You need to set your hardware and database up appropriately.

>Hi All,
>
>If we want to implement Datawarehouse and OLAP with Oracle, besides
>Oracle RDBMS Server, what are other Oracle products that I need to
>purchase ?
>
>Thanks a lot for the info,
>Krist
Received on Tue Jul 02 2002 - 07:22:39 CDT