Method and system for managing operation of a user-defined function on a partitioned database

A computer-implemented method for managing execution of a query against a partitioned database having a plurality of data partitions, comprising:

• receiving a query for execution against each of the plurality of data partitions, the query referencing a user-defined function comprising a plurality of conditional statements each being associated with one or more instructions defining operations to be performed on data returned in response to execution of the query;
• and wherein at least some of the plurality of data partitions are associated with different modified forms of the user-defined function, and each of the modified forms of the user-defined function containing a subset of the plurality of conditional statements, the subset being only those of the plurality of conditional statements for which data exists in the respective data partition;
• executing, by operation of one or more computer processors, the query against each of the plurality of data partitions;
• and for each execution of the query, returning a respective result set from each of the plurality of data partitions;
• and
• invoking the respective associated modified form of the user-defined function to execute on the respective result set returned from the respective data partition with which the user-defined function is associated, thereby producing a modified result set for each data partition.

A non-transitory computer-readable storage medium containing a program which, when executed by a computer processor, performs an operation for managing execution of a query against a partitioned database having a plurality of data partitions, the operation comprising:

• providing a user-defined function comprising a plurality of conditional statements each being associated with one or more instructions defining operations to be performed on data returned in response to execution of the query;
• for each of the plurality of data partitions:
• examining data of the data partition;
• and
• on the basis of examined data, implementing (i) a copy of the user-defined function on the data partition when data exists in the respective data partition for all of the plurality of conditional statements and (ii) a modified form of the user-defined function on the data partition when data exists in the respective data partition for only a subset of the plurality of conditional statements, wherein the modified form of the user-defined function contains only the subset of the plurality of conditional statements for which data exists in the respective data partition;
• and
• executing, by operation of one or more computer processors, the query referring to the user-defined function against the plurality of data partitions;
• wherein execution of the query on each data partition invokes execution of the respective user-defined function against the data returned in response to execution of the query against the respective data partition.