{"id":"https://openalex.org/W2950833175","doi":"https://doi.org/10.1145/3299869.3319894","title":"Pessimistic Cardinality Estimation","display_name":"Pessimistic Cardinality Estimation","publication_year":2019,"publication_date":"2019-06-18","ids":{"openalex":"https://openalex.org/W2950833175","doi":"https://doi.org/10.1145/3299869.3319894","mag":"2950833175"},"language":"en","primary_location":{"id":"doi:10.1145/3299869.3319894","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3299869.3319894","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3319894","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3319894","any_repository_has_fulltext":null},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5002086896","display_name":"Walter Cai","orcid":null},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Walter Cai","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064988079","display_name":"Magdalena Ba\u0142azi\u0144ska","orcid":"https://orcid.org/0000-0002-6805-0325"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Magdalena Balazinska","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048204602","display_name":"Dan Suciu","orcid":"https://orcid.org/0000-0002-4144-0868"},"institutions":[{"id":"https://openalex.org/I201448701","display_name":"University of Washington","ror":"https://ror.org/00cvxb145","country_code":"US","type":"education","lineage":["https://openalex.org/I201448701"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dan Suciu","raw_affiliation_strings":["University of Washington, Seattle, WA, USA"],"affiliations":[{"raw_affiliation_string":"University of Washington, Seattle, WA, USA","institution_ids":["https://openalex.org/I201448701"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5002086896"],"corresponding_institution_ids":["https://openalex.org/I201448701"],"apc_list":null,"apc_paid":null,"fwci":5.6749,"has_fulltext":true,"cited_by_count":76,"citation_normalized_percentile":{"value":0.96786758,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"18","last_page":"35"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9998999834060669,"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.9998999834060669,"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.9991999864578247,"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/T10627","display_name":"Advanced Image and Video Retrieval Techniques","score":0.9987999796867371,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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.7256510257720947},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.6778362989425659},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.6227906942367554},{"id":"https://openalex.org/keywords/hash-function","display_name":"Hash function","score":0.55865478515625},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.4810676574707031},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.4791392982006073},{"id":"https://openalex.org/keywords/monotonic-function","display_name":"Monotonic function","score":0.47095948457717896},{"id":"https://openalex.org/keywords/parameterized-complexity","display_name":"Parameterized complexity","score":0.4583562910556793},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.4276264011859894},{"id":"https://openalex.org/keywords/join","display_name":"Join (topology)","score":0.41926127672195435},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4074598252773285},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.40008583664894104},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.30642491579055786},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2719331979751587},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.16331705451011658},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.10429728031158447}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7256510257720947},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.6778362989425659},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.6227906942367554},{"id":"https://openalex.org/C99138194","wikidata":"https://www.wikidata.org/wiki/Q183427","display_name":"Hash function","level":2,"score":0.55865478515625},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.4810676574707031},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.4791392982006073},{"id":"https://openalex.org/C72169020","wikidata":"https://www.wikidata.org/wiki/Q194404","display_name":"Monotonic function","level":2,"score":0.47095948457717896},{"id":"https://openalex.org/C165464430","wikidata":"https://www.wikidata.org/wiki/Q1570441","display_name":"Parameterized complexity","level":2,"score":0.4583562910556793},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.4276264011859894},{"id":"https://openalex.org/C2776124973","wikidata":"https://www.wikidata.org/wiki/Q3183033","display_name":"Join (topology)","level":2,"score":0.41926127672195435},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4074598252773285},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.40008583664894104},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.30642491579055786},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2719331979751587},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.16331705451011658},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.10429728031158447},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3299869.3319894","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3299869.3319894","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3319894","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"}],"best_oa_location":{"id":"doi:10.1145/3299869.3319894","is_oa":true,"landing_page_url":"https://doi.org/10.1145/3299869.3319894","pdf_url":"https://dl.acm.org/doi/pdf/10.1145/3299869.3319894","source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2019 International Conference on Management of Data","raw_type":"proceedings-article"},"sustainable_development_goals":[{"display_name":"Partnerships for the goals","id":"https://metadata.un.org/sdg/17","score":0.47999998927116394}],"awards":[{"id":"https://openalex.org/G620229259","display_name":null,"funder_award_id":"1614738","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"},{"id":"https://openalex.org/G656365904","display_name":null,"funder_award_id":"1535565","funder_id":"https://openalex.org/F4320306076","funder_display_name":"National Science Foundation"}],"funders":[{"id":"https://openalex.org/F4320306076","display_name":"National Science Foundation","ror":"https://ror.org/021nxhr62"},{"id":"https://openalex.org/F4320319907","display_name":"Alberta Innovates - Technology Futures","ror":"https://ror.org/00ynafe15"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2950833175.pdf","grobid_xml":"https://content.openalex.org/works/W2950833175.grobid-xml"},"referenced_works_count":20,"referenced_works":["https://openalex.org/W166430344","https://openalex.org/W2008552727","https://openalex.org/W2026966899","https://openalex.org/W2066623874","https://openalex.org/W2089369802","https://openalex.org/W2132823934","https://openalex.org/W2143452574","https://openalex.org/W2153180521","https://openalex.org/W2153329411","https://openalex.org/W2153406069","https://openalex.org/W2169998163","https://openalex.org/W2243803726","https://openalex.org/W2396309311","https://openalex.org/W2429510775","https://openalex.org/W2545307730","https://openalex.org/W2585664214","https://openalex.org/W2612048434","https://openalex.org/W2798325362","https://openalex.org/W2808009442","https://openalex.org/W2963898466"],"related_works":["https://openalex.org/W2051058708","https://openalex.org/W1494268238","https://openalex.org/W154868527","https://openalex.org/W1983207144","https://openalex.org/W2490706771","https://openalex.org/W4205996836","https://openalex.org/W2480116122","https://openalex.org/W4300943255","https://openalex.org/W4400143025","https://openalex.org/W2168592511"],"abstract_inverted_index":{"In":[0,121,150],"this":[1,124,193],"work":[2],"we":[3,126,157],"introduce":[4,127],"a":[5,82,92,128,159],"novel":[6],"approach":[7,18],"to":[8,25,54,75,176,196],"the":[9,30,34,39,46,76,97,103,145,151,182],"problem":[10],"of":[11,33,99,107,153],"cardinality":[12,184],"estimation":[13,185],"over":[14,166,197],"multijoin":[15],"queries.":[16],"Our":[17],"leveraging":[19],"randomized":[20],"hashing":[21],"and":[22,66,68,102,105,144],"data":[23,64,109],"sketching":[24],"tighten":[26],"these":[27,70],"bounds":[28,40,71,101],"beyond":[29],"current":[31],"state":[32],"art.":[35],"We":[36,60,90,136],"demonstrate":[37,91,158],"that":[38,132],"can":[41],"be":[42,73],"injected":[43],"directly":[44],"into":[45],"cost":[47,79],"based":[48],"query":[49,172],"optimizer":[50],"framework":[51],"enabling":[52],"it":[53],"avoid":[55],"expensive":[56],"physical":[57,86,171],"join":[58,87],"plans.":[59],"outline":[61],"our":[62,100,108,138],"base":[63],"structures":[65],"methodology,":[67],"how":[69],"may":[72],"introduced":[74],"optimizer's":[77],"parameterized":[78],"function":[80],"as":[81,117],"new":[83],"statistic":[84],"for":[85],"plan":[88,173],"selection.":[89],"complex":[93],"tradeoff":[94],"space":[95,112],"between":[96],"tightness":[98],"size":[104],"complexity":[106],"structures.":[110],"This":[111],"is":[113],"not":[114],"always":[115],"monotonic":[116,134],"one":[118],"might":[119],"expect.":[120],"order":[122],"combat":[123],"non-monotonicity,":[125],"partition":[129],"budgeting":[130],"scheme":[131],"guarantees":[133],"behavior.":[135],"evaluate":[137],"methods":[139],"on":[140],"GooglePlus":[141],"community":[142],"graphs~\\citegoogleplus,":[143],"Join":[146],"Order":[147],"Benchmark":[148],"(JOB)~\\citeLeis:2015:GQO:2850583.2850594.":[149],"presence":[152],"foreign":[154,188],"key":[155,189],"indexes,":[156],"$1.7\\times$":[160],"improvement":[161],"in":[162,169],"aggregate":[163],"(time":[164],"summed":[165],"all":[167],"queries":[168],"benchmark)":[170],"runtime":[174],"compared":[175],"plans":[177],"chosen":[178],"by":[179],"Postgres":[180],"using":[181],"default":[183],"methods.":[186],"When":[187],"indexes":[190],"are":[191],"absent,":[192],"advantage":[194],"improves":[195],"$10\\times$.":[198]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":13},{"year":2024,"cited_by_count":14},{"year":2023,"cited_by_count":13},{"year":2022,"cited_by_count":8},{"year":2021,"cited_by_count":17},{"year":2020,"cited_by_count":7},{"year":2019,"cited_by_count":2}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}