There is a good discussion @askTom about the Star Schema and Star queries (Often used with OLAP and Business Intelligence) - via Mark RittmanHow Do I Combine Relational And Multidimensional Data In A Single OLAP Cube?

The ability to present a layer of abstraction above either relational or multidimensional data held in the database has always been presented as one of the major strengths of Oracle OLAP. By describing OLAP data using general terms such as 'cubes', 'dimensions' and 'measures', query tools such as Oracle Discoverer or BI Beans can refer to data in the OLAP Catalog without needing to know in what manner that data is actually physically stored.

no comments

Please log in (you may want to register first) to post comments!