Dimensional data warehousing with MySQL : a tutorial / Djoni Darmawikarta.

Format:

Book

Author/Creator:

Darmawikarta, Djoni, author.

Language:

English

Subjects (All):

MySQL (Electronic resource).

Data warehousing.

Physical Description:

1 online resource (431 p.)

Edition:

First edition.

Place of Publication:

[Montreal, CAN] : Brainy Software Corp., 2007.

Language Note:

English

Summary:

Data warehousing with MySQL, a free and popular database, has never been made easier with this step-by-step tutorial on building dimensional data warehouses. Topics include star-schema modeling, populating (Extract, Transform, and Load: ETL), testing, and dimensional querying. It comes complete with a hands-on case-- scaled-down from a real project-- as well as an electronic copy of all MySQL scripts and sample data available for download. Computer programmers who need to build a data warehouse will find relevant examples and information written in a thorough, easy-to-follow style.

Contents:

Intro

Table of Contents

Introduction

Part I Fundamentals

Chapter 1 Basic Components

Chapter 2 Dimension History

Chapter 3 Measure Additivity

Chapter 4 Dimensional Queries

Part II Extract, Transform, and Load

Chapter 5 Source Extraction

Chapter 6 Populating the Date Dimension

Chapter 7 Initial Population

Chapter 8 Regular Population

Chapter 9 Regular Population Scheduling

Part III Growth

Chapter 10 Adding Columns

Chapter 11 On-Demand Population

Chapter 12 Subset Dimensions

Chapter 13 Dimension Role Playing

Chapter 14 Snapshots

Chapter 15 Dimension Hierarchies

Chapter 16 Multi-Path and Ragged Heirarchies

Chapter 17 Degenerate Dimensions

Chapter 18 Junk Dimensions

Chapter 19 Multi-Star Schemas

Part IV Advanced Techniques

Chapter 20 Non-straight Sources

Chapter 21 Factless Facts

Chapter 22 Late Arrival Facts

Chapter 23 Dimension Consolidation

Chatper 24 Accumulated Measures

Chapter 25 Band Dimensions

Appendix A Flat File Data Sources

Index.

Notes:

Includes index.

Description based on online resource; title from PDF title page (ebrary, viewed June 25, 2014).

OCLC:

243599833