Benchmarking hybrid OLTP&OLAP database systems

Research output: Chapter in Book/Report/Conference proceedingConference contributionpeer-review

10 Scopus citations

Abstract

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).

Original languageEnglish
Title of host publicationDatenbanksysteme fur Business, Technologie und Web, BTW 2011 - 14. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme", DBIS 2011 - Proceedings
EditorsTheo Harder, Wolfgang Lehner, Bernhard Mitschang, Harald Schoning, Holger Schwarz
PublisherGesellschaft fur Informatik (GI)
Pages390-409
Number of pages20
ISBN (Electronic)9783885792741
StatePublished - 2011
Event2011 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 - Kaiserslautern, Germany
Duration: 2 Mar 20114 Mar 2011

Publication series

NameLecture Notes in Informatics (LNI), Proceedings - Series of the Gesellschaft fur Informatik (GI)
Volume180
ISSN (Print)1617-5468

Conference

Conference2011 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
Country/TerritoryGermany
CityKaiserslautern
Period2/03/114/03/11

Fingerprint

Dive into the research topics of 'Benchmarking hybrid OLTP&OLAP database systems'. Together they form a unique fingerprint.

Cite this