Patent ID: 9275102
Filing Date: 2016-03-01
CPC Classification: G06F

Claim Text:
1. A computer-implemented method to regulate query resource consumption as a function of current load of a processing environment, the computer-implemented method comprising: receiving a plurality of queries for execution in the processing environment, the plurality of queries including a first query, a second query, and a third query; determining a maximum threshold of a resource that any query is permitted to consume, based on a measure of the current load of the processing environment; determining, for each of the first, second and third queries, an estimated amount of the resource likely consumed by the respective query when executed, wherein the estimated amount likely consumed by the respective query does not exceed the maximum threshold; issuing the first query for execution, upon determining that the estimated amount of the resource likely consumed by the first query does not exceed the maximum threshold; dynamically adjusting the maximum threshold by operation of one or more computer processors, based on one or more changes in the current load over time and without requiring user intervention, including decreasing the maximum threshold responsive to an increase in the current load; rejecting or delaying execution of the second query, upon determining that the estimated amount of the second query exceeds the decreased maximum threshold; and suspending or aborting the third query mid-execution, upon determining that the estimated amount of the resource likely consumed by the third query exceeds the decreased maximum threshold; whereby resource consumption of the first, second, and third queries is regulated as a function of the current load of the processing environment.