{"title":"通过降低数据库锁定级别提高并发事务性能","authors":"M. Mohamed, M. Badawy, A. El-Sayed","doi":"10.21608/mjeer.2018.63267","DOIUrl":null,"url":null,"abstract":"A concurrency in database designed to implement multipletransactions on the same database simultaneously that mayproduce on a problem called transactions conflict. Theperformance improvement of web-based database transactionsis through applying concurrency. Previous proposals to applyconcurrency lead to huge problems such transactions conflict.Transactions Conflict leads to rollback some transactions frommultiple concurrent transactions to complete the others. Thispaper proposes an algorithm to solve this obstacle byimplementing locking on the cell level. This algorithm improvesthe throughput and committing transactions by about 42% and36% respectively.","PeriodicalId":218019,"journal":{"name":"Menoufia Journal of Electronic Engineering Research","volume":"76 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2018-07-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Improvement of Concurrent Transactions Performance via Database Locking Level Reduction\",\"authors\":\"M. Mohamed, M. Badawy, A. El-Sayed\",\"doi\":\"10.21608/mjeer.2018.63267\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"A concurrency in database designed to implement multipletransactions on the same database simultaneously that mayproduce on a problem called transactions conflict. Theperformance improvement of web-based database transactionsis through applying concurrency. Previous proposals to applyconcurrency lead to huge problems such transactions conflict.Transactions Conflict leads to rollback some transactions frommultiple concurrent transactions to complete the others. Thispaper proposes an algorithm to solve this obstacle byimplementing locking on the cell level. This algorithm improvesthe throughput and committing transactions by about 42% and36% respectively.\",\"PeriodicalId\":218019,\"journal\":{\"name\":\"Menoufia Journal of Electronic Engineering Research\",\"volume\":\"76 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2018-07-01\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Menoufia Journal of Electronic Engineering Research\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.21608/mjeer.2018.63267\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Menoufia Journal of Electronic Engineering Research","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.21608/mjeer.2018.63267","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
Improvement of Concurrent Transactions Performance via Database Locking Level Reduction
A concurrency in database designed to implement multipletransactions on the same database simultaneously that mayproduce on a problem called transactions conflict. Theperformance improvement of web-based database transactionsis through applying concurrency. Previous proposals to applyconcurrency lead to huge problems such transactions conflict.Transactions Conflict leads to rollback some transactions frommultiple concurrent transactions to complete the others. Thispaper proposes an algorithm to solve this obstacle byimplementing locking on the cell level. This algorithm improvesthe throughput and committing transactions by about 42% and36% respectively.
京公网安备 11010802042870号
京ICP备2023020795号-1
分享
求助内容：
应助结果提醒方式：
扫码关注我们
