Scaling Up Mixed Workloads: A Battle of Data Freshness, Flexibility, and Scheduling

  • Iraklis Psaroudakis
  • Florian Wolf
  • Norman May
  • Thomas Neumann
  • Alexander Böhm
  • Anastasia Ailamaki
  • Kai-Uwe Sattler
Conference paper

DOI: 10.1007/978-3-319-15350-6_7

Part of the Lecture Notes in Computer Science book series (LNCS, volume 8904)
Cite this paper as:
Psaroudakis I. et al. (2015) Scaling Up Mixed Workloads: A Battle of Data Freshness, Flexibility, and Scheduling. In: Nambiar R., Poess M. (eds) Performance Characterization and Benchmarking. Traditional to Big Data. TPCTC 2014. Lecture Notes in Computer Science, vol 8904. Springer, Cham

Abstract

The common “one size does not fit all” paradigm isolates transactional and analytical workloads into separate, specialized database systems. Operational data is periodically replicated to a data warehouse for analytics. Competitiveness of enterprises today, however, depends on real-time reporting on operational data, necessitating an integration of transactional and analytical processing in a single database system. The mixed workload should be able to query and modify common data in a shared schema. The database needs to provide performance guarantees for transactional workloads, and, at the same time, efficiently evaluate complex analytical queries. In this paper, we share our analysis of the performance of two main-memory databases that support mixed workloads, SAP HANA and HyPer, while evaluating the mixed workload CH-benCHmark. By examining their similarities and differences, we identify the factors that affect performance while scaling the number of concurrent transactional and analytical clients. The three main factors are (a) data freshness, i.e., how recent is the data processed by analytical queries, (b) flexibility, i.e., restricting transactional features in order to increase optimization choices and enhance performance, and (c) scheduling, i.e., how the mixed workload utilizes resources. Specifically for scheduling, we show that the absence of workload management under cases of high concurrency leads to analytical workloads overwhelming the system and severely hurting the performance of transactional workloads.

Keywords

OLAP OLTP CH-benCHmark SAP HANA HyPer Data freshness Flexibility Scheduling Workload management 

Copyright information

© Springer International Publishing Switzerland 2015

Authors and Affiliations

  • Iraklis Psaroudakis
    • 1
    • 3
  • Florian Wolf
    • 1
    • 4
  • Norman May
    • 1
  • Thomas Neumann
    • 2
  • Alexander Böhm
    • 1
  • Anastasia Ailamaki
    • 3
  • Kai-Uwe Sattler
    • 4
  1. 1.SAP SEWalldorfGermany
  2. 2.TU MunichMunichGermany
  3. 3.EPFLLausanneSwitzerland
  4. 4.TU IlmenauIlmenauGermany

Personalised recommendations