{"id":"https://openalex.org/W7154380691","doi":"https://doi.org/10.48550/arxiv.2604.09944","title":"PLOP: Cost-Based Placement of Semantic Operators in Hybrid Query Plans","display_name":"PLOP: Cost-Based Placement of Semantic Operators in Hybrid Query Plans","publication_year":2026,"publication_date":"2026-04-10","ids":{"openalex":"https://openalex.org/W7154380691","doi":"https://doi.org/10.48550/arxiv.2604.09944"},"language":null,"primary_location":{"id":"doi:10.48550/arxiv.2604.09944","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.09944","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.2604.09944","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5133566473","display_name":"Qiuyang Mang","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Mang, Qiuyang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133579466","display_name":"Yufan Xiang","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Xiang, Yufan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133613269","display_name":"Hangrui Zhou","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Zhou, Hangrui","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133555259","display_name":"Runyuan He","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"He, Runyuan","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133564948","display_name":"Jiaxiang Yu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yu, Jiaxiang","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5133594987","display_name":"Hanchen Li","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Li, Hanchen","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5013608601","display_name":"Aditya Parameswaran","orcid":"https://orcid.org/0000-0002-4538-4752"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Parameswaran, Aditya","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5133615870","display_name":"Alvin Cheung","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Cheung, Alvin","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":8,"corresponding_author_ids":["https://openalex.org/A5133566473"],"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.7660999894142151,"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.7660999894142151,"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.04960000142455101,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.042100001126527786,"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/relational-database","display_name":"Relational database","score":0.6384000182151794},{"id":"https://openalex.org/keywords/heuristics","display_name":"Heuristics","score":0.5967000126838684},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5906000137329102},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.4900999963283539},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.45159998536109924},{"id":"https://openalex.org/keywords/leverage","display_name":"Leverage (statistics)","score":0.43059998750686646},{"id":"https://openalex.org/keywords/speedup","display_name":"Speedup","score":0.4239000082015991},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.40299999713897705},{"id":"https://openalex.org/keywords/sparql","display_name":"SPARQL","score":0.39649999141693115}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7598000168800354},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.6384000182151794},{"id":"https://openalex.org/C127705205","wikidata":"https://www.wikidata.org/wiki/Q5748245","display_name":"Heuristics","level":2,"score":0.5967000126838684},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5906000137329102},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.4900999963283539},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.45159998536109924},{"id":"https://openalex.org/C153083717","wikidata":"https://www.wikidata.org/wiki/Q6535263","display_name":"Leverage (statistics)","level":2,"score":0.43059998750686646},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.4239000082015991},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.40299999713897705},{"id":"https://openalex.org/C41009113","wikidata":"https://www.wikidata.org/wiki/Q54871","display_name":"SPARQL","level":4,"score":0.39649999141693115},{"id":"https://openalex.org/C106131492","wikidata":"https://www.wikidata.org/wiki/Q3072260","display_name":"Filter (signal processing)","level":2,"score":0.36239999532699585},{"id":"https://openalex.org/C111335779","wikidata":"https://www.wikidata.org/wiki/Q3454686","display_name":"Reduction (mathematics)","level":2,"score":0.3529999852180481},{"id":"https://openalex.org/C24394798","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database management system","level":3,"score":0.32440000772476196},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.32030001282691956},{"id":"https://openalex.org/C2129575","wikidata":"https://www.wikidata.org/wiki/Q54837","display_name":"Semantic Web","level":2,"score":0.32019999623298645},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.3116999864578247},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.2903999984264374},{"id":"https://openalex.org/C511149849","wikidata":"https://www.wikidata.org/wiki/Q7449051","display_name":"Semantic computing","level":3,"score":0.27959999442100525},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.27810001373291016},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.27239999175071716},{"id":"https://openalex.org/C90312973","wikidata":"https://www.wikidata.org/wiki/Q7449052","display_name":"Semantic data model","level":2,"score":0.2653999924659729},{"id":"https://openalex.org/C99436015","wikidata":"https://www.wikidata.org/wiki/Q1722436","display_name":"Relational calculus","level":4,"score":0.2648000121116638},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.2630999982357025},{"id":"https://openalex.org/C93983250","wikidata":"https://www.wikidata.org/wiki/Q795053","display_name":"Cost estimate","level":2,"score":0.25859999656677246},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.2572000026702881},{"id":"https://openalex.org/C184337299","wikidata":"https://www.wikidata.org/wiki/Q1437428","display_name":"Semantics (computer science)","level":2,"score":0.25699999928474426},{"id":"https://openalex.org/C195324797","wikidata":"https://www.wikidata.org/wiki/Q33742","display_name":"Natural language","level":2,"score":0.2563000023365021},{"id":"https://openalex.org/C56288433","wikidata":"https://www.wikidata.org/wiki/Q58673","display_name":"Data manipulation language","level":2,"score":0.25619998574256897},{"id":"https://openalex.org/C14036430","wikidata":"https://www.wikidata.org/wiki/Q3736076","display_name":"Function (biology)","level":2,"score":0.25450000166893005},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.25360000133514404},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2515999972820282}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.48550/arxiv.2604.09944","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.09944","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.2604.09944","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2604.09944","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":{"Recent":[0],"database":[1,52],"systems":[2,106],"have":[3],"introduced":[4],"semantic":[5,63,138,150,201],"operators":[6,28,69,81,99],"that":[7,79,147,165,191],"leverage":[8],"large":[9],"language":[10,23],"models":[11],"(LLMs)":[12],"to":[13,60,66,100,137,152,172,213],"filter,":[14],"join,":[15],"and":[16,50,207,216,234],"project":[17],"over":[18],"structured":[19],"data":[20,78],"using":[21],"natural":[22],"predicates.":[24],"In":[25],"practice,":[26],"these":[27],"are":[29],"combined":[30],"with":[31],"traditional":[32],"relational":[33,68,98,169,183],"operators,":[34],"e.g.,":[35],"equi-joins,":[36],"producing":[37],"hybrid":[38,129,134],"query":[39,135],"plans":[40],"whose":[41],"execution":[42],"cost":[43,120,181,189,218,247],"depends":[44],"on":[45,174,240],"both":[46],"expensive":[47],"LLM":[48,86,92,158,180],"calls":[49,93],"conventional":[51],"processing.":[53],"A":[54],"key":[55],"optimization":[56],"question":[57,111],"is":[58],"where":[59],"place":[61],"each":[62],"operator":[64],"relative":[65],"the":[67,71,77,118,153,193,231,251],"in":[70],"plan:":[72],"placing":[73,88],"them":[74,89],"earlier":[75],"reduces":[76,91,133],"subsequent":[80],"process,":[82],"but":[83,96,163],"requires":[84],"more":[85],"calls;":[87],"later":[90],"through":[94],"deduplication,":[95],"forces":[97],"process":[101],"larger":[102],"intermediate":[103],"data.":[104],"Existing":[105],"either":[107],"ignore":[108],"this":[109,166],"placement":[110,140,194],"or":[112],"apply":[113],"simple":[114],"heuristics":[115],"without":[116],"considering":[117],"full":[119],"trade-off.":[121],"We":[122,145],"present":[123],"PLOP,":[124],"a":[125,187,245],"plan-level":[126],"optimizer":[127],"for":[128],"semantic-relational":[130],"queries.":[131,177],"PLOP":[132,185,210,243],"planning":[136],"filter":[139],"via":[141],"two":[142,208],"equivalence-preserving":[143],"rewrites.":[144],"prove":[146],"deferring":[148],"all":[149],"filters":[151],"latest":[154],"possible":[155],"position":[156],"minimizes":[157],"invocations":[159],"under":[160],"function":[161],"caching,":[162],"show":[164],"can":[167],"cause":[168],"processing":[170],"costs":[171],"dominate":[173],"complex":[175],"multi-table":[176],"To":[178],"balance":[179],"against":[182,230,236],"cost,":[184],"uses":[186],"dynamic-programming-based":[188],"model":[190],"finds":[192],"minimizing":[195],"their":[196],"weighted":[197],"sum.":[198],"On":[199],"44":[200],"SQL":[202],"queries":[203],"across":[204],"five":[205],"schemas":[206],"benchmarks,":[209],"achieves":[211,244],"up":[212],"1.5$\\times$":[214],"speedup":[215],"4.29$\\times$":[217],"reduction":[219,248],"while":[220,249],"maintaining":[221],"high":[222],"output":[223],"quality:":[224],"an":[225],"average":[226],"F1":[227],"of":[228],"0.85":[229],"unoptimized":[232],"baseline":[233],"0.84":[235],"human-annotated":[237],"ground":[238],"truth":[239],"SemBench.":[241],"Overall,":[242],"significant":[246],"preserving":[250],"highest":[252],"accuracy":[253],"among":[254],"six":[255],"publicly":[256],"available":[257],"systems.":[258]},"counts_by_year":[],"updated_date":"2026-05-05T08:41:31.759640","created_date":"2026-04-15T00:00:00"}