{"id":"https://openalex.org/W4391305444","doi":"https://doi.org/10.1109/tkde.2024.3359710","title":"Half-Xor: A Fully-Dynamic Sketch for Estimating the Number of Distinct Values in Big Tables","display_name":"Half-Xor: A Fully-Dynamic Sketch for Estimating the Number of Distinct Values in Big Tables","publication_year":2024,"publication_date":"2024-01-29","ids":{"openalex":"https://openalex.org/W4391305444","doi":"https://doi.org/10.1109/tkde.2024.3359710"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2024.3359710","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2024.3359710","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","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/A5022240408","display_name":"Pinghui Wang","orcid":"https://orcid.org/0000-0001-5779-6108"},"institutions":[{"id":"https://openalex.org/I87445476","display_name":"Xi'an Jiaotong University","ror":"https://ror.org/017zhmm22","country_code":"CN","type":"education","lineage":["https://openalex.org/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Pinghui Wang","raw_affiliation_strings":["MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China","Shenzhen Research Institute, Xi'an Jiaotong University, Shenzhen, China"],"raw_orcid":"https://orcid.org/0000-0001-5779-6108","affiliations":[{"raw_affiliation_string":"MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China","institution_ids":["https://openalex.org/I87445476"]},{"raw_affiliation_string":"Shenzhen Research Institute, Xi'an Jiaotong University, Shenzhen, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113106696","display_name":"Dongdong Xie","orcid":"https://orcid.org/0009-0002-8727-4946"},"institutions":[{"id":"https://openalex.org/I87445476","display_name":"Xi'an Jiaotong University","ror":"https://ror.org/017zhmm22","country_code":"CN","type":"education","lineage":["https://openalex.org/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Dongdong Xie","raw_affiliation_strings":["MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China"],"raw_orcid":"https://orcid.org/0009-0002-8727-4946","affiliations":[{"raw_affiliation_string":"MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007402211","display_name":"Junzhou Zhao","orcid":"https://orcid.org/0000-0003-3476-8248"},"institutions":[{"id":"https://openalex.org/I87445476","display_name":"Xi'an Jiaotong University","ror":"https://ror.org/017zhmm22","country_code":"CN","type":"education","lineage":["https://openalex.org/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Junzhou Zhao","raw_affiliation_strings":["MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China"],"raw_orcid":"https://orcid.org/0000-0003-3476-8248","affiliations":[{"raw_affiliation_string":"MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100324930","display_name":"Jinsong Li","orcid":"https://orcid.org/0009-0006-1726-6149"},"institutions":[{"id":"https://openalex.org/I87445476","display_name":"Xi'an Jiaotong University","ror":"https://ror.org/017zhmm22","country_code":"CN","type":"education","lineage":["https://openalex.org/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jinsong Li","raw_affiliation_strings":["MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China"],"raw_orcid":"https://orcid.org/0009-0006-1726-6149","affiliations":[{"raw_affiliation_string":"MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101785439","display_name":"Zhicheng Li","orcid":"https://orcid.org/0009-0001-0857-4573"},"institutions":[{"id":"https://openalex.org/I87445476","display_name":"Xi'an Jiaotong University","ror":"https://ror.org/017zhmm22","country_code":"CN","type":"education","lineage":["https://openalex.org/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhicheng Li","raw_affiliation_strings":["MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China"],"raw_orcid":"https://orcid.org/0009-0001-0857-4573","affiliations":[{"raw_affiliation_string":"MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5101780303","display_name":"Rundong Li","orcid":"https://orcid.org/0000-0003-0354-9536"},"institutions":[{"id":"https://openalex.org/I87445476","display_name":"Xi'an Jiaotong University","ror":"https://ror.org/017zhmm22","country_code":"CN","type":"education","lineage":["https://openalex.org/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Rundong Li","raw_affiliation_strings":["MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China"],"raw_orcid":"https://orcid.org/0000-0003-0354-9536","affiliations":[{"raw_affiliation_string":"MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103326335","display_name":"Yang Ren","orcid":"https://orcid.org/0009-0002-8679-8238"},"institutions":[{"id":"https://openalex.org/I2250955327","display_name":"Huawei Technologies (China)","ror":"https://ror.org/00cmhce21","country_code":"CN","type":"company","lineage":["https://openalex.org/I2250955327"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Yang Ren","raw_affiliation_strings":["Huawei Technologies Co., Ltd., Shenzhen, China"],"raw_orcid":"https://orcid.org/0009-0002-8679-8238","affiliations":[{"raw_affiliation_string":"Huawei Technologies Co., Ltd., Shenzhen, China","institution_ids":["https://openalex.org/I2250955327"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5101691766","display_name":"Jia Di","orcid":"https://orcid.org/0000-0002-2328-3811"},"institutions":[{"id":"https://openalex.org/I87445476","display_name":"Xi'an Jiaotong University","ror":"https://ror.org/017zhmm22","country_code":"CN","type":"education","lineage":["https://openalex.org/I87445476"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Jia Di","raw_affiliation_strings":["MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China"],"raw_orcid":"https://orcid.org/0000-0002-2328-3811","affiliations":[{"raw_affiliation_string":"MOE Key Laboratory for Intelligent Networks and Network Security, Xi&#x2019;an Jiaotong University, Xi&#x2019;an, China","institution_ids":["https://openalex.org/I87445476"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":8,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.4477,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.92851861,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":98},"biblio":{"volume":"36","issue":"7","first_page":"3111","last_page":"3125"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9215999841690063,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9215999841690063,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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/sketch","display_name":"Sketch","score":0.7623903751373291},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7474899291992188},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3158200681209564}],"concepts":[{"id":"https://openalex.org/C2779231336","wikidata":"https://www.wikidata.org/wiki/Q7534724","display_name":"Sketch","level":2,"score":0.7623903751373291},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7474899291992188},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3158200681209564}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tkde.2024.3359710","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2024.3359710","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G2455875836","display_name":null,"funder_award_id":"62272372","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G296553909","display_name":null,"funder_award_id":"U22B2019","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7908474832","display_name":null,"funder_award_id":"62372362","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8176576550","display_name":null,"funder_award_id":"62272379","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":37,"referenced_works":["https://openalex.org/W760598031","https://openalex.org/W1601435884","https://openalex.org/W1608865483","https://openalex.org/W1982092405","https://openalex.org/W2002231822","https://openalex.org/W2008365755","https://openalex.org/W2025051251","https://openalex.org/W2047061289","https://openalex.org/W2058416167","https://openalex.org/W2058991275","https://openalex.org/W2103126020","https://openalex.org/W2114413252","https://openalex.org/W2114424556","https://openalex.org/W2144982963","https://openalex.org/W2259091399","https://openalex.org/W2270062199","https://openalex.org/W2394785274","https://openalex.org/W2749679580","https://openalex.org/W2762566515","https://openalex.org/W2911324315","https://openalex.org/W2948371369","https://openalex.org/W3168054278","https://openalex.org/W3169136406","https://openalex.org/W4206064074","https://openalex.org/W4210546623","https://openalex.org/W4213251304","https://openalex.org/W4214655602","https://openalex.org/W4242142158","https://openalex.org/W4246899237","https://openalex.org/W4290928039","https://openalex.org/W4290944102","https://openalex.org/W4295126499","https://openalex.org/W4300577719","https://openalex.org/W6693783752","https://openalex.org/W6734131497","https://openalex.org/W6743322848","https://openalex.org/W6758116220"],"related_works":["https://openalex.org/W2748952813","https://openalex.org/W2378994405","https://openalex.org/W2385974820","https://openalex.org/W2373478030","https://openalex.org/W2378679551","https://openalex.org/W3149739944","https://openalex.org/W2392363776","https://openalex.org/W2063051341","https://openalex.org/W1494563618","https://openalex.org/W2357022711"],"abstract_inverted_index":{"Calculating":[0],"the":[1,33,51,82,131,151,157,167],"number":[2,40],"of":[3,11,22,41,59,102],"distinct":[4,60],"values":[5],"(i.e.,":[6],"NDV)":[7],"in":[8],"a":[9,12,20,39,54,90,103,108,117,122,126],"column":[10],"big":[13],"table":[14],"is":[15,75,143],"costly":[16,68],"yet":[17],"fundamental":[18],"to":[19,69,115,145,162,165],"variety":[21],"database":[23],"applications":[24],"such":[25],"as":[26],"data":[27,57,74,127],"compression":[28],"and":[29,36,79,107,112,120,155],"profiling.":[30],"To":[31,84],"reduce":[32],"high":[34],"time":[35],"space":[37],"cost,":[38],"sketch":[42,92,100],"methods":[43,64],"(e.g.,":[44],"HyperLogLog)":[45],"have":[46],"been":[47],"proposed,":[48],"which":[49],"estimate":[50],"NDV":[52],"from":[53,81],"constructed":[55],"compact":[56,104],"summary":[58],"values.":[61],"However,":[62],"these":[63],"fail":[65],"or":[66],"are":[67],"manage":[70],"fully-dynamic":[71],"scenarios":[72],"where":[73],"often":[76],"inserted":[77],"into":[78],"deleted":[80],"table.":[83],"solve":[85],"this":[86],"issue,":[87],"we":[88],"propose":[89],"novel":[91],"method,":[93,134],"<italic":[94],"xmlns:mml=\"http://www.w3.org/1998/Math/MathML\"":[95],"xmlns:xlink=\"http://www.w3.org/1999/xlink\">Half-Xor</i>":[96],".":[97],"Our":[98],"Half-Xor":[99,142],"consists":[101],"bit":[105],"matrix":[106],"small":[109],"counter":[110,123],"array,":[111],"it":[113],"needs":[114],"set":[116],"few":[118],"bits":[119],"update":[121],"when":[124],"handling":[125],"insertion/deletion.":[128],"Compared":[129],"with":[130],"state-of-the-art":[132],"mergeable":[133],"our":[135,140],"experimental":[136],"results":[137],"demonstrate":[138],"that":[139],"method":[141],"up":[144,161],"6.6":[146],"times":[147,164],"more":[148],"accurate":[149],"under":[150],"same":[152,168],"memory":[153,158],"usage":[154,159],"reduces":[156],"by":[160],"16":[163],"achieve":[166],"estimation":[169],"accuracy.":[170]},"counts_by_year":[{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}