Customer Reviews

Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

5 star:		(5)
4 star:		(2)
3 star:		(0)
2 star:		(0)
1 star:		(0)

 

 

Chris does a great job of laying out both the good and bad associated with using aggregates as a means to support Business Intelligence and Hierarchical-type queries within a Data Warehouse environment. As a disciple of Ralph Kimball's Chris kept true to the doctrine and helped the reader understand why he recommended the tacts he did throughout the manuscript. The material was easy to follow and his illustrations were clear representations of the material being presented. I especially liked that he added platform-specific hints and scenarios to tailor the material to the reader's environment. While I do not necessarily agree that building aggregate tables are the solution to many of the challenges in a Business Intelligence use of Data from a Data Warehouse, I do feel that Chris' book is a great place to start to learn the challenges and start down the path of solution to the problem. Add on material might include mention of other solutions that are not manual that also address the same challenge - such as the software package from HyperRoll.

I must confess that I was skeptic before reading the book, because I thought that it could not add very much to Kimball's books. However, I was wrong: this turned out to be a very useful book. Not only it contains the most detailed explanation of DW aggregates available, but it also contains a very good discussion of the loading process for various types of dimensions and facts, which forms the bulk of data warehouse "back room processing".
One more final plus: the author completely adopts the Kimball approach to Data Warehousing, so this book fits very nicely with other books from Wiley's describing Kimball methodology.

This book answers the question of how can I make my data warehouse queries run faster. There is no magic to this, just pre-compute the data that you want to query and store that in your data warehouse. That is what is meant by 'aggregates' in this book. Of course that is easier said than done. The book covers issues like what to pre-compute and how to use the aggregate. It also has a nice introductory section on how to load a data warehouse with aggregates.

Recently, a colleague recommended "Mastering Data Warehouse Aggregates" and I have already applied many of the powerful techniques so ably presented by Mr. Adamson. Although experienced in the implementation of the Dr. Kimball's star schema approach, I have never been able to exploit its full performance potential - until now.

Despite the complexity of the material, the book is concise and easy to understand. NOTE: Adamson's approach is not tied to any proprietary HW or SW product. The book guided me from design fundamentals to a performance-optimized upgrade of an existing data warehouse. And it didn't take a long time to do it, either.

If you're a performance-oriented data warehousing professional, you'll find this book deserves a place on your book shelf of essential references. Highly recommended.

Aggregate tables can improve the performance of a data warehouse by hundreds or thousands of times.

This book explains how to work with aggregates, and -- this was the most interesting part -- how to make it transparently, so the users don't have to know that they are querying aggregates.

I strongly recommend this book!

If you are responsible for delivering results from your company's data warehouse, you owe it to yourself to read this book. Chris Adamson has lived and breathed this stuff and he knows first hand the challenges facing those who enable the business intelligence systems that more and more organizations have come to rely on. The implementation of aggregates in your data warehouse is not trivial. Make a mistake and the consequences can be very serious indeed. Mr. Adamson is more than an author. He is a scholar, an educator, and an experienced practitioner in the data warehousing world and the information he shares in this book is worth many times the cover price.

Mr. Adamson is certainly the foremost expert in this area. He has many years of hands-on experience, research, and knowledge in Data Warehousing. I have been able to consult his books and find answers and solutions to problems that I encounter every day in my work. You shouldn't waste your time by not buying this book. Definitely don't waste your money by buying a book written by some else.