Dimensional Data Warehousing with MySQL: A Tutorial

Product Description

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.

Product Details

* Amazon Sales Rank: #449985 in Books
* Published on: 2007-04-01
* Original language: English
* Number of items: 1
* Binding: Paperback
* 448 pages

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.
Customer Reviews

One dimensional and disappointing2
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!

Best practical introduction to Data Warehousing if you're using MySQL5
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!

A lucid Introduction to data warehousing4
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.