{"id":"https://openalex.org/W1996737572","doi":"https://doi.org/10.1145/1559845.1559950","title":"Compensation-aware data types in RDBMS","display_name":"Compensation-aware data types in RDBMS","publication_year":2009,"publication_date":"2009-06-29","ids":{"openalex":"https://openalex.org/W1996737572","doi":"https://doi.org/10.1145/1559845.1559950","mag":"1996737572"},"language":"en","primary_location":{"id":"doi:10.1145/1559845.1559950","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559950","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 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/A5011967774","display_name":"Aravind Yalamanchi","orcid":null},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Aravind Yalamanchi","raw_affiliation_strings":["Oracle USA, Nashua, NH, USA","Oracle USA, Nashua, NH, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Nashua, NH, USA","institution_ids":[]},{"raw_affiliation_string":"Oracle USA, Nashua, NH, USA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5007788082","display_name":"Dieter Gawlick","orcid":"https://orcid.org/0000-0002-7882-0565"},"institutions":[{"id":"https://openalex.org/I1342911587","display_name":"Oracle (United States)","ror":"https://ror.org/006c77m33","country_code":"US","type":"company","lineage":["https://openalex.org/I1342911587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dieter Gawlick","raw_affiliation_strings":["Oracle USA, Redwood City, CA, USA","Oracle USA, Redwood City, CA, USA#TAB#"],"affiliations":[{"raw_affiliation_string":"Oracle USA, Redwood City, CA, USA","institution_ids":["https://openalex.org/I1342911587"]},{"raw_affiliation_string":"Oracle USA, Redwood City, CA, USA#TAB#","institution_ids":["https://openalex.org/I1342911587"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":["https://openalex.org/A5011967774"],"corresponding_institution_ids":["https://openalex.org/I1342911587"],"apc_list":null,"apc_paid":null,"fwci":0.7243,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.72489196,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"931","last_page":"938"},"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.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"}},"topics":[{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","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.9993000030517578,"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/T11719","display_name":"Data Quality and Management","score":0.9921000003814697,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/atomicity","display_name":"Atomicity","score":0.8799973726272583},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8602586984634399},{"id":"https://openalex.org/keywords/distributed-transaction","display_name":"Distributed transaction","score":0.6845715641975403},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.613059401512146},{"id":"https://openalex.org/keywords/relational-database-management-system","display_name":"Relational database management system","score":0.6061235070228577},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.5571460723876953},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.5308125019073486},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4881914258003235},{"id":"https://openalex.org/keywords/compensating-transaction","display_name":"Compensating transaction","score":0.48764100670814514},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4568297863006592},{"id":"https://openalex.org/keywords/consistency","display_name":"Consistency (knowledge bases)","score":0.42817315459251404},{"id":"https://openalex.org/keywords/transaction-data","display_name":"Transaction data","score":0.41347092390060425},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3653903603553772},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.2707706689834595}],"concepts":[{"id":"https://openalex.org/C188045909","wikidata":"https://www.wikidata.org/wiki/Q3306359","display_name":"Atomicity","level":3,"score":0.8799973726272583},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8602586984634399},{"id":"https://openalex.org/C25185021","wikidata":"https://www.wikidata.org/wiki/Q4053284","display_name":"Distributed transaction","level":4,"score":0.6845715641975403},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.613059401512146},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.6061235070228577},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.5571460723876953},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.5308125019073486},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4881914258003235},{"id":"https://openalex.org/C155951066","wikidata":"https://www.wikidata.org/wiki/Q5156254","display_name":"Compensating transaction","level":5,"score":0.48764100670814514},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4568297863006592},{"id":"https://openalex.org/C2776436953","wikidata":"https://www.wikidata.org/wiki/Q5163215","display_name":"Consistency (knowledge bases)","level":2,"score":0.42817315459251404},{"id":"https://openalex.org/C127722929","wikidata":"https://www.wikidata.org/wiki/Q7833714","display_name":"Transaction data","level":3,"score":0.41347092390060425},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3653903603553772},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.2707706689834595},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1559845.1559950","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1559845.1559950","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2009 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.169.1522","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.169.1522","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.it.usyd.edu.au/%7Edbrg/wp-content/papers/SIGMOD/2009/p931-yalamanchi.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.902.7264","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.902.7264","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"https://www.researchgate.net/profile/Dieter_Gawlick/publication/221214307_Compensation-aware_data_types_in_RDBMS/links/543fb3410cf21227a11ac2cf.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Peace, Justice and strong institutions","score":0.4300000071525574,"id":"https://metadata.un.org/sdg/16"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W11669818","https://openalex.org/W61387815","https://openalex.org/W1525098045","https://openalex.org/W1525343879","https://openalex.org/W1545155892","https://openalex.org/W1975637639","https://openalex.org/W1986925088","https://openalex.org/W2109464129","https://openalex.org/W2152505375","https://openalex.org/W2154045335","https://openalex.org/W2597608265","https://openalex.org/W4206210947","https://openalex.org/W4251283131"],"related_works":["https://openalex.org/W2731282421","https://openalex.org/W590454891","https://openalex.org/W579270350","https://openalex.org/W2123909466","https://openalex.org/W2427525016","https://openalex.org/W107499463","https://openalex.org/W2350726838","https://openalex.org/W2090136942","https://openalex.org/W2018479316","https://openalex.org/W1585382547"],"abstract_inverted_index":{"In":[0],"a":[1,122,134],"traditional":[2],"database":[3,113],"system,":[4],"the":[5,14,40,43,97,112,118,125,158,194,199,214],"transaction":[6,25,123],"management":[7,26],"protocols":[8],"and":[9,21,35,53,70,87,103,110,124,143,197,217],"mechanisms":[10],"are":[11,168],"constrained":[12],"by":[13,55,153,171],"fundamental":[15],"properties":[16,31],"of":[17,42,74,93],"atomicity,":[18],"consistency,":[19],"isolation,":[20],"durability":[22],"(ACID).":[23],"A":[24],"system":[27,114],"with":[28,177,189],"strict":[29],"ACID":[30],"typically":[32],"employs":[33],"read":[34,102],"write":[36],"locks,":[37],"held":[38],"for":[39,64,81,99,111,221],"duration":[41],"transaction,":[44],"to":[45,101,115,120,127,146,150,208],"protect":[46],"its":[47],"uncommitted":[48,106,191],"data":[49,107,152,166,184,196],"from":[50,129],"being":[51],"seen":[52],"modified":[54,159],"some":[56],"other":[57,190],"transaction.":[58],"While":[59],"this":[60,162],"approach":[61,220],"is":[62,78,96,187],"effective":[63],"applications":[65,82,95],"involving":[66],"short":[67],"execution":[68],"times":[69],"relatively":[71],"small":[72],"number":[73],"concurrent":[75],"operations,":[76],"it":[77],"too":[79],"restrictive":[80],"that":[83,138,182,198],"involve":[84],"reactive,":[85],"long-lived,":[86],"complex":[88],"transactions.":[89],"The":[90],"common":[91,151],"denominator":[92],"such":[94],"need":[98],"transactions":[100,145],"possibly":[104],"modify":[105],"values":[108],"[1]":[109],"still":[116],"retain":[117],"ability":[119,126],"abort":[121],"recover":[128],"failures.":[130],"This":[131,211],"paper":[132,212],"proposes":[133],"Business":[135],"Transaction":[136],"framework":[137],"allows":[139],"long":[140],"lasting,":[141],"discontinuous,":[142],"resumable":[144],"perform":[147],"shared":[148,174,223],"updates":[149,224],"holding":[154],"semantic":[155],"locks":[156],"on":[157,193],"rows.":[160],"Under":[161],"framework,":[163],"basic":[164],"SQL":[165],"types":[167],"made":[169],"compensation-aware":[170],"associating":[172],"domain-specific":[173],"update":[175],"semantics":[176,180],"them.":[178],"These":[179],"ensure":[181],"each":[183],"modification":[185],"operation":[186,200],"compatible":[188],"activity":[192],"same":[195],"can":[201],"be":[202],"undone,":[203],"if":[204],"needed,":[205],"without":[206],"resorting":[207],"cascading":[209],"aborts.":[210],"describes":[213],"key":[215],"concepts":[216],"presents":[218],"our":[219],"supporting":[222],"in":[225],"Oracle":[226],"RDBMS.":[227]},"counts_by_year":[{"year":2014,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}