Evaluation of set of representative query performance using robustness mapping
AssigneeHewlett-Packard Development Company, L.P.
InventorsGoetz Graefe, Murali M. Krishna, Harumi Kuno, Janet L. Wiener
Life of this patent
Estimating the term…
Abstract
Computer-implemented systems and associated operating methods use atomic query maps to identify and evaluate database query plan robustness landmarks. The computer-implemented system comprises logic that evaluates robustness of a selected atomic query by measuring performance of atomic query execution in a predetermined range of runtime conditions that include data characteristics. The logic produces a set of measurements that can be displayed as one or more performance maps and analyzes the measured performance to identify landmarks indicative of database atomic query performance degradation greater than a predetermined amount.
Claims17
A computer-implemented system comprising:
- a logic circuit to:
- evaluate robustness of a selected atomic query by measuring performance of atomic query execution in a selected range of runtime conditions in a multi-dimensional parameter space, the multi-dimensional parameter space including at least one of data characteristics or an availability of a resource;
- produce a set of measurements to be displayed in at least one performance map, the at least one performance map indicating the measured performance in the selected range of runtime conditions;
- and
- analyze the measured performance to identify landmarks indicative of database atomic query performance degradation greater than a selected amount.
A computer-implemented system comprising:
- a logic circuit to:
- evaluate database performance of a selected query plan;
- create a set of performance maps to indicate performance of a selected database system following the selected query plan under a selected range of measured runtime conditions in a multi-dimensional parameter space, the multi-dimensional parameter space including at least one of data characteristics or an availability of a resource, at least one of the performance maps comprising a landmark indicative of database performance degradation greater than a selected amount;
- measure the database performance in the selected range of runtime conditions;
- and
- map the measured runtime conditions to the set of performance maps.
A computer-implemented system comprising:
- a logic circuit to:
- access a set of atomic query maps indicating atomic query performance in a plurality of runtime conditions in a multi-dimensional parameter space;
- and
- analyze the atomic query maps to identify landmarks in relation to a selected query plan, wherein the landmarks are to be identified by identifying a set of runtime conditions in which performance of the selected query plan degrades in a manner different from a predetermined manner, the multi-dimensional parameter space including at least one of data characteristics or an availability of a resource.
Dependencies are inferred from the claim text.