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]

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.

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

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com.

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for more information on trade opportunities with O'Reilly conferences, or contact mediapartners@oreilly.com.

Press and Media

For media-related inquiries, contact confpr@oreilly.com.

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.