{"id":"https://openalex.org/W4414428468","doi":"https://doi.org/10.1145/3749157","title":"A Fast, Mergeable, and LDP Compatible Sketch for Counting the Number of Distinct Values in Fully Dynamic Tables","display_name":"A Fast, Mergeable, and LDP Compatible Sketch for Counting the Number of Distinct Values in Fully Dynamic Tables","publication_year":2025,"publication_date":"2025-09-22","ids":{"openalex":"https://openalex.org/W4414428468","doi":"https://doi.org/10.1145/3749157"},"language":"en","primary_location":{"id":"doi:10.1145/3749157","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3749157","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/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 KLINNS Lab, Xi'an Jiaotong University, Xi'an, China"],"raw_orcid":"https://orcid.org/0009-0001-0857-4573","affiliations":[{"raw_affiliation_string":"MOE KLINNS Lab, Xi'an Jiaotong University, Xi'an, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102845337","display_name":"Pinghui Wang","orcid":"https://orcid.org/0000-0002-1434-837X"},"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 KLINNS Lab, Xi'an Jiaotong University, Xi'an, China"],"raw_orcid":"https://orcid.org/0000-0002-1434-837X","affiliations":[{"raw_affiliation_string":"MOE KLINNS Lab, Xi'an Jiaotong University, Xi'an, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Zeli Lin","orcid":"https://orcid.org/0009-0000-4761-0410"},"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":"Zeli Lin","raw_affiliation_strings":["Xi'an Jiaotong University, Xi'an, China"],"raw_orcid":"https://orcid.org/0009-0000-4761-0410","affiliations":[{"raw_affiliation_string":"Xi'an Jiaotong University, Xi'an, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5086008165","display_name":"B. J. Chen","orcid":null},"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":"Bichun Chen","raw_affiliation_strings":["Xi'an Jiaotong University, Xi'an, China"],"raw_orcid":"https://orcid.org/0009-0007-9718-9354","affiliations":[{"raw_affiliation_string":"Xi'an Jiaotong University, Xi'an, China","institution_ids":["https://openalex.org/I87445476"]}]},{"author_position":"last","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 KLINNS Lab, Xi'an Jiaotong University, Xi'an, China"],"raw_orcid":"https://orcid.org/0009-0002-8727-4946","affiliations":[{"raw_affiliation_string":"MOE KLINNS Lab, Xi'an Jiaotong University, Xi'an, China","institution_ids":["https://openalex.org/I87445476"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I87445476"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.26872509,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"3","issue":"4","first_page":"1","last_page":"27"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9990000128746033,"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"}},"topics":[{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9990000128746033,"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"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9987000226974487,"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.9976999759674072,"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/sketch","display_name":"Sketch","score":0.7520999908447266},{"id":"https://openalex.org/keywords/probabilistic-logic","display_name":"Probabilistic logic","score":0.5511000156402588},{"id":"https://openalex.org/keywords/differential-privacy","display_name":"Differential privacy","score":0.5425000190734863},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.5199999809265137},{"id":"https://openalex.org/keywords/focus","display_name":"Focus (optics)","score":0.5006999969482422},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.4830999970436096},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.44179999828338623}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8138999938964844},{"id":"https://openalex.org/C2779231336","wikidata":"https://www.wikidata.org/wiki/Q7534724","display_name":"Sketch","level":2,"score":0.7520999908447266},{"id":"https://openalex.org/C49937458","wikidata":"https://www.wikidata.org/wiki/Q2599292","display_name":"Probabilistic logic","level":2,"score":0.5511000156402588},{"id":"https://openalex.org/C23130292","wikidata":"https://www.wikidata.org/wiki/Q5275358","display_name":"Differential privacy","level":2,"score":0.5425000190734863},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.5336999893188477},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.5199999809265137},{"id":"https://openalex.org/C192209626","wikidata":"https://www.wikidata.org/wiki/Q190909","display_name":"Focus (optics)","level":2,"score":0.5006999969482422},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.4900999963283539},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.4830999970436096},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.44179999828338623},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.39800000190734863},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.30379998683929443},{"id":"https://openalex.org/C2780586882","wikidata":"https://www.wikidata.org/wiki/Q7520643","display_name":"Simple (philosophy)","level":2,"score":0.30379998683929443},{"id":"https://openalex.org/C2775937380","wikidata":"https://www.wikidata.org/wiki/Q1232589","display_name":"Replica","level":2,"score":0.30309998989105225},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.29269999265670776},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.2800999879837036},{"id":"https://openalex.org/C118702147","wikidata":"https://www.wikidata.org/wiki/Q189396","display_name":"Dynamic random-access memory","level":3,"score":0.27709999680519104},{"id":"https://openalex.org/C123201435","wikidata":"https://www.wikidata.org/wiki/Q456632","display_name":"Information privacy","level":2,"score":0.2736999988555908},{"id":"https://openalex.org/C2776760102","wikidata":"https://www.wikidata.org/wiki/Q5139990","display_name":"Code (set theory)","level":3,"score":0.2709999978542328},{"id":"https://openalex.org/C113775141","wikidata":"https://www.wikidata.org/wiki/Q428691","display_name":"Computer engineering","level":1,"score":0.258899986743927}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3749157","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3749157","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/G2354043596","display_name":null,"funder_award_id":"62272372, 62272379","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G7434723456","display_name":null,"funder_award_id":"CCF-HuaweiDB202407","funder_id":"https://openalex.org/F4320322183","funder_display_name":"Huawei Technologies"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320322183","display_name":"Huawei Technologies","ror":"https://ror.org/00cmhce21"}],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":51,"referenced_works":["https://openalex.org/W44899178","https://openalex.org/W71228264","https://openalex.org/W98727202","https://openalex.org/W403953909","https://openalex.org/W570680726","https://openalex.org/W1499549173","https://openalex.org/W1694216773","https://openalex.org/W1785933978","https://openalex.org/W1981029888","https://openalex.org/W1995437102","https://openalex.org/W2008292329","https://openalex.org/W2010582541","https://openalex.org/W2029619274","https://openalex.org/W2034302520","https://openalex.org/W2058416167","https://openalex.org/W2058991275","https://openalex.org/W2064710146","https://openalex.org/W2065264435","https://openalex.org/W2089066317","https://openalex.org/W2103126020","https://openalex.org/W2107418220","https://openalex.org/W2114021497","https://openalex.org/W2123845384","https://openalex.org/W2130486040","https://openalex.org/W2131090456","https://openalex.org/W2140430731","https://openalex.org/W2276249153","https://openalex.org/W2295205026","https://openalex.org/W2603552416","https://openalex.org/W2752494670","https://openalex.org/W2765204830","https://openalex.org/W2771456763","https://openalex.org/W2897450989","https://openalex.org/W2911978475","https://openalex.org/W2949409203","https://openalex.org/W3092538966","https://openalex.org/W3105379405","https://openalex.org/W3119448165","https://openalex.org/W3129748168","https://openalex.org/W4205228770","https://openalex.org/W4206912547","https://openalex.org/W4221155765","https://openalex.org/W4242142158","https://openalex.org/W4254214712","https://openalex.org/W4290944102","https://openalex.org/W4379135657","https://openalex.org/W4380433156","https://openalex.org/W4385452990","https://openalex.org/W4392405801","https://openalex.org/W4393180322","https://openalex.org/W4412428244"],"related_works":[],"abstract_inverted_index":{"Counting":[0],"the":[1,24,161,173,187],"number":[2],"of":[3,175,186],"distinct":[4],"values":[5],"(NDV)":[6],"is":[7,44],"a":[8,101,137,147],"fundamental":[9],"problem":[10],"in":[11,53,194],"web":[12],"applications":[13],"and":[14,49,69,75,112,123,197],"databases,":[15],"particularly":[16],"under":[17,202],"memory":[18,76,188],"constraints.":[19],"Sketch-based":[20],"methods,":[21],"such":[22,57],"as":[23,58],"Flajolet-Martin":[25],"sketch,":[26],"construct":[27],"compact":[28],"data":[29],"summaries":[30],"to":[31,152,160,189,206],"estimate":[32],"NDV":[33,121],"but":[34],"primarily":[35],"focus":[36],"on":[37],"insertion-only":[38],"scenarios.":[39],"However,":[40],"supporting":[41],"delete":[42],"operations":[43],"crucial":[45],"for":[46,62,108,119],"maintaining":[47],"accurate":[48],"up-to-date":[50],"cardinality":[51],"estimates":[52],"many":[54],"real-world":[55],"applications,":[56],"databases.":[59],"Existing":[60],"methods":[61],"fully":[63,109],"dynamic":[64,110],"scenarios,":[65],"involving":[66],"both":[67,120],"insertions":[68],"deletions,":[70],"often":[71,81],"incur":[72],"considerable":[73],"computational":[74],"overhead.":[77],"Furthermore,":[78],"collaborative":[79],"computation":[80],"requires":[82],"sharing":[83],"sketches":[84],"with":[85,114,131],"external":[86],"or":[87],"untrusted":[88],"parties,":[89],"which":[90],"introduces":[91],"significant":[92],"privacy":[93,117,124],"risks.":[94],"To":[95],"address":[96],"these":[97],"challenges,":[98],"we":[99,145],"propose":[100],"novel":[102],"sketch":[103,167],"method,":[104],"GMod,":[105],"specifically":[106],"designed":[107,166],"scenarios":[111,204],"compatible":[113],"local":[115,195],"differential":[116],"(LDP)":[118],"estimation":[122,150,192],"preservation.":[125],"Our":[126],"method":[127,183],"supports":[128],"efficient":[129],"deletions":[130],"minimal":[132],"additional":[133],"overhead":[134],"by":[135],"utilizing":[136],"single":[138],"discrete":[139],"uniformly":[140],"distributed":[141],"random":[142],"variable.":[143],"Additionally,":[144],"introduce":[146],"lightweight":[148],"probabilistic":[149],"model":[151,171],"compute":[153],"NDV,":[154],"achieving":[155],"3\u00d7":[156],"faster":[157],"performance":[158],"compared":[159,205],"state-of-the-art.":[162],"By":[163],"incorporating":[164],"carefully":[165],"perturbation":[168],"mechanisms,":[169],"our":[170,182],"mitigates":[172],"impact":[174],"LDP":[176,203],"noise.":[177],"Experimental":[178],"results":[179],"demonstrate":[180],"that":[181],"uses":[184],"1/3":[185],"achieve":[190],"comparable":[191],"accuracy":[193,201],"settings":[196],"provides":[198],"8\u00d7":[199],"higher":[200],"state-of-the-art":[207],"methods.":[208]},"counts_by_year":[],"updated_date":"2026-06-26T08:34:08.712188","created_date":"2025-10-10T00:00:00"}