{"id":"https://openalex.org/W4415306910","doi":"https://doi.org/10.48550/arxiv.2504.17181","title":"Evaluating Learned Query Performance Prediction Models at LinkedIn: Challenges, Opportunities, and Findings","display_name":"Evaluating Learned Query Performance Prediction Models at LinkedIn: Challenges, Opportunities, and Findings","publication_year":2025,"publication_date":"2025-04-24","ids":{"openalex":"https://openalex.org/W4415306910","doi":"https://doi.org/10.48550/arxiv.2504.17181"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:2504.17181","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2504.17181","pdf_url":"https://arxiv.org/pdf/2504.17181","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"type":"preprint","indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2504.17181","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Song, Chujun","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Song, Chujun","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5081685401","display_name":"Slim Bouguerra","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Bouguerra, Slim","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5120045308","display_name":"Erik Krogen","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Krogen, Erik","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":"https://openalex.org/A5049333271","display_name":"Daniel J. Abadi","orcid":"https://orcid.org/0000-0003-3771-2995"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Abadi, Daniel","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":true,"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/T11719","display_name":"Data Quality and Management","score":0.9987999796867371,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9987999796867371,"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9918000102043152,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9896000027656555,"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/performance-prediction","display_name":"Performance prediction","score":0.5755000114440918},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.5540000200271606},{"id":"https://openalex.org/keywords/predictive-modelling","display_name":"Predictive modelling","score":0.48080000281333923},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4772000014781952},{"id":"https://openalex.org/keywords/data-modeling","display_name":"Data modeling","score":0.4262000024318695},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.3723999857902527},{"id":"https://openalex.org/keywords/regression-analysis","display_name":"Regression analysis","score":0.31709998846054077},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.3019999861717224}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8292999863624573},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5759999752044678},{"id":"https://openalex.org/C2777115002","wikidata":"https://www.wikidata.org/wiki/Q7168246","display_name":"Performance prediction","level":2,"score":0.5755000114440918},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.5540000200271606},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.5216000080108643},{"id":"https://openalex.org/C45804977","wikidata":"https://www.wikidata.org/wiki/Q7239673","display_name":"Predictive modelling","level":2,"score":0.48080000281333923},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4772000014781952},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.4262000024318695},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.39980000257492065},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.3723999857902527},{"id":"https://openalex.org/C152877465","wikidata":"https://www.wikidata.org/wiki/Q208042","display_name":"Regression analysis","level":2,"score":0.31709998846054077},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.3019999861717224},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.2964000105857849},{"id":"https://openalex.org/C83546350","wikidata":"https://www.wikidata.org/wiki/Q1139051","display_name":"Regression","level":2,"score":0.29170000553131104},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.28040000796318054},{"id":"https://openalex.org/C51632099","wikidata":"https://www.wikidata.org/wiki/Q3985153","display_name":"Training set","level":2,"score":0.2630000114440918},{"id":"https://openalex.org/C2989134064","wikidata":"https://www.wikidata.org/wiki/Q288510","display_name":"Execution time","level":2,"score":0.2587999999523163},{"id":"https://openalex.org/C48921125","wikidata":"https://www.wikidata.org/wiki/Q10861030","display_name":"Linear regression","level":2,"score":0.2578999996185303},{"id":"https://openalex.org/C12267149","wikidata":"https://www.wikidata.org/wiki/Q282453","display_name":"Support vector machine","level":2,"score":0.2572999894618988},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.25619998574256897}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:arXiv.org:2504.17181","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2504.17181","pdf_url":"https://arxiv.org/pdf/2504.17181","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},{"id":"doi:10.48550/arxiv.2504.17181","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2504.17181","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:2504.17181","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2504.17181","pdf_url":"https://arxiv.org/pdf/2504.17181","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4415306910.pdf","grobid_xml":"https://content.openalex.org/works/W4415306910.grobid-xml"},"referenced_works_count":0,"referenced_works":[],"related_works":[],"abstract_inverted_index":{"Recent":[0],"advancements":[1],"in":[2],"learning-based":[3],"query":[4,84,126],"performance":[5,101],"prediction":[6,74],"models":[7,14,34,53,65,91,105],"have":[8],"demonstrated":[9],"remarkable":[10],"efficacy.":[11],"However,":[12],"these":[13,33,52,64,90,104,112],"are":[15,98],"predominantly":[16],"validated":[17],"using":[18],"synthetic":[19],"datasets":[20],"focused":[21],"on":[22,42,55],"cardinality":[23],"or":[24],"latency":[25],"estimations.":[26],"This":[27],"paper":[28],"explores":[29],"the":[30,83,99,107,124,162,171],"application":[31],"of":[32,103],"to":[35,67,92,134,148],"LinkedIn's":[36],"complex":[37],"real-world":[38,56],"OLAP":[39],"queries":[40],"executed":[41],"Trino,":[43],"addressing":[44],"four":[45],"primary":[46],"research":[47],"questions:":[48],"(1)":[49],"How":[50],"do":[51],"perform":[54],"industrial":[57,125],"data":[58],"with":[59],"limited":[60],"information?":[61],"(2)":[62],"Can":[63],"generalize":[66],"new":[68],"tasks,":[69],"such":[70],"as":[71],"CPU":[72,135],"time":[73,136],"and":[75,121,130,138],"classification?":[76],"(3)":[77],"What":[78,97],"additional":[79],"information":[80],"available":[81,108],"from":[82,170],"plan":[85],"could":[86,154],"be":[87,168],"utilized":[88],"by":[89],"enhance":[93,155],"their":[94],"performance?":[95],"(4)":[96],"theoretical":[100],"limits":[102],"given":[106],"data?":[109],"To":[110],"address":[111],"questions,":[113],"we":[114,159],"evaluate":[115],"several":[116],"models-including":[117],"TLSTM,":[118],"TCNN,":[119],"QueryFormer,":[120],"XGBoost,":[122],"against":[123],"workload":[127],"at":[128],"LinkedIn,":[129],"extend":[131],"our":[132],"analysis":[133],"regression":[137],"classification":[139],"tasks.":[140],"We":[141],"also":[142],"propose":[143],"a":[144],"multi-task":[145],"learning":[146],"approach":[147],"incorporate":[149],"underutilized":[150],"operator-level":[151],"metrics":[152],"that":[153,166],"model":[156],"understanding.":[157],"Additionally,":[158],"empirically":[160],"analyze":[161],"inherent":[163],"upper":[164],"bound":[165],"can":[167],"achieved":[169],"models.":[172]},"counts_by_year":[],"updated_date":"2026-07-28T07:46:37.118299","created_date":"2025-10-18T00:00:00"}
