Mastering Data Warehouse Aggregates

By Christopher Adamson

Forward by Ralph Kimball
Published by John Wiley & Sons, Inc.
ISBN: 978-0-471-77709-0
Paperback, 384 pages

Available at

Mastering Data Warehouse Aggregates is the first book to provide in-depth coverage of dimensional aggregates-- the single most effective tool for increasing the performance of a star schema data warehouse.

Chris Adamson provides data warehouse designers and developers with the tools and techniques to incorporate dimensional aggregates into new or existing applications, providing substantial gains in performance.

Every aspect of the data warehouse lifecycle is covered from strategy and planning through design and implementation. Universal techniques are supplemented with special considerations for popular technologies such as materialized views and materialized query tables.

Star Schema designers not building aggregates will also find useful information on basic principles of dimensional design, ETL workflow, project planning, archive strategy, and advanced dimensional techniques such as hierarchy bridge tables.

Chapters include:

  • Fundamentals of Aggregates
  • Choosing Aggregates
  • Designing Aggregates
  • Using Aggregates
  • ETL Part 1: Incorporating Aggregates
  • ETL Part 2: Loading Aggregates
  • Aggregates and Your Project
  • Advanced Aggregate Design
  • Additional Topics
  • Glossary

More information on Mastering Data Warehouse Aggregates is available at, where you can read user comments and browse a sample chapter.