Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho Corp.) Slides are at http://forge.mysql.com/wiki/Starring_Sakila_-_A_Data_Warehouse_Mini-Tutorial From the official conference description at http://www.mysqlconf.com/mysql2009/public/schedule/detail/7016 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,  []

Presented at the 2009 MySQL Camp: Grand Tour of the Information Schema and its Applications by Roland Bouman Description: The following topics will be covered: - Introduction of the information schema and its components - How to generate WIKI documentation from the information schema - Generating code (triggers, SPs) to maintain a rich history database - Creating a stored procedure to check violated foreign key constraints - Creating a stored procedure to create federated tables