Back to results
US 10,762,084 B2Granted
Distribute execution of user-defined function
AssigneeMicro Focus LLC
InventorsVivek Bharathan, Charles Edward Bear, Nga Tran
Life of this patent
Estimating the term…
Abstract
A user-defined function (UDF) is received. Then, execution of the UDF is distributed into a plurality of phases. Lastly, each of the phases is executed separately on a relational database including an aggregate projection that stores an aggregate value calculated from a table column of a table using an aggregate function.
Claims20
A method, comprising:
- receiving a query request including a user-defined function (UDF);
- distributing, by a processor, execution of the UDF in the query request into a plurality of phases including a data load phase, a query phase, and a maintenance phase;
- and
- executing, by the processor, each of the plurality of phases separately on a relational database including an aggregate projection that stores an aggregate value calculated from a table column of a table using an aggregate function, wherein each of the plurality of phases applies a different transformation to data in the relational database.
1 more element
A system, comprising:
- an interface unit to parse a query to identify a user-defined function (UDF) in the query;
- a distribution unit to distribute execution of the UDF in the query into a plurality of phases including a data load phase, a query phase, and a maintenance phase;
- and
- an execution unit to execute each of the plurality of phases separately on a relational database that includes an aggregate projection that stores an aggregate value calculated from a table column of a table, wherein each of the plurality of phases applies a different transformation to data in the relational database.
1 more element
A non-transitory computer-readable storage medium storing instructions that, when executed by a processor of a device, cause the processor to:
- parse a query to identify a user-defined function in the query;
- distribute execution of the UDF in the query into a plurality of phases including a data load phase, a query phase, and a maintenance phase;
- and
- execute the query including the UDF in each of the plurality of phases separately on a relational database, wherein each of the plurality of phases applies a different transformation to data in the relational database.
1 more element
Dependencies are inferred from the claim text.