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
Qshell for iSeries
Introduction to Qshell
Running Qshell
Commands
Path-Name Expansion
The Perl Utility
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Cisco Unified CallManager Clustering and Deployment Options
Configuring User Features, Part 1
Multilevel Precedence and Preemption
Threats Targeting Remote Administration
PKI Enrollment
Introduction to 80x86 Assembly Language and Computer Architecture
Representing Data in a Computer
Basic Instructions
Decimal Arithmetic
Input/Output
Appendix B Useful MS-DOS Commands
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 4. Get the Birds-Eye View
Hack 20. Track Official Storm Reporting
Hacks 5161: Introduction
Hack 51. Make a Fullscreen Map the Right Way
Hack 69. Cluster Markers at High Zoom Levels
Ruby Cookbook (Cookbooks (OReilly))
Sorting an Array
Overloading Methods
Defining a Virtual Attribute
Converting One Image Format to Another
Refactoring the View into Partial Snippets of Views
VBScript in a Nutshell, 2nd Edition
Introduction
VBScripts History and Uses
Program Flow
Appendix A. Language Elements by Category
Appendix C. Operators
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