What is SAP HANA?


SAP HANA is an acronym which stands for High-Performance Analytic Appliance.

It is developed and marketed by SAP SE. Its in-memory, column oriented, relational database system make it unique from other database systems available in the market.

In-memory database are also called Main Memory Database System and it relies on Main Memory (RAM) for Computer Data Storage.

A Relational Database is a DBMS which utilizes the Primary Key & Foreign Key relationship.

Column-Oriented DBMS is a Database system that stores data by column rather than row.

SAP HANA Database
General Architecture of SAP HANA Database

Let us understand the concept of Column Oriented DBMS using an example.

If we have employee details of 3 Employee in our system, as follow:

0011231BARRY ALLEN50000
0021232OLIVER QUEEN60000
0031233JAMES BOND70000


Row Oriented System:

In row oriented system, it will be saved as follows (It will not be saved as shown, because real database systems save it in serialized manner):

001: 1231, BARRY ALLEN, 50000;
002: 1232, OLIVER QUEEN, 60000;
003: 1233, JAMES BOND, 70000;


Now if I have to make a search on the basis of SALARY, it will search whole system for that, which is okay in case of low data but slow in case of abundant data. In that case Row Oriented System make Indexes on basis of column as shown below:

001: 50000;
002: 60000;
003: 70000;


The Indexes are faster, the only demerit is that for every column An Index will be required, which will acquire more data in database.

Column Oriented System:

In column oriented system, it will be saved as follows:

50000:001, 60000:002, 70000:003;


In above example, every row has same type of data i.e. on the basis of column.

One point to observe is: “In a row-oriented indexed system, the primary key is the Row ID that is mapped from indexed data. In the column-oriented system, the primary key is the data, which is mapped from Row ID”.

So, if we want to do a search on basis of any column, the searches will be faster as it will be searched only in a single row.

How to Access SAP HANA:

SAP HANA utilizes Raw/Open SQL to communicate with database as well as utilizes “ABAP for HANA” which is newer version of ABAP that runs on HANA.

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.