Evaluation of database query plan robustness landmarks using operator maps or query maps
AssigneeHewlett-Packard Development Company, L.P.
InventorsGoetz Graefe, Harumi Kuno, Janet L. Wiener
Life of this patent
Estimating the term…
Abstract
Computer-implemented systems and associated operating methods create and use an operator map to identify and evaluate database query plan robustness landmarks. The computer-implemented system comprises logic that creates a map evaluating performance of an implementation of a database engine operator during execution under actual operating conditions. The logic measures and maps performance for a selected range of runtime conditions including resource availability and data characteristics.
Claims15
A computer-implemented system comprising:
- a processor;
- a computer-readable data storage medium to store computer-readable program code that is executable by the processor to implement logic,
- wherein the logic creates a performance map evaluating performance of an implementation of a database engine operator or query plan during execution under actual conditions, the logic measuring and mapping performance for a selected range of runtime conditions comprising data characteristics,
- wherein the logic analyzes the maps to identify landmarks in relation to the database engine operator or the query plan in which performance degrades in a predetermined manner.
A computer-implemented system comprising:
- a processor;
- a computer-readable data storage medium to store computer-readable program code that is executable by the processor to implement logic,
- wherein the logic accesses at least one performance map created by acquisition during execution of an implementation of a database engine operator under actual conditions, the logic measuring and mapping performance for a selected range of runtime conditions to identify regions under which performance of a selected operator implementation degrades in a manner different from a predetermined proper manner, the logic analyzing the maps to identify landmarks in relation to a selected query plan wherein query performance degrades in a predetermined manner.
A computer-executed method of processing data comprising:
- evaluating database query plan robustness landmarks, by a processor, comprising:
- creating a performance map evaluating performance of an implementation of a database engine operator during execution under actual conditions, by the processor;
- measuring and mapping performance for a selected range of runtime conditions comprising data characteristics,
- analyzing the performance map to identify landmarks in relation to the database engine operator in which performance degrades in a predetermined manner, by the processor.
Dependencies are inferred from the claim text.