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.