{"id":"https://openalex.org/W4394923485","doi":"https://doi.org/10.1145/3627703.3650080","title":"Validating Database System Isolation Level Implementations with Version Certificate Recovery","display_name":"Validating Database System Isolation Level Implementations with Version Certificate Recovery","publication_year":2024,"publication_date":"2024-04-18","ids":{"openalex":"https://openalex.org/W4394923485","doi":"https://doi.org/10.1145/3627703.3650080"},"language":"en","primary_location":{"id":"doi:10.1145/3627703.3650080","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3627703.3650080","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":"Proceedings of the Nineteenth European Conference on Computer Systems","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://doi.org/10.1145/3627703.3650080","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5082532678","display_name":"Jack Clark","orcid":"https://orcid.org/0000-0003-3886-7657"},"institutions":[{"id":"https://openalex.org/I47508984","display_name":"Imperial College London","ror":"https://ror.org/041kmwe10","country_code":"GB","type":"education","lineage":["https://openalex.org/I47508984"]}],"countries":["GB"],"is_corresponding":true,"raw_author_name":"Jack Clark","raw_affiliation_strings":["Imperial College London"],"affiliations":[{"raw_affiliation_string":"Imperial College London","institution_ids":["https://openalex.org/I47508984"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5080781439","display_name":"Alastair F. Donaldson","orcid":"https://orcid.org/0000-0002-7448-7961"},"institutions":[{"id":"https://openalex.org/I47508984","display_name":"Imperial College London","ror":"https://ror.org/041kmwe10","country_code":"GB","type":"education","lineage":["https://openalex.org/I47508984"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Alastair F. Donaldson","raw_affiliation_strings":["Imperial College London"],"affiliations":[{"raw_affiliation_string":"Imperial College London","institution_ids":["https://openalex.org/I47508984"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5002846450","display_name":"John Wickerson","orcid":"https://orcid.org/0000-0001-6735-5533"},"institutions":[{"id":"https://openalex.org/I47508984","display_name":"Imperial College London","ror":"https://ror.org/041kmwe10","country_code":"GB","type":"education","lineage":["https://openalex.org/I47508984"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"John Wickerson","raw_affiliation_strings":["Imperial College London"],"affiliations":[{"raw_affiliation_string":"Imperial College London","institution_ids":["https://openalex.org/I47508984"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5066738024","display_name":"Manuel Rigger","orcid":"https://orcid.org/0000-0001-8303-2099"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Manuel Rigger","raw_affiliation_strings":["National University of Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore","institution_ids":["https://openalex.org/I165932596"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5082532678"],"corresponding_institution_ids":["https://openalex.org/I47508984"],"apc_list":null,"apc_paid":null,"fwci":2.175,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.87635428,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"754","last_page":"768"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":1.0,"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":1.0,"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.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"}},{"id":"https://openalex.org/T11424","display_name":"Security and Verification in Computing","score":0.9873999953269958,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/computer-science","display_name":"Computer science","score":0.8730090856552124},{"id":"https://openalex.org/keywords/serialization","display_name":"Serialization","score":0.7016599774360657},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5528035163879395},{"id":"https://openalex.org/keywords/isolation","display_name":"Isolation (microbiology)","score":0.5508036613464355},{"id":"https://openalex.org/keywords/concurrency-control","display_name":"Concurrency control","score":0.47394728660583496},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.46808677911758423},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.44813331961631775},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.3935343325138092}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8730090856552124},{"id":"https://openalex.org/C52723943","wikidata":"https://www.wikidata.org/wiki/Q1127410","display_name":"Serialization","level":2,"score":0.7016599774360657},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5528035163879395},{"id":"https://openalex.org/C2775941552","wikidata":"https://www.wikidata.org/wiki/Q25212305","display_name":"Isolation (microbiology)","level":2,"score":0.5508036613464355},{"id":"https://openalex.org/C84511453","wikidata":"https://www.wikidata.org/wiki/Q2914952","display_name":"Concurrency control","level":3,"score":0.47394728660583496},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.46808677911758423},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.44813331961631775},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.3935343325138092},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"score":0.0},{"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.1145/3627703.3650080","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3627703.3650080","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":"Proceedings of the Nineteenth European Conference on Computer Systems","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3627703.3650080","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3627703.3650080","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":"Proceedings of the Nineteenth European Conference on Computer Systems","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W1987358714","https://openalex.org/W1991199257","https://openalex.org/W1993505169","https://openalex.org/W1997354355","https://openalex.org/W1999035602","https://openalex.org/W2016432059","https://openalex.org/W2023304911","https://openalex.org/W2040856861","https://openalex.org/W2076627572","https://openalex.org/W2117780839","https://openalex.org/W2117917070","https://openalex.org/W2138474070","https://openalex.org/W2139285682","https://openalex.org/W2152812436","https://openalex.org/W2186001977","https://openalex.org/W2293215590","https://openalex.org/W2328249030","https://openalex.org/W2394555589","https://openalex.org/W2516402643","https://openalex.org/W2604961016","https://openalex.org/W2911450990","https://openalex.org/W2919742489","https://openalex.org/W2964715982","https://openalex.org/W2979942385","https://openalex.org/W2999082198","https://openalex.org/W3031917602","https://openalex.org/W3042605769","https://openalex.org/W3085924233","https://openalex.org/W3096427810","https://openalex.org/W3099032206","https://openalex.org/W3106731144","https://openalex.org/W4206512216","https://openalex.org/W4231141358","https://openalex.org/W4256473085","https://openalex.org/W4384345711","https://openalex.org/W6677979303"],"related_works":["https://openalex.org/W2167689506","https://openalex.org/W1567707405","https://openalex.org/W2348172073","https://openalex.org/W2121941088","https://openalex.org/W2096756691","https://openalex.org/W2104731798","https://openalex.org/W2280852004","https://openalex.org/W1566490931","https://openalex.org/W2032677704","https://openalex.org/W2802956903"],"abstract_inverted_index":{"Transactions":[0],"are":[1,59],"a":[2,42,47,112,121,158,191,201],"key":[3,92],"feature":[4],"of":[5,14,111,123,145,204],"database":[6,33,103,134,177],"systems":[7,104],"and":[8,65,73,128,156,180,230],"isolation":[9,26,49,75,109],"levels":[10],"specify":[11],"the":[12,70,108,125,133,143,152,195],"behavior":[13,21],"concurrently":[15],"executing":[16],"transactions.":[17],"Ensuring":[18],"their":[19],"correct":[20],"is":[22,94,99,186],"crucial.":[23],"Recently,":[24],"many":[25,162],"anomalies":[27],"have":[28,168],"been":[29],"found":[30],"in":[31,62],"production":[32],"systems.":[34],"Checkers":[35],"can":[36,220,235],"be":[37,226],"used":[38,176],"to":[39,46,95,105,154,207],"validate":[40],"that":[41,98,184,217,224,233],"particular":[43],"execution":[44],"conforms":[45],"desired":[48],"level.":[50],"However,":[51],"state-of-the-art":[52,192],"checkers":[53],"cannot":[54,225],"handle":[55],"predicate":[56,213],"operations,":[57],"which":[58,150],"both":[60],"common":[61],"real-world":[63],"workloads":[64],"essential":[66],"for":[67,161,173],"distinguishing":[68],"between":[69],"repeatable":[71],"read":[72],"serializable":[74,163],"levels.":[76],"In":[77],"this":[78,82],"work,":[79],"we":[80,140,199],"address":[81],"issue":[83],"by":[84,102,228,241],"proposing":[85],"an":[86,146,242],"efficient":[87],"white-box":[88],"checker,":[89],"Emme.":[90],"Our":[91],"idea":[93],"use":[96],"information":[97],"easily":[100],"provided":[101],"efficiently":[106],"check":[107],"level":[110],"given":[113],"transaction":[114],"history.":[115],"We":[116,167,182,215],"present":[117],"version":[118,126,131,159,170],"certificate":[119,160,171],"recovery,":[120],"method":[122],"recovering":[124],"order":[127],"each":[129],"operation's":[130],"from":[132],"system":[135],"under":[136],"test.":[137],"For":[138],"efficiency,":[139],"also":[141,231],"propose":[142],"concept":[144],"expected":[147,196],"serialization":[148,197],"order,":[149,198],"obviates":[151],"need":[153],"define":[155],"recover":[157],"concurrency":[164],"control":[165],"protocols.":[166],"implemented":[169],"recovery":[172],"three":[174],"widely":[175],"systems---PostgreSQL,":[178],"CockroachDB,":[179],"TiDB.":[181],"demonstrate":[183],"Emme":[185,208],"1.2-3.6\u00d7":[187],"faster":[188],"than":[189],"Elle,":[190],"checker.":[193],"Using":[194],"obtain":[200],"further":[202],"speedup":[203],"34-430\u00d7":[205],"compared":[206],"when":[209],"checking":[210],"histories":[211,223],"containing":[212],"operations.":[214],"show":[216,232],"our":[218],"approach":[219],"identify":[221],"invalid":[222],"detected":[227],"Elle":[229],"it":[234],"find":[236],"realistic":[237],"bugs":[238],"purposely":[239],"introduced":[240],"engineer.":[243]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":1}],"updated_date":"2026-03-13T16:22:10.518609","created_date":"2025-10-10T00:00:00"}