Method and system for estimating per query resource consumption
OwnerVibhuti Singh Sengarinventor
Life of this patent
Estimating the term…
Abstract
There is disclosed a method for estimating query resource consumption for a system storing a representative query resource consumption table. When a query is received, information of a representative query including representative resource consumption information is retrieved from the representative query resource consumption table, where a type of representative query is determined according to the received query. A resource consumption ratio of the received query and the representative query is calculated (computed), and a query resource consumption of the received query is estimated using the representative resource consumption and the calculated resource consumption ratio.
Claims20
A method for estimating query resource consumption for a system storing a representative query resource consumption table, the method comprising:
- receiving a query;
- retrieving information of a representative query including representative resource consumption information from said representative query resource consumption table, wherein a type of said representative query is determined according to said received query;
- calculating a resource consumption ratio of said received query and said representative query;
- and
- estimating a query resource consumption of said received query using the representative resource consumption and said calculated resource consumption ratio.
A query resource consumption estimation system for estimating resource consumption for executing a query, comprising:
- an interface for receiving a query for resource consumption estimation;
- a storage medium for storing a representative query resource consumption table including information of a plurality of representative queries each of a query plan with corresponding representative resource consumption information;
- and
- a processor for retrieving information of a representative query from said representative query resource consumption table wherein a type of said representative query is determined according to said received query, calculating a resource consumption ratio of said received query and said representative query, and estimating a query resource consumption of said received query using said representative resource consumption and said calculated resource consumption ratio.
A computer data signal operable to cause a computer to execute a process for estimating query resource consumption in an enterprise system using a representative query resource consumption table, the process comprising:
- receiving a query;
- retrieving information of a representative query including representative resource consumption information from said representative query resource consumption table, wherein a type of said representative query is determined according to said received query;
- calculating a resource consumption ratio of said received query and said representative query;
- and
- estimating a query resource consumption of said received query using the representative resource consumption and said calculated resource consumption ratio.
A computer program product having a computer readable medium having a computer program recorded therein for query resource consumption estimation program for a system having a storage medium for storing at a representative query resource consumption table, capable of performing a method comprising:
- receiving a query;
- retrieving information of a representative query including representative resource consumption information from said representative query resource consumption table, wherein a type of said representative query is determined according to said received query;
- calculating a resource consumption ratio of said received query and said representative query;
- and
- estimating a query resource consumption of said received query using the representative resource consumption and said calculated resource consumption ratio.
Dependencies are inferred from the claim text.