{"id":"https://openalex.org/W1982092405","doi":"https://doi.org/10.1145/2452376.2452456","title":"HyperLogLog in practice","display_name":"HyperLogLog in practice","publication_year":2013,"publication_date":"2013-03-18","ids":{"openalex":"https://openalex.org/W1982092405","doi":"https://doi.org/10.1145/2452376.2452456","mag":"1982092405"},"language":"en","primary_location":{"id":"doi:10.1145/2452376.2452456","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452456","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","raw_type":"proceedings-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/A5064408830","display_name":"Stefan Heule","orcid":null},"institutions":[{"id":"https://openalex.org/I4210100430","display_name":"Google (Switzerland)","ror":"https://ror.org/014f9c269","country_code":"CH","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210100430","https://openalex.org/I4210128969"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Stefan Heule","raw_affiliation_strings":["ETH Zurich and Google, Inc"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"ETH Zurich and Google, Inc","institution_ids":["https://openalex.org/I4210100430"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5051123931","display_name":"Marc Nunkesser","orcid":null},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Marc Nunkesser","raw_affiliation_strings":["Google, Inc","GOOGLE INC "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google, Inc","institution_ids":["https://openalex.org/I1291425158"]},{"raw_affiliation_string":"GOOGLE INC ","institution_ids":["https://openalex.org/I1291425158"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5003829918","display_name":"Alexander Hall","orcid":"https://orcid.org/0000-0002-5866-2221"},"institutions":[{"id":"https://openalex.org/I1291425158","display_name":"Google (United States)","ror":"https://ror.org/00njsd438","country_code":"US","type":"company","lineage":["https://openalex.org/I1291425158","https://openalex.org/I4210128969"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Alexander Hall","raw_affiliation_strings":["Google, Inc","GOOGLE INC "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Google, Inc","institution_ids":["https://openalex.org/I1291425158"]},{"raw_affiliation_string":"GOOGLE INC ","institution_ids":["https://openalex.org/I1291425158"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":15.0906,"has_fulltext":false,"cited_by_count":300,"citation_normalized_percentile":{"value":0.99089995,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":100},"biblio":{"volume":null,"issue":null,"first_page":"683","last_page":"692"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9998999834060669,"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/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/T12761","display_name":"Data Stream Mining Techniques","score":0.992900013923645,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.8402881622314453},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7543179392814636},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.6021221280097961},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.5668853521347046},{"id":"https://openalex.org/keywords/algorithm-design","display_name":"Algorithm design","score":0.47533631324768066},{"id":"https://openalex.org/keywords/series","display_name":"Series (stratigraphy)","score":0.4273446798324585},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.38701343536376953}],"concepts":[{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.8402881622314453},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7543179392814636},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.6021221280097961},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.5668853521347046},{"id":"https://openalex.org/C106516650","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm design","level":2,"score":0.47533631324768066},{"id":"https://openalex.org/C143724316","wikidata":"https://www.wikidata.org/wiki/Q312468","display_name":"Series (stratigraphy)","level":2,"score":0.4273446798324585},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.38701343536376953},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","level":0,"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/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","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/2452376.2452456","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2452376.2452456","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 16th International Conference on Extending Database Technology","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W1785933978","https://openalex.org/W2003580796","https://openalex.org/W2005731313","https://openalex.org/W2007993174","https://openalex.org/W2008365755","https://openalex.org/W2025051251","https://openalex.org/W2074935284","https://openalex.org/W2099480861","https://openalex.org/W2103126020","https://openalex.org/W2111678491","https://openalex.org/W2114027169","https://openalex.org/W2119714163","https://openalex.org/W2132822431","https://openalex.org/W2144982963","https://openalex.org/W2154096150","https://openalex.org/W2583903344","https://openalex.org/W4249750499","https://openalex.org/W6675247803"],"related_works":["https://openalex.org/W2058438338","https://openalex.org/W2168299207","https://openalex.org/W2019471580","https://openalex.org/W2002177687","https://openalex.org/W4224920876","https://openalex.org/W2941284322","https://openalex.org/W2017309389","https://openalex.org/W2585354854","https://openalex.org/W2026059297","https://openalex.org/W4246121856"],"abstract_inverted_index":{"Cardinality":[0],"estimation":[1],"has":[2],"a":[3,37,67,95],"wide":[4],"range":[5,57],"of":[6,10,30,39,58],"applications":[7],"and":[8,24,49,71,89],"is":[9,28],"particular":[11],"importance":[12],"in":[13,21,94],"database":[14],"systems.":[15],"Various":[16],"algorithms":[17],"have":[18,61],"been":[19],"proposed":[20,64],"the":[22,25,78,91],"past,":[23],"HyperLogLog":[26,80],"algorithm":[27,43,65,86],"one":[29],"them.":[31],"In":[32],"this":[33,42],"paper,":[34],"we":[35],"present":[36],"series":[38],"improvements":[40],"to":[41,77],"that":[44],"reduce":[45],"its":[46,52],"memory":[47],"requirements":[48],"significantly":[50],"increase":[51],"accuracy":[53],"for":[54,66],"an":[55],"important":[56],"cardinalities.":[59],"We":[60],"implemented":[62],"our":[63,84],"system":[68],"at":[69],"Google":[70],"evaluated":[72],"it":[73,76],"empirically,":[74],"comparing":[75],"original":[79],"algorithm.":[81],"Like":[82],"HyperLogLog,":[83],"improved":[85],"parallelizes":[87],"perfectly":[88],"computes":[90],"cardinality":[92],"estimate":[93],"single":[96],"pass.":[97]},"counts_by_year":[{"year":2026,"cited_by_count":7},{"year":2025,"cited_by_count":24},{"year":2024,"cited_by_count":28},{"year":2023,"cited_by_count":28},{"year":2022,"cited_by_count":26},{"year":2021,"cited_by_count":33},{"year":2020,"cited_by_count":32},{"year":2019,"cited_by_count":34},{"year":2018,"cited_by_count":25},{"year":2017,"cited_by_count":23},{"year":2016,"cited_by_count":12},{"year":2015,"cited_by_count":14},{"year":2014,"cited_by_count":11},{"year":2013,"cited_by_count":3}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}