| |
| |
| Preface for the Second Edition | |
| |
| |
| Preface for the Third Edition | |
| |
| |
| Acknowledgments | |
| |
| |
| About the Author | |
| |
| |
| Evolution of Decision Support Systems | |
| |
| |
| The Evolution | |
| |
| |
| The Advent of DASD | |
| |
| |
| PC/4GL Technology | |
| |
| |
| Enter the Extract Program | |
| |
| |
| The Spider Web | |
| |
| |
| Problems with the Naturally Evolving Architecture | |
| |
| |
| Lack of Data Credibility | |
| |
| |
| Problems with Productivity | |
| |
| |
| From Data to Information | |
| |
| |
| A Change in Approach | |
| |
| |
| The Architected Environment | |
| |
| |
| Data Integration in the Architected Environment | |
| |
| |
| Who Is the User? | |
| |
| |
| The Development Life Cycle | |
| |
| |
| Patterns of Hardware Utilization | |
| |
| |
| Setting the Stage for Reengineering | |
| |
| |
| Monitoring the Data Warehouse Environment | |
| |
| |
| Summary | |
| |
| |
| The Data Warehouse Environment | |
| |
| |
| The Structure of the Data Warehouse | |
| |
| |
| Subject Orientation | |
| |
| |
| Day 1-Day n Phenomenon | |
| |
| |
| Granularity | |
| |
| |
| The Benefits of Granularity | |
| |
| |
| An Example of Granularity | |
| |
| |
| Dual Levels of Granularity | |
| |
| |
| Exploration and Data Mining | |
| |
| |
| Living Sample Database | |
| |
| |
| Partitioning as a Design Approach | |
| |
| |
| Partitioning of Data | |
| |
| |
| Structuring Data in the Data Warehouse | |
| |
| |
| Data Warehouse: The Standards Manual | |
| |
| |
| Auditing and the Data Warehouse | |
| |
| |
| Cost Justification | |
| |
| |
| Justifying Your Data Warehouse | |
| |
| |
| Data Homogeneity/Heterogeneity | |
| |
| |
| Purging Warehouse Data | |
| |
| |
| Reporting and the Architected Environment | |
| |
| |
| The Operational Window of Opportunity | |
| |
| |
| Incorrect Data in the Data Warehouse | |
| |
| |
| Summary | |
| |
| |
| The Data Warehouse and Design | |
| |
| |
| Beginning with Operational Data | |
| |
| |
| Data/Process Models and the Architected Environment | |
| |
| |
| The Data Warehouse and Data Models | |
| |
| |
| The Data Warehouse Data Model | |
| |
| |
| The Midlevel Data Model | |
| |
| |
| The Physical Data Model | |
| |
| |
| The Data Model and Iterative Development | |
| |
| |
| Normalization/Denormalization | |
| |
| |
| Snapshots in the Data Warehouse | |
| |
| |
| Meta Data | |
| |
| |
| Managing Reference Tables in a Data Warehouse | |
| |
| |
| Cyclicity of Data-The Wrinkle of Time | |
| |
| |
| Complexity of Transformation and Integration | |
| |
| |
| Triggering the Data Warehouse Record | |
| |
| |
| Events | |
| |
| |
| Components of the Snapshot | |
| |
| |
| Some Examples | |
| |
| |
| Profile Records | |
| |
| |
| Managing Volume | |
| |
| |
| Creating Multiple Profile Records | |
| |
| |
| Going from the Data Warehouse to the Operational Environment | |
| |
| |
| Direct Access of Data Warehouse Data | |
| |
| |
| Indirect Access of Data Warehouse Data | |
| |
| |
| An Airline Commission Calculation System | |
| |
| |
| A Retail Personalization System | |
| |
| |
| Credit Scoring | |
| |
| |
| Indirect Use of Data Warehouse Data | |
| |
| |
| Star Joins | |
| |
| |
| Supporting the ODS | |
| |
| |
| Summary | |
| |
| |
| Granularity in the Data Warehouse | |
| |
| |
| Raw Estimates | |
| |
| |
| Input to the Planning Process | |
| |
| |
| Data in Overflow? | |
| |
| |
| Overflow Storage | |
| |
| |
| What the Levels of Granularity Will Be | |
| |
| |
| Some Feedback Loop Techniques | |
| |
| |
| Levels of Granularity-Banking Environment | |
| |
| |
| Summary | |
| |
| |
| The Data Warehouse and Technology | |
| |
| |
| Managing Large Amounts of Data | |
| |
| |
| Managing Multiple Media | |
| |
| |
| Index/Monitor Data | |
| |
| |
| Interfaces to Many Technologies | |
| |
| |
| Programmer/Designer Control of Data Placement | |
| |
| |
| Parallel Storage/Management of Data | |
| |
| |
| Meta Data Management | |
| |
| |
| Language Interface | |
| |
| |
| Efficient Loading of Data | |
| |
| |
| Efficient Index Utilization | |
| |
| |
| Compaction of Data | |
| |
| |
| Compound Keys | |
| |
| |
| Variable-Length Data | |
| |
| |
| Lock Management | |
| |
| |
| Index-Only Processing | |
| |
| |
| Fast Restore | |
| |
| |
| Other Technological Features | |
| |
| |
| DBMS Types and the Data Warehouse | |
| |
| |
| Changing DBMS Technology | |
| |
| |
| Multidimensional DBMS and the Data Warehouse | |
| |
| |
| Data Warehousing across Multiple Storage Media | |
| |
| |
| Meta Data in the Data Warehouse Environment | |
| |
| |
| Context and Content | |
| |
| |
| Three Types of Contextual Information | |
| |
| |
| Capturing and Managing Contextual Information | |
| |
| |
| Looking at the Past | |
| |
| |
| Refreshing the Data Warehouse | |
| |
| |
| Testing | |
| |
| |
| Summary | |
| |
| |
| The Distributed Data Warehouse | |
| |
| |
| Types of Distributed Data Warehouses | |
| |
| |
| Local and Global Data Warehouses | |
| |
| |
| The Technologically Distributed Data Warehouse | |
| |
| |
| The Independently Evolving Distributed Data Warehouse | |
| |
| |
| The Nature of the Development Efforts | |
| |
| |
| Completely Unrelated Warehouses | |
| |
| |
| Distributed Data Warehouse Development | |
| |
| |
| Coordinating Development across Distributed Locations | |
| |
| |
| The Corporate Data Model-Distributed | |
| |
| |
| Meta Data in the Distributed Warehouse | |
| |
| |
| Building the Warehouse on Multiple Levels | |
| |
| |
| Multiple Groups Building the Current Level of Detail | |
| |
| |
| Different Requirements at Different Levels | |
| |
| |
| Other Types of Detailed Data | |
| |
| |
| Meta Data | |
| |
| |
| Multiple Platforms for Common Detail Data | |
| |
| |
| Summary | |
| |
| |
| Executive Information Systems and the Data Warehouse | |
| |
| |
| EIS-The Promise | |
| |
| |
| A Simple Example | |
| |
| |
| Drill-Down Analysis | |
| |
| |
| Supporting the Drill-Down Process | |
| |
| |
| The Data Warehouse as a Basis for EIS | |
| |
| |
| Where to Turn | |
| |
| |
| Event Mapping | |
| |
| |
| Detailed Data and EIS | |
| |
| |
| Keeping Only Summary Data in the EIS | |
| |
| |
| Summary | |
| |
| |
| External/Unstructured Data and the Data Warehouse | |
| |
| |
| External/Unstructured Data in the Data Warehouse | |
| |
| |
| Meta Data and External Data | |
| |
| |
| Storing External/Unstructured Data | |
| |
| |
| Different Components of External/Unstructured Data | |
| |
| |
| Modeling and External/Unstructured Data | |
| |
| |
| Secondary Reports | |
| |
| |
| Archiving External Data | |
| |
| |
| Comparing Internal Data to External Data | |
| |
| |
| Summary | |
| |
| |
| Migration to the Architected Environment | |
| |
| |
| A Migration Plan | |
| |
| |
| The Feedback Loop | |
| |
| |
| Strategic Considerations | |
| |
| |
| Methodology and Migration | |
| |
| |
| A Data-Driven Development Methodology | |
| |
| |
| Data-Driven Methodology | |
| |
| |
| System Development Life Cycles | |
| |
| |
| A Philosophical Observation | |
| |
| |
| Operational Development/DSS Development | |
| |
| |
| Summary | |
| |
| |
| The Data Warehouse and the Web | |
| |
| |
| Supporting the Ebusiness Environment | |
| |
| |
| Moving Data from the Web to the Data Warehouse | |
| |
| |
| Moving Data from the Data Warehouse to the Web | |
| |
| |
| Web Support | |
| |
| |
| Summary | |
| |
| |
| ERP and the Data Warehouse | |
| |
| |
| ERP Applications Outside the Data Warehouse | |
| |
| |
| Building the Data Warehouse inside the ERP Environment | |
| |
| |
| Feeding the Data Warehouse through ERP and Non-ERP Systems | |
| |
| |
| The ERP-Oriented Corporate Data Warehouse | |
| |
| |
| Summary | |
| |
| |
| Data Warehouse Design Review Checklist | |
| |
| |
| When to Do Design Review | |
| |
| |
| Who Should Be in the Design Review? | |
| |
| |
| What Should the Agenda Be? | |
| |
| |
| The Results | |
| |
| |
| Administering the Review | |
| |
| |
| A Typical Data Warehouse Design Review | |
| |
| |
| Summary | |
| |
| |
| Appendix | |
| |
| |
| Glossary | |
| |
| |
| Reference | |
| |
| |
| Index | |