Using User-defined Functions and Aggregates to Speed Up Your Data Warehouse Processing

Brian Miezejewski (MySQL), Mark Atwood (Network.com at Sun Microsystems)
3:05pm Wednesday, 04/16/2008
Architecture and Technology, Data Warehousing and Business Intelligence, Performance Tuning and Benchmarks
 Location: Ballroom C

MySQL has had both User Defined Functions and User Defined Aggregates for a long time. Both can be used to create complex data manipulation tools that can process the large scale data normally associated with a data warehouse much faster than almost all other techniques. Learn how to use User Defined Functions and Aggregates to quickly perform complex functions on large sets of data and to turn complex multijoin queries that itinerarize networks or traverse trees into a single 1 table scan. The program includes a short overview on creating a UDF or a UDA and then runs through several examples using real User Defined Functions and Aggregates to solve real-world problems in a high-performance Data Warehouse environment.

People planning to attend this session also want to see:

Brian Miezejewski

MySQL

Brian Miezejewski is a Principal consultant for MySQL with over 25 years of database and software development experience. His experience includes Director of Data Architecture & Systems at travelweb.com and Senior Principal Architect for the American Airlines Enterprise data warehouse. He has led the development of multiple data warehouses over 4TB in size.

Photo of Mark Atwood

Mark Atwood

Network.com at Sun Microsystems

Mark Atwood is an employee of Network.com at Sun Microsystems, where he works on Drizzle and other cloud computing technologies. He was formerly a member of MySQL Professional Services, specializing in custom server hacks. He is a coauthor of the OAuth Core specification. He has been involved in projects to build large self-configuring internet networks, including a widely deployed net-connected CATV consumer appliance, a PSTN internet application, and a Mil-Spec decision support intel application. He lives in Seattle.

Sponsors
  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com.

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for more information on trade opportunities with O'Reilly conferences, or contact mediapartners@oreilly.com.

Press and Media

For media-related inquiries, contact confpr@oreilly.com.

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.