Building Scalable & High Performance Datamarts with MySQL

Tangirala Sarma (DW/BI Architect)
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.

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.

Sponsors
  • 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.