Schedule: Data Warehousing and Business Intelligence sessions

Location: Ballroom E Level: Novice
David Lutz (Infobright)
Average rating: ***..
(3.40, 5 ratings)
This tutorial focuses on how to design and build a data warehouse, with emphasis on common pitfalls encountered by implementers and how to avoid them. We’ll spend some time discussing why Data Marts are different from transactional solutions and how to think differently when designing and implementing a Data Mart or Data Warehouse, along with real life examples using Open Source technologies. Read more.
Location: Ballroom B Level: Novice
Michael G. Zinner (Sun Microsystems), Max Mether (MySQL), Mike Hillyer (Message Systems)
Regardless if you are a newbie to the MySQL database or you have been using MySQL for years already - this is your chance to learn professional database schema design from the MySQL experts. Get fluent on the basic modeling concepts, learn all about the performance tricks and become a pro in using MySQL Workbench, making database design and maintenance most efficient. Reserve your seat now! Read more.
Location: Ballroom E Level: Intermediate
Christophe Bisciglia (Cloudera, Inc), Aaron Kimball (Cloudera, Inc.)
Average rating: ****.
(4.50, 4 ratings)
Recently, there has been a lot of buzz around MapReduce, and the Apache Hadoop project. Even more recently, we have seen proprietary SQL database systems add support for MapReduce. This is great for data, but lacks advantages of open source. In this tutorial, we will provide both background knowledge and the practical experience necessary to combine these models to get more out of your data. Read more.
Location: Ballroom F Level: Intermediate
Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho)
Average rating: ****.
(4.00, 2 ratings)
Lately there's been a lot of talk about MySQL-based business intelligence and datawarehousing. But what does it all really mean? What's behind the BI/OLAP/ETL alphabet soup, and what in heavens name are star schemas, facts and dimensions? Using the Sakila sample database as material, this session will explain what data warehouses are, what problems they solve, and how they are designed and built. Read more.
Location: Ballroom A Level: Intermediate
Osma Ahvenlampi (Sulake)
Average rating: ****.
(4.00, 2 ratings)
Habbo, the world's leading virtual world for teens, has been running on MySQL ever since year 2000 and serves millions of users each month. It's global operation and continued product development depend on timely analysis of masses of data, a challenge we solved using Infobright's Brighthouse DWH engine. I'll tell you why and how we did that. Read more.
Location: Ballroom D Level: Intermediate
Michael McFadden (
Average rating: ****.
(4.00, 2 ratings)
Any application with frequent polling and extensive archiving needs has run into the situation of ‘too much data’. Tables become huge and unsearchable, performance goes down, and over time the cost to store this data adds up. This session covers data smoothing techniques including SQL query side solutions that reduce resolution for data archival storage for more efficient application performance. Read more.
Location: Ballroom D Level: Intermediate
Matt Casters (Pentaho)
Average rating: ***..
(3.00, 1 rating)
This presentation explores what cloud computing means beyond being a buzz-word and touches upon the various scenarios where MySQL and Pentaho Data Integration (Kettle) can be deployed on a large number of hosts to process data in parallel. Read more.
Location: Ballroom G Level: Intermediate
Vidur Apparao (LiveOps, Inc.), Stephen O'Sullivan (LiveOps, Inc.)
Average rating: ****.
(4.00, 2 ratings)
A case study of the evolution of MySQL usage, as a company moved from a scrappy startup - with the goals of finding a cheap, quick, and simple database solution - to a mature enterprise - with high availability and horizontal scalability as key requirements. Read more.
Location: Ballroom C Level: Novice
Christopher Lavigne (Breadboard BI, Inc.)
Based on a real-world case study from a comprehensive market intelligence product - developed for by Breadboard BI, Inc - this 45 minute presentation describes a multi-source, enterprise data warehouse developed on a 100% open source stack - MySQL 5.1 (with partitioning), Pentaho Business Intelligence Suite, Linux OS. Read more.

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.