Title :
Conflict-driven load control for the avoidance of data-contention thrashing
Author :
Moenkeberg, Axel ; Weikum, Gerhard
Author_Institution :
Dept. of Comput. Sci., ETH Zurich, Switzerland
Abstract :
A conflict-driven approach to automatic load control is presented. Various definitions of conflict rate are investigated as to whether they are suitable as a control metric. Evidence is provided that there exists at least one suitable metric and a single value, called the critical conflict rate, that indicates data-contention (DC) thrashing regardless of the number or types of transactions in the system. Based on this observation, an algorithm is developed that admits new transactions and/or cancels running transactions depending on the current conflict rate. The algorithm and its various substrategies for transaction admission and transaction cancellation are evaluated under several sorts of overload situations. Simulation experiments with this algorithm have shown fairly good results, i.e. DC thrashing was prevented in overload situations without overly limiting the achievable throughput under regular conditions. Load control is fully automated, i.e., it does not require any manual tuning parameters
Keywords :
database management systems; transaction processing; DBMS; conflict-driven load control; control metric; critical conflict rate; data-contention thrashing; database management system; transaction admission; transaction cancellation; Automatic control; Computer science; Databases; Delay; H infinity control; Hardware; Information systems; Load flow control; Throughput; Thumb;
Conference_Titel :
Data Engineering, 1991. Proceedings. Seventh International Conference on
Conference_Location :
Kobe
Print_ISBN :
0-8186-2138-9
DOI :
10.1109/ICDE.1991.131512