{"id":"https://openalex.org/W2906910993","doi":"https://doi.org/10.1145/3318464.3389727","title":"QuickSel: Quick Selectivity Learning with Mixture Models","display_name":"QuickSel: Quick Selectivity Learning with Mixture Models","publication_year":2020,"publication_date":"2020-05-29","ids":{"openalex":"https://openalex.org/W2906910993","doi":"https://doi.org/10.1145/3318464.3389727","mag":"2906910993"},"language":"en","primary_location":{"id":"doi:10.1145/3318464.3389727","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3318464.3389727","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},"type":"conference-paper","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1812.10568","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Yongjoo Park","orcid":null},"institutions":[{"id":"https://openalex.org/I157725225","display_name":"University of Illinois Urbana-Champaign","ror":"https://ror.org/047426m28","country_code":"US","type":"education","lineage":["https://openalex.org/I157725225"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yongjoo Park","raw_affiliation_strings":["University of Illinois at Urbana-Champaign, Urbana, IL, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Illinois at Urbana-Champaign, Urbana, IL, USA","institution_ids":["https://openalex.org/I157725225"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Shucheng Zhong","orcid":null},"institutions":[{"id":"https://openalex.org/I27837315","display_name":"University of Michigan","ror":"https://ror.org/00jmfr291","country_code":"US","type":"education","lineage":["https://openalex.org/I27837315"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Shucheng Zhong","raw_affiliation_strings":["University of Michigan - Ann Arbor, Ann Arbor, MI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Michigan - Ann Arbor, Ann Arbor, MI, USA","institution_ids":["https://openalex.org/I27837315"]}]},{"author_position":"last","author":{"id":null,"display_name":"Barzan Mozafari","orcid":null},"institutions":[{"id":"https://openalex.org/I27837315","display_name":"University of Michigan","ror":"https://ror.org/00jmfr291","country_code":"US","type":"education","lineage":["https://openalex.org/I27837315"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Barzan Mozafari","raw_affiliation_strings":["University of Michigan - Ann Arbor, Ann Arbor, MI, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Michigan - Ann Arbor, Ann Arbor, MI, USA","institution_ids":["https://openalex.org/I27837315"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":63,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"1017","last_page":"1033"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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.9988999962806702,"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/T11269","display_name":"Algorithms and Data Compression","score":0.9984999895095825,"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/histogram","display_name":"Histogram","score":0.7545999884605408},{"id":"https://openalex.org/keywords/mixture-model","display_name":"Mixture model","score":0.5519999861717224},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.521399974822998},{"id":"https://openalex.org/keywords/selectivity","display_name":"Selectivity","score":0.45890000462532043},{"id":"https://openalex.org/keywords/pattern-recognition","display_name":"Pattern recognition (psychology)","score":0.387800008058548},{"id":"https://openalex.org/keywords/yield","display_name":"Yield (engineering)","score":0.34279999136924744}],"concepts":[{"id":"https://openalex.org/C53533937","wikidata":"https://www.wikidata.org/wiki/Q185020","display_name":"Histogram","level":3,"score":0.7545999884605408},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6680999994277954},{"id":"https://openalex.org/C61224824","wikidata":"https://www.wikidata.org/wiki/Q2260434","display_name":"Mixture model","level":2,"score":0.5519999861717224},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.521399974822998},{"id":"https://openalex.org/C118792377","wikidata":"https://www.wikidata.org/wiki/Q108584245","display_name":"Selectivity","level":3,"score":0.45890000462532043},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.43959999084472656},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.399399995803833},{"id":"https://openalex.org/C153180895","wikidata":"https://www.wikidata.org/wiki/Q7148389","display_name":"Pattern recognition (psychology)","level":2,"score":0.387800008058548},{"id":"https://openalex.org/C134121241","wikidata":"https://www.wikidata.org/wiki/Q899301","display_name":"Yield (engineering)","level":2,"score":0.34279999136924744},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3278999924659729},{"id":"https://openalex.org/C160920958","wikidata":"https://www.wikidata.org/wiki/Q7662746","display_name":"Synthetic data","level":2,"score":0.32249999046325684},{"id":"https://openalex.org/C155512373","wikidata":"https://www.wikidata.org/wiki/Q287450","display_name":"Residual","level":2,"score":0.3158000111579895},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.30230000615119934},{"id":"https://openalex.org/C151376022","wikidata":"https://www.wikidata.org/wiki/Q168698","display_name":"Exponential function","level":2,"score":0.30070000886917114},{"id":"https://openalex.org/C2776502983","wikidata":"https://www.wikidata.org/wiki/Q690182","display_name":"Contrast (vision)","level":2,"score":0.28110000491142273},{"id":"https://openalex.org/C51632099","wikidata":"https://www.wikidata.org/wiki/Q3985153","display_name":"Training set","level":2,"score":0.2623000144958496},{"id":"https://openalex.org/C2778572836","wikidata":"https://www.wikidata.org/wiki/Q380933","display_name":"Space (punctuation)","level":2,"score":0.25679999589920044}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/3318464.3389727","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3318464.3389727","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2020 ACM SIGMOD International Conference on Management of Data","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1812.10568","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1812.10568","pdf_url":"https://arxiv.org/pdf/1812.10568","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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1812.10568","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1812.10568","pdf_url":"https://arxiv.org/pdf/1812.10568","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":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G4874361201","display_name":null,"funder_award_id":"1629397","funder_id":"https://openalex.org/F4320315254","funder_display_name":"Innovative Research Group Project of the National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320315254","display_name":"Innovative Research Group Project of the National Natural Science Foundation of China","ror":null}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":89,"referenced_works":["https://openalex.org/W25483517","https://openalex.org/W975351372","https://openalex.org/W1480643633","https://openalex.org/W1480794755","https://openalex.org/W1480809079","https://openalex.org/W1493098199","https://openalex.org/W1530498197","https://openalex.org/W1556530724","https://openalex.org/W1600880963","https://openalex.org/W1602727134","https://openalex.org/W1608665031","https://openalex.org/W1764905529","https://openalex.org/W1870815170","https://openalex.org/W1947403449","https://openalex.org/W1964482959","https://openalex.org/W1968367053","https://openalex.org/W1968829657","https://openalex.org/W1981462693","https://openalex.org/W1993831977","https://openalex.org/W2004825836","https://openalex.org/W2007451827","https://openalex.org/W2008931591","https://openalex.org/W2019961888","https://openalex.org/W2021993549","https://openalex.org/W2027138312","https://openalex.org/W2029798546","https://openalex.org/W2037192958","https://openalex.org/W2041851430","https://openalex.org/W2044760336","https://openalex.org/W2053075747","https://openalex.org/W2057576485","https://openalex.org/W2061750459","https://openalex.org/W2063512404","https://openalex.org/W2075712468","https://openalex.org/W2080566084","https://openalex.org/W2087874866","https://openalex.org/W2089059416","https://openalex.org/W2096498985","https://openalex.org/W2099259603","https://openalex.org/W2100913274","https://openalex.org/W2102489964","https://openalex.org/W2106475159","https://openalex.org/W2107628111","https://openalex.org/W2107653846","https://openalex.org/W2109906716","https://openalex.org/W2112056262","https://openalex.org/W2120108467","https://openalex.org/W2123575007","https://openalex.org/W2126365559","https://openalex.org/W2129905273","https://openalex.org/W2130283598","https://openalex.org/W2132560950","https://openalex.org/W2134364602","https://openalex.org/W2138793904","https://openalex.org/W2143672210","https://openalex.org/W2144661390","https://openalex.org/W2145499969","https://openalex.org/W2147440220","https://openalex.org/W2150779766","https://openalex.org/W2153329411","https://openalex.org/W2175806766","https://openalex.org/W2489619167","https://openalex.org/W2605843372","https://openalex.org/W2613206411","https://openalex.org/W2732582420","https://openalex.org/W2799015892","https://openalex.org/W2888919756","https://openalex.org/W2949044932","https://openalex.org/W2950833175","https://openalex.org/W2955798121","https://openalex.org/W2962771342","https://openalex.org/W2970148517","https://openalex.org/W3021702690","https://openalex.org/W4231287357","https://openalex.org/W4236656499","https://openalex.org/W4254149337","https://openalex.org/W4255671299","https://openalex.org/W4291720394","https://openalex.org/W4299841484","https://openalex.org/W6629510986","https://openalex.org/W6638337754","https://openalex.org/W6641869264","https://openalex.org/W6643254419","https://openalex.org/W6665104178","https://openalex.org/W6679001947","https://openalex.org/W6713425744","https://openalex.org/W6759199104","https://openalex.org/W6761818208","https://openalex.org/W7074562860"],"related_works":[],"abstract_inverted_index":{"Estimating":[0],"the":[1,31,34,66,70,74,117,132,196,214],"selectivity":[2,52,109,164],"of":[3,17,73,92,131],"a":[4,7,108,174,178],"query":[5,14,158],"is":[6,201,219],"key":[8],"step":[9],"in":[10,86],"almost":[11],"any":[12],"cost-based":[13],"optimizer.":[15],"Most":[16],"today's":[18],"databases":[19],"rely":[20],"on":[21,69,173,189],"histograms":[22,60,67,225],"or":[23],"samples":[24],"that":[25],"are":[26,41,45,80],"periodically":[27],"refreshed":[28],"by":[29],"re-scanning":[30],"data":[32,36],"as":[33,98],"underlying":[35,133],"changes.":[37],"Since":[38],"frequent":[39],"scans":[40],"costly,":[42],"these":[43,78],"statistics":[44],"often":[46],"stale":[47],"and":[48,159,177,210,226],"lead":[49],"to":[50,57,84,153],"poor":[51],"estimates.":[53],"As":[54],"an":[55,89,128],"alternative":[56],"scans,":[58],"query-driven":[59,118,169,206],"have":[61],"been":[62],"proposed,":[63],"which":[64,114,135],"refine":[65],"based":[68],"actual":[71],"selectivities":[72],"observed":[75],"queries.":[76,102],"Unfortunately,":[77],"approaches":[79],"either":[81],"too":[82],"costly":[83],"use":[85,123],"practice---i.e.,":[87],"require":[88],"exponential":[90],"number":[91],"buckets---or":[93],"quickly":[94],"lose":[95],"their":[96],"advantage":[97],"they":[99],"observe":[100],"more":[101,162,221],"In":[103],"this":[104],"paper,":[105],"we":[106],"propose":[107],"learning":[110],"framework,":[111],"called":[112],"QuickSel,":[113],"falls":[115],"into":[116],"paradigm":[119],"but":[120],"does":[121],"not":[122],"histograms.":[124],"Instead,":[125],"it":[126],"builds":[127],"internal":[129],"model":[130,176],"data,":[134],"can":[136],"be":[137],"refined":[138],"significantly":[139],"faster":[140,203],"(e.g.,":[141],"only":[142],"1.9":[143],"milliseconds":[144],"for":[145,182],"300":[146],"queries).":[147],"This":[148],"fast":[149],"refinement":[150],"allows":[151],"QuickSel":[152,171,200,218],"continuously":[154],"learn":[155],"from":[156],"each":[157],"yield":[160],"increasingly":[161],"accurate":[163,222],"estimates":[165],"over":[166],"time.":[167],"Unlike":[168],"histograms,":[170,207],"relies":[172],"mixture":[175],"new":[179],"optimization":[180],"algorithm":[181],"training":[183],"its":[184],"model.":[185],"Our":[186],"extensive":[187],"experiments":[188],"two":[190],"real-world":[191],"datasets":[192],"confirm":[193],"that,":[194],"given":[195,213],"same":[197,215],"target":[198],"accuracy,":[199],"34.0x--179.4x":[202],"than":[204,223],"state-of-the-art":[205],"including":[208],"ISOMER":[209],"STHoles.":[211],"Further,":[212],"space":[216],"budget,":[217],"26.8%--91.8%":[220],"periodically-updated":[224],"samples,":[227],"respectively.":[228]},"counts_by_year":[{"year":2026,"cited_by_count":4},{"year":2025,"cited_by_count":12},{"year":2024,"cited_by_count":11},{"year":2023,"cited_by_count":11},{"year":2022,"cited_by_count":6},{"year":2021,"cited_by_count":17},{"year":2020,"cited_by_count":2}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2019-01-11T00:00:00"}