Taster: self-tuning, elastic and online approximate query processing

Matthaios Olma, Odysseas Papapetrou, Raja Appuswamy, Anastasia Ailamaki

Research output: Chapter in Book/Report/Conference proceedingConference contributionAcademicpeer-review

1 Citation (Scopus)
2 Downloads (Pure)

Abstract

Current Approximate Query Processing (AQP) engines are far from silver-bullet solutions, as they adopt several static design decisions that target specific workloads and deployment scenarios. Offline AQP engines target deployments with large storage budget, and offer substantial performance improvement for predictable workloads, but fail when new query types appear, i.e., due to shifting user interests. To the other extreme, online AQP engines assume that query workloads are unpredictable, and therefore build all samples at query time, without reusing samples (or parts of them) across queries. Clearly, both extremes miss out on different opportunities for optimizing performance and cost. In this paper, we present Taster, a self-tuning, elastic, online AQP engine that synergistically combines the benefits of online and offline AQP. Taster performs online approximation by injecting synopses (samples and sketches) into the query plan, while at the same time it strategically materializes and reuses synopses across queries, and continuously adapts them to changes in the workload and to the available storage resources. Our experimental evaluation shows that Taster adapts to shifting workload and to varying storage budgets, and always matches or significantly outperforms the state-of-the-art performing AQP approaches (online or offline).

Original languageEnglish
Title of host publicationProceedings - 2019 IEEE 35th International Conference on Data Engineering, ICDE 2019
Place of PublicationPiscataway
PublisherIEEE Computer Society
Pages482-493
Number of pages12
ISBN (Electronic)9781538674741
DOIs
Publication statusPublished - 1 Apr 2019
Event35th IEEE International Conference on Data Engineering, ICDE 2019 - Macau, China
Duration: 8 Apr 201911 Apr 2019

Conference

Conference35th IEEE International Conference on Data Engineering, ICDE 2019
CountryChina
CityMacau
Period8/04/1911/04/19

Keywords

  • Adaptive
  • Approximation
  • Online
  • Tuning
  • adaptive
  • approximation
  • tuning
  • online

Fingerprint Dive into the research topics of 'Taster: self-tuning, elastic and online approximate query processing'. Together they form a unique fingerprint.

  • Cite this

    Olma, M., Papapetrou, O., Appuswamy, R., & Ailamaki, A. (2019). Taster: self-tuning, elastic and online approximate query processing. In Proceedings - 2019 IEEE 35th International Conference on Data Engineering, ICDE 2019 (pp. 482-493). [8731505] IEEE Computer Society. https://doi.org/10.1109/ICDE.2019.00050