Multiclass Query Scheduling in Real-Time Database Systems

• Main Authors: PANG, Hwee Hwa, CAREY, Michael J., LIVNY, Miron
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 1995
• Subjects: Memory management; Priority scheduling; Query processing; Real-time database systems; Databases and Information Systems; Numerical Analysis and Scientific Computing
• Online Access: https://ink.library.smu.edu.sg/sis_research/110; https://ink.library.smu.edu.sg/context/sis_research/article/1109/viewcontent/Multiclass_Query_Scheduling_in_Real_Time_Database_Systems__edited_.pdf
• Institution: Singapore Management University

In recent years, a demand for real-time systems that can manipulate large amounts of shared data has led to the emergence of real-time database systems (RTDBS) as a research area. This paper focuses on the problem of scheduling queries in RTDBSs. We introduce and evaluate a new algorithm called Priority Adaptation Query Resource Scheduling (PAQRS) for handling both single class and multiclass query workloads. The performance objective of the algorithm is to minimize the number of missed deadlines, while at the same time ensuring that any deadline misses are scattered across the different classes according to an administratively-defined miss distribution. This objective is achieved by dynamically adapting the system's admission, memory allocation, and priority assignment policies according to its current resource configuration and workload characteristics. A series of experiments confirms that PAQRS is very effective for real-time query scheduling