Patent ID: 8224811
Filing Date: 2012-07-17
Classification: G06F

Abstract:
1. 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: