MySQL is increasingly being adopted for Business Intelligence (BI) and data warehousing (DWH) purposes. Although the technology as such is far from new, there is still quite noticeable confusion and misunderstanding among MySQL Developers and DBAs surrounding key BI/DWH concepts such as denormalization, dimensional modeling, ETL, and OLAP. Even if the concepts are clear, it is still not clear what the purpose is of a datawarehouse, and what problems it can solve.
The Sakila database is a simple, publicly available sample database of a DVD rental business, distributed by Sun (formerly MySQL AB). It is quite popular for illustrating traditional database schema design issues and SQL queries.
The sakila database makes for a great mini-tutorial on how to design, create, load and use a data warehouse. In 45 minutes, attendees can witness exactly how this is done, and how the result differs from the original sakila schema.
The following outline explains the structure of this talk in detail
I’m a Web Application and Business Intelligence developer and I authored two books about the Pentaho Open Source Business Intelligence stack: “Pentaho Solutions” (ISBN 978-0470484326) and “Pentaho Kettle Solutions (ISBN 978-0470635179). I’m an active member of the MySQL and Pentaho communities. In the past, I worked for Inter Access, MySQL AB, Sun Microsystems. I currently work for Strukton Rail.
I have been an independent BI consultant for many years and implemented numerous data warehouses and BI solutions for large companies. For the last 6 years I have been very busy writing an ETL tool called Kettle. This tool was open sourced in December 2005 and acquired by Pentaho Open Source BI early in 2006. As such I’m now Chief Data Integration for Pentaho mainly doing lead development for Kettle a.k.a. Pentaho Data Integration.
Comments on this page are now closed.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.