O'Reilly Open Source Software Convention 2003

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

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