olap functionality in an ORACLE Rdbms

From: Asim <member26812_at_dbforums.com>
Date: Wed, 02 Apr 2003 05:53:59 +0000
Message-ID: <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

--
Posted via http://dbforums.com

Received on Wed Apr 02 2003 - 07:53:59 CEST

This message: [ Message body ]
Next message: Yvonne Dishon: "Datafile Rename Problem"
Previous message: andrewst: "Re: SQL-Query with many equal subselects"
Next in thread: Jusung Yang: "Re: olap functionality in an ORACLE Rdbms"
Reply: Jusung Yang: "Re: olap functionality in an ORACLE Rdbms"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message