{"id":"https://openalex.org/W3161742868","doi":"https://doi.org/10.14778/3529337.3529339","title":"Accurate summary-based cardinality estimation through the lens of cardinality estimation graphs","display_name":"Accurate summary-based cardinality estimation through the lens of cardinality estimation graphs","publication_year":2022,"publication_date":"2022-04-01","ids":{"openalex":"https://openalex.org/W3161742868","doi":"https://doi.org/10.14778/3529337.3529339","mag":"3161742868"},"language":"en","primary_location":{"id":"doi:10.14778/3529337.3529339","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3529337.3529339","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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 VLDB Endowment","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/A5078841290","display_name":"Jeremy Chen","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":true,"raw_author_name":"Jeremy Chen","raw_affiliation_strings":["University of Waterloo"],"affiliations":[{"raw_affiliation_string":"University of Waterloo","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5042480078","display_name":"Yuqing Huang","orcid":"https://orcid.org/0000-0002-1713-9602"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Yuqing Huang","raw_affiliation_strings":["University of Waterloo"],"affiliations":[{"raw_affiliation_string":"University of Waterloo","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064281555","display_name":"Mushi Wang","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Mushi Wang","raw_affiliation_strings":["University of Waterloo"],"affiliations":[{"raw_affiliation_string":"University of Waterloo","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023876520","display_name":"Semih Saliho\u011flu","orcid":"https://orcid.org/0000-0002-8112-4501"},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Semih Salihoglu","raw_affiliation_strings":["University of Waterloo"],"affiliations":[{"raw_affiliation_string":"University of Waterloo","institution_ids":["https://openalex.org/I151746483"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5084611773","display_name":"Ken Salem","orcid":null},"institutions":[{"id":"https://openalex.org/I151746483","display_name":"University of Waterloo","ror":"https://ror.org/01aff2v68","country_code":"CA","type":"education","lineage":["https://openalex.org/I151746483"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"Ken Salem","raw_affiliation_strings":["University of Waterloo"],"affiliations":[{"raw_affiliation_string":"University of Waterloo","institution_ids":["https://openalex.org/I151746483"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5078841290"],"corresponding_institution_ids":["https://openalex.org/I151746483"],"apc_list":null,"apc_paid":null,"fwci":2.5691,"has_fulltext":false,"cited_by_count":19,"citation_normalized_percentile":{"value":0.8945606,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"15","issue":"8","first_page":"1533","last_page":"1545"},"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.9997000098228455,"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.9997000098228455,"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/T11106","display_name":"Data Management and Algorithms","score":0.9991999864578247,"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/T11719","display_name":"Data Quality and Management","score":0.9991999864578247,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/estimator","display_name":"Estimator","score":0.9094398021697998},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.7317425608634949},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4873281419277191},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.4682627320289612},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.4517218768596649},{"id":"https://openalex.org/keywords/joins","display_name":"Joins","score":0.4320601224899292},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.34470513463020325},{"id":"https://openalex.org/keywords/mathematical-optimization","display_name":"Mathematical optimization","score":0.3434993624687195},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.19778728485107422},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.18014636635780334}],"concepts":[{"id":"https://openalex.org/C185429906","wikidata":"https://www.wikidata.org/wiki/Q1130160","display_name":"Estimator","level":2,"score":0.9094398021697998},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.7317425608634949},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4873281419277191},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.4682627320289612},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.4517218768596649},{"id":"https://openalex.org/C2778692605","wikidata":"https://www.wikidata.org/wiki/Q4041866","display_name":"Joins","level":2,"score":0.4320601224899292},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.34470513463020325},{"id":"https://openalex.org/C126255220","wikidata":"https://www.wikidata.org/wiki/Q141495","display_name":"Mathematical optimization","level":1,"score":0.3434993624687195},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.19778728485107422},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.18014636635780334},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3529337.3529339","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3529337.3529339","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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 VLDB Endowment","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":41,"referenced_works":["https://openalex.org/W1537369822","https://openalex.org/W1539479527","https://openalex.org/W1581547316","https://openalex.org/W1588349761","https://openalex.org/W1589269155","https://openalex.org/W1810256132","https://openalex.org/W1975887898","https://openalex.org/W2021850646","https://openalex.org/W2041961594","https://openalex.org/W2065311396","https://openalex.org/W2073479529","https://openalex.org/W2089247435","https://openalex.org/W2100387739","https://openalex.org/W2117849706","https://openalex.org/W2124533460","https://openalex.org/W2132560950","https://openalex.org/W2143672210","https://openalex.org/W2156664231","https://openalex.org/W2166443874","https://openalex.org/W2168865746","https://openalex.org/W2169998163","https://openalex.org/W2171361281","https://openalex.org/W2212047990","https://openalex.org/W2243803726","https://openalex.org/W2396309311","https://openalex.org/W2402498022","https://openalex.org/W2421547754","https://openalex.org/W2424452828","https://openalex.org/W2585664214","https://openalex.org/W2755385361","https://openalex.org/W2786268876","https://openalex.org/W2890276152","https://openalex.org/W2946026089","https://openalex.org/W2950833175","https://openalex.org/W2962730682","https://openalex.org/W2963101491","https://openalex.org/W2970204999","https://openalex.org/W3030639942","https://openalex.org/W3104921985","https://openalex.org/W3198307109","https://openalex.org/W4255671299"],"related_works":["https://openalex.org/W2158013543","https://openalex.org/W2073547112","https://openalex.org/W2462670247","https://openalex.org/W4230850137","https://openalex.org/W575918167","https://openalex.org/W2612896625","https://openalex.org/W2596944507","https://openalex.org/W4379932427","https://openalex.org/W3161742868","https://openalex.org/W4310609877"],"abstract_inverted_index":{"This":[0,226],"paper":[1],"is":[2,170],"an":[3,132,143,232],"experimental":[4],"and":[5,21,38,42,91,118,161,204,240],"analytical":[6],"study":[7],"of":[8,11,27,127,154],"two":[9],"classes":[10],"summary-based":[12],"cardinality":[13,67,82],"estimators":[14,34,47,61,72,104,129,203,209,236],"that":[15,35,48,101,147,201,217,250],"use":[16,49,62],"statistics":[17,64],"about":[18],"input":[19],"relations":[20],"small-size":[22,164],"joins":[23],"in":[24,80,211],"the":[25,44,152,155,167,174,244],"context":[26],"graph":[28,84],"database":[29],"management":[30],"systems:":[31],"(i)":[32],"optimistic":[33,60,103,128,202,238],"make":[36,131],"uniformity":[37],"conditional":[39],"independence":[40],"assumptions;":[41],"(ii)":[43],"recent":[45,223],"pessimistic":[46,208,224,235,245],"information":[50],"theoretic":[51],"linear":[52],"programs":[53],"(LPs).":[54],"We":[55,69,99,140,198],"begin":[56],"by":[57,193],"analyzing":[58],"how":[59],"pre-computed":[63],"to":[65,130,172,187,230,237],"generate":[66],"estimates.":[68],"show":[70,100,200,216],"these":[71,184],"can":[73,190,219],"be":[74,191],"modeled":[75],"as":[76,89,115,248],"picking":[77,112],"bottom-to-top":[78],"paths":[79,114,149],"a":[81,125],"estimation":[83],"(CEG),":[85],"which":[86,136,189],"contains":[87],"sub-queries":[88],"nodes":[90],"edges":[92],"whose":[93],"weights":[94],"are":[95,210],"average":[96],"degree":[97],"statistics.":[98],"existing":[102,138],"have":[105,252],"either":[106],"undefined":[107],"or":[108],"fixed":[109],"choices":[110],"for":[111],"CEG":[113],"their":[116],"estimates":[117,185],"ignore":[119],"alternative":[120],"choices.":[121],"Instead,":[122],"we":[123,215],"outline":[124],"space":[126],"estimate":[133],"on":[134,151,158,179],"CEGs,":[135],"subsumes":[137],"estimators.":[139,225],"show,":[141],"using":[142,166,194],"extensive":[144],"empirical":[145],"analysis,":[146],"effective":[148,171],"depend":[150],"structure":[153],"queries.":[156],"While":[157],"acyclic":[159],"queries":[160,162,180],"with":[163,181],"cycles,":[165],"maximum-weight":[168],"path":[169],"address":[173],"well":[175],"known":[176],"underestimation":[177],"problem,":[178],"larger":[182],"cycles":[183],"tend":[186],"overestimate,":[188],"addressed":[192],"minimum":[195],"weight":[196],"paths.":[197],"next":[199],"seemingly":[205],"disparate":[206],"LP-based":[207],"fact":[212],"connected.":[213],"Specifically,":[214],"CEGs":[218],"also":[220],"model":[221],"some":[222],"connection":[227],"allows":[228],"us":[229],"adopt":[231],"optimization":[233],"from":[234],"ones,":[239],"provide":[241],"insights":[242],"into":[243],"estimators,":[246],"such":[247],"showing":[249],"they":[251],"combinatorial":[253],"solutions.":[254]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":11},{"year":2024,"cited_by_count":4},{"year":2023,"cited_by_count":3}],"updated_date":"2026-04-11T08:14:18.477133","created_date":"2025-10-10T00:00:00"}