Estimating execution time for batch queries
AssigneeInternational Business Machines Corporation
InventorsXiaobo Wang, Shuo Li, Xiao Xiao Chen, Sheng Yan Sun
Life of this patent
Estimating the term…
Abstract
A computer-implemented method to estimate an execution time for large query batches. The method includes identifying a batch of queries, where the batch of queries where each query is configured to retrieve data from a database. Selecting a first query and generating an access path for the first query including one or more mini plans. Building a learning model for the one or more mini plans. Estimating an estimated execution time for each of the one or more mini plans. Adding each of the estimated execution times for each of the one or more mini plans to determine a first total estimated time for the first query. Displaying the first total estimated time.
Claims20
A computer-implemented method comprising:
- identifying a batch of queries, wherein the batch of queries includes a plurality of queries and each query of the plurality of queries is configured to retrieve data from a database;
- selecting a first query of the plurality of queries;
- generating an access path for the first query including one or more mini plans;
- building a learning model for the one or more mini plans;
- estimating, by the one or more mini plans, an estimated execution time for each of the one or more mini plans;
- adding each of the estimated execution times for each of the one or more mini plans to determine a first total estimated time for the first query;
- and
- displaying the first total estimated time;
- and
- executing the batch of queries.
A system comprising:
- a processor;
- and
- a computer-readable storage medium communicatively coupled to the processor and storing program instructions which, when executed by the processor, are configured to cause the processor to:
- identify a batch of queries, wherein the batch of queries includes a plurality of queries and each query of the plurality of queries is configured to retrieve data from a database;
- select a first query of the plurality of queries;
- generate an access path for the first query includes one or more mini plans;
- build a learning model for the one or more mini plans;
- estimate, by the one or more mini plans, an estimated execution time for each of the one or more mini plans;
- add each of the estimated execution times for each of the one or more mini plans to determine a total query estimated time;
- and
- display the total query estimated time.
A computer program product, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processing unit to cause the processing unit to:
- identify a batch of queries, wherein the batch of queries includes a plurality of queries and each query of the plurality of queries is configured to retrieve data from a database;
- select a first query of the plurality of queries;
- generate an access path for the first query includes one or more mini plans;
- build a learning model for the one or more mini plans;
- estimate, by the one or more mini plans, an estimated execution time for each of the one or more mini plans;
- add each of the estimated execution times for each of the one or more mini plans to determine a total query estimated time;
- and
- display the total query estimated time.
Dependencies are inferred from the claim text.