TY - GEN
T1 - Benchmarking hybrid OLTP&OLAP database systems
AU - Funke, Florian
AU - Kemper, Alfons
AU - Neumann, Thomas
N1 - Publisher Copyright:
© 2011 Gesellschaft fur Informatik (GI). All rights reserved.
PY - 2011
Y1 - 2011
N2 - Recently, the case has been made for operational or real-time Business Intelligence (BI). As the traditional separation into OLTP database and OLAP data warehouse obviously incurs severe latency disadvantages for operational BI, hybrid OLTP&OLAP database systems are being developed. The advent of the first generation of such hybrid OLTP&OLAP database systems requires means to characterize their performance. While there are standardized and widely used benchmarks addressing either OLTP or OLAP workloads, the lack of a hybrid benchmark led us to the definition of a new mixed workload benchmark, called TPC-CH. This benchmark bridges the gap between the existing single-workload suits: TPC-C for OLTP and TPC-H for OLAP. The newly proposed TPC-CH benchmark executes a mixed workload: A transactional workload based on the order entry processing of TPC-C and a corresponding TPC-H-equivalent OLAP query suite on this sales data base. As it is derived from these two most widely used TPC benchmarks our new TPC-CH benchmark produces results that are highly comparable to both, hybrid systems and classic single-workload systems. Thus, we are able to compare the performance of our own (and other) hybrid database system running both OLTP and OLAP workloads in parallel with the OLTP performance of dedicated transactional systems (e.g., VoltDB) and the OLAP performance of specialized OLAP databases (e.g., column stores such as MonetDB).
AB - Recently, the case has been made for operational or real-time Business Intelligence (BI). As the traditional separation into OLTP database and OLAP data warehouse obviously incurs severe latency disadvantages for operational BI, hybrid OLTP&OLAP database systems are being developed. The advent of the first generation of such hybrid OLTP&OLAP database systems requires means to characterize their performance. While there are standardized and widely used benchmarks addressing either OLTP or OLAP workloads, the lack of a hybrid benchmark led us to the definition of a new mixed workload benchmark, called TPC-CH. This benchmark bridges the gap between the existing single-workload suits: TPC-C for OLTP and TPC-H for OLAP. The newly proposed TPC-CH benchmark executes a mixed workload: A transactional workload based on the order entry processing of TPC-C and a corresponding TPC-H-equivalent OLAP query suite on this sales data base. As it is derived from these two most widely used TPC benchmarks our new TPC-CH benchmark produces results that are highly comparable to both, hybrid systems and classic single-workload systems. Thus, we are able to compare the performance of our own (and other) hybrid database system running both OLTP and OLAP workloads in parallel with the OLTP performance of dedicated transactional systems (e.g., VoltDB) and the OLAP performance of specialized OLAP databases (e.g., column stores such as MonetDB).
UR - http://www.scopus.com/inward/record.url?scp=85072600862&partnerID=8YFLogxK
M3 - Conference contribution
AN - SCOPUS:85072600862
T3 - Lecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)
SP - 390
EP - 409
BT - Datenbanksysteme fur Business, Technologie und Web, BTW 2011 - 14. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme", DBIS 2011 - Proceedings
A2 - Harder, Theo
A2 - Lehner, Wolfgang
A2 - Mitschang, Bernhard
A2 - Schoning, Harald
A2 - Schwarz, Holger
PB - Gesellschaft fur Informatik (GI)
T2 - 2011 Datenbanksysteme fur Business, Technologie und Web, BTW 2011 - 14. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme", DBIS 2011 - Database Systems for Business, Technology and Web, BTW 2011 - 14th Conference of the GI Department "Databases and Information Systems", DBIS 2011
Y2 - 2 March 2011 through 4 March 2011
ER -