BUILDING THE DATA WAREHOUSE
CO NTE NTS CHAPTER 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 CHAPTER 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 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 TEAMFLY 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 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 THE DATA WAREHOUSE AND TECHNOLOGY MANAGING LARGE AMOUNTS OF DATA MANAGING MULTIPLE MEDIA 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 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 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 MULTIPLE PLATFORMS FOR COMMON DETAIL DATA 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 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 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 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 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 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