{"title":"Pseudo column level locking","authors":"Nagavamsi Ponnekanti","doi":"10.1109/ICDE.2001.914868","DOIUrl":null,"url":null,"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).","PeriodicalId":431818,"journal":{"name":"Proceedings 17th International Conference on Data Engineering","volume":"123 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2001-04-02","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings 17th International Conference on Data Engineering","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/ICDE.2001.914868","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 1
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).
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
