{"id":"https://openalex.org/W2520738984","doi":"https://doi.org/10.1145/2938503.2938526","title":"Efficient Approximate OLAP Querying Over Time Series","display_name":"Efficient Approximate OLAP Querying Over Time Series","publication_year":2016,"publication_date":"2016-01-01","ids":{"openalex":"https://openalex.org/W2520738984","doi":"https://doi.org/10.1145/2938503.2938526","mag":"2520738984"},"language":"en","primary_location":{"id":"doi:10.1145/2938503.2938526","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2938503.2938526","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 20th International Database Engineering & Applications Symposium on - IDEAS '16","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://tud.qucosa.de/id/qucosa%3A79865","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5019110545","display_name":"Kasun S. Perera","orcid":null},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"TU Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":true,"raw_author_name":"Kasun S. Perera","raw_affiliation_strings":["Database Technology Group, Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Database Technology Group, Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005556093","display_name":"Martin Hahmann","orcid":null},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"TU Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Martin Hahmann","raw_affiliation_strings":["Database Technology Group, Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Database Technology Group, Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063512642","display_name":"Wolfgang Lehner","orcid":"https://orcid.org/0000-0001-8107-2775"},"institutions":[{"id":"https://openalex.org/I78650965","display_name":"TU Dresden","ror":"https://ror.org/042aqky30","country_code":"DE","type":"education","lineage":["https://openalex.org/I78650965"]}],"countries":["DE"],"is_corresponding":false,"raw_author_name":"Wolfgang Lehner","raw_affiliation_strings":["Database Technology Group, Technische Universit\u00e4t Dresden, Dresden, Germany"],"affiliations":[{"raw_affiliation_string":"Database Technology Group, Technische Universit\u00e4t Dresden, Dresden, Germany","institution_ids":["https://openalex.org/I78650965"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5061064237","display_name":"Torben Bach Pedersen","orcid":"https://orcid.org/0000-0002-1615-777X"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Torben Bach Pedersen","raw_affiliation_strings":["Department of Computer Science, Aalborg University, Aalborg, Denmark"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Aalborg University, Aalborg, Denmark","institution_ids":["https://openalex.org/I891191580"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5010748912","display_name":"Christian Thomsen","orcid":"https://orcid.org/0000-0002-0862-0509"},"institutions":[{"id":"https://openalex.org/I891191580","display_name":"Aalborg University","ror":"https://ror.org/04m5j1k67","country_code":"DK","type":"education","lineage":["https://openalex.org/I891191580"]}],"countries":["DK"],"is_corresponding":false,"raw_author_name":"Christian Thomsen","raw_affiliation_strings":["Department of Computer Science, Aalborg University, Aalborg, Denmark"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, Aalborg University, Aalborg, Denmark","institution_ids":["https://openalex.org/I891191580"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5019110545"],"corresponding_institution_ids":["https://openalex.org/I78650965"],"apc_list":null,"apc_paid":null,"fwci":1.483,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.85134395,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"205","last_page":"211"},"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.9991000294685364,"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.9991000294685364,"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.9972000122070312,"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/T12205","display_name":"Time Series Analysis and Forecasting","score":0.9962000250816345,"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/online-analytical-processing","display_name":"Online analytical processing","score":0.9328161478042603},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8679167032241821},{"id":"https://openalex.org/keywords/bottleneck","display_name":"Bottleneck","score":0.7050610780715942},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.582001805305481},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5723171234130859},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.48201075196266174},{"id":"https://openalex.org/keywords/data-redundancy","display_name":"Data redundancy","score":0.47538673877716064},{"id":"https://openalex.org/keywords/time-series","display_name":"Time series","score":0.45460245013237},{"id":"https://openalex.org/keywords/volume","display_name":"Volume (thermodynamics)","score":0.44039005041122437},{"id":"https://openalex.org/keywords/big-data","display_name":"Big data","score":0.43810662627220154},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.417632132768631},{"id":"https://openalex.org/keywords/aggregate","display_name":"Aggregate (composite)","score":0.417501300573349},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4154312014579773},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.31579965353012085},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.29490023851394653},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1488361954689026},{"id":"https://openalex.org/keywords/machine-learning","display_name":"Machine learning","score":0.13020741939544678}],"concepts":[{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.9328161478042603},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8679167032241821},{"id":"https://openalex.org/C2780513914","wikidata":"https://www.wikidata.org/wiki/Q18210350","display_name":"Bottleneck","level":2,"score":0.7050610780715942},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.582001805305481},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5723171234130859},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.48201075196266174},{"id":"https://openalex.org/C7545210","wikidata":"https://www.wikidata.org/wiki/Q838123","display_name":"Data redundancy","level":2,"score":0.47538673877716064},{"id":"https://openalex.org/C151406439","wikidata":"https://www.wikidata.org/wiki/Q186588","display_name":"Time series","level":2,"score":0.45460245013237},{"id":"https://openalex.org/C20556612","wikidata":"https://www.wikidata.org/wiki/Q4469374","display_name":"Volume (thermodynamics)","level":2,"score":0.44039005041122437},{"id":"https://openalex.org/C75684735","wikidata":"https://www.wikidata.org/wiki/Q858810","display_name":"Big data","level":2,"score":0.43810662627220154},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.417632132768631},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.417501300573349},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4154312014579773},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.31579965353012085},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.29490023851394653},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1488361954689026},{"id":"https://openalex.org/C119857082","wikidata":"https://www.wikidata.org/wiki/Q2539","display_name":"Machine learning","level":1,"score":0.13020741939544678},{"id":"https://openalex.org/C62520636","wikidata":"https://www.wikidata.org/wiki/Q944","display_name":"Quantum mechanics","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/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"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/C121332964","wikidata":"https://www.wikidata.org/wiki/Q413","display_name":"Physics","level":0,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1145/2938503.2938526","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2938503.2938526","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 20th International Database Engineering & Applications Symposium on - IDEAS '16","raw_type":"proceedings-article"},{"id":"pmh:oai:pure.atira.dk:publications/05c49981-cf5f-4147-a7c2-6e47e7cc1a43","is_oa":false,"landing_page_url":"https://vbn.aau.dk/da/publications/05c49981-cf5f-4147-a7c2-6e47e7cc1a43","pdf_url":null,"source":{"id":"https://openalex.org/S4306401731","display_name":"VBN Forskningsportal (Aalborg Universitet)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I891191580","host_organization_name":"Aalborg University","host_organization_lineage":["https://openalex.org/I891191580"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Perera , K B D K S , Hahmann , M , Lehner , W , Pedersen , T B & Thomsen , C 2016 , Efficient Approximate OLAP Querying Over Time Series . in Proceedings of the 20th International Database Engineering & Applications Symposium . Association for Computing Machinery , pp. 205-211 , International Database Engineering & Applications Symposium , Montreal , Canada , 11/07/2016 . https://doi.org/10.1145/2938503.2938526","raw_type":"contributionToPeriodical"},{"id":"pmh:oai:qucosa:de:qucosa:79865","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A79865","pdf_url":null,"source":{"id":"https://openalex.org/S4377196312","display_name":"Qucosa (Saxon State and University Library Dresden)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I3132420320","host_organization_name":"SLUB Dresden","host_organization_lineage":["https://openalex.org/I3132420320"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:Text"}],"best_oa_location":{"id":"pmh:oai:qucosa:de:qucosa:79865","is_oa":true,"landing_page_url":"https://tud.qucosa.de/id/qucosa%3A79865","pdf_url":null,"source":{"id":"https://openalex.org/S4377196312","display_name":"Qucosa (Saxon State and University Library Dresden)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I3132420320","host_organization_name":"SLUB Dresden","host_organization_lineage":["https://openalex.org/I3132420320"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"doc-type:Text"},"sustainable_development_goals":[{"id":"https://metadata.un.org/sdg/16","score":0.6399999856948853,"display_name":"Peace, Justice and strong institutions"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W82830760","https://openalex.org/W1496130826","https://openalex.org/W1623444038","https://openalex.org/W1989163741","https://openalex.org/W2037701287","https://openalex.org/W2071989194","https://openalex.org/W2072764742","https://openalex.org/W2114543211","https://openalex.org/W2139276812","https://openalex.org/W2143401113","https://openalex.org/W2151443932","https://openalex.org/W2152029707","https://openalex.org/W2407353011","https://openalex.org/W4242587584","https://openalex.org/W4285719527","https://openalex.org/W6713934345"],"related_works":["https://openalex.org/W1988774479","https://openalex.org/W2123931473","https://openalex.org/W1799555191","https://openalex.org/W3012397820","https://openalex.org/W2382658894","https://openalex.org/W2791024100","https://openalex.org/W4312096174","https://openalex.org/W195952546","https://openalex.org/W1551562200","https://openalex.org/W2248831950"],"abstract_inverted_index":{"The":[0],"ongoing":[1],"trend":[2],"for":[3,155],"data":[4,20,98],"gathering":[5],"not":[6,68],"only":[7],"produces":[8],"larger":[9],"volumes":[10],"of":[11,18,23,38,97,159,196],"data,":[12,109],"but":[13],"also":[14,58],"increases":[15],"the":[16,36,72,95,183,206],"variety":[17],"recorded":[19,115],"types.":[21],"Out":[22],"these,":[24],"especially":[25],"time":[26,62,107,118,160],"series,":[27],"e.g.":[28],"various":[29],"sensor":[30],"readings,":[31],"have":[32],"attracted":[33],"attention":[34],"in":[35,51,205],"domains":[37],"business":[39],"intelligence":[40],"and":[41,166,178],"decision":[42],"making.":[43],"As":[44],"OLAP":[45,88,157],"queries":[46,89],"play":[47],"a":[48,69,78,102],"major":[49],"role":[50],"these":[52,139,185],"domains,":[53],"it":[54,75],"is":[55,67,101,123,167],"desirable":[56],"to":[57,82,198],"execute":[59],"them":[60],"on":[61,71],"series":[63,108,161],"data.":[64],"While":[65],"this":[66,121,149],"problem":[70,104],"conceptual":[73],"level,":[74],"can":[76,192],"become":[77],"bottleneck":[79],"with":[80],"regards":[81],"query":[83,135,207],"run-time.":[84],"In":[85,148,188],"general,":[86],"processing":[87],"gets":[90],"more":[91],"computationally":[92],"intensive":[93],"as":[94],"volume":[96],"grows.":[99],"This":[100],"particular":[103],"when":[105],"querying":[106,158],"which":[110],"generally":[111],"contains":[112],"multiple":[113],"measures":[114],"at":[116],"fine":[117],"granularities.":[119],"Usually,":[120],"issue":[122],"addressed":[124],"either":[125,142],"by":[126,131],"scaling":[127],"up":[128,197],"hardware":[129],"or":[130,144],"employing":[132],"workload":[133],"based":[134],"optimization":[136],"techniques.":[137],"However,":[138],"solutions":[140],"are":[141],"costly":[143],"require":[145],"continuous":[146],"maintenance.":[147],"paper":[150],"we":[151,172,191],"propose":[152,179],"an":[153],"approach":[154],"approximate":[156],"that":[162,181],"offers":[163],"constant":[164],"latency":[165],"maintenance-free.":[168],"To":[169],"achieve":[170,193],"this,":[171],"identify":[173],"similarities":[174,186],"between":[175],"aggregation":[176],"cuboids":[177],"algorithms":[180],"eliminate":[182],"redundancy":[184],"present.":[187],"doing":[189],"so,":[190],"compression":[194],"rates":[195],"80%":[199],"while":[200],"maintaining":[201],"low":[202],"average":[203],"errors":[204],"results.":[208]},"counts_by_year":[{"year":2021,"cited_by_count":1},{"year":2017,"cited_by_count":5}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}