MySQL Users Conference 2006 “MySQL is at the heart of revolutionary changes in computer history.“—Tim O'Reilly
 Co-presented by O'Reilly Media, Inc. and MySQL AB
 Conference Coverage


Higher Order MySQL

Giuseppe Maxia, QA Developer, MySQL AB

Track: Performance Tuning and Benchmarks, Architecture and Technology
Date: Tuesday, April 25
Time: 5:20pm - 6:05pm
Location: Ballroom C

Higher order functions are those that can accept a function as an argument or can produce a function as their output. MySQL recent addition of stored procedures and dynamic querying makes it possible to extend the DBMS features, especially for business intelligence and data warehousing. Functions that can create functions are useful to expand the language, producing complex SQL code quickly and accurately.

Some examples of what can be achieved with these kind of functions:

  • global table CRC (as oposed to record CRC) for remote table comparison
  • cross tabulation (pivot tables in SQL)
  • data on demand from compressed storage (indexed, as opposed to non-indexed data stored by the archive engine)
  • enhanced metadata queries, where records from the information schema and records from data table create customized administrative tools.

The applications are countless. The power of stored procedures, paired with dynamic queries, can give developers the ability of doubling the features of MySQL DBMS. Higher order functions and procedures are one step beyond normal stored procedures. They give developers one template to create standardized functions for similar tasks. While the basics of such discipline are better exploited in application languages (C, C++, Perl come to mind), dynamic SQL is perfectly capable of achieving important goals.

Diamond Sponsor

Business Objects
Hewlett Packard

Platinum Sponsors

Four J's Development Tools, Inc
GoldenGate Software, Inc.

Gold Sponsors

Actuate Corporation
Data Direct Technologies
Dell Inc.
Dolphin Interconnect Solutions
Embarcadero Technologies
EMC Centera
Lumen Software
Novell, Inc.
Rackspace Managed Hosting
Red Hat
Sun Microsystems
The SCO Group
Zmanda, Inc.

Media Sponsors

Conference Guru
Database Trends and Applications
DevtownStation News
IPTV Industry
Linux Journal
Methods and Tools newsletter
Sys Admin magazine
The ServerSide
The Women's Technology Cluster
Web Host Industry Review
WiMAX Industry

In-Kind Sponsors

Griffin Technology

Sponsor Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact us at

Download the MySQL Users Conference Sponsor/Exhibitor Prospectus

Conference News

To stay abreast of conference news and to receive email notification when registration opens, please sign up here.

Press and Media

For media-related inquiries, contact Suzanne Axtell at

Copyright MySQL AB and O'Reilly Media, Inc.
MySQL O'Reilly