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

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.

Brian Miezejewski


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 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

Hewlett Packard Enterprise

Mark Atwood is a long time participant in the open source community, and is a regular conference speaker. He is the Director of Open Source Engagement at Hewlett Packard Enterprise. His technology interests include software infrastructure and tooling, open source databases, and hackerspaces. He makes his home in the green city of Seattle.

  • 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

Contact Us

View a complete list of MySQL contacts.