US6067542A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Pragma facility and SQL3 extension for optimal parallel UDF execution
Assignee: Teradata US Inc
•
Filing: 1997-09-30
•
Granted: 2000-05-23
•
Expires: 2017-09-30
Abstract
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.
Inventors
- 👤 Felipe Carino, Jr.
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-08 13:10
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2453; G06F16/24532; G06F16/24534; G06F16/24547; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943; Y10S707/99944; Y10S707/99945
Claims Analysis
Total Claims: 27
Claim 1
Independent Claim
71 words
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.
Claim 2
Independent Claim
71 words
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.
Claim 3
Dependent Claim
20 words
The method of claim 1 above, wherein the optimization information specifies whether data is to be streamed to a client.
Claim 4
Independent Claim
79 words
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.
Claim 5
Independent Claim
79 words
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.
Claim 6
Independent Claim
79 words
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.
Claim 7
Independent Claim
79 words
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.
Claim 8
Independent Claim
77 words
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.
Claim 9
Independent Claim
77 words
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.
Claim 10
Independent Claim
77 words
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.
Claim 11
Independent Claim
77 words
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.
Claim 12
Dependent Claim
19 words
The apparatus of claim 6, wherein the optimization information specifies whether data is to be streamed to a client.
Claim 13
Independent Claim
85 words
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.
Claim 14
Independent Claim
85 words
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.
Claim 15
Independent Claim
85 words
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.
Claim 16
Independent Claim
85 words
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.
Claim 17
Independent Claim
83 words
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.
Claim 18
Independent Claim
83 words
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.
Claim 19
Dependent Claim
97 words
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.
Claim 20
Dependent Claim
97 words
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.
Claim 21
Dependent Claim
19 words
The method of claim 11, wherein the optimization information specifies whether data is to be streamed to a client.
Claim 22
Dependent Claim
105 words
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.
Claim 23
Dependent Claim
105 words
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.
Claim 24
Dependent Claim
105 words
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.
Claim 25
Dependent Claim
105 words
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.
Claim 26
Dependent Claim
103 words
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.
Claim 27
Dependent Claim
103 words
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.
References Cited (Backward Citations)
US5325525A
Cited
US5504894A
Cited
US5845113A
Cited
US5857180A
Cited
US5799310A
Cited
US5850550A
Cited
US5873083A
Cited
US5754841A
Cited
US5794250A
Cited
US5930786A
Cited
US5864843A
Cited
US5765147A
Cited
US5806061A
Cited
US5873075A
Cited
US6006235A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-05-23 | 2003-11-22 | 2004-05-23 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-05-23 | 2007-11-22 | 2008-05-23 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-05-23 | 2011-11-22 | 2012-05-23 | $7700.00 | Window Closed / Lapsed |