{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,23]],"date-time":"2026-06-23T08:32:54Z","timestamp":1782203574096,"version":"3.54.5"},"publisher-location":"New York, NY, USA","reference-count":91,"publisher":"ACM","license":[{"start":{"date-parts":[[2022,6,10]],"date-time":"2022-06-10T00:00:00Z","timestamp":1654819200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"funder":[{"name":"HighTech Support Program from Shanghai Committee of Science and Technology","award":["20ZR1428100"],"award-info":[{"award-number":["20ZR1428100"]}]},{"DOI":"10.13039\/501100001809","name":"National Natural Science Foundation of China","doi-asserted-by":"publisher","award":["61902242,62132014,62172272"],"award-info":[{"award-number":["61902242,62132014,62172272"]}],"id":[{"id":"10.13039\/501100001809","id-type":"DOI","asserted-by":"publisher"}]}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2022,6,10]]},"DOI":"10.1145\/3514221.3526120","type":"proceedings-article","created":{"date-parts":[[2022,6,12]],"date-time":"2022-06-12T02:33:49Z","timestamp":1655001229000},"page":"4-18","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":20,"title":["Ad Hoc Transactions in Web Applications: The Good, the Bad, and the Ugly"],"prefix":"10.1145","author":[{"given":"Chuzhe","family":"Tang","sequence":"first","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education, Shanghai, China"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Zhaoguo","family":"Wang","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education, Shanghai, China"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Xiaodong","family":"Zhang","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education, Shanghai, China"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Qianmian","family":"Yu","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education, Shanghai, China"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Binyu","family":"Zang","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education, Shanghai, China"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Haibing","family":"Guan","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University, Shanghai, China"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Haibo","family":"Chen","sequence":"additional","affiliation":[{"name":"Shanghai Jiao Tong University & Ministry of Education, Shanghai, China"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2022,6,11]]},"reference":[{"key":"e_1_3_2_2_1_1","volume-title":"Proceedings of the 5th Biennial Conference on Innovative Data Systems Research","author":"Alvaro Peter","year":"2011","unstructured":"Peter Alvaro, Neil Conway, Joseph M. Hellerstein, and William R. Marczak. 2011. Consistency Analysis in Bloom: a CALM and Collected Approach. In Proceedings of the 5th Biennial Conference on Innovative Data Systems Research (Asilomar, CA, USA) (CIDR '11). 249--260. http:\/\/cidrdb.org\/cidr2011\/Papers\/CIDR11_Paper35.pdf"},{"key":"e_1_3_2_2_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/38765.38847"},{"key":"e_1_3_2_2_3_1","doi-asserted-by":"publisher","DOI":"10.1016\/B978-0--444--88433--6.50020--4"},{"key":"e_1_3_2_2_4_1","doi-asserted-by":"publisher","DOI":"10.14778\/2735508.2735509"},{"key":"e_1_3_2_2_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2737784"},{"key":"e_1_3_2_2_6_1","doi-asserted-by":"publisher","DOI":"10.14778\/3297753.3297760"},{"key":"e_1_3_2_2_7_1","doi-asserted-by":"publisher","DOI":"10.1145\/2741948.2741972"},{"key":"e_1_3_2_2_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/22890.22945"},{"key":"e_1_3_2_2_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223785"},{"key":"e_1_3_2_2_10_1","unstructured":"Broadleaf Commerce. 2021. BroadleafCommerce. https:\/\/github.com\/BroadleafCommerce\/BroadleafCommerce"},{"key":"e_1_3_2_2_11_1","doi-asserted-by":"publisher","DOI":"10.1145\/2568225.2568259"},{"key":"e_1_3_2_2_12_1","unstructured":"Civilized Discourse Construction Kit. 2021. Discourse. https:\/\/github.com\/discourse\/discourse"},{"key":"e_1_3_2_2_13_1","unstructured":"Civilized Discourse Construction Kit. 2021. MiniSql. https:\/\/github.com\/discourse\/mini_sql"},{"key":"e_1_3_2_2_14_1","unstructured":"Claire. 2019. Avoid race condition when streaming deleted statuses. https:\/\/github.com\/mastodon\/mastodon\/pull\/10280"},{"key":"e_1_3_2_2_15_1","unstructured":"danielcolgrove. 2021. Comments on issue 2472. https:\/\/github.com\/BroadleafCommerce\/BroadleafCommerce\/issues\/2472#issuecomment-762425223"},{"key":"e_1_3_2_2_16_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3035919"},{"key":"e_1_3_2_2_17_1","volume-title":"Retrieved","year":"2021","unstructured":"DB-Engines. 2021. DB-Engines Ranking of Relational DBMS. Retrieved Dec. 15, 2021 from https:\/\/db-engines.com\/en\/ranking\/relational+dbms"},{"key":"e_1_3_2_2_18_1","doi-asserted-by":"publisher","DOI":"10.14778\/2536274.2536331"},{"key":"e_1_3_2_2_19_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2015.7113278"},{"key":"e_1_3_2_2_20_1","unstructured":"Django Software Foundation. 2021. Django. https:\/\/www.djangoproject.com"},{"key":"e_1_3_2_2_21_1","doi-asserted-by":"publisher","DOI":"10.1007\/s11390-020--9700--5"},{"key":"e_1_3_2_2_22_1","unstructured":"Double Chain Tech. 2021. SCM Biz Suite. https:\/\/github.com\/doublechaintech\/scm-biz-suite"},{"key":"e_1_3_2_2_23_1","doi-asserted-by":"publisher","DOI":"10.1145\/360363.360369"},{"key":"e_1_3_2_2_24_1","unstructured":"FIT2CLOUD. 2021. JumpServer. https:\/\/github.com\/jumpserver\/jumpserver"},{"key":"e_1_3_2_2_25_1","doi-asserted-by":"publisher","DOI":"10.1145\/38714.38742"},{"key":"e_1_3_2_2_26_1","doi-asserted-by":"publisher","DOI":"10.1145\/50202.50206"},{"key":"e_1_3_2_2_27_1","volume-title":"Proceedings of The BTW 2007 conference on Database Systems in Business,Technology and Web (BTW '07)","author":"Graefe Goetz","year":"2007","unstructured":"Goetz Graefe. 2007. Hierarchical locking in B-tree indexes. In Proceedings of The BTW 2007 conference on Database Systems in Business,Technology and Web (BTW '07), Alfons Kemper, Harald Sch\u00f6ning, Thomas Rose, Matthias Jarke, Thomas Seidl, Christoph Quix, and Christoph Brochhaus (Eds.). Gesellschaft f\u00fcr Informatik e. V., Bonn, 18--42. https:\/\/dl.gi.de\/20.500.12116\/31818"},{"key":"e_1_3_2_2_28_1","doi-asserted-by":"publisher","DOI":"10.1145\/2463676.2465325"},{"key":"e_1_3_2_2_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/356842.356847"},{"key":"e_1_3_2_2_30_1","doi-asserted-by":"publisher","DOI":"10.1145\/1282480.1282513"},{"key":"e_1_3_2_2_31_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICST.2013.19"},{"key":"e_1_3_2_2_32_1","doi-asserted-by":"publisher","DOI":"10.1145\/2491411.2491412"},{"key":"e_1_3_2_2_33_1","unstructured":"The PostgreSQL Global Development Group. 2021. PostgreSQL 13.3 Documentation."},{"key":"e_1_3_2_2_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/3369736"},{"key":"e_1_3_2_2_35_1","doi-asserted-by":"publisher","DOI":"10.1145\/77643.77647"},{"key":"e_1_3_2_2_36_1","doi-asserted-by":"publisher","DOI":"10.14778\/3377369.3377373"},{"key":"e_1_3_2_2_37_1","doi-asserted-by":"publisher","DOI":"10.1145\/582318.582340"},{"key":"e_1_3_2_2_38_1","doi-asserted-by":"publisher","DOI":"10.1145\/319566.319567"},{"key":"e_1_3_2_2_39_1","unstructured":"Jean-Philippe Lang. 2021. Redmine. https:\/\/github.com\/redmine\/redmine"},{"key":"e_1_3_2_2_40_1","doi-asserted-by":"publisher","DOI":"10.1109\/69.485643"},{"key":"e_1_3_2_2_41_1","doi-asserted-by":"publisher","DOI":"10.14778\/2831360.2831368"},{"key":"e_1_3_2_2_42_1","volume-title":"Proceedings of the 2014 USENIX Annual Technical Conference (Philadelphia, PA, USA) (USENIX ATC '14), Garth Gibson and Nickolai Zeldovich (Eds.). USENIX Association, USA, 281--292","author":"Li Cheng","year":"2014","unstructured":"Cheng Li, Jo\u00e3o Leit\u00e3o, Allen Clement, Nuno M. Pregui\u00e7a, Rodrigo Rodrigues, and Viktor Vafeiadis. 2014. Automating the Choice of Consistency Levels in Replicated Systems. In Proceedings of the 2014 USENIX Annual Technical Conference (Philadelphia, PA, USA) (USENIX ATC '14), Garth Gibson and Nickolai Zeldovich (Eds.). USENIX Association, USA, 281--292."},{"key":"e_1_3_2_2_43_1","doi-asserted-by":"publisher","DOI":"10.5555\/2387880.2387906"},{"key":"e_1_3_2_2_44_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2004.1319981"},{"key":"e_1_3_2_2_45_1","doi-asserted-by":"publisher","DOI":"10.1145\/2168836.2168855"},{"key":"e_1_3_2_2_46_1","unstructured":"Microsoft. 2020. Table Hints (Transact-SQL). https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/queries\/hints-transact-sql-table?view=sql-server-ver15"},{"key":"e_1_3_2_2_47_1","unstructured":"Microsoft. 2021. Remarks on SET TRANSACTION ISOLATION LEVEL (Transact-SQL). Microsoft. https:\/\/docs.microsoft.com\/en-us\/sql\/t-sql\/statements\/set-transaction-isolation-level-transact-sql?view=sql-server-ver15#remarks"},{"key":"e_1_3_2_2_48_1","unstructured":"Vlad Mihalcea. 2015. High-Performance Java Persistence. Vlad Mihalcea Romania."},{"key":"e_1_3_2_2_49_1","volume-title":"Karel Maesen, Radim Vansa, and Louis Jacomet.","author":"Mihalcea Vlad","year":"2021","unstructured":"Vlad Mihalcea, Steve Ebersole, Andrea Boriero, Gunnar Morling, Gail Badner, Chris Cranford, Emmanuel Bernard, Sanne Grinovero, Brett Meyer, Hardy Ferentschik, Gavin King, Christian Bauer, Max Rydahl Andersen, Karel Maesen, Radim Vansa, and Louis Jacomet. 2021. Hibernate ORM 5.5.7.Final User Guide. Red Hat. https:\/\/docs.jboss.org\/hibernate\/orm\/5.5\/userguide\/html_single\/Hibernate_User_Guide.html"},{"key":"e_1_3_2_2_50_1","volume-title":"Proceedings of the 16th International Conference on Very Large Data Bases (VLDB '90)","author":"Mohan C.","year":"1990","unstructured":"C. Mohan. 1990. ARIES\/KVL: A Key-Value Locking Method for Concurrency Control of Multiaction Transactions Operating on B-Tree Indexes. In Proceedings of the 16th International Conference on Very Large Data Bases (VLDB '90). Morgan Kaufmann Publishers Inc., San Francisco, CA, USA, 392--405."},{"key":"e_1_3_2_2_51_1","doi-asserted-by":"publisher","DOI":"10.1145\/128765.128770"},{"key":"e_1_3_2_2_52_1","doi-asserted-by":"publisher","DOI":"10.1145\/130283.130338"},{"key":"e_1_3_2_2_53_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2749436"},{"key":"e_1_3_2_2_54_1","unstructured":"OASIS Web Services Transaction (WS-TX) TC. 2009. Web Services Atomic Transaction (WS-AtomicTransaction). OASIS. https:\/\/docs.oasis-open.org\/ws-tx\/wsat\/2006\/06"},{"key":"e_1_3_2_2_55_1","unstructured":"OASIS Web Services Transaction (WS-TX) TC. 2009. Web Services Coordination (WS-Coordination). OASIS. https:\/\/docs.oasis-open.org\/ws-tx\/wscoor\/2006\/06"},{"key":"e_1_3_2_2_56_1","doi-asserted-by":"publisher","DOI":"10.1145\/7239.7265"},{"key":"e_1_3_2_2_57_1","unstructured":"Oracle. 2020. MySQL 8.0 Reference Manual (Including MySQL NDB Cluster 8.0)."},{"key":"e_1_3_2_2_58_1","doi-asserted-by":"publisher","DOI":"10.1145\/1066116.1189038"},{"key":"e_1_3_2_2_59_1","unstructured":"Project Concerto. 2021. API controller did not implement order version check. https:\/\/github.com\/spree\/spree\/issues\/10748"},{"key":"e_1_3_2_2_60_1","unstructured":"Project Concerto. 2021. Crash while processing payments leads to unexpected behavior. https:\/\/github.com\/spree\/spree\/issues\/10744"},{"key":"e_1_3_2_2_61_1","unstructured":"Project Concerto. 2021. Implementation issue in order lock. https:\/\/github.com\/spree\/spree\/issues\/10697"},{"key":"e_1_3_2_2_62_1","unstructured":"Project Concerto. 2021. Mixing Active Record & mini_sql leads to unexpected behavior. https:\/\/meta.discourse.org\/t\/mixing-active-record-mini-sql-leads-to-unexpected-behavior\/176504"},{"key":"e_1_3_2_2_63_1","unstructured":"Project Concerto. 2021. A more efficient Redis lock. https:\/\/meta.discourse.org\/t\/a-more-efficient-redis-lock\/177841"},{"key":"e_1_3_2_2_64_1","unstructured":"Project Concerto. 2021. Race condition in downsize_upload script. https:\/\/meta.discourse.org\/t\/race-condition-in-downsize-upload-script\/177152"},{"key":"e_1_3_2_2_65_1","unstructured":"Project Concerto. 2021. Redis lock's TTL may leads to potential bugs. https:\/\/github.com\/tootsuite\/mastodon\/issues\/15645"},{"key":"e_1_3_2_2_66_1","unstructured":"Project Concerto. 2021. Session order lock may be discarded unexpectedly. https:\/\/github.com\/BroadleafCommerce\/BroadleafCommerce\/issues\/2555"},{"key":"e_1_3_2_2_67_1","unstructured":"Project Concerto. 2021. Sku inconsistent caused by concurrent checkout. https:\/\/github.com\/BroadleafCommerce\/BroadleafCommerce\/issues\/2472"},{"key":"e_1_3_2_2_68_1","volume-title":"Proceedings of the 14th International Conference on Very Large Data Bases (VLDB '88)","author":"Pu Calton","unstructured":"Calton Pu, Gail E. Kaiser, and Norman C. Hutchinson. 1988. Split-Transactions for Open-Ended Activities. In Proceedings of the 14th International Conference on Very Large Data Bases (VLDB '88). Morgan Kaufmann Publishers Inc., San Francisco, CA, USA, 26--37."},{"key":"e_1_3_2_2_69_1","unstructured":"Rails Core Team. 2021. Active Record. https:\/\/guides.rubyonrails.org\/active_record_basics.html"},{"key":"e_1_3_2_2_70_1","unstructured":"Rails Core Team. 2021. Ruby on Rails. https:\/\/rubyonrails.org"},{"key":"e_1_3_2_2_71_1","unstructured":"Red Hat. 2021. Hibernate ORM. https:\/\/hibernate.org\/orm\/"},{"key":"e_1_3_2_2_72_1","doi-asserted-by":"publisher","DOI":"10.5555\/645911.671118"},{"key":"e_1_3_2_2_73_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882958"},{"key":"e_1_3_2_2_74_1","unstructured":"Eugen Rochko. 2019. Comments on commit a359be23. https:\/\/github.com\/mastodon\/mastodon\/pull\/4642\/commits\/a359be23a3c26fe7a824ce9bb0f1faaaac3d02b6#r134231414"},{"key":"e_1_3_2_2_75_1","unstructured":"Eugen Rochko and other Mastodon contributors. 2021. Mastodon. https:\/\/github.com\/mastodon\/mastodon"},{"key":"e_1_3_2_2_76_1","unstructured":"Sam Saffron. 2015. A reply on Edit of rebaked post doesn't show in HTML; only in raw. https:\/\/meta.discourse.org\/t\/edit-of-rebaked-post-doesnt-show-in-html-only-in-raw\/33815\/6"},{"key":"e_1_3_2_2_77_1","unstructured":"Saleor Commerce. 2021. Saleor Commerce. https:\/\/github.com\/saleor\/saleor"},{"key":"e_1_3_2_2_78_1","doi-asserted-by":"publisher","DOI":"10.1007\/978--3--642--24550--3_29"},{"key":"e_1_3_2_2_79_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-540-89856-6_3"},{"key":"e_1_3_2_2_80_1","unstructured":"A. Silberschatz H.F. Korth and S. Sudarshan. 2011. Database System Concepts. McGraw-Hill New York NY USA."},{"key":"e_1_3_2_2_81_1","unstructured":"Spree Commerce. 2021. Spree Commerce. https:\/\/spreecommerce.org"},{"key":"e_1_3_2_2_82_1","doi-asserted-by":"publisher","DOI":"10.1145\/2517349.2522713"},{"key":"e_1_3_2_2_83_1","doi-asserted-by":"publisher","DOI":"10.1145\/3035918.3064037"},{"key":"e_1_3_2_2_84_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2915202"},{"key":"e_1_3_2_2_85_1","doi-asserted-by":"publisher","DOI":"10.5555\/1924943.1924955"},{"key":"e_1_3_2_2_86_1","unstructured":"X\/Open. 1991. Distributed Transaction Processing: The XA Specification."},{"key":"e_1_3_2_2_87_1","doi-asserted-by":"publisher","DOI":"10.1145\/3132847.3132954"},{"key":"e_1_3_2_2_88_1","doi-asserted-by":"publisher","DOI":"10.1145\/3180155.3180194"},{"key":"e_1_3_2_2_89_1","doi-asserted-by":"publisher","DOI":"10.1145\/3236024.3264589"},{"key":"e_1_3_2_2_90_1","unstructured":"Philip Z. 2021. Comments on issue 17 (in Chinese). https:\/\/github.com\/doublechaintech\/scm-biz-suite\/issues\/17"},{"key":"e_1_3_2_2_91_1","unstructured":"Xiaodong Zhang. 2021. The synchronized used to prevent concurrency doesn't work as expected (in Chinese). https:\/\/github.com\/doublechaintech\/scm-biz-suite\/issues\/17"}],"event":{"name":"SIGMOD\/PODS '22: International Conference on Management of Data","location":"Philadelphia PA USA","acronym":"SIGMOD\/PODS '22","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the 2022 International Conference on Management of Data"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526120","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3514221.3526120","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,17]],"date-time":"2025-06-17T18:10:07Z","timestamp":1750183807000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3514221.3526120"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,6,10]]},"references-count":91,"alternative-id":["10.1145\/3514221.3526120","10.1145\/3514221"],"URL":"https:\/\/doi.org\/10.1145\/3514221.3526120","relation":{},"subject":[],"published":{"date-parts":[[2022,6,10]]},"assertion":[{"value":"2022-06-11","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}