Re: olap functionality in an ORACLE Rdbms

ORACLE has a very nice DOC on data warehousing, definitely look it up. You can look up ORACLE 9i OLAP as well, although it may not be useful to you at this point. As to aggregations, find out from users what you want to see, that would give you some ideas as to what to aggregate. And then monitor data mart usage and see how often these MVs are queried. Add or drop accordingly.

• Jusung Yang

Asim <member26812_at_dbforums.com> wrote in message news:<2718626.1049262839_at_dbforums.com>...
> I am using Oracle 9i Database.
>
> I have built a sales schema for my data mart, which include 7
> dimension tables and one fact table.
>
> I DONT have any olap engine.
>
> Can anyone guide me or give me some hints how I can provide the
> olap functionality by using only oracle 9i database.
> Some one told be about materialized views and query rewrite features
> of oracle 9i, but how can I
> precalculate all aggregations. If i precalculate only few
> aggregation then
> how can i decide that which few aggrigations are to be precalculated
> and which should be calculated at runtime.
>
> Thanks in Advance
Received on Wed Apr 02 2003 - 19:24:36 CEST