Patent ID: 8224811

Claim:
A computer-implemented system comprising: a logic circuit to: receive at least one robustness map of measured database system performance acquired during database execution in a range of runtime conditions, at least one of the runtime conditions of the database system being a first condition at which performance degrades by more than a first threshold; receive a set of query plans to be managed and a set of robustness maps including landmarks in terms of operator's cardinality, resource conditions, and performance for a target database management system; identify landmarks pertinent to the query plans; extract a set of landmarks indicative of the conditions causing performance to degrade in a manner different from a proper manner and indicative of probabilities of the conditions; analyze a state of a currently executing query by locating the query's performance on the at least one robustness map; and monitor execution of a query plan of the query plans by performing at least one of: characterizing a range and trends of current operating conditions; identifying robustness landmarks pertinent to the executing query within a current range of operating conditions wherein performance is known to degrade in a manner different from the proper manner by the first threshold or a second threshold; identifying robustness landmarks pertinent to the executing which are likely to be encountered with persisting current trends; and determining, for the executing query, whether corrective action is merited.