PARALLELIZING SQL USER DEFINED TRANSFORMATION FUNCTIONS

摘要

Example embodiments relate to parallelizing structured query language (SQL) user defined transformation functions. In example embodiments, a subquery of a query is received from a query engine, where each of the subqueries is associated with a distinct magic number in a magic table. A user defined transformation function that includes local, role-based functionality may then be executed, where the magic number triggers parallel execution of the user defined transformation function. At this stage, the results of the user defined transformation function are sent to the query engine, where the query engine unions the results with other results that are obtained from the other database nodes.

主权项

1. A database node for parallelizing structured query language (SQL) user defined transformation functions, the system comprising:
a storage device comprising a magic table that comprises a magic number, wherein the magic number is associated with the database node; a processor to:
receive a subquery of a plurality of subqueries from a query engine, wherein each of the plurality of subqueries is associated with one of a plurality of distinct magic numbers in the magic table;execute a user defined transformation function that comprises local, role-based functionality, wherein the magic number triggers parallel execution of the user defined transformation function; andsend results of the user defined transformation function to the query engine, wherein the query engine unions the results with other results that are obtained from a plurality of database nodes.