{"id":"https://openalex.org/W3033164579","doi":"https://doi.org/10.1145/3401071.3401656","title":"Automated tuning of query degree of parallelism via machine learning","display_name":"Automated tuning of query degree of parallelism via machine learning","publication_year":2020,"publication_date":"2020-06-03","ids":{"openalex":"https://openalex.org/W3033164579","doi":"https://doi.org/10.1145/3401071.3401656","mag":"3033164579"},"language":"en","primary_location":{"id":"doi:10.1145/3401071.3401656","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3401071.3401656","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","raw_type":"proceedings-article"},"type":"conference-paper","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/A5102017677","display_name":"Zhiwei Fan","orcid":"https://orcid.org/0009-0009-5940-1101"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zhiwei Fan","raw_affiliation_strings":["University of Wisconsin-Madison"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061137265","display_name":"Rathijit Sen","orcid":"https://orcid.org/0000-0003-4736-2837"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Rathijit Sen","raw_affiliation_strings":["Microsoft Gray Systems Lab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Gray Systems Lab","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5040506752","display_name":"Paraschos Koutris","orcid":"https://orcid.org/0000-0001-6309-1702"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Paraschos Koutris","raw_affiliation_strings":["University of Wisconsin-Madison"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5050593520","display_name":"Aws Albarghouthi","orcid":"https://orcid.org/0000-0003-4577-175X"},"institutions":[{"id":"https://openalex.org/I135310074","display_name":"University of Wisconsin\u2013Madison","ror":"https://ror.org/01y2jtd41","country_code":"US","type":"education","lineage":["https://openalex.org/I135310074"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Aws Albarghouthi","raw_affiliation_strings":["University of Wisconsin-Madison"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Wisconsin-Madison","institution_ids":["https://openalex.org/I135310074"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.1709,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.74656536,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":97},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"4"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991000294685364,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9991000294685364,"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/T11106","display_name":"Data Management and Algorithms","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9969000220298767,"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.9118987321853638},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7592558860778809},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.6606270670890808},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.6577876806259155},{"id":"https://openalex.org/keywords/parallelism","display_name":"Parallelism (grammar)","score":0.6260862350463867},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.5597883462905884},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.5464337468147278},{"id":"https://openalex.org/keywords/degree","display_name":"Degree (music)","score":0.4364001154899597},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.43585720658302307},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.4288901686668396},{"id":"https://openalex.org/keywords/task-parallelism","display_name":"Task parallelism","score":0.41518640518188477},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.39342576265335083},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2934260368347168},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.29067695140838623},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.1838054060935974}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.9118987321853638},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7592558860778809},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.6606270670890808},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.6577876806259155},{"id":"https://openalex.org/C2781172179","wikidata":"https://www.wikidata.org/wiki/Q853109","display_name":"Parallelism (grammar)","level":2,"score":0.6260862350463867},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.5597883462905884},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.5464337468147278},{"id":"https://openalex.org/C2775997480","wikidata":"https://www.wikidata.org/wiki/Q586277","display_name":"Degree (music)","level":2,"score":0.4364001154899597},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.43585720658302307},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.4288901686668396},{"id":"https://openalex.org/C42992933","wikidata":"https://www.wikidata.org/wiki/Q691169","display_name":"Task parallelism","level":3,"score":0.41518640518188477},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.39342576265335083},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2934260368347168},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.29067695140838623},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.1838054060935974},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C24890656","wikidata":"https://www.wikidata.org/wiki/Q82811","display_name":"Acoustics","level":1,"score":0.0},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3401071.3401656","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3401071.3401656","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the Third International Workshop on Exploiting Artificial Intelligence Techniques for Data Management","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5,"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W2081728040","https://openalex.org/W2100773341","https://openalex.org/W2944240329","https://openalex.org/W2970148517","https://openalex.org/W3099273181","https://openalex.org/W6641330010"],"related_works":["https://openalex.org/W2096359267","https://openalex.org/W3125756434","https://openalex.org/W2006459955","https://openalex.org/W2901901036","https://openalex.org/W1560919561","https://openalex.org/W203907944","https://openalex.org/W1986746529","https://openalex.org/W2150741898","https://openalex.org/W2072123157","https://openalex.org/W185198413"],"abstract_inverted_index":{"Determining":[0],"the":[1,42,54],"degree":[2],"of":[3,10,44,98],"parallelism":[4],"(DOP)":[5],"for":[6,59,107],"query":[7,28,31,60,71],"execution":[8,61],"is":[9,62],"great":[11],"importance":[12],"to":[13,27,89],"both":[14,70],"performance":[15,32,72],"and":[16,30,65,73],"resource":[17],"provisioning.":[18],"However,":[19],"recent":[20],"work":[21],"that":[22,52,68],"applies":[23],"machine":[24],"learning":[25],"(ML)":[26],"optimization":[29],"prediction":[33],"in":[34],"relational":[35],"database":[36],"management":[37],"systems":[38],"(RDBMSs)":[39],"has":[40],"ignored":[41],"effect":[43],"intra-query":[45],"parallelism.":[46],"In":[47],"this":[48],"work,":[49],"we":[50,100],"argue":[51],"determining":[53],"optimal":[55],"or":[56],"near-optimal":[57],"DOP":[58,91],"a":[63,96],"fundamental":[64],"challenging":[66],"task":[67],"benefits":[69],"cost-benefit":[74],"tradeoffs.":[75],"We":[76,93],"then":[77],"present":[78],"promising":[79],"preliminary":[80],"results":[81],"on":[82],"how":[83],"ML":[84],"techniques":[85],"can":[86],"be":[87],"applied":[88],"automate":[90],"tuning.":[92],"conclude":[94],"with":[95],"list":[97],"challenges":[99],"encountered,":[101],"as":[102,104],"well":[103],"future":[105],"directions":[106],"our":[108],"work.":[109]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":3},{"year":2020,"cited_by_count":1}],"updated_date":"2026-07-29T14:22:42.915294","created_date":"2025-10-10T00:00:00"}