Flylib.com
Dimensional Data Warehousing with MySQL: A Tutorial
Dimensional Data Warehousing with MySQL: A Tutorial
ISBN: 0975212826
EAN: 2147483647
Year: 2004
Pages: 149
Authors:
Djoni Darmawikarta
BUY ON AMAZON
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
Year: 2004
Pages: 149
Authors:
Djoni Darmawikarta
BUY ON AMAZON
A+ Fast Pass
Domain 4 Motherboard/Processors/Memory
Domain 5 Printers
Domain 6 Basic Networking
Domain 1 Operating System Fundamentals
Domain 3 Diagnosing and Troubleshooting
Managing Enterprise Systems with the Windows Script Host
Introduction
Shell Operations
Logon Scripts and Scheduling
Networking Resources
Internet Applications
Visual C# 2005 How to Program (2nd Edition)
Summary
Windows Forms
TreeView Control
Introduction
Using a DataSet to Read and Write XML
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The Microsoft Client Library for AJAX
The Pulsing Heart of ASP.NET AJAX
The AJAX Control Toolkit
Built-in Application Services
Remote Method Calls with ASP.NET AJAX
Ruby Cookbook (Cookbooks (OReilly))
Simulating a Subclass of Fixnum
Automatically Initializing Instance Variables
Unit Testing Your Web Site
Testing, Debugging, Optimizing, and Documenting
Getting Input One Line at a Time
Understanding Digital Signal Processing (2nd Edition)
THE COMMUTATIVE PROPERTY OF LINEAR TIME-INVARIANT SYSTEMS
THE DFT OF RECTANGULAR FUNCTIONS
FFT SOFTWARE PROGRAMS
Chapter Thirteen. Digital Signal Processing Tricks
DUAL-MODE AVERAGING
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies