{"id":"https://openalex.org/W3176419577","doi":"https://doi.org/10.1145/3448016.3452754","title":"Demonstrating UDO: A Unified Approach for Optimizing Transaction Code, Physical Design, and System Parameters via Reinforcement Learning","display_name":"Demonstrating UDO: A Unified Approach for Optimizing Transaction Code, Physical Design, and System Parameters via Reinforcement Learning","publication_year":2021,"publication_date":"2021-06-09","ids":{"openalex":"https://openalex.org/W3176419577","doi":"https://doi.org/10.1145/3448016.3452754","mag":"3176419577"},"language":"en","primary_location":{"id":"doi:10.1145/3448016.3452754","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3448016.3452754","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3452754","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3452754","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5050681387","display_name":"Junxiong Wang","orcid":"https://orcid.org/0000-0001-6998-0711"},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Junxiong Wang","raw_affiliation_strings":["Cornell University, Ithaca, NY, USA"],"affiliations":[{"raw_affiliation_string":"Cornell University, Ithaca, NY, USA","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087259526","display_name":"Immanuel Trummer","orcid":"https://orcid.org/0000-0002-7203-2349"},"institutions":[{"id":"https://openalex.org/I205783295","display_name":"Cornell University","ror":"https://ror.org/05bnh6r87","country_code":"US","type":"education","lineage":["https://openalex.org/I205783295"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Immanuel Trummer","raw_affiliation_strings":["Cornell University, Ithaca, NY, USA"],"affiliations":[{"raw_affiliation_string":"Cornell University, Ithaca, NY, USA","institution_ids":["https://openalex.org/I205783295"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5058797341","display_name":"Debabrota Basu","orcid":"https://orcid.org/0000-0002-3204-2884"},"institutions":[{"id":"https://openalex.org/I4210138412","display_name":"Centre de recherche Inria Lille - Nord Europe","ror":"https://ror.org/04eej9726","country_code":"FR","type":"facility","lineage":["https://openalex.org/I1326498283","https://openalex.org/I4210138412"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Debabrota Basu","raw_affiliation_strings":["Scool, Inria Lille-Nord Europe, Lille, France"],"affiliations":[{"raw_affiliation_string":"Scool, Inria Lille-Nord Europe, Lille, France","institution_ids":["https://openalex.org/I4210138412"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5050681387"],"corresponding_institution_ids":["https://openalex.org/I205783295"],"apc_list":null,"apc_paid":null,"fwci":1.2802,"has_fulltext":true,"cited_by_count":10,"citation_normalized_percentile":{"value":0.8103074,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":90,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"2794","last_page":"2797"},"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.9976000189781189,"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.9976000189781189,"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.9940000176429749,"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.9922999739646912,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7954146862030029},{"id":"https://openalex.org/keywords/reinforcement-learning","display_name":"Reinforcement learning","score":0.6987945437431335},{"id":"https://openalex.org/keywords/benchmarking","display_name":"Benchmarking","score":0.6635399460792542},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.47232764959335327},{"id":"https://openalex.org/keywords/code","display_name":"Code (set theory)","score":0.46604788303375244},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4509229362010956},{"id":"https://openalex.org/keywords/point","display_name":"Point (geometry)","score":0.4260149300098419},{"id":"https://openalex.org/keywords/computer-engineering","display_name":"Computer engineering","score":0.3257289528846741},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.30364832282066345},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.08498361706733704}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7954146862030029},{"id":"https://openalex.org/C97541855","wikidata":"https://www.wikidata.org/wiki/Q830687","display_name":"Reinforcement learning","level":2,"score":0.6987945437431335},{"id":"https://openalex.org/C86251818","wikidata":"https://www.wikidata.org/wiki/Q816754","display_name":"Benchmarking","level":2,"score":0.6635399460792542},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.47232764959335327},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.46604788303375244},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4509229362010956},{"id":"https://openalex.org/C28719098","wikidata":"https://www.wikidata.org/wiki/Q44946","display_name":"Point (geometry)","level":2,"score":0.4260149300098419},{"id":"https://openalex.org/C113775141","wikidata":"https://www.wikidata.org/wiki/Q428691","display_name":"Computer engineering","level":1,"score":0.3257289528846741},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.30364832282066345},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08498361706733704},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.0},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.0},{"id":"https://openalex.org/C162853370","wikidata":"https://www.wikidata.org/wiki/Q39809","display_name":"Marketing","level":1,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3448016.3452754","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3448016.3452754","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3452754","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:HAL:hal-03446016v1","is_oa":false,"landing_page_url":"https://hal.science/hal-03446016","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"SIGMOD/PODS '21: International Conference on Management of Data, Jun 2021, Virtual Event, China. pp.2794-2797, ⟨10.1145/3448016.3452754⟩","raw_type":"Conference papers"},{"id":"pmh:oai:lilloa.univ-lille.fr:20.500.12210/57983","is_oa":true,"landing_page_url":null,"pdf_url":null,"source":{"id":"https://openalex.org/S4306402203","display_name":"LillOA (Universit\u00e9 de Lille (University Of Lille))","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210123514","host_organization_name":"Centre d'Etudes en Civilisations, Langues et Litt\u00e9ratures Etrang\u00e8res","host_organization_lineage":["https://openalex.org/I4210123514"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":{"id":"doi:10.1145/3448016.3452754","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3448016.3452754","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3448016.3452754","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2021 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G6894402473","display_name":null,"funder_award_id":"Fellowship","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8355866346","display_name":null,"funder_award_id":"IIS-1910830","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G848032724","display_name":null,"funder_award_id":"Science","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G8835807941","display_name":"III: Small: Regret-Bounded Query Evaluation via Reinforcement Learning","funder_award_id":"1910830","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3176419577.pdf","grobid_xml":"https://content.openalex.org/works/W3176419577.grobid-xml"},"referenced_works_count":8,"referenced_works":["https://openalex.org/W1997840820","https://openalex.org/W2145466803","https://openalex.org/W2165481122","https://openalex.org/W2236986911","https://openalex.org/W2889252017","https://openalex.org/W2970851599","https://openalex.org/W3095166039","https://openalex.org/W3139377883"],"related_works":["https://openalex.org/W4238897586","https://openalex.org/W435179959","https://openalex.org/W2619091065","https://openalex.org/W2059640416","https://openalex.org/W1490753184","https://openalex.org/W2284465472","https://openalex.org/W2291782699","https://openalex.org/W1993948687","https://openalex.org/W2011676020","https://openalex.org/W2000169967"],"abstract_inverted_index":{"UDO":[0,14,37,68,89,132,162],"is":[1],"a":[2,17,129,134,177],"versatile":[3],"tool":[4],"for":[5,11,85],"offline":[6],"tuning":[7,20],"of":[8,19,56,150,179],"database":[9,33],"systems":[10],"specific":[12],"workloads.":[13],"can":[15],"consider":[16],"variety":[18,178],"choices,":[21],"reaching":[22],"from":[23,81],"picking":[24],"transaction":[25],"code":[26],"variants":[27],"over":[28],"index":[29],"selections":[30],"up":[31],"to":[32,41,43,64,75,110,137,146],"system":[34],"parameter":[35,66],"tuning.":[36],"uses":[38,90,133],"reinforcement":[39,91],"learning":[40,92],"converge":[42],"near-optimal":[44],"configurations,":[45],"creating":[46],"and":[47,116,125,169,181],"evaluating":[48,156],"different":[49,65,121],"configurations":[50,122,157],"via":[51],"actual":[52],"query":[53],"executions":[54],"(instead":[55],"relying":[57],"on":[58,163,170],"simplifying":[59],"cost":[60],"models).":[61],"To":[62],"cater":[63],"types,":[67],"distinguishes":[69],"heavy":[70,87,182],"parameters":[71,183],"(which":[72],"are":[73,123],"expensive":[74,151],"change,":[76],"e.g.":[77],"physical":[78],"design":[79],"parameters)":[80],"light":[82,180],"parameters.":[83],"Specifically":[84],"optimizing":[86,176],"parameters,":[88],"algorithms":[93],"that":[94],"allow":[95],"delaying":[96],"the":[97,108,112,117,148],"point":[98,113],"at":[99],"which":[100,120],"reward":[101],"feedback":[102],"becomes":[103],"available.":[104],"This":[105],"gives":[106],"us":[107],"freedom":[109],"optimize":[111],"in":[114,119],"time":[115],"order":[118],"created":[124],"evaluated":[126],"(by":[127],"benchmarking":[128],"workload":[130],"sample).":[131],"cost-based":[135],"planner":[136],"minimize":[138],"configuration":[139],"switching":[140],"overheads.":[141],"For":[142],"instance,":[143],"it":[144],"aims":[145],"amortize":[147],"creation":[149],"data":[152],"structures":[153],"by":[154],"consecutively":[155],"using":[158],"them.":[159],"We":[160],"demonstrate":[161],"Postgres":[164],"as":[165,167,172,174],"well":[166,173],"MySQL":[168],"TPC-H":[171],"TPC-C,":[175],"concurrently.":[184]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":3},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":3}],"updated_date":"2026-04-10T15:06:20.359241","created_date":"2025-10-10T00:00:00"}