Patent ID: 7379953
Filing Date: 2008-05-27
Classification: G06F,Y10S

Abstract:
1. A method for resource adaptive workload management, comprising the steps of: receiving at least one execution objective for at least one of a plurality of queries under execution; monitoring a progress status of, and an amount of resource consumed by, each of the plurality of queries; estimating a remaining resource requirement for each of the plurality of queries, based on the progress status of, and the amount of resource consumed by, each of the plurality of queries; and adjusting resource allocation based on the at least one execution objective and the estimates of the remaining resource requirements, wherein the method is implemented in a relational database management system (RDBMS), wherein the RDBMS has a query admission queue for storing queries prior to execution, and the method further comprises the steps of: maintaining an array of query-related information for all queries in the RDBMS including the plurality of queries under execution and any of the queries currently stored in the query admission queue; respectively updating the query-related information for each of the queries during executions thereof; and wherein remaining query execution times for the queries are estimated using the query-related information stored in the array.