{"id":"https://openalex.org/W2066293100","doi":"https://doi.org/10.1145/1807167.1807238","title":"Continuous sampling for online aggregation over multiple queries","display_name":"Continuous sampling for online aggregation over multiple queries","publication_year":2010,"publication_date":"2010-06-06","ids":{"openalex":"https://openalex.org/W2066293100","doi":"https://doi.org/10.1145/1807167.1807238","mag":"2066293100"},"language":"en","primary_location":{"id":"doi:10.1145/1807167.1807238","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1807167.1807238","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2010 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/A5064646829","display_name":"Sai Wu","orcid":"https://orcid.org/0000-0002-1866-9197"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":true,"raw_author_name":"Sai Wu","raw_affiliation_strings":["National University of Singapore, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024892041","display_name":"Beng Chin Ooi","orcid":"https://orcid.org/0000-0003-4446-1100"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Beng Chin Ooi","raw_affiliation_strings":["National University of Singapore, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5077593594","display_name":"Kian\u2010Lee Tan","orcid":"https://orcid.org/0000-0001-9315-4057"},"institutions":[{"id":"https://openalex.org/I165932596","display_name":"National University of Singapore","ror":"https://ror.org/01tgyzw49","country_code":"SG","type":"education","lineage":["https://openalex.org/I165932596"]}],"countries":["SG"],"is_corresponding":false,"raw_author_name":"Kian-Lee Tan","raw_affiliation_strings":["National University of Singapore, Singapore, Singapore"],"affiliations":[{"raw_affiliation_string":"National University of Singapore, Singapore, Singapore","institution_ids":["https://openalex.org/I165932596"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5064646829"],"corresponding_institution_ids":["https://openalex.org/I165932596"],"apc_list":null,"apc_paid":null,"fwci":3.0436,"has_fulltext":false,"cited_by_count":78,"citation_normalized_percentile":{"value":0.91915407,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"651","last_page":"662"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"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"}},"topics":[{"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.998199999332428,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.998199999332428,"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/computer-science","display_name":"Computer science","score":0.8067484498023987},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.7383530139923096},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.6214399337768555},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.5920342206954956},{"id":"https://openalex.org/keywords/node","display_name":"Node (physics)","score":0.5558797717094421},{"id":"https://openalex.org/keywords/cosmos","display_name":"Cosmos (plant)","score":0.5552748441696167},{"id":"https://openalex.org/keywords/directed-acyclic-graph","display_name":"Directed acyclic graph","score":0.5068214535713196},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4762073755264282},{"id":"https://openalex.org/keywords/sampling","display_name":"Sampling (signal processing)","score":0.47542598843574524},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3943963944911957},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3813880681991577},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.37884998321533203},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.18427932262420654}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8067484498023987},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.7383530139923096},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.6214399337768555},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5920342206954956},{"id":"https://openalex.org/C62611344","wikidata":"https://www.wikidata.org/wiki/Q1062658","display_name":"Node (physics)","level":2,"score":0.5558797717094421},{"id":"https://openalex.org/C2780307871","wikidata":"https://www.wikidata.org/wiki/Q476937","display_name":"Cosmos (plant)","level":2,"score":0.5552748441696167},{"id":"https://openalex.org/C74197172","wikidata":"https://www.wikidata.org/wiki/Q1195339","display_name":"Directed acyclic graph","level":2,"score":0.5068214535713196},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4762073755264282},{"id":"https://openalex.org/C140779682","wikidata":"https://www.wikidata.org/wiki/Q210868","display_name":"Sampling (signal processing)","level":3,"score":0.47542598843574524},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3943963944911957},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3813880681991577},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.37884998321533203},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.18427932262420654},{"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/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C31972630","wikidata":"https://www.wikidata.org/wiki/Q844240","display_name":"Computer vision","level":1,"score":0.0},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","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/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C106131492","wikidata":"https://www.wikidata.org/wiki/Q3072260","display_name":"Filter (signal processing)","level":2,"score":0.0},{"id":"https://openalex.org/C52119013","wikidata":"https://www.wikidata.org/wiki/Q50637","display_name":"Art history","level":1,"score":0.0},{"id":"https://openalex.org/C66938386","wikidata":"https://www.wikidata.org/wiki/Q633538","display_name":"Structural engineering","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/1807167.1807238","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1807167.1807238","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2010 ACM SIGMOD International Conference on Management of data","raw_type":"proceedings-article"},{"id":"pmh:oai:scholarbank.nus.edu.sg:10635/41180","is_oa":false,"landing_page_url":"http://scholarbank.nus.edu.sg/handle/10635/41180","pdf_url":null,"source":{"id":"https://openalex.org/S7407052290","display_name":"National University of Singapore","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":"Scopus","raw_type":"Conference Paper"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.211.6687","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.211.6687","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.comp.nus.edu.sg/~ooibc/sigmod10cosmos.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":23,"referenced_works":["https://openalex.org/W1531312256","https://openalex.org/W2020147322","https://openalex.org/W2022942700","https://openalex.org/W2037701287","https://openalex.org/W2038176938","https://openalex.org/W2058424950","https://openalex.org/W2069433961","https://openalex.org/W2098416578","https://openalex.org/W2107422095","https://openalex.org/W2117538598","https://openalex.org/W2119072946","https://openalex.org/W2126652202","https://openalex.org/W2132808937","https://openalex.org/W2149304112","https://openalex.org/W2164049396","https://openalex.org/W2167811976","https://openalex.org/W2169982181","https://openalex.org/W2199389590","https://openalex.org/W2296677182","https://openalex.org/W4229903866","https://openalex.org/W4240682706","https://openalex.org/W4250212406","https://openalex.org/W6750558377"],"related_works":["https://openalex.org/W1496222301","https://openalex.org/W3207760230","https://openalex.org/W1590307681","https://openalex.org/W4312814274","https://openalex.org/W4285370786","https://openalex.org/W2296488620","https://openalex.org/W2358353312","https://openalex.org/W2353836703","https://openalex.org/W41015297","https://openalex.org/W4280645561"],"abstract_inverted_index":{"In":[0,27,65],"this":[1,66],"paper,":[2],"we":[3],"propose":[4],"an":[5,17,126],"online":[6,104],"aggregation":[7,19],"system":[8],"called":[9],"COSMOS":[10,90,109,123],"(Continuous":[11],"Sampling":[12],"for":[13,48,106],"Multiple":[14],"queries":[15,25,54,70],"in":[16,130],"Online":[18],"System),":[20],"to":[21,42,59,72,83,95,101,115],"process":[22],"multiple":[23],"aggregate":[24],"efficiently.":[26],"COSMOS,":[28],"a":[29,43,56,107,112],"dataset":[30,39],"is":[31],"first":[32],"scrambled":[33],"so":[34],"that":[35],"sequentially":[36],"scanning":[37],"the":[38,61,73,85,103,135,139],"gives":[40],"rise":[41],"stream":[44],"of":[45,69,76,87,143],"random":[46],"samples":[47],"all":[49],"queries.":[50,64,89],"Moreover,":[51],"COS-MOS":[52],"organizes":[53],"into":[55],"dissemination":[57],"graph":[58],"exploit":[60],"dependencies":[62],"across":[63],"way,":[67],"aggregates":[68,86,105],"closer":[71],"root":[74],"(source":[75],"data":[77],"flow)":[78],"can":[79],"potentially":[80],"be":[81],"used":[82],"compute":[84],"descendent/dependent":[88],"applies":[91],"some":[92],"statistical":[93],"approach":[94],"combine":[96],"answers":[97],"from":[98],"ancestor":[99],"nodes":[100],"generate":[102],"node.":[108],"also":[110],"offers":[111],"partitioning":[113],"strategy":[114],"further":[116],"salvage":[117],"intermediate":[118],"answers.":[119],"We":[120],"have":[121],"implemented":[122],"and":[124,141],"conducted":[125],"extensive":[127],"experimental":[128],"study":[129],"PostgreSQL.":[131],"Our":[132],"results":[133],"on":[134],"TPC-H":[136],"benchmark":[137],"show":[138],"efficiency":[140],"effectiveness":[142],"COSMOS.":[144]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":4},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":8},{"year":2018,"cited_by_count":12},{"year":2017,"cited_by_count":12},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":10},{"year":2013,"cited_by_count":3},{"year":2012,"cited_by_count":5}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}