Dimensional Data Warehousing with MySQL: A Tutorial
Dimensional Data Warehousing with MySQL: A Tutorial
ISBN: 0975212826
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 149
Pages: 149
Authors: Djoni Darmawikarta
- 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
- Adding 2006 Data
- Hierarchical Queries
- Ragged Hierarchies
- Summary
- Chapter 17: Degenerate Dimensions
- Revising the Regular Population Script
- Testing the Revised Regular Population Script
- Summary
- Chapter 18: Junk Dimensions
- Adding the Sales Order Attribute Junk Dimension
- Revising the Regular Population Script
- Summary
- Chapter 19: Multi-Star Schemas
- Populating the New Stars Tables
- Testing
- Summary
- Part IV: Advanced Techniques
- Chapter 20: Non-straight Sources
- Revising the Campaign Population Script
- Summary
- Chapter 21: Factless Facts
- Revising the DW Regular Population Script
- Summary
- Chapter 22: Late Arrival Facts
- Testing
- Summary
- Chapter 23: Dimension Consolidation
- Testing the Zip Code Dimension Implementation
- Revising the production_fact Table
- Testing the Factory Zip Codes
- Revising the Regular Population Script
- Testing the Revised Regular Population Script
- Revising the Production Regular Population Script
- Testing the Revised Production Regular Population Script
- Summary
- Chapter 24: Accumulated Measures
- Initial Population
- Testing the Initial Population Script
- Regular Population
- Example Queries
- Summary
- Chapter 25: Band Dimensions
- Initial Population
- Revising the Regular Population Script
- Testing
- Summary
- Appendix A: Flat File Data Sources
- Index
- B
- C
- D
- E
- F
- G
- H
- I
- J
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- W
- List of Figures
- List of Tables
- List of Examples
Dimensional Data Warehousing with MySQL: A Tutorial
ISBN: 0975212826
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 149
Pages: 149
Authors: Djoni Darmawikarta