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
The .NET Developers Guide to Directory Services Programming
Chasing Referrals
Basics of Reading Attribute Values
Summary
LDIFDE
Summary
VBScript Programmers Reference
Error Handling and Debugging
Classes in VBScript (Writing Your Own COM Objects)
Windows Script Host
Appendix G The Windows Script Host Object Model
Appendix I VBScript Features not in VBA
Managing Enterprise Systems with the Windows Script Host
Shell Operations
Input/Output Streams
Registry Operations
Messaging Operations
Security
Cisco Voice Gateways and Gatekeepers
Basic Digit Manipulation
Order of Operation in Digit Manipulation
Hunt Groups
Call Admission Control
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
The Challenges of Web Application Development
Creating a Struts-based MVC Application
Managing Business Logic with Struts
Building a Data Access Tier with ObjectRelationalBridge
Creating a Search Engine with Lucene
Microsoft Office Visio 2007 Step by Step (Step By Step (Microsoft))
Applying Themes to Entire Diagrams
Exporting Timelines to Create Gantt Charts
Creating Network Diagrams
Creating Network Reports
Glossary
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