{"id":"https://openalex.org/W4386768432","doi":"https://doi.org/10.14778/3611540.3611633","title":"A Learned Query Rewrite System","display_name":"A Learned Query Rewrite System","publication_year":2023,"publication_date":"2023-08-01","ids":{"openalex":"https://openalex.org/W4386768432","doi":"https://doi.org/10.14778/3611540.3611633"},"language":"en","primary_location":{"id":"doi:10.14778/3611540.3611633","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611540.3611633","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/A5100451576","display_name":"Guoliang Li","orcid":"https://orcid.org/0000-0002-1398-0621"},"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/A5108047851","display_name":"Jianming Wu","orcid":"https://orcid.org/0000-0002-6136-7469"},"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":"Jianming Wu","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/A5077653363","display_name":"Jiesi Liu","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":"Jiesi Liu","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/A5053352268","display_name":"Zhaoyan Sun","orcid":"https://orcid.org/0009-0000-2688-4981"},"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":"Zhaoyan Sun","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/A5028224364","display_name":"Xinning Zhang","orcid":"https://orcid.org/0000-0003-2763-1526"},"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":"Xinning Zhang","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":2.1056,"has_fulltext":false,"cited_by_count":12,"citation_normalized_percentile":{"value":0.87988791,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":97,"max":99},"biblio":{"volume":"16","issue":"12","first_page":"4110","last_page":"4113"},"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.996999979019165,"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.996999979019165,"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/T11986","display_name":"Scientific Computing and Data Management","score":0.9896000027656555,"subfield":{"id":"https://openalex.org/subfields/1802","display_name":"Information Systems and Management"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.987500011920929,"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/computer-science","display_name":"Computer science","score":0.8174223899841309},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.7087095379829407},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.6406749486923218},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.5683631896972656},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5566360950469971},{"id":"https://openalex.org/keywords/spatial-query","display_name":"Spatial query","score":0.5496231317520142},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.5367077589035034},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5173494219779968},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.47946369647979736},{"id":"https://openalex.org/keywords/oracle","display_name":"Oracle","score":0.4656636714935303},{"id":"https://openalex.org/keywords/web-query-classification","display_name":"Web query classification","score":0.4460068941116333},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.4410708248615265},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.42970746755599976},{"id":"https://openalex.org/keywords/result-set","display_name":"Result set","score":0.42719951272010803},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.42669740319252014},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.4184107482433319},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.41791653633117676},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2953299582004547},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2846333086490631},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.16707977652549744},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.15015169978141785}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8174223899841309},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.7087095379829407},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.6406749486923218},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.5683631896972656},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5566360950469971},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.5496231317520142},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.5367077589035034},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5173494219779968},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.47946369647979736},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.4656636714935303},{"id":"https://openalex.org/C118689300","wikidata":"https://www.wikidata.org/wiki/Q7978614","display_name":"Web query classification","level":4,"score":0.4460068941116333},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.4410708248615265},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.42970746755599976},{"id":"https://openalex.org/C4969071","wikidata":"https://www.wikidata.org/wiki/Q7316353","display_name":"Result set","level":3,"score":0.42719951272010803},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.42669740319252014},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.4184107482433319},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.41791653633117676},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2953299582004547},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2846333086490631},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.16707977652549744},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.15015169978141785},{"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/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3611540.3611633","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3611540.3611633","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":[{"id":"https://metadata.un.org/sdg/16","display_name":"Peace, Justice and strong institutions","score":0.5099999904632568}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W1781117130","https://openalex.org/W1988504473","https://openalex.org/W2503947316","https://openalex.org/W2788561287","https://openalex.org/W2889503624","https://openalex.org/W3025775630","https://openalex.org/W3100925961","https://openalex.org/W4205381461","https://openalex.org/W4281813636","https://openalex.org/W4282556381"],"related_works":["https://openalex.org/W2128834514","https://openalex.org/W2406556739","https://openalex.org/W4379390531","https://openalex.org/W2188347403","https://openalex.org/W4386123427","https://openalex.org/W2887264929","https://openalex.org/W2359365197","https://openalex.org/W2217632272","https://openalex.org/W3160252689","https://openalex.org/W1581079322"],"abstract_inverted_index":{"Query":[0],"rewriting":[1],"is":[2,22],"a":[3,8,98],"challenging":[4],"task":[5],"that":[6,102],"transforms":[7],"SQL":[9,26],"query":[10,52,99],"to":[11,24,57,67,116],"improve":[12],"its":[13,17],"performance":[14,79,133],"while":[15],"maintaining":[16],"result":[18],"set.":[19],"However,":[20],"it":[21,45],"difficult":[23],"rewrite":[25,39,58,73,100,117],"queries,":[27,43,59],"which":[28],"often":[29],"involve":[30],"complex":[31],"logical":[32],"structures,":[33],"and":[34,69,75,105,126],"there":[35],"are":[36],"numerous":[37],"candidate":[38],"strategies":[40],"for":[41],"such":[42],"making":[44],"an":[46],"NP-hard":[47],"problem.":[48],"Existing":[49],"databases":[50],"or":[51],"optimization":[53],"engines":[54],"adopt":[55],"heuristics":[56],"but":[60],"these":[61,93],"approaches":[62],"may":[63,76,87],"not":[64,88],"be":[65,89],"able":[66],"judiciously":[68],"adaptively":[70],"apply":[71],"the":[72,122],"rules":[74],"cause":[77],"significant":[78],"regression":[80],"in":[81,124],"some":[82],"cases":[83],"(e.g.,":[84],"correlated":[85],"subqueries":[86],"eliminated).":[90],"To":[91],"address":[92],"limitations,":[94],"we":[95],"introduce":[96],"LearnedRewrite,":[97],"system":[101,123],"combines":[103],"traditional":[104],"learned":[106],"algorithms":[107],"(i.e.,":[108],"Monte":[109],"Carlo":[110],"tree":[111],"search":[112],"+":[113],"hybrid":[114],"estimator)":[115],"queries.":[118],"We":[119],"have":[120],"implemented":[121],"Calcite,":[125],"experimental":[127],"results":[128],"demonstrate":[129],"LearnedRewrite":[130],"achieves":[131],"superior":[132],"on":[134],"three":[135],"real":[136],"datasets.":[137]},"counts_by_year":[{"year":2026,"cited_by_count":3},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":5}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}