Practical Data Migration

Table of contents

1. Copyright
2. List of Figures and Tables
3. Author
4. Foreword
5. Glossary
6. Preface
7. Introduction
8. Part One Reasons and Methods
   1. 1 Reasons
      1. WHY QUALITY DATA MIGRATION MATTERS
      2. A PRACTITIONE’S PERSPECTIVE
   2. 2 The Golden Rules
      1. THE MOST IMPORTANT LESSONS
   3. 3 Data Stakeholders
      1. INTRODUCTION
      2. THE COMMUTER AND THE KNIGHT ERRANT
      3. OWNERSHIP
      4. FINDING THE RIGHT FELLOW TRAVELLERS
   4. 4 Four Key Concepts
      1. FIRST: A HEALTH WARNING
      2. USING CONCEPTUAL ENTITY MODELS TO DEFINE THE KEY BUSINESS DATA AREAS
      3. DOCUMENTING KEY BUSINESS DATA AREA RELATIONS
      4. DOCUMENTING INDIVIDUAL KEY BUSINESS DATA AREAS
      5. CONFUSING DATA STRUCTURES AND BUSINESS FUNCTIONS
      6. LEGACY DATA STORES
      7. DOCUMENTING LEGACY DATA STORES
   5. 5 Data Quality Rules
      1. INTRODUCING DATA QUALITY RULES
      2. A TYPICAL DATA QUALITY RULE DOCUMENT
      3. DATA QUALITY ASSESSMENT
      4. METHOD STATEMENTS
      5. METRICS
      6. GENERATING DATA QUALITY RULES
   6. 6 Data Gaps and Data Mapping
      1. HEALTH WARNING
      2. STANDARD DATA MIGRATION TERMS
      3. DATA GAP ANALYSIS
      4. DATA MAPPING
   7. 7 Non-functional Requirements
      1. INTRODUCTION
      2. DATA SIZING
      3. RUN TIMES
      4. SEQUENCING
      5. HARDWARE AND SOFTWARE CONSIDERATIONS
      6. WINDOWS OF OPPORTUNITY
      7. DATA MIGRATION IMPLEMENTATION FORMS
      8. FALLBACK
      9. THE ‘ONE WAY STREET‘ PROBLEM
9. Part Two Specimen Project
   1. 8 Project Overview
      1. INTRODUCTION
      2. SPECIMEN PROJECT OVERVIEW
      3. WHY A SEPARATE PROJECT?
      4. BACK TO THE EXAMPLE PROJECT
      5. USE OF ITERATION
      6. PROJECT CONTROL POINTS AND PLANNING
   2. 9 Stage 0 Project Initiation
      1. INTRODUCTION
      2. STANDARD PROJECT INITIATION DELIVERABLES
      3. CREATE YOUR OWN DATA MIGRATION STRATEGY
      4. FIRST-CUT PROJECT PLAN
      5. SET UP AN APPROPRIATE PROJECT SUPPORT OFFICE FUNCTION
      6. INITIAL LISTS OF DATA STORE OWNERS, LEGACY DATA STORES AND KEY BUSINESS DATA AREAS
      7. STAGE 0 CLOSEDOWN
      8. STAGE 0 PROJECT CONTROL POINTS
   3. 10 Stage 1 Data Preparation
      1. STEP 1.0: STAGE INITIATION
      2. STEP 1.1: ANALYSE LEGACY DATA STORES
      3. STEP 1.2: UPDATE KEY BUSINESS DATA AREA MODELS
      4. STEP 1.3: CREATE FIRST-CUT SYSTEM RETIREMENT POLICIES
      5. STEP 1.4: CREATE DATA QUALITY RULES
      6. STEP 1.5: ENACT DATA QUALITY RULES
      7. DATA TRANSITIONAL RULES
      8. TRANSIENT DATA STORES
      9. USE OF RECURSION
      10. STAGE 1 CLOSEDOWN
      11. STAGE 1 PROJECT CONTROLS
   4. 11 Stage 2 Data Preparation
      1. STEP 2.0: STAGE INITIATION
      2. STEP 2.1: NOMINATE CANDIDATE LEGACY DATA STORES
      3. STEP 2.2: CREATE STAGE 2 DATA QUALITY RULES
      4. STEP 2.3: ENACT DATA QUALITY RULES
      5. STEP 2.4: ENHANCE SYSTEM RETIREMENT POLICIES
      6. DATA TRANSITIONAL RULES
      7. TRANSIENT DATA STORES
      8. STAGE 2 CLOSEDOWN
      9. STAGE 2 PROJECT CONTROLS
   5. 12 Stage 3 Build, Test and Go Live
      1. STAGE 3 OVERVIEW
      2. STEP 3.0: STAGE INITIATION
      3. STEP 3.1: PHYSICAL DESIGN OF MIGRATION
      4. STEP 3.2: DATA MIGRATION TESTING
      5. STEP 3.3: BUILDING THE MIGRATION SOFTWARE
      6. STEP 3.4: EXECUTE THE MIGRATION
      7. STEP 3.5: POST-IMPLEMENTATION REVIEW
      8. STAGE 3 PROJECT CONTROLS
10. Part Three Rescuing Data Migration Projects
    1. 13 Data Migration Projects That Have Gone Wrong: A Survival Guide
       1. INTRODUCTION
       2. STABILIZATION
       3. PLANNED ACTIVITY
       4. POST-IMPLEMENTATION MOP-UP
       5. CONCLUSION
11. Index