Exploiting DBMS Idleness Periods for Tuning its Performance
AbdulMateen, Basit Raza, Muhammad Sher, Mian Muhammad Awais
International Journal of Information Studies, Vol. 6, No. 1, 2014.
DOI: 
Link: https://www.dline.info/ijis/fulltext/v6n1/ijisv6n1_2.pdf
Abstract:
Rapid growth in data, maximum functionality and changing behavior tends the database workload to be more complex and tricky. Every organization has complex types of database workloads that are difficult to manage by the humans; human experts take much time to get sufficient experience to manage workload efficiently; even in some cases this task becomes impossible and leads towards malnourishment. The versatility in database workload leads practitioners and researchers towards new challenges. The paper presents a novel approach for the workload management through Case Base Reasoning characterization approach, impact based scheduling and DBMS idleness detection. The approach will be validated
through experiments which will be performed over the real time workload to reveal the efficiency and accuracy. The ultimate goal of the research is to provide an Autonomous Workload Management framework with characterization, scheduler and
idleness detection modules.