| |
| |
Preface | |
| |
| |
Table of contents | |
| |
| |
Table of figures and tables | |
| |
| |
| |
Introduction | |
| |
| |
| |
Why this book? | |
| |
| |
| |
Audience | |
| |
| |
| |
Structure | |
| |
| |
| |
The evolution of data warehousing | |
| |
| |
| |
The data warehouse--a brief history | |
| |
| |
| |
Prehistoric times--before the 1980s | |
| |
| |
| |
The middle ages--mid- to late-1980s | |
| |
| |
| |
The data revolution--the early 1990s | |
| |
| |
| |
The era of information-based management--into the 21st century | |
| |
| |
| |
What is a data warehouse? | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Today's development environment | |
| |
| |
| |
Fragmented application development | |
| |
| |
| |
Operational application development | |
| |
| |
| |
Application-driven decision support | |
| |
| |
| |
The Info Center | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Principles of data warehousing | |
| |
| |
| |
Types of data and their uses | |
| |
| |
| |
Types of data | |
| |
| |
| |
Business data | |
| |
| |
| |
Metadata | |
| |
| |
| |
Data beyond the scope of the warehouse | |
| |
| |
| |
Internal and external data | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Conceptual data architecture | |
| |
| |
| |
Business data architectures | |
| |
| |
| |
The single-layer data architecture | |
| |
| |
| |
The two-layer data architecture | |
| |
| |
| |
The three-layer data architecture | |
| |
| |
| |
A data architecture for metadata | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Design techniques | |
| |
| |
| |
Enterprise data modeling | |
| |
| |
| |
Representing time in business data | |
| |
| |
| |
Historical data | |
| |
| |
| |
Data replication | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Introduction to the logical architecture | |
| |
| |
| |
Business data in the data warehouse | |
| |
| |
| |
Business data--other considerations | |
| |
| |
| |
External data | |
| |
| |
| |
Metadata in the data warehouse | |
| |
| |
| |
The data warehouse catalog | |
| |
| |
| |
Operational systems | |
| |
| |
| |
Data warehouse functionality | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Creating the data asset | |
| |
| |
| |
Business data warehouse design | |
| |
| |
| |
Modeling the BDW--general design | |
| |
| |
| |
Modeling the BDW--a segmented approach | |
| |
| |
| |
Modeling the BDW--practical results | |
| |
| |
| |
The structure of periodic data in the BDW | |
| |
| |
| |
Archive and retrieval | |
| |
| |
| |
The role of parallel databases | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Populating the business data warehouse | |
| |
| |
| |
BDW population--initial considerations | |
| |
| |
| |
Capture--an introduction | |
| |
| |
| |
From operational data to the BDW | |
| |
| |
| |
Six data capture techniques | |
| |
| |
| |
Output data structures from capture | |
| |
| |
| |
Apply--an introduction | |
| |
| |
| |
Apply during BDW creation | |
| |
| |
| |
Apply during BDW maintenance | |
| |
| |
| |
Refresh versus update of the BDW | |
| |
| |
| |
Transformation--an introduction | |
| |
| |
| |
Transformation in BDW population | |
| |
| |
| |
BDW population--the overall process | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Unlocking the data asset for end users | |
| |
| |
| |
Designing business information warehouses | |
| |
| |
| |
Types of business information warehouse | |
| |
| |
| |
Modeling BIWs | |
| |
| |
| |
Key influences on BIW design | |
| |
| |
| |
BIW implementation | |
| |
| |
| |
Historical data in BIWs | |
| |
| |
| |
Archive and retrieval in BIWs | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Populating business information warehouses | |
| |
| |
| |
BIW population--an introduction | |
| |
| |
| |
Capture from the BDW | |
| |
| |
| |
Apply to the BIW | |
| |
| |
| |
Comparing the performance of update and refresh modes of replication | |
| |
| |
| |
Transformation | |
| |
| |
| |
BIW population--implementation aspects | |
| |
| |
| |
Conclusions | |
| |
| |
| |
User access to information | |
| |
| |
| |
The business information interface | |
| |
| |
| |
Data access | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Information--data in context | |
| |
| |
| |
The business information guide--an introduction | |
| |
| |
| |
Requirements for the BIG | |
| |
| |
| |
The naive and sentimental user | |
| |
| |
| |
Users of the BIG | |
| |
| |
| |
Structure of the BIG | |
| |
| |
| |
DWC population | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Implementing the data warehouse | |
| |
| |
| |
Obstacles to implementation | |
| |
| |
| |
The size and scope of the warehouse | |
| |
| |
| |
Justifying investment in a data warehouse | |
| |
| |
| |
Organizational issues | |
| |
| |
| |
Placement of the BDW and BIWs in the enterprise | |
| |
| |
| |
Ongoing administration | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Planning your implementation | |
| |
| |
| |
Segmenting the data warehouse | |
| |
| |
| |
Staging the warehouse implementation | |
| |
| |
| |
Kick-starting the implementation process | |
| |
| |
| |
Coordinating the data warehouse implementation process | |
| |
| |
| |
Critical success factors | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Justifying the warehouse | |
| |
| |
| |
The traditional justification approach | |
| |
| |
| |
Beyond cost avoidance | |
| |
| |
| |
A new basis for competitiveness | |
| |
| |
| |
Changing management structures | |
| |
| |
| |
The automation of marketing | |
| |
| |
| |
Data warehouse costs | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Organizational implications of data warehousing | |
| |
| |
| |
From planning to pilot | |
| |
| |
| |
From initiation to roll-out | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Physical structure of the data warehouse | |
| |
| |
| |
The data warehouse environment--centralized versus distributed | |
| |
| |
| |
Aligning the data warehouse with the organizational structure | |
| |
| |
| |
Subsetting the BDW | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Data warehouse management | |
| |
| |
| |
Replication administration | |
| |
| |
| |
From administration to runtime | |
| |
| |
| |
Process management | |
| |
| |
| |
Data transfer | |
| |
| |
| |
Other database support functions | |
| |
| |
| |
Conclusions | |
| |
| |
| |
Looking to the future | |
| |
| |
| |
A single information source | |
| |
| |
| |
Distributed information availability | |
| |
| |
| |
Information in a business context | |
| |
| |
| |
Automated information delivery | |
| |
| |
| |
Information quality and ownership | |
| |
| |
| |
Concluding remarks | |
| |
| |
References | |
| |
| |
Index | |