Benchmarking database design for mixed OLTP and OLAP workloads

  • Authors:
  • Anja Bog;Kai Sachs;Alexander Zeier

  • Affiliations:
  • Hasso Plattner Institute, Potsdam, Germany;SAP AG, Walldorf, Germany;Hasso Plattner Institute, Potsdam, Germany

  • Venue:
  • Proceedings of the 2nd ACM/SPEC International Conference on Performance engineering
  • Year:
  • 2011

Quantified Score

Hi-index 0.00

Visualization

Abstract

Current database benchmarks are either focusing on online transaction processing (OLTP) or on online analytical pro- cessing (OLAP) systems. This traditional separation has to be reevaluated to reflect current trends in the design of database systems. We see a need for a realistic benchmark workload taking both aspects into account. Therefore, we defined a mixed workload and illustrate ways to apply our workload to evaluate the influence of database design on system performance.