Leveraging Compression in the Tableau Data Engine

In Proceedings of the 2014 ACM SIGMOD international conference on Management of data (SIGMOD '14). ACM, New York, NY, USA, 563-573.

In this paper, we describe how the Tableau Data Engine (an internally developed column store) leverages a number of compression techniques to improve query performance. The approach is simpler than existing systems for operating on compressed data and more unified, removing the necessity for custom data access mechanisms. The approach also uses some novel metadata extraction techniques to improve the choices made by the system’s run-time optimiser.

Author(s)

Michael Grantham

Tableau Author(s)

Richard Wesley, Pawel Terlecki