The mixed workload CH-benCHmark

  • Authors:
  • Richard Cole;Florian Funke;Leo Giakoumakis;Wey Guy;Alfons Kemper;Stefan Krompass;Harumi Kuno;Raghunath Nambiar;Thomas Neumann;Meikel Poess;Kai-Uwe Sattler;Michael Seibold;Eric Simon;Florian Waas

  • Affiliations:
  • ParAccel;TU München;Microsoft;Microsoft;TU München;TU München;HP Labs;Cisco;TU München;Oracle;TU Ilmenau;TU München;SAP;Greenplum

  • Venue:
  • Proceedings of the Fourth International Workshop on Testing Database Systems
  • Year:
  • 2011

Quantified Score

Hi-index 0.00

Visualization

Abstract

While standardized and widely used benchmarks address either operational or real-time Business Intelligence (BI) workloads, the lack of a hybrid benchmark led us to the definition of a new, complex, mixed workload benchmark, called mixed workload CH-benCHmark. This benchmark bridges the gap between the established single-workload suites of TPC-C for OLTP and TPC-H for OLAP, and executes a complex mixed workload: a transactional workload based on the order entry processing of TPC-C and a corresponding TPC-H-equivalent OLAP query suite run in parallel on the same tables in a single database system. As it is derived from these two most widely used TPC benchmarks, the CH-benCHmark produces results highly relevant to both hybrid and classic single-workload systems.