Adamson Christopher. Star Schema. The Complete Reference

McGraw-Hill, 2010. — 486 p. — ISBN: 978-0-07-174433-1.This book is a complete reference to dimensional design — the first intended for any reader. The best practices presented in this volume cut across all architectures, including those espoused by W.H. Inmon and Ralph Kimball. Organized around the key concepts of dimensional design, this book provides full, in-depth treatment of each topic, sequenced in a logical progression from fundamentals through advanced techniques.
This book is designed for both beginners and experts in dimensional design. If you are a beginner, it is the ideal place to start. Each chapter provides you with best practices and their underlying rationale, detailed examples, and the criteria you need to make design decisions.
If you are an expert, you will be able to use this guide as a reference. Whenever you face a particular design challenge, you will find a chapter or section dedicated to the topic.
Dimensional design enables profoundly powerful business analysis. A solid understanding of the underlying principles is essential, whether you are directly involved in design activities, work with dimensional data structures, manage projects, or fund implementations. Mastery of the techniques and best practices in this book will help you unleash the full potential of your data warehouse, regardless of architecture, implementation scope, or software tools.Fundamentals
Analytic Databases and Dimensional Design
Data Warehouse Architectures
Stars and Cubes
Multiple Stars
A Fact Table for Each Process
Conformed Dimensions
Dimension Design
More on Dimension Tables
Hierarchies and Snowflakes
More Slow Change Techniques
Multi-Valued Dimensions and Bridges
Recursive Hierarchies and Bridges
Fact Table Design
Transactions, Snapshots and Accumulating Snapshots
Factless Fact Tables
Type-Specific Stars
Performance
Derived Schemas
Aggregates
Tools and Documentation
Design and Business Intelligence
Design and ETL
How to Design and Document a Dimensional Model