Brighthouse: an analytic data warehouse for ad-hoc queries

  • Authors:
  • Dominik Ślȩzak;Jakub Wróblewski;Victoria Eastwood;Piotr Synak

  • Affiliations:
  • Infobright Inc., Poland;Infobright Inc., Poland;Infobright Inc., Canada;Infobright Inc., Poland

  • Venue:
  • Proceedings of the VLDB Endowment
  • Year:
  • 2008

Quantified Score

Hi-index 0.00

Visualization

Abstract

Brighthouse is a column-oriented data warehouse with an automatically tuned, ultra small overhead metadata layer called Knowledge Grid, that is used as an alternative to classical indexes. The advantages of column-oriented data storage, as well as data compression have already been well-documented, especially in the context of analytic, decision support querying. This paper demonstrates additional benefits resulting from Knowledge Grid for compressed, column-oriented databases. In particular, we explain how it assists in query optimization and execution, by minimizing the need of data reads and data decompression.