Optimizing an OLAP Database

As mentioned previously, in order to use your OLAP database, you must first process the cubes that are contained within the database. Simply stated, processing the cube populates the cube definition with actual transactional data from your data warehouse or data mart. Before you actually populate your cube, however, you need to define certain optimization definitions for your cube. Analysis Services provides two primary mechanisms for optimizing the cubes within OLAP databases:

  • Aggregations

  • Partitions

Aggregations

Aggregations are summaries of data that are calculated by the Analysis Server and stored in the database along with the transaction level cube data. For example, an aggregation of data would be the total sales ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.