Microsoft SQL Server 2005 Analysis Services Paperback – Dec 15 2006
|New from||Used from|
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your mobile phone number.
From the Back Cover
Microsoft SQL Server 2005 Analysis Services is definitive guide to programming Analysis Services2005. It will give you unparalleled insight into the ways in which Analysis Services functions straight from the members of the Analysis Services team at Microsoft . It not only explains ways to use Analysis Services 2005 to design and create multidimensional objects, databases, dimensions, cubes, but it also provides invaluable information about the reasons behind design decision taken by the development team.Chapters include:
- Introduction to Analysis Services
- Creating Multidimensional Models using Analysis Services
- High availability
- Localization and Globalization
About the Author
Edward Melomed is one of the original members of the Microsoft SQL Server Analysis Services team. He arrived in Redmond as a part of Microsoft's acquisition of Panorama Software Systems, Inc., which led to the technology that gave rise to Analysis Services 2005. He works as a program manager and plays a major role in the infrastructure design for the Analysis Services engine.
Irina Gorbach is a senior software designer on the Analysis Services team, which she joined soon after its creation nine years ago. During her time at Microsoft, Irina has designed and developed many features, was responsible for client subsystems OLEDB and ADOMD.NET, and was in the original group of architects that designed the XML for Analysis specification. Recently she has been working on the architecture and design of calculation algorithms.
Alexander Berger was one of the first developers to work on OLAP systems at Panorama. After it was acquired by Microsoft, he led the development of Microsoft OLAP Server through all its major releases. He is one of the architects of OLEDB for the OLAP standard and MDX language, and holds more than 30 patents in the area of multidimensional databases.
Py Bateman is a technical writer at Microsoft. She originally hails from Texas, which was considered a separate country on the multinational Analysis Services team.
See all Product Description
Most Helpful Customer Reviews on Amazon.com (beta)
This is the 1st book which not only covers all the spectrums of Microsoft SQL Server 2005 Analysis Services but also reveals how the core OLAP engine handles various tasks such as creating execution plan for cube processing; coordinating thread pools; handling dependencies;... It also describes each processing job's features (like whether it's a single- or multi- threaded task; how resource intensive it is;...) in great details.
If you are interested in the OLAP physical storage (for example, how different types of data are stored and compressed; how the bitmap index is created and optimized; how the hash table is constructed to enable fast access; what the file extension .ahstore\.kstore\.map\... stands for;...), then this is the book for you because the authors are OLAP engine gurus who know the physical structure inside out.
Once equipped with the deep engine knowledge, you would be empowered for a high scalable and performing OLAP solution architecture, design and implementation. It will also help you with the capacity planning to better match the hardware selection with your processing window.
That's why I think this book is "The Key for Deep Divers".
Despite of its 900 pages, the book is filled with useful information that you don't find anywhere else, neither in MSDN and BOL, nor in other books and blogs.
This book is absolutely not "yet another book about Analysis Services" and dramatically distinguishes itself over Wrox's publications.
By the depth of the material presented, this book can be put in the same category as such wonderful books as Inside Microsoft SQL Server 2005 by Itzik Ben-Gan and Kalen Delaney.
Analysis Services 2005 is a serious book for serious people, but in no way dry or boring. I swallowed it in few days as a breathtaking adventure.
However, if you have specific implementation problem, there are really no solution short cuts in the book. On the other hand, you can probably figure out if you will be able to solve it by digging into the specifics of Analysis Services implementation.
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Networking & Cloud Computing > Data in the Enterprise > Client-Server Systems
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design