Dynamic Workload Management for Very Large Data Warehouses - Juggling Feathers and Bowling Balls

Workload management for Business Intelligence (BI) queries poses different challenges than those addressed in the Online Transaction Processing (OLTP) context. The fundamental problem is that the execution times of BI queries can range from milliseconds to hours, and it is difficult to estimate these times accurately. Key challenges raised by this problem are how to identify queries that are not performing properly and what to do about them. The authors propose here a workload management system for controlling the execution of individual queries based on realistic customer service level objectives.