Sign in  |  Register
Advanced search
Publication Cover

CITATION

Adamson, Christopher. Star Schema The Complete Reference. US: McGraw-Hill Osborne Media, 2010.

Star Schema The Complete Reference

Authors: Christopher Adamson

Published:  July 2010

eISBN: 9780071744331 0071744339 | ISBN: 9780071744324
Open eBook
  • Contents
  • Acknowledgments
  • Introduction
  • Part I: Fundamentals
  • Chapter 1 Analytic Databases and Dimensional Design
  • Dimensional Design
  • The Star Schema
  • Using a Star Schema
  • Guiding Principles
  • Summary
  • Further Reading
  • Chapter 2 Data Warehouse Architectures
  • Inmon’s Corporate Information Factory
  • Kimball’s Dimensional Data Warehouse
  • Stand-Alone Data Marts
  • Architecture and Dimensional Design
  • Summary
  • Further Reading
  • Chapter 3 Stars and Cubes
  • Dimension Table Features
  • Fact Table Features
  • Slowly Changing Dimensions
  • Cubes
  • Summary
  • Further Reading
  • Part II: Multiple Stars
  • Chapter 4 A Fact Table for Each Process
  • Fact Tables and Business Processes
  • Facts that Have Different Timing
  • Facts that Have Different Grain
  • Analyzing Facts from More than One Fact Table
  • Summary
  • Further Reading
  • Chapter 5 Conformed Dimensions
  • The Synergy of Multiple Stars
  • Dimensions and Drilling Across
  • Conformed Dimensions
  • Architecture and Conformance
  • Summary
  • Further Reading
  • Part III: Dimension Design
  • Chapter 6 More on Dimension Tables
  • Grouping Dimensions into Tables
  • Breaking Up Large Dimensions
  • Dimension Roles and Aliasing
  • Avoiding the NULL
  • Behavioral Dimensions
  • Summary
  • Further Reading
  • Chapter 7 Hierarchies and Snowflakes
  • Drilling
  • Attribute Hierarchies and Drilling
  • Snowflakes
  • Outriggers
  • Summary
  • Further Reading
  • Chapter 8 More Slow Change Techniques
  • Time-Stamped Dimensions
  • Type 3 Changes
  • Hybrid Slow Changes
  • Summary
  • Further Reading
  • Chapter 9 Multi-Valued Dimensions and Bridges
  • Standard One-to-Many Relationships
  • Multi-Valued Dimensions
  • Multi-Valued Attributes
  • Summary
  • Further Reading
  • Chapter 10 Recursive Hierarchies and Bridges
  • Recursive Hierarchies
  • Flattening a Recursive Hierarchy
  • The Hierarchy Bridge
  • Changes and the Hierarchy Bridge
  • Variations on the Hierarchy Bridge
  • Summary
  • Further Reading
  • Part IV: Fact Table Design
  • Chapter 11 Transactions, Snapshots, and Accumulating Snapshots
  • Transaction Fact Tables
  • Snapshot Fact Tables
  • Accumulating Snapshot Fact Tables
  • Summary
  • Further Reading
  • Chapter 12 Factless Fact Tables
  • Events with No Facts
  • Conditions, Coverage, or Eligibility
  • Summary
  • Further Reading
  • Chapter 13 Type-Specific Stars
  • Type-Specific Attributes
  • Core and Custom Stars
  • Using Generic Attributes
  • Summary
  • Further Reading
  • Part V: Performance
  • Chapter 14 Derived Schemas
  • Restructuring Dimensional Data
  • The Merged Fact Table
  • The Pivoted Fact Table
  • The Sliced Fact Table
  • Set Operation Fact Tables
  • Summary
  • Further Reading
  • Chapter 15 Aggregates
  • Fundamentals of Aggregates
  • Making Aggregates Invisible
  • Alternative Summary Designs
  • Summary
  • Further Reading
  • Part VI: Tools and Documentation
  • Chapter 16 Design and Business Intelligence
  • Business Intelligence and SQL Generation
  • Guidelines for the Semantic Layer
  • Working with SQL-Generating BI Tools
  • Working with Cube-Based BI
  • Summary
  • Further Reading
  • Chapter 17 Design and ETL
  • The ETL Process
  • Loading a Star
  • Optimizing the Load
  • Cleansing Data
  • Housekeeping Columns
  • Summary
  • Further Reading
  • Chapter 18 How to Design and Document a Dimensional Model
  • Dimensional Design and the Data Warehouse Life Cycle
  • Design Activities
  • Documenting a Dimensional Model
  • Summary
  • Further Reading
  • Index