research-article

SAP HANA database: data management for modern business applications

Authors:

Wolfgang LehnerAuthors Info & Claims

ACM SIGMOD Record, Volume 40, Issue 4

Pages 45 - 51

https://doi.org/10.1145/2094114.2094126

Published: 11 January 2012 Publication History

Get Access

Abstract

The SAP HANA database is positioned as the core of the SAP HANA Appliance to support complex business analytical processes in combination with transactionally consistent operational workloads. Within this paper, we outline the basic characteristics of the SAP HANA database, emphasizing the distinctive features that differentiate the SAP HANA database from other classical relational database management systems. On the technical side, the SAP HANA database consists of multiple data processing engines with a distributed query processing environment to provide the full spectrum of data processing -- from classical relational data supporting both row- and column-oriented physical representations in a hybrid engine, to graph and text processing for semi- and unstructured data management within the same system.

From a more application-oriented perspective, we outline the specific support provided by the SAP HANA database of multiple domain-specific languages with a built-in set of natively implemented business functions. SQL -- as the lingua franca for relational database systems -- can no longer be considered to meet all requirements of modern applications, which demand the tight interaction with the data management layer. Therefore, the SAP HANA database permits the exchange of application semantics with the underlying data management platform that can be exploited to increase query expressiveness and to reduce the number of individual application-to-database round trips.

References

[1]

P. Grosse, W. Lehner, T. Weichert, F. Färber, and W.-S. Li. Bridging two worlds with RICE. In VLDB Conference, 2011.

Google Scholar

[2]

B. Jaecksch, F. Färber, F. Rosenthal, and W. Lehner. Hybrid Data-Flow Graphs for Procedural Domain-Specific Query Languages. In SSDBM Conference, pages 577--578, 2011.

Digital Library

Google Scholar

[3]

B. Jaecksch, W. Lehner, and F. Färber. A plan for OLAP. In EDBT conference, pages 681--686, 2010.

Digital Library

Google Scholar

[4]

J. Krüger, M. Grund, C. Tinnefeld, H. Plattner, A. Zeier, and F. Faerber. Optimizing Write Performance for Read Optimized Databases. In DASFAA Conference, pages 291--305, 2010.

Digital Library

Google Scholar

[5]

H. Plattner and A. Zeier. In-Memory Data Management: An Inflection Point for Enterprise Applications. Springer, Berlin Heidelberg, 2011.

Digital Library

Google Scholar

[6]

J. Schaffner, B. Eckart, D. Jacobs, C. Schwarz, H. Plattner, and A. Zeier. Predicting In-Memory Database Performance for Automating Cluster Management Tasks. In ICDE Conference, pages 1264--1275, 2011.

Digital Library

Google Scholar

[7]

C. Weyerhäuser, T. Mindnich, F. Färber, and W. Lehner. Exploiting Graphic Card Processor Technology to Accelerate Data Mining Queries in SAP NetWeaver BIA. In ICDM Workshops, pages 506--515, 2008.

Digital Library

Google Scholar

Cited By

View all

Vogel LAnneser CGruber FNeumann TGiceva JKemper A(2025)Scaling Beyond DRAM Without Compromising PerformanceScalable Data Management for Future Hardware10.1007/978-3-031-74097-8_6(145-169)Online publication date: 24-Jan-2025
https://doi.org/10.1007/978-3-031-74097-8_6
Liu YZeng XZhang H(2024)LeCo: Lightweight Compression via Learning Serial CorrelationsProceedings of the ACM on Management of Data10.1145/36393202:1(1-28)Online publication date: 26-Mar-2024
https://dl.acm.org/doi/10.1145/3639320
Chen YChen S(2024)Cabin: A Compressed Adaptive Binned Scan IndexProceedings of the ACM on Management of Data10.1145/36393122:1(1-26)Online publication date: 26-Mar-2024
https://dl.acm.org/doi/10.1145/3639312
Show More Cited By

Index Terms

SAP HANA database: data management for modern business applications
1. Applied computing
  1. Enterprise computing
    1. Business process management
2. Information systems
  1. Data management systems
    1. Database management system engines
  2. Information systems applications

Recommendations

Efficient transaction processing in SAP HANA database: the end of a column store myth
SIGMOD '12: Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data

The SAP HANA database is the core of SAP's new data management platform. The overall goal of the SAP HANA database is to provide a generic but powerful system for different query scenarios, both transactional and analytical, on the same data ...
ABAP Development for SAP HANA
SAP CONTROLLING: Focuses on SAP FICO Certification SAP FICO Training

