Dimensional Data Warehousing with MySQL: A Tutorial - page 1
- 1
- 2
- Back Cover
- Back Cover
- Back Cover
- Dimensional Data Warehousing with MySQL-A Tutorial
- Introduction
- Who This Book Is For
- Prerequisite Skills
- What You Will Get from This Book
- Chapters Overview
- Code Download
- Part I: Fundamentals
- Chapter 1: Basic Components
- The Star Schema
- Surrogate Keys
- Tasks
- Summary
- Chapter 2: Dimension History
- Slowly Changing Dimension Type 1 (SCD1)
- Slowly Changing Dimension Type 2 (SCD2)
- Summary
- Chapter 3: Measure Additivity
- Testing Fully-Additivity
- Summary
- Chapter 4: Dimensional Queries
- Aggregate Queries
- Specific Queries
- Inside-Out Queries
- Summary
- Part II: Extract, Transform, and Load
- Chapter 5: Source Extraction
- Whole Source or Change Data Capture (CDC)
- Pull by Data or Push by Source
- Push-by-source CDC on Sales Orders Extraction
- Testing
- Summary
- Chapter 6: Populating the Date Dimension
- Pre-population
- Testing Pre-Population
- One-Date-Every-Day
- Loading Dates from the Source
- Summary
- Chapter 7: Initial Population
- Source Data
- Initial Population Script
- Running the Initial Population Script
- Summary
- Chapter 8: Regular Population
- Regular Population Script
- Testing Data
- Summary
- Chapter 9: Regular Population Scheduling
- Scheduling the Batch Job
- Summary
- Part III: Growth
- Chapter 10: Adding Columns
- Revising Regular Population Script
- Testing
- Summary
- Chapter 11: On-Demand Population
- Performing On-Demand Population
- Testing
- Summary
- Chapter 12: Subset Dimensions
- Pennsylvania Customer Dimension
- Revising the Regular Population
- Testing the Revised Regular Population
- Summary
- Chapter 13: Dimension Role Playing
- Table Alias Implementation
- Database View
- Summary
- Chapter 14: Snapshots
- Periodic Snapshots
- Accumulating Snapshots
- Preparing Data for Regular Population
- Summary
- Chapter 15: Dimension Hierarchies
- Grouping and Drilling Queries
- Summary
- Chapter 16: Multi-Path and Ragged Hierarchies
- 1
- 2
