The latest edition of the single most authoritative guide ondimensional modeling for data warehousing!
Dimensional modeling has become the most widely acceptedapproach for data warehouse design. Here is a complete library ofdimensional modeling techniques-- the most comprehensive collectionever written. Greatly expanded to cover both basic and advancedtechniques for optimizing data warehouse design, this secondedition to Ralph Kimball's classic guide is more than sixty percentupdated.
The authors begin with fundamental design recommendations andgradually progress step-by-step through increasingly complexscenarios. Clear-cut guidelines for designing dimensional modelsare illustrated using real-world data warehouse case studies drawnfrom a variety of business application areas and industries,including:
* Retail sales and e-commerce
* Inventory management
* Procurement
* Order management
* Customer relationship management (CRM)
* Human resources management
* Accounting
* Financial services
* Telecommunications and utilities
* Education
* Transportation
* Health care and insurance
By the end of the book, you will have mastered the full range ofpowerful techniques for designing dimensional databases that areeasy to understand and provide fast query response. You will alsolearn how to create an architected framework that integrates thedistributed data warehouse using standardized dimensions andfacts.
This book is also available as part of the Kimball's DataWarehouse Toolkit Classics Box Set (ISBN: 9780470479575) with thefollowing 3 books:
The Data Warehouse Toolkit, 2nd Edition (9780471200246)
The Data Warehouse Lifecycle Toolkit, 2nd Edition(9780470149775)
The Data Warehouse ETL Toolkit (9780764567575)
Ralph Kimball
Computer Science Data-warehouse-Konzept Database & Data Warehousing Technologies Datenbanken u. Data Warehousing Informatik
"...this is the daddy of data warehousing process books. No othermaterial available so concisely and precisely explains what isrequired from a data warehousing solution...this is a greatbook..." (Enterprise Server Magazine, July 2002)
()