O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required