{"id":"https://openalex.org/W2119843648","doi":"https://doi.org/10.1145/1142473.1142512","title":"Recovery from \"bad\" user transactions","display_name":"Recovery from \"bad\" user transactions","publication_year":2006,"publication_date":"2006-06-27","ids":{"openalex":"https://openalex.org/W2119843648","doi":"https://doi.org/10.1145/1142473.1142512","mag":"2119843648"},"language":"en","primary_location":{"id":"doi:10.1145/1142473.1142512","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142473.1142512","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2006 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/A5009686443","display_name":"David Lomet","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"David Lomet","raw_affiliation_strings":["Microsoft Research, Redmond, WA"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5090568937","display_name":"Zografoula Vagena","orcid":null},"institutions":[{"id":"https://openalex.org/I103635307","display_name":"University of California, Riverside","ror":"https://ror.org/03nawhv43","country_code":"US","type":"education","lineage":["https://openalex.org/I103635307"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zografoula Vagena","raw_affiliation_strings":["Univ. of California Riverside, Riverside, CA"],"affiliations":[{"raw_affiliation_string":"Univ. of California Riverside, Riverside, CA","institution_ids":["https://openalex.org/I103635307"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5089941827","display_name":"Roger Barga","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Roger Barga","raw_affiliation_strings":["Microsoft Research, Redmond, WA"],"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5009686443"],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":4.4101,"has_fulltext":false,"cited_by_count":34,"citation_normalized_percentile":{"value":0.94888863,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"337","last_page":"346"},"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9995999932289124,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.998199999332428,"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/backup","display_name":"Backup","score":0.8968448638916016},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.8058829307556152},{"id":"https://openalex.org/keywords/commit","display_name":"Commit","score":0.7933260202407837},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7788540124893188},{"id":"https://openalex.org/keywords/compensating-transaction","display_name":"Compensating transaction","score":0.7662529945373535},{"id":"https://openalex.org/keywords/distributed-transaction","display_name":"Distributed transaction","score":0.7647290229797363},{"id":"https://openalex.org/keywords/transaction-log","display_name":"Transaction log","score":0.7289092540740967},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.6556603312492371},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.6171686053276062},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6132526397705078},{"id":"https://openalex.org/keywords/nested-transaction","display_name":"Nested transaction","score":0.5643563866615295},{"id":"https://openalex.org/keywords/backup-software","display_name":"Backup software","score":0.5311784744262695},{"id":"https://openalex.org/keywords/process","display_name":"Process (computing)","score":0.5295292735099792},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.48425886034965515},{"id":"https://openalex.org/keywords/transaction-processing-system","display_name":"Transaction processing system","score":0.47507423162460327},{"id":"https://openalex.org/keywords/rollback","display_name":"Rollback","score":0.44799935817718506},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.21989256143569946}],"concepts":[{"id":"https://openalex.org/C2780945871","wikidata":"https://www.wikidata.org/wiki/Q194274","display_name":"Backup","level":2,"score":0.8968448638916016},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.8058829307556152},{"id":"https://openalex.org/C153180980","wikidata":"https://www.wikidata.org/wiki/Q19776675","display_name":"Commit","level":2,"score":0.7933260202407837},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7788540124893188},{"id":"https://openalex.org/C155951066","wikidata":"https://www.wikidata.org/wiki/Q5156254","display_name":"Compensating transaction","level":5,"score":0.7662529945373535},{"id":"https://openalex.org/C25185021","wikidata":"https://www.wikidata.org/wiki/Q4053284","display_name":"Distributed transaction","level":4,"score":0.7647290229797363},{"id":"https://openalex.org/C2212953","wikidata":"https://www.wikidata.org/wiki/Q948454","display_name":"Transaction log","level":3,"score":0.7289092540740967},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.6556603312492371},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.6171686053276062},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6132526397705078},{"id":"https://openalex.org/C137180784","wikidata":"https://www.wikidata.org/wiki/Q6997825","display_name":"Nested transaction","level":5,"score":0.5643563866615295},{"id":"https://openalex.org/C503016453","wikidata":"https://www.wikidata.org/wiki/Q4839801","display_name":"Backup software","level":3,"score":0.5311784744262695},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.5295292735099792},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.48425886034965515},{"id":"https://openalex.org/C11354467","wikidata":"https://www.wikidata.org/wiki/Q953487","display_name":"Transaction processing system","level":4,"score":0.47507423162460327},{"id":"https://openalex.org/C174220543","wikidata":"https://www.wikidata.org/wiki/Q395307","display_name":"Rollback","level":3,"score":0.44799935817718506},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.21989256143569946}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/1142473.1142512","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1142473.1142512","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2006 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.91.8647","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.91.8647","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.ucf.edu/~kienhua/classes/COP6730/transaction1.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":12,"referenced_works":["https://openalex.org/W1517870510","https://openalex.org/W1545155892","https://openalex.org/W1589223644","https://openalex.org/W1698229348","https://openalex.org/W2020592463","https://openalex.org/W2104954161","https://openalex.org/W2117034946","https://openalex.org/W2149833616","https://openalex.org/W2154322583","https://openalex.org/W2162064942","https://openalex.org/W4236976055","https://openalex.org/W6637704273"],"related_works":["https://openalex.org/W2123909466","https://openalex.org/W170089733","https://openalex.org/W590454891","https://openalex.org/W2051530389","https://openalex.org/W2119843648","https://openalex.org/W2186504310","https://openalex.org/W1988072050","https://openalex.org/W2122254813","https://openalex.org/W2211850419","https://openalex.org/W2158759608"],"abstract_inverted_index":{"User":[0],"written":[1,120],"transaction":[2,95],"code":[3],"is":[4,60,131],"responsible":[5],"for":[6,139],"the":[7,14,21,64,112,122,142],"\"C\"":[8],"in":[9,44,80,87],"ACID":[10],"transactions,":[11,69],"i.e.,":[12],"taking":[13],"database":[15,83],"from":[16],"one":[17],"consistent":[18],"state":[19],"to":[20,31,136],"next.":[22],"However,":[23],"user":[24],"transactions":[25,97,116],"can":[26],"be":[27,73,137],"flawed":[28,94,123],"and":[29,54,63,96,107],"lead":[30],"inconsistent":[32],"(or":[33],"invalid)":[34],"states.":[35],"Database":[36],"systems":[37],"usually":[38],"correct":[39],"invalid":[40],"data":[41,90,110,119],"using":[42],"\"point":[43],"time\"":[45],"recovery,":[46],"a":[47,52,85,93],"costly":[48],"process":[49,105],"that":[50,132],"installs":[51],"backup":[53,134],"rolls":[55],"it":[56],"forward.":[57],"The":[58],"result":[59],"long":[61],"outages":[62],"\"de-commit\"":[65],"of":[66,114,128],"many":[67],"valid":[68],"which":[70,88],"must":[71],"then":[72],"re-submitted,":[74],"frequently":[75],"manually.":[76],"We":[77],"have":[78],"implemented":[79],"our":[81,129],"transaction-time":[82,144],"system":[84],"technique":[86],"only":[89],"tainted":[91,109],"by":[92,121],"dependent":[98,117],"upon":[99],"its":[100],"updates":[101],"are":[102],"\"removed\".":[103],"This":[104],"identifies":[106],"quarantines":[108],"despite":[111],"complication":[113],"determining":[115],"on":[118],"transaction.":[124],"A":[125],"further":[126],"property":[127],"implementation":[130],"no":[133],"needs":[135],"installed":[138],"this":[140],"because":[141],"prior":[143],"states":[145],"provide":[146],"an":[147],"online":[148],"backup.":[149]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":3},{"year":2013,"cited_by_count":3}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}