Table of Contents
Chapter 1: A brief history of data warehousing and first-generation data warehouses
Personal Computers and 4GL Technology
Evolution from the Business Perspective
The Data Ware House Environment
Integrating Data—a Painful Experience
A Different Development Approach
Evolution to the DW 2.0 Environment
The Business Impact of the Data Warehouse
Various Components of the Data Warehouse Environment
The Evolution of Data Warehousing from the Business Perspective
Other Notions About a Data Warehouse
The Federated Data Warehouse Approach
Building a “Real” Data Warehouse
Chapter 2: An introduction to DW 2.0
DW 2.0—from the Business Perspective
Reasons for the Different Sectors
Structured Data/Unstructured Data
Changing Business Requirements
The Flow of Data Within DW 2.0
DW 2.0 and Referential Integrity
Chapter 3: DW 2.0 components—about the different sectors
Reusability of Data and Analysis
Active Repository/Passive Repository
Metadata and the System of Record
Internal Taxonomies/External Taxonomies
Metadata In the Archival Sector
Chapter 5: Fluidity of the DW 2.0 technology infrastructure
Reducing the Length of Time For It to Respond
Semantically Temporal, Semantically Static Data
Mixing Semantically Stable and Unstable Data
Separating Semantically Stable and Unstable Data
Chapter 6: Methodology and approach for DW 2.0
Spiral Methodology—a Summary of Key Features
The Seven Streams Approach—an Overview
Enterprise Reference Model Stream
Enterprise Knowledge Coordination Stream
Information Factory Development Stream
Data Profiling and Mapping Stream
Data Correction Stream (Previously Called the Data Cleansing Stream)
Total Information Quality Management Stream
Chapter 7: Statistical processing and DW 2.0
The Integrity of the Comparison
The Sources for Exploration Processing
Data Marts and the Exploration Facility
Using Exploration Data Internally
From the Perspective of the Business Analyst
Chapter 8: Data models and DW 2.0
Making the Distinction Between Granular and Summarized Data
Data Models and the Interactive Sector
Data Models and Unstructured Data
From the Perspective of the Business User
Chapter 9: Monitoring the DW 2.0 environment
Monitoring the DW 2.0 Environment
The Transaction Monitor—Response Time
From the Perspective of the Business User
Chapter 10: DW 2.0 and security
From the Perspective of the Business User
All Data In DW 2.0—Relative To Time
Time Relativity In the Interactive Sector
Data Relativity Elsewhere In DW 2.0
Transactions In the Integrated Sector
Beginning and Ending a Sequence of Records
Time Variance In the Archival Sector
From the Perspective of the End User
Chapter 12: The flow of data in DW 2.0
The Flow of Data Throughout the Architecture
Entering the Interactive Sector
Data Flow Into the Integrated Sector
Data Flow Into the Near Line Sector
Data Flow Into the Archival Sector
The Falling Probability of Data Access
From the Perspective of the Business User
Chapter 13: ETL processing and DW 2.0
From Application Data to Corporate Data
Code Creation or Parametrically Driven ETL
From the Perspective of the Business User
Chapter 14: DW 2.0 and the granularity manager
Raising the Level of Granularity
The Functions of the Granularity Manager
Home-Grown Versus Third-Party Granularity Managers
Parallelizing the Granularity Manager
From the Perspective of the Business User
Chapter 15: DW 2.0 and performance
Good Performance—a Cornerstone For DW 2.0
Analytical Productivity and Response Time
Parallelization for Transaction Processing
Separation of Transactions Into Classes
Protecting the Interactive Sector
Separating Farmers and Explorers
Physically Group Data Together
Check Automatically Generated Code
From the Perspective of the Business User
The Perfect World Almost Never Happens
Adding Components Incrementally
Building the Metadata Infrastructure
Migration to the Unstructured Environment
From the Perspective of the Business User
Chapter 17: Cost justification and DW 2.0
A Micro-Level Cost Justification
So How Much Does all of This Cost?
First-Generation DW and DW 2.0—The Economics
From the Perspective of the Business User
Chapter 18: Data quality in DW 2.0
The DW 2.0 Data Quality Tool Set
Data Profiling Tools and the Reverse-Engineered Data Model
Data Profiling Inconsistencies Challenge Top-Down Modeling
Chapter 19: DW 2.0 and unstructured data
Whereto Do Textual Analytical Processing
External Glossaries/Taxonomies
Semistructured Data/Value = Name Data
The Technology Needed to Prepare the Data
Structured/Unstructured Linkage
From the Perspective of the Business User
Chapter 20: DW 2.0 and the system of record
From the Perspective of the Business User
Chapter 21: Miscellaneous topics
The Convenience of a Data Mart
Moving Data from One Data Mart to Another
Chapter 22: Processing in the DW 2.0 environment
Chapter 23: Administering the DW 2.0 environment
Defining the Moment When an Archival Sector Will Be Needed
Determining Whether the Near Line Sector Is Needed
Systems and Technology Administration
Management Administration of the DW 2.0 Environment
Prioritization and Prioritization Conflicts