Why, What, and How of Data Warehouses for MySQL

Best Practices for Businesses
4 December 11:30 - 12:20 @ Sentosa 5-8

Integrating MySQL's reliable transaction processing with a capable data warehouse is a best practice that gives users timely and comprehensive insight into business data. In this talk we will explain how data warehouses work and why you need one. We will next survey the classes of data warehouse products that you can combine with MySQL, such as Oracle, Vertica, InfiniDB, Hadoop, and NoSQL databases like MongoDB. Finally, we will show a practical example of how to deliver transactions from MySQL to a data warehouse in real-time using Tungsten Replicator. Implementation highlights include provisioning the data warehouse, filtering and transforming data during loading, and handling mundane but critical issues like timezones and character sets. You will leave the talk equipped with a practical toolset to select a data warehouse and begin moving in data from MySQL.

Speakers

Robert Hodges
CEO, Continuent
Speaker Biography: 
Robert has over 30 years of experience in database and application engineering. Prior to Continuent, he worked on object-relational databases and transaction processing at Sybase. He also held senior engineering positions at Portera and Exigen Group, where he designed and operated software-as-a-service applications. Robert is the original designer of Continuent's Tungsten solution.


Slides