SOLD OUT Data Warehousing with MySQL and OSS Tools
John Paul Ashenfelter, CTO, TransitionPoint
Date: Tuesday, July 27
Time: 8:45am - 12:15pm
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 warehousingDesigning 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 specificstables, datatypes, and functions
new in MySQL 5.0...
Other OSS toolsDatabases: 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.
© 2004, O'Reilly Media, Inc.