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

Home -> Community -> Usenet -> c.d.o.server -> Re: Data warehouse feature?

Re: Data warehouse feature?

From: Uday Bikkasani <udayb_at_bigfoot.com>
Date: 27 Nov 1998 16:21:33 PST
Message-ID: <73nfmd$krd@chronicle.concentric.net>


If you are looking for some advanced features look at the white papers for Oracle 8i. They have added some cool features to make data Warehousing Easy and Faster. They have added some of Oracle express features into oracle 8i

uday

Joel R. DeRider <deriderj_at_concentric.net> wrote in message news:73lijc$dvf_at_journal.concentric.net...
>Hi Jimmy,
>
>Oracle 8 is the release you will want to use for warehousing. It has major
>advancements in parallelism in query, loading, index builds, etc. In
>addition is has a functioning optimizer that will, given the proper schema
>implementation, provide special access paths using star schema
optimization.
>
>I have spent much time with Oracle and warehousing, working on both small
>data marts (100-150 gigabytes) and large scale implementations (500+
>gigabytes). If you have not done this before, be forewarned that you will
>need exceptional hardware to make data warehousing work.
>
>Don't think in small terms, because it will be a waste of time and effort.
>As an example, the smallest, useable implementation I have dealt with at
100
>gigabytes was a four way SMP with 2 gigabytes of memory and 16 disks using
>IBM's extraordinary SSA disk. This was an NT implementation. It was
actual
>failing until we purchased the IBM disk. Warehousing eats machine
>resources!
>
>Hope this helps,
>
>Joel R. DeRider
>Jimmy wrote in message <365E337D.1834_at_comp.polyu.edu.hk>...
>>Hello all,
>>
>> What are the features of Oracle (and version?) that help to develope
>>the data warehouse?
>>
>>Thanks,
>>Jimmy
>
>
Received on Fri Nov 27 1998 - 18:21:33 CST

Original text of this message

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