• 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