Chapter 9. Processing Optimization

Chapter Objectives Estimated time: 2 hours
In this chapter, you’ll learn what happens when you process a database and you’ll learn how to

  • Avoid problems with cubes stored using HOLAP or ROLAP storage.

  • Incrementally update a dimension or a cube.

  • Avoid problems when incrementally updating a cube.

  • Use partitions to manage large cubes.

  • Use Data Transformation Services (DTS) to automate processing a database.


Conceptually, the Analysis server is a black box, mysteriously converting the values in a data warehouse into a miraculous object called a cube. And for the most part, you can simply ignore what goes on inside that black box and let the Analysis server work its magic. Knowledge is, however, power, and that adage certainly holds true in the domain of Microsoft SQL Server 2000 Analysis Services. The more you know about what goes on within the black box of the Analysis server, the better you’ll be able to troubleshoot unusual situations and find solutions to difficult problems. This chapter explains in broad terms what goes on inside the black box. The explanations are simplified, but they encompass some of the most complex topics in this book. If nothing else, this chapter can give you an appreciation for the sophistication and elegance of the Analysis server design.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.149.233.72