Gift Guide

Mastering Data Warehouse Aggregates: Maximizing Star Schema Performance

( 3 )


  • 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 ...
See more details below
$56.59 price
(Save 5%)$60.00 List Price
Other sellers (Paperback)
  • All (6) from $16.57   
  • New (4) from $36.29   
  • Used (2) from $16.57   


  • 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
Read More Show Less

Product Details

  • ISBN-13: 9780471777090
  • Publisher: Wiley
  • Publication date: 7/12/2006
  • Edition number: 1
  • Pages: 384
  • Sales rank: 1,029,630
  • Product dimensions: 7.40 (w) x 9.30 (h) x 0.81 (d)

Meet the Author

Christopher Adamson is a data warehousing consultant and founder of Oakton Software LLC. An expert in star schema design, he has managed and executed data warehouse implementations in a variety of industries. His customers have included Fortune 500 companies, large and small businesses, government agencies, and data warehousing tool vendors. Mr. Adamson also teaches dimensional modeling and is a co-author of Data Warehouse Design Solutions (also from Wiley). He can be contacted through his website,

Read More Show Less

Table of Contents




Chapter 1 Fundamentals of Aggregates.

Star Schema Basics.

Operational Systems and the Data Warehouse.

Operational Systems.

Data Warehouse Systems.

Facts and Dimensions.

The Star Schema.

Dimension Tables and Surrogate Keys.

Fact Tables and Grain.

Using the Star Schema.

Multiple Stars and Conformance.

Data Warehouse Architecture.

Invisible Aggregates.

Improving Performance.

The Base Schema and the Aggregate Schema.

The Aggregate Navigator.

Principles of Aggregation.

Providing the Same Results.

The Same Facts and Dimension Attributes as the Base Schema.

Other Types of Summarization.

Pre-Joined Aggregates.

Derived Tables.

Tables with New Facts.


Chapter 2 Choosing Aggregates.

What Is a Potential Aggregate?

Aggregate Fact Tables: A Question of Grain.

Aggregate Dimensions Must Conform.

Pre-Joined Aggregates Have Grain Too.

Enumerating Potential Aggregates.

Identifying Potentially Useful Aggregates.

Drawing on Initial Design.

Design Decisions.

Listening to Users.

Where Subject Areas Meet.

The Conformance Bus.

Aggregates for Drilling Across.

Query Patterns of an Existing System.

Analyzing Reports for Potential Aggregates.

Choosing Which Reports to Analyze.

Assessing the Value of Potential Aggregates.

Number of Aggregates.

Presence of an Aggregate Navigator.

Space Consumed by Aggregate Tables.

How Many Rows Are Summarized.

Examining the Number of Rows Summarized.

The Cardinality Trap and Sparsity.

Who Will Benefit from the Aggregate.


Chapter 3 Designing Aggregates.

The Base Schema.

Identification of Grain.

When Grain Is Forgotten.

Grain and Aggregates.

Conformance Bus.

Rollup Dimensions.

Aggregation Points.

Natural Keys.

Source Mapping.

Slow Change Processing.


Housekeeping Columns.

Design Principles for the Aggregate Schema.

A Separate Star for Each Aggregation.

Single Schema and the Level Field.

Drawbacks to the Single Schema Approach.

Advantages of Separate Tables.

Pre-Joined Aggregates.

Naming Conventions.

Naming the Attributes.

Naming Aggregate Tables.

Aggregate Dimension Design.

Attributes of Aggregate Dimensions.

Sourcing Aggregate Dimensions.

Shared Dimensions.

Aggregate Fact Table Design.

Aggregate Facts: Names and Data Types.

No New Facts, Including Counts.

Degenerate Dimensions.

Audit Dimension.

Sourcing Aggregate Fact Tables.

Pre-Joined Aggregate Design.

Documenting the Aggregate Schema.

Identify Schema Families.

Identify Dimensional Conformance.

Documenting Aggregate Dimension Tables.

Documenting Aggregate Fact Tables.

Pre-Joined Aggregates.

Materialized Views and Materialized Query Tables.


Chapter 4 Using Aggregates.

Which Tables to Use?

The Schema Design.

Relative Size.

Aggregate Portfolio and Availability.

Requirements for the Aggregate Navigator.

Why an Aggregate Navigator?

Two Views and Query Rewrite.

Dynamic Availability.

Multiple Front Ends.

Multiple Back Ends.

Evaluating Aggregate Navigators.

Front-End Aggregate Navigators.


Pros and Cons.

Back-End Aggregate Navigation.


Pros and Cons.

Performance Add-On Technologies and OLAP.


Pros and Cons.

Specific Solutions.

Living with Materialized Views.

Using Materialized Views.

Materialized Views as Pre-Joined Aggregates.

Materialized Views as Aggregate Fact Tables (Without Aggregate Dimensions).

Materialized Views and Aggregate Dimension Tables.

Additional Considerations.

Living with Materialized Query Tables.

Using Materialized Query Tables.

Materialized Query Tables as Pre-Joined Aggregates.

Materialized Query Tables as Aggregate Fact Tables (Without Aggregate Dimensions).

Materialized Query Tables and Aggregate Dimension Tables.

Additional Considerations.

Working Without an Aggregate Navigator.

