{"id":"https://openalex.org/W7098697826","doi":null,"title":"Processing Complex Aggregate Queries over Data Streams","display_name":"Processing Complex Aggregate Queries over Data Streams","alternate_titles":[],"publication_year":null,"publication_date":null,"ids":{"openalex":"https://openalex.org/W7098697826"},"language":"en","primary_location":{"id":"pmh:oai:CiteSeerX.psu:10.1.1.603.731","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.603.731","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.searchforum.org.cn/dataflowgroup/Reading/Reading_Suny/SIGMOD/sigmod2002/processing complex aggregate queries over data streams.pdf","raw_type":"text"},"parent_works":[],"lineage":["https://openalex.org/W7098697826"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5023079617","display_name":"Minos Garofalakis","orcid":"https://orcid.org/0000-0003-0285-3907","observed_orcids":["https://orcid.org/0000-0003-0285-3907"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Minos Garofalakis","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023537206","display_name":"Johannes E. Gehrke","orcid":"https://orcid.org/0009-0006-6293-5209","observed_orcids":["https://orcid.org/0009-0006-6293-5209"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Johannes Gehrke","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]},{"author_position":"last","author":{"id":null,"display_name":"Rajeev Rastogi","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Rajeev Rastogi","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":true,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.9980000257492065,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.0006000000284984708,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"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.00019999999494757503,"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-queries","display_name":"aggregate queries","score":0.7760000228881836},{"id":"https://openalex.org/keywords/data-streams","display_name":"data streams","score":0.9150000214576721},{"id":"https://openalex.org/keywords/approximate-query-processing","display_name":"approximate query processing","score":0.7490000128746033},{"id":"https://openalex.org/keywords/sketching","display_name":"sketching","score":0.7940000295639038},{"id":"https://openalex.org/keywords/limited-memory","display_name":"limited memory","score":0.628000020980835},{"id":"https://openalex.org/keywords/domain-partitioning","display_name":"domain partitioning","score":0.8349999785423279},{"id":"https://openalex.org/keywords/histograms","display_name":"histograms","score":0.9490000009536743},{"id":"https://openalex.org/keywords/sql-queries","display_name":"SQL queries","score":0.7329999804496765},{"id":"https://openalex.org/keywords/approximation-guarantees","display_name":"approximation guarantees","score":0.5989999771118164}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8306999802589417},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.7911999821662903},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.7077000141143799},{"id":"https://openalex.org/C42812","wikidata":"https://www.wikidata.org/wiki/Q1082910","display_name":"Partition (number theory)","level":2,"score":0.6575000286102295},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5807999968528748},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.5128999948501587},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4377000033855438},{"id":"https://openalex.org/C2778484313","wikidata":"https://www.wikidata.org/wiki/Q1172540","display_name":"Data stream","level":2,"score":0.42989999055862427},{"id":"https://openalex.org/C36503486","wikidata":"https://www.wikidata.org/wiki/Q11235244","display_name":"Domain (mathematical analysis)","level":2,"score":0.4189000129699707},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.41850000619888306},{"id":"https://openalex.org/C2778058735","wikidata":"https://www.wikidata.org/wiki/Q4692253","display_name":"Aggregate data","level":2,"score":0.3472000062465668},{"id":"https://openalex.org/C42058472","wikidata":"https://www.wikidata.org/wiki/Q810214","display_name":"Base (topology)","level":2,"score":0.29739999771118164},{"id":"https://openalex.org/C42090638","wikidata":"https://www.wikidata.org/wiki/Q4048907","display_name":"STREAMS","level":2,"score":0.29440000653266907},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.29339998960494995},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.2897999882698059},{"id":"https://openalex.org/C24756922","wikidata":"https://www.wikidata.org/wiki/Q1757694","display_name":"Data quality","level":3,"score":0.27709999680519104},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.2728999853134155},{"id":"https://openalex.org/C53533937","wikidata":"https://www.wikidata.org/wiki/Q185020","display_name":"Histogram","level":3,"score":0.2689000070095062},{"id":"https://openalex.org/C176217482","wikidata":"https://www.wikidata.org/wiki/Q860554","display_name":"Metric (unit)","level":2,"score":0.2671000063419342},{"id":"https://openalex.org/C175801342","wikidata":"https://www.wikidata.org/wiki/Q1988917","display_name":"Data analysis","level":2,"score":0.2621000111103058},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.259799987077713},{"id":"https://openalex.org/C82578977","wikidata":"https://www.wikidata.org/wiki/Q16773055","display_name":"Data aggregator","level":3,"score":0.25619998574256897}],"mesh":[],"locations_count":1,"locations":[{"id":"pmh:oai:CiteSeerX.psu:10.1.1.603.731","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.603.731","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.searchforum.org.cn/dataflowgroup/Reading/Reading_Suny/SIGMOD/sigmod2002/processing complex aggregate queries over data streams.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W7095625344","https://openalex.org/W2379926810","https://openalex.org/W2574650610","https://openalex.org/W2375169826","https://openalex.org/W1995328140","https://openalex.org/W2122290246","https://openalex.org/W2167216631","https://openalex.org/W2121654526"],"abstract_inverted_index":{"Recent":[0],"years":[1],"have":[2],"witnessed":[3],"an":[4],"increasing":[5],"interest":[6],"in":[7,23,146,180],"designing":[8],"algorithms":[9],"for":[10,47,212],"querying":[11],"and":[12,55,73],"analyzing":[13],"streaming":[14],"data":[15,17,41,61,91,140,199],"(i.e.,":[16],"that":[18,102,111,183,202],"is":[19,43,164,216],"seen":[20],"only":[21,28],"once":[22],"a":[24,44,181],"fixed":[25],"order)":[26],"with":[27,93,123,193],"limited":[29,94],"memory.":[30],"Providing":[31],"((perhaps":[32],"approxi-mate)":[33],"answers":[34,119,208],"to":[35,69,116,120,150,165,210,226],"queries":[36,88,122],"ov":[37],"r":[38],"uch":[39],"continuous":[40,90],"streams":[42,92,110,200],"crucial":[45],"re-quirement":[46],"many":[48],"application":[49],"environments;":[50],"examples":[51],"include":[52],"large":[53],"tele-com":[54],"IP":[56],"network":[57,67],"installations":[58],"where":[59],"performance":[60],"from":[62],"different":[63],"parts":[64],"of":[65,82,108,154,189,231],"the":[66,80,109,127,138,147,152,155,168,171,177,229,232],"needs":[68],"be":[70,114,144],"continuously":[71],"collected":[72],"analyzed.":[74],"In":[75],"this":[76],"paper,":[77],"we":[78],"consider":[79],"problem":[81,179],"approximately":[83],"answering":[84],"gen-eral":[85],"aggregate":[86,121,213],"SQL":[87],"over":[89],"mem-ory.":[95],"Our":[96],"method":[97],"relies":[98],"on":[99,126,137],"randomizing":[100],"techniques":[101],"compute":[103],"small":[104],"\"sketch":[105],"\"":[106],"summaries":[107],"can":[112,143],"then":[113],"used":[115,145],"provide":[117,204],"approx-imate":[118],"provable":[124],"guarantees":[125],"approx-imation":[128],"error.":[129],"We":[130],"also":[131],"demonstrate":[132],"how":[133],"existing":[134],"statistical":[135],"information":[136],"base":[139],"(e.g.,":[141],"histograms)":[142],"proposed":[148],"framework":[149],"improve":[151],"quality":[153],"approximation":[156],"provided":[157],"by":[158],"our":[159,186,190,220],"algorithms.":[160],"The":[161],"key":[162],"idea":[163],"intelligently":[166],"partition":[167],"domain":[169,221],"f":[170],"underlying":[172],"attribute(s)":[173],"and,":[174],"thus,":[175],"decompose":[176],"sketching":[178],"way":[182],"provably":[184],"tight-ens":[185],"guarantees.":[187],"Results":[188],"experimental":[191],"study":[192],"real-life":[194],"as":[195,197],"well":[196],"synthetic":[198],"indicate":[201],"sketches":[203],"significantly":[205],"more":[206],"accurate":[207],"compared":[209],"histograms":[211],"queries.":[214],"This":[215],"es-pecially":[217],"true":[218],"when":[219],"partitioning":[222],"methods":[223],"are":[224],"employed":[225],"further":[227],"boost":[228],"accuracy":[230],"final":[233],"estimates.":[234],"1.":[235]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W7098697826","counts_by_year":[],"updated_date":"2026-11-14T11:04:58.165337","created_date":"2025-10-27T00:00:00"}
