{"id":"https://openalex.org/W1974421547","doi":"https://doi.org/10.1145/2818178","title":"Workload-Driven Antijoin Cardinality Estimation","display_name":"Workload-Driven Antijoin Cardinality Estimation","publication_year":2015,"publication_date":"2015-10-23","ids":{"openalex":"https://openalex.org/W1974421547","doi":"https://doi.org/10.1145/2818178","mag":"1974421547"},"language":"en","primary_location":{"id":"doi:10.1145/2818178","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2818178","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"ACM Transactions on Database Systems","raw_type":"journal-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/A5065838987","display_name":"Florin Rusu","orcid":"https://orcid.org/0000-0002-7018-9043"},"institutions":[{"id":"https://openalex.org/I156087764","display_name":"University of California, Merced","ror":"https://ror.org/00d9ah105","country_code":"US","type":"education","lineage":["https://openalex.org/I156087764"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Florin Rusu","raw_affiliation_strings":["University of California, Merced, CA","University of California, Merced CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Merced, CA","institution_ids":["https://openalex.org/I156087764"]},{"raw_affiliation_string":"University of California, Merced CA#TAB#","institution_ids":["https://openalex.org/I156087764"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5091802679","display_name":"Zixuan Zhuang","orcid":null},"institutions":[{"id":"https://openalex.org/I156087764","display_name":"University of California, Merced","ror":"https://ror.org/00d9ah105","country_code":"US","type":"education","lineage":["https://openalex.org/I156087764"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zixuan Zhuang","raw_affiliation_strings":["University of California, Merced, CA","University of California, Merced CA#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of California, Merced, CA","institution_ids":["https://openalex.org/I156087764"]},{"raw_affiliation_string":"University of California, Merced CA#TAB#","institution_ids":["https://openalex.org/I156087764"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103182309","display_name":"Mingxi Wu","orcid":"https://orcid.org/0009-0009-2738-7018"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mingxi Wu","raw_affiliation_strings":["GraphSQL, Mountain View, CA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"GraphSQL, Mountain View, CA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5002518742","display_name":"Chris Jermaine","orcid":null},"institutions":[{"id":"https://openalex.org/I74775410","display_name":"Rice University","ror":"https://ror.org/008zs3103","country_code":"US","type":"education","lineage":["https://openalex.org/I74775410"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chris Jermaine","raw_affiliation_strings":["Rice University, Houston, TX","Rice University (Houston, TX)"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Rice University, Houston, TX","institution_ids":["https://openalex.org/I74775410"]},{"raw_affiliation_string":"Rice University (Houston, TX)","institution_ids":["https://openalex.org/I74775410"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.5799,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.66611076,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":"40","issue":"3","first_page":"1","last_page":"41"},"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/T11303","display_name":"Bayesian Modeling and Causal Inference","score":0.9970999956130981,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9897000193595886,"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.8058136105537415},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.7915322780609131},{"id":"https://openalex.org/keywords/estimator","display_name":"Estimator","score":0.740476667881012},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.5351292490959167},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.42765557765960693},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.360338032245636},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3363506495952606},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.32884636521339417},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.1864326000213623},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1427428424358368}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8058136105537415},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.7915322780609131},{"id":"https://openalex.org/C185429906","wikidata":"https://www.wikidata.org/wiki/Q1130160","display_name":"Estimator","level":2,"score":0.740476667881012},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.5351292490959167},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.42765557765960693},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.360338032245636},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3363506495952606},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32884636521339417},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.1864326000213623},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1427428424358368},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/2818178","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2818178","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"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":"ACM Transactions on Database Systems","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":53,"referenced_works":["https://openalex.org/W130710483","https://openalex.org/W135863099","https://openalex.org/W1480809079","https://openalex.org/W1486632395","https://openalex.org/W1601435884","https://openalex.org/W1735309556","https://openalex.org/W1779498314","https://openalex.org/W1963765273","https://openalex.org/W1964857063","https://openalex.org/W1975731516","https://openalex.org/W1981462693","https://openalex.org/W1981794144","https://openalex.org/W1985093013","https://openalex.org/W1991271936","https://openalex.org/W1995034419","https://openalex.org/W2002791618","https://openalex.org/W2010890196","https://openalex.org/W2018666252","https://openalex.org/W2020584928","https://openalex.org/W2022858489","https://openalex.org/W2024562752","https://openalex.org/W2027685188","https://openalex.org/W2041563709","https://openalex.org/W2045656233","https://openalex.org/W2045938805","https://openalex.org/W2049633694","https://openalex.org/W2090403603","https://openalex.org/W2095673361","https://openalex.org/W2102166438","https://openalex.org/W2110363867","https://openalex.org/W2120108467","https://openalex.org/W2130695933","https://openalex.org/W2131413649","https://openalex.org/W2132823934","https://openalex.org/W2134786002","https://openalex.org/W2143452574","https://openalex.org/W2150779766","https://openalex.org/W2151310484","https://openalex.org/W2151454464","https://openalex.org/W2153329411","https://openalex.org/W2162569193","https://openalex.org/W2165990006","https://openalex.org/W2171903035","https://openalex.org/W2212047990","https://openalex.org/W2293896416","https://openalex.org/W3083806692","https://openalex.org/W4230435573","https://openalex.org/W4232383088","https://openalex.org/W4237172715","https://openalex.org/W4241185933","https://openalex.org/W4255671299","https://openalex.org/W4292691288","https://openalex.org/W6605485969"],"related_works":["https://openalex.org/W986318368","https://openalex.org/W2384410913","https://openalex.org/W2352878646","https://openalex.org/W2990194547","https://openalex.org/W2004734601","https://openalex.org/W2130149817","https://openalex.org/W1480123525","https://openalex.org/W2414054180","https://openalex.org/W4214892316","https://openalex.org/W2287264064"],"abstract_inverted_index":{"Antijoin":[0],"cardinality":[1,41,52,67,176],"estimation":[2,53],"is":[3,54],"among":[4],"a":[5,61,81,99,110,144,183],"handful":[6],"of":[7,26,47,103,172,182],"problems":[8],"that":[9,68,114],"has":[10],"eluded":[11],"accurate":[12],"efficient":[13,139,174],"solutions":[14,49],"amenable":[15],"to":[16,77,120,128,131,149],"implementation":[17],"in":[18,31,80,147],"relational":[19],"query":[20,82,184],"optimizers.":[21],"Given":[22],"the":[23,35,104,116,121,126,132,159,162,170,179,189],"widespread":[24],"use":[25,93],"antijoin":[27,51,66,175],"and":[28,34,75],"subset-based":[29],"queries":[30],"analytical":[32],"workloads":[33],"extensive":[36,190],"research":[37],"targeted":[38],"at":[39],"join":[40],"estimation\u2014a":[42],"seemingly":[43],"related":[44],"problem\u2014the":[45],"lack":[46],"adequate":[48],"for":[50,65,141],"intriguing.":[55],"In":[56],"this":[57],"article,":[58],"we":[59,92,108,136],"introduce":[60],"novel":[62,89],"sampling-based":[63],"estimator":[64,86,127,177],"(unlike":[69],"existent":[70],"estimators)":[71],"provides":[72],"sufficient":[73],"accuracy":[74],"efficiency":[76],"be":[78],"implemented":[79],"optimizer.":[83],"The":[84],"proposed":[85],"incorporates":[87],"three":[88],"ideas.":[90],"First,":[91],"prior":[94],"workload":[95],"information":[96],"when":[97],"learning":[98],"mixture":[100],"superpopulation":[101,117],"model":[102,118],"data":[105],"offline.":[106],"Second,":[107],"design":[109],"Bayesian":[111],"statistics":[112],"framework":[113],"updates":[115],"according":[119],"live":[122],"queries,":[123],"thus":[124],"allowing":[125],"adapt":[129],"dynamically":[130],"online":[133],"workload.":[134],"Third,":[135],"develop":[137],"an":[138,173],"algorithm":[140],"sampling":[142],"from":[143],"hypergeometric":[145],"distribution":[146],"order":[148],"generate":[150],"Monte":[151],"Carlo":[152],"trials":[153],",":[154],"without":[155],"explicitly":[156],"instantiating":[157],"either":[158],"population":[160],"or":[161],"sample.":[163],"When":[164],"put":[165],"together,":[166],"these":[167],"ideas":[168],"form":[169],"basis":[171],"satisfying":[178],"strict":[180],"requirements":[181],"optimizer,":[185],"as":[186,195,197],"shown":[187],"by":[188],"experimental":[191],"results":[192],"over":[193],"synthetically-generated":[194],"well":[196],"massive":[198],"TPC-H":[199],"data.":[200]},"counts_by_year":[{"year":2018,"cited_by_count":2}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}