Tolerance level-based tuning of query processing
AssigneeHewlett Packard Enterprise Development LP
InventorShine Mathew
Life of this patent
Estimating the term…
Abstract
An input is accessed representing a tuning parameter for a first query statement and a tolerance level. The tolerance level represents a degree of acceptable discrepancy between the first query statement and another query statement. A first fingerprint is generated for the first query statement based on a content of the first query statement and the tolerance level; and the first fingerprint and the tuning parameter are stored. The first fingerprint is used as an index for an optimizer to associate the tuning parameter with a second query statement that corresponds to the first fingerprint.
Claims20
A method comprising:
- accessing input representing a tuning parameter for a first query statement and a tolerance level, wherein the tolerance level represents a degree of acceptable discrepancy between the first query statement and another query statement;
- generating a first fingerprint for the first query statement based on a content of the first query statement and the tolerance level;
- and
- storing the first fingerprint and the tuning parameter, wherein the first fingerprint is used by an optimizer as an index to associate the tuning parameter with a second query statement that corresponds to the first fingerprint.
A system comprising:
- a processor;
- and
- a memory to store instructions that, when executed by the processor, cause the processor to:
- access a first query statement;
- determine a first plurality of fingerprints representing the first query statement, wherein the first plurality of fingerprints correspond to different tolerance levels;
- compare the first plurality of fingerprints to a second plurality of fingerprints, wherein each fingerprint of the second plurality of fingerprints is associated with a tuning parameter of a plurality of tuning parameters;
- based on the comparison, select a tuning parameter of the plurality of tuning parameters;
- and
- process the first query statement based on the selected tuning parameter.
A non-transitory machine readable storage medium storing instructions that, when executed by a machine, cause the machine to:
- access a first query statement, a tuning parameter for the first query statement and a tolerance level defining a degree of association between the first query statement and the tuning parameter;
- based on the tolerance level and a content of the first query statement, process the first query statement to generate a first hash value;
- and
- associate the first hash value with the tuning parameter.
Dependencies are inferred from the claim text.