Session The Open Source Data Warehouse Roger Magoulas Track: LAMP Date: Thursday, April 21 Time: 10:30am - 11:15am Location: Ballroom F TrackBack Commodity hardware, faster disks, and open source software now make building a data warehouse more of a resource and design issue than a cost issue for many organizations. Now a robust analysis infrastructure can be built on an open source platform with no performance or functional compromises. This talk covers a proven analysis architecture, the open source tool options for each architecture component, the basics of dimensional modeling, and a few tricks of the trade. It provides the basic architecture, toolkit, design principles, and strategy for building an effective open source data warehouse. Why open source? Aside from the cost savings, open source lets you leverage what your staff already knows--tools like Perl, MySQL, and Apache--rather than having to procure and staff for the proprietary tools that dominate the commercial space. Specific topics include: Data Warehouse Architecture: Consolidated Data Store (CDS) Process to condition, correlate and transform data Multi-topic data marts dimensional models Multi-channel data access Open Source Components Database: MySQL fast, effective Data Movement: Perl/DBI/SQL flexible data access Data Access: Perl/Apache/SQL template toolkit for ad hoc SQL Perl hash for crosstabs/pivot Perl for reports Graphing tools Dimensional Model organizes data for analysis Performance Considerations configuration indexing SQL-92 joins aggregate tables and aggregate navigation Download presentation file

Diamond Sponsor

Platinum Sponsors

Gold Sponsors

Silver Sponsors

Media Sponsors

MySQL User Conference Sponsor Opportunities — Reach business leaders and technology influencers at the MySQL User Conference. Download Exhibitor and Sponsor Prospectus. Call Andrew Calvo at 707-829-0515 or email at

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Media Center — Press releases, news, and information for the press.

Conference News