DocumentCode
3207109
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
fYear
1991
fDate
8-12 Apr 1991
Firstpage
632
Lastpage
639
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;
fLanguage
English
Publisher
ieee
Conference_Titel
Data Engineering, 1991. Proceedings. Seventh International Conference on
Conference_Location
Kobe
Print_ISBN
0-8186-2138-9
Type
conf
DOI
10.1109/ICDE.1991.131512
Filename
131512
Link To Document