Name
Abstract | ||
|---|---|---|
Resource allocation in database management systems is a performance management process in which an autonomic DBMS makes resource allocation decisions based on properties like workload business importance. We propose the use of economic models to guide the resource allocation decisions. An economic model is described in terms of business concepts and has been successfully applied in computer system resource allocation problems. In this paper, we present an approach that uses economic models to allocate multiple resources, such as main memory buffer space and CPU shares, to workloads running concurrently on a DBMS. The economic model enables workloads to meet their service level objectives by allocating resources through partitioning the individual DBMS resources and making system-level resource allocation plans for the workloads. The resource allocation plans can be dynamically changed to respond to changes in workload performance requirements. Experiments are conducted on IBM® DB2® databases to verify the effectiveness of our approach. |
Year | DOI | Venue |
|---|---|---|
2008 | 10.1145/1463788.1463814 | CASCON |
Keywords | Field | DocType |
resource allocation,resource allocation decision,economic model,individual dbms resource,business concept,database management system,system-level resource allocation plan,multiple resource,computer system resource allocation,autonomic dbms,resource allocation plan,database management,performance management,service level | Resource management,Service level objective,Economic model,Computer science,Workload,Resource allocation (computer),Human resource management system,Resource allocation,Performance management,Database | Conference |
Citations | PageRank | References |
3 | 0.39 | 9 |
Authors | ||
4 | ||
Name | Order | Citations | PageRank |
|---|---|---|---|
| Mingyi Zhang | 1 | 8 | 3.83 |
| Patrick Martin | 2 | 3 | 0.39 |
| Wendy Powley | 3 | 329 | 28.43 |
| Paul Bird | 4 | 119 | 8.78 |