{"title":"伪列级锁定","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":"{\"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}","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
摘要
提出了一种优化方法，可以显著增强某些关系dbms中行级锁定所提供的并发性。通过这种优化，获得的并发性程度与客户站点中常见的某些情况下的列级锁定相当。此外，这种优化不会显著增加并发控制的开销。我们使用术语伪列级锁定(pseudo-column-level locking, PCLL)来描述通过这种优化增强的行级锁定。虽然一些基于版本的并发控制方案可能提供比PCLL更好的并发性，但通常很难将它们合并到依赖于锁定进行并发控制的关系DBMS中。我们的技术很容易实现，并且已经在Sybase Adaptive Server Enterprise (ASE)中实现了。
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
分享
求助内容：
应助结果提醒方式：
扫码关注我们
