Tuesday, August 23, 2016

HANA (High performance analytics appliance)

Home


SAP HANA is an in-memory database and application platform, column-oriented,compressed and relational database management system developed and marketed by SAP
primary function as database server is to store and retrieve data as requested by the applications. In addition,
it performs advanced analytics (predictive analytics, spatial data processing, text analytics, text search,
streaming analytics, graph data processing) and  includes ETL capabilities and an application server.

HANA started with

  HANA 1.0 ---->   SPS 03 --> In Nov 2011
           ---->    SPS 04 -->  April 2012
           ---->   SPS 05 -->  Dec   2012
           ---->   SPS 06 -->  June  2013
           ---->   SPS 07 -->  Dec   2013
           ---->   SPS 08 -->  May   2014
           ---->   SPS 09 -->  Nov   2014
           ---->   SPS 10 -->  June  2015
           ---->   SPS 11 -->  Nov   2015
           ---->   SPS 12 -->  May   2016


SAP HANA is supported on below platforms:

VMware    --> vSphere
IBM       --> PowerVM
Hitachi   --> LPAR
Huawei    --> Fushion Sphere
RedHatRHEL--> KVM Hypervisor
SUSE Linux--> Enterprise Hypervisor


SAP is providing two editions of HANA:

1) SAP HANA Platform edition

   1.1) HANA Database
   1.2) HANA Studio
   1.3) HANA Client
 
Optional components

     AFL ( Application functional libraries)
     IC  ( Information Composer)
     SDA (Smart data access)

2) SAP HANA Enterprise edition

   2.1) ETL (Extract Transform Load)

   -SAP Data Services (BODS)
   -SAP Landscape Replication server.



Features of SAP HANA:

The main features of SAP HANA are given below −

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

Based on multi core architecture in distributed system environment.

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

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

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

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 −

SAP HANA is Hybrid In-memory database.

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

It uses parallel processing with multicore CPU Architecture.

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
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.

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.

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

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.


Need for SAP HANA:

Today, most successful companies respond quickly to market changes and new opportunities. A key to this is the effective and efficient use of data and information by analyst and managers.

HANA overcomes the limitations mentioned below −

Due to increase in “Data Volume”, it is a challenge for the companies to provide access to real time data for analysis and business use.

It involves high maintenance cost for IT companies to store and maintain large data volumes.

Due to unavailability of real time data, analysis and processing results are delayed.

1 comment: