O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

Summary

This chapter covered the processes for designing physical storage for your cube. You learned about the capabilities of the three core storage modes—MOLAP, HOLAP, and ROLAP—and about aggregation design and partitioning. Remember that several of these features require the Enterprise Edition of SSAS, as noted for each feature in the text of this chapter.

The most important consideration for physical cube storage design is to get the correct balance between performance and manageability. Many customers are satisfied with MOLAP for their entire cubes, with just a bit of added custom-designed aggregations.

In the next chapter, we'll venture into the world of SSIS. You'll learn how to design basic SSIS packages, and in the process, you'll learn ...

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