Domain Query Optimization: Adapting the General-Purpose Database System Hyper for Tableau Workloads
| dc.contributor.author | Vogelsgesang, Adrian | |
| dc.contributor.author | Muehlbauer, Tobias | |
| dc.contributor.author | Leis, Viktor | |
| dc.contributor.author | Neumann, Thomas | |
| dc.contributor.author | Kemper, Alfons | |
| dc.contributor.editor | Grust, Torsten | |
| dc.contributor.editor | Naumann, Felix | |
| dc.contributor.editor | Böhm, Alexander | |
| dc.contributor.editor | Lehner, Wolfgang | |
| dc.contributor.editor | Härder, Theo | |
| dc.contributor.editor | Rahm, Erhard | |
| dc.contributor.editor | Heuer, Andreas | |
| dc.contributor.editor | Klettke, Meike | |
| dc.contributor.editor | Meyer, Holger | |
| dc.date.accessioned | 2019-04-11T07:21:21Z | |
| dc.date.available | 2019-04-11T07:21:21Z | |
| dc.date.issued | 2019 | |
| dc.description.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. | en |
| dc.identifier.doi | 10.18420/btw2019-19 | |
| dc.identifier.isbn | 978-3-88579-683-1 | |
| dc.identifier.pissn | 1617-5468 | |
| dc.identifier.uri | https://dl.gi.de/handle/20.500.12116/21703 | |
| dc.language.iso | en | |
| dc.publisher | Gesellschaft für Informatik, Bonn | |
| dc.relation.ispartof | BTW 2019 | |
| dc.relation.ispartofseries | Lecture Notes in Informatics (LNI) – Proceedings, Volume P-289 | |
| dc.title | Domain Query Optimization: Adapting the General-Purpose Database System Hyper for Tableau Workloads | en |
| gi.citation.endPage | 333 | |
| gi.citation.startPage | 313 | |
| gi.conference.date | 4.-8. März 2019 | |
| gi.conference.location | Rostock | |
| gi.conference.sessiontitle | Industriebeiträge |
Dateien
Originalbündel
1 - 1 von 1