SAP HANA – the evolution of an in-memory DBMS from pure OLAP processing towards mixed workloads

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

Contributors

  • Norman May - , SAP Research (Author)
  • Alexander Böhm - , SAP Research (Author)
  • Wolfgang Lehner - , Chair of Databases, TUD Dresden University of Technology (Author)

Abstract

The journey of SAP HANA started as an in-memory appliance for complex, analytical applications. The success of the system quickly motivated SAP to broaden the scope from the OLAP workloads the system was initially architected for to also handle transactional workloads, in particular to support its Business Suite flagship product. In this paper, we highlight some of the core design changes to evolve an in-memory column store system towards handling OLTP workloads. We also discuss the challenges of running mixed workloads with low-latency OLTP queries and complex analytical queries in the context of the same database management system and give an outlook on the future database interaction patterns of modern business applications we see emerging currently.

Details

Original languageEnglish
Title of host publicationDatenbanksysteme fur Business, Technologie und Web, BTW 2017 - 17. Fachtagung des GI-Fachbereichs "Datenbanken und Informationssysteme�, DBIS 2017, Proceedings
EditorsBernhard Mitschang, Daniela Nicklas, Frank Leymann, Harald Schoning, Melanie Herschel, Jens Teubner, Theo Harder
PublisherGesellschaft fur Informatik (GI)
Pages545-563
Number of pages19
ISBN (electronic)9783885796596
Publication statusPublished - 2017
Peer-reviewedYes

Publication series

SeriesGI-Edition : lecture notes in informatics. Proceedings
Volume265
ISSN1617-5468

Conference

TitleDBIS - Database Systems for Business, Technology and Web, BTW 2017, 17th Symposium of the GI Department "Databases and Information Systems"
Duration6 - 10 March 2017
CityStuttgart
CountryGermany

External IDs

ORCID /0000-0001-8107-2775/work/142253514

Keywords

ASJC Scopus subject areas