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
Similar book on Amazon
SQL Hacks
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
Successful Business Intelligence: Secrets to Making BI a Killer App
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
WebLogic: The Definitive Guide
Using JNDI and RMI
Overview of JDBC Resources
JMS
Creating Domains
JMX
C++ How to Program (5th Edition)
Example: High-Performance Card Shuffling and Dealing Simulation
Memory Functions of the Pointer-Based String-Handling Library
F.3. The #define Preprocessor Directive: Symbolic Constants
I.2. Tutorials
I.7. Standard Template Library
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 2. Find Yourself (and Others) on Google Maps
Hack 19. Map Local Weather Conditions
Hack 44. You Got Your A9 Local in My Google Maps!
Hack 61. Use the Right Developers Key Automatically
Hack 68. Automatically Cut and Name Custom Map Tiles
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Phase 1 Readiness Assessment
Phase 3 Mobilization
Phase 4 Performance and Control
Service Process Challenges
Raising the Stakes in Service Process Improvement
Telecommunications Essentials, Second Edition: The Complete Global Source (2nd Edition)
The Electromagnetic Spectrum and Bandwidth
Internet Addressing and Address Resolution
Multimedia Networking Requirements
Fiber Solutions
5G: Enhanced Data Services
GDI+ Programming with C#
Working with Fonts
Advanced Typography
Matrix Operations in Image Processing
Appendix A. Exception Handling in .NET
Section A.3. Understanding Exception Classes
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