Method and system for workload management for data management systems

Abstract

A system for controlling access to a downstream database management system (DMS) is provided. The system comprises an interface to maintain client connections with a plurality of upstream clients; a pooling component to establish a dynamic pool, and to selectively route each client connection to a pool; within each pool maintaining a queue comprising client database requests associated with particular client connections; and selectively granting access to the client database requests within each queue to at least one downstream DMS.

1 . A system for controlling access to a downstream database management system (DMS), the system comprising:
 an interface to maintain client connections with a plurality of upstream clients;   a pooling component to establish a dynamic pool, and to selectively route each client connection to a pool;   within each pool maintaining a queue comprising client database requests associated with particular client connections; and   selectively granting access to the client database requests within each queue to at least one downstream DMS.   
     
     
         2 . The system of  claim 1 , wherein the pooling component routes each client connection based on a policy. 
     
     
         3 . The system of  claim 1 , wherein each dynamic pool comprises limits a number of concurrent connections permitted to the DMS. 
     
     
         4 . The system of  claim 1 , wherein each dynamic pool limits a number of concurrent active slots for each pool. 
     
     
         5 . The system of  claim 1 , wherein each dynamic pool limits a number of connection requests that can be waitlisted within the queue. 
     
     
         6 . The system of  claim 1 , further comprising a control module configured to allow administrators to configure each pool. 
     
     
         7 . The system of  claim 1 , further comprising a tracing component to monitor aspects of a connection. 
     
     
         8 . The system of  claim 7 , wherein said aspects comprises a time when a request was received, time spent waiting for admission to a pool, a transcript of the request, a Time when first data pursuant to the client database request is received, and a time when a client database request is completed. 
     
     
         9 . The system of  claim 1 , configured to selectively grant access to said upstream clients to a plurality of downstream DMS instances. 
     
     
         10 . The system of  claim 9 , wherein said downstream DMS define a cluster within which the particular instances are replicas of each other, save for variations due to data commit operations 
     
     
         11 . The system of  claim 1 , configured to execute a work load balancing process to select a DMS the particular instance to process a claim to this request based on a workload balancing criterion. 
     
     
         12 . The system of  claim 11 , wherein said working balancing criterion comprises a criterion to randomly select said instance. 
     
     
         13 . The system of  claim 11 , wherein said work load balancing criterion comprises a criterion to select said instance on a round robin basis. 
     
     
         14 . The system of  claim 11 , wherein said work load balancing process is configured to select said instance based on factors selected from the group consisting of client address, geographical location, client priority, and a type associated with the client database request. 
     
     
         15 . The system of  claim 10 , further comprising a mechanism to detect an operational state associated with each DMS replica. 
     
     
         16 . The system of  claim 15 , configured to exclude any non-operational DMS replicas from said work load balancing process. 
     
     
         17 . The system of  claim 10 , further comprising a special pool configured to queue client database requests during maintenance operations.