File Library

Aggregation: The BI Server Versus the Oracle Optimizer
Topic: Business Intelligence Files
Owner: Stewart Bryson
Date: 2012-05-25
Subtopic: Kscope12

Aggregate navigation describes the functionality that BI systems have to use summary level data instead of detail level data for faster data access and report performance. When using Oracle Business Intelligence 11g and Oracle Database 11g, we can choose which “engine” we want to handle summary management and the navigation between different levels of granularity: the BI Server, or the Oracle Optimizer. Both methods support full summary management functionality, and either one is robust enough for an enterprise data warehouse. So which one should we choose? This presentation will walk the participants through both options, and investigate the different design paradigms that may favor one implementation over the other.

Download File View File   ODTUG 2012 - Aggregation.pdf

Become a member of ODTUG to gain access to more than 2,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database

Click here to see the Full Techincal Resource Database