Building a data warehouse for decision support / Vidette Poe with contributions by Laura L. Reeves.

Enhanced descriptions from Syndetics:

A guide to developing and implementing a data warehouse, for database designers and administrators, programmers, and system and data architects. Emphasizes the difference between operational and analytical processing and the architecture and infrastructure for the data warehouse, discusses the decision support life cycle, and teaches a database design for large warehouses called Star Schema. Contains numerous case studies and "tips from the trenches," plus product and vendor listings. Annotation copyright by Book News, Inc., Portland, OR

Table of contents provided by Syndetics

• Note: Each chapter concludes with a summary
• 1 Let's Start with the Basics
• What is a Decision Support System?
• Understanding Operational versus Analytical Processing
• What is A Data Warehouse?
• Real Life Data Warehouse Examples
• Community Mutual Insurance Company
• A Corporate Overview Meeting the Need for Information-Predecessor Systems
• In the Beginning . . .
• Gathering Data Requirements
• Infrastructures
• User Reaction to Initial Development
• The User Community
• Building on the Warehouse
• What the Future Holds
• 20/20 Hindsight
• Tips from the Trenches
• 1.1 Learning from Community
• Mutual Internal Cost Allocations: Chargebacks
• A Consumer Packaged Goods Company
• A Corporate Overview
• How it Got Started
• Implementation Project
• Architecture and Infrastructure
• End User Reaction
• Data Warehouse Expansion 20/20 Hindsight
• Endnote
• 2 Understanding Terms and Technology
• Analytical Processing
• Operational Processing
• Decision Support Systems
• Data Warehouse
• Environment for Data Access
• Architecture
• Technical Infrastructures
• Source and Target Data
• Levels of Users
• Classes of Tools
• Decision Support System (DSS) Applications
• Data Transformation
• Data Transformation Tools
• Middleware Tools
• Metadata
• Star Schema
• Hierarchies
• Granularity
• Database Gateway
• Megabytes, Gigabytes, and Terabytes
• Decision Support Development Cycle
• 3 Understanding Architecture and Infrastructures
• The Task at Hand
• Understanding Data Warehouse Architecture
• The Characteristics of Data Warehouse Architecture
• Data Is Extracted from Source Systems, Database, or Files
• The Data from the Source Systems is Integrated and Transformed before Being Loaded into the Data Warehouse
• A Separate Read-only Database is Created for Decision Support Data
• Users Access the Data Warehouse via a Front End Tool or Application
• Expanding the Generic Data Warehouse Architecture
• Understanding the Relationship of Infrastructures and Architecture
• Architecture and Infrastructures as a Separate Project
• Tips From the Trenches
• 3.1 Architecture and Infrastructures
• And the Answer is . . .
• 4 The Decision Support Life Cycle
• Life Cycles for System Development
• Issues Affecting the Decision Support Life Cycle
• The Decision Support Life Cycle In an Architected Environment
• The Phases of the Decision Support Life Cycle (DSLC)
• Phase 1 Planning
• Phase 2 Gathering Data Requirements and Modeling
• Gathering Data Requirements
• Data Modeling
• Phase 3 Physical Database Design and Development
• Phase 4 Data Mapping and Transformation
• Phase 5 Populating the Data Warehouse
• Tips from the Trenches
• 4.1 Availabiliy of Data
• Phase 6 Automating Data Management Procedures
• Phase 7 Application Development-Creating the Starter Set of Reports
• Phase 8 Data Validation and Testing
• Phase 9 Training
• Phase 10 Rollout
• 5 Getting Started with Data Warehouse Development
• The Proof Is in the Pilot
• Clarify the Purpose and Goal of the Pilot Project
• Treat the Pilot like a Development Project
• Building on the Pilot
• Choosing a Business Area for Data Warehouse Development
• Tips from the Trenches
• 5.1 Choosing a Business Area
• Ensuring a Successful Data Warehouse
• Tips from the Trenches
• 5.2 Building a Successful Data Warehouse "The Big Eight"
• Be Clear on Your Goal
• Understand the Chosen Data Warehouse Architecture
• Make Sure the Technical Infrastructures Are in Place or Being Put in Place
• Clarify the Project Team's Responsibility and Final Deliverable
• Make Sure the Members of the Project Team Understand the Difference between Operational and Decision Support Data
• Get the Correct Training
• Get the Right Resources
• Choose Front End Data Access Software Based on User Needs and Abilities
• 6 Gathering Data Requirements
• A Proper Mindset
• User Interviews
• The Purpose of Interviews
• Setting up Successful Interviews
• Who to Interview
• Tips from the Trenches
• 6.1 Setting Up Successful