TU Darmstadt / ULB / TUbiblio

Sharing Opportunities for OLTP Workloads in Different Isolation Levels

Rehrmann, Robin and Binnig, Carsten and Böhm, Alexander and Kim, Kihong and Lehner, Wolfgang (2020):
Sharing Opportunities for OLTP Workloads in Different Isolation Levels.
In: Proceedings of the VLDB Endowment, 13 (10), pp. 1696-1708. VLDB Endowment, ISSN 21508097,
DOI: 10.14778/3401960.3401967,
[Article]

Abstract

OLTP applications are usually executed by a high number of clients in parallel and are typically faced with high throughput demand as well as a constraint latency requirement for individual statements. Interestingly, OLTP workloads are often read-heavy and comprise similar query patterns, which provides a potential to share work of statements belonging to different transactions. Consequently, OLAP techniques for sharing work have started to be applied also to OLTP workloads, lately.In this paper, we present an approach for merging read statements within interactively submitted multi-statement transactions consisting of reads and writes. We first define a formal framework for merging transactions running under a given isolation level and provide insights into a prototypical implementation of merging within a commercial database system. In our experimental evaluation, we show that, depending on the isolation level, the load in the system and the read-share of the workload, an improvement of the transaction throughput by up to a factor of 2.5X is possible without compromising the transactional semantics.

Item Type: Article
Erschienen: 2020
Creators: Rehrmann, Robin and Binnig, Carsten and Böhm, Alexander and Kim, Kihong and Lehner, Wolfgang
Title: Sharing Opportunities for OLTP Workloads in Different Isolation Levels
Language: English
Abstract:

OLTP applications are usually executed by a high number of clients in parallel and are typically faced with high throughput demand as well as a constraint latency requirement for individual statements. Interestingly, OLTP workloads are often read-heavy and comprise similar query patterns, which provides a potential to share work of statements belonging to different transactions. Consequently, OLAP techniques for sharing work have started to be applied also to OLTP workloads, lately.In this paper, we present an approach for merging read statements within interactively submitted multi-statement transactions consisting of reads and writes. We first define a formal framework for merging transactions running under a given isolation level and provide insights into a prototypical implementation of merging within a commercial database system. In our experimental evaluation, we show that, depending on the isolation level, the load in the system and the read-share of the workload, an improvement of the transaction throughput by up to a factor of 2.5X is possible without compromising the transactional semantics.

Journal or Publication Title: Proceedings of the VLDB Endowment
Journal volume: 13
Number: 10
Publisher: VLDB Endowment
Uncontrolled Keywords: dm
Divisions: 20 Department of Computer Science
20 Department of Computer Science > Data Management
Date Deposited: 14 Dec 2020 09:34
DOI: 10.14778/3401960.3401967
Corresponding Links:
Export:
Suche nach Titel in: TUfind oder in Google
Send an inquiry Send an inquiry

Options (only for editors)
Show editorial Details Show editorial Details