Sharing opportunities for OLTP workloads in different isolation levels

Research output: Contribution to journalResearch articleContributedpeer-review

Contributors

  • Robin Rehrmann - , Chair of Databases (Author)
  • Carsten Binnig - , Technische Universität Darmstadt (Author)
  • Alexander Böhm - , SAP Research (Author)
  • Kihong Kim - , SAP Labs Korea (Author)
  • Wolfgang Lehner - , Chair of Databases (Author)

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 de-fine 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.

Details

Original languageEnglish
Article number10
Pages (from-to)1696-1708
Number of pages13
JournalProceedings of the VLDB Endowment
Volume13
Issue number10
Publication statusPublished - 1 Jun 2020
Peer-reviewedYes

External IDs

Scopus 85091179939
ORCID /0000-0001-8107-2775/work/142253448