Query management based on amount of data change
AssigneeInternational Business Machines Corporation
InventorsEric L. BARSNESS, Daniel E. BEUCH, Brian R. MURAS, John M. SANTOSUOSSO
Life of this patent
Estimating the term…
Abstract
Techniques are described for estimating and managing an amount of data change for query processing. Embodiments of the present disclosure may generally receive a query to be executed and calculate an estimated amount of data change for the received query. If the initial estimated amount of data change for the received query does not exceed a threshold amount of data change, embodiments of the present disclosure may submit the query for execution. If the initial estimated amount of data change for the received query does exceed a threshold amount of data change, embodiments of the present disclosure may halt the execution of the query.
Claims20
A method, comprising:
- receiving a query to be executed against a database;
- calculating an estimated amount of data that will be changed in executing the query against the database;
- determining a threshold amount of data based on one or more attributes of the query;
- and
- upon determining that the estimated amount of data change for the query does not exceed the threshold amount of data, executing the query against the database.
A system, comprising:
- a computer processor;
- and
- a memory containing a program that, when executed on the computer processor, performs an operation for managing the execution of a query, comprising:
- receiving a query to be executed;
- calculating an estimated amount of data change for the received query;
- and
- upon determining that the estimated amount of data change for the received query does not exceed a threshold amount of data change, executing the query
A computer program product for managing the execution of a query, comprising:
- a computer-readable storage medium having computer readable program code embodied therewith, the computer readable program code comprising:
- computer readable program code to receive a query to be executed;
- computer readable program code to calculate an estimated amount of data change for the received query;
- and
- computer readable program to, upon determining that the estimated amount of data change for the received query does not exceed a threshold amount of data change, execute the query.
Dependencies are inferred from the claim text.