Building Scalable & High Performance Datamarts with MySQL

Data Warehousing and Business Intelligence, Tutorial
Location: Ballroom F Level: Intermediate
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.


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.

  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.