{"id":"https://openalex.org/W2991530444","doi":"https://doi.org/10.14778/3368289.3368294","title":"Deep unsupervised cardinality estimation","display_name":"Deep unsupervised cardinality estimation","publication_year":2019,"publication_date":"2019-11-01","ids":{"openalex":"https://openalex.org/W2991530444","doi":"https://doi.org/10.14778/3368289.3368294","mag":"2991530444"},"language":"en","primary_location":{"id":"doi:10.14778/3368289.3368294","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3368289.3368294","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":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1905.04278","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5103011963","display_name":"Zongheng Yang","orcid":"https://orcid.org/0000-0001-8716-8743"},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zongheng Yang","raw_affiliation_strings":["UC Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064891668","display_name":"Eric Liang","orcid":"https://orcid.org/0000-0002-3760-6845"},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Eric Liang","raw_affiliation_strings":["UC Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018727500","display_name":"Amog Kamsetty","orcid":null},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Amog Kamsetty","raw_affiliation_strings":["UC Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034693651","display_name":"Chenggang Wu","orcid":"https://orcid.org/0000-0002-2716-4393"},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Chenggang Wu","raw_affiliation_strings":["UC Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102881531","display_name":"Yan Duan","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yan Duan","raw_affiliation_strings":["covariant.ai"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"covariant.ai","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100718286","display_name":"Xi Chen","orcid":"https://orcid.org/0000-0003-2254-460X"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xi Chen","raw_affiliation_strings":["UC Berkeley and covariant.ai"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Berkeley and covariant.ai","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5049349154","display_name":"Pieter Abbeel","orcid":null},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Pieter Abbeel","raw_affiliation_strings":["UC Berkeley and covariant.ai"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Berkeley and covariant.ai","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043626252","display_name":"Joseph M. Hellerstein","orcid":"https://orcid.org/0000-0002-7712-4306"},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Joseph M. Hellerstein","raw_affiliation_strings":["UC Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018480426","display_name":"Sanjay Krishnan","orcid":"https://orcid.org/0000-0001-6968-4090"},"institutions":[{"id":"https://openalex.org/I40347166","display_name":"University of Chicago","ror":"https://ror.org/024mw5h28","country_code":"US","type":"education","lineage":["https://openalex.org/I40347166"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sanjay Krishnan","raw_affiliation_strings":["University of Chicago"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Chicago","institution_ids":["https://openalex.org/I40347166"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041920173","display_name":"Ion Stoica","orcid":"https://orcid.org/0000-0002-5373-0088"},"institutions":[{"id":"https://openalex.org/I134446601","display_name":"Berkeley College","ror":"https://ror.org/02xewxa75","country_code":"US","type":"education","lineage":["https://openalex.org/I134446601"]},{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ion Stoica","raw_affiliation_strings":["UC Berkeley"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"UC Berkeley","institution_ids":["https://openalex.org/I134446601","https://openalex.org/I95457486"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":14.5516,"has_fulltext":false,"cited_by_count":200,"citation_normalized_percentile":{"value":0.99453689,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":100},"biblio":{"volume":"13","issue":"3","first_page":"279","last_page":"292"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9997000098228455,"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.9997000098228455,"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/T10637","display_name":"Advanced Clustering Algorithms Research","score":0.9958000183105469,"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.9909999966621399,"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/estimator","display_name":"Estimator","score":0.7699514627456665},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6693983674049377},{"id":"https://openalex.org/keywords/autoregressive-model","display_name":"Autoregressive model","score":0.6173511147499084},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.5896145701408386},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.5404196381568909},{"id":"https://openalex.org/keywords/usable","display_name":"USable","score":0.47702500224113464},{"id":"https://openalex.org/keywords/independence","display_name":"Independence (probability theory)","score":0.44621920585632324},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.4244707226753235},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36290836334228516},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.23276543617248535},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.21007421612739563}],"concepts":[{"id":"https://openalex.org/C185429906","wikidata":"https://www.wikidata.org/wiki/Q1130160","display_name":"Estimator","level":2,"score":0.7699514627456665},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6693983674049377},{"id":"https://openalex.org/C159877910","wikidata":"https://www.wikidata.org/wiki/Q2202883","display_name":"Autoregressive model","level":2,"score":0.6173511147499084},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.5896145701408386},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.5404196381568909},{"id":"https://openalex.org/C2780615836","wikidata":"https://www.wikidata.org/wiki/Q2471869","display_name":"USable","level":2,"score":0.47702500224113464},{"id":"https://openalex.org/C35651441","wikidata":"https://www.wikidata.org/wiki/Q625303","display_name":"Independence (probability theory)","level":2,"score":0.44621920585632324},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4244707226753235},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36290836334228516},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.23276543617248535},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.21007421612739563},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.14778/3368289.3368294","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3368289.3368294","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"},{"id":"pmh:oai:arXiv.org:1905.04278","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1905.04278","pdf_url":"https://arxiv.org/pdf/1905.04278","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:1905.04278","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1905.04278","pdf_url":"https://arxiv.org/pdf/1905.04278","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":[{"display_name":"Partnerships for the goals","score":0.4399999976158142,"id":"https://metadata.un.org/sdg/17"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":81,"referenced_works":["https://openalex.org/W204885769","https://openalex.org/W1480376833","https://openalex.org/W1487588218","https://openalex.org/W1511986666","https://openalex.org/W1522301498","https://openalex.org/W1581547316","https://openalex.org/W1866230956","https://openalex.org/W1947403449","https://openalex.org/W1964857063","https://openalex.org/W1976625337","https://openalex.org/W2022858489","https://openalex.org/W2046437776","https://openalex.org/W2075712468","https://openalex.org/W2099111195","https://openalex.org/W2102166438","https://openalex.org/W2112056262","https://openalex.org/W2120108467","https://openalex.org/W2132244350","https://openalex.org/W2138793904","https://openalex.org/W2144661390","https://openalex.org/W2150779766","https://openalex.org/W2151454464","https://openalex.org/W2153329411","https://openalex.org/W2163166770","https://openalex.org/W2163288162","https://openalex.org/W2168865746","https://openalex.org/W2170111110","https://openalex.org/W2171903035","https://openalex.org/W2210387432","https://openalex.org/W2396309311","https://openalex.org/W2396635388","https://openalex.org/W2401576518","https://openalex.org/W2402498022","https://openalex.org/W2423557781","https://openalex.org/W2519091744","https://openalex.org/W2559655401","https://openalex.org/W2581236139","https://openalex.org/W2585664214","https://openalex.org/W2612690371","https://openalex.org/W2626778328","https://openalex.org/W2755385361","https://openalex.org/W2766026698","https://openalex.org/W2790625403","https://openalex.org/W2795239330","https://openalex.org/W2885801653","https://openalex.org/W2890276152","https://openalex.org/W2892181857","https://openalex.org/W2896457183","https://openalex.org/W2911540814","https://openalex.org/W2922302645","https://openalex.org/W2939789414","https://openalex.org/W2949382160","https://openalex.org/W2951388027","https://openalex.org/W2951870209","https://openalex.org/W2952295562","https://openalex.org/W2952838738","https://openalex.org/W2955798121","https://openalex.org/W2962868088","https://openalex.org/W2963403868","https://openalex.org/W2963636093","https://openalex.org/W2963853546","https://openalex.org/W2964121744","https://openalex.org/W2964122153","https://openalex.org/W2970148517","https://openalex.org/W2970597249","https://openalex.org/W3041888157","https://openalex.org/W3099158806","https://openalex.org/W3099273181","https://openalex.org/W3100077023","https://openalex.org/W4232672600","https://openalex.org/W4236656499","https://openalex.org/W4237172715","https://openalex.org/W4246006899","https://openalex.org/W4289703391","https://openalex.org/W4299841484","https://openalex.org/W4300048831","https://openalex.org/W4385245566","https://openalex.org/W4388297583","https://openalex.org/W6631190155","https://openalex.org/W6641136096","https://openalex.org/W6674851815"],"related_works":["https://openalex.org/W2982321410","https://openalex.org/W2392004567","https://openalex.org/W2940029036","https://openalex.org/W4388292429","https://openalex.org/W2756595502","https://openalex.org/W2046296964","https://openalex.org/W2010789764","https://openalex.org/W2219281195","https://openalex.org/W2187233292","https://openalex.org/W4389422031"],"abstract_inverted_index":{"Cardinality":[0],"estimation":[1],"has":[2],"long":[3],"been":[4],"grounded":[5],"in":[6],"statistical":[7,31],"tools":[8],"for":[9,53],"density":[10],"estimation.":[11],"To":[12,58],"capture":[13],"the":[14,23,94,103,140],"rich":[15],"multivariate":[16],"distributions":[17],"of":[18,25,29,39,73,84,123],"relational":[19],"tables,":[20],"we":[21,64,101],"propose":[22],"use":[24],"a":[26,44,60,66],"new":[27],"type":[28],"high-capacity":[30],"model:":[32],"deep":[33],"autoregressive":[34,74],"models.":[35],"However,":[36],"direct":[37],"application":[38],"these":[40],"models":[41,75],"leads":[42],"to":[43,51,135],"limited":[45],"estimator":[46,92,126],"that":[47,76],"is":[48,145],"prohibitively":[49],"expensive":[50],"evaluate":[52],"range":[54,80],"or":[55,86],"wildcard":[56],"predicates.":[57],"produce":[59],"truly":[61],"usable":[62],"estimator,":[63],"develop":[65],"Monte":[67],"Carlo":[68],"integration":[69],"scheme":[70],"on":[71,112],"top":[72],"can":[77],"efficiently":[78],"handle":[79],"queries":[81],"with":[82],"dozens":[83],"dimensions":[85],"more.":[87],"Like":[88],"classical":[89],"synopses,":[90],"our":[91,125],"summarizes":[93],"data":[95,105],"without":[96,107],"supervision.":[97],"Unlike":[98],"previous":[99],"solutions,":[100],"approximate":[102],"joint":[104],"distribution":[106],"any":[108],"independence":[109],"assumptions.":[110],"Evaluated":[111],"real-world":[113],"datasets":[114],"and":[115,120,144,147],"compared":[116],"against":[117],"real":[118],"systems":[119],"dominant":[121],"families":[122],"techniques,":[124],"achieves":[127],"single-digit":[128],"multiplicative":[129],"error":[130],"at":[131],"tail,":[132],"an":[133],"up":[134],"90x":[136],"accuracy":[137],"improvement":[138],"over":[139],"second":[141],"best":[142],"method,":[143],"space-":[146],"runtime-efficient.":[148]},"counts_by_year":[{"year":2026,"cited_by_count":11},{"year":2025,"cited_by_count":24},{"year":2024,"cited_by_count":43},{"year":2023,"cited_by_count":32},{"year":2022,"cited_by_count":26},{"year":2021,"cited_by_count":43},{"year":2020,"cited_by_count":20},{"year":2016,"cited_by_count":1}],"updated_date":"2026-07-03T08:13:44.112507","created_date":"2025-10-10T00:00:00"}