| |
| |
| Foreword | |
| |
| |
| Introduction | |
| |
| |
| |
| The Data Warehouse | |
| |
| |
| |
| Business Intelligence | |
| |
| |
| |
| The Business of Chess | |
| |
| |
| |
| Business Intelligence | |
| |
| |
| |
| The Data Warehouse | |
| |
| |
| |
| Subject Orientation | |
| |
| |
| |
| Integration | |
| |
| |
| |
| Nonvolatile | |
| |
| |
| |
| Time-Variant Collection of Data | |
| |
| |
| |
| Supporting Management's Decision | |
| |
| |
| |
| Decision Support Systems | |
| |
| |
| |
| Reporting | |
| |
| |
| |
| On-Line Analytical Processing | |
| |
| |
| |
| Data Mining | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Glossary | |
| |
| |
| |
| Object-Oriented Design | |
| |
| |
| |
| The Development Process | |
| |
| |
| |
| Shortcomings of Waterfall Approach | |
| |
| |
| |
| The Development Spiral | |
| |
| |
| |
| The Advantages of the Development Spiral | |
| |
| |
| |
| Metadata | |
| |
| |
| |
| Types of Metadata | |
| |
| |
| |
| The Central Metadata Repository | |
| |
| |
| |
| Enterprise Data Model | |
| |
| |
| |
| The Objective of Objects | |
| |
| |
| |
| Classes and Superclasses | |
| |
| |
| |
| Aggregations and Behaviors | |
| |
| |
| |
| Modeling Objects | |
| |
| |
| |
| The Advantages of Object Modeling | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Glossary | |
| |
| |
| |
| Analysis and Design | |
| |
| |
| |
| The Definition Phase | |
| |
| |
| |
| Case Study--Definition Phase | |
| |
| |
| |
| The Analysis Phase | |
| |
| |
| |
| The Interview Process | |
| |
| |
| |
| The Analysis Model | |
| |
| |
| |
| The Design Phase | |
| |
| |
| |
| The Object Model | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Glossary | |
| |
| |
| |
| The Implementation Model | |
| |
| |
| |
| Dimensionality | |
| |
| |
| |
| Dimensionality and Information Systems | |
| |
| |
| |
| Multidimensional Databases | |
| |
| |
| |
| Working in Multiple Dimensions | |
| |
| |
| |
| Multidimensional Database Issues | |
| |
| |
| |
| Big Brother and the Building Company's Analysis Space | |
| |
| |
| |
| Star Schema | |
| |
| |
| |
| Working with the Star Schema | |
| |
| |
| |
| Big Brother and the Building Company's Implementation Model | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Glossary | |
| |
| |
| |
| Dimension Tables--the Nouns of the Data Warehouse | |
| |
| |
| |
| Dimension-Table Characteristics | |
| |
| |
| |
| Slowly Changing Dimensions | |
| |
| |
| |
| Constellations and Conforming Dimensions | |
| |
| |
| |
| Snowflakes | |
| |
| |
| |
| Many-to-Many Relationships | |
| |
| |
| |
| Hierarchies and Aggregations | |
| |
| |
| |
| Nonanalytical Data | |
| |
| |
| |
| Dimension of Time | |
| |
| |
| |
| The Dimensions of BBBC | |
| |
| |
| |
| Broker Dimension | |
| |
| |
| |
| Client Dimension | |
| |
| |
| |
| Commercial Real Estate Company Dimension | |
| |
| |
| |
| Property Dimension | |
| |
| |
| |
| Time | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Glossary | |
| |
| |
| |
| Fact Tables--the Verbs of the Data Warehouse | |
| |
| |
| |
| Fact Tables | |
| |
| |
| |
| Measure By Measure | |
| |
| |
| |
| Precision | |
| |
| |
| |
| Granularity | |
| |
| |
| |
| Additive, Semiadditive, and Nonadditive | |
| |
| |
| |
| Factless Fact Tables | |
| |
| |
| |
| Degenerate Dimensions | |
| |
| |
| |
| Degenerate Facts | |
| |
| |
| |
| Heterogeneous Fact Tables | |
| |
| |
| |
| BBBC Fact Tables | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Glossary | |
| |
| |
| |
| Implementation Considerations | |
| |
| |
| |
| Parallel Processing | |
| |
| |
| |
| The Perils of Parallelism | |
| |
| |
| |
| The Geometry of Parallelism | |
| |
| |
| |
| The Parallel Nature of the Data Warehouse | |
| |
| |
| |
| Parallel Architectures | |
| |
| |
| |
| Parallel Data Storage | |
| |
| |
| |
| Parallel Databases | |
| |
| |
| |
| Bitmapped Indexing | |
| |
| |
| |
| Star Query Optimization | |
| |
| |
| |
| Summation Tables | |
| |
| |
| |
| Web-Enabled Data Warehousing | |
| |
| |
| |
| The BBBC Data Warehouse | |
| |
| |
| |
| Summary | |
| |
| |
| |
| Glossary | |
| |
| |
| |
| The Spacially Enabled Data Warehouse | |
| |
| |
| |
| Analyzing Patient Needs | |
| |
| |
| |
| Extraction, Transformation, and Loading | |
| |
| |
| |
| The ETL Strategy | |
| |
| |
| |
| ETL Process | |
| |
| |
| |
| Metadata Standards | |
| |
| |
| |
| The Open Information Model | |
| |
| |
| |
| Common Warehouse Metadata | |
| |
| |
| |
| Conventional Wisdom, Tips, Hints, and General Advice | |
| |
| |
| Glossary | |
| |
| |
| Index | |