Designing Scalable Data Warehouse With MySQL

Presentation: external link
Average rating: *....
(1.00, 1 rating)
  • Introduction to Data Warehouse and its major components
  • Designing high performance OLTP system, production server
  • Designing staging server to store dimension, fact and aggregate tables
  • Design and add ETL layer to generate dimension, fact and aggregate tables
  • Loading of dimension, fact and aggregation tables to production from staging
  • Scheduling of ETL and real-time handling
  • Generating low latency reporting using cubes and MDX
  • How to scale-out the OLAP architecture
Photo of Venu Anuganti

Venu Anuganti


Venu Anuganti is a ex MySQL Kernel Developer located in Sunnyvale, CA, USA. Currently working as Data Architect to design and implement high performance large scale data store solutions for both OLTP and OLAP (Date warehouse + Analytics)

Comments on this page are now closed.


Bob Wall
04/15/2011 6:41am PDT

Not really much about how to do DW with MySQL, other than to not do them with MySQL. The discussion of the staging servers was not very clear.

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Media Partners Opportunities

For media partnerships, contact mediapartners@

Press & Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts