Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance Reviews
Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
This is the first book to provide in-depth coverage of star schema aggregates used in dimensional modeling-from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative bu
Rating: 
(out of 6 reviews)
List Price: $ 55.00
Price:
SS LIMITED BURNDOUT FIREPROOF WAREHOUSE (HO)
 | US $42.50 (0 Bid) End Date: Thursday Feb-09-2012 13:03:24 PST Bid now | Add to watch list |
 | US $12.50 End Date: Thursday Feb-09-2012 13:03:26 PST Buy It Now for only: US $12.50 Buy it now | Add to watch list |
Find More Warehouse Products
Warehouse Products
| 
Aggregates, Data, Mastering, Performance, Reviews, Schema, Solutions, Star, Warehouse
Review by S. L. Hoffman for Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
Rating:
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.
Review by F. Hu for Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
Rating:
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.
Review by Andrea Vincenzi for Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
Rating:
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.
Review by R. Porter for Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
Rating:
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.
Review by Jesse R. Baldwin for Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
Rating:
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.