|
Microsoft SQL Server 2005 Analysis Services |  | Authors: Edward Melomed, Irina Gorbach, Alexander Berger, Py Bateman
Publisher: Sams
Category: Book
List Price: $64.99
Buy New: $5.48
as of 9/8/2010 21:15 CDT details
You Save: $59.51 (92%)
New (33) Used (25) from $1.16
Seller: purpleturtleproducts
Rating:  19 reviews
Sales Rank: 547867
Media: Paperback
Edition: 1
Pages: 864
Number Of Items: 1
Shipping Weight (lbs): 2.8
Dimensions (in): 9.1 x 7 x 2.1
ISBN: 0672327821
Dewey Decimal Number: 005
EAN: 9780672327827
ASIN: 0672327821
Publication Date: December 25, 2006
Availability: Usually ships in 1-2 business days
| |
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
Microsoft SQL Server Analysis Services provides fast access to data by means of multidimensional data structures and the multidimensional query languag MDX. Analysis Services provides the capability to design, create, and manage multidimensional cubes based on data warehouse tables, and it serves as the foundation for the Microsoft Business Intelligence strategy. Microsoft SQL Server 2005 Analysis Services gives the reader insight into the way Analysis Services functions. It not only explains ways to design and create multidimensional objects, databases, dimensions, and cubes, but also provides invaluable information about the reasons behind design decisions made by the development team. Here's what you will find inside: - Understand the key concepts of multidimensional modeling
- Explore the multidimensional object model and its definition language
- Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts
- Understand the mechanisms of integrating multidimensional and relational databases
- Learn how to build client applications to access data in Analysis Services
- Examine server architecture, including main data structures, data processing, and query resolution algorithms
- Gain a deep understanding of the internal and external protocols for data transfer, including the XML/A protocol
- Explore how Analysis Services manages memory
- Explore the security model, including role-based security, code-access security, and data security
- Discover how to monitor and manage Analysis Services
All the code for the sample database used in the book can be found at www.informit.com/title/0672327821.
|
| Customer Reviews:
Showing reviews 1-5 of 19
 The Key for Deep Divers January 15, 2007
Ning Zhu
21 out of 22 found this review helpful
I've been architecting BI solutions for large enterprise customers for past 7 years and one of the biggest challenges is trying to optimize the processing performance without enough knowledge about how the OLAP engine works under the hood.
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".
The best Analysis Services book! Wonderful book! January 24, 2007
Vladimir Chtepa (Hannover, Germany)
13 out of 14 found this review helpful
The authors unveiled the secrets of Analysis Services internals. The book helps to understand why and how Analysis Services is designed, made, and how it runs. It helps immensely every designer and developer to get all of SSAS power. It describes not only the best practices, but also gives warnings about possible mistakes during cube design, processing and querying.
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.
Best book on Analysis Services May 20, 2007
Balachandran Atur
8 out of 8 found this review helpful
The book is not meant for beginners, but, doesn't expect the reader to be an expert on OLAP either. Some introductory knowledge of OLAP would be enough to derive a great deal of benefit from this book. Most books on Analysis services deal with the user facing aspects of it - MDX or database modelling. This is the only book that covers the storage engine of Analysis Services and not just covers it - offers a great deal of detail in a way that is easily understood. This is not to say that query evaluation through MDX is given a short shrift. Both aspects of Analysis services are covered in a very detailed fashion. No other book talks about the implementation of processing algorithms, memory management, query evaluation and the like in such a clear and in depth fashion. Topics like Distinct count and Many to Many dimensions that many implementations stumble over are explained well. The book will pay for itself over and over again when you have to implement Analysis Services. It should really have been called Inside Microsoft Analysis Services 2005.
More Than You Ever Want to Know About Analysis Services July 4, 2007
S. Martin (Corinth,TX)
7 out of 7 found this review helpful
My title says it all: if you want a nuts and bolts book about Analysis Services and MDX, this is the book for you. If you want to know how to implement OLAP from a higher level, their are other books I recommend (Mundy and Thornwaite, for example). So far I haven't found a book that explains what goes on under the hood as well as this one, but then these guys invented it.
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.
This book is the Daily Reference for the MSAS 2005 developer January 9, 2007
Sergei Sheinblum (Kirkland)
7 out of 8 found this review helpful
I have been developing OLAP AS/MSAS solutions for companies for more then 7 years. I would give 5 stars for book not because it is the ONLY BOOK for MSAS 2005 and it coveres every aspect of THE TOOL (MSAS) in a very simple and understandable language but also because it's content is very well cataloged to understand MSAS Engine. However, if you are looking for a book on MDX(es) you might consider to go to MOsha Pasumansky's website http://www.mosha.com/msolap/ and his book for MDX developers.I also found this book as unique on examples how to code with XMLA scripts in MSAS. I would like to see more examples for coding with AMO objects but think that might be overkill for the book as it could of be a separate book itself. I would Recommend this book as a 'MUST' to read for Database Analysts and Developers who are Designing and Developing Reports/DW with MSAS cubes. The book has started to serving me as a 'wizard' to understand the best practices to design and develop OLAP cubes with MSAS 2005.
Showing reviews 1-5 of 19
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2008, SQL Server 2005 Books. All Rights Reserved. In association with Amazon.com | |
