Mastering Data Warehouse Aggregates: Solutions for Star Schema Performance

Table of contents

1. Copyright
2. Dedication
3. About the Author
4. Credits
5. Foreword
6. Acknowledgments
7. Introduction
8. Fundamentals of Aggregates
   1. Star Schema Basics
   2. Invisible Aggregates
   3. Other Types of Summarization
   4. Summary
9. Choosing Aggregates
   1. What Is a Potential Aggregate?
   2. Identifying Potentially Useful Aggregates
   3. Assessing the Value of Potential Aggregates
   4. Summary
10. Designing Aggregates
    1. The Base Schema
    2. Design Principles for the Aggregate Schema
    3. Documenting the Aggregate Schema
    4. Summary
11. Using Aggregates
    1. Which Tables to Use?
    2. Requirements for the Aggregate Navigator
    3. Evaluating Aggregate Navigators
    4. Specific Solutions
    5. Summary
12. ETL Part 1: Incorporating Aggregates
    1. The Load Process
    2. Loading the Base Star Schema
    3. Loading the Aggregate Schema
    4. Real-Time Loads
    5. Summary
13. ETL Part 2: Loading Aggregates
    1. The Source Data for Aggregate Tables
    2. Loading Aggregate Dimensions
    3. Loading Aggregate Fact Tables
    4. Dropping and Rebuilding Aggregates
    5. Pre-Joined Aggregates
    6. Materialized Views and Materialized Query Tables
    7. Summary
14. Aggregates and Your Project
    1. Data Warehouse Implementation
    2. The Aggregate Project
    3. Management of Aggregates
    4. Summary
15. Advanced Aggregate Design
    1. Aggregating Facts
    2. Aggregating Dimensions
    3. Other Schema Types
    4. Summary
16. Related Topics
    1. Aggregates and the Archive Strategy
    2. Aggregates and Security
    3. Derived Tables
    4. When Rollups Are Deployed Before Detail
    5. Summary
17. Glossary
18. Index