{"id":"https://openalex.org/W2963554098","doi":"https://doi.org/10.14778/3236187.3236212","title":"Moment-based quantile sketches for efficient high cardinality aggregation queries","display_name":"Moment-based quantile sketches for efficient high cardinality aggregation queries","publication_year":2018,"publication_date":"2018-07-01","ids":{"openalex":"https://openalex.org/W2963554098","doi":"https://doi.org/10.14778/3236187.3236212","mag":"2963554098"},"language":"en","primary_location":{"id":"doi:10.14778/3236187.3236212","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3236187.3236212","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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 VLDB Endowment","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/A5068366265","display_name":"Edward Gan","orcid":"https://orcid.org/0000-0002-3237-6657"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Edward Gan","raw_affiliation_strings":["Stanford InfoLab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford InfoLab","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5103942334","display_name":"Jialin Ding","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jialin Ding","raw_affiliation_strings":["Stanford InfoLab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford InfoLab","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034622870","display_name":"Kai Sheng Tai","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kai Sheng Tai","raw_affiliation_strings":["Stanford InfoLab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford InfoLab","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5009088661","display_name":"Vatsal Sharan","orcid":"https://orcid.org/0009-0003-1280-5623"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Vatsal Sharan","raw_affiliation_strings":["Stanford InfoLab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford InfoLab","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5002538469","display_name":"Peter Bailis","orcid":"https://orcid.org/0000-0003-1166-7823"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Peter Bailis","raw_affiliation_strings":["Stanford InfoLab"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Stanford InfoLab","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":5.0847,"has_fulltext":false,"cited_by_count":53,"citation_normalized_percentile":{"value":0.96395973,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":"11","issue":"11","first_page":"1647","last_page":"1660"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9995999932289124,"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.9995999932289124,"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.9994000196456909,"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/T10799","display_name":"Data Visualization and Analytics","score":0.9952999949455261,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/quantile","display_name":"Quantile","score":0.8180564641952515},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7262487411499023},{"id":"https://openalex.org/keywords/sketch","display_name":"Sketch","score":0.5324358344078064},{"id":"https://openalex.org/keywords/memory-footprint","display_name":"Memory footprint","score":0.5317453145980835},{"id":"https://openalex.org/keywords/byte","display_name":"Byte","score":0.520634114742279},{"id":"https://openalex.org/keywords/search-engine-indexing","display_name":"Search engine indexing","score":0.4870801270008087},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4739266037940979},{"id":"https://openalex.org/keywords/bottleneck","display_name":"Bottleneck","score":0.4637596607208252},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.4513515532016754},{"id":"https://openalex.org/keywords/principle-of-maximum-entropy","display_name":"Principle of maximum entropy","score":0.4443175196647644},{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.44183599948883057},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.32879751920700073},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.29703187942504883},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.22596290707588196},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.1987413763999939},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.12507027387619019}],"concepts":[{"id":"https://openalex.org/C118671147","wikidata":"https://www.wikidata.org/wiki/Q578714","display_name":"Quantile","level":2,"score":0.8180564641952515},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7262487411499023},{"id":"https://openalex.org/C2779231336","wikidata":"https://www.wikidata.org/wiki/Q7534724","display_name":"Sketch","level":2,"score":0.5324358344078064},{"id":"https://openalex.org/C74912251","wikidata":"https://www.wikidata.org/wiki/Q6815727","display_name":"Memory footprint","level":2,"score":0.5317453145980835},{"id":"https://openalex.org/C43364308","wikidata":"https://www.wikidata.org/wiki/Q8799","display_name":"Byte","level":2,"score":0.520634114742279},{"id":"https://openalex.org/C75165309","wikidata":"https://www.wikidata.org/wiki/Q2258979","display_name":"Search engine indexing","level":2,"score":0.4870801270008087},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4739266037940979},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.4637596607208252},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.4513515532016754},{"id":"https://openalex.org/C9679016","wikidata":"https://www.wikidata.org/wiki/Q1417473","display_name":"Principle of maximum entropy","level":2,"score":0.4443175196647644},{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.44183599948883057},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.32879751920700073},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.29703187942504883},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.22596290707588196},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.1987413763999939},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.12507027387619019},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.0},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3236187.3236212","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3236187.3236212","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"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 VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":86,"referenced_works":["https://openalex.org/W202303397","https://openalex.org/W346507350","https://openalex.org/W1249613807","https://openalex.org/W1490272990","https://openalex.org/W1490362171","https://openalex.org/W1496357020","https://openalex.org/W1514461580","https://openalex.org/W1517022795","https://openalex.org/W1522579744","https://openalex.org/W1587069825","https://openalex.org/W1738124305","https://openalex.org/W1847038087","https://openalex.org/W1882488766","https://openalex.org/W1965972569","https://openalex.org/W1974088667","https://openalex.org/W1977633159","https://openalex.org/W1979467333","https://openalex.org/W1982063824","https://openalex.org/W1995484833","https://openalex.org/W2004110412","https://openalex.org/W2010250346","https://openalex.org/W2012828271","https://openalex.org/W2022858489","https://openalex.org/W2024463287","https://openalex.org/W2028995298","https://openalex.org/W2030868206","https://openalex.org/W2032558547","https://openalex.org/W2044782420","https://openalex.org/W2044880891","https://openalex.org/W2051434435","https://openalex.org/W2057714068","https://openalex.org/W2059998776","https://openalex.org/W2061725512","https://openalex.org/W2065263105","https://openalex.org/W2068289711","https://openalex.org/W2071989194","https://openalex.org/W2080234606","https://openalex.org/W2091341267","https://openalex.org/W2094835873","https://openalex.org/W2096175520","https://openalex.org/W2098376057","https://openalex.org/W2099351934","https://openalex.org/W2103201239","https://openalex.org/W2110100895","https://openalex.org/W2112452856","https://openalex.org/W2119885577","https://openalex.org/W2129516068","https://openalex.org/W2131975293","https://openalex.org/W2141862445","https://openalex.org/W2143401113","https://openalex.org/W2143672210","https://openalex.org/W2144261930","https://openalex.org/W2145061307","https://openalex.org/W2147880316","https://openalex.org/W2150779766","https://openalex.org/W2152837238","https://openalex.org/W2161118867","https://openalex.org/W2164598857","https://openalex.org/W2166363824","https://openalex.org/W2167396179","https://openalex.org/W2257756289","https://openalex.org/W2295655272","https://openalex.org/W2296319761","https://openalex.org/W2299041621","https://openalex.org/W2317943859","https://openalex.org/W2404462252","https://openalex.org/W2423036951","https://openalex.org/W2502896623","https://openalex.org/W2546772565","https://openalex.org/W2581448455","https://openalex.org/W2602567987","https://openalex.org/W2611426260","https://openalex.org/W2613751718","https://openalex.org/W2743027853","https://openalex.org/W2744538883","https://openalex.org/W2951177125","https://openalex.org/W2959792658","https://openalex.org/W2962790067","https://openalex.org/W2963211500","https://openalex.org/W3004286518","https://openalex.org/W3120740533","https://openalex.org/W3144237830","https://openalex.org/W4246444773","https://openalex.org/W4254246953","https://openalex.org/W4289258943","https://openalex.org/W4398299709"],"related_works":["https://openalex.org/W1488761988","https://openalex.org/W2044551864","https://openalex.org/W2047938026","https://openalex.org/W1572557500","https://openalex.org/W4390690393","https://openalex.org/W3124946120","https://openalex.org/W2585269888","https://openalex.org/W3132003399","https://openalex.org/W2909697207","https://openalex.org/W4385270236"],"abstract_inverted_index":{"Interactive":[0],"analytics":[1],"increasingly":[2],"involves":[3],"querying":[4],"for":[5,117],"quantiles":[6,94],"over":[7],"sub-populations":[8],"of":[9,80,98,110],"high":[10],"cardinality":[11],"datasets.":[12],"Data":[13],"processing":[14],"engines":[15],"such":[16],"as":[17,58],"Druid":[18,156],"and":[19,42,70,100,105,154],"Spark":[20],"use":[21,109],"mergeable":[22,44],"summaries":[23],"to":[24,57,152,160],"estimate":[25,93],"quantiles,":[26],"but":[27],"summary":[28,81],"merge":[29],"times":[30],"can":[31,47,91,127],"be":[32],"a":[33,40,64,78,111],"bottleneck":[34],"during":[35],"aggregation.":[36],"We":[37,87],"show":[38,106],"how":[39,89,107],"compact":[41],"efficiently":[43,92],"quantile":[45,133],"sketch":[46,126],"support":[48],"aggregation":[49],"workloads.":[50],"This":[51],"data":[52],"structure,":[53],"which":[54],"we":[55,90],"refer":[56],"the":[59,84,96,101,108,124,147,155],"moments":[60,99,125],"sketch,":[61],"operates":[62],"with":[63,135],"small":[65],"memory":[66],"footprint":[67],"(200":[68],"bytes)":[69],"computationally":[71],"efficient":[72],"(50ns)":[73],"merges":[74],"by":[75,150,158],"tracking":[76],"only":[77],"set":[79],"statistics,":[82],"notably":[83],"sample":[85],"moments.":[86],"demonstrate":[88],"using":[95],"method":[97],"maximum":[102],"entropy":[103],"principle,":[104],"cascade":[112],"further":[113],"improves":[114],"query":[115,144],"time":[116,145],"threshold":[118],"predicates.":[119],"Empirical":[120],"evaluation":[121],"shows":[122],"that":[123],"achieve":[128],"less":[129,137],"than":[130,139],"1":[131],"percent":[132],"error":[134],"15\u00d7":[136],"overhead":[138],"comparable":[140],"summaries,":[141],"improving":[142],"end":[143],"in":[146],"MacroBase":[148],"engine":[149,157],"up":[151,159],"7\u00d7":[153],"60\u00d7.":[161]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":9},{"year":2023,"cited_by_count":5},{"year":2022,"cited_by_count":4},{"year":2021,"cited_by_count":10},{"year":2020,"cited_by_count":13},{"year":2019,"cited_by_count":6},{"year":2018,"cited_by_count":2}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}