{"id":"https://openalex.org/W4413943390","doi":"https://doi.org/10.14778/3742728.3742732","title":"Approximation-First Timeseries Query At Scale","display_name":"Approximation-First Timeseries Query At Scale","publication_year":2025,"publication_date":"2025-04-01","ids":{"openalex":"https://openalex.org/W4413943390","doi":"https://doi.org/10.14778/3742728.3742732"},"language":"en","primary_location":{"id":"doi:10.14778/3742728.3742732","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3742728.3742732","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":null,"display_name":"Zeying Zhu","orcid":null},"institutions":[{"id":"https://openalex.org/I66946132","display_name":"University of Maryland, College Park","ror":"https://ror.org/047s2c258","country_code":"US","type":"education","lineage":["https://openalex.org/I66946132"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zeying Zhu","raw_affiliation_strings":["University of Maryland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Maryland","institution_ids":["https://openalex.org/I66946132"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5017580896","display_name":"Jonathan Chamberlain","orcid":"https://orcid.org/0000-0001-7029-2836"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Jonathan Chamberlain","raw_affiliation_strings":["Boston University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Boston University","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5078531387","display_name":"Kenny Wu","orcid":null},"institutions":[{"id":"https://openalex.org/I66946132","display_name":"University of Maryland, College Park","ror":"https://ror.org/047s2c258","country_code":"US","type":"education","lineage":["https://openalex.org/I66946132"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Kenny Wu","raw_affiliation_strings":["University of Maryland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Maryland","institution_ids":["https://openalex.org/I66946132"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5011231717","display_name":"David Starobinski","orcid":"https://orcid.org/0000-0002-8071-3865"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"David Starobinski","raw_affiliation_strings":["Boston University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Boston University","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5015818714","display_name":"Zaoxing Liu","orcid":"https://orcid.org/0000-0002-9119-1679"},"institutions":[{"id":"https://openalex.org/I66946132","display_name":"University of Maryland, College Park","ror":"https://ror.org/047s2c258","country_code":"US","type":"education","lineage":["https://openalex.org/I66946132"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Zaoxing Liu","raw_affiliation_strings":["University of Maryland"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"University of Maryland","institution_ids":["https://openalex.org/I66946132"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.25239099,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"18","issue":"8","first_page":"2348","last_page":"2361"},"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/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/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9979000091552734,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/scale","display_name":"Scale (ratio)","score":0.5995858907699585},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.48617714643478394},{"id":"https://openalex.org/keywords/time-series","display_name":"Time series","score":0.4485248625278473},{"id":"https://openalex.org/keywords/series","display_name":"Series (stratigraphy)","score":0.4334322214126587},{"id":"https://openalex.org/keywords/econometrics","display_name":"Econometrics","score":0.391275554895401},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.23077818751335144},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.17992493510246277},{"id":"https://openalex.org/keywords/geology","display_name":"Geology","score":0.12549719214439392},{"id":"https://openalex.org/keywords/geography","display_name":"Geography","score":0.12337276339530945},{"id":"https://openalex.org/keywords/cartography","display_name":"Cartography","score":0.0801105797290802}],"concepts":[{"id":"https://openalex.org/C2778755073","wikidata":"https://www.wikidata.org/wiki/Q10858537","display_name":"Scale (ratio)","level":2,"score":0.5995858907699585},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.48617714643478394},{"id":"https://openalex.org/C151406439","wikidata":"https://www.wikidata.org/wiki/Q186588","display_name":"Time series","level":2,"score":0.4485248625278473},{"id":"https://openalex.org/C143724316","wikidata":"https://www.wikidata.org/wiki/Q312468","display_name":"Series (stratigraphy)","level":2,"score":0.4334322214126587},{"id":"https://openalex.org/C149782125","wikidata":"https://www.wikidata.org/wiki/Q160039","display_name":"Econometrics","level":1,"score":0.391275554895401},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.23077818751335144},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.17992493510246277},{"id":"https://openalex.org/C127313418","wikidata":"https://www.wikidata.org/wiki/Q1069","display_name":"Geology","level":0,"score":0.12549719214439392},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.12337276339530945},{"id":"https://openalex.org/C58640448","wikidata":"https://www.wikidata.org/wiki/Q42515","display_name":"Cartography","level":1,"score":0.0801105797290802},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3742728.3742732","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3742728.3742732","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":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":41,"referenced_works":["https://openalex.org/W1523565998","https://openalex.org/W1536719639","https://openalex.org/W1550529073","https://openalex.org/W1702728283","https://openalex.org/W2024463287","https://openalex.org/W2080234606","https://openalex.org/W2109885200","https://openalex.org/W2123845384","https://openalex.org/W2294510862","https://openalex.org/W2294581520","https://openalex.org/W2600547451","https://openalex.org/W2899061597","https://openalex.org/W2912416028","https://openalex.org/W2913556077","https://openalex.org/W2913821232","https://openalex.org/W2914997739","https://openalex.org/W2998368829","https://openalex.org/W3004286518","https://openalex.org/W3081937877","https://openalex.org/W3146100921","https://openalex.org/W3147694699","https://openalex.org/W4205097557","https://openalex.org/W4206351584","https://openalex.org/W4210896998","https://openalex.org/W4214502646","https://openalex.org/W4231524450","https://openalex.org/W4238172360","https://openalex.org/W4239110337","https://openalex.org/W4252932445","https://openalex.org/W4253579101","https://openalex.org/W4285451014","https://openalex.org/W4286447321","https://openalex.org/W4301073899","https://openalex.org/W4301404790","https://openalex.org/W4301647871","https://openalex.org/W4302937682","https://openalex.org/W4317928033","https://openalex.org/W4386768924","https://openalex.org/W4399208467","https://openalex.org/W4401856724","https://openalex.org/W6945316566"],"related_works":["https://openalex.org/W4391375266","https://openalex.org/W2899084033","https://openalex.org/W2748952813","https://openalex.org/W2390279801","https://openalex.org/W4391913857","https://openalex.org/W2358668433","https://openalex.org/W2119012848","https://openalex.org/W2622688551","https://openalex.org/W1550175370","https://openalex.org/W1990205660"],"abstract_inverted_index":{"Timeseries":[0],"monitoring":[1,29,85],"systems":[2,19],"such":[3],"as":[4,81,107],"Prometheus":[5,116,142,160],"play":[6],"a":[7,108,135],"crucial":[8],"role":[9],"in":[10,71,138],"gaining":[11],"observability":[12],"of":[13,48,121,150,156],"the":[14,42],"underlying":[15],"system":[16,25],"infrastructure.":[17],"These":[18],"collect":[20],"timeseries":[21],"metrics":[22],"from":[23],"various":[24],"components":[26],"and":[27,45,65,74,92,101,117,143,161],"perform":[28],"queries":[30,50],"over":[31,124,141],"periodic":[32],"window-based":[33,98],"aggregations":[34],"(i.e.,":[35],"rule":[36,49,72],"queries).":[37],"However,":[38],"despite":[39],"wide":[40],"adoption,":[41],"operational":[43,90,147],"costs":[44,91,149],"query":[46,66,79,93,99,139,151],"latency":[47,140],"remain":[51],"high.":[52],"In":[53],"this":[54],"paper,":[55],"we":[56],"identify":[57],"major":[58],"bottlenecks":[59],"associated":[60],"with":[61,169],"repeated":[62],"data":[63],"scans":[64],"computations":[67],"concerning":[68],"window":[69],"overlaps":[70],"queries,":[73],"present":[75],"PromSketch,":[76],"an":[77],"approximation-first":[78],"framework":[80],"intermediate":[82],"caches":[83],"for":[84],"systems.":[86],"It":[87],"enables":[88],"low":[89],"latency,":[94],"by":[95,153,162],"combining":[96],"approximate":[97],"frameworks":[100],"sketch-based":[102],"precomputation.":[103],"PromSketch":[104,131],"is":[105],"implemented":[106],"standalone":[109],"module":[110],"that":[111,130],"can":[112],"be":[113],"integrated":[114],"into":[115],"VictoriaMetrics,":[118,144],"covering":[119],"70%":[120],"Prometheus'":[122],"aggregation":[123],"time":[125],"queries.":[126],"Our":[127],"evaluation":[128],"shows":[129],"achieves":[132],"up":[133],"to":[134,159,167],"two-order-of-magnitude":[136],"reduction":[137],"while":[145],"lowering":[146],"dollar":[148],"processing":[152],"three":[154],"orders":[155],"magnitude":[157],"compared":[158,166],"at":[163,170],"least":[164],"4\u00d7":[165],"VictoriaMetrics":[168],"most":[171],"5%":[172],"average":[173],"errors":[174],"across":[175],"statistics.":[176]},"counts_by_year":[],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}