DocumentCode
3299057
Title
When serializability comes without cost
Author
Alomari, Mohammad ; Cahill, Michael ; Fekete, Alan ; Röhm, Uwe
Author_Institution
Univ. of Sydney, Sydney
fYear
2008
fDate
March 31 2008-April 4 2008
Firstpage
164
Lastpage
171
Abstract
It is usually expected that performance is reduced by using stricter concurrency control, which reduces the risk of anomalies that can lead to data corruption. For example, the weak isolation level Read Committed allows anomalies that are prevented by two-phase locking (abbreviated 2PL), and because 2PL holds locks for longer than RC, it has lower throughput. We show that sometimes, guaranteed correctness can be obtained along with better throughput than RC, by use of the multiversion snapshot isolation mechanism along with modifications to application programs as proposed by Fekete et al. We investigate the conditions under which this effect occurs.
Keywords
concurrency control; database management systems; data corruption; database management systems; multiversion snapshot isolation mechanism; serializability; stricter concurrency control; two-phase locking; Australia; Concurrency control; Costs; Database systems; Delay effects; Gold; Information technology; Interleaved codes; Throughput; Transaction databases;
fLanguage
English
Publisher
ieee
Conference_Titel
Computer Systems and Applications, 2008. AICCSA 2008. IEEE/ACS International Conference on
Conference_Location
Doha
Print_ISBN
978-1-4244-1967-8
Electronic_ISBN
978-1-4244-1968-5
Type
conf
DOI
10.1109/AICCSA.2008.4493531
Filename
4493531
Link To Document