SAP HANA Architecture
SAP offering a platform that having innovative in memory, & that can be deployed on the business premise or a demand. This platform is called SAP HANA. The main attraction of the HANA is nothing but high performance. It extracts the maximum capabilities of the hardware used in a system and achieve this maximum performance.
What is the Role of HANA? It is nothing but, integration as shown below:
What is the Role of HANA? It is nothing but, integration as shown below:
As shown in the above diagram, SAP HANA integrating the Business Control Logic to the Database with extremely high performance. This high performance is achieved due to the specialty of the HANA architecture.
For learn more about HANA Architecture there are 4 sections in the HANA. They are mentioned in below:
1.SAP HANA In-memory Database.
2.Database Architecture
3.Extended Application Services.
4.HANA based Applications.
Now lets go through the first one.
4.HANA based Applications.
Now lets go through the first one.
1. SAP HANA In-memory Database.
SAP HANA runs on a CPU which having the multi-core processors. These processors or cores connected to the main memory of several Terabytes. A core is virtually acts as a processor, so multi- core processor have the capacity to execute faster the processes with convenient manner. Also here main memory have the capacity of several terabyte, so it can store the huge volume data (multiples of 8e+9 KB). This core and main memory are connected via cache. The advantages of connecting cores with main memory is that fetching and writing the data to the main memory is much faster as compared with secondary memory like hard disks. That's secret of the high performance of the HANA. Also it uses the following feature.
1.1 Columnar Data Storage.
1.2 Parallel Processing.
1.3 Simplifying Applications.
1.1 Columnar Data Storage.
A Database is a two dimensional collection of data which organized in columns and rows. A table can be organized as two types. One is row order and other is column order.
SAP HANA supports both organizing structure, but it is optimized for column order.
Advantages of the Columnar Data Storage are:
- High efficient compression.
- Columns are stored as sequence of bit-coded integers.
- No need of additional index structure (having in-built index integers in each column).
- Reduce complexity.
- Reduce efforts of defining and maintaining metadata (data about the data)
1.2 Parallel Processing
As shown in the above, SAP HANA can execute the column order storage with separate core or processor parallel at a time. A complete column can processed or two cores can divide a single column and execute. This will increase the performance as well as efficiency of exection.
1.3 Application Simplifying
Due to the above mentioned columnar data storage and parallel processing the scanning speed is actually several gigabytes per milliseconds. This brings high performance in HANA and high sort of execution.

Nice Explanation
ReplyDelete