{"id":"https://openalex.org/W4407131582","doi":"https://doi.org/10.1145/3725309","title":"How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks","display_name":"How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks","publication_year":2025,"publication_date":"2025-06-17","ids":{"openalex":"https://openalex.org/W4407131582","doi":"https://doi.org/10.1145/3725309"},"language":"en","primary_location":{"id":"doi:10.1145/3725309","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3725309","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},"type":"preprint","indexed_in":["arxiv","crossref","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/2502.01229","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5044350577","display_name":"Roman Heinrich","orcid":"https://orcid.org/0000-0001-7321-9562"},"institutions":[{"id":"https://openalex.org/I31512782","display_name":"Technische Universit\u00e4t Darmstadt","ror":"https://ror.org/05n911h24","country_code":"DE","type":"education","lineage":["https://openalex.org/I31512782"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Roman Heinrich","raw_affiliation_strings":["Technical University of Darmstadt, Darmstadt, Germany and DFKI Darmstadt, Darmstadt, Germany"],"affiliations":[{"raw_affiliation_string":"Technical University of Darmstadt, Darmstadt, Germany and DFKI Darmstadt, Darmstadt, Germany","institution_ids":["https://openalex.org/I31512782"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5057341552","display_name":"Manisha Luthra","orcid":"https://orcid.org/0000-0002-3788-6664"},"institutions":[{"id":"https://openalex.org/I31512782","display_name":"Technische Universit\u00e4t Darmstadt","ror":"https://ror.org/05n911h24","country_code":"DE","type":"education","lineage":["https://openalex.org/I31512782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Manisha Luthra","raw_affiliation_strings":["Technical University of Darmstadt, Darmstadt, Germany and DFKI Darmstadt, Darmstadt, Germany"],"affiliations":[{"raw_affiliation_string":"Technical University of Darmstadt, Darmstadt, Germany and DFKI Darmstadt, Darmstadt, Germany","institution_ids":["https://openalex.org/I31512782"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5116145256","display_name":"Johannes Wehrstein","orcid":"https://orcid.org/0000-0002-7152-8959"},"institutions":[{"id":"https://openalex.org/I31512782","display_name":"Technische Universit\u00e4t Darmstadt","ror":"https://ror.org/05n911h24","country_code":"DE","type":"education","lineage":["https://openalex.org/I31512782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Johannes Wehrstein","raw_affiliation_strings":["Technical University of Darmstadt, Darmstadt, Germany"],"affiliations":[{"raw_affiliation_string":"Technical University of Darmstadt, Darmstadt, Germany","institution_ids":["https://openalex.org/I31512782"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023540722","display_name":"H. Kornmayer","orcid":"https://orcid.org/0000-0002-8878-7623"},"institutions":[{"id":"https://openalex.org/I108806672","display_name":"Baden-Wuerttemberg Cooperative State University","ror":"https://ror.org/02xdzy536","country_code":"DE","type":"education","lineage":["https://openalex.org/I108806672"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Harald Kornmayer","raw_affiliation_strings":["Duale Hochschule Baden-W\u00fcrttemberg (DHBW) Mannheim, Mannheim, Germany"],"affiliations":[{"raw_affiliation_string":"Duale Hochschule Baden-W\u00fcrttemberg (DHBW) Mannheim, Mannheim, Germany","institution_ids":["https://openalex.org/I108806672"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5073504200","display_name":"Carsten Binnig","orcid":"https://orcid.org/0000-0002-2744-7836"},"institutions":[{"id":"https://openalex.org/I31512782","display_name":"Technische Universit\u00e4t Darmstadt","ror":"https://ror.org/05n911h24","country_code":"DE","type":"education","lineage":["https://openalex.org/I31512782"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Carsten Binnig","raw_affiliation_strings":["Technical University of Darmstadt, Darmstadt, Germany and DFKI Darmstadt, Darmstadt, Germany"],"affiliations":[{"raw_affiliation_string":"Technical University of Darmstadt, Darmstadt, Germany and DFKI Darmstadt, Darmstadt, Germany","institution_ids":["https://openalex.org/I31512782"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5044350577"],"corresponding_institution_ids":["https://openalex.org/I31512782"],"apc_list":null,"apc_paid":null,"fwci":5.6784,"has_fulltext":true,"cited_by_count":4,"citation_normalized_percentile":{"value":0.95190845,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":95,"max":99},"biblio":{"volume":"3","issue":"3","first_page":"1","last_page":"27"},"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.9592000246047974,"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.9592000246047974,"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/T10215","display_name":"Semantic Web and Ontologies","score":0.9546999931335449,"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"}},{"id":"https://openalex.org/T11596","display_name":"Constraint Satisfaction and Optimization","score":0.9083999991416931,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6739113330841064},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.6442060470581055},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.2902970314025879}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6739113330841064},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.6442060470581055},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.2902970314025879}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.1145/3725309","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3725309","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the ACM on Management of Data","raw_type":"journal-article"},{"id":"pmh:oai:tubiblio.ulb.tu-darmstadt.de:159398","is_oa":false,"landing_page_url":"http://tubiblio.ulb.tu-darmstadt.de/view/person/Heinrich=3ARoman=3A=3A.html>","pdf_url":null,"source":{"id":"https://openalex.org/S4377196390","display_name":"TUbilio (Technical University of Darmstadt)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I31512782","host_organization_name":"Technische Universit\u00e4t Darmstadt","host_organization_lineage":["https://openalex.org/I31512782"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"acceptedVersion","is_accepted":true,"is_published":false,"raw_source_name":null,"raw_type":"NonPeerReviewed"},{"id":"pmh:oai:arXiv.org:2502.01229","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2502.01229","pdf_url":"https://arxiv.org/pdf/2502.01229","source":{"id":"https://openalex.org/S4393918464","display_name":"ArXiv.org","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":"pmh:oai:share.osf.io:98f10ca9-cfd3-4a8e-a07a-6162ef0ee322","is_oa":false,"landing_page_url":"https://osf.io/rb5tn","pdf_url":null,"source":{"id":"https://openalex.org/S4306401127","display_name":"OSF Preprints (OSF Preprints)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I2799848540","host_organization_name":"Center for Open Science","host_organization_lineage":["https://openalex.org/I2799848540"],"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":"Project"},{"id":"doi:10.48550/arxiv.2502.01229","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.2502.01229","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":"pmh:oai:arXiv.org:2502.01229","is_oa":true,"landing_page_url":"http://arxiv.org/abs/2502.01229","pdf_url":"https://arxiv.org/pdf/2502.01229","source":{"id":"https://openalex.org/S4393918464","display_name":"ArXiv.org","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"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":[{"id":"https://openalex.org/F4320318429","display_name":"Deutsches Forschungszentrum f\u00fcr K\u00fcnstliche Intelligenz","ror":"https://ror.org/01ayc5b57"},{"id":"https://openalex.org/F4320323384","display_name":"Technische Universit\u00e4t Darmstadt","ror":"https://ror.org/05n911h24"}],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4407131582.pdf","grobid_xml":"https://content.openalex.org/works/W4407131582.grobid-xml"},"referenced_works_count":38,"referenced_works":["https://openalex.org/W4400909943","https://openalex.org/W2081728040","https://openalex.org/W2116436709","https://openalex.org/W4383749444","https://openalex.org/W4380433215","https://openalex.org/W2010149990","https://openalex.org/W2100773341","https://openalex.org/W2066140355","https://openalex.org/W4400910513","https://openalex.org/W4313138291","https://openalex.org/W3013555795","https://openalex.org/W2013434755","https://openalex.org/W4282570649","https://openalex.org/W4399163950","https://openalex.org/W2396309311","https://openalex.org/W4395071060","https://openalex.org/W4400909514","https://openalex.org/W4306317394","https://openalex.org/W4285338532","https://openalex.org/W4281754544","https://openalex.org/W2911464154","https://openalex.org/W4392454229","https://openalex.org/W2153329411","https://openalex.org/W2078483536","https://openalex.org/W2998249308","https://openalex.org/W4206830372","https://openalex.org/W4402041923","https://openalex.org/W4366492460","https://openalex.org/W3111141572","https://openalex.org/W2109907545","https://openalex.org/W4389628219","https://openalex.org/W4221142004","https://openalex.org/W3097225903","https://openalex.org/W2991530444","https://openalex.org/W4283326127","https://openalex.org/W4392453910","https://openalex.org/W3037027022","https://openalex.org/W4366492480"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W4396701345","https://openalex.org/W2376932109","https://openalex.org/W2001405890","https://openalex.org/W4396696052"],"abstract_inverted_index":{"Traditionally,":[0],"query":[1,23,73,80,99,157],"optimizers":[2],"rely":[3],"on":[4,31,94],"cost":[5,18,28,43,123],"models":[6,29,47],"to":[7,37,51,62,120,147],"choose":[8],"the":[9,39,97,129],"best":[10],"execution":[11],"plan":[12],"from":[13],"several":[14],"candidates,":[15],"making":[16,152],"precise":[17],"estimates":[19],"critical":[20],"for":[21,156],"efficient":[22],"execution.":[24],"In":[25,82,112],"recent":[26],"years,":[27],"based":[30],"machine":[32],"learning":[33],"have":[34,48,59],"been":[35,49,60],"proposed":[36],"overcome":[38],"weaknesses":[40],"of":[41,96],"traditional":[42,122,130],"models.":[44],"While":[45],"these":[46,137],"shown":[50],"provide":[52],"better":[53],"prediction":[54],"accuracy,":[55],"only":[56],"limited":[57],"efforts":[58],"made":[61],"investigate":[63],"how":[64,76],"well":[65],"Learned":[66],"Cost":[67],"Models":[68],"(LCMs)":[69],"actually":[70],"perform":[71],"in":[72,136],"optimization":[74,100],"and":[75,107,145],"they":[77],"affect":[78],"overall":[79],"performance.":[81],"this":[83,87],"paper,":[84],"we":[85,115],"address":[86],"by":[88,141],"a":[89,121],"systematic":[90],"study":[91],"evaluating":[92],"LCMs":[93,119,135,153],"three":[95],"core":[98],"tasks:":[101],"join":[102],"ordering,":[103],"access":[104],"path":[105],"selection,":[106],"physical":[108],"operator":[109],"selection":[110],".":[111],"our":[113],"study,":[114],"compare":[116],"seven":[117],"state-of-the-art":[118],"model":[124,131],"and,":[125],"surprisingly,":[126],"find":[127],"that":[128],"often":[132],"still":[133],"outperforms":[134],"tasks.":[138],"We":[139],"conclude":[140],"highlighting":[142],"major":[143],"takeaways":[144],"recommendations":[146],"guide":[148],"future":[149],"research":[150],"toward":[151],"more":[154],"effective":[155],"optimization.":[158]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":2}],"updated_date":"2026-04-09T08:11:56.329763","created_date":"2025-02-05T00:00:00"}