{"id":"https://openalex.org/W4393180053","doi":"https://doi.org/10.1145/3639270","title":"One Seed, Two Birds: A Unified Learned Structure for Exact and Approximate Counting","display_name":"One Seed, Two Birds: A Unified Learned Structure for Exact and Approximate Counting","publication_year":2024,"publication_date":"2024-03-12","ids":{"openalex":"https://openalex.org/W4393180053","doi":"https://doi.org/10.1145/3639270"},"language":"en","primary_location":{"id":"doi:10.1145/3639270","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3639270","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/A5043243608","display_name":"Yingze Li","orcid":"https://orcid.org/0009-0005-9035-7218"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Yingze Li","raw_affiliation_strings":["Harbin Institude of Technology, Harbin, China"],"raw_orcid":"https://orcid.org/0009-0005-9035-7218","affiliations":[{"raw_affiliation_string":"Harbin Institude of Technology, Harbin, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100396652","display_name":"Hongzhi Wang","orcid":"https://orcid.org/0000-0002-7521-2871"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Hongzhi Wang","raw_affiliation_strings":["Harbin Institute of Technology, Harbin, China"],"raw_orcid":"https://orcid.org/0000-0002-7521-2871","affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology, Harbin, China","institution_ids":["https://openalex.org/I204983213"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102918471","display_name":"Xianglong Liu","orcid":"https://orcid.org/0000-0002-4907-5279"},"institutions":[{"id":"https://openalex.org/I204983213","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08","country_code":"CN","type":"education","lineage":["https://openalex.org/I204983213"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xianglong Liu","raw_affiliation_strings":["Harbin Institute of Technology, Harbin, China"],"raw_orcid":"https://orcid.org/0000-0002-4907-5279","affiliations":[{"raw_affiliation_string":"Harbin Institute of Technology, Harbin, China","institution_ids":["https://openalex.org/I204983213"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5043243608"],"corresponding_institution_ids":["https://openalex.org/I204983213"],"apc_list":null,"apc_paid":null,"fwci":0.944,"has_fulltext":false,"cited_by_count":3,"citation_normalized_percentile":{"value":0.71397484,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":98},"biblio":{"volume":"2","issue":"1","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.9998000264167786,"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.9998000264167786,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9855999946594238,"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.9842000007629395,"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.8189504146575928},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.7689365744590759},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.7260468006134033},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.725153923034668},{"id":"https://openalex.org/keywords/tree","display_name":"Tree (set theory)","score":0.5960873961448669},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.5000207424163818},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.433480441570282},{"id":"https://openalex.org/keywords/tree-structure","display_name":"Tree structure","score":0.43287163972854614},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.2876703143119812},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.21882179379463196},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.17875951528549194},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.1386704444885254},{"id":"https://openalex.org/keywords/binary-tree","display_name":"Binary tree","score":0.12245297431945801}],"concepts":[{"id":"https://openalex.org/C185429906","wikidata":"https://www.wikidata.org/wiki/Q1130160","display_name":"Estimator","level":2,"score":0.8189504146575928},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.7689365744590759},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.7260468006134033},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.725153923034668},{"id":"https://openalex.org/C113174947","wikidata":"https://www.wikidata.org/wiki/Q2859736","display_name":"Tree (set theory)","level":2,"score":0.5960873961448669},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.5000207424163818},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.433480441570282},{"id":"https://openalex.org/C163797641","wikidata":"https://www.wikidata.org/wiki/Q2067937","display_name":"Tree structure","level":3,"score":0.43287163972854614},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.2876703143119812},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.21882179379463196},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.17875951528549194},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.1386704444885254},{"id":"https://openalex.org/C197855036","wikidata":"https://www.wikidata.org/wiki/Q380172","display_name":"Binary tree","level":2,"score":0.12245297431945801},{"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/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"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":1,"locations":[{"id":"doi:10.1145/3639270","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3639270","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/G2712600695","display_name":null,"funder_award_id":"62232005, 62202126","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W1566774944","https://openalex.org/W2063512404","https://openalex.org/W2066799613","https://openalex.org/W2122990007","https://openalex.org/W2151135734","https://openalex.org/W2159886933","https://openalex.org/W2396309311","https://openalex.org/W2798499404","https://openalex.org/W2948233700","https://openalex.org/W2962771342","https://openalex.org/W2963554098","https://openalex.org/W2967734741","https://openalex.org/W2991530444","https://openalex.org/W3013555795","https://openalex.org/W3081786030","https://openalex.org/W3097225903","https://openalex.org/W3107842002","https://openalex.org/W3111141572","https://openalex.org/W3124277639","https://openalex.org/W3164254023","https://openalex.org/W3173963616","https://openalex.org/W4206830372","https://openalex.org/W4282542689","https://openalex.org/W4321448303","https://openalex.org/W4381710487","https://openalex.org/W6678342440"],"related_works":["https://openalex.org/W2066405186","https://openalex.org/W1659690962","https://openalex.org/W2145355078","https://openalex.org/W2093885745","https://openalex.org/W2351266481","https://openalex.org/W2132547887","https://openalex.org/W2358174538","https://openalex.org/W2047015677","https://openalex.org/W2071459461","https://openalex.org/W2516987005"],"abstract_inverted_index":{"The":[0],"modern":[1],"database":[2],"has":[3,99],"many":[4],"precise":[5],"and":[6,45,95,117,178,199,207],"approximate":[7],"counting":[8,28,76,88],"requirements.":[9],"Nevertheless,":[10],"a":[11,50,62,70,187],"solitary":[12],"multidimensional":[13,71],"index":[14,73],"or":[15,38],"cardinality":[16,83,110],"estimator":[17],"is":[18,148,170,193],"insufficient":[19],"to":[20,22,54,86,104,138,150,201],"cater":[21],"the":[23,40,56,105,142,155,164,219],"escalating":[24],"demands":[25],"across":[26],"all":[27],"scenarios.":[29],"Such":[30],"approaches":[31],"are":[32,121,214],"constrained":[33],"either":[34],"by":[35,39,136],"query":[36,43,130,189],"selectivity":[37],"compromise":[41],"between":[42],"accuracy":[44,144],"efficiency.":[46,96],"We":[47],"propose":[48],"CardIndex,":[49],"unified":[51],"learned":[52,72],"structure":[53,114,169],"solve":[55],"above":[57],"problems.":[58],"CardIndex":[59],"serves":[60],"as":[61,69,80],"versatile":[63],"solution":[64],"that":[65,120,192],"not":[66],"only":[67],"functions":[68],"for":[74,93],"accurate":[75],"but":[77],"also":[78],"doubles":[79],"an":[81],"adaptive":[82],"estimator,":[84],"catering":[85],"varying":[87],"scenarios":[89],"with":[90],"diverse":[91],"requirements":[92],"precision":[94],"Rigorous":[97],"experimentation":[98],"showcased":[100],"its":[101],"superiority.":[102],"Compared":[103],"state-of-the-art":[106],"(SOTA)":[107],"autoregressive":[108],"data-driven":[109],"estimation":[111,131,143],"baselines,":[112],"our":[113,128,168],"achieves":[115],"training":[116],"updating":[118],"times":[119,152,180,195,203,216],"two":[122,137,171],"orders":[123,172],"of":[124,145,161,167,173],"magnitude":[125,174],"faster.":[126],"Additionally,":[127],"CPU-based":[129],"latency":[132],"surpasses":[133],"GPU-based":[134],"baselines":[135],"three":[139],"times.":[140],"Notably,":[141],"low-selectivity":[146],"queries":[147,210],"up":[149],"314":[151],"better":[153],"than":[154,176,182,197,205,218],"current":[156],"SOTA":[157,220],"estimator.":[158],"In":[159],"terms":[160],"indexing":[162],"tasks,":[163],"construction":[165],"speed":[166,191],"faster":[175,181,196,204,217],"RSMI":[177,198],"1.9":[179],"R-tree.":[183],"Furthermore,":[184],"it":[185],"exhibits":[186],"point":[188],"processing":[190],"3%-17%":[194],"1.07":[200],"2.75":[202],"R-tree":[206],"KDB-tree.":[208],"Range":[209],"under":[211],"specific":[212],"loads":[213],"20%":[215],"indexes.":[221]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":2}],"updated_date":"2026-05-21T09:19:25.381259","created_date":"2025-10-10T00:00:00"}