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
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Looping Commands
The Art of Using Animated Sprites for 2D Games
Programming the Keyboard, Mouse, and Joystick
Playing Intro Movies and Cut-Scenes
Appendix A Answers to the Chapter Quizzes
Project Management JumpStart
Building the Foundation
Initiating the Project
Assessing Risk
Closing the Books
Appendix C Sample Project Management Checklists
Beginning Cryptography with Java
Message Digests, MACs, and HMACs
Asymmetric Key Cryptography
Object Description in Cryptography Using ASN.1
Certificate Revocation and Path Validation
Key and Certificate Management Using Keystores
Data Structures and Algorithms in Java
Extending a Class
Stacks and Queues
Amortized Analysis
The Java Collections Framework Again
A.4. Interacting with the User
Junos Cookbook (Cookbooks (OReilly))
Exiting Configuration Mode
Creating a Login Banner
Introduction
Configuring Frame Relay on a T1 Interface
Load-Balancing BGP Traffic
Comparing, Designing, and Deploying VPNs
Review Questions
Implementing QoS for MPLS Layer 3 VPNs
Review Questions
Designing and Deploying IPsec Remote Access and Teleworker VPNs
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