The Data Warehouse lifecycle toolkit - Expert methods for designing, developing, and deploying data warehouses

Lifecycle refers to all the steps in the complete software development process: planning, design, coding, testing, implementing, and managing. This book is a step-by-step methodology for designing, developing, and deploying data marts and data warehouses. It is based on the real-life experiences of four leading data warehouse developers.

Table of contents

The Chess Pieces
The Star Lifecycle
Project Planning and Management
Collecting the Requirements
A First Course on Dimensional Modeling
A Graduate Course on Dimensional Modeling
Building Dimensional Model
Introducing Data Warehouse Architecture
Back Room Technical Architecture
Architecture for the Front Room
Infrastructure and Metadata
A Graduate Course on the Internet and Security
Creating the Architecture Plan and Selecting Products
A Graduate Course on Aggregates
Completing the Physical Design
Data Staging
Building End User Applications
Planning The Deployment
Maintaining and Growing the Data Warehouse
Appendices.