{"id":"https://openalex.org/W4411374194","doi":"https://doi.org/10.1145/3722212.3724457","title":"TXSQL: Lock Optimizations Towards High Contented Workloads","display_name":"TXSQL: Lock Optimizations Towards High Contented Workloads","publication_year":2025,"publication_date":"2025-06-17","ids":{"openalex":"https://openalex.org/W4411374194","doi":"https://doi.org/10.1145/3722212.3724457"},"language":"en","primary_location":{"id":"doi:10.1145/3722212.3724457","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3722212.3724457","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3722212.3724457","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5115588865","display_name":"Donghui Wang","orcid":null},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Donghui Wang","raw_affiliation_strings":["Tencent Inc., Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tencent Inc., Shenzhen, China","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101526503","display_name":"Yuxing Chen","orcid":"https://orcid.org/0000-0002-6220-2535"},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yuxing Chen","raw_affiliation_strings":["Tencent Inc., Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tencent Inc., Shenzhen, China","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5111360283","display_name":"Chengyao Jiang","orcid":null},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chengyao Jiang","raw_affiliation_strings":["Tencent Inc., Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tencent Inc., Shenzhen, China","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001037413","display_name":"Anqun Pan","orcid":"https://orcid.org/0000-0002-6756-149X"},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Anqun Pan","raw_affiliation_strings":["Tencent Inc., Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tencent Inc., Shenzhen, China","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108527211","display_name":"Wei Jiang","orcid":"https://orcid.org/0000-0003-1640-0562"},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wei Jiang","raw_affiliation_strings":["Tencent Inc., Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tencent Inc., Shenzhen, China","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078293733","display_name":"Wang Song-li","orcid":null},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Songli Wang","raw_affiliation_strings":["Tencent Inc., Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tencent Inc., Shenzhen, China","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5010681523","display_name":"Hailin Lei","orcid":null},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hailin Lei","raw_affiliation_strings":["Tencent Inc., Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tencent Inc., Shenzhen, China","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024417642","display_name":"Chong Zhu","orcid":null},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chong Zhu","raw_affiliation_strings":["Tencent Inc., Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tencent Inc., Shenzhen, China","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066111929","display_name":"Lixiong Zheng","orcid":null},"institutions":[{"id":"https://openalex.org/I2250653659","display_name":"Tencent (China)","ror":"https://ror.org/00hhjss72","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250653659"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Lixiong Zheng","raw_affiliation_strings":["Tencent Inc., Shenzhen, China"],"affiliations":[{"raw_affiliation_string":"Tencent Inc., Shenzhen, China","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005529387","display_name":"Wei L\u00fc","orcid":"https://orcid.org/0000-0001-6769-2695"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Wei Lu","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101440226","display_name":"Yunpeng Chai","orcid":"https://orcid.org/0000-0002-3286-9259"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yunpeng Chai","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091139467","display_name":"Feng Zhang","orcid":"https://orcid.org/0000-0003-1983-7321"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Feng Zhang","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5008721449","display_name":"Xiaoyong Du","orcid":"https://orcid.org/0000-0002-5757-9135"},"institutions":[{"id":"https://openalex.org/I78988378","display_name":"Renmin University of China","ror":"https://ror.org/041pakw92","country_code":"CN","type":"education","lineage":["https://openalex.org/I78988378"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaoyong Du","raw_affiliation_strings":["Renmin University of China, Beijing, China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China, Beijing, China","institution_ids":["https://openalex.org/I78988378"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":13,"corresponding_author_ids":["https://openalex.org/A5115588865"],"corresponding_institution_ids":["https://openalex.org/I2250653659"],"apc_list":null,"apc_paid":null,"fwci":3.2508,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.91804465,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":91,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"675","last_page":"688"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9994999766349792,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9993000030517578,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12127","display_name":"Software System Performance and Reliability","score":0.9954000115394592,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/lock","display_name":"Lock (firearm)","score":0.74957674741745},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7007030248641968},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.4559611976146698},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.4532056152820587},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.3689202070236206},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.09411868453025818},{"id":"https://openalex.org/keywords/mechanical-engineering","display_name":"Mechanical engineering","score":0.046003758907318115}],"concepts":[{"id":"https://openalex.org/C174839445","wikidata":"https://www.wikidata.org/wiki/Q1134386","display_name":"Lock (firearm)","level":2,"score":0.74957674741745},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7007030248641968},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.4559611976146698},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4532056152820587},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.3689202070236206},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.09411868453025818},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.046003758907318115}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3722212.3724457","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3722212.3724457","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3722212.3724457","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3722212.3724457","pdf_url":null,"source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2025 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":60,"referenced_works":["https://openalex.org/W1433235304","https://openalex.org/W1550275036","https://openalex.org/W1814601622","https://openalex.org/W1969460277","https://openalex.org/W1975637639","https://openalex.org/W1993505169","https://openalex.org/W1998663979","https://openalex.org/W2006732937","https://openalex.org/W2080345113","https://openalex.org/W2081360300","https://openalex.org/W2107212030","https://openalex.org/W2130617154","https://openalex.org/W2132497824","https://openalex.org/W2133741724","https://openalex.org/W2141710443","https://openalex.org/W2152211001","https://openalex.org/W2152812436","https://openalex.org/W2155070484","https://openalex.org/W2236986911","https://openalex.org/W2271870283","https://openalex.org/W2302689651","https://openalex.org/W2394555589","https://openalex.org/W2425029179","https://openalex.org/W2435606122","https://openalex.org/W2576856762","https://openalex.org/W2579029018","https://openalex.org/W2585130803","https://openalex.org/W2585715281","https://openalex.org/W2612011989","https://openalex.org/W2769700065","https://openalex.org/W2798304533","https://openalex.org/W2884299639","https://openalex.org/W2899672681","https://openalex.org/W2902648414","https://openalex.org/W2933851371","https://openalex.org/W2949401976","https://openalex.org/W2970836712","https://openalex.org/W2990985518","https://openalex.org/W3008139924","https://openalex.org/W3022630129","https://openalex.org/W3027997356","https://openalex.org/W3081666704","https://openalex.org/W3098168353","https://openalex.org/W3158900323","https://openalex.org/W3164625502","https://openalex.org/W3173853494","https://openalex.org/W3174320343","https://openalex.org/W3174952926","https://openalex.org/W4206512216","https://openalex.org/W4250445884","https://openalex.org/W4312357089","https://openalex.org/W4378510288","https://openalex.org/W4389721993","https://openalex.org/W4394967015","https://openalex.org/W4396571399","https://openalex.org/W4400071957","https://openalex.org/W4400909951","https://openalex.org/W4404181461","https://openalex.org/W6600168703","https://openalex.org/W6910646414"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"Two-phase":[0],"locking":[1],"(2PL)":[2],"is":[3,63],"a":[4,21],"fundamental":[5],"and":[6,26,48,55,97],"widely":[7],"used":[8],"concurrency":[9,54],"control":[10],"protocol.":[11],"It":[12],"regulates":[13],"concurrent":[14],"access":[15],"to":[16,46],"database":[17],"data":[18],"by":[19],"following":[20],"specific":[22],"sequence":[23],"of":[24],"acquiring":[25],"releasing":[27],"locks":[28],"during":[29],"transaction":[30,34],"execution,":[31],"thereby":[32],"ensuring":[33],"isolation.":[35],"However,":[36],"in":[37,65,84,99],"strict":[38],"2PL,":[39],"transactions":[40,45],"must":[41],"wait":[42],"for":[43],"conflicting":[44],"commit":[47],"release":[49],"their":[50,87],"locks,":[51],"which":[52],"reduces":[53],"system":[56,76],"throughput.":[57],"We":[58],"have":[59],"observed":[60],"this":[61],"issue":[62],"exacerbated":[64],"high-contented":[66],"workloads":[67],"at":[68],"Tencent,":[69],"where":[70],"lock":[71,95],"contention":[72,96],"can":[73],"severely":[74],"degrade":[75],"performance.":[77],"While":[78],"existing":[79],"optimizations":[80],"demonstrate":[81],"some":[82],"effectiveness":[83],"high-contention":[85],"scenarios,":[86],"performance":[88],"remains":[89],"insufficient,":[90],"as":[91],"they":[92],"suffer":[93],"from":[94],"waiting":[98],"hotspot":[100],"access.":[101]},"counts_by_year":[{"year":2025,"cited_by_count":1}],"updated_date":"2026-03-27T05:58:40.876381","created_date":"2025-10-10T00:00:00"}