• DocumentCode
    2614394
  • Title

    Performance analysis of optimistic concurrency control schemes with different rerun policies

  • Author

    Yu, Philip S. ; Dias, Daniel M.

  • Author_Institution
    IBM Thomas J. Watson Res. Center, Yorktown Heights, NY, USA
  • fYear
    1991
  • fDate
    11-13 Sep 1991
  • Firstpage
    294
  • Lastpage
    300
  • Abstract
    The pure optimistic concurrency control (OCC) scheme, which only aborts a transaction at its commit time, can do better than aborting transactions as soon as conflict is detected (broadcast OCC). To further exploit this phenomenon, hybrid CC schemes are devised which use a different CC scheme to handle rerun transactions. These include switching to static or dynamic locking (static and dynamic hybrid OCC schemes, respectively) or to broadcast OCC during rerun, while doing pure OCC for the first run. In the high-data contention environment, where locking is inferior to OCC, it is found that the static and dynamic hybrid OCC can do better than OCC
  • Keywords
    concurrency control; database management systems; performance evaluation; transaction processing; dynamic locking; high-data contention environment; optimistic concurrency control schemes; performance analysis; rerun policies; rerun transactions; Broadcasting; Concurrency control; Delay; Hardware; Memory management; Performance analysis; Protocols;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Computer Software and Applications Conference, 1991. COMPSAC '91., Proceedings of the Fifteenth Annual International
  • Conference_Location
    Tokyo
  • Print_ISBN
    0-8186-2152-4
  • Type

    conf

  • DOI
    10.1109/CMPSAC.1991.170192
  • Filename
    170192