{"id":"https://openalex.org/W2964468098","doi":"https://doi.org/10.14778/3339490.3339499","title":"Optimal and general out-of-order sliding-window aggregation","display_name":"Optimal and general out-of-order sliding-window aggregation","publication_year":2019,"publication_date":"2019-06-01","ids":{"openalex":"https://openalex.org/W2964468098","doi":"https://doi.org/10.14778/3339490.3339499","mag":"2964468098"},"language":"en","primary_location":{"id":"doi:10.14778/3339490.3339499","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3339490.3339499","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/A5054849628","display_name":"Kanat Tangwongsan","orcid":"https://orcid.org/0000-0001-9775-8165"},"institutions":[{"id":"https://openalex.org/I25399158","display_name":"Mahidol University","ror":"https://ror.org/01znkr924","country_code":"TH","type":"education","lineage":["https://openalex.org/I25399158"]},{"id":"https://openalex.org/I316699675","display_name":"Hodges University","ror":"https://ror.org/00s8h5d08","country_code":"US","type":"education","lineage":["https://openalex.org/I316699675"]}],"countries":["TH","US"],"is_corresponding":false,"raw_author_name":"Kanat Tangwongsan","raw_affiliation_strings":["Mahidol University International College"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Mahidol University International College","institution_ids":["https://openalex.org/I25399158","https://openalex.org/I316699675"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5079080602","display_name":"Martin Hirzel","orcid":"https://orcid.org/0009-0006-8840-6065"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Martin Hirzel","raw_affiliation_strings":["IBM Research"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5111811936","display_name":"Scott Schneider","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Scott Schneider","raw_affiliation_strings":["IBM Research"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"IBM Research","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":2.6034,"has_fulltext":false,"cited_by_count":32,"citation_normalized_percentile":{"value":0.9062385,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":96,"max":99},"biblio":{"volume":"12","issue":"10","first_page":"1167","last_page":"1180"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"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/T11106","display_name":"Data Management and Algorithms","score":0.9993000030517578,"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/T12761","display_name":"Data Stream Mining Techniques","score":0.9983999729156494,"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/sliding-window-protocol","display_name":"Sliding window protocol","score":0.7657430768013},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6202501654624939},{"id":"https://openalex.org/keywords/window","display_name":"Window (computing)","score":0.5331653356552124},{"id":"https://openalex.org/keywords/latency","display_name":"Latency (audio)","score":0.47148892283439636},{"id":"https://openalex.org/keywords/upper-and-lower-bounds","display_name":"Upper and lower bounds","score":0.45124977827072144},{"id":"https://openalex.org/keywords/data-stream-mining","display_name":"Data stream mining","score":0.45122048258781433},{"id":"https://openalex.org/keywords/matching","display_name":"Matching (statistics)","score":0.41989952325820923},{"id":"https://openalex.org/keywords/real-time-computing","display_name":"Real-time computing","score":0.3988902270793915},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.3850792348384857},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.28355932235717773},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.11381995677947998},{"id":"https://openalex.org/keywords/telecommunications","display_name":"Telecommunications","score":0.09893816709518433},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.09679260849952698}],"concepts":[{"id":"https://openalex.org/C102392041","wikidata":"https://www.wikidata.org/wiki/Q592860","display_name":"Sliding window protocol","level":3,"score":0.7657430768013},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6202501654624939},{"id":"https://openalex.org/C2778751112","wikidata":"https://www.wikidata.org/wiki/Q835016","display_name":"Window (computing)","level":2,"score":0.5331653356552124},{"id":"https://openalex.org/C82876162","wikidata":"https://www.wikidata.org/wiki/Q17096504","display_name":"Latency (audio)","level":2,"score":0.47148892283439636},{"id":"https://openalex.org/C77553402","wikidata":"https://www.wikidata.org/wiki/Q13222579","display_name":"Upper and lower bounds","level":2,"score":0.45124977827072144},{"id":"https://openalex.org/C89198739","wikidata":"https://www.wikidata.org/wiki/Q3079880","display_name":"Data stream mining","level":2,"score":0.45122048258781433},{"id":"https://openalex.org/C165064840","wikidata":"https://www.wikidata.org/wiki/Q1321061","display_name":"Matching (statistics)","level":2,"score":0.41989952325820923},{"id":"https://openalex.org/C79403827","wikidata":"https://www.wikidata.org/wiki/Q3988","display_name":"Real-time computing","level":1,"score":0.3988902270793915},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.3850792348384857},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.28355932235717773},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.11381995677947998},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.09893816709518433},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.09679260849952698},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3339490.3339499","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3339490.3339499","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":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":36,"referenced_works":["https://openalex.org/W398859631","https://openalex.org/W1976821017","https://openalex.org/W1985605309","https://openalex.org/W2025387515","https://openalex.org/W2037007500","https://openalex.org/W2041749018","https://openalex.org/W2052464302","https://openalex.org/W2077180154","https://openalex.org/W2085426673","https://openalex.org/W2098037505","https://openalex.org/W2101717554","https://openalex.org/W2102654168","https://openalex.org/W2114409719","https://openalex.org/W2123388621","https://openalex.org/W2123845384","https://openalex.org/W2135216003","https://openalex.org/W2153972927","https://openalex.org/W2156212081","https://openalex.org/W2166597031","https://openalex.org/W2167274498","https://openalex.org/W2171828861","https://openalex.org/W2247317079","https://openalex.org/W2294510862","https://openalex.org/W2295655272","https://openalex.org/W2534428167","https://openalex.org/W2566979091","https://openalex.org/W2623567496","https://openalex.org/W2623691391","https://openalex.org/W2752885492","https://openalex.org/W2790658561","https://openalex.org/W2794747816","https://openalex.org/W2794948548","https://openalex.org/W2901608006","https://openalex.org/W2934794790","https://openalex.org/W6677231548","https://openalex.org/W7029321148"],"related_works":["https://openalex.org/W4360995307","https://openalex.org/W2167004500","https://openalex.org/W2141008330","https://openalex.org/W2059461309","https://openalex.org/W1572762191","https://openalex.org/W2375516608","https://openalex.org/W2106570241","https://openalex.org/W3207785250","https://openalex.org/W4382459699","https://openalex.org/W6445124"],"abstract_inverted_index":{"Sliding-window":[0],"aggregation":[1,30,86],"derives":[2],"a":[3,11,81,164],"user-defined":[4],"summary":[5],"of":[6,10,92,95,124],"the":[7,29,73,102,122,125,128,156,173,211],"most-recent":[8],"portion":[9],"data":[12,37],"stream.":[13],"For":[14,50],"in-order":[15,137],"streams,":[16,52],"each":[17],"window":[18,68,75,85,196],"change":[19,126],"can":[20,188],"be":[21],"handled":[22],"in":[23,206],"O":[24,61,114,133,141,150,219],"(1)":[25,134,142],"time":[26,65,135,143,154],"even":[27],"when":[28],"operator":[31],"is":[32,72,98,121],"not":[33],"invertible.":[34],"But":[35],"streaming":[36],"often":[38],"arrive":[39],"inherently":[40],"out-of-order,":[41],"e.g.,":[42],"due":[43],"to":[44,56,127,149,210],"clock":[45],"drifts":[46],"and":[47,104,139,176,182,208],"communication":[48],"delays.":[49],"such":[51],"prior":[53],"work":[54],"resorted":[55],"latency-prone":[57],"buffering":[58],"or":[59,110],"spent":[60],"(log":[62,115,151,220],"n":[63,71,152,221],")":[64,117,153,222],"for":[66,136,144,155,195],"every":[67],"change,":[69],"where":[70,119],"instantaneous":[74],"size.":[76],"This":[77,131],"paper":[78],"presents":[79],"FiBA,":[80],"novel":[82],"real-time":[83],"sliding":[84],"algorithm":[87,174],"that":[88,192,202],"optimally":[89],"handles":[90],"streams":[91],"varying":[93],"degrees":[94],"out-of-orderness.":[96],"FiBA":[97,187,203],"as":[99,101],"general":[100],"state-of-the-art":[103],"supports":[105],"variable-sized":[106],"windows.":[107],"An":[108],"insert":[109],"evict":[111],"takes":[112],"amortized":[113],"d":[116,120],"time,":[118],"distance":[123],"window's":[129],"boundary.":[130],"means":[132],"arrivals":[138],"nearly":[140],"slightly":[145],"out-of-order":[146,159],"arrivals,":[147],"tending":[148],"most":[157],"severely":[158],"arrivals.":[160],"We":[161],"also":[162],"prove":[163],"matching":[165],"lower":[166],"bound,":[167],"showing":[168],"optimality.":[169],"At":[170],"its":[171],"heart,":[172],"combines":[175],"extends":[177],"finger":[178],"searching,":[179],"lazy":[180],"rebalancing,":[181],"position-aware":[183],"partial":[184],"aggregates.":[185],"Further,":[186],"answer":[189],"range":[190],"queries":[191],"aggregate":[193],"subwindows":[194],"sharing.":[197],"Finally,":[198],"our":[199],"experiments":[200],"show":[201],"performs":[204],"well":[205],"practice":[207],"conforms":[209],"theoretical":[212],"findings,":[213],"with":[214],"significantly":[215],"higher":[216],"throughput":[217],"than":[218],"algorithms.":[223]},"counts_by_year":[{"year":2026,"cited_by_count":2},{"year":2025,"cited_by_count":3},{"year":2024,"cited_by_count":6},{"year":2023,"cited_by_count":7},{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":7},{"year":2020,"cited_by_count":4}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}