{"id":"https://openalex.org/W7106426646","doi":"https://doi.org/10.48550/arxiv.2511.16455","title":"[Experiment, Analysis, and Benchmark] Systematic Evaluation of Plan-based Adaptive Query Processing","display_name":"[Experiment, Analysis, and Benchmark] Systematic Evaluation of Plan-based Adaptive Query Processing","publication_year":2025,"publication_date":"2025-11-20","ids":{"openalex":"https://openalex.org/W7106426646","doi":"https://doi.org/10.48550/arxiv.2511.16455"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2511.16455","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2511.16455","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.2511.16455","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Mu, Pei","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Mu, Pei","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Carniel, Anderson Chaves","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Carniel, Anderson Chaves","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"middle","author":{"id":null,"display_name":"Barbalace, Antonio","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Barbalace, Antonio","raw_affiliation_strings":[],"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Shaikhha, Amir","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Shaikhha, Amir","raw_affiliation_strings":[],"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":4,"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.7732999920845032,"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.7732999920845032,"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.14300000667572021,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.017799999564886093,"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/bottleneck","display_name":"Bottleneck","score":0.7921000123023987},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.7472000122070312},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.5152999758720398},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.4499000012874603},{"id":"https://openalex.org/keywords/performance-improvement","display_name":"Performance improvement","score":0.3952000141143799},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.3425999879837036}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.859499990940094},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.7921000123023987},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.7472000122070312},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5152999758720398},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.45089998841285706},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.4499000012874603},{"id":"https://openalex.org/C2778915421","wikidata":"https://www.wikidata.org/wiki/Q3643177","display_name":"Performance improvement","level":2,"score":0.3952000141143799},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.35199999809265137},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.3425999879837036},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.319599986076355},{"id":"https://openalex.org/C99016210","wikidata":"https://www.wikidata.org/wiki/Q5488129","display_name":"Query expansion","level":2,"score":0.2978000044822693},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.2687000036239624},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.26600000262260437},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.259799987077713},{"id":"https://openalex.org/C2989070954","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database query","level":2,"score":0.2531000077724457},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.25200000405311584},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.2515000104904175}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2511.16455","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2511.16455","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.2511.16455","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2511.16455","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":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Unreliable":[0],"cardinality":[1,37,129,145],"estimation":[2],"remains":[3,64],"a":[4,23,166],"critical":[5],"performance":[6,117,149,158,200],"bottleneck":[7],"in":[8,103,132,140],"database":[9,189],"management":[10],"systems":[11],"(DBMSs).":[12],"Adaptive":[13],"Query":[14],"Processing":[15],"(AQP)":[16],"strategies":[17],"address":[18],"this":[19,33,81],"limitation":[20],"by":[21,34],"providing":[22],"more":[24],"robust":[25],"query":[26,123],"execution":[27,42],"mechanism.":[28],"Specifically,":[29],"plan-based":[30,53,75,98,162,182],"AQP":[31,99,163,169,183],"achieves":[32],"incrementally":[35],"refining":[36],"using":[38],"feedback":[39],"from":[40,121],"the":[41,46,50,69,106,113,122,128,141,161,193,196],"of":[43,52,73,108,160],"sub-plans.":[44],"However,":[45],"actual":[47],"reason":[48],"behind":[49],"improvements":[51,150],"AQP,":[54],"especially":[55],"across":[56,89],"different":[57],"storage":[58],"architectures":[59],"(on-disk":[60],"vs.":[61],"in-memory":[62,87,142],"DBMSs),":[63],"unexplored.":[65],"This":[66],"paper":[67],"presents":[68],"first":[70],"comprehensive":[71],"analysis":[72],"state-of-the-art":[74,167],"AQP.":[76],"We":[77,154],"implement":[78],"and":[79,86,180,186,199],"evaluate":[80],"strategy":[82],"on":[83,178,192],"both":[84,104],"on-disk":[85,114],"DBMSs":[88],"two":[90],"benchmarks.":[91],"Our":[92],"key":[93],"findings":[94],"reveal":[95],"that":[96],"while":[97],"provides":[100],"overall":[101],"speedups":[102],"environments,":[105],"sources":[107],"improvement":[109],"differ":[110],"significantly.":[111],"In":[112],"DBMS,":[115,143],"PostgreSQL,":[116],"gains":[118],"primarily":[119],"come":[120],"plan":[124],"reorderings,":[125],"but":[126],"not":[127],"updating":[130,134],"mechanism;":[131],"fact,":[133],"cardinalities":[135],"introduces":[136],"measurable":[137],"overhead.":[138],"Conversely,":[139],"DuckDB,":[144],"refinement":[146],"drives":[147],"significant":[148,157],"for":[151,176],"most":[152],"queries.":[153],"also":[155],"observe":[156],"benefits":[159],"compared":[164],"to":[165],"related-based":[168],"method.":[170],"These":[171],"observations":[172],"provide":[173],"crucial":[174],"insights":[175],"researchers":[177],"when":[179],"why":[181],"is":[184],"effective,":[185],"ultimately":[187],"guide":[188],"system":[190],"developers":[191],"tradeoffs":[194],"between":[195],"implementation":[197],"effort":[198],"improvements.":[201]},"counts_by_year":[],"updated_date":"2025-11-23T05:13:22.807545","created_date":"2025-11-23T00:00:00"}