{"id":"https://openalex.org/W3032843849","doi":"https://doi.org/10.1145/3318464.3389714","title":"Long-lived Transactions Made Less Harmful","display_name":"Long-lived Transactions Made Less Harmful","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W3032843849","doi":"https://doi.org/10.1145/3318464.3389714","mag":"3032843849"},"language":"en","primary_location":{"id":"doi:10.1145/3318464.3389714","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3318464.3389714","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-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/A5101920870","display_name":"Jongbin Kim","orcid":"https://orcid.org/0000-0002-0182-842X"},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":true,"raw_author_name":"Jongbin Kim","raw_affiliation_strings":["Hanyang University, Seoul, South Korea"],"affiliations":[{"raw_affiliation_string":"Hanyang University, Seoul, South Korea","institution_ids":["https://openalex.org/I4575257"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5062457999","display_name":"Hyunsoo Cho","orcid":"https://orcid.org/0000-0003-2651-6403"},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Hyunsoo Cho","raw_affiliation_strings":["Hanyang University, Seoul, South Korea"],"affiliations":[{"raw_affiliation_string":"Hanyang University, Seoul, South Korea","institution_ids":["https://openalex.org/I4575257"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024168353","display_name":"Kihwang Kim","orcid":null},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Kihwang Kim","raw_affiliation_strings":["Hanyang University, Seoul, South Korea"],"affiliations":[{"raw_affiliation_string":"Hanyang University, Seoul, South Korea","institution_ids":["https://openalex.org/I4575257"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005974088","display_name":"Jaeseon Yu","orcid":null},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Jaeseon Yu","raw_affiliation_strings":["Hanyang University, Seoul, South Korea"],"affiliations":[{"raw_affiliation_string":"Hanyang University, Seoul, South Korea","institution_ids":["https://openalex.org/I4575257"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5059925471","display_name":"Sooyong Kang","orcid":"https://orcid.org/0000-0002-5332-7846"},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Sooyong Kang","raw_affiliation_strings":["Hanyang University, Seoul, South Korea"],"affiliations":[{"raw_affiliation_string":"Hanyang University, Seoul, South Korea","institution_ids":["https://openalex.org/I4575257"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5034858357","display_name":"Hyungsoo Jung","orcid":"https://orcid.org/0000-0002-5376-7200"},"institutions":[{"id":"https://openalex.org/I4575257","display_name":"Hanyang University","ror":"https://ror.org/046865y68","country_code":"KR","type":"education","lineage":["https://openalex.org/I4575257"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Hyungsoo Jung","raw_affiliation_strings":["Hanyang University, Seoul, South Korea"],"affiliations":[{"raw_affiliation_string":"Hanyang University, Seoul, South Korea","institution_ids":["https://openalex.org/I4575257"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5101920870"],"corresponding_institution_ids":["https://openalex.org/I4575257"],"apc_list":null,"apc_paid":null,"fwci":1.2334,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.80880526,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"495","last_page":"510"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9990000128746033,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9990000128746033,"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/computer-science","display_name":"Computer science","score":0.7821553945541382},{"id":"https://openalex.org/keywords/software-versioning","display_name":"Software versioning","score":0.618689775466919},{"id":"https://openalex.org/keywords/garbage-collection","display_name":"Garbage collection","score":0.5549114346504211},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5331807732582092},{"id":"https://openalex.org/keywords/snapshot","display_name":"Snapshot (computer storage)","score":0.5261477828025818},{"id":"https://openalex.org/keywords/concurrency","display_name":"Concurrency","score":0.5132372379302979},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.5103082060813904},{"id":"https://openalex.org/keywords/garbage","display_name":"Garbage","score":0.48174619674682617},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.4578288197517395},{"id":"https://openalex.org/keywords/heap","display_name":"Heap (data structure)","score":0.4279450476169586},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.34807297587394714},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.3266971707344055},{"id":"https://openalex.org/keywords/software","display_name":"Software","score":0.15408045053482056}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7821553945541382},{"id":"https://openalex.org/C198140048","wikidata":"https://www.wikidata.org/wiki/Q10859422","display_name":"Software versioning","level":3,"score":0.618689775466919},{"id":"https://openalex.org/C105122174","wikidata":"https://www.wikidata.org/wiki/Q322202","display_name":"Garbage collection","level":3,"score":0.5549114346504211},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5331807732582092},{"id":"https://openalex.org/C55282118","wikidata":"https://www.wikidata.org/wiki/Q252683","display_name":"Snapshot (computer storage)","level":2,"score":0.5261477828025818},{"id":"https://openalex.org/C193702766","wikidata":"https://www.wikidata.org/wiki/Q1414548","display_name":"Concurrency","level":2,"score":0.5132372379302979},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.5103082060813904},{"id":"https://openalex.org/C75403996","wikidata":"https://www.wikidata.org/wiki/Q5521979","display_name":"Garbage","level":2,"score":0.48174619674682617},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.4578288197517395},{"id":"https://openalex.org/C134757568","wikidata":"https://www.wikidata.org/wiki/Q274089","display_name":"Heap (data structure)","level":2,"score":0.4279450476169586},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.34807297587394714},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.3266971707344055},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.15408045053482056},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3318464.3389714","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3318464.3389714","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":27,"referenced_works":["https://openalex.org/W1483819513","https://openalex.org/W1963674762","https://openalex.org/W1986479133","https://openalex.org/W1996931099","https://openalex.org/W2011395086","https://openalex.org/W2014977566","https://openalex.org/W2018464987","https://openalex.org/W2020129682","https://openalex.org/W2116436709","https://openalex.org/W2117917070","https://openalex.org/W2118995439","https://openalex.org/W2128841495","https://openalex.org/W2133384222","https://openalex.org/W2141710443","https://openalex.org/W2172197636","https://openalex.org/W2265888380","https://openalex.org/W2294111665","https://openalex.org/W2423891596","https://openalex.org/W2441046553","https://openalex.org/W2571118757","https://openalex.org/W2773419540","https://openalex.org/W2948329914","https://openalex.org/W2948526913","https://openalex.org/W2982402713","https://openalex.org/W4237407586","https://openalex.org/W4293763691","https://openalex.org/W4298468057"],"related_works":["https://openalex.org/W2132258996","https://openalex.org/W2524496484","https://openalex.org/W2147299991","https://openalex.org/W2098868378","https://openalex.org/W2101464091","https://openalex.org/W2245694847","https://openalex.org/W1700460898","https://openalex.org/W4250131244","https://openalex.org/W2148255588","https://openalex.org/W4297378365"],"abstract_inverted_index":{"Many":[0],"systems":[1],"use":[2],"snapshot":[3],"isolation,":[4],"or":[5],"something":[6],"similar,":[7],"as":[8],"defaults,":[9],"and":[10,54,82,110,147,152],"multi-version":[11],"concurrency":[12],"control":[13],"(MVCC)":[14],"remains":[15],"essential":[16],"to":[17,59,70,164],"offering":[18],"such":[19,103],"point-in-time":[20],"consistency.":[21],"One":[22],"major":[23],"issue":[24],"in":[25,38,171],"MVCC":[26],"is":[27],"the":[28,39,49,159,166,172],"timely":[29],"removal":[30],"of":[31,34,41,52,63,113,145,168,174],"unnecessary":[32,80],"versions":[33,51,90,170],"data":[35],"items,":[36],"especially":[37],"presence":[40],"long-lived":[42],"transactions":[43],"(LLTs).":[44],"We":[45,141],"have":[46],"observed":[47],"that":[48,67,126,158],"latest":[50],"MySQL":[53],"PostgreSQL":[55],"are":[56],"still":[57],"vulnerable":[58],"LLTs.":[60],"Our":[61],"analysis":[62],"existing":[64],"proposals":[65],"suggests":[66],"new":[68,121,133],"solutions":[69],"this":[71,99],"matter":[72],"must":[73],"provide":[74],"rigorous":[75],"rules":[76,104],"for":[77,85,92,119],"completely":[78],"identifying":[79],"versions,":[81],"elaborate":[83],"designs":[84],"version":[86,107,111,122],"cleaning":[87],"lest":[88],"old":[89],"required":[91],"LLTs":[93,175],"should":[94],"suspend":[95],"garbage":[96],"collection.":[97],"In":[98],"paper,":[100],"we":[101],"formalize":[102],"into":[105],"our":[106,120],"pruning":[108],"theorem":[109],"classification,":[112],"which":[114],"all":[115],"form":[116],"theoretical":[117],"foundations":[118],"management":[123],"system,":[124],"vDriver,":[125],"bases":[127],"its":[128],"record":[129],"versioning":[130],"on":[131],"a":[132,143],"principle:":[134],"Single":[135],"In-row":[136],"Remaining":[137],"Off-row":[138],"(SIRO)":[139],"versioning.":[140],"implemented":[142],"prototype":[144],"vDriver":[146],"integrated":[148],"it":[149],"with":[150,161,180],"MySQL-8.0":[151],"PostgreSQL-12.0.":[153],"The":[154],"experimental":[155],"evaluation":[156],"demonstrated":[157],"engines":[160],"Driver":[162],"continue":[163],"perform":[165],"reclamation":[167],"dead":[169],"face":[173],"while":[176],"retaining":[177],"transaction":[178],"throughput":[179],"reduced":[181],"space":[182],"consumption.":[183]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}