mostraligabue
» » Dimensional Data Warehousing with MySQL: A Tutorial

ePub Dimensional Data Warehousing with MySQL: A Tutorial download

by Djoni Darmawikarta

ePub Dimensional Data Warehousing with MySQL: A Tutorial download
Author:
Djoni Darmawikarta
ISBN13:
978-0975212820
ISBN:
0975212826
Language:
Publisher:
BrainySoftware (April 1, 2007)
Category:
Subcategory:
Databases & Big Data
ePub file:
1494 kb
Fb2 file:
1502 kb
Other formats:
lit doc rtf mobi
Rating:
4.3
Votes:
375

Data warehousing with MySQL, a free and popular database, has never been made easier with this step-by-step tutorial . This book is a very hands on no-nonsense introduction to Data Warehousing.

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. 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. Topicsinclude 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 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.

Computer programmers who need to build a data warehouse will find relevant examples and information written in a thorough, easy-to-follow style in this step-by-step tutorial. Download (chm, . 6 Mb). Epub FB2 PDF mobi txt RTF.

Year: 2004 Pages: 149. Authors: Djoni Darmawikarta. The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin. Successful Business Intelligence: Secrets to Making BI a Killer App. Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems). High-Speed Signal Propagation Advanced Black Magic. Signal Propagation Model. Topics include star-schema modeling, populating (Extract, Transform, and Load: ETL), testing, and dimensional querying. Computer programmers who need to build a data warehouse will find relevant examples and information written in a thorough, easy-to-follow style.

Home Djoni Darmawikarta Dimensional Data Warehousing with MySQL: A Tutorial. Dimensional Data Warehousing with MySQL: A Tutorial. Djoni Darmawikarta built his career at IBM and currently works for a Canadian insurance company as a technical specialist in its data intelligence team. He lives in Toronto, Ontario. I will do my best to address your concerns including 100% refund of your money.

Finding books BookSee BookSee - Download books for free.

Djoni Darmawikarta is an expert in data warehousing and business intelligence He is the author of "Dimensional Data Warehousing with MySQL: A Tutorial.

Djoni Darmawikarta is an expert in data warehousing and business intelligence. He worked for IBM for 17 years as a systems engineer, a consultant, and a customer support manager before joining a Toronto-based insurance company as a senior data analyst. He is the author of "Dimensional Data Warehousing with MySQL: A Tutorial. Learn about new offers and get more deals by joining our newsletter.

SQL for MySQL : a beginner's tutorial, by: Darmawikarta, Djoni, Published: (2014). Data mining and warehousing by: Prabhu, S. Published: (2007). Data model patterns a metadata map, by: Hay, David . 1947- Published: (2006).

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.
  • 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!

  • 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.

  • 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!