US 2010/0162251 A1 · SYSTEM, METHOD, AND COMPUTER-READABLE MEDIUM FOR CLASSIFYING PROBLEM QUERIES TO REDUCE EXCEPTION PROCESSING

Abstract

A system, method, and computer-readable medium that facilitate classification of database requests as problematic based on estimated processing characteristics of the request are provided. Estimated processing characteristics may include estimated skew including central processing unit skew and input/output operation skew, central processing unit duration per input/output operation, and estimated memory usage. The estimated processing characteristics are made on a request step basis. The request is classified as problematic responsive to determining one or more of the estimated characteristics of a request step exceed a corresponding threshold. In this manner, mechanisms for predicting bad query behavior are provided. Workload management of those requests may then be more successfully provided through workload throttles, filters, or even a more confident exception detection that correlates with the estimated bad behavior.

Claims23

Dependent claims

A method of classifying requests in a database system deployed in a computer system, comprising:

receiving a plurality of steps of a database request;
estimating processing characteristics of one or more of the request steps;
assigning the request a problematic classification responsive to determining at least one of the processing characteristics exceeds a specified threshold;
and
processing the request according to the problematic classification.

2 more elements

A computer-readable medium having computer-executable instructions for execution by a processing system, the computer-executable instructions for classifying requests in a database system deployed in a computer system, the computer-executable instructions, when executed, cause the processing system to:

receive a plurality of steps of a database request;
estimate processing characteristics of one or more of the request steps;
assign the request a problematic classification responsive to determining at least one of the processing characteristics exceeds a specified threshold;
and
process the request according to the problematic classification.

2 more elements

A computer system having a database management system deployed therein configured to classify requests, comprising:

at least one storage medium on which the database management system is stored;
and
at least one processing module that receives a plurality of steps of a database request, estimates processing characteristics of one or more of the request steps, assigns the request a problematic classification responsive to determining at least one of the processing characteristics exceeds a specified threshold, and processes the request according to the problematic classification.

Dependencies are inferred from the claim text.

System, method, and computer-readable medium for classifying problem queries to reduce exception processing

Life of this patent

System, method, and computer-readable medium for classifying problem queries to reduce exception processing

Life of this patent

Abstract

Claims23