Domain query optimization: Adapting the general-purpose database system hyper for tableau workloads

Vogelsgesang A, Muehlbauer T, Leis V, Neumann T, Kemper A (2019)


Publication Type: Conference contribution

Publication year: 2019

Publisher: Gesellschaft fur Informatik (GI)

Book Volume: P-289

Pages Range: 313-333

Conference Proceedings Title: Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)

Event location: Rostock DE

ISBN: 9783885796831

DOI: 10.18420/btw2019-19

Abstract

The Hyper database system was started as an academic project at Technical University Munich. In 2016, the commercial spin-off of the academic Hyper database system was acquired by Tableau, a leader in the analytics and business intelligence (BI) platforms market. As a human-in-the-loop BI platform, Tableau products machine-generate query workloads with characteristics that differ from human-written queries and queries represented in industry-standard database system benchmarks. In this work, we contribute optimizations we developed for one important class of queries typically generated by Tableau products: retrieving (aggregates of) the domain of a column. We devise methods for leveraging the compression of the database column in order to efficiently retrieve the duplicate-free value set, i.e., the domain. Our extensive performance evaluation of a synthetic benchmark and over 60 thousand real-world workbooks from Tableau Public shows that our optimization enables query latencies for domain queries that allow self-service ad-hoc data exploration.

Authors with CRIS profile

Involved external institutions

How to cite

APA:

Vogelsgesang, A., Muehlbauer, T., Leis, V., Neumann, T., & Kemper, A. (2019). Domain query optimization: Adapting the general-purpose database system hyper for tableau workloads. In Torsten Grust, Felix Naumann, Alexander Bohm, Wolfgang Lehner, Theo Harder, Erhard Rahm, Andreas Heuer, Meike Klettke, Holger Meyer (Eds.), Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI) (pp. 313-333). Rostock, DE: Gesellschaft fur Informatik (GI).

MLA:

Vogelsgesang, Adrian, et al. "Domain query optimization: Adapting the general-purpose database system hyper for tableau workloads." Proceedings of the Datenbanksysteme fur Business, Technologie und Web, BTW 2019 and 18. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme", DBIS 2019, Rostock Ed. Torsten Grust, Felix Naumann, Alexander Bohm, Wolfgang Lehner, Theo Harder, Erhard Rahm, Andreas Heuer, Meike Klettke, Holger Meyer, Gesellschaft fur Informatik (GI), 2019. 313-333.

BibTeX: Download