Title :
Serializable use of Read Committed isolation level
Author :
Mohammad Alomari;Alan Fekete
Author_Institution :
Saudi Arabian Oil Company, Dhahran 31311, Saudi Arabia
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"
Conference_Titel :
Computer Systems and Applications (AICCSA), 2015 IEEE/ACS 12th International Conference of
Electronic_ISBN :
2161-5330
DOI :
10.1109/AICCSA.2015.7507103