You are previewing DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals.
O'Reilly logo
DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals

Book Description

Geared to IT professionals eager to get into the all-important field of data warehousing, this book explores all topics needed by those who design and implement data warehouses. Readers will learn about planning requirements, architecture, infrastructure, data preparation, information delivery, implementation, and maintenance. They'll also find a wealth of industry examples garnered from the author's 25 years of experience in designing and implementing databases and data warehouse applications for major corporations.

Market: IT Professionals, Consultants.

Table of Contents

  1. Copyright
  2. Dedication
  3. FOREWORD
  4. PREFACE
  5. THE COMPELLING NEED FOR DATA WAREHOUSING
    1. CHAPTER OBJECTIVES
    2. ESCALATING NEED FOR STRATEGIC INFORMATION
    3. FAILURES OF PAST DECISION-SUPPORT SYSTEMS
    4. OPERATIONAL VERSUS DECISION-SUPPORT SYSTEMS
    5. DATA WAREHOUSING-THE ONLY VIABLE SOLUTION
    6. DATA WAREHOUSE DEFINED
    7. CHAPTER SUMMARY
    8. REVIEW QUESTIONS
    9. EXERCISES
  6. DATA WAREHOUSE: THE BUILDING BLOCKS
    1. CHAPTER OBJECTIVES
    2. DEFINING FEATURES
    3. DATA WAREHOUSES AND DATA MARTS
    4. OVERVIEW OF THE COMPONENTS
    5. METADATA IN THE DATA WAREHOUSE
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  7. TRENDS IN DATA WAREHOUSING
    1. CHAPTER OBJECTIVES
    2. CONTINUED GROWTH IN DATA WAREHOUSING
    3. SIGNIFICANT TRENDS
    4. EMERGENCE OF STANDARDS
    5. WEB-ENABLED DATA WAREHOUSE
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  8. PLANNING AND PROJECT MANAGEMENT
    1. CHAPTER OBJECTIVES
    2. PLANNING YOUR DATA WAREHOUSE
    3. THE DATA WAREHOUSE PROJECT
    4. THE PROJECT TEAM
    5. PROJECT MANAGEMENT CONSIDERATIONS
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  9. DEFINING THE BUSINESS REQUIREMENTS
    1. CHAPTER OBJECTIVES
    2. DIMENSIONAL ANALYSIS
    3. INFORMATION PACKAGES—A NEW CONCEPT
    4. REQUIREMENTS GATHERING METHODS
    5. REQUIREMENTS DEFINITION: SCOPE AND CONTENT
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  10. Requirements As The Driving Force For Data Warehousing
    1. CHAPTER OBJECTIVES
    2. DATA DESIGN
    3. THE ARCHITECTURAL PLAN
    4. DATA STORAGE SPECIFICATIONS
    5. INFORMATION DELIVERY STRATEGY
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  11. THE ARCHITECTURAL COMPONENTS
    1. CHAPTER OBJECTIVES
    2. UNDERSTANDING DATA WAREHOUSE ARCHITECTURE
    3. DISTINGUISHING CHARACTERISTICS
    4. ARCHITECTURAL FRAMEWORK
    5. TECHNICAL ARCHITECTURE
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  12. INFRASTRUCTURE AS THE FOUNDATION FOR DATA WAREHOUSING
    1. CHAPTER OBJECTIVES
    2. INFRASTRUCTURE SUPPORTING ARCHITECTURE
    3. HARDWARE AND OPERATING SYSTEMS
    4. DATABASE SOFTWARE
    5. COLLECTION OF TOOLS
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  13. THE SIGNIFICANT ROLE OF METADATA
    1. CHAPTER OBJECTIVES
    2. WHY METADATA IS IMPORTANT
    3. METADATA TYPES BY FUNCTIONAL AREAS
    4. BUSINESS METADATA
    5. TECHNICALMETADATA
    6. HOW TO PROVIDE METADATA
    7. CHAPTER SUMMARY
    8. REVIEW QUESTIONS
    9. EXERCISES
  14. PRINCIPLES OF DIMENSIONAL MODELING
    1. CHAPTER OBJECTIVES
    2. FROM REQUIREMENTS TO DATA DESIGN
    3. THE STAR SCHEMA
    4. STAR SCHEMA KEYS
    5. ADVANTAGES OF THE STAR SCHEMA
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  15. DIMENSIONAL MODELING: ADVANCED TOPICS
    1. CHAPTER OBJECTIVES
    2. UPDATES TO THE DIMENSION TABLES
    3. MISCELLANEOUS DIMENSIONS
    4. THE SNOWFLAKE SCHEMA
    5. AGGREGATE FACT TABLES
    6. FAMILIES OF STARS
    7. CHAPTER SUMMARY
    8. REVIEW QUESTIONS
    9. EXERCISES
  16. DATA EXTRACTION, TRANSFORMATION, AND LOADING
    1. CHAPTER OBJECTIVES
    2. ETL OVERVIEW
    3. DATA EXTRACTION
    4. DATA TRANSFORMATION
    5. DATA LOADING
    6. ETL SUMMARY
    7. CHAPTER SUMMARY
    8. REVIEW QUESTIONS
    9. EXERCISES
  17. DATA QUALITY: A KEY TO SUCCESS
    1. CHAPTER OBJECTIVES
    2. WHY IS DATA QUALITY CRITICAL?
    3. DATA QUALITY CHALLENGES
    4. DATA QUALITY TOOLS
    5. DATA QUALITY INITIATIVE
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  18. MATCHING INFORMATION TO THE CLASSES OF USERS
    1. CHAPTER OBJECTIVES
    2. INFORMATION FROM THE DATA WAREHOUSE
    3. WHO WILL USE THE INFORMATION?
    4. INFORMATION DELIVERY
    5. INFORMATION DELIVERY TOOLS
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  19. OLAP IN THE DATA WAREHOUSE
    1. CHAPTER OBJECTIVES
    2. DEMAND FOR ONLINE ANALYTICAL PROCESSING
    3. MAJOR FEATURES AND FUNCTIONS
    4. OLAP MODELS
    5. OLAP IMPLEMENTATION CONSIDERATIONS
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  20. DATA WAREHOUSING AND THE WEB
    1. CHAPTER OBJECTIVES
    2. WEB-ENABLED DATA WAREHOUSE
    3. WEB-BASED INFORMATION DELIVERY
    4. OLAP AND THE WEB
    5. BUILDING A WEB-ENABLED DATA WAREHOUSE
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  21. DATA MINING BASICS
    1. CHAPTER OBJECTIVES
    2. WHAT IS DATA MINING?
    3. MAJOR DATA MINING TECHNIQUES
    4. DATA MINING APPLICATIONS
    5. CHAPTER SUMMARY
    6. REVIEW QUESTIONS
    7. EXERCISES
  22. THE PHYSICAL DESIGN PROCESS
    1. CHAPTER OBJECTIVES
    2. PHYSICAL DESIGN STEPS
    3. PHYSICAL DESIGN CONSIDERATIONS
    4. PHYSICAL STORAGE
    5. INDEXING THE DATA WAREHOUSE
    6. PERFORMANCE ENHANCEMENT TECHNIQUES
    7. CHAPTER SUMMARY
    8. REVIEW QUESTIONS
    9. EXERCISES
  23. DATA WAREHOUSE DEPLOYMENT
    1. CHAPTER OBJECTIVES
    2. MAJOR DEPLOYMENT ACTIVITIES
    3. CONSIDERATIONS FOR A PILOT
    4. SECURITY
    5. BACKUP AND RECOVERY
    6. CHAPTER SUMMARY
    7. REVIEW QUESTIONS
    8. EXERCISES
  24. GROWTH AND MAINTENANCE
    1. CHAPTER OBJECTIVES
    2. MONITORING THE DATA WAREHOUSE
    3. USER TRAINING AND SUPPORT
    4. MANAGING THE DATA WAREHOUSE
    5. CHAPTER SUMMARY
    6. REVIEW QUESTIONS
    7. EXERCISES
  25. PROJECT LIFE CYCLE STEPS AND CHECKLISTS
    1. DATA WAREHOUSE PROJECT LIFE CYCLE: MAJOR STEPS AND SUBSTEPS
    2. PROJECT PLANNING
    3. REQUIREMENTS DEFINITION
    4. DESIGN
    5. CONSTRUCTION
    6. DEPLOYMENT
    7. MAINTENANCE
    8. CHECKLISTS FOR MAJOR ACTIVITIES
    9. PROJECT PLANNING
    10. REQUIREMENTS DEFINITION
    11. DESIGN
    12. CONSTRUCTION
    13. DEPLOYMENT
    14. MAINTENANCE
  26. CRITICAL FACTORS FOR SUCCESS
  27. GUIDELINES FOR EVALUATING VENDOR SOLUTIONS
  28. REFERENCES
  29. GLOSSARY