{"id":"https://openalex.org/W7160548368","doi":"https://doi.org/10.48550/arxiv.2605.05044","title":"Efficient Cost-Based Rewrite in a Bottom-Up Optimizer","display_name":"Efficient Cost-Based Rewrite in a Bottom-Up Optimizer","publication_year":2026,"publication_date":"2026-05-06","ids":{"openalex":"https://openalex.org/W7160548368","doi":"https://doi.org/10.48550/arxiv.2605.05044"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2605.05044","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.05044","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"type":"preprint","indexed_in":["datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://doi.org/10.48550/arxiv.2605.05044","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5118325344","display_name":"Qi Cheng","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Cheng, Qi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135621042","display_name":"Yang Sun","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sun, Yang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5013481107","display_name":"Weidong Yu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yu, Weidong","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135559845","display_name":"Danny Chen","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chen, Danny","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135581146","display_name":"Weicheng Wang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wang, Weicheng","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5135545551","display_name":"Chong Chen","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Chen, Chong","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5109039470","display_name":"Per-\u00c5ke Larson","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Larson, Per-Ake","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"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.9063000082969666,"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.9063000082969666,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.03099999949336052,"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/T11106","display_name":"Data Management and Algorithms","score":0.023099999874830246,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.6396999955177307},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.6241000294685364},{"id":"https://openalex.org/keywords/interleaving","display_name":"Interleaving","score":0.6050999760627747},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.5504000186920166},{"id":"https://openalex.org/keywords/reuse","display_name":"Reuse","score":0.4957999885082245},{"id":"https://openalex.org/keywords/core","display_name":"Core (optical fiber)","score":0.400299996137619},{"id":"https://openalex.org/keywords/optimization-problem","display_name":"Optimization problem","score":0.37929999828338623},{"id":"https://openalex.org/keywords/plan","display_name":"Plan (archaeology)","score":0.34139999747276306}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8181999921798706},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.6396999955177307},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.6241000294685364},{"id":"https://openalex.org/C28034677","wikidata":"https://www.wikidata.org/wiki/Q17092530","display_name":"Interleaving","level":2,"score":0.6050999760627747},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.5504000186920166},{"id":"https://openalex.org/C206588197","wikidata":"https://www.wikidata.org/wiki/Q846574","display_name":"Reuse","level":2,"score":0.4957999885082245},{"id":"https://openalex.org/C2164484","wikidata":"https://www.wikidata.org/wiki/Q5170150","display_name":"Core (optical fiber)","level":2,"score":0.400299996137619},{"id":"https://openalex.org/C137836250","wikidata":"https://www.wikidata.org/wiki/Q984063","display_name":"Optimization problem","level":2,"score":0.37929999828338623},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.34139999747276306},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.323199987411499},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.32109999656677246},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.31769999861717224},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.2946000099182129},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.2809000015258789},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.2802000045776367},{"id":"https://openalex.org/C78766204","wikidata":"https://www.wikidata.org/wiki/Q555032","display_name":"Multi-core processor","level":2,"score":0.2791999876499176},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.2766000032424927},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.2671000063419342},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2621999979019165},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.258899986743927},{"id":"https://openalex.org/C131924884","wikidata":"https://www.wikidata.org/wiki/Q5087085","display_name":"Chase","level":2,"score":0.2581000030040741},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2540000081062317},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.25380000472068787},{"id":"https://openalex.org/C77618280","wikidata":"https://www.wikidata.org/wiki/Q1155772","display_name":"Scheme (mathematics)","level":2,"score":0.2515000104904175},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.25130000710487366},{"id":"https://openalex.org/C93693863","wikidata":"https://www.wikidata.org/wiki/Q897659","display_name":"Branch and bound","level":2,"score":0.2506999969482422}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2605.05044","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.05044","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"doi:10.48550/arxiv.2605.05044","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2605.05044","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":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"The":[0,94,146],"query":[1],"optimizer":[2,144],"in":[3,151],"a":[4,33,86,100,142],"Database":[5],"Management":[6],"Systems":[7],"(DBMS),":[8],"translates":[9],"declarative":[10],"queries":[11],"into":[12],"efficient":[13],"execution":[14,51],"plans.":[15],"Conventional":[16],"bottom-up":[17,92,143],"optimization":[18,78,162],"consists":[19],"of":[20,53,96,167],"two":[21],"main":[22],"stages:":[23],"Query":[24],"Rewrite":[25],"(QRW)":[26],"and":[27,56,75,116,136],"Cost-Based":[28],"Optimization":[29],"(CBO).":[30],"However,":[31],"applying":[32],"rewrite":[34,89],"rule":[35],"during":[36,127],"QRW":[37,66],"may":[38,46],"not":[39],"always":[40],"be":[41],"beneficial;":[42],"the":[43,49,54,124,152,165],"best":[44],"choice":[45],"depend":[47],"on":[48],"(estimated)":[50],"cost":[52,119],"original":[55],"rewritten":[57],"expressions.":[58],"Fully":[59],"exploiting":[60],"such":[61],"cost-dependent":[62],"rules":[63],"necessitates":[64],"interleaving":[65],"with":[67],"frequent":[68],"CBO":[69,106],"invocations,":[70],"thereby":[71],"incurring":[72],"substantial":[73],"overhead":[74],"often":[76],"impractical":[77],"times.":[79],"To":[80],"mitigate":[81],"this":[82],"inefficiency,":[83],"we":[84,114],"introduce":[85],"novel":[87],"cost-based":[88],"framework":[90,147],"for":[91,104,134],"optimizers.":[93],"core":[95],"our":[97,168],"approach":[98],"is":[99],"multi-level":[101],"caching":[102,135],"mechanism":[103],"intermediate":[105,138],"results":[107,140],"aimed":[108],"at":[109],"eliminating":[110],"redundant":[111],"computation.":[112],"Furthermore,":[113],"establish":[115],"exploit":[117],"upper":[118],"bounds":[120],"to":[121],"intelligently":[122],"prune":[123],"search":[125],"space":[126],"optimization.":[128],"We":[129],"also":[130],"contribute":[131],"methodological":[132],"solutions":[133],"reusing":[137],"plan":[139],"within":[141],"architecture.":[145],"has":[148],"been":[149],"implemented":[150],"GaussDB":[153],"optimizer.":[154],"Experiments":[155],"show":[156],"that":[157],"it":[158],"significantly":[159],"reduces":[160],"overall":[161],"time,":[163],"demonstrating":[164],"effectiveness":[166],"approach.":[169]},"counts_by_year":[],"updated_date":"2026-07-01T06:00:48.157686","created_date":"2026-05-08T00:00:00"}