SAP HANA

SAP HANA (formerly High Performance Analytic Appliance, today no acronym) is a database technology from SAP, which was introduced in 2010. It is an appliance, a combination of hardware and software in-memory technology that uses the opposite of the hard drive much faster accessible computer's memory for data storage, compared to the conventional applications to allow using the evaluations with higher performance.

History

HANA was developed by SAP in cooperation with some clients, including Coca Cola Hellenic, the Future Group ( an Indian operator of department store chains) and Hilti to scan large amounts of data efficiently. The appliance was launched in spring 2010 and deployed starting in November of the same year. From the manufacturer's point of view, the in-memory database is an important issue for the future, as well Snabe, Co -CEO of SAP, said in 2011. Among the four main investment focus of the company had been achieved in the in-memory technology in 2011, the strongest growth. On January 10, 2013, SAP announced that the core applications of SAP Business Suite are available based on HANA.

Method

With HANA different techniques both in software and in hardware area are combined. On the software side, a hybrid of the usual in-memory databases, column- oriented approach and the conventional, common in relational databases row-oriented database technology is employed. On the hardware side, an attempt is made to replace as the main memory by the CPU cache, and the disk memory by the main memory in order to use the respective faster access times. These processes enable performance advantages.

Use

Designed for business intelligence and business analytics applications appliance is used in the SAP Netweaver Business Warehouse and Business Objects in Strategic Workforce Planning. It is, however, according to the manufacturer also possible to run other applications with HANA. In addition to other SAP products include all SQL -based applications. On January 10, 2013, SAP announced the availability of the entire SAP Business Suite on HANA.

Similar products

Oracle Exalytics established 2011 with a similar system before.

Since version 10.5 DB2 IBM also dominated by the column-oriented data management and in-memory technology.