Building Scalable & High Performance Datamarts with MySQL

Data Warehousing and Business Intelligence is gaining mission critical status in managing today’s enterprise. Data warehouses have been around for a while but only now enterprises are seriously looking to open source options to build a scalable and reliable data warehouse/datamart. MySQL has gained significant ground in managing OLTP systems. But, it is now time to seriously consider MySQL for building data warehouses/datamarts. It is critical that these datamarts are built on good foundation.

This session focuses on design principles and techniques to build a solid foundation for datamarts using MySQL. We will cover the following topics:

• Data warehouse/Datamart fundamentals

• Dimensional modeling Techniques: Star vs. Snowflake

• Building datamarts for scalability, maintenability and performance

• Tips & Techniques

• Use of summary/aggregations in data warehouses

• MySQL features and functionality to support Data Warehouse/Datamarts

• Challenges: things to watch out for.