{"id":"https://openalex.org/W4413978235","doi":"https://doi.org/10.14778/3749646.3749689","title":"TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection","display_name":"TxnSails: Achieving Serializable Transaction Scheduling with Self-Adaptive Isolation Level Selection","publication_year":2025,"publication_date":"2025-07-01","ids":{"openalex":"https://openalex.org/W4413978235","doi":"https://doi.org/10.14778/3749646.3749689"},"language":"en","primary_location":{"id":"doi:10.14778/3749646.3749689","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3749646.3749689","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5114098567","display_name":"Q. Zhuang","orcid":null},"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":true,"raw_author_name":"Qiyu Zhuang","raw_affiliation_strings":["Renmin University of China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China","institution_ids":["https://openalex.org/I78988378"]}]},{"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"],"affiliations":[{"raw_affiliation_string":"Renmin University of China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5115593024","display_name":"Shuang Liu","orcid":"https://orcid.org/0009-0001-4284-7897"},"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":"Shuang Liu","raw_affiliation_strings":["Renmin University of China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China","institution_ids":["https://openalex.org/I78988378"]}]},{"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"],"affiliations":[{"raw_affiliation_string":"Tencent Inc","institution_ids":["https://openalex.org/I2250653659"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5026604798","display_name":"Xu Shi","orcid":"https://orcid.org/0000-0002-1449-1846"},"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":"Xinyue Shi","raw_affiliation_strings":["Renmin University of China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066862989","display_name":"Zhanhao Zhao","orcid":"https://orcid.org/0000-0002-4044-7742"},"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":"Zhanhao Zhao","raw_affiliation_strings":["Renmin University of China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China","institution_ids":["https://openalex.org/I78988378"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5108298739","display_name":"Y. J. Sun","orcid":"https://orcid.org/0009-0009-3690-7978"},"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":"Yipeng Sun","raw_affiliation_strings":["Renmin University of China"],"affiliations":[{"raw_affiliation_string":"Renmin University of China","institution_ids":["https://openalex.org/I78988378"]}]},{"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"],"affiliations":[{"raw_affiliation_string":"Tencent Inc","institution_ids":["https://openalex.org/I2250653659"]}]},{"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"],"affiliations":[{"raw_affiliation_string":"Renmin University of China","institution_ids":["https://openalex.org/I78988378"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":9,"corresponding_author_ids":["https://openalex.org/A5114098567"],"corresponding_institution_ids":["https://openalex.org/I78988378"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.32240049,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"18","issue":"11","first_page":"4227","last_page":"4240"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998000264167786,"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"}},"topics":[{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998000264167786,"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/T10054","display_name":"Parallel Computing and Optimization Techniques","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1708","display_name":"Hardware and Architecture"},"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9979000091552734,"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/serialization","display_name":"Serialization","score":0.6920077800750732},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6528183221817017},{"id":"https://openalex.org/keywords/isolation","display_name":"Isolation (microbiology)","score":0.6073738932609558},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5936055779457092},{"id":"https://openalex.org/keywords/scheduling","display_name":"Scheduling (production processes)","score":0.4829799234867096},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.4565742313861847},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.40133145451545715},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.37341025471687317},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.24822530150413513},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.17455339431762695},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.1598069667816162},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.12355953454971313},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.114081472158432},{"id":"https://openalex.org/keywords/biology","display_name":"Biology","score":0.05771937966346741}],"concepts":[{"id":"https://openalex.org/C52723943","wikidata":"https://www.wikidata.org/wiki/Q1127410","display_name":"Serialization","level":2,"score":0.6920077800750732},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6528183221817017},{"id":"https://openalex.org/C2775941552","wikidata":"https://www.wikidata.org/wiki/Q25212305","display_name":"Isolation (microbiology)","level":2,"score":0.6073738932609558},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5936055779457092},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.4829799234867096},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4565742313861847},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.40133145451545715},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.37341025471687317},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.24822530150413513},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.17455339431762695},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.1598069667816162},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.12355953454971313},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.114081472158432},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.05771937966346741},{"id":"https://openalex.org/C89423630","wikidata":"https://www.wikidata.org/wiki/Q7193","display_name":"Microbiology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3749646.3749689","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3749646.3749689","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":45,"referenced_works":["https://openalex.org/W1535010300","https://openalex.org/W1549414577","https://openalex.org/W1601925768","https://openalex.org/W1970748906","https://openalex.org/W1976216569","https://openalex.org/W1985229168","https://openalex.org/W1986119248","https://openalex.org/W1987844293","https://openalex.org/W1989306170","https://openalex.org/W1993505169","https://openalex.org/W1995339490","https://openalex.org/W1999060469","https://openalex.org/W2104954161","https://openalex.org/W2139285682","https://openalex.org/W2141710443","https://openalex.org/W2164700649","https://openalex.org/W2167868416","https://openalex.org/W2209943643","https://openalex.org/W2240667924","https://openalex.org/W2386452338","https://openalex.org/W2423891596","https://openalex.org/W2632828877","https://openalex.org/W2725226870","https://openalex.org/W2884299639","https://openalex.org/W2951893822","https://openalex.org/W2990985518","https://openalex.org/W3037027022","https://openalex.org/W3081666704","https://openalex.org/W3085309079","https://openalex.org/W3123420770","https://openalex.org/W3198338757","https://openalex.org/W4289866500","https://openalex.org/W4294408690","https://openalex.org/W4301736558","https://openalex.org/W4380433264","https://openalex.org/W4388545212","https://openalex.org/W4390145145","https://openalex.org/W4391748541","https://openalex.org/W4396571399","https://openalex.org/W4399163413","https://openalex.org/W4400909951","https://openalex.org/W4404181165","https://openalex.org/W4404181461","https://openalex.org/W4411374194","https://openalex.org/W4413349917"],"related_works":["https://openalex.org/W4231356583","https://openalex.org/W1593760324","https://openalex.org/W2376159383","https://openalex.org/W2351439380","https://openalex.org/W2899905671","https://openalex.org/W4390136247","https://openalex.org/W2365228680","https://openalex.org/W2131622620","https://openalex.org/W2362327801","https://openalex.org/W4384940449"],"abstract_inverted_index":{"Achieving":[0],"the":[1,17,33,36,44,108,111,123],"serializable":[2,74,157],"isolation":[3,26,41,54,78,94,119,125,139,158],"level":[4,55,79,140,159],"is":[5],"costly.":[6],"Recent":[7],"studies":[8,30],"have":[9],"revealed":[10],"that":[11,57,89,145],"adjusting":[12],"specific":[13],"query":[14],"patterns":[15],"within":[16],"workload":[18],"can":[19],"still":[20],"achieve":[21,73],"serializability,":[22,49],"even":[23],"at":[24,92],"lower":[25,40,93,118],"levels.":[27],"Nevertheless,":[28],"these":[29],"typically":[31],"overlook":[32],"trade-off":[34,109],"between":[35,110],"performance":[37,112],"advantages":[38],"of":[39],"levels":[42,95],"and":[43,114,154],"overhead":[45,115],"required":[46],"to":[47,52,59,72,106,134,152,162],"maintain":[48],"potentially":[50],"leading":[51],"suboptimal":[53],"choices":[56],"fail":[58],"maximize":[60],"performance.":[61],"In":[62],"this":[63],"paper,":[64],"we":[65],"present":[66],"TxnSails,":[67],"a":[68,84,102,130],"middle-tier":[69],"solution":[70],"designed":[71],"scheduling":[75],"with":[76,96,117],"self-adaptive":[77],"selection.":[80],"First,":[81],"TxnSails":[82,100,128,146],"incorporates":[83],"unified":[85],"concurrency":[86],"control":[87],"algorithm":[88],"achieves":[90],"serializability":[91,136],"minimal":[97],"overhead.":[98],"Second,":[99],"employs":[101],"deep":[103],"learning":[104],"method":[105],"characterize":[107],"benefits":[113],"associated":[116],"levels,":[120],"thus":[121],"predicting":[122],"optimal":[124],"level.":[126],"Finally,":[127],"implements":[129],"cross-isolation":[131],"validation":[132],"mechanism":[133],"ensure":[135],"during":[137],"real-time":[138],"transitions.":[141],"Extensive":[142],"experiments":[143],"demonstrate":[144],"outperforms":[147],"existing":[148],"solutions":[149],"by":[150,160],"up":[151,161],"26.7\u00d7":[153],"PostgreSQL":[155],"'s":[156],"4.8\u00d7.":[163]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}
