{"id":"https://openalex.org/W4205381461","doi":"https://doi.org/10.14778/3485450.3485456","title":"A learned query rewrite system using Monte Carlo tree search","display_name":"A learned query rewrite system using Monte Carlo tree search","publication_year":2021,"publication_date":"2021-09-01","ids":{"openalex":"https://openalex.org/W4205381461","doi":"https://doi.org/10.14778/3485450.3485456"},"language":"en","primary_location":{"id":"doi:10.14778/3485450.3485456","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3485450.3485456","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-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/A5056912386","display_name":"Xuanhe Zhou","orcid":"https://orcid.org/0000-0002-2285-7836"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xuanhe Zhou","raw_affiliation_strings":["Tsinghua University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100404163","display_name":"Guoliang Li","orcid":"https://orcid.org/0000-0003-1601-6640"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guoliang Li","raw_affiliation_strings":["Tsinghua University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101797040","display_name":"Chengliang Chai","orcid":"https://orcid.org/0000-0001-8080-5594"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Chengliang Chai","raw_affiliation_strings":["Tsinghua University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5100951661","display_name":"Jianhua Feng","orcid":null},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jianhua Feng","raw_affiliation_strings":["Tsinghua University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Tsinghua University","institution_ids":["https://openalex.org/I99065089"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I99065089"],"apc_list":null,"apc_paid":null,"fwci":5.2003,"has_fulltext":false,"cited_by_count":58,"citation_normalized_percentile":{"value":0.96233773,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":99,"max":100},"biblio":{"volume":"15","issue":"1","first_page":"46","last_page":"58"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12072","display_name":"Machine Learning and Algorithms","score":0.9955000281333923,"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"}},"topics":[{"id":"https://openalex.org/T12072","display_name":"Machine Learning and Algorithms","score":0.9955000281333923,"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/T10028","display_name":"Topic Modeling","score":0.9933000206947327,"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/T10181","display_name":"Natural Language Processing Techniques","score":0.9923999905586243,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7821780443191528},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7677791118621826},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.6679337024688721},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.598656177520752},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.5960648655891418},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.5737623572349548},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.53211909532547},{"id":"https://openalex.org/keywords/query-expansion","display_name":"Query expansion","score":0.5221205949783325},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.5106959939002991},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4950363039970398},{"id":"https://openalex.org/keywords/range-query","display_name":"Range query (database)","score":0.4859429597854614},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.4799778461456299},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.47376301884651184},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.46942952275276184},{"id":"https://openalex.org/keywords/search-tree","display_name":"Search tree","score":0.46688854694366455},{"id":"https://openalex.org/keywords/monte-carlo-tree-search","display_name":"Monte Carlo tree search","score":0.4565046429634094},{"id":"https://openalex.org/keywords/node","display_name":"Node (physics)","score":0.45060160756111145},{"id":"https://openalex.org/keywords/search-algorithm","display_name":"Search algorithm","score":0.30976033210754395},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.28831738233566284},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.26905733346939087},{"id":"https://openalex.org/keywords/monte-carlo-method","display_name":"Monte Carlo method","score":0.2573060691356659},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.198164165019989},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.1794142723083496},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.16576817631721497},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.09528079628944397}],"concepts":[{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7821780443191528},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7677791118621826},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.6679337024688721},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.598656177520752},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.5960648655891418},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.5737623572349548},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.53211909532547},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.5221205949783325},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.5106959939002991},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4950363039970398},{"id":"https://openalex.org/C136736807","wikidata":"https://www.wikidata.org/wiki/Q818943","display_name":"Range query (database)","level":5,"score":0.4859429597854614},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.4799778461456299},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.47376301884651184},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.46942952275276184},{"id":"https://openalex.org/C207024777","wikidata":"https://www.wikidata.org/wiki/Q621673","display_name":"Search tree","level":3,"score":0.46688854694366455},{"id":"https://openalex.org/C46149586","wikidata":"https://www.wikidata.org/wiki/Q11785332","display_name":"Monte Carlo tree search","level":3,"score":0.4565046429634094},{"id":"https://openalex.org/C62611344","wikidata":"https://www.wikidata.org/wiki/Q1062658","display_name":"Node (physics)","level":2,"score":0.45060160756111145},{"id":"https://openalex.org/C125583679","wikidata":"https://www.wikidata.org/wiki/Q755673","display_name":"Search algorithm","level":2,"score":0.30976033210754395},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.28831738233566284},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.26905733346939087},{"id":"https://openalex.org/C19499675","wikidata":"https://www.wikidata.org/wiki/Q232207","display_name":"Monte Carlo method","level":2,"score":0.2573060691356659},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.198164165019989},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.1794142723083496},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.16576817631721497},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.09528079628944397},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"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/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.0},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3485450.3485456","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3485450.3485456","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":44,"referenced_works":["https://openalex.org/W41554520","https://openalex.org/W1781117130","https://openalex.org/W1988504473","https://openalex.org/W2005731313","https://openalex.org/W2081728040","https://openalex.org/W2104829182","https://openalex.org/W2126316555","https://openalex.org/W2167978511","https://openalex.org/W2396309311","https://openalex.org/W2788561287","https://openalex.org/W2790625403","https://openalex.org/W2885801653","https://openalex.org/W2889503624","https://openalex.org/W2890276152","https://openalex.org/W2911540814","https://openalex.org/W2948513753","https://openalex.org/W2970148517","https://openalex.org/W2970851599","https://openalex.org/W2975054757","https://openalex.org/W2991530444","https://openalex.org/W2996500300","https://openalex.org/W2998249308","https://openalex.org/W2999324038","https://openalex.org/W3006978394","https://openalex.org/W3025775630","https://openalex.org/W3029535034","https://openalex.org/W3030387435","https://openalex.org/W3037027022","https://openalex.org/W3099273181","https://openalex.org/W3100925961","https://openalex.org/W3105457604","https://openalex.org/W3173850788","https://openalex.org/W3174465898","https://openalex.org/W3176153696","https://openalex.org/W3176434378","https://openalex.org/W3176550827","https://openalex.org/W3196849431","https://openalex.org/W3197917898","https://openalex.org/W3217092890","https://openalex.org/W6651775274","https://openalex.org/W6675782219","https://openalex.org/W6677916085","https://openalex.org/W6770828584","https://openalex.org/W6775572905"],"related_works":["https://openalex.org/W92686808","https://openalex.org/W1003283331","https://openalex.org/W2031915568","https://openalex.org/W2387583461","https://openalex.org/W132930353","https://openalex.org/W2607400785","https://openalex.org/W2123785547","https://openalex.org/W4327811054","https://openalex.org/W2593714645","https://openalex.org/W2978000411"],"abstract_inverted_index":{"Query":[0],"rewrite":[1,16,27,42,56,77,86,97,132,166],"transforms":[2],"a":[3,82,92,119,127,145,195,218],"SQL":[4,15],"query":[5,47,64,131,140,147],"into":[6],"an":[7,18],"equivalent":[8],"one":[9],"but":[10,111],"with":[11,60],"higher":[12],"performance.":[13,48,234],"However,":[14,49],"is":[17,70,137,144],"NP-hard":[19],"problem,":[20],"and":[21,66,68,88,141],"existing":[22,243],"approaches":[23],"adopt":[24],"heuristics":[25,31],"to":[26,73,85,153,162,170,176,186,198,231],"the":[28,37,46,50,61,75,115,135,138,155,159,164,178,183,189,200,210,224,233],"queries.":[29,104],"These":[30],"have":[32,99],"two":[33],"main":[34],"limitations.":[35],"First,":[36],"order":[38,84,230],"of":[39,53,63,117,204],"applying":[40],"different":[41,96,100,103],"rules":[43,67,98],"significantly":[44,241],"affects":[45],"search":[51,212,226],"space":[52],"all":[54],"possible":[55],"orders":[57],"grows":[58],"exponentially":[59],"number":[62],"operators":[65],"it":[69],"rather":[71],"hard":[72],"find":[74,163],"optimal":[76,165,190],"order.":[78],"Existing":[79,105],"methods":[80,106],"apply":[81],"pre-defined":[83],"queries":[87],"will":[89],"fall":[90],"in":[91,158,227,229],"local":[93],"optimum.":[94],"Second,":[95],"benefits":[101,116],"for":[102],"work":[107],"on":[108],"single":[109],"plans":[110],"cannot":[112],"effectively":[113],"estimate":[114,199],"rewriting":[118],"query.":[120,167],"To":[121],"address":[122],"these":[123],"challenges,":[124],"we":[125,193],"propose":[126,169,194,217],"policy":[128,160,179,184],"tree":[129,156,161,185,211,225],"based":[130],"framework,":[133],"where":[134],"root":[136],"input":[139],"each":[142,205],"node":[143],"rewritten":[146,206],"from":[148],"its":[149],"parent.":[150],"We":[151,168,215],"aim":[152],"explore":[154,177,223],"nodes":[157],"use":[171],"Monte":[172],"Carlo":[173],"Tree":[174],"Search":[175],"tree,":[180],"which":[181,208],"navigates":[182],"efficiently":[187],"get":[188],"node.":[191],"Moreover,":[192],"learning-based":[196],"model":[197],"expected":[201],"performance":[202],"improvement":[203],"query,":[207],"guides":[209],"more":[213],"accurately.":[214],"also":[216],"parallel":[219,228],"algorithm":[220],"that":[221,238],"can":[222],"improve":[232],"Experimental":[235],"results":[236],"showed":[237],"our":[239],"method":[240],"outperformed":[242],"approaches.":[244]},"counts_by_year":[{"year":2026,"cited_by_count":7},{"year":2025,"cited_by_count":11},{"year":2024,"cited_by_count":15},{"year":2023,"cited_by_count":17},{"year":2022,"cited_by_count":8}],"updated_date":"2026-07-17T09:13:05.818461","created_date":"2025-10-10T00:00:00"}