Datenbank-Spektrum

, Volume 15, Issue 2, pp 141–152 | Cite as

Managed Query Processing within the SAP HANA Database Platform

  • Norman May
  • Alexander Böhm
  • Meinolf Block
  • Wolfgang Lehner
FACHBEITRAG

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.

References

  1. 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–1098Google Scholar
  2. 2.
    Binnig C, May N, Mindnich T (2013) SQLScript: Efficiently analyzing big enterprise data in SAP HANA. In: BTW, pp 363–382Google Scholar
  3. 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–33Google Scholar
  4. 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–1317Google Scholar
  5. 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. 36Google Scholar
  6. 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: DATAGoogle Scholar
  7. 7.
    Legler T, Lehner W, Ross A (2007) Der Einfluss der Datenverteilung auf die Performanz eines Data Warehouse. In: BTW, pp. 502–513Google Scholar
  8. 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–592Google Scholar
  9. 9.
    Meijer E (2011) The world according to LINQ. Commun ACM 54(10):45–51Google Scholar
  10. 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. 11.
    Rudolf M, Paradies M, Bornhövd C, Lehner W (2013) The graph story of the SAP HANA database. In: BTW pp. 403–420Google Scholar
  12. 12.
    SAP Fiori for SAP Business Suite (2014) http://help.sap.com/fiori, last accessed: 2015-05-26
  13. 13.
    SAP HANA Developer Guide (2014) http://help.sap.com/hana/SAP_HANA_Developer_Guide_en.pdf, last accessed: 2015-05-26
  14. 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. 15.
    Vassiliadis P, Sellis T (1999) A survey of logical models for OLAP databases. SIGMOD Rec 28(4):64–69Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2015

Authors and Affiliations

  • Norman May
    • 1
  • Alexander Böhm
    • 1
  • Meinolf Block
    • 1
  • Wolfgang Lehner
    • 1
  1. 1.SAP SE, Walldorf, Germany & Technische Universität DresdenDresdenGermany

Personalised recommendations