{"id":"https://openalex.org/W2059788796","doi":"https://doi.org/10.1109/tcc.2014.2338325","title":"FastRAQ: A Fast Approach to Range-Aggregate Queries in Big Data Environments","display_name":"FastRAQ: A Fast Approach to Range-Aggregate Queries in Big Data Environments","publication_year":2014,"publication_date":"2014-07-30","ids":{"openalex":"https://openalex.org/W2059788796","doi":"https://doi.org/10.1109/tcc.2014.2338325","mag":"2059788796"},"language":"en","primary_location":{"id":"doi:10.1109/tcc.2014.2338325","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tcc.2014.2338325","pdf_url":null,"source":{"id":"https://openalex.org/S2492498579","display_name":"IEEE Transactions on Cloud Computing","issn_l":"2168-7161","issn":["2168-7161","2372-0018"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["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 Cloud Computing","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/A5028040417","display_name":"Xiaochun Yun","orcid":"https://orcid.org/0000-0003-2849-1086"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"government","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210156404","display_name":"Institute of Information Engineering","ror":"https://ror.org/04r53se39","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210156404"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Xiaochun Yun","raw_affiliation_strings":["Institute of Information Engineering, Chinese Academy of Sciences, Beijing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Information Engineering, Chinese Academy of Sciences, Beijing, China","institution_ids":["https://openalex.org/I19820366","https://openalex.org/I4210156404"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102853473","display_name":"Guangjun Wu","orcid":"https://orcid.org/0000-0003-2753-8217"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"government","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210156404","display_name":"Institute of Information Engineering","ror":"https://ror.org/04r53se39","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210156404"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guangjun Wu","raw_affiliation_strings":["Institute of Information Engineering, Chinese Academy of Sciences, Beijing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Information Engineering, Chinese Academy of Sciences, Beijing, China","institution_ids":["https://openalex.org/I19820366","https://openalex.org/I4210156404"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102854878","display_name":"Guangyan Zhang","orcid":"https://orcid.org/0000-0002-3480-5902"},"institutions":[{"id":"https://openalex.org/I99065089","display_name":"Tsinghua University","ror":"https://ror.org/03cve4549","country_code":"CN","type":"education","lineage":["https://openalex.org/I99065089"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Guangyan Zhang","raw_affiliation_strings":["Department of Computer Science and Technology, Tsinghua University, Beijing, China","Dept. of Computer Science & Technology, Tsinghua University, Beijing, China#TAB#"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Technology, Tsinghua University, Beijing, China","institution_ids":["https://openalex.org/I99065089"]},{"raw_affiliation_string":"Dept. of Computer Science & Technology, Tsinghua University, Beijing, China#TAB#","institution_ids":["https://openalex.org/I99065089"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5087894632","display_name":"Keqin Li","orcid":"https://orcid.org/0000-0001-5224-4048"},"institutions":[{"id":"https://openalex.org/I1327163397","display_name":"State University of New York","ror":"https://ror.org/01q1z8k08","country_code":"US","type":"education","lineage":["https://openalex.org/I1327163397"]},{"id":"https://openalex.org/I157455823","display_name":"SUNY New Paltz","ror":"https://ror.org/03j3dv688","country_code":"US","type":"education","lineage":["https://openalex.org/I157455823"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Keqin Li","raw_affiliation_strings":["Department of Computer Science, State University of New York, New Paltz, NY","[Department of Computer Science, State University of New York, New Paltz, NY]"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science, State University of New York, New Paltz, NY","institution_ids":["https://openalex.org/I157455823"]},{"raw_affiliation_string":"[Department of Computer Science, State University of New York, New Paltz, NY]","institution_ids":["https://openalex.org/I1327163397"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5010150000","display_name":"Shupeng Wang","orcid":"https://orcid.org/0000-0002-2799-4100"},"institutions":[{"id":"https://openalex.org/I19820366","display_name":"Chinese Academy of Sciences","ror":"https://ror.org/034t30j35","country_code":"CN","type":"government","lineage":["https://openalex.org/I19820366"]},{"id":"https://openalex.org/I4210156404","display_name":"Institute of Information Engineering","ror":"https://ror.org/04r53se39","country_code":"CN","type":"facility","lineage":["https://openalex.org/I19820366","https://openalex.org/I4210156404"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Shupeng Wang","raw_affiliation_strings":["Institute of Information Engineering, Chinese Academy of Sciences, Beijing, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Institute of Information Engineering, Chinese Academy of Sciences, Beijing, China","institution_ids":["https://openalex.org/I19820366","https://openalex.org/I4210156404"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":4.0758,"has_fulltext":false,"cited_by_count":32,"citation_normalized_percentile":{"value":0.93989686,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":"3","issue":"2","first_page":"206","last_page":"218"},"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/T10627","display_name":"Advanced Image and Video Retrieval Techniques","score":0.9965999722480774,"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"}},{"id":"https://openalex.org/T11269","display_name":"Algorithms and Data Compression","score":0.987500011920929,"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/aggregate","display_name":"Aggregate (composite)","score":0.8150856494903564},{"id":"https://openalex.org/keywords/partition","display_name":"Partition (number theory)","score":0.7829633951187134},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7234528064727783},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7201205492019653},{"id":"https://openalex.org/keywords/range","display_name":"Range (aeronautics)","score":0.6755915284156799},{"id":"https://openalex.org/keywords/range-query","display_name":"Range query (database)","score":0.6154454350471497},{"id":"https://openalex.org/keywords/sketch","display_name":"Sketch","score":0.5724116563796997},{"id":"https://openalex.org/keywords/histogram","display_name":"Histogram","score":0.5362120866775513},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.4752461910247803},{"id":"https://openalex.org/keywords/online-aggregation","display_name":"Online aggregation","score":0.4386196434497833},{"id":"https://openalex.org/keywords/data-structure","display_name":"Data structure","score":0.4364733099937439},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3449513912200928},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.2568866014480591},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.19327673316001892},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.17230278253555298},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.162443608045578},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.16064411401748657},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.14257067441940308},{"id":"https://openalex.org/keywords/discrete-mathematics","display_name":"Discrete mathematics","score":0.08426839113235474},{"id":"https://openalex.org/keywords/combinatorics","display_name":"Combinatorics","score":0.07672348618507385},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.07631900906562805}],"concepts":[{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.8150856494903564},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.7829633951187134},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7234528064727783},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7201205492019653},{"id":"https://openalex.org/C204323151","wikidata":"https://www.wikidata.org/wiki/Q905424","display_name":"Range (aeronautics)","level":2,"score":0.6755915284156799},{"id":"https://openalex.org/C136736807","wikidata":"https://www.wikidata.org/wiki/Q818943","display_name":"Range query (database)","level":5,"score":0.6154454350471497},{"id":"https://openalex.org/C2779231336","wikidata":"https://www.wikidata.org/wiki/Q7534724","display_name":"Sketch","level":2,"score":0.5724116563796997},{"id":"https://openalex.org/C53533937","wikidata":"https://www.wikidata.org/wiki/Q185020","display_name":"Histogram","level":3,"score":0.5362120866775513},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.4752461910247803},{"id":"https://openalex.org/C24028149","wikidata":"https://www.wikidata.org/wiki/Q7094056","display_name":"Online aggregation","level":5,"score":0.4386196434497833},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.4364733099937439},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3449513912200928},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2568866014480591},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.19327673316001892},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.17230278253555298},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.162443608045578},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.16064411401748657},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.14257067441940308},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.08426839113235474},{"id":"https://openalex.org/C114614502","wikidata":"https://www.wikidata.org/wiki/Q76592","display_name":"Combinatorics","level":1,"score":0.07672348618507385},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.07631900906562805},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C115961682","wikidata":"https://www.wikidata.org/wiki/Q860623","display_name":"Image (mathematics)","level":2,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/tcc.2014.2338325","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tcc.2014.2338325","pdf_url":null,"source":{"id":"https://openalex.org/S2492498579","display_name":"IEEE Transactions on Cloud Computing","issn_l":"2168-7161","issn":["2168-7161","2372-0018"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319808","host_organization_name":"Institute of Electrical and Electronics Engineers","host_organization_lineage":["https://openalex.org/P4310319808"],"host_organization_lineage_names":["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 Cloud Computing","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G3366461611","display_name":null,"funder_award_id":"61202067","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8169812688","display_name":"\u9762\u5411\u4e91\u8ba1\u7b97\u7cfb\u7edf\u7684\u534f\u4f5c\u5f0f\u6570\u636e\u6d88\u5197\u4f20\u8f93\u7406\u8bba\u53ca\u65b9\u6cd5\u7814\u7a76","funder_award_id":"61271275","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"},{"id":"https://openalex.org/F4320321940","display_name":"Harbin Institute of Technology","ror":"https://ror.org/01yqg2h08"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":30,"referenced_works":["https://openalex.org/W1575494040","https://openalex.org/W1581547316","https://openalex.org/W1976597724","https://openalex.org/W1982092405","https://openalex.org/W1991969632","https://openalex.org/W1993892970","https://openalex.org/W2014989534","https://openalex.org/W2020147322","https://openalex.org/W2041912938","https://openalex.org/W2046437776","https://openalex.org/W2071425575","https://openalex.org/W2079057568","https://openalex.org/W2081227030","https://openalex.org/W2095178251","https://openalex.org/W2104829661","https://openalex.org/W2119072946","https://openalex.org/W2135472951","https://openalex.org/W2144982963","https://openalex.org/W2145555113","https://openalex.org/W2151065878","https://openalex.org/W2155110539","https://openalex.org/W2164507334","https://openalex.org/W2296677182","https://openalex.org/W2323881768","https://openalex.org/W3122714990","https://openalex.org/W4236656499","https://openalex.org/W4285719527","https://openalex.org/W6634880912","https://openalex.org/W6675385364","https://openalex.org/W6681658524"],"related_works":["https://openalex.org/W2156905243","https://openalex.org/W2963478395","https://openalex.org/W2763763937","https://openalex.org/W2060733691","https://openalex.org/W2159840061","https://openalex.org/W2168877244","https://openalex.org/W2491175701","https://openalex.org/W2753914954","https://openalex.org/W2164280904","https://openalex.org/W1561175729"],"abstract_inverted_index":{"Range-aggregate":[0],"queries":[1,20,42],"are":[2,21],"to":[3,18,23,40],"apply":[4],"a":[5,56,63,71,157],"certain":[6],"aggregate":[7],"function":[8],"on":[9,133],"all":[10,86,112],"tuples":[11,110],"within":[12,156,178],"given":[13,180],"query":[14,73,154],"ranges.":[15],"Existing":[16],"approaches":[17],"range-aggregate":[19,41,72,101,153],"insufficient":[22],"quickly":[24],"provide":[25],"accurate":[26],"results":[27,148,155],"in":[28,43,125],"big":[29,44,50],"data":[30,45,51,94,145],"environments.":[31,46],"In":[32],"this":[33],"paper,":[34],"we":[35],"propose":[36],"FastRAQ-a":[37],"fast":[38],"approach":[39,132],"FastRAQ":[47,76,88,131,151],"first":[48],"divides":[49],"into":[52],"independent":[53],"partitions":[54],"with":[55,141],"balanced":[57],"partitioning":[58],"algorithm,":[59],"and":[60,96,119,137],"then":[61],"generates":[62],"local":[64,83],"estimation":[65],"sketch":[66],"for":[67,93,100,111],"each":[68],"partition.":[69],"When":[70],"request":[74],"arrives,":[75],"obtains":[77],"the":[78,106,116,122,126,130,134,170,179],"result":[79],"directly":[80],"by":[81],"summarizing":[82],"estimates":[84],"from":[85],"partitions.":[87],"has":[89],"O(1)":[90],"time":[91,98,158],"complexity":[92,99],"updates":[95],"O(N/P\u00d7B)":[97],"queries,":[102],"where":[103],"N":[104],"is":[105,115,121,173],"number":[107,124],"of":[108,162,167],"distinct":[109],"dimensions,":[113],"P":[114],"partition":[117],"number,":[118],"B":[120],"bucket":[123],"histogram.":[127],"We":[128],"implement":[129],"Linux":[135],"platform,":[136],"evaluate":[138],"its":[139],"performance":[140],"about":[142],"10":[143],"billions":[144],"records.":[146],"Experimental":[147],"demonstrate":[149],"that":[150,166],"provides":[152],"period":[159],"two":[160],"orders":[161],"magnitude":[163],"lower":[164],"than":[165,175],"Hive,":[168],"while":[169],"relative":[171],"error":[172],"less":[174],"3":[176],"percent":[177],"confidence":[181],"interval.":[182]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2022,"cited_by_count":2},{"year":2020,"cited_by_count":4},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":4},{"year":2017,"cited_by_count":3},{"year":2016,"cited_by_count":9},{"year":2015,"cited_by_count":1}],"updated_date":"2026-07-22T07:51:19.307946","created_date":"2025-10-10T00:00:00"}