Relational Solutions, Inc.

Data Warehouse Methodology

Summary Version

 

The Seven Major Steps:

  1. Business Analysis
  2. Database Design
  3. Extract/Transform/Load
  4. Query
  5. Performance & Tuning
  6. Change Management
  7. Backup & Recovery

Business Analysis

 

Database Design

 

 

Extraction/Transformation/Load

 

Query Tool

  1. Install query tool.
  2. Define/review meta data requirements.
  3. Define reusable/common queries.
  4. Define batch query requirements.
  5. Implement batch and reusable queries.
  6. Test all predefined queries.
  7. Test ad-hoc capabilities.
  8. Review with end users.
  9. Implement changes.
  10. Review with end users.

Database Performance & Tuning.

Implement Backup & Recovery Plans.

Implement Change Management Strategy