MySQL is becoming more and more popular as a database for data warehousing and business intelligence solutions, where big hardware and expensive commercial database have dominated the scene so far. The constant search for a lower TCO has forced many organisation to look at cheaper alternatives to the traditional commercial databases – Oracle, Sybase and SQLServer. MySQL is indeed the hottest alternative to commercial databases for data warehousing solutions.
Due to the ease of use and to the pluggable storage architecture, MySQL can provide an effective and inexpensive solution in Business Intelligence. It is true that MySQL Server is still missing some of the key elements of data warehousing, such as bitmap indexes, parallel queries and a more sophisticated optimizer. On the other hand, MySQL can be a perfect data mart, or it can be used with a columnar engine to improve performance and reduce the administration tasks.
In order to create a successful data warehouse with MySQL, users need to think differently. The standard MySQL approach, commonly used for online applications, does not work. Thinking big hardware and very complex queries does not work either. This session will introduce the correct implementation of MySQL server for a data warehouse project.
We will present the hottest technologies around MySQL in Data Warehousing, we will compare and review how they work and they can be used.
At the end of the presentation, users should have a better understanding of the various alternatives available with MySQL, in order to invest their time and efforts on the most suitable technology for their needs.
Ivan has worked in the IT industry for 25 years covering different roles, such as CTO and Chief Architect, and establishing various companies in Europe.
Ivan has joined MySQL in 2005 as Sales Engineer and he is now responsible for the Field Services team in Europe at SkySQL.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media partnerships, contact mediapartners@ oreilly.com
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 Bulletin (login required).
View a complete list of O'Reilly MySQL Conference Contacts