| |
| |
| List of Figures | |
| |
| |
| Preface | |
| |
| |
| |
| Evolution of Decision Support Systems | |
| |
| |
| The Evolution | |
| |
| |
| The Advent of Disk Storage | |
| |
| |
| PC/4GL Technology | |
| |
| |
| Enter the Extract Program | |
| |
| |
| The "Spider Web" | |
| |
| |
| Problems With the Naturally Evolving Architecture | |
| |
| |
| Lack of Credibility of Data | |
| |
| |
| The Problems With Productivity | |
| |
| |
| From Data To Information | |
| |
| |
| A Change in Approaches | |
| |
| |
| The Architected Environment | |
| |
| |
| Integration | |
| |
| |
| The Development Life Cycle | |
| |
| |
| Patterns of Hardware Utilization | |
| |
| |
| The Information Cycle | |
| |
| |
| |
| The Data Warehouse/Rdb Environment | |
| |
| |
| What Is a Data Warehouse? | |
| |
| |
| Subject Orientation | |
| |
| |
| Integration | |
| |
| |
| Time Variancy | |
| |
| |
| Nonvolatile | |
| |
| |
| General Structure of the Data Warehouse | |
| |
| |
| Subject Orientation | |
| |
| |
| Day 1 - Day n Phenomena | |
| |
| |
| Granularity | |
| |
| |
| An Example of Granularity | |
| |
| |
| Dual Levels of Granularity | |
| |
| |
| Living Sample Data | |
| |
| |
| Partitioning of Data | |
| |
| |
| Structuring Data in the Data Warehouse | |
| |
| |
| DEC and the Data Warehouse | |
| |
| |
| |
| Data Warehouse and Design | |
| |
| |
| Beginning with Operational Data | |
| |
| |
| Data/Process Models and the Architected Environment | |
| |
| |
| Data Warehouse and Data Models | |
| |
| |
| The Data Model | |
| |
| |
| The ERD | |
| |
| |
| The Mid-Level Data Model | |
| |
| |
| The Physical Data Model | |
| |
| |
| Normalization/Denormalization | |
| |
| |
| |
| Granularity in the Data Warehouse | |
| |
| |
| Raw Estimates | |
| |
| |
| Input into the Planning Process | |
| |
| |
| Dual or Singular Levels of Granularity? | |
| |
| |
| What the Levels of Granularity Will Be | |
| |
| |
| Some Feedback Loop Techniques | |
| |
| |
| Levels of Granularity - Banking Environment | |
| |
| |
| |
| VAX Rdb/VMS Features for Decision Support Systems | |
| |
| |
| SQL | |
| |
| |
| Creating the Database Structure | |
| |
| |
| Buffering | |
| |
| |
| Read-Only Storage Areas | |
| |
| |
| Creating the Tables to Hold Your Data | |
| |
| |
| The METADATA | |
| |
| |
| The TABLE | |
| |
| |
| Indexes | |
| |
| |
| Placing the Data | |
| |
| |
| Optimization | |
| |
| |
| Loading the Data Warehouse | |
| |
| |
| RMU/Load | |
| |
| |
| VAX Data Distributor | |
| |
| |
| Write Your Own Program | |
| |
| |
| Other Products Used in DSS Environments | |
| |
| |
| |
| Miscellaneous (But Important!) Topics | |
| |
| |
| Decentralized Data Warehouse | |
| |
| |
| Organizational Considerations | |
| |
| |
| Metadata | |
| |
| |
| Artifact Relationships | |
| |
| |
| Reporting and the Data Warehouse | |
| |
| |
| Security | |
| |
| |
| |
| EIS and Data Warehouse | |
| |
| |
| A Simple Example | |
| |
| |
| Drill-Down Analysis | |
| |
| |
| Supporting the Drill-Down Process | |
| |
| |
| The Data Warehouse | |
| |
| |
| Where to Turn | |
| |
| |
| |
| External/Unstructured Data and the Data Warehouse | |
| |
| |
| Metadata | |
| |
| |
| Storing External/Unstructured Data | |
| |
| |
| Modelling and External/Unstructured Data | |
| |
| |
| Secondary Reports | |
| |
| |
| Archiving Data | |
| |
| |
| |
| Migration to the Architected Environment | |
| |
| |
| A Migration Plan | |
| |
| |
| The Feedback Loop | |
| |
| |
| Strategic Considerations | |
| |
| |
| |
| A DSS Design Review Checklist | |
| |
| |
| When To Do Design Review | |
| |
| |
| Who Should Be In the Design Review | |
| |
| |
| What | |
| |
| |
| The Results | |
| |
| |
| Administering the Review | |
| |
| |
| A Typical Rdb DSS Design Review | |
| |
| |
| References | |
| |
| |
| Index | |