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 BOFs
Arrow Events
Arrow Community
 Software
Arrow Exhibitors
Arrow Sponsors
Arrow Hotel/Travel
Arrow Venue Map
Arrow See & Do
Arrow Press
Arrow Mail List


O'Reilly Open Source Convention
Hornbill.

Tutorial

SOLD OUT Building Data Warehouses with MySQL
John Paul Ashenfelter, TransitionPoint

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

Building a data warehouse is not rocket science, but it takes a different approach even for experienced database developers. This tutorial focuses on building data warehouses using MySQL, but the primary focus is on building the warehouse. The following will be covered:

Designing data warehouse tables

  • The value of DEnormalizing data warehouse tables
  • Facts and dimensions
  • Common dimensions and how to create them using MySQL

    Building an order warehouse

  • Production data for an order system
  • Facts and dimensions for an order system
  • Specifics of data extraction and transform using a real order system

    Getting data into MySQL

  • From Microsoft SQL
  • From Oracle
  • From other structured and unstructured sources

    MySQL specifics

  • Datatypes
  • Time and date functions
  • Performance

    Discuss other kinds of data warehouse tables as time and interest permit. By the end of the tutorial, you should have enough information to build a useful data warehouse in MySQL using your own data systems.



  • O'Reilly Home | Privacy Policy

    © 2003, O'Reilly Media, Inc.