Home Page Icon
Home Page
Table of Contents for
Code Download
Close
Code Download
by Djoni Darmawikarta
Dimensional Data Warehousing with MySQL: A Tutorial
Copyright
Introduction
What This Book Is About and What It Is Not
Who This Book Is For
Prerequisite Skills
What You Will Get from This Book
Chapters Overview
Code Download
Fundamentals
Basic Components
The Star Schema
Surrogate Keys
Tasks
Summary
Dimension History
Slowly Changing Dimension Techniques
Slowly Changing Dimension Type 1 (SCD1)
Slowly Changing Dimension Type 2 (SCD2)
Summary
Measure Additivity
Fully-Additive Measures
Testing Fully-Additivity
Summary
Dimensional Queries
Applying Dimensional Queries
Aggregate Queries
Specific Queries
Inside-Out Queries
Summary
Extract, Transform, and Load
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
Populating the Date Dimension
Pre-population
Testing Pre-Population
One-Date-Every-Day
Loading Dates from the Source
Summary
Initial Population
Source Data
Initial Population Script
Running the Initial Population Script
Summary
Regular Population
Identifying Data Sources and Loading Types
Regular Population Script
Testing Data
Summary
Regular Population Scheduling
Preparing the Batch File
Scheduling the Batch Job
Summary
Growth
Adding Columns
Enhancing the Schema
Revising Regular Population Script
Testing
Summary
On-Demand Population
Enhancing the Schema
Performing On-Demand Population
Testing
Summary
Subset Dimensions
Month Roll-up Dimension
Pennsylvania Customer Dimension
Revising the Regular Population
Testing the Revised Regular Population
Summary
Dimension Role Playing
Adding Request Delivery Dates
Table Alias Implementation
Database View
Summary
Snapshots
Periodic Snapshots
Accumulating Snapshots
Preparing Data for Regular Population
Summary
Dimension Hierarchies
Hierarchies in A Data Warehouse
Grouping and Drilling Queries
Summary
Multi-Path and Ragged Hierarchies
Adding A Hierarchy
Adding 2006 Data
Hierarchical Queries
Ragged Hierarchies
Summary
Degenerate Dimensions
Degenerating the Order Dimension
Revising the Regular Population Script
Testing the Revised Regular Population Script
Summary
Junk Dimensions
Adding the Sales Order Attribute Junk Dimension
Revising the Regular Population Script
Summary
Multi-Star Schemas
The New Star Schema
Populating the New Star’s Tables
Testing
Summary
Advanced Techniques
Non-straight Sources
Overview
Revising the Campaign Population Script
Summary
Factless Facts
Product Launch Factless Facts
Revising the DW Regular Population Script
Summary
Late Arrival Facts
Handling Late Arrival Facts
Testing
Summary
Dimension Consolidation
Revising the Data Warehouse Schema
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
Accumulated Measures
The Revised Schema
Initial Population
Testing the Initial Population Script
Regular Population
Example Queries
Summary
Band Dimensions
Annual Sales Order Star Schema
Initial Population
Revising the Regular Population Script
Testing
Summary
Flat File Data Sources
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Chapters Overview
Next
Next Chapter
Fundamentals
Code Download
The program examples accompanying this book can be downloaded from
http://jtute.com
.
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset