Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. Conferences, Workshops, Symposiums, and Seminars
  4. Taster: Self-Tuning, Elastic and Online Approximate Query Processing
 
conference paper

Taster: Self-Tuning, Elastic and Online Approximate Query Processing

Olma, Matthaios
•
Papapetrou, Odysseas  
•
Appuswamy, Raja  
Show more
2019
2019 IEEE 35th International Conference On Data Engineering (Icde 2019)
35th IEEE International Conference on Data Engineering (ICDE 2019)

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).

  • Files
  • Details
  • Metrics
Type
conference paper
DOI
10.1109/ICDE.2019.00050
Web of Science ID

WOS:000477731600043

Author(s)
Olma, Matthaios
Papapetrou, Odysseas  
Appuswamy, Raja  
Ailamaki, Anastasia  
Date Issued

2019

Publisher

IEEE

Publisher place

New York

Published in
2019 IEEE 35th International Conference On Data Engineering (Icde 2019)
Total of pages

12

Start page

482

End page

493

Subjects

databases

•

approximation

•

online

•

adaptive

•

tuning

•

synopses

Editorial or Peer reviewed

REVIEWED

Written at

EPFL

EPFL units
DIAS  
Event nameEvent placeEvent date
35th IEEE International Conference on Data Engineering (ICDE 2019)

Macau SAR, Chine

April 8-11,2019

Available on Infoscience
May 30, 2019
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/156604
Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés