{"id":"https://openalex.org/W4398233598","doi":"https://doi.org/10.1145/3626246.3654728","title":"ASM in Action: Fast and Practical Learned Cardinality Estimation","display_name":"ASM in Action: Fast and Practical Learned Cardinality Estimation","publication_year":2024,"publication_date":"2024-05-23","ids":{"openalex":"https://openalex.org/W4398233598","doi":"https://doi.org/10.1145/3626246.3654728"},"language":"en","primary_location":{"id":"doi:10.1145/3626246.3654728","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3626246.3654728","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2024 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5088286775","display_name":"Sangoh Lee","orcid":"https://orcid.org/0009-0009-3940-7311"},"institutions":[{"id":"https://openalex.org/I123900574","display_name":"Pohang University of Science and Technology","ror":"https://ror.org/04xysgw12","country_code":"KR","type":"education","lineage":["https://openalex.org/I123900574"]}],"countries":["KR"],"is_corresponding":true,"raw_author_name":"Sangoh Lee","raw_affiliation_strings":["GSAI, POSTECH, Pohang, Republic of Korea"],"affiliations":[{"raw_affiliation_string":"GSAI, POSTECH, Pohang, Republic of Korea","institution_ids":["https://openalex.org/I123900574"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5055332840","display_name":"Kyoungmin Kim","orcid":"https://orcid.org/0009-0000-0224-2570"},"institutions":[{"id":"https://openalex.org/I5124864","display_name":"\u00c9cole Polytechnique F\u00e9d\u00e9rale de Lausanne","ror":"https://ror.org/02s376052","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I5124864"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Kyoungmin Kim","raw_affiliation_strings":["EPFL, Lausanne, Switzerland"],"affiliations":[{"raw_affiliation_string":"EPFL, Lausanne, Switzerland","institution_ids":["https://openalex.org/I5124864"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5035744252","display_name":"Wook-Shin Han","orcid":"https://orcid.org/0000-0001-9206-9563"},"institutions":[{"id":"https://openalex.org/I123900574","display_name":"Pohang University of Science and Technology","ror":"https://ror.org/04xysgw12","country_code":"KR","type":"education","lineage":["https://openalex.org/I123900574"]}],"countries":["KR"],"is_corresponding":false,"raw_author_name":"Wook-Shin Han","raw_affiliation_strings":["GSAI, POSTECH, Pohang, Republic of Korea"],"affiliations":[{"raw_affiliation_string":"GSAI, POSTECH, Pohang, Republic of Korea","institution_ids":["https://openalex.org/I123900574"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5088286775"],"corresponding_institution_ids":["https://openalex.org/I123900574"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.0556444,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"460","last_page":"463"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12072","display_name":"Machine Learning and Algorithms","score":0.9962000250816345,"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"}},"topics":[{"id":"https://openalex.org/T12072","display_name":"Machine Learning and Algorithms","score":0.9962000250816345,"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/T11106","display_name":"Data Management and Algorithms","score":0.9932000041007996,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9923999905586243,"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/cardinality","display_name":"Cardinality (data modeling)","score":0.7264068126678467},{"id":"https://openalex.org/keywords/action","display_name":"Action (physics)","score":0.6881006956100464},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.674910843372345},{"id":"https://openalex.org/keywords/estimation","display_name":"Estimation","score":0.46044835448265076},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.3500407338142395},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.163510262966156},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.08365210890769958}],"concepts":[{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.7264068126678467},{"id":"https://openalex.org/C2780791683","wikidata":"https://www.wikidata.org/wiki/Q846785","display_name":"Action (physics)","level":2,"score":0.6881006956100464},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.674910843372345},{"id":"https://openalex.org/C96250715","wikidata":"https://www.wikidata.org/wiki/Q965330","display_name":"Estimation","level":2,"score":0.46044835448265076},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.3500407338142395},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.163510262966156},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.08365210890769958},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C201995342","wikidata":"https://www.wikidata.org/wiki/Q682496","display_name":"Systems engineering","level":1,"score":0.0},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3626246.3654728","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3626246.3654728","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Companion of the 2024 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":11,"referenced_works":["https://openalex.org/W2051756193","https://openalex.org/W2060091058","https://openalex.org/W2396309311","https://openalex.org/W3013555795","https://openalex.org/W3097225903","https://openalex.org/W3176153696","https://openalex.org/W3201096471","https://openalex.org/W4282570649","https://openalex.org/W4380433194","https://openalex.org/W4393183973","https://openalex.org/W6600617465"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2748952813","https://openalex.org/W2002177687","https://openalex.org/W2058438338","https://openalex.org/W2019471580","https://openalex.org/W2390279801","https://openalex.org/W2941284322","https://openalex.org/W2358668433","https://openalex.org/W4224920876","https://openalex.org/W2168299207"],"abstract_inverted_index":{"Learned":[0],"cardinality":[1,33],"estimators":[2],"have":[3],"shown":[4],"remarkable":[5],"improvements":[6],"in":[7,25,40],"estimation":[8,51,82],"accuracy":[9],"by":[10],"exploiting":[11],"machine":[12],"learning":[13],"techniques,":[14],"yet":[15],"suffer":[16],"from":[17],"inefficiency":[18],"or":[19],"sub-optimal":[20],"query":[21,26],"plans":[22],"when":[23],"deployed":[24],"optimizers.":[27],"ASM":[28],"is":[29],"a":[30],"new":[31],"learned":[32],"estimator":[34],"that":[35,54],"significantly":[36],"outperformed":[37],"previous":[38],"approaches":[39],"terms":[41],"of":[42,53],"end-to-end":[43],"execution":[44],"times.":[45],"This":[46],"demonstration":[47],"illustrates":[48],"the":[49,75,81],"internal":[50],"process":[52],"utilizes":[55],"autoregressive":[56],"models,":[57],"sampling,":[58],"and":[59,63],"multi-dimensional":[60],"statistics":[61],"merging,":[62],"compares":[64],"its":[65],"performance":[66],"with":[67],"other":[68],"alternatives.":[69],"To":[70],"do":[71],"so,":[72],"we":[73],"visualize":[74],"detailed":[76],"plan":[77],"space":[78],"exploration":[79],"utilizing":[80],"results.":[83]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}