DocumentCode
3013337
Title
Pseudo column level locking
Author
Ponnekanti, Nagavamsi
fYear
2001
fDate
2001
Firstpage
545
Lastpage
550
Abstract
Presents an optimization that can significantly enhance the concurrency provided by row-level locking in some relational DBMSs. With this optimization, the degree of concurrency obtained is comparable to that in column-level locking in some cases that are common at customer sites. Besides, this optimization does not increase the overhead of concurrency control significantly. We use the term pseudo-column-level locking (PCLL) for row-level locking enhanced with this optimization. While some versioning-based concurrency control schemes may offer better concurrency than PCLL, they are usually hard to incorporate in a relational DBMS that relies on locking for concurrency control. Our technique is simple to implement, and it has been implemented in Sybase Adaptive Server Enterprise (ASE)
Keywords
concurrency control; optimisation; relational databases; Sybase Adaptive Server Enterprise; concurrency control; optimization; pseudo-column-level locking; relational DBMS; row-level locking; versioning; Concurrency control; Concurrent computing; Database systems; Indexes; Indexing;
fLanguage
English
Publisher
ieee
Conference_Titel
Data Engineering, 2001. Proceedings. 17th International Conference on
Conference_Location
Heidelberg
ISSN
1063-6382
Print_ISBN
0-7695-1001-9
Type
conf
DOI
10.1109/ICDE.2001.914868
Filename
914868
Link To Document