Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Materialised Views
Thanks Alistair,
I suppose my question is "If we have an unlimited budget and can afford an Oracle DW feeding into an OLAP data mart is this a better solution than having the Orcale DW with some materialised views for reporting and data analysis ?"
Steve
<alistair.thomson_at_sphinxcst.co.uk> wrote in message
news:87eoae$7bl$1_at_nnrp1.deja.com...
> A materialized view is used to summerise data. This could result in a
> fact table with millions of records being summarised to a MV of
> thousands of records. The query response time is infinately faster. OLAP
> tools should also benefit from this if they are reporting directly from
> the MV.
>
> Alistair Thomson
>
> In article <87e43m$pi7$1_at_gxsn.com>,
> "Steven Price" <prices_at_globalnet.co.uk> wrote:
> > Has nyone used the new mterialised views and how do they compare to
> using an
> > OLAP tool
> >
> > We are building a DW wth fact tables of about 100 million rows which
> users
> > want to use for ad-hoc analysis.
> > There are about 6 dimensions.
> >
> > Steve
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Feb 05 2000 - 12:27:09 CST