{"id":"https://openalex.org/W7133718929","doi":"https://doi.org/10.48550/arxiv.2603.04169","title":"Efficient Query Rewrite Rule Discovery via Standardized Enumeration and Learning-to-Rank(extend)","display_name":"Efficient Query Rewrite Rule Discovery via Standardized Enumeration and Learning-to-Rank(extend)","publication_year":2026,"publication_date":"2026-03-04","ids":{"openalex":"https://openalex.org/W7133718929","doi":"https://doi.org/10.48550/arxiv.2603.04169"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2603.04169","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.04169","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2603.04169","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5128138375","display_name":"Yuan Zhang","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Zhang, Yuan","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5128193491","display_name":"Yuxing Chen","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chen, Yuxing","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5128155404","display_name":"Yuekun Yu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yu, Yuekun","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057053812","display_name":"Jinbin Huang","orcid":"https://orcid.org/0000-0002-8238-5439"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Huang, Jinbin","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5128157259","display_name":"Rui Mao","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mao, Rui","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001037413","display_name":"Anqun Pan","orcid":"https://orcid.org/0000-0002-6756-149X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Pan, Anqun","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066111929","display_name":"Lixiong Zheng","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zheng, Lixiong","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5128218661","display_name":"Jianbin Qin","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Qin, Jianbin","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5128138375"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"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.8019000291824341,"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.8019000291824341,"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/T11719","display_name":"Data Quality and Management","score":0.061400000005960464,"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"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.021800000220537186,"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/scalability","display_name":"Scalability","score":0.6777999997138977},{"id":"https://openalex.org/keywords/enumeration","display_name":"Enumeration","score":0.667900025844574},{"id":"https://openalex.org/keywords/ranking","display_name":"Ranking (information retrieval)","score":0.5888000130653381},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.5807999968528748},{"id":"https://openalex.org/keywords/rewriting","display_name":"Rewriting","score":0.49639999866485596},{"id":"https://openalex.org/keywords/rank","display_name":"Rank (graph theory)","score":0.44119998812675476},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.44040000438690186},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.4350999891757965},{"id":"https://openalex.org/keywords/node","display_name":"Node (physics)","score":0.3961000144481659}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7943999767303467},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.6777999997138977},{"id":"https://openalex.org/C156340839","wikidata":"https://www.wikidata.org/wiki/Q2704791","display_name":"Enumeration","level":2,"score":0.667900025844574},{"id":"https://openalex.org/C189430467","wikidata":"https://www.wikidata.org/wiki/Q7293293","display_name":"Ranking (information retrieval)","level":2,"score":0.5888000130653381},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.5807999968528748},{"id":"https://openalex.org/C154690210","wikidata":"https://www.wikidata.org/wiki/Q1668499","display_name":"Rewriting","level":2,"score":0.49639999866485596},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4657000005245209},{"id":"https://openalex.org/C164226766","wikidata":"https://www.wikidata.org/wiki/Q7293202","display_name":"Rank (graph theory)","level":2,"score":0.44119998812675476},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.44040000438690186},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.4350999891757965},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4146000146865845},{"id":"https://openalex.org/C62611344","wikidata":"https://www.wikidata.org/wiki/Q1062658","display_name":"Node (physics)","level":2,"score":0.3961000144481659},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.39399999380111694},{"id":"https://openalex.org/C82714645","wikidata":"https://www.wikidata.org/wiki/Q438331","display_name":"Template","level":2,"score":0.3684000074863434},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.3596999943256378},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.35010001063346863},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.33959999680519104},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.32350000739097595},{"id":"https://openalex.org/C172722865","wikidata":"https://www.wikidata.org/wiki/Q2302053","display_name":"Spatial query","level":5,"score":0.31299999356269836},{"id":"https://openalex.org/C86037889","wikidata":"https://www.wikidata.org/wiki/Q4330127","display_name":"Learning to rank","level":3,"score":0.3070000112056732},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.28769999742507935},{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.2847999930381775},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.2815999984741211},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.27489998936653137},{"id":"https://openalex.org/C136726353","wikidata":"https://www.wikidata.org/wiki/Q903789","display_name":"Disjunctive normal form","level":2,"score":0.2712000012397766},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.26980000734329224},{"id":"https://openalex.org/C193524817","wikidata":"https://www.wikidata.org/wiki/Q386780","display_name":"Association rule learning","level":2,"score":0.26429998874664307},{"id":"https://openalex.org/C120567893","wikidata":"https://www.wikidata.org/wiki/Q1582085","display_name":"Knowledge extraction","level":2,"score":0.2639999985694885},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.2535000145435333},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.25040000677108765},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.25}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2603.04169","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.04169","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2603.04169","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2603.04169","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"article"},"sustainable_development_goals":[{"display_name":"No poverty","score":0.43198537826538086,"id":"https://metadata.un.org/sdg/1"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Query":[0],"rewriting":[1],"is":[2],"essential":[3],"for":[4,116,215],"database":[5],"performance":[6],"optimization,":[7],"but":[8,82],"existing":[9],"automated":[10],"rule":[11,57,114,141,153,223],"enumeration":[12,63,103],"methods":[13],"suffer":[14],"from":[15,128],"exponential":[16],"search":[17,95],"spaces,":[18],"severe":[19],"redundancy,":[20],"and":[21,54,91,132,197,209],"poor":[22],"scalability,":[23],"especially":[24],"when":[25],"handling":[26],"complex":[27,210],"query":[28,76,167,190],"plans":[29,77],"with":[30,64,78,170],"five":[31],"or":[32],"more":[33],"nodes,":[34],"where":[35],"a":[36,48,65,139],"node":[37,118],"represents":[38],"an":[39],"operator":[40,79],"in":[41],"the":[42,94,107,148,159,181,213],"plan":[43,168],"tree.":[44],"We":[45],"present":[46],"SLER,":[47],"scalable":[49,113],"system":[50],"that":[51],"enables":[52],"efficient":[53],"effective":[55],"rewrite":[56,140,152],"discovery":[58],"by":[59,104,220],"combining":[60],"standardized":[61,72],"template":[62,110,194],"learning":[66],"to":[67,87,99,155,173,183],"rank":[68,100],"approach.":[69],"SLER":[70,135,165],"uses":[71],"templates,":[73],"abstractions":[74],"of":[75,161,207],"structures":[80],"preserved":[81],"data":[83],"specific":[84],"details":[85],"removed,":[86],"eliminate":[88],"structural":[89],"redundancies":[90],"drastically":[92],"reduce":[93],"space.":[96],"A":[97],"learn":[98],"model":[101],"guides":[102],"pre":[105],"filtering":[106],"most":[108],"promising":[109],"pairs,":[111],"enabling":[112],"generation":[115,217],"large":[117],"templates.":[119],"Evaluated":[120],"on":[121],"over":[122],"11000":[123],"real":[124],"world":[125],"SQL":[126],"queries":[127],"both":[129],"open":[130],"source":[131],"commercial":[133],"workloads,":[134],"has":[136],"automatically":[137],"constructed":[138],"repository":[142],"exceeding":[143],"1":[144],"million":[145,163],"rules":[146],"-":[147],"largest":[149],"empirically":[150],"validated":[151],"library":[154],"date.":[156],"Notably,":[157],"at":[158],"scale":[160,179],"one":[162],"rules,":[164],"supports":[166],"templates":[169],"complexity":[171],"up":[172],"channel":[174],"level":[175],"depth.":[176],"This":[177],"unprecedented":[178],"opens":[180],"door":[182],"discovering":[184],"highly":[185],"intricate":[186],"transformations":[187],"across":[188],"diverse":[189],"patterns.":[191],"Critically,":[192],"SLER's":[193],"driven":[195],"design":[196],"learned":[198],"ranking":[199],"mechanism":[200],"are":[201],"inherently":[202],"extensible,":[203],"allowing":[204],"seamless":[205],"integration":[206],"new":[208],"operators,":[211],"paving":[212],"way":[214],"next":[216],"optimizers":[218],"powered":[219],"comprehensive,":[221],"adaptive":[222],"spaces.":[224]},"counts_by_year":[],"updated_date":"2026-03-10T14:07:55.174380","created_date":"2026-03-06T00:00:00"}