Speeding Up Queries in Column Stores

A Case for Compression
  • Christian Lemke
  • Kai-Uwe Sattler
  • Franz Faerber
  • Alexander Zeier
Conference paper

DOI: 10.1007/978-3-642-15105-7_10

Part of the Lecture Notes in Computer Science book series (LNCS, volume 6263)
Cite this paper as:
Lemke C., Sattler KU., Faerber F., Zeier A. (2010) Speeding Up Queries in Column Stores. In: Bach Pedersen T., Mohania M.K., Tjoa A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2010. Lecture Notes in Computer Science, vol 6263. Springer, Berlin, Heidelberg

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