• DocumentCode
    3779340
  • Title

    Serializable use of Read Committed isolation level

  • Author

    Mohammad Alomari;Alan Fekete

  • Author_Institution
    Saudi Arabian Oil Company, Dhahran 31311, Saudi Arabia
  • fYear
    2015
  • Firstpage
    1
  • Lastpage
    8
  • Abstract
    Several DBMS engines use Read Committed (RC) as a default isolation level, risking the loss of data integrity but allowing more concurrency. We propose ways to preanalyse (and then modify) the code of a set of applications, that will allow us to run at RC isolation and still guarantee that all executions are serializable. Our experiments show performance that is significantly higher than from traditional ways that ensure correctness by directly using stronger isolation mechanisms (two-phase locking or snapshot isolation) that might be available in the engine. The overhead of our approach compared to RC on unmodified application programs is typically only about 5-10%.
  • Keywords
    "Engines","Silicon","Databases","Concurrency control","History","Concurrent computing","Proposals"
  • Publisher
    ieee
  • Conference_Titel
    Computer Systems and Applications (AICCSA), 2015 IEEE/ACS 12th International Conference of
  • Electronic_ISBN
    2161-5330
  • Type

    conf

  • DOI
    10.1109/AICCSA.2015.7507103
  • Filename
    7507103