Workload merging potential in SAP Hybris

Research output: Contribution to book/conference proceedings/anthology/reportConference contributionContributedpeer-review

Contributors

  • Robin Rehrmann - , Chair of Databases (Author)
  • Martin Keppner - , Technical University of Munich (Author)
  • Wolfgang Lehner - , Chair of Databases (Author)
  • Carsten Binnig - , TUD Dresden University of Technology (Author)
  • Arne Schwarz - , SAP Research (Author)

Abstract

OLTP DBMSs in enterprise scenarios are often facing the challenge to deal with workload peaks resulting from events such as Cyber Monday or Black Friday. The traditional solution to prevent running out of resources and thus coping with such workload peaks is to use a significant over-provisioning of the underlying infrastructure. Another direction to cope with such peak scenarios is to apply resource sharing. In a recent work, we showed that merging read statements in OLTP scenarios offers the opportunity to maintain low latency for systems under heavy load without over-provisioning. In this paper, we analyze a real enterprise OLTP workload - - SAP Hybris - - with respect to statements types, complexity, and hot-spot statements to find potential candidates for workload sharing in OLTP. We additionally share work of the Hybris workload in our system OLTPShare and report on savings with respect to CPU consumption. Another interesting effect we show is that with OLTPShare, we can increase the SAP Hybris throughput by 20%.

Details

Original languageEnglish
Title of host publicationDBTest '20: Proceedings of the workshop on Testing Database Systems
PublisherAssociation for Computing Machinery, Inc
Number of pages6
ISBN (electronic)978-1-4503-8001-0
Publication statusPublished - 19 Jun 2020
Peer-reviewedYes

Publication series

SeriesMOD: International Conference on Management of Data (DBTest)

Conference

Title2020 Workshop on Testing Database Systems, DBTest 2020
Duration19 June 2020
CityPortland
CountryUnited States of America

External IDs

Scopus 85086079960
ORCID /0000-0001-8107-2775/work/142253455

Keywords