Tutorial 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 TrackBack 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.