TY  - JOUR
A1  - Bog, Anja
A1  - Plattner, Hasso
A1  - Zeier, Alexander
T1  - A mixed transaction processing and operational reporting benchmark
JF  - Information systems frontiers
N2  - The importance of reporting is ever increasing in today's fast-paced market environments and the availability of up-to-date information for reporting has become indispensable. Current reporting systems are separated from the online transaction processing systems (OLTP) with periodic updates pushed in. A pre-defined and aggregated subset of the OLTP data, however, does not provide the flexibility, detail, and timeliness needed for today's operational reporting. As technology advances, this separation has to be re-evaluated and means to study and evaluate new trends in data storage management have to be provided. This article proposes a benchmark for combined OLTP and operational reporting, providing means to evaluate the performance of enterprise data management systems for mixed workloads of OLTP and operational reporting queries. Such systems offer up-to-date information and the flexibility of the entire data set for reporting. We describe how the benchmark provokes the conflicts that are the reason for separating the two workloads on different systems. In this article, we introduce the concepts, logical data schema, transactions and queries of the benchmark, which are entirely based on the original data sets and real workloads of existing, globally operating enterprises.
KW  - Benchmarking
KW  - Mixed workload
KW  - OLTP
KW  - Operational reporting
Y1  - 2011
U6  - https://doi.org/10.1007/s10796-010-9283-8
SN  - 1387-3326
VL  - 13
IS  - 3
SP  - 321
EP  - 335
PB  - Springer
CY  - Dordrecht
ER  -