Page 8 -

Contents 7

Part II Descriptive analytics 107
Chapter 3 Data Warehousing 108
3.1 Opening Vignette: Isle of Capri Casinos Is Winning with
Enterprise Data Warehouse 109
3.2 Data Warehousing Definitions and Concepts 111
What Is a Data Warehouse? 111
A Historical Perspective to Data Warehousing 111
Characteristics of Data Warehousing 113
Data Marts 114
Operational Data Stores 114
Enterprise Data Warehouses (EDW) 115
Metadata 115
▶ ApplicAtion cAse 3.1 A Better Data Plan: Well-Established TELCOs
Leverage Data Warehousing and Analytics to Stay on Top in a
Competitive Industry 115
3.3 Data Warehousing Process Overview 117
▶ ApplicAtion cAse 3.2 Data Warehousing Helps MultiCare Save
More Lives 118
3.4 Data Warehousing Architectures 120
Alternative Data Warehousing Architectures 123
Which Architecture Is the Best? 126
3.5 Data Integration and the Extraction, Transformation, and
Load (ETL) Processes 127
Data Integration 128
▶ ApplicAtion cAse 3.3 BP Lubricants Achieves BIGS Success 128
Extraction, Transformation, and Load 130
3.6 Data Warehouse Development 132
▶ ApplicAtion cAse 3.4 Things Go Better with Coke’s Data
Warehouse 133
Data Warehouse Development Approaches 133
▶ ApplicAtion cAse 3.5 Starwood Hotels & Resorts Manages Hotel
Profitability with Data Warehousing 136
Additional Data Warehouse Development Considerations 137
Representation of Data in Data Warehouse 138
Analysis of Data in the Data Warehouse 139
OLAP Versus OLTP 140
OLAP Operations 140
3.7 Data Warehousing Implementation Issues 143
▶ ApplicAtion cAse 3.6 EDW Helps Connect State Agencies in
Michigan 145
Massive Data Warehouses and Scalability 146
3.8 Real-Time Data Warehousing 147
▶ ApplicAtion cAse 3.7 Egg Plc Fries the Competition in Near Real
Time 148

A01_SHAR9209_10_PIE_FM.indd 7 1/25/14 7:47 AM