Human Decisions.

Maintaining the Aggregate Portfolio.

Impact on the ETL Process.


Chapter 5 ETL Part 1: Incorporating Aggregates.

The Load Process.

The Importance of the Load.

Tools of the Load.

Incremental Loads and Changed Data Identification.

The Top-Level Process.

Loading the Base Star Schema.

Loading Dimension Tables.

Attributes of the Dimension Table.

Requirements for the Dimension Load Process.

Extracting and Preparing the Record.

Process New Records.

Process Type 1 Changes.

Process Type 2 Changes.

Loading Fact Tables.

Requirements for the Fact Table Load Process.

Acquire Data and Assemble Facts.

Identification of Surrogate Keys.

Putting It All Together.

Loading the Aggregate Schema.

Loading Aggregates Separately from Base Schema Tables.

Invalid Aggregates.

Load Frequency.

Taking Aggregates Off-Line.

Off-Line Load Processes.

Materialized Views and Materialized Query Tables.

Drop and Rebuild Versus Incremental Load.

Drop and Rebuild.

Incremental Loading of Aggregates.

Real-Time Loads.

Real-Time Load of the Base Schema.

Real-Time Load and Aggregate Tables.

Partitioning the Schema.


Chapter 6 ETL Part 2: Loading Aggregates.

The Source Data for Aggregate Tables.

Changed Data Identification.

Elimination of Redundant Processing.

Ensuring Conformance.

Loading the Base Schema and Aggregates Simultaneously.

Loading Aggregate Dimensions.

Requirements for the Aggregate Dimension Load Process.

Extracting and Preparing the Records.

Identifying and Processing New Records.

Identifying and Processing Type 1 Changes.

Processing Type 2 Changes.

Key Mapping.

Loading Aggregate Fact Tables.

Requirements for Loading Aggregate Fact Tables.

Acquire Data and Assemble Facts.

Selecting Source Columns.

Processing New Facts Only.

Calculating and Aggregating Facts.

One Query Does It All.

Identification of Surrogate Keys.

Aggregating Over Time.

Dropping and Rebuilding Aggregates.

Dropping and Rebuilding Aggregate Dimension Tables.

Dropping and Rebuilding Aggregate Fact Tables.

Pre-Joined Aggregates.

Dropping and Rebuilding a Pre-Joined Aggregate.

Incrementally Loading a Pre-Joined Aggregate.

Materialized Views and Materialized Query Tables.

Defining Attributes for Aggregate Dimensions.

Optimizing the Hierarchy.


Chapter 7 Aggregates and Your Project.

Data Warehouse Implementation.

Incremental Implementation of the Data Warehouse.

Planning Data Marts Around Conformed Dimensions.

Other Approaches.

Incorporating Aggregates into the Project.

Aggregates and the First Data Mart.

Subsequent Subject Areas.

The Aggregate Project.

Strategy Stage.

Technology Selection: Choosing an Aggregate Navigator.

Additional Strategic Tasks and Deliverables.

Design Stage.

Design of the Aggregate Schema and Load Specification.

Design Documentation.

Developing Test Plans for Aggregates.

Build Stage.

Iterative Build and Aggregates.

Build Tasks and Aggregates.


Transitioning to Production, Final Testing, and Documentation.

End User Education.

Management of Aggregates.

Maintenance Responsibilities.

Ad Hoc Changes to Aggregate Portfolio.

An Ongoing Process.


Chapter 8 Advanced Aggregate Design.

Aggregating Facts.

Periodic Snapshots Designs.




Invisible Aggregates for Periodic Snapshots.

Averaging Semi-Additive Facts Produces a Derived Schema.

Taking Less Frequent Snapshots Does Not Produce an Invisible Aggregate.

Accumulating Snapshots.

The Accumulating Snapshot.

Aggregating the Accumulating Snapshot.

Factless Fact Tables.

Factless Events and Aggregates.

Coverage Tables and Aggregates.

Aggregating Dimensions.

Transaction Dimensions.

Timestamping a Dimension.

Aggregating a Timestamped Dimension.

Bridge Tables.

Dealing with Multi-Valued Attributes.

Aggregates and Bridge Tables.

Core and Custom Stars.

Other Schema Types.

Snowflakes and Aggregates.

The Snowflake Schema.

Aggregating Snowflakes.

Third Normal Form Schemas and Aggregates.


Chapter 9 Related Topics.

Aggregates and the Archive Strategy.

The Data Warehouse Archive Strategy.

Aggregates and Archives.

Maintaining Aggregates.

Archive Versus Purge.

Summarizing Off-Line Data.

Aggregates and Security.

Dimensionally Driven Security and Aggregates.

Unrestricted Access to Summary Data.

Derived Tables.

The Merged Fact Table.

The Pivoted Fact Table.

The Sliced Fact Table.

When Rollups Are Deployed Before Detail.

Building the Base Table First.

Building the Rollup First.

Parallel Load Processes.

Redeveloping the Load.

Historic Detail.




Read More Show Less

Customer Reviews

Average Rating 5
( 3 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 3 Customer Reviews
  • Anonymous

    Posted July 6, 2014

    Jacpb to below

    What? A million people are named jacob.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted July 5, 2014



    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted July 5, 2014

    To jacob


    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)