O'Reilly Open Source Convention - August 1-5, 2005 - Portland, Oregon
 Convention Coverage

Tutorial

Building Open Source Data Warehouses with MySQL and Open Source Tools
John Paul Ashenfelter, CTO, TransitionPoint

Track: Databases
Date: Monday, August 1st, 2005
Time: 1:30pm - 5:00pm
Location: Portland 253

Building a data warehouse is not rocket science, but it takes a different approach than traditional application development practices, even for experienced database developers. This tutorial focuses on building data warehouses using MySQL. We're going to dig into why MySQL specifically is a good choice for data warehousing, the basics of building an order-focused data warehouse, and the complementary open source tools for reporting and visualization. While there are MySQL databases in the terabyte range, we'll focus specficially on the 10-100 GB range.

Open source for data warehousing?
- Why build a data warehouse?
- Why use open source (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

Delivering the data warehouse
- open source reporting tools (particularly JasperReports)
- open source visualization tools
- delivery systems for data warehouse reports

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.



Diamond Sponsors

Computer Associates International Inc., (CA)
Hewlett Packard
SpikeSource
Sun Microsystems

Platinum Sponsors

Novell, Inc.

Gold Sponsors

ActiveState
IBM
Ticketmaster

Silver Sponsors

ActiveGrid
Alfresco
Black Duck Software
CollabNet
Covalent Technologies
Google
GroundWork Open Source Solutions
Intel Corporation
Mergere, Inc.
Microsoft
Oracle
Palamida
SourceLabs
SugarCRM
Yahoo! Inc.
Zend Technologies, Inc.

Media Sponsors

boing boing
C/C++ Users Journal
DevtownStation News
Digital ID World
Enterprise Open Source Journal
Free Software Magazine
InsideMac Radio
Integration Developer News
Linux Journal
LinuxQuestions.org
Open Enterprise Trends
Queue
SDForum
Software Association of Oregon
Version Tracker
Wi-Fi Technology Forum
Women's Technology Cluster
WorldWIT

In-Kind Sponsors

Dell Inc.
Gibson
Griffin Technology
Harman Multimedia
Smugmug

Sponsors

OSCON 2005 Sponsor Opportunities — Email us at

Download the OSCON 05 Sponsor/Exhibitor Prospectus

OSCON 2005 Media Sponsor Opportunities — Call Margi Levin at 707-827-7184 or email at

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Conference News

Want to receive conference news? Sign up for our email newsletter.

O'Reilly Home | Privacy Policy

© 2005, O'Reilly Media, Inc.