Back to results
US 8,712,972 B2Granted
Query optimization with awareness of limited resource usage
AssigneeSybase, Inc.
InventorsPrateem Mandal, Edwin Anthony Seputis
Life of this patent
Estimating the term…
Loading patent…
Loading patent…
AssigneeSybase, Inc.
InventorsPrateem Mandal, Edwin Anthony Seputis
Estimating the term…
System, method, computer program product embodiments and combinations and sub-combinations thereof for tuning query execution performance in a database management system are described. In an aspect, query optimization in a database management system (DBMS) with awareness of limited resource usage includes identifying limited resource usage for each possible plan being considered for query execution by a query engine. A determination of whether any possible plan has limited resource usage that does not exceed a threshold level is made, and when at least one possible plan does not exceed the threshold level, the identified limited resource usage is included as a consideration during plan selection by the query engine. In an embodiment, temporary database usage is identified for each possible plan.
A computer-implemented method for query optimization with awareness of limited resource usage, the method comprising:
A system for query optimization with awareness of limited resource usage, the system comprising:
A computer program product including a non-transitory computer-readable storage medium having instructions stored thereon that, if executed by one or more processors, cause said processors to perform operations comprising:
Dependencies are inferred from the claim text.
Drawings are temporarily unavailable. Open the PDF at USPTO
From the US filing history. Foreign family members aren’t listed.
Query rewriting; Transformation: plan optimisation
Computing and data processing
About 4 years 5 months of term left · ends 3 Apr 2031 (estimated)
1. Field of the Invention
The present invention is directed to tuning query execution performance of a database system through query optimization with awareness of temporary database usage.
2. Background Art
The accompanying drawings, which are incorporated herein and form part of the specification, illustrate embodiments of the present invention and, together with the description, further serve to explain the principles of the invention and to enable a person skilled in the relevant art(s) to make and use the invention.
FIG. 1 illustrates an exemplary database management system (DBMS), according to an embodiment of the invention.
FIG. 2a depicts a block flow diagram of query optimization with awareness of limited resource usage in accordance with an embodiment of the invention.
The features and advantages of the present invention will become more apparent from the detailed description set forth below when taken in conjunction with the drawings. In the drawings, like reference numbers generally indicate identical, functionally similar, and/or structurally similar elements. Generally, the drawing in which an element first appears is indicated by the leftmost digit(s) in the corresponding reference number.
The present invention relates to a system, method, computer program product embodiments and combinations and sub-combinations thereof for tuning query execution performance of a database system.
While the present invention is described herein with reference to illustrative embodiments for particular applications, it should be understood that the invention is not limited thereto. Those skilled in the art with access to the teachings provided herein will recognize additional modifications, applications, and embodiments within the scope thereof and additional fields in which the invention would be of significant utility.