Pragma facility and SQL3 extension for optimal parallel UDF execution
AssigneeNCR Corporation
InventorFelipe Carino, Jr.
Life of this patent
Estimating the term…
Abstract
A method, apparatus, and article of manufacture for a computer implemented query optimizer. A query is to be executed containing user defined functions and abstract data type parameters to retrieve data from a database. Optimization information is received from a user. Then, the execution of the query is optimized based on the received optimization information for execution within a massively parallel, shared nothing architecture.
Claims15
A method of executing a query comprising user defined functions and abstract data type parameters in a computer to retrieve data from a database, the method comprising the steps of:
- receiving optimization information from a user;
- and
- optimizing the execution of the query based on the received optimization information for execution within a massively parallel, shared nothing architecture,
- wherein the optimization information specifies that it is safe to update in place.
A method of executing a query comprising user defined functions and abstract data type parameters in a computer to retrieve data from a database, the method comprising the steps of:
- receiving optimization information from a user;
- and
- optimizing the execution of the query based on the received optimization information for execution within a massively parallel, shared nothing architecture,
- wherein the optimization information specifies that a user-defined function is to be executed in a first pass of a two-pass execution.
A method of executing a query comprising user defined functions and abstract data type parameters in a computer to retrieve data from a database, the method comprising the steps of:
- receiving optimization information from a user;
- and
- optimizing the execution of the query based on the received optimization information for execution within a massively parallel, shared nothing architecture,
- wherein the optimization information specifies that a user-defined function is to be executed in a second pass of a two-pass execution.
A method of executing a query comprising user defined functions and abstract data type parameters in a computer to retrieve data from a database, the method comprising the steps of:
- receiving optimization information from a user;
- and
- optimizing the execution of the query based on the received optimization information for execution within a massively parallel, shared nothing architecture,
- wherein the optimization information specifies at least one pass of a two-pass execution in which to retrieve an object.
An apparatus for executing a query comprising user defined functions and abstract data type parameters, comprising:
- a computer having a data storage device connected thereto, wherein the data storage device stores a database;
- and
- one or more computer programs, performed by the computer, for receiving optimization information from a user and for optimizing the execution of the query based on the received optimization information,
- wherein the optimization information specifies that it is safe to update in place.
An apparatus for executing a query comprising user defined functions and abstract data type parameters, comprising:
- a computer having a data storage device connected thereto, wherein the data storage device stores a database;
- and
- one or more computer programs, performed by the computer, for receiving optimization information from a user and for optimizing the execution of the query based on the received optimization information
- wherein the optimization information specifies that a user-defined function is to be executed in a first pass of a two-pass execution.
An apparatus for executing a query comprising user defined functions and abstract data type parameters, comprising:
- a computer having a data storage device connected thereto, wherein the data storage device stores a database;
- and
- one or more computer programs, performed by the computer, for receiving optimization information from a user and for optimizing the execution of the query based on the received optimization information
- wherein the optimization information specifies that a user-defined function is to be executed in a second pass of a two-pass execution.
An apparatus for executing a query comprising user defined functions and abstract data type parameters, comprising:
- a computer having a data storage device connected thereto, wherein the data storage device stores a database;
- and
- one or more computer programs, performed by the computer, for receiving optimization information from a user and for optimizing the execution of the query based on the received optimization information,
- wherein the optimization information specifies at least one pass of a two-pass execution in which to retrieve an object.
An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query comprising a user defined function, the query being performed by the computer to retrieve data from a database stored in a data storage device connected to the computer, the method comprising the steps of:
- receiving optimization information from a user;
- and
- optimizing the execution of the query based on the received optimization information,
- wherein the optimization information specifies that it is safe to update in place.
An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query comprising a user defined function, the query being performed by the computer to retrieve data from a database stored in a data storage device connected to the computer, the method comprising the steps of:
- receiving optimization information from a user;
- and
- optimizing the execution of the query based on the received optimization information,
- wherein the optimization information specifies that a user-defined function is to be executed in a first pass of a two-pass execution.
An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query comprising a user defined function, the query being performed by the computer to retrieve data from a database stored in a data storage device connected to the computer, the method comprising the steps of:
- receiving optimization information from a user;
- and
- optimizing the execution of the query based on the received optimization information,
- wherein the optimization information specifies that a user-defined function is to be executed in a second pass of a two-pass execution.
An article of manufacture comprising a computer program carrier readable by a computer and embodying one or more instructions executable by the computer to perform method steps for executing a query comprising a user defined function, the query being performed by the computer to retrieve data from a database stored in a data storage device connected to the computer, the method comprising the steps of:
- receiving optimization information from a user;
- and
- optimizing the execution of the query based on the received optimization information,
- wherein the optimization information specifies at least one pass of a two-pass execution in which to retrieve an object.
Dependencies are inferred from the claim text.