Re: OLAP support in Oracle

Hugh,
  Oracle doesn't have native 'Cube', Rollup functionality yet. But building
a star-schema or Snowflake schema
Fact table(s) and 1 or more dimension tables you can have Decision support
system.
The rollup fact tables (Aggregate fact tables) can be built after that base
on speed needs and data to aggregate.
  This would be a ROLAP solution. Several commercial products can support
the ROLAP solution and have there own twists on how you build them. Microstrategy (www.strategy.com) , Sagent (www.sagenttech.com). I am familiar with these two.

MOLAP solution extracts data for a DSS products like ESSBase, Arbor....Cognos others. I am not as familiar but they pull the data and put it in their database cube(s).

Some good reading on build a data mart/warehouse explains a lot of questions
/ do's and don't's with practice solutions The Datawarehouse Toolkit by Ralph Kimball.

HTH Dave Fowler
dfowler_at_smmj.com

Hugh Beever wrote in message <2_bC1.30$Po3.288931_at_newsr2.u-net.net>...
>Does Oracle support the SQL 'CUBE' and 'ROLLUP' functionality and if so
>which version? Are there other features (excluding PL/SQL) which will
help
>with building and maintaining summary tables in a data warehouse?
Anyone out
>there got a large DW with lots of summary tables they would be happy to
talk
>about?
>
>Lots of questions, hopefully lots of answers
>
>Hugh
>
>
Received on Tue Aug 18 1998 - 19:25:33 CDT