Towards a QoS-aware DBMS

Authors

Abstract

Quality of service is a key issue in current and future computer systems. Applications run on systems and typically access a backend DBMS which doesn't provide performance-related QoS guarantees, and whose resources are constrained. Throughput increases with the number of concurrent transactions until it reaches a saturation point (optimal EC) where more concurrent transactions lead to a drop in throughput. In order to sustain quality of service, it is essential to use admission control mechanisms that manage congestion and do not admit transactions that can't be executed within relevant quality-of service constraints, thus avoiding the degradation of performance for running transactions. In this paper we use a QoS Brokering architecture to enhance DBMS with QoS capabilities that allow the system to deliver QoS guarantees while sustaining large throughputs with reduced miss ratios. Experimental results are obtained using the TPC-C transactional benchmark.

Keywords

QoS

Subject

QoS; DB

Related Project

AdaptDB: Auto-Adaptability of Database Server for QoS in Heterogeneous Environments

Conference

SMDB, April 2008