Skip to main content
SpringerLink
Log in

Managed Query Processing within the SAP HANA Database Platform

  • FACHBEITRAG
  • Published:
Datenbank-Spektrum Aims and scope Submit manuscript

Abstract

The SAP HANA database extends the scope of traditional database engines as it supports data models beyond regular tables, e.g. text, graphs or hierarchies. Moreover, SAP HANA also provides developers with a more fine-grained control to define their database application logic, e.g. exposing specific operators which are difficult to express in SQL. Finally, the SAP HANA database implements efficient communication to dedicated client applications using more effective communication mechanisms than available with standard interfaces like JDBC or ODBC. These features of the HANA database are complemented by the extended scripting engine–an application server for server-side JavaScript applications–that is tightly integrated into the query processing and application lifecycle management. As a result, the HANA platform offers more concise models and code for working with the HANA platform and provides superior runtime performance.

This paper describes how these specific capabilities of the HANA platform can be consumed and gives a holistic overview of the HANA platform starting from query modeling, to the deployment, and efficient execution. As a distinctive feature, the HANA platform integrates most steps of the application lifecycle, and thus makes sure that all relevant artifacts stay consistent whenever they are modified. The HANA platform also covers transport facilities to deploy and undeploy applications in a complex system landscape.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9

Similar content being viewed by others

Notes

  1. https://cloud.google.com/developers/.

  2. https://azure.microsoft.com.

  3. https://developer.salesforce.com/.

  4. https://apex.oracle.com/.

  5. https://hcp.sap.com/

  6. \text{The application is part of the standard HANA delivery. See} http://help.sap.com/hana/SAP_HANA_Interactive_Education_SHINE_en.pdf for the setup procedure.

  7. The most important special case in ERP systems is the currency conversions, i.e. interpreting decimal values as Euro and converting them given a specific date to US dollars. Interestingly in the context of a business application, this is not only a semantically complex operation, but it is also very performance critical.

References

  1. Blakeley AJ, Rao V, Kunen I, Prout A, Henaire M, Kleinerman C (2008) .NET Database Programmability and Extensibility in Microsoft SQL Server. In: Proc. SIGMOD, pp. 1087–1098

  2. Binnig C, May N, Mindnich T (2013) SQLScript: Efficiently analyzing big enterprise data in SAP HANA. In: BTW, pp 363–382

  3. Färber F, May N, Lehner W, Große P, Müller I, Rauhe H, Dees J (2012) The SAP HANA Database – an architecture overview. IEEE Data Eng Bull 35(1):28–33

  4. Große P, Lehner W, Weichert T, Färber F, Li WS (2011) Bridging two worlds with RICE—integrating R into the SAP in-memory computing engine. Proc VLDB 4(12):1307–1317

  5. Große P, May N, Lehner W (2014) A study of partitioning and parallel UDF execution with the SAP HANA database. In: SSDBM, pp. 36

  6. Kernert D, May N, Hladik M, Werner K (2015) From static to agile - interactive particle physics analysis using analytical views in the SAP HANA DB. In: DATA

  7. Legler T, Lehner W, Ross A (2007) Der Einfluss der Datenverteilung auf die Performanz eines Data Warehouse. In: BTW, pp. 502–513

  8. May N, Lehner W, Hameed P. S, Maheshwari N, Müller C, Chowdhuri S, Goel A (2015) SAP HANA -from relational OLAP database to big data infrastructure. In: EDBT, pp 581–592

  9. Meijer E (2011) The world according to LINQ. Commun ACM 54(10):45–51

  10. Nagel K (2013) BW-on-HANA and the “FEMS”. https://blogs.saphana.com/2013/05/15/bw-on-hana-and-the-fems/, last accessed 2015-05-26

  11. Rudolf M, Paradies M, Bornhövd C, Lehner W (2013) The graph story of the SAP HANA database. In: BTW pp. 403–420

  12. SAP Fiori for SAP Business Suite (2014) http://help.sap.com/fiori, last accessed: 2015-05-26

  13. SAP HANA Developer Guide (2014) http://help.sap.com/hana/SAP_HANA_Developer_Guide_en.pdf, last accessed: 2015-05-26

  14. SAP HANA Predictive Analysis Library (2014) http://help.sap.com/hana/SAP_HANA_Predictive_Analysis_Library_PAL_en.pdf, last accessed: 2015-05-26

  15. Vassiliadis P, Sellis T (1999) A survey of logical models for OLAP databases. SIGMOD Rec 28(4):64–69

Download references

Author information

Authors and Affiliations

  1. SAP SE, Walldorf, Germany & Technische Universität Dresden, Dresden, Germany

    Norman May, Alexander Böhm, Meinolf Block & Wolfgang Lehner

Authors
  1. Norman May
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Alexander Böhm
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Meinolf Block
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Wolfgang Lehner
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Norman May.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

May, N., Böhm, A., Block, M. et al. Managed Query Processing within the SAP HANA Database Platform. Datenbank Spektrum 15, 141–152 (2015). https://doi.org/10.1007/s13222-015-0185-2

Download citation

  • Received:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s13222-015-0185-2

Keywords

Search

Navigation