{"id":"https://openalex.org/W2141192422","doi":"https://doi.org/10.1145/1247480.1247535","title":"Sharing aggregate computation for distributed queries","display_name":"Sharing aggregate computation for distributed queries","publication_year":2007,"publication_date":"2007-06-11","ids":{"openalex":"https://openalex.org/W2141192422","doi":"https://doi.org/10.1145/1247480.1247535","mag":"2141192422"},"language":"en","primary_location":{"id":"doi:10.1145/1247480.1247535","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247535","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 ACM SIGMOD international conference on Management of data","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/A5008753977","display_name":"Ryan Huebsch","orcid":null},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Ryan Huebsch","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023079617","display_name":"Minos Garofalakis","orcid":"https://orcid.org/0000-0003-0285-3907"},"institutions":[{"id":"https://openalex.org/I4210134091","display_name":"Yahoo (United States)","ror":"https://ror.org/040dkzz12","country_code":"US","type":"company","lineage":["https://openalex.org/I4210134091"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Minos Garofalakis","raw_affiliation_strings":["Yahoo! Research, Berkeley, CA"],"affiliations":[{"raw_affiliation_string":"Yahoo! Research, Berkeley, CA","institution_ids":["https://openalex.org/I4210134091"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5043626252","display_name":"Joseph M. Hellerstein","orcid":"https://orcid.org/0000-0002-7712-4306"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Joseph M. Hellerstein","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA","institution_ids":["https://openalex.org/I95457486"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5041920173","display_name":"Ion Stoica","orcid":"https://orcid.org/0000-0002-5373-0088"},"institutions":[{"id":"https://openalex.org/I95457486","display_name":"University of California, Berkeley","ror":"https://ror.org/01an7q238","country_code":"US","type":"education","lineage":["https://openalex.org/I95457486"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ion Stoica","raw_affiliation_strings":["University of California at Berkeley, Berkeley, CA"],"affiliations":[{"raw_affiliation_string":"University of California at Berkeley, Berkeley, CA","institution_ids":["https://openalex.org/I95457486"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5008753977"],"corresponding_institution_ids":["https://openalex.org/I95457486"],"apc_list":null,"apc_paid":null,"fwci":6.4849,"has_fulltext":false,"cited_by_count":47,"citation_normalized_percentile":{"value":0.97261386,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"485","last_page":"496"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9965999722480774,"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.9965999722480774,"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/T10080","display_name":"Energy Efficient Wireless Sensor Networks","score":0.9919000267982483,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9886999726295471,"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/computer-science","display_name":"Computer science","score":0.8264003396034241},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.6126546263694763},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.555047333240509},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5378396511077881},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.4816795289516449},{"id":"https://openalex.org/keywords/computation","display_name":"Computation","score":0.4718632400035858},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.4290877878665924},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.3947691023349762},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.2115321159362793},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.0902927815914154}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8264003396034241},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.6126546263694763},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.555047333240509},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5378396511077881},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.4816795289516449},{"id":"https://openalex.org/C45374587","wikidata":"https://www.wikidata.org/wiki/Q12525525","display_name":"Computation","level":2,"score":0.4718632400035858},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.4290877878665924},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.3947691023349762},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2115321159362793},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0902927815914154},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","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/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"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":5,"locations":[{"id":"doi:10.1145/1247480.1247535","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1247480.1247535","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2007 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:berkeley.edu:13030-hb4j49p330","is_oa":false,"landing_page_url":"http://techreports.lib.berkeley.edu/accessPages/EECS-2006-98.html","pdf_url":null,"source":{"id":"https://openalex.org/S7407050879","display_name":"UC Berkeley","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"technical reports"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.118.5817","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.118.5817","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.ucf.edu/~kienhua/classes/COP5711/Papers/Sigmod07DDB.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.123.3960","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.123.3960","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.berkeley.edu/~minos/Papers/sigmod07aggshare.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.69.2381","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.69.2381","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.cs.berkeley.edu/~istoica/papers/2007/ryan-sigmod07.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":21,"referenced_works":["https://openalex.org/W139219924","https://openalex.org/W1575701986","https://openalex.org/W1982691959","https://openalex.org/W2011039300","https://openalex.org/W2023797161","https://openalex.org/W2029146455","https://openalex.org/W2058978608","https://openalex.org/W2059453880","https://openalex.org/W2085426673","https://openalex.org/W2101717554","https://openalex.org/W2107443258","https://openalex.org/W2107800601","https://openalex.org/W2126490564","https://openalex.org/W2130203819","https://openalex.org/W2134743705","https://openalex.org/W2135499008","https://openalex.org/W2140430731","https://openalex.org/W2144261930","https://openalex.org/W2144499729","https://openalex.org/W2153259545","https://openalex.org/W2167396179"],"related_works":["https://openalex.org/W17155033","https://openalex.org/W3207760230","https://openalex.org/W1496222301","https://openalex.org/W1590307681","https://openalex.org/W2536018345","https://openalex.org/W4312814274","https://openalex.org/W4285370786","https://openalex.org/W2296488620","https://openalex.org/W2358353312","https://openalex.org/W2353836703"],"abstract_inverted_index":{"An":[0],"emerging":[1],"challenge":[2,34],"in":[3,45,59,68,75,115],"modern":[4],"distributed":[5,63,207],"querying":[6],"is":[7,35],"to":[8,36,119,176,210],"efficiently":[9],"process":[10],"multiple":[11],"continuous":[12],"aggregation":[13,64,164],"queries":[14,47,65,83,96,111,147],"simultaneously.":[15],"Processing":[16],"each":[17],"query":[18],"independently":[19],"may":[20,41],"be":[21,43,85,149],"infeasible,":[22],"so":[23],"multi-query":[24],"optimizations":[25],"are":[26,97],"critical":[27],"for":[28,56,145,183,199,231],"sharing":[29,57,143,174,212],"work":[30,58],"across":[31],"queries.":[32,93],"The":[33,94],"identify":[37,73,127],"overlapping":[38],"computations":[39],"that":[40,66,112,141,172,195],"not":[42],"obvious":[44],"the":[46,60,105,110,142,177,217],"themselves.":[48],"In":[49],"this":[50,232],"paper,":[51],"we":[52,126,170,186,229],"reveal":[53],"new":[54],"opportunities":[55],"context":[61],"of":[62,80,130,190,219],"vary":[67],"their":[69],"selection":[70],"predicates.":[71],"We":[72,202],"settings":[74],"which":[76],"a":[77,101,116,128,188,205,223],"large":[78],"set":[79,179],"q":[81,91],"such":[82,146],"can":[84,148],"answered":[86],"by":[87,99],"executing":[88],"k":[89,95],"\u226a":[90],"different":[92],"revealed":[98],"analyzing":[100],"boolean":[102],"matrix":[103,154],"capturing":[104],"connection":[106],"between":[107],"data":[108],"and":[109,137,139,168,193,214,235],"they":[113,196],"satisfy,":[114],"manner":[117],"akin":[118],"familiar":[120],"techniques":[121,221],"like":[122],"Gaussian":[123],"elimination.":[124],"Indeed,":[125],"class":[129],"linear":[131,158],"aggregate":[132],"functions":[133,165],"(including":[134,166],"SUM,":[135],"COUNT":[136],"AVERAGE),":[138],"show":[140],"potential":[144],"optimally":[150],"recovered":[151],"using":[152],"standard":[153],"decompositions":[155],"from":[156],"computational":[157],"algebra.":[159],"For":[160],"some":[161],"other":[162],"typical":[163],"MIN":[167],"MAX)":[169],"find":[171],"optimal":[173],"maps":[175],"NP-hard":[178],"basis":[180],"problem.":[181],"However,":[182],"those":[184],"scenarios,":[185],"present":[187,204],"family":[189],"heuristic":[191],"algorithms":[192],"demonstrate":[194],"perform":[197],"well":[198],"moderate-sized":[200],"matrices.":[201],"also":[203],"dynamic":[206],"system":[208],"architecture":[209],"exploit":[211],"opportunities,":[213],"experimentally":[215],"evaluate":[216],"benefits":[218],"our":[220],"via":[222],"novel,":[224],"flexible":[225],"random":[226],"workload":[227],"generator":[228],"develop":[230],"setting.":[233],"Categories":[234],"Subject":[236],"Descriptors:":[237],"H.2.4":[238],"[Systems]:":[239],"Distributed":[240],"databases":[241]},"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":4},{"year":2015,"cited_by_count":1},{"year":2014,"cited_by_count":2},{"year":2013,"cited_by_count":1},{"year":2012,"cited_by_count":7}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}