Abstract | ||
---|---|---|
Workloads presented to Database Management Systems (DBMSs) can fluctuate dramatically with a sudden influx of requests or a request involving a complex query. Increased loads can strain resources and impact performance. We propose a load control system based on regulating individual resource usage in a predictive manner and illustrate the use of this technique for a single resource, namely the sort heap. A method of estimating sort heap usage based on the query execution plan is detailed and several scheduling methods based on these estimations are proposed and compared experimentally. |
Year | Venue | Keywords |
---|---|---|
2012 | CASCON | predictive manner,impact performance,sort-aware query scheduling,sort heap usage,individual resource usage,database management system,query execution plan,database management systems,sort heap,complex query,load control system,single resource |
Field | DocType | Citations |
Query optimization,Computer science,Scheduling (computing),sort,View,Real-time computing,Heap (data structure),Online aggregation,Control system,Database,Distributed computing | Conference | 0 |
PageRank | References | Authors |
0.34 | 12 | 4 |
Name | Order | Citations | PageRank |
---|---|---|---|
Natalie Gruska | 1 | 43 | 3.15 |
Wendy Powley | 2 | 329 | 28.43 |
Patrick Martin | 3 | 0 | 0.34 |
Paul Bird | 4 | 119 | 8.78 |