SAP HANA

from Wikipedia, the free encyclopedia
SAP HANA

SAP 2011 logo.svg
Basic data

developer SAP SE
Publishing year 2010
Current  version 2.0 SPS04
( April 5, 2019 )
operating system Linux
programming language C , C ++
category In-memory - RDBMS
License proprietary license, end-user license agreement
German speaking No
Product page on sap.com

HANA (formerly English H igh performance to alytic A ppliance , high-performance analysis application ' ) is a development and integration platform of SAP software applications that the core of a relational database management system is (RDBMS) and OLAP - and OLTP -Landscapes in a common In -Memory database combined. It was originally an appliance ; H. a combination of hardware and software that uses in-memory technology to store the data in the computer's main memory, which can be accessed much faster than the hard drive . Compared to conventional applications, it enables evaluations of large amounts of data with higher performance . Today, SAP HANA can be used with various hardware and also virtualized .

history

The architecture of SAP HANA was developed by SAP in 2008 in cooperation with the Hasso Plattner Institute and Stanford University for the real-time analysis of large amounts of data. Former SAP board member Vishal Sikka called it “ Hasso's New Architecture ” in a blog . Before the name "HANA" caught on, the application was also referred to as "SanssouciDB" or "NewDB" in various publications. SAP HANA was first presented in spring 2010 and was implemented from November of the same year. Originally only available as an appliance, SAP HANA has now been further developed into a platform for all SAP business applications that support in-memory technology and can also be installed on the customer's own hardware.

On January 10, 2013, SAP announced that the core applications of the SAP Business Suite based on HANA are available.

In 2015, SAP presented the first product, SAP S / 4HANA , which is based entirely on the simplified data model of SAP HANA. The product had been sold 5,400 times by the end of the year.

In 2016, HANA Express, a free edition for testing and developing productive applications with up to 32 GB of memory, was released. Use with additional storage is possible for a surcharge. In addition, that year SAP BW / 4HANA appeared as the successor to SAP BW and version 2.0 of the database.

Procedure

With SAP HANA, different technologies are combined in both software and hardware. On the software side, a hybrid of the column-oriented working method that is common in in-memory databases and the conventional line-oriented database technology that is widespread in relational databases is used.

A key feature of SAP HANA is its consistent design as an in-memory platform, i.e. H. As is usually the case with databases, data for analysis or processing are not copied from a hard drive to the main memory, but are kept there in full. This enables the implementation of transactional ( OLTP ) and analytical procedures ( OLAP ) in the same system and the processing and analysis of large amounts of data ( Big Data ) in almost real time.

In some cases, these processes enable significant performance advantages and business processes that were not possible with previous database technologies. Since 2014, SAP has also offered the SAP HANA platform in a company's own cloud environment; mixed operation (hybrid) is also possible. The SAP HANA Enterprise Cloud enables companies to use corporate applications such as ERP , CRM , BI etc. as so-called Managed Services ( SaaS ), based on SAP HANA as an in-memory database platform.

The SAP HANA Cloud Platform includes extensive in-memory application and database services ( PaaS ). It enables companies to create extensions for applications themselves or to consume them from partners.

use

The appliance, which was developed for business intelligence and business analytics applications, was initially used in the SAP Business Warehouse and in Business Objects Strategic Workforce Planning . However, according to the manufacturer, it is also possible to operate other applications with HANA. In addition to other SAP products, this includes all SQL- based applications. On January 10, 2013, SAP announced the availability of the entire SAP Business Suite on HANA . From then on, SAP HANA was gradually developed into an open platform and supplemented with functions for text analysis , data mining and geodata .

Application server

In addition to the database, Hana provides the SAP HANA XSA (HANA XS Advanced) service, an option for programming native Hana applications. From version 2.04, programming with server-side JavaScript, Java and Python is possible on XSA.

similar products

The Exalytics In-Memory Machine introduced by Oracle in 2011 also uses in-memory technology. Since July 2014, Oracle has also been offering a so-called “in-memory” option for database version 12c.

From version 10.5, column-oriented data management and in-memory technology are also available for the DB2 database from IBM with the technology called BLU Acceleration.

In contrast to these two products, which replicate data from the hard drive to their main memory for in-memory operation, SAP HANA has a pure in-memory database . See the In-Memory Database article for many other similar products.

Web links

Individual evidence

  1. ↑ help.sap.com . (accessed on August 1, 2019).
  2. ↑ a b c d Alexander Neumann: SAP delivers appliances for in-memory computing. In: heise.de. December 1, 2010, accessed August 8, 2020 .
  3. ↑ In memory database - parallel processing - RDBMS - SAP HANA. Retrieved April 24, 2019 .
  4. ↑ Michael Kurzidim: SAP's in-memory database Sanssouci (HANA). In: Computerworld. February 23, 2011, accessed August 6, 2020 .
  5. ^ Hasso Plattner, Alexander Zeier: In-Memory Data Management. Technology and Applications . 2nd Edition. Springer, Berlin / Heidelberg 2012, ISBN 978-3-642-29574-4 , doi : 10.1007 / 978-3-642-29575-1 (English, 267 pages).
  6. ↑ Christiane Stagge: Glossary SAP HANA . SAP SE. April 23, 2012. Accessed July 24, 2018.
  7. ↑ SAP HANA is now available to customers worldwide . SAP SE. June 21, 2011. Accessed July 24, 2018.
  8. ↑ SAP presents new innovations for the SAP HANA platform in three dimensions . SAP SE. October 23, 2013. Accessed July 24, 2018.
  9. ↑ SAP Business Suite powered by SAP HANA now generally available . SAP SE. May 15, 2013. Accessed July 24, 2018.
  10. ↑ a b Andreas Schmitz: What actually is SAP HANA? . SAP SE. September 7, 2015. Accessed July 24, 2018.
  11. ↑ Alexander Neumann: In-Memory-Database: SAP attracts with free express edition of HANA . heise.de. September 20, 2016. Accessed July 24, 2018.
  12. ↑ Heinrich Vaske: SAP is taking the next step into the S / 4 future with its data warehouse solution . Computer week. August 31, 2016. Accessed July 24, 2018.
  13. ↑ Hans-Peter Schüler: HANA 2: SAP's next in-memory database . heise.de. November 8, 2016. Accessed July 24, 2018.
  14. ↑ Christian Kirsch: SAP concentrates on its own database . heise.de. November 10, 2011. Accessed July 24, 2018.
  15. ↑ According to an independent market research institute, SAP HANA is one of the leading in-memory database platforms . SoftSelect. August 11, 2015. Accessed July 24, 2018.
  16. ↑ a b Harald Weiss: Hana: The hardware that SAP software should make . chip.de. May 25, 2011. Accessed July 24, 2018.
  17. ↑ Rick Whiting: SAP Data Warehouse Software Now Relies On HANA Database ( English ) CRN. October 11, 2011. Accessed July 24, 2018.
  18. ↑ Jens Ihlenfeld: SAP presents R4, which is not called that . golem.de. January 10, 2013. Accessed July 24, 2018.
  19. ↑ SAP HANA XSA - application server. In: mindsquare. Accessed December 20, 2019 (German).
  20. ↑ Lars Röwekamp: Oracle's memory-resident database as an appliance . heise.de. October 3, 2011. Accessed July 24, 2018.
  21. ↑ Oracle Database In-Memory - Powering the Real-Time Enterprise ( English , PDF, 903 kB) Oracle. 2018. Retrieved July 24, 2018.
  22. ^ Roman Melnyk: What's new in DB2 10.5 for Linux, UNIX, and Windows ( English ) IBM. April 23, 2013. Accessed July 24, 2018.