{"id":"https://openalex.org/W3029327553","doi":"https://doi.org/10.1145/3318464.3389704","title":"Learning a Partitioning Advisor for Cloud Databases","display_name":"Learning a Partitioning Advisor for Cloud Databases","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W3029327553","doi":"https://doi.org/10.1145/3318464.3389704","mag":"3029327553"},"language":"en","primary_location":{"id":"doi:10.1145/3318464.3389704","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3318464.3389704","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/A5065513658","display_name":"Benjamin Hilprecht","orcid":"https://orcid.org/0000-0003-4935-7118"},"institutions":[{"id":"https://openalex.org/I31512782","display_name":"Technical University of Darmstadt","ror":"https://ror.org/05n911h24","country_code":"DE","type":"education","lineage":["https://openalex.org/I31512782"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Benjamin Hilprecht","raw_affiliation_strings":["TU Darmstadt, Darmstadt, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TU Darmstadt, Darmstadt, Germany","institution_ids":["https://openalex.org/I31512782"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073504200","display_name":"Carsten Binnig","orcid":"https://orcid.org/0000-0002-2744-7836"},"institutions":[{"id":"https://openalex.org/I31512782","display_name":"Technical University of Darmstadt","ror":"https://ror.org/05n911h24","country_code":"DE","type":"education","lineage":["https://openalex.org/I31512782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Carsten Binnig","raw_affiliation_strings":["TU Darmstadt, Darmstadt, Germany"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TU Darmstadt, Darmstadt, Germany","institution_ids":["https://openalex.org/I31512782"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5110209646","display_name":"Uwe R\u00f6hm","orcid":null},"institutions":[{"id":"https://openalex.org/I129604602","display_name":"University of Sydney","ror":"https://ror.org/0384j8v12","country_code":"AU","type":"education","lineage":["https://openalex.org/I129604602"]}],"countries":["AU"],"is_corresponding":false,"raw_author_name":"Uwe R\u00f6hm","raw_affiliation_strings":["The University of Sydney, Sydney, Australia"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"The University of Sydney, Sydney, Australia","institution_ids":["https://openalex.org/I129604602"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5065513658"],"corresponding_institution_ids":["https://openalex.org/I31512782"],"apc_list":null,"apc_paid":null,"fwci":13.3636,"has_fulltext":false,"cited_by_count":62,"citation_normalized_percentile":{"value":0.98745346,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"143","last_page":"157"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9976999759674072,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9968000054359436,"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.8594328165054321},{"id":"https://openalex.org/keywords/cloud-computing","display_name":"Cloud computing","score":0.6894977688789368},{"id":"https://openalex.org/keywords/provisioning","display_name":"Provisioning","score":0.6604299545288086},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.6205291152000427},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.5995854139328003},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5743586421012878},{"id":"https://openalex.org/keywords/schema","display_name":"Schema (genetic algorithms)","score":0.4950522482395172},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.44564852118492126},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.42961984872817993},{"id":"https://openalex.org/keywords/database-administrator","display_name":"Database administrator","score":0.42630574107170105},{"id":"https://openalex.org/keywords/scheme","display_name":"Scheme (mathematics)","score":0.42379266023635864},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.41305190324783325},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.22658005356788635},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.18376222252845764},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.11426037549972534}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8594328165054321},{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.6894977688789368},{"id":"https://openalex.org/C172191483","wikidata":"https://www.wikidata.org/wiki/Q1071806","display_name":"Provisioning","level":2,"score":0.6604299545288086},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.6205291152000427},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.5995854139328003},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5743586421012878},{"id":"https://openalex.org/C52146309","wikidata":"https://www.wikidata.org/wiki/Q7431116","display_name":"Schema (genetic algorithms)","level":2,"score":0.4950522482395172},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.44564852118492126},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.42961984872817993},{"id":"https://openalex.org/C70236469","wikidata":"https://www.wikidata.org/wiki/Q1078262","display_name":"Database administrator","level":2,"score":0.42630574107170105},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.42379266023635864},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.41305190324783325},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.22658005356788635},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.18376222252845764},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.11426037549972534},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/3318464.3389704","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3318464.3389704","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"},{"id":"pmh:oai:tubiblio.ulb.tu-darmstadt.de:121557","is_oa":false,"landing_page_url":"http://tubiblio.ulb.tu-darmstadt.de/121557/","pdf_url":null,"source":{"id":"https://openalex.org/S4377196390","display_name":"TUbilio (Technical University of Darmstadt)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I31512782","host_organization_name":"Technische Universit\u00e4t Darmstadt","host_organization_lineage":["https://openalex.org/I31512782"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Konferenzver\u00f6ffentlichung"},{"id":"pmh:oai:tubiblio.ulb.tu-darmstadt.de:132216","is_oa":false,"landing_page_url":"http://tubiblio.ulb.tu-darmstadt.de/132216/","pdf_url":null,"source":{"id":"https://openalex.org/S4377196390","display_name":"TUbilio (Technical University of Darmstadt)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I31512782","host_organization_name":"Technische Universit\u00e4t Darmstadt","host_organization_lineage":["https://openalex.org/I31512782"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Konferenzver\u00f6ffentlichung"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":39,"referenced_works":["https://openalex.org/W1553825122","https://openalex.org/W1576035775","https://openalex.org/W1964144121","https://openalex.org/W1971885140","https://openalex.org/W2105252819","https://openalex.org/W2108094106","https://openalex.org/W2121863487","https://openalex.org/W2130617154","https://openalex.org/W2133741724","https://openalex.org/W2140342613","https://openalex.org/W2145339207","https://openalex.org/W2150630976","https://openalex.org/W2203529038","https://openalex.org/W2257979135","https://openalex.org/W2396309311","https://openalex.org/W2399175302","https://openalex.org/W2560592986","https://openalex.org/W2583754181","https://openalex.org/W2584555500","https://openalex.org/W2607264901","https://openalex.org/W2613136061","https://openalex.org/W2755385361","https://openalex.org/W2790625403","https://openalex.org/W2791195860","https://openalex.org/W2798504574","https://openalex.org/W2890276152","https://openalex.org/W2913631065","https://openalex.org/W2948513753","https://openalex.org/W2952332632","https://openalex.org/W2970148517","https://openalex.org/W2972067927","https://openalex.org/W2977038365","https://openalex.org/W2995787416","https://openalex.org/W3099158806","https://openalex.org/W3099273181","https://openalex.org/W4214717370","https://openalex.org/W6602325395","https://openalex.org/W6677916085","https://openalex.org/W6759199104"],"related_works":["https://openalex.org/W2888733525","https://openalex.org/W2379143279","https://openalex.org/W4246658255","https://openalex.org/W613932090","https://openalex.org/W2108441106","https://openalex.org/W2158831935","https://openalex.org/W4210881933","https://openalex.org/W2348698578","https://openalex.org/W13324341","https://openalex.org/W2350484003"],"abstract_inverted_index":{"Cloud":[0],"vendors":[1],"provide":[2],"ready-to-use":[3],"distributed":[4],"DBMS":[5,15],"solutions":[6],"as":[7,38],"a":[8,14,45,56,75,108],"service.":[9],"While":[10],"the":[11,34,79,90,94],"provisioning":[12],"of":[13,82,111],"is":[16,73,101],"usually":[17],"fully":[18],"automated,":[19],"customers":[20],"typically":[21],"still":[22],"have":[23],"to":[24,103],"make":[25],"important":[26],"design":[27],"decisions":[28],"which":[29],"were":[30],"traditionally":[31],"made":[32],"by":[33],"database":[35,47],"administrator":[36],"such":[37],"finding":[39],"an":[40],"optimal":[41],"partitioning":[42,59,84,91,120],"scheme":[43],"for":[44,67,107,118],"given":[46],"schema":[48],"and":[49,86,113],"workload.":[50],"In":[51,93],"this":[52],"paper,":[53],"we":[54,96],"introduce":[55],"new":[57],"learned":[58],"advisor":[60,100],"based":[61],"on":[62],"Deep":[63],"Reinforcement":[64],"Learning":[65],"(DRL)":[66],"OLAP-style":[68],"workloads.":[69],"The":[70],"main":[71],"idea":[72],"that":[74,98],"DRL":[76],"agent":[77],"learns":[78],"cost":[80],"tradeoffs":[81],"different":[83],"schemes":[85],"can":[87],"thus":[88],"automate":[89],"decision.":[92],"evaluation,":[95],"show":[97],"our":[99],"able":[102],"find":[104],"non-trivial":[105],"partitionings":[106],"wide":[109],"range":[110],"workloads":[112],"outperforms":[114],"more":[115],"classical":[116],"approaches":[117],"automated":[119],"design.":[121]},"counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":15},{"year":2022,"cited_by_count":16},{"year":2021,"cited_by_count":14},{"year":2020,"cited_by_count":3}],"updated_date":"2026-05-09T13:55:54.758798","created_date":"2025-10-10T00:00:00"}