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.
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.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
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 O'Reilly MySQL Conference newsletter (login required).
View a complete list of O'Reilly MySQL Conference contacts.