O'Reilly Open Source Convention
Books Safari Bookshelf Conferences O'Reilly Network

Arrow Home
Arrow Registration
Arrow Speakers
Arrow Keynotes
Arrow Tutorials
Arrow Sessions
Arrow At-a-Glance
Arrow Wiki
Arrow BOFs
Arrow Events
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Tips for
Arrow Press
Arrow Mail List



SOLD OUT Data Warehousing with MySQL and OSS Tools
John Paul Ashenfelter, CTO, TransitionPoint

Track: MySQL
Date: Tuesday, July 27
Time: 8:45am - 12:15pm
Location: Columbia


Building a datawarehouse is not rocket science, but it takes a different approach even for experienced database developers. This tutorial focuses on building data warehouses using MySQL. We're going to dig into why MySQL is a good choice for data warehousing, the basics of building an order-focused data warehouse, and the specifics of using MySQL data warehouses, particularly in the 10-100 GB range.

MySQL for Data Warehousing?

  • Why build a data warehouse?
  • Why use MySQL?
  • Can this really work?
  • Basics of data warehousing

  • Designing data warehouse tables and denormalization
  • Facts and dimensions, and using MySQL to build them
  • Building an order warehouse
  • Specifics of data extraction and transform using a real order system
  • MySQL specifics

  • tables, datatypes, and functions
  • new in MySQL 5.0...
  • performance considerations
  • Other OSS tools

  • Databases: Postgres, MaxDB
  • Java tools: JasperReports engine and OpenReports
  • PHP tools: rlib
  • We'll discuss other data warehouse issues as time and interest permit. By the end of the tutorial, you should have enough information to build a useful data warehouse using MySQL.

    O'Reilly Home | Privacy Policy

    © 2004, O'Reilly Media, Inc.