ScyPer: elastic OLAP throughput on transactional data

  • Authors:
  • Tobias Mühlbauer;Wolf Rödiger;Angelika Reiser;Alfons Kemper;Thomas Neumann

  • Affiliations:
  • Technische Universität München, Munich, Germany;Technische Universität München, Munich, Germany;Technische Universität München, Munich, Germany;Technische Universität München, Munich, Germany;Technische Universität München, Munich, Germany

  • Venue:
  • Proceedings of the Second Workshop on Data Analytics in the Cloud
  • Year:
  • 2013

Quantified Score

Hi-index 0.00

Visualization

Abstract

Ever increasing main memory sizes and the advent of multi-core parallel processing have fostered the development of in-core databases. Even the transactional data of large enterprises can be retained in-memory on a single server. Modern in-core databases like our HyPer system achieve best-of-breed OLTP throughput that is sufficient for the lion's share of applications. Remaining server resources are used for OLAP query processing on the latest transactional data, i.e., real-time business analytics. While OLTP performance of a single server is sufficient, an increasing demand for OLAP throughput can only be satisfied economically by a scale-out. In this work we present ScyPer, a Scale-out of our HyPer main memory database system that horizontally scales out on shared-nothing hardware. With ScyPer we aim at (i) sustaining the superior OLTP throughput of a single HyPer server, and (ii) providing elastic OLAP throughput by provisioning additional servers on-demand, e.g., in the Cloud.