|
|
Business Intelligence Books - Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance
|
List Price: $50.00
Our Price: $44.28
Your Save: $ 5.72 ( 11% )
Availability: Usually ships in 24 hours
Manufacturer: Wiley
|
Average Customer Rating: 
|
|
Binding: Paperback
Dewey Decimal Number: 005.74
EAN: 9780471777090
ISBN: 0471777099
Label: Wiley
Manufacturer: Wiley
Number Of Items: 1
Number Of Pages: 384
Publication Date: 2006-07-19
Publisher: Wiley
Studio: Wiley
|
|
|
|
|
|
Editorial Reviews:
|
- 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 builds, and early data loads
|
|
|
Spotlight customer reviews:
|
Customer Rating:
Summary: Focused, clear and useful
Comment: 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.
Customer Rating:
Summary: Buy with confidence
Comment: 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.
Customer Rating:
Summary: Do yourself a favor
Comment: 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.
Customer Rating:
Summary: Boost Data Warehouse Performance
Comment: 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.
Customer Rating: 
Summary: Accurate and Easy to Follow
Comment: 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.
|
|
|
|
|
|
|
|
|
