Microsoft SQL Server 2005 Analysis Services and over 2 million other books are available for Amazon Kindle . Learn more


or
Sign in to turn on 1-Click ordering.
More Buying Choices
Have one to sell? Sell yours here
Sorry, this item is not available in
Image not available for
Colour:
Image not available

 
Start reading Microsoft SQL Server 2005 Analysis Services on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft SQL Server 2005 Analysis Services [Paperback]

Edward Melomed , Irina Gorbach , Alexander Berger , Py Bateman
5.0 out of 5 stars  See all reviews (2 customer reviews)
Price: 42.99 & FREE Delivery in the UK. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In stock but may require up to 2 additional days to deliver.
Dispatched from and sold by Amazon. Gift-wrap available.

Formats

Amazon Price New from Used from
Kindle Edition 28.83  
Paperback 42.99  
Amazon.co.uk Trade-In Store
Did you know you can use your mobile to trade in your unwanted books for an Amazon.co.uk Gift Card to spend on the things you want? Visit the Books Trade-In Store for more details or check out the Trade-In Amazon Mobile App Guidelines on how to trade in using a smartphone. Learn more.

Book Description

15 Dec 2006 0672327821 978-0672327827 1

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.


Product details

  • Paperback: 864 pages
  • Publisher: Sams; 1 edition (15 Dec 2006)
  • Language: English
  • ISBN-10: 0672327821
  • ISBN-13: 978-0672327827
  • Product Dimensions: 23.3 x 17.7 x 4.7 cm
  • Average Customer Review: 5.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: 1,191,738 in Books (See Top 100 in Books)

Product Description

From the Back Cover

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.

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.

 


Inside This Book (Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

4 star
0
3 star
0
2 star
0
1 star
0
5.0 out of 5 stars
5.0 out of 5 stars
Most Helpful Customer Reviews
5.0 out of 5 stars Great Book! 10 Jun 2011
By Rolls
Format:Paperback|Verified Purchase
This is a great book! Like the other poster says, it is in 2005 but it is still relevant for 2008 as there are no major differences. Also, this book in my opinion is better than most books on SSAS that I have looked through before settling on this. A great book, I certainly recommend it for begginers to advanced users.
Comment | 
Was this review helpful to you?
5.0 out of 5 stars Just fascinating, top stuff! 1 Jan 2011
Format:Paperback|Verified Purchase
I feel compelled to write this review because this book has no review yet I had therefore not considered it... before it was highly recommended to me (thanks David!).

Although SSAS 2005 is an "old" release already, I highly recommend reading this book (and keeping it at hand) whether you use 2005 or 2008 because it is just so good and most of what you learn is still valid in 2008.

Written by members of the team that developed that version, it is full of explanations on how it works behind the hood, which I find invaluable to then understand how to best use the tool.

I will have to go through some chapters a few more times before it really sinks in but I just loved this book.

I'll rate it on a par with the "Inside SQL Server" series. Top notch!
Was this review helpful to you?
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com: 3.6 out of 5 stars  17 reviews
20 of 20 people found the following review helpful
2.0 out of 5 stars Good reference book 24 Oct 2007
By aquarist - Published on Amazon.com
Format:Paperback
Don't use this book to learn Analysis Services. Use this book as a reference after you have already learned Analysis Services from other books such as the ones by Teo Lachev or Reed Jacobson. This book doesn't even attempt to explain what a Dimension is, what an Attribute is etc. Instead it gives you DDL (XML) dumps for those things. Concepts are not explained using examples. I still gave it 2 stars because it has some programming info that other books do not have, and is good as a reference book for Analysis Services experts.
22 of 23 people found the following review helpful
5.0 out of 5 stars The Key for Deep Divers 15 Jan 2007
By Ning Zhu - Published on Amazon.com
Format:Paperback
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".
14 of 15 people found the following review helpful
5.0 out of 5 stars The best Analysis Services book! Wonderful book! 24 Jan 2007
By Vladimir Chtepa - Published on Amazon.com
Format:Paperback
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.
8 of 8 people found the following review helpful
5.0 out of 5 stars Best book on Analysis Services 20 May 2007
By Balachandran Atur - Published on Amazon.com
Format:Paperback
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.
7 of 7 people found the following review helpful
5.0 out of 5 stars More Than You Ever Want to Know About Analysis Services 4 July 2007
By S. Martin - Published on Amazon.com
Format:Paperback|Verified Purchase
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.
Were these reviews helpful?   Let us know
Search Customer Reviews
Only search this product's reviews
ARRAY(0xa35252d0)

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   


Look for similar items by category


Feedback