SAP HANA INTRODUCTION

Features of SAP HANA

The main features of SAP HANA are given below −

     1)  SAP HANA is a combination of software and hardware innovation to process huge amount of real time data.

     2)  Based on multi core architecture in distributed system environment.

     3)  Based on row and column type of data-storage in database.

     4)  Used extensively in Memory Computing Engine (IMCE) to process and analyze massive amount of real time data.

     5)  It reduces cost of ownership, increases application performance, enables new applications to run on real time environment that were not possible before.

     

     6)  It is written in C++, supports and runs on only one Operating System Suse Linux Enterprise Server 11 SP1/2.

Features of In-Memory Database

The main features of SAP HANA in-memory database are −

      1)  SAP HANA is Hybrid In-memory database.

      2)  It combines row based, column based and Object Oriented base technology.

      3)  It uses parallel processing with multicore CPU Architecture.

      4)  Conventional Database reads memory data in 5 milliseconds. SAP HANA In-Memory database reads data in 5 nanoseconds.

It means, memory reads in HANA database are 1 million times faster than a conventional database hard disk memory reads.

Analysts want to see current data immediately in real time and do not want to wait for data until it is loaded to SAP BW system. SAP HANA In-Memory processing allows loading of real time data with use of various data provisioning techniques.

Advantages of In-Memory Database

      

       1)   HANA database takes advantage of in-memory processing to deliver the fastest data-retrieval speeds, which is enticing to companies struggling with high-scale online transactions or timely forecasting and planning.

       2)    Disk-based storage is still the enterprise standard and price of RAM has been declining steadily, so memory-intensive architectures will eventually replace slow, mechanical spinning disks and will lower the cost of data storage.

       3)     In-Memory Column-based storage provides data compression up to 11 times, thus, reducing the storage space of huge data.

        4)   This speed advantages offered by RAM storage system are further enhanced by the use of multi-core CPUs, multiple CPUs per node and multiple nodes per server in a distributed environment.