|
Enterprise application-database co-innovation for hybrid transactional/analytical processing: a virtual data model and its query optimization needs
Kim, Kihong
;
Kim, Hyunwook
;
Lee, Jinsu
;
Lee, Taehyung
;
Böhm, Alexander
;
May, Norman
;
Moerkotte, Guido
;
Ritter, Daniel
;
Dentzer, Ralf
;
Gerwens, Heiko
;
Kofman, Irena
;
Andrei, Mihnea
|
DOI:
|
https://doi.org/10.1145/3722212.3724436
|
|
URL:
|
https://dl.acm.org/doi/10.1145/3722212.3724436
|
|
URN:
|
urn:nbn:de:bsz:180-madoc-716404
|
|
Document Type:
|
Conference or workshop publication
|
|
Year of publication:
|
2025
|
|
Book title:
|
SIGMOD/PODS '25 : Companion of the 2025 International Conference on Management of Data
|
|
Page range:
|
485-498
|
|
Conference title:
|
2025 ACM SIGMOD/PODS International Conference on Management of Data
|
|
Location of the conference venue:
|
Berlin, Germany
|
|
Date of the conference:
|
22.-27.06.2025
|
|
Publisher:
|
Markl, Volker
;
Abouzied, Azza
;
Hellerstein, Joseph M.
|
|
Place of publication:
|
New York, NY
|
|
Publishing house:
|
Association for Computing Machinery
|
|
ISBN:
|
979-8-4007-1564-8
|
|
Related URLs:
|
|
|
Publication language:
|
English
|
|
Institution:
|
School of Business Informatics and Mathematics > Practical Computer Science III (Moerkotte 1996-)
|
|
Pre-existing license:
|
 Creative Commons Attribution 4.0 International (CC BY 4.0)
|
|
Subject:
|
004 Computer science, internet
|
|
Keywords (English):
|
HTAP , query optimization , application-database co-innovation , SAP HANA , SAP S/4HANA
|
|
Abstract:
|
The advent of hybrid transactional/analytical processing (HTAP) systems has reshaped enterprise data management, breaking the wall between transaction processing and analytics. This paper explores the co-innovation between enterprise applications and databases to advance HTAP architecture and drive its scalable adoption, as exemplified by SAP S/4HANA powered by SAP HANA. At the core of this innovation lies the Virtual Data Model (VDM), which simplifies the formulation of analytical queries directly over transactional data, making HTAP databases more accessible to application developers.
This paper delves into the complexities of the VDM, highlighting key query optimization challenges such as expansive join views, augmentation joins, and augmentation self-joins. Our findings underscore the pivotal role of robust query optimizers in achieving efficient HTAP query execution. By providing actionable insights into the design and optimization of database systems, this paper may serve as motivation for further research into advancing HTAP database technology.
|
 | Dieser Eintrag ist Teil der Universitätsbibliographie. |
 | Das Dokument wird vom Publikationsserver der Universitätsbibliothek Mannheim bereitgestellt. |
 Search Authors in
BASE:
Kim, Kihong
;
Kim, Hyunwook
;
Lee, Jinsu
;
Lee, Taehyung
;
Böhm, Alexander
;
May, Norman
;
Moerkotte, Guido
;
Ritter, Daniel
;
Dentzer, Ralf
;
Gerwens, Heiko
;
Kofman, Irena
;
Andrei, Mihnea
Google Scholar:
Kim, Kihong
;
Kim, Hyunwook
;
Lee, Jinsu
;
Lee, Taehyung
;
Böhm, Alexander
;
May, Norman
;
Moerkotte, Guido
;
Ritter, Daniel
;
Dentzer, Ralf
;
Gerwens, Heiko
;
Kofman, Irena
;
Andrei, Mihnea
You have found an error? Please let us know about your desired correction here: E-Mail
Actions (login required)
 |
Show item |
|
