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

Matthaios Olma, Odysseas Papapetrou, Raja Appuswamy, Anastasia Ailamaki

Onderzoeksoutput: Hoofdstuk in Boek/Rapport/CongresprocedureConferentiebijdrageAcademicpeer review

2 Citaten (Scopus)
3 Downloads (Pure)

Samenvatting

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

Originele taal-2Engels
TitelProceedings - 2019 IEEE 35th International Conference on Data Engineering, ICDE 2019
Plaats van productiePiscataway
UitgeverijIEEE Computer Society
Pagina's482-493
Aantal pagina's12
ISBN van elektronische versie9781538674741
DOI's
StatusGepubliceerd - 1 apr 2019
Evenement35th IEEE International Conference on Data Engineering, ICDE 2019 - Macau, China
Duur: 8 apr 201911 apr 2019

Congres

Congres35th IEEE International Conference on Data Engineering, ICDE 2019
LandChina
StadMacau
Periode8/04/1911/04/19

Vingerafdruk Duik in de onderzoeksthema's van 'Taster: self-tuning, elastic and online approximate query processing'. Samen vormen ze een unieke vingerafdruk.

Citeer dit