Building Scalable & High Performance Datamarts with MySQL

Tangirala Sarma (DW/BI Architect)

9:00am Monday, 04/14/2008

Data Warehousing and Business Intelligence, Tutorial
Location: Ballroom F

Presentation: Building Scalable _ High Performance Datamarts with MySQL Presentation [PDF]

Average rating:

(1.00, 1 rating)

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.

People planning to attend this session also want to see:

Tangirala Sarma

DW/BI Architect

Tangirala Sarma is a leading Business Intelligence and Data Warehousing specialist who combines understanding of information technology with extensive business understanding and information-based decision making methodologies. As a DW/BI practitioner, Tangirala helps enterprises identify, justify, implement and leverage leading edge technology environments to create and/or improve analytical capabilities. Tangirala has led implementation of several complex and scaleable multi terabyte data warehouses with companies in the financial services, telecommunications, retail, publishing and hospitality industries.

Sarma is an established writer and has authored several white papers on churn management, rapid migration technology and DW/BI technologies.