Speeding Up Queries in Column Stores

A Case for Compression
  • Christian Lemke
  • Kai-Uwe Sattler
  • Franz Faerber
  • Alexander Zeier
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6263)

Abstract

BI accelerator solutions like the SAP NetWeaver database engine TREX achieve high performance when processing complex analytic queries in large data warehouses. They do so with a combination of column-oriented data organization, memory-based processing, and a scalable multiserver architecture. The use of data compression techniques further reduces both memory consumption and processing time. In this paper we study query operators like scan and aggregation on compressed data structures implemented in TREX.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 2010

Authors and Affiliations

  • Christian Lemke
    • 1
    • 2
  • Kai-Uwe Sattler
    • 2
  • Franz Faerber
    • 1
  • Alexander Zeier
    • 3
  1. 1.SAP AGWalldorfGermany
  2. 2.Ilmenau Univ. of TechnologyIlmenauGermany
  3. 3.Hasso-Plattner-InstitutePotsdamGermany

Personalised recommendations