Affiliation:
1. SAP SE, Germany and TU Dresden, Germany
2. TU Darmstadt, Germany
3. SAP SE, Germany
4. SAP Labs Korea
5. TU Dresden, Germany
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.
Subject
General Earth and Planetary Sciences,Water Science and Technology,Geography, Planning and Development
Cited by
22 articles.
订阅此论文施引文献
订阅此论文施引文献，注册后可以免费订阅5篇论文的施引文献，订阅后可以查看论文全部施引文献
1. Exploiting Shared Sub-Expression and Materialized View Reuse for Multi-Query Optimization;Information Systems Frontiers;2024-06-25
2. SH2O: Efficient Data Access for Work-Sharing Databases;Proceedings of the ACM on Management of Data;2023-11-13
3. CredsCache: Making OverlayFS scalable for containerized services;Future Generation Computer Systems;2023-10
4. What Happens When Two Multi-Query Optimization Paradigms Combine?;Advances in Databases and Information Systems;2023
5. An Optimized Transaction Processing Scheme for Highly Contented E-commerce Workloads Optimized Scheme for Contended Workloads;2022 IEEE 24th Int Conf on High Performance Computing & Communications; 8th Int Conf on Data Science & Systems; 20th Int Conf on Smart City; 8th Int Conf on Dependability in Sensor, Cloud & Big Data Systems & Application (HPCC/DSS/SmartCity/DependSys);2022-12