{"id":"https://openalex.org/W4411141314","doi":"https://doi.org/10.1145/3725233","title":"Efficient Algorithms for Cardinality Estimation and Conjunctive Query Evaluation With Simple Degree Constraints","display_name":"Efficient Algorithms for Cardinality Estimation and Conjunctive Query Evaluation With Simple Degree Constraints","publication_year":2025,"publication_date":"2025-06-09","ids":{"openalex":"https://openalex.org/W4411141314","doi":"https://doi.org/10.1145/3725233"},"language":"en","primary_location":{"id":"doi:10.1145/3725233","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3725233","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","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/A5006392819","display_name":"Sungjin Im","orcid":"https://orcid.org/0000-0001-5994-7280"},"institutions":[{"id":"https://openalex.org/I185103710","display_name":"University of California, Santa Cruz","ror":"https://ror.org/03s65by71","country_code":"US","type":"education","lineage":["https://openalex.org/I185103710"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sungjin Im","raw_affiliation_strings":["Computer Science and Engineering, University of California, Santa Cruz, Santa Cruz, CA, USA"],"raw_orcid":"https://orcid.org/0000-0001-5994-7280","affiliations":[{"raw_affiliation_string":"Computer Science and Engineering, University of California, Santa Cruz, Santa Cruz, CA, USA","institution_ids":["https://openalex.org/I185103710"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5044201440","display_name":"Benjamin Moseley","orcid":"https://orcid.org/0000-0001-8162-017X"},"institutions":[{"id":"https://openalex.org/I74973139","display_name":"Carnegie Mellon University","ror":"https://ror.org/05x2bcf33","country_code":"US","type":"education","lineage":["https://openalex.org/I74973139"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Benjamin Moseley","raw_affiliation_strings":["Tepper School of Business, Carnegie Mellon University, Pittsburgh, PA, USA"],"raw_orcid":"https://orcid.org/0000-0001-8162-017X","affiliations":[{"raw_affiliation_string":"Tepper School of Business, Carnegie Mellon University, Pittsburgh, PA, USA","institution_ids":["https://openalex.org/I74973139"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102964484","display_name":"Hung Q. Ngo","orcid":"https://orcid.org/0000-0002-3498-4744"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Hung Ngo","raw_affiliation_strings":["Research, RelationalAI, Berkeley, CA, USA"],"raw_orcid":"https://orcid.org/0000-0002-3498-4744","affiliations":[{"raw_affiliation_string":"Research, RelationalAI, Berkeley, CA, USA","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5046525615","display_name":"Kirk Pruhs","orcid":"https://orcid.org/0000-0001-5680-1753"},"institutions":[{"id":"https://openalex.org/I170201317","display_name":"University of Pittsburgh","ror":"https://ror.org/01an3r305","country_code":"US","type":"education","lineage":["https://openalex.org/I170201317"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kirk Pruhs","raw_affiliation_strings":["Computer Science Department, University of Pittsburgh, Pittsburgh, Pennsylvania, USA"],"raw_orcid":"https://orcid.org/0000-0001-5680-1753","affiliations":[{"raw_affiliation_string":"Computer Science Department, University of Pittsburgh, Pittsburgh, Pennsylvania, USA","institution_ids":["https://openalex.org/I170201317"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.064,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.7574395,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":98},"biblio":{"volume":"3","issue":"2","first_page":"1","last_page":"26"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9980000257492065,"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.9980000257492065,"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.9966999888420105,"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/T12288","display_name":"Optimization and Search Problems","score":0.9896000027656555,"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/cardinality","display_name":"Cardinality (data modeling)","score":0.8040554523468018},{"id":"https://openalex.org/keywords/degree","display_name":"Degree (music)","score":0.7391694784164429},{"id":"https://openalex.org/keywords/simple","display_name":"Simple (philosophy)","score":0.7110471725463867},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6004414558410645},{"id":"https://openalex.org/keywords/boolean-conjunctive-query","display_name":"Boolean conjunctive query","score":0.5570881962776184},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.5117220878601074},{"id":"https://openalex.org/keywords/conjunctive-normal-form","display_name":"Conjunctive normal form","score":0.4850301146507263},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.4756619334220886},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.35723876953125},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.20041152834892273},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.17531323432922363},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.169748455286026},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.14843398332595825},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.12589600682258606}],"concepts":[{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.8040554523468018},{"id":"https://openalex.org/C2775997480","wikidata":"https://www.wikidata.org/wiki/Q586277","display_name":"Degree (music)","level":2,"score":0.7391694784164429},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.7110471725463867},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6004414558410645},{"id":"https://openalex.org/C24755975","wikidata":"https://www.wikidata.org/wiki/Q4943354","display_name":"Boolean conjunctive query","level":5,"score":0.5570881962776184},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.5117220878601074},{"id":"https://openalex.org/C16221470","wikidata":"https://www.wikidata.org/wiki/Q846564","display_name":"Conjunctive normal form","level":2,"score":0.4850301146507263},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4756619334220886},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.35723876953125},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.20041152834892273},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.17531323432922363},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.169748455286026},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.14843398332595825},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.12589600682258606},{"id":"https://openalex.org/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0},{"id":"https://openalex.org/C111472728","wikidata":"https://www.wikidata.org/wiki/Q9471","display_name":"Epistemology","level":1,"score":0.0},{"id":"https://openalex.org/C24890656","wikidata":"https://www.wikidata.org/wiki/Q82811","display_name":"Acoustics","level":1,"score":0.0},{"id":"https://openalex.org/C138885662","wikidata":"https://www.wikidata.org/wiki/Q5891","display_name":"Philosophy","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3725233","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3725233","pdf_url":null,"source":{"id":"https://openalex.org/S4387289859","display_name":"Proceedings of the ACM on Management of Data","issn_l":"2836-6573","issn":["2836-6573"],"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 ACM on Management of Data","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G1962461707","display_name":null,"funder_award_id":"CCF-2423106, CCF-2121745, CCF-1844939, CCF-212174, CCF-1907673, CCF-2209654, CCF-18451464","funder_id":"https://openalex.org/F4320323817","funder_display_name":"Universitas Brawijaya"},{"id":"https://openalex.org/G4133223615","display_name":null,"funder_award_id":"N00014-22-1-2702","funder_id":"https://openalex.org/F4320323817","funder_display_name":"Universitas Brawijaya"}],"funders":[{"id":"https://openalex.org/F4320323817","display_name":"Universitas Brawijaya","ror":"https://ror.org/01wk3d929"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":25,"referenced_works":["https://openalex.org/W2021161286","https://openalex.org/W2030893020","https://openalex.org/W2041961594","https://openalex.org/W2075723156","https://openalex.org/W2090322880","https://openalex.org/W2161956202","https://openalex.org/W2396309311","https://openalex.org/W2401576518","https://openalex.org/W2500139799","https://openalex.org/W2585424461","https://openalex.org/W2624220145","https://openalex.org/W2790840297","https://openalex.org/W2794645646","https://openalex.org/W2950833175","https://openalex.org/W2962730682","https://openalex.org/W2963994000","https://openalex.org/W3030422499","https://openalex.org/W4221145500","https://openalex.org/W4245652633","https://openalex.org/W4299678562","https://openalex.org/W4300645277","https://openalex.org/W4380433098","https://openalex.org/W4391591855","https://openalex.org/W4396892722","https://openalex.org/W4406379978"],"related_works":["https://openalex.org/W2100609826","https://openalex.org/W2997126574","https://openalex.org/W609190756","https://openalex.org/W2385922226","https://openalex.org/W2079885161","https://openalex.org/W2576726417","https://openalex.org/W3125756434","https://openalex.org/W2469887214","https://openalex.org/W4245981568","https://openalex.org/W4295792406"],"abstract_inverted_index":{"Cardinality":[0],"estimation":[1,29],"and":[2,21,25],"conjunctive":[3,43,209],"query":[4,15,44],"evaluation":[5],"are":[6,77],"two":[7],"of":[8,41,53,121,131,155,224],"the":[9,34,37,86,100,146,168,199,239],"most":[10],"fundamental":[11],"problems":[12],"in":[13,106,108,116,149,198],"database":[14],"processing.":[16],"Recent":[17],"work":[18],"proposed,":[19],"studied,":[20],"implemented":[22],"a":[23,42,50,128,162,180,185,203,208,233],"robust":[24],"practical":[26],"information-theoretic":[27],"cardinality":[28,38],"framework.":[30],"In":[31,211],"this":[32,62,153,189],"framework,":[33],"estimator":[35],"is":[36,64,85,95,111,126,161,179,243],"upper":[39,74,91,236],"bound":[40,63,84,102,148,170,237],"subject":[45],"to":[46,113,144,166,183,201,206,217,221,232],"''degree-constraints'',":[47],"which":[48,242],"model":[49],"rich":[51],"set":[52],"input":[54],"data":[55],"statistics.":[56],"For":[57],"general":[58],"degree":[59,122,132,136,173,225],"constraints,":[60],"computing":[61],"computationally":[65,244],"hard.":[66],"Researchers":[67,138],"have":[68],"naturally":[69,231],"sought":[70],"efficiently":[71],"computable":[72,115],"relaxed":[73,90,235],"bounds":[75],"that":[76],"as":[78,80],"tight":[79],"possible.":[81],"The":[82],"polymatroid":[83,101,147,169],"tightest":[87],"among":[88],"those":[89],"bounds.":[92],"While":[93],"it":[94,110],"an":[96],"open":[97],"question":[98],"whether":[99],"can":[103,194],"be":[104,114,196],"computed":[105],"polynomial-time":[107,117,181],"general,":[109],"known":[112],"for":[118,152],"some":[119],"classes":[120,223],"constraints.":[123,137,156,174,226],"Our":[124,157,175],"focus":[125],"on":[127],"common":[129],"class":[130,154],"constraints":[133],"called":[134,238],"simple":[135,172],"had":[139],"not":[140],"previously":[141],"determined":[142],"how":[143],"compute":[145,167,184],"polynomial":[150,163],"time":[151,164],"first":[158],"main":[159,177],"result":[160,178],"algorithm":[165,182,205],"given":[171],"second":[176],"''proof":[186],"sequence''":[187],"establishing":[188],"bound.":[190],"This":[191],"proof":[192],"sequence":[193],"then":[195],"incorporated":[197],"PANDA-framework":[200],"give":[202],"faster":[204],"evaluate":[207],"query.":[210],"addition,":[212],"we":[213],"show":[214],"computational":[215],"limitations":[216],"extending":[218],"our":[219,228],"results":[220],"broader":[222],"Finally,":[227],"technique":[229],"leads":[230],"new":[234],"flow":[240],"bound,":[241],"tractable.":[245]},"counts_by_year":[{"year":2026,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}