A Composite Benchmark for Online Transaction Processing and Operational Reporting

Up-to-date data is of immense importance for operational reporting. Global enterprises require such a high throughput during daily operations that reporting systems had to be separated from the transactional system to avoid inhibiting performance. These architectures, however, do not provide the required reporting flexibility as the data set is a pre-defined subset of the actual data and updated only at certain time intervals, e.g. nightly. The composite benchmark for online transaction processing (OLTP) and operational reporting, henceforth CBTR, provides means to evaluate the performance of enterprise systems for a mixed workload of OLTP and operational reporting queries. Such a system offers up-to-date information and the flexibility of the entire data set for reporting. CBTR provokes the conflicts that were the reason for separating the two workloads on different systems. In this paper we introduce the concepts of CBTR, which is based on the original data set and real workloads of an existing, globally operating enterprise.