Comments

Information & Contributors

Information

Published In

ACM SIGMOD Record Volume 40, Issue 4

December 2011

60 pages

ISSN:0163-5808

DOI:10.1145/2094114

Issue’s Table of Contents

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 11 January 2012

Published in SIGMOD Volume 40, Issue 4

Check for updates

Qualifiers

Research-article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

307
Total Citations
View Citations
5,246
Total Downloads

Downloads (Last 12 months)202
Downloads (Last 6 weeks)5

Reflects downloads up to 08 Feb 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Vogel LAnneser CGruber FNeumann TGiceva JKemper A(2025)Scaling Beyond DRAM Without Compromising PerformanceScalable Data Management for Future Hardware10.1007/978-3-031-74097-8_6(145-169)Online publication date: 24-Jan-2025
https://doi.org/10.1007/978-3-031-74097-8_6
Liu YZeng XZhang H(2024)LeCo: Lightweight Compression via Learning Serial CorrelationsProceedings of the ACM on Management of Data10.1145/36393202:1(1-28)Online publication date: 26-Mar-2024
https://dl.acm.org/doi/10.1145/3639320
Chen YChen S(2024)Cabin: A Compressed Adaptive Binned Scan IndexProceedings of the ACM on Management of Data10.1145/36393122:1(1-26)Online publication date: 26-Mar-2024
https://dl.acm.org/doi/10.1145/3639312
Habich DPietrzyk JBarcelo PSanchez-Pi NMeliou ASudarshan S(2024)SIMDified Data Processing - Foundations, Abstraction, and Advanced TechniquesCompanion of the 2024 International Conference on Management of Data10.1145/3626246.3654694(613-621)Online publication date: 9-Jun-2024
https://dl.acm.org/doi/10.1145/3626246.3654694
Taleb YMcGehee KYan NWang SMüller SSamuels ABarcelo PSanchez-Pi NMeliou ASudarshan S(2024)Amazon MemoryDB: A Fast and Durable Memory-First Cloud DatabaseCompanion of the 2024 International Conference on Management of Data10.1145/3626246.3653380(309-320)Online publication date: 9-Jun-2024
https://dl.acm.org/doi/10.1145/3626246.3653380
Giles EVarman P(2024)ACID Support for Compute eXpress Link Memory TransactionsProceedings of the International Conference for High Performance Computing, Networking, Storage, and Analysis on ZZZ10.1109/SCW63240.2024.00138(982-995)Online publication date: 17-Nov-2024
https://dl.acm.org/doi/10.1109/SCW63240.2024.00138
Jambigi NHammesfahr JMueller MBach TFelderer M(2024)On Enhancing Root Cause Analysis with SQL Summaries for Failures in Database Workload Replays at SAP HANA2024 IEEE 35th International Symposium on Software Reliability Engineering Workshops (ISSREW)10.1109/ISSREW63542.2024.00052(85-90)Online publication date: 28-Oct-2024
https://doi.org/10.1109/ISSREW63542.2024.00052
Lyu ZBach TLi YLe NHoemke L(2024)BIPeC: A Combined Change-Point Analyzer to Identify Performance Regressions in Large-scale Database Systems2024 IEEE International Conference on Software Maintenance and Evolution (ICSME)10.1109/ICSME58944.2024.00084(808-819)Online publication date: 6-Oct-2024
https://doi.org/10.1109/ICSME58944.2024.00084
Chen HHong XXiao KMao S(2024)Integration Design of Motion Capture and Sensor Technology in Home Fitness2024 IEEE 2nd International Conference on Sensors, Electronics and Computer Engineering (ICSECE)10.1109/ICSECE61636.2024.10729406(1369-1376)Online publication date: 29-Aug-2024
https://doi.org/10.1109/ICSECE61636.2024.10729406
Amagata D(2024)Independent Range Sampling on Interval Data2024 IEEE 40th International Conference on Data Engineering (ICDE)10.1109/ICDE60146.2024.00041(449-461)Online publication date: 13-May-2024
https://doi.org/10.1109/ICDE60146.2024.00041
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Publication

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Abstract

References

Cited By

Index Terms

Recommendations

Efficient transaction processing in SAP HANA database: the end of a column store myth

ABAP Development for SAP HANA

SAP CONTROLLING: Focuses on SAP FICO Certification SAP FICO Training

Comments

Information

Published In

Publisher

Publication History

Check for updates

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

Login options

Full Access

View options

PDF

eReader

Share

Share this Publication link

Share on social media

Affiliations