This Article 
 Bibliographic References 
 Add to: 
2012 IEEE Fifth International Conference on Cloud Computing
WIQ: Work-Intensive Query Scheduling for In-Memory Database Systems
Honolulu, HI, USA USA
June 24-June 29
ISBN: 978-1-4673-2892-0
We propose a novel admission control policy for database queries. Our methodology uses system measurements of CPU utilization and query backlogs to determine interference between queries in execution on the same database server. Query interference may arise due to the concurrent access of hardware and software resources and can affect performance in positive and negative ways. Specifically our admission control considers the mix of jobs in service and prioritizes the query classes consuming CPU resources more efficiently. The policy ignores I/O subsystems and is therefore highly appropriate for in-memory databases. We validate our approach in trace-driven simulation and show performance increases of query slowdowns and throughputs compared to first-come first-served and shortest expected processing time first scheduling. Simulation experiments are parameterized from system traces of a SAP HANA in-memory database installation with TPC-H type workloads.
Index Terms:
Databases,Admission control,Interference,Instruction sets,Delay,Computational modeling,scheduling,performance,database management,query interference,admission control
Stephan Kraft, Giuliano Casale, Alin Jula, Peter Kilpatrick, Des Greer, "WIQ: Work-Intensive Query Scheduling for In-Memory Database Systems," cloud, pp.33-40, 2012 IEEE Fifth International Conference on Cloud Computing, 2012
Usage of this product signifies your acceptance of the Terms of Use.