CH-benCHmark

Summary

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.

The Benchmark: Analytical Queries

Query 1

This query reports the total amount and quantity of all shipped orderlines given by a specific time period. Additionally it informs about the average amount and quantity plus the total count of all these orderlines ordered by the individual orderline number.

Query 10

Query for analyzing the expenses of all customers listing their living country, some detail of them and the amount of money which they have used to take their orders since a specific date. The whole list is sorted by the amount of the customers’ orders.

Query 13

The query lists the number of customers grouped and sorted by the size of orders they made. The result set of the relation between customers and the size of their orders is sorted by the size of orders and counts how many customers have dealt the same way.

Query 20

Suppliers in a particular nation having selected parts that may be candidates for a promotional offer if the quantity of these items is more than 50 percent of the total quantity which has been ordered since a certain date.

Query 22

This query lists how many customers within a specific range of country codes have not bought anything for the whole period of time and who have a greater than average balance on their account. The county code is represented by the first two characters of the phone number.