OLTPShare: The case for sharing in OLTP workloads

Publikation: Beitrag in FachzeitschriftKonferenzartikelBeigetragenBegutachtung

Beitragende

  • Robin Rehrmann - , Professur für Datenbanken, SAP Research (Autor:in)
  • Carsten Binnig - , Technische Universität Darmstadt (Autor:in)
  • Alexander Böhm - , SAP Research (Autor:in)
  • Kihong Kim - , SAP Labs Korea (Autor:in)
  • Wolfgang Lehner - , Professur für Datenbanken (Autor:in)
  • Amr Rizk - , Technische Universität Darmstadt (Autor:in)

Abstract

In the past, resource sharing has been extensively studied for OLAP workloads. Naturally, the question arises, why studies mainly focus on OLAP and not on OLTP workloads? At first sight, OLTP queries - due to their short runtime - may not have enough potential for the additional overhead. In addition, OLTP workloads do not only execute read operations but also updates. In this paper, we address query sharing for OLTP workloads. We first analyze the sharing potential in real-world OLTP workloads. Based on those findings, we then present an execution strategy, called OLTPShare that implements a novel batching scheme for OLTP workloads. We analyze the sharing benefits by integrating OLTPShare into a prototype version of the commercial database system SAP HANA. Our results show for different OLTP workloads that OLTPShare enables SAP HANA to provide a significant throughput increase in high-load scenarios compared to the conventional execution strategy without sharing.

Details

OriginalspracheEnglisch
Seiten (von - bis)1769-1780
Seitenumfang12
FachzeitschriftProceedings of the VLDB Endowment
Jahrgang11
Ausgabenummer12
PublikationsstatusVeröffentlicht - 2018
Peer-Review-StatusJa

Konferenz

Titel44th International Conference on Very Large Data Bases, VLDB 2018
Dauer27 - 31 August 2018
StadtRio de Janeiro
LandBrasilien

Externe IDs

Scopus 85058888857
ORCID /0000-0001-8107-2775/work/142253504

Schlagworte