Dimensional Data Warehousing with MySQL: A Tutorial [Paperback]

Djoni Darmawikarta (Author)

Book Description

Publication Date: April 1, 2007

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.

Editorial Reviews

About the Author

Djoni Darmawikarta built his career at IBM and currently works for a Canadian insurance company as a technical specialist in its data warehousing/business intelligence team. He lives in Toronto, Ontario.

Product Details

• Paperback: 448 pages
• Publisher: BrainySoftware (April 1, 2007)
• Language: English
• ISBN-10: 0975212826
• ISBN-13: 978-0975212820
• Product Dimensions: 9 x 7.1 x 1 inches
• Shipping Weight: 1.7 pounds (View shipping rates and policies)
• Average Customer Review: 3.7 out of 5 stars  See all reviews (3 customer reviews)
• Amazon Best Sellers Rank: #1,601,639 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

6 of 6 people found the following review helpful:

5.0 out of 5 stars Best practical introduction to Data Warehousing if you're using MySQL, July 30, 2008

By 

trevo2020 (Sunnyvale, CA) - See all my reviews

Amazon Verified Purchase

This review is from: Dimensional Data Warehousing with MySQL: A Tutorial (Paperback)

I had skimmed through the authoritative Toolkit books and found them very verbose. This book is a very hands on no-nonsense introduction to Data Warehousing.

One of the thngs that this book provided that I haven't seen in any other DW books I've come across is actual MySQL scripts used to demonstrate each lesson. If you have read a few Data Warehousing books, you'd read that the ETL (Data loading) part is the most complex piece and most books won't go into detail how its done. This book provides detailed scripts on how one goes about getting data from a production database into the Data Warehouse. I think this alone is worth the price of the book!

I come from the OLTP side of the business having written many J2EE apps for e-commerce, content systems and enterprise intergration projects. My 15+ years of experience made me ill prepared for a BI project - I didn't have a clue what a "star schema" meant.

The chapters of this book are very easy to follow and in no time I totally understood the principles and practices behind OLAP, and felt comfortable enough to set up a very simple Data Warehouse.

I'm surprised this book isn't more well known as I can't recommend it enough!

3 of 3 people found the following review helpful:

4.0 out of 5 stars A lucid Introduction to data warehousing, September 28, 2007

By 

Richard "Hillbilly" (Wichita, KS USA) - See all my reviews
(REAL NAME)   

This review is from: Dimensional Data Warehousing with MySQL: A Tutorial (Paperback)

I'm new to MySQL and this was my first book on the subject. The author has done a great job of writing for a specific skillset and not wasting our time with alot of fundamentals or too advanced stuff. I'm somewhat learning challenged and found the organization of the material to aid greatly in my grasp of the subject.

3 of 6 people found the following review helpful:

2.0 out of 5 stars One dimensional and disappointing, January 30, 2009

By 

Sam Tregar (Ossining, New York) - See all my reviews
(REAL NAME)   

This review is from: Dimensional Data Warehousing with MySQL: A Tutorial (Paperback)

I found this book very disappointing. This book contains just one kind of information - simple MySQL implementation descriptions for standard data-warehouse structures. There's no discussion of what data-warehousing is, why you would do it or why a particular structure is better or worse than another.

I can only imagine that this book would be useful if you happened to be a data-warehouse expert with a very poor grasp of basic MySQL usage. It's hard to imagine anyone with even a small amount of MySQL experience finding this book useful.

And just a final note, the book's example are focused on using MySQL on Windows XP. Who in their right mind would build a data warehouse on MySQL running on Windows XP? The section on setting up a scheduled job using Windows XP's scheduled task wizard is hilarious!