{"id":"https://openalex.org/W4411267048","doi":"https://doi.org/10.1145/3742465","title":"AWDIT: An Optimal Weak Database Isolation Tester","display_name":"AWDIT: An Optimal Weak Database Isolation Tester","publication_year":2025,"publication_date":"2025-06-10","ids":{"openalex":"https://openalex.org/W4411267048","doi":"https://doi.org/10.1145/3742465"},"language":"en","primary_location":{"id":"doi:10.1145/3742465","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3742465","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3742465","source":{"id":"https://openalex.org/S4210216081","display_name":"Proceedings of the ACM on Programming Languages","issn_l":"2475-1421","issn":["2475-1421"],"is_oa":true,"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Programming Languages","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"diamond","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3742465","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5118196328","display_name":"Lasse M\u00f8ldrup","orcid":null},"institutions":[{"id":"https://openalex.org/I204337017","display_name":"Aarhus University","ror":"https://ror.org/01aj84f44","country_code":"DK","type":"education","lineage":["https://openalex.org/I204337017"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Lasse M\u00f8ldrup","raw_affiliation_strings":["Aarhus University, Aarhus, Denmark"],"raw_orcid":"https://orcid.org/0009-0005-9670-7039","affiliations":[{"raw_affiliation_string":"Aarhus University, Aarhus, Denmark","institution_ids":["https://openalex.org/I204337017"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5022252401","display_name":"Andreas Pavlogiannis","orcid":"https://orcid.org/0000-0002-8943-0722"},"institutions":[{"id":"https://openalex.org/I204337017","display_name":"Aarhus University","ror":"https://ror.org/01aj84f44","country_code":"DK","type":"education","lineage":["https://openalex.org/I204337017"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Andreas Pavlogiannis","raw_affiliation_strings":["Aarhus University, Aarhus, Denmark"],"raw_orcid":"https://orcid.org/0000-0002-8943-0722","affiliations":[{"raw_affiliation_string":"Aarhus University, Aarhus, Denmark","institution_ids":["https://openalex.org/I204337017"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I204337017"],"apc_list":null,"apc_paid":null,"fwci":2.8636,"has_fulltext":true,"cited_by_count":5,"citation_normalized_percentile":{"value":0.90990229,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":98},"biblio":{"volume":"9","issue":"PLDI","first_page":"1540","last_page":"1564"},"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.9972000122070312,"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.9972000122070312,"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/T10743","display_name":"Software Testing and Debugging Techniques","score":0.9965999722480774,"subfield":{"id":"https://openalex.org/subfields/1712","display_name":"Software"},"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.996399998664856,"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/isolation","display_name":"Isolation (microbiology)","score":0.708126425743103},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5267816781997681},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5094030499458313},{"id":"https://openalex.org/keywords/biology","display_name":"Biology","score":0.09940776228904724},{"id":"https://openalex.org/keywords/bioinformatics","display_name":"Bioinformatics","score":0.03899100422859192}],"concepts":[{"id":"https://openalex.org/C2775941552","wikidata":"https://www.wikidata.org/wiki/Q25212305","display_name":"Isolation (microbiology)","level":2,"score":0.708126425743103},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5267816781997681},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5094030499458313},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.09940776228904724},{"id":"https://openalex.org/C60644358","wikidata":"https://www.wikidata.org/wiki/Q128570","display_name":"Bioinformatics","level":1,"score":0.03899100422859192}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3742465","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3742465","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3742465","source":{"id":"https://openalex.org/S4210216081","display_name":"Proceedings of the ACM on Programming Languages","issn_l":"2475-1421","issn":["2475-1421"],"is_oa":true,"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Programming Languages","raw_type":"journal-article"},{"id":"pmh:oai:pure.atira.dk:publications/429d942d-2900-4a36-8275-39e4f7b3e675","is_oa":true,"landing_page_url":"https://pure.au.dk/portal/en/publications/429d942d-2900-4a36-8275-39e4f7b3e675","pdf_url":"https://pure.au.dk/ws/files/470326109/AWDIT.pdf","source":null,"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"M\u00f8ldrup, L & Pavlogiannis, A 2025, 'AWDIT : An Optimal Weak Database Isolation Tester', Proceedings of the ACM on Programming Languages , vol. 9, 209, pp. 1540-1564. https://doi.org/10.1145/3742465","raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":{"id":"doi:10.1145/3742465","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3742465","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3742465","source":{"id":"https://openalex.org/S4210216081","display_name":"Proceedings of the ACM on Programming Languages","issn_l":"2475-1421","issn":["2475-1421"],"is_oa":true,"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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Programming Languages","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4834617424","display_name":null,"funder_award_id":"VIL42117","funder_id":"https://openalex.org/F4320310490","funder_display_name":"Villum Fonden"}],"funders":[{"id":"https://openalex.org/F4320310490","display_name":"Villum Fonden","ror":"https://ror.org/007ww2d15"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4411267048.pdf","grobid_xml":"https://content.openalex.org/works/W4411267048.grobid-xml"},"referenced_works_count":41,"referenced_works":["https://openalex.org/W1430872261","https://openalex.org/W1972332180","https://openalex.org/W1975840504","https://openalex.org/W1986463648","https://openalex.org/W2012001501","https://openalex.org/W2023304911","https://openalex.org/W2080658418","https://openalex.org/W2119887456","https://openalex.org/W2125930899","https://openalex.org/W2143725230","https://openalex.org/W2293215590","https://openalex.org/W2476146301","https://openalex.org/W2497521232","https://openalex.org/W2528919074","https://openalex.org/W2612808231","https://openalex.org/W2737641788","https://openalex.org/W2892948282","https://openalex.org/W2949910966","https://openalex.org/W2962998221","https://openalex.org/W2972926935","https://openalex.org/W2979942385","https://openalex.org/W2980176182","https://openalex.org/W2995880861","https://openalex.org/W3004616691","https://openalex.org/W3032865144","https://openalex.org/W3088538340","https://openalex.org/W3106247424","https://openalex.org/W3150160382","https://openalex.org/W3198655391","https://openalex.org/W3205847787","https://openalex.org/W4206512216","https://openalex.org/W4214567754","https://openalex.org/W4234066571","https://openalex.org/W4366660507","https://openalex.org/W4372258288","https://openalex.org/W4379512374","https://openalex.org/W4390605117","https://openalex.org/W4394653559","https://openalex.org/W4395113499","https://openalex.org/W4403223306","https://openalex.org/W6893178890"],"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":{"Database":[0],"isolation":[1,35,38,50,65,78,91,110,115,123,189,210,282],"is":[2,59,159,256,265,293],"a":[3,13,60,76,99,104,146,180,192,266],"formal":[4],"contract":[5],"concerning":[6],"the":[7,107,137,206,246,249,261,275,303,324],"level":[8,283],"of":[9,71,88,106,109,139,154,162,195,212,248,269,312],"data":[10],"consistency":[11],"that":[12,101,254,263,291],"database":[14,72,172,188],"provides":[15],"to":[16,21,47,75,82,119,128,152],"its":[17],"clients.":[18],"In":[19,80,174],"order":[20,81],"achieve":[22],"low":[23],"latency,":[24],"high":[25],"throughput,":[26],"and":[27,182,198,219,235,286,315,320],"partition":[28],"tolerance,":[29],"modern":[30],"databases":[31,43,84],"forgo":[32],"strong":[33,114],"transaction":[34],"for":[36,63,186,279,302,317],"weak":[37,122,171,187,209,281],"guarantees.":[39],"However,":[40,142],"several":[41],"production":[42],"have":[44,145],"been":[45,117],"found":[46],"suffer":[48],"from":[49],"bugs":[51],",":[52,259,272],"breaking":[53],"their":[54],"data-consistency":[55],"contract.":[56],"Black-box":[57],"testing":[58,113,140,151],"prominent":[61],"technique":[62],"detecting":[64],"bugs,":[66],"by":[67],"checking":[68],"whether":[69,203],"histories":[70],"transactions":[73],"adhere":[74],"prescribed":[77],"level.":[79],"test":[83,170],"on":[85,274],"realistic":[86],"workloads":[87,153],"large":[89,147],"size,":[90,157],"testers":[92,144],"must":[93],"be":[94,120,129],"as":[95,97],"efficient":[96],"possible,":[98],"requirement":[100],"has":[102,116,135],"initiated":[103],"study":[105],"complexity":[108],"testing.":[111],"Although":[112],"known":[118],"NP-complete,":[121],"levels":[124,211],"were":[125],"recently":[126],"shown":[127],"testable":[130],"in":[131,223,260],"polynomial":[132,148],"time,":[133],"which":[134,158],"propelled":[136],"scalability":[138],"tools.":[141],"existing":[143],"complexity,":[149],"restricting":[150],"only":[155],"moderate":[156],"not":[160],"typical":[161],"large-scale":[163],"databases.":[164],"How":[165],"efficiently":[166],"can":[167],"we":[168,177,252],"provably":[169,183],"isolation?":[173],"this":[175],"work,":[176],"develop":[178],"AWDIT,":[179],"highly-efficient":[181],"optimal":[184,258],"tester":[185],".":[190],"Given":[191],"history":[193],"H":[194,204],"size":[196],"n":[197,227,232,238,270],"k":[199,240],"sessions,":[200],"AWDIT":[201,255,292,307],"tests":[202],"satisfies":[205],"most":[207],"common":[208],"Read":[213,216],"Committed":[214],"(RC),":[215],"Atomic":[217],"(RA),":[218],"Causal":[220],"Consistency":[221],"(CC)":[222],"time":[224],"O":[225,230,236],"(":[226,231,237],"3/2":[228,233,271],"),":[229,234,241],"\u00b7":[239],"respectively,":[242,322],"improving":[243],"significantly":[244,294],"over":[245,323],"state":[247],"art.":[250],"Moreover,":[251],"prove":[253],"essentially":[257],"sense":[262],"there":[264],"lower":[267],"bound":[268],"based":[273],"combinatorial":[276],"BMM":[277],"hypothesis,":[278],"any":[280],"between":[284],"RC":[285],"CC.":[287],"Our":[288],"experiments":[289],"show":[290],"faster":[295],"than":[296],"existing,":[297],"highly":[298],"optimized":[299],"testers;":[300],"e.g.,":[301],"\u223c20\ufe6a":[304],"largest":[305],"histories,":[306],"obtains":[308],"an":[309],"average":[310],"speedup":[311],"245\u00d7,":[313],"193\u00d7,":[314],"62\u00d7":[316],"RC,":[318],"RA,":[319],"CC,":[321],"best":[325],"baseline.":[326]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":2}],"updated_date":"2026-08-25T07:29:55.448023","created_date":"2025-10-10T00:00:00"}