O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

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

Partitioning

A partition is a logical and physical segmentation of the data in a cube. Recall that OLAP data is defined as detail rows and any associated aggregations for data retrieved from a particular source fact table. Partitions are created to make management and maintenance of cube data easier. Importantly, partitions can be processed and queried in parallel. Here are some more specific examples:

  • Scalability. Partitions can be located in different physical locations, even on different physical servers.

  • Availability. Configuring processing settings on a per-partition basis can speed up cube processing. Cubes can be unavailable for browsing during processing, depending on the type of processing that is being done. (We’ll say more about this ...

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