Adaptive query scheduling for mixed database workloads with multiple objectives
Stefan Krompaß, Harumi Kuno, Kevin Wilkinson, Umeshwar Dayal, Alfons Kemper · 2010
Ideally, a data warehouse would be able to run multiple types of queries concurrently, meeting different performance objectives for each type. However, due to the difficulty of managing mixed workloads, most commercial systems segregate distinct workload components by using strict resource partitioning and/or time multiplexing. This approach avoids unexpected resource contention, but when one workload component does not fully use its allocated resources, those resources may then lie unused even if they could greatly improve the performance of another component.