Successful and Cost Effective Data Warehouse... The MySQL Way

Ivan Zoratti (SkySQL)
Average rating: ***..
(3.00, 2 ratings)

MySQL is becoming more and more popular as a database for data warehouse and business intelligence solutions, where big hardware and expensive commercial database have dominated the scene so far.

The use of MySQL in a data warehouse environment is in some way a collision of four worlds placed in two parallel universes. In one universe, Data Architects and DBAs know how to model and manage large multidimensional DBs, they know how tune queries when they can parallelize them or when they can manage a large amount of caching against large Storage Area Networks. In another universe, Developers and DBAs are used to query and manage lots of small boxes running MySQL against their web applications, looking for the simplest queries and smallest results. When OLAP architects try to use MySQL and Web Developers build a multidimensional DB, the results are often far from what is expected.

With a correct implementation, MySQL can be used to power very large and complex OLAP DBs, at a fraction of the cost of a commercial solution.

The objective of this presentation is to give some technical tips and insight hints on how to use MySQL for data warehouse solutions. We will present real examples on:
- How to model a multidimensional DB for MySQL, diverging from the classic Kimball’s methodology;
- How to efficiently use storage engines, caches and indexes available for MySQL for OLAP solutions, compared to what is available for other RDBMSs;
- How to query distributed DBs, combining the sharding approach with a multidimensional modelling.

We will also provide basic benchmarks to compare the various options available for MySQL.

Photo of Ivan Zoratti

Ivan Zoratti

SkySQL

With 25 years of experience in computer science and in the IT industry, Ivan has developed projects and published literature on fast communication between heterogeneous computer systems since the early 80s. Ivan started his career in IT in 1986 at Digital Equipment Corporation, following his self experience with the kernel of the PdP 11 machines. Since 1987, he has been involved in large projects with DEC RDB, Informix, Oracle, SQLServer and later with MySQL. He has worked on data warehouse and BI projects since the early 90s. In 1997, Ivan joined MicroStrategy as Director of Professional Services and Advanced Solutions in Europe, where he has been directly involved in the architecture and development of some of the largest DW on the planet. He joined MySQL in 2005 and he is now responsible of the European Presales team for the Software Infrastructure Group at Sun Europe.

Comments on this page are now closed.

Comments

Picture of Sheeri K. Cabral
Sheeri K. Cabral
04/16/2010 9:26am PDT

Video for this session is online at www.youtube.com/watch?v=zdS...

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo 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@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.