TU Darmstadt / ULB / TUbiblio

OLTPShare: The Case for Sharing in OLTP Workloads

Rehrmann, Robin ; Binnig, Carsten ; Böhm, Alexander ; Kim, Kihong ; Lehner, Wolfgang ; Rizk, Amr (2018)
OLTPShare: The Case for Sharing in OLTP Workloads.
In: Proceedings of the VLDB Endowment, 11 (12)
doi: 10.14778/3229863.3229866
Artikel, Bibliographie

Kurzbeschreibung (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.

Typ des Eintrags: Artikel
Erschienen: 2018
Autor(en): Rehrmann, Robin ; Binnig, Carsten ; Böhm, Alexander ; Kim, Kihong ; Lehner, Wolfgang ; Rizk, Amr
Art des Eintrags: Bibliographie
Titel: OLTPShare: The Case for Sharing in OLTP Workloads
Sprache: Englisch
Publikationsjahr: 1 August 2018
Verlag: ACM
Titel der Zeitschrift, Zeitung oder Schriftenreihe: Proceedings of the VLDB Endowment
Jahrgang/Volume einer Zeitschrift: 11
(Heft-)Nummer: 12
DOI: 10.14778/3229863.3229866
Kurzbeschreibung (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.

Freie Schlagworte: Projekt X1
Zusätzliche Informationen:

Proceedings of the 44th International Conference on Very Large Data Bases, Rio de Janeiro, Brazil August 2018

Fachbereich(e)/-gebiet(e): 20 Fachbereich Informatik
20 Fachbereich Informatik > Data Management (2022 umbenannt in Data and AI Systems)
DFG-Sonderforschungsbereiche (inkl. Transregio)
DFG-Sonderforschungsbereiche (inkl. Transregio) > Sonderforschungsbereiche
DFG-Sonderforschungsbereiche (inkl. Transregio) > Sonderforschungsbereiche > SFB 1053: MAKI – Multi-Mechanismen-Adaption für das künftige Internet
DFG-Sonderforschungsbereiche (inkl. Transregio) > Sonderforschungsbereiche > SFB 1053: MAKI – Multi-Mechanismen-Adaption für das künftige Internet > B: Adaptionsmechanismen
DFG-Sonderforschungsbereiche (inkl. Transregio) > Sonderforschungsbereiche > SFB 1053: MAKI – Multi-Mechanismen-Adaption für das künftige Internet > B: Adaptionsmechanismen > Teilprojekt B4: Planung
DFG-Sonderforschungsbereiche (inkl. Transregio) > Sonderforschungsbereiche > SFB 1053: MAKI – Multi-Mechanismen-Adaption für das künftige Internet > D: Technologie
DFG-Sonderforschungsbereiche (inkl. Transregio) > Sonderforschungsbereiche > SFB 1053: MAKI – Multi-Mechanismen-Adaption für das künftige Internet > D: Technologie > Teilprojekt D2: Data-Center-Technologie
Hinterlegungsdatum: 07 Feb 2020 10:40
Letzte Änderung: 25 Apr 2023 13:59
PPN:
Export:
Suche nach Titel in: TUfind oder in Google
Frage zum Eintrag Frage zum Eintrag

Optionen (nur für Redakteure)
Redaktionelle Details anzeigen Redaktionelle Details anzeigen