Title
Sort-aware query scheduling in database management systems
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 Gruska1433.15
Wendy Powley232928.43
Patrick Martin300.34
Paul Bird41198.78