UrbanPro
true

Learn SAP HANA Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Search in

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

Harsh Sharma
24/02/2018 0 0

SAP HANA Database is Main-Memory centric data management platform. SAP HANA Database runs on SUSE Linux Enterprises Server and builds on C++ Language.

SAP HANA Database can be distributed to multiple machines.

SAP HANA Advantages are as mentioned below -

  • SAP HANA is useful as it's very fast due to all data loaded in-Memory and no need to load data from disk.
  • SAP HANA can be used for the purpose of OLAP (On-line analytic) and OLTP (On-Line Transaction) on a single database.

SAP HANA Database consists of a set of in-memory processing engines. Calculation engine is main in-memory Processing engines in SAP HANA. It works with other processing engine like Relational database Engine(Row and Column engine), OLAP Engine, etc.

Relational database table resides in column or row store.

There are two storage types for SAP HANA table.

  1. Row type storage (For Row Table).
  2. Column type storage (For Column Table).

Text data and Graph data resides in Text Engine and Graph Engine respectively. There are some more engines in SAP HANA Database. The data is allowed to store in these engines as long as enough space is available.

In this tutorial, you will learn:

  • SAP HANA Architecture

  • SAP HANA Landscape

  • SAP HANA Sizing

SAP HANA Architecture:

Data is compressed by different compression techniques (e.g. dictionary encoding, run length encoding, sparse encoding, cluster encoding, indirect encoding) in SAP HANA Column store.

When main memory limit is reached in SAP HANA, the whole database objects (table, view,etc.) that are not used will be unloaded from the main memory and saved into the disk.

These objects names are defined by application semantic and reloaded into main memory from the disk when required again. Under normal circumstances SAP HANA database manages unloading and loading of data automatically.

However, the user can load and unload data from individual table manually by selecting a table in SAP HANA studio in respective Schema- by right-clicking and selecting the option "Unload/Load".

SAP HANA Server consists of:

  1. Index Server
  2. Preprocessor Server
  3. Name Server
  4. Statistics Server
  5. XS Engine

    SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

  1. SAP HANA Index Server:

    SAP HANA Database Main server are index server. Detail of each server is as below:

  • It's the main SAP HANA database component
  • It contains actual data stores and the engine for processing the data.
  • Index Server processes incoming SQL or MDX statement.

Below is the architecture of Index Server.

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

 

SAP HANA Index Server overview:

  • Session and Transaction Manager: Session Component manage sessions and connections for SAP HANA database. Transaction Manager coordinates and control transactions.
  • SQL and MDX Processor: SQL Processor component queries data and send to them in query processing engine i.e. SQL/SQL Script / R / Calc Engine. MDX Processor queries and manipulates Multidimensional data (e,g. Analytic View in SAP HANA).
  • SQL / SQL Script / R / Calc Engine: This Component executes SQL / SQL script and calculation data convert in calculation model.
  • Repository: Repository maintain the versioning of SAP HANA metadata object e.g.(Attribute view, Analytic View, Stored procedure).
  • Persistence layer: This layer uses in-built feature "Disaster Recovery" of SAP HANA database. Backup is saved in it as save points in the data volume.
  1. Preprocessor Server:

This server is used in Text Analysis and extracts data from a text when the search function is used.

  1. Name Server:

This Server contains all information about the system landscape. In distributed server, the name server contains information about each running component and location of data on the server. This server contains information about the server on which data exists.

  1. Statistic Server:

Statistic server is responsible for collecting the data related to status, resource allocation / consumption and performance of SAP HANA system.

  1. XS Server:

XS Server contains XS Engine. It allows external application and developers to use SAP HANA database via the XS Engine client. The external client application can use HTTP to transmit data via XS engine for HTTP server.

SAP HANA Landscape:

"HANA" mean High Performance Analytic Appliance is a combination of hardware and software platform.

  • Due to change in computer architecture, the more powerful computer is available in terms of CPU, RAM, and Hard Disk.
  • SAP HANA is the solution for performance bottleneck, in which all data is stored in Main Memory and no need to frequently transfer data from disk I/O to main memory.

Below are SAP HANA Innovation in the field of Hardware/Software.

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

There are two types of Relational data stores in SAP HANA: Row Store and Column Store.

Row Store:

  • It is same as Traditional database e.g. (Oracle, SQL Server). The only difference is that all data is stored in row storage area in memory of SAP HANA, unlike a traditional database, where data is stored in Hard Drive.

Column Store:

  • Column store is the part of the SAP HANA database and manages data in columnar way in SAP HANA memory. Column tables are stored in Column store area. The Column store provides good performance for write operations and at the same time optimizes the read operation.

Read and write operation performance optimized with below two data structure.

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

Main Storage:

Main Storage contains the main part of data. In Main Storage, suitable data compression Method (Dictionary Encoding, Cluster Encoding, Sparse Encoding, Run Length encoding, etc.) is applied to compress data with the purpose to save memory and speed up searches.

  • In main storage write operations on compressed data will be costly, so write operation do not directly modify compressed data in main storage. Instead, all changes are written in a separate area in column storage known as "Delta Storage."
  • Delta storage is optimized for a write operation and uses normal compression. The write operations are not allowed on main storage but allowed on delta storage. Read operations are allowed on both storages.

We can manually load data in Main memory by option "Load into Memory" and Unload data from Main memory by "Unload from Memory" option as shown below.

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

Delta Storage:

Delta storage is used for a write operation and uses basic compression. All uncommitted modification in Column table data stored in delta storage.

When we want to move these changes into Main Storage, then use "delta merge operation" from SAP HANA studio as below:

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

  • The purpose of delta merge operation is to move changes, which is collected in delta storage to main storage.
  • After performing Delta Merge operation on sap column table, the content of main storage is saved to disk and compression recalculated.

Process of moving Data from Delta to Main Storage during delta merge:

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

There is a buffer store (L1-Delta) which is row storage. So in SAP HANA, column table acts like row store due to L1-delta:

  1. The user runs update / insert query on the table (Physical Operator is SQL statements.).
  2. Data first go to L1. When L1 moves data further (L1- Uncommitted data)
  3. Then data goes to L2-delta buffer, which is column oriented. (L2- Committed data)
  4. When L2-delta process is complete, data goes to Main storage.

So, Column storage is both Write-optimized and Read-optimized due to L1-Delta and main storage respectively. L1-Delta contains all uncommitted data. Committed data moves to Main Store through L2-Delta. From main store data goes to the persistence layer (The arrow indicating here is a physical operator that send SQL Statement in Column Store). After Processing SQL Statement in Column store, data goes to the persistence layer.

E.g. below is row-based table:

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

Table data is stored on disk in linear format, so below is format how data is stored on disk for row and column table -

In SAP HANA memory, this table is stored in Row Store on disk as format:

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial Memory address

And in Column, data is stored on disk as:

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial Memory address

Data is stored column-wise in the linear format on the disk. Data can be compressed by compress technique.

So, Column store has an advantage of memory saving.

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

SAP HANA Sizing:

Sizing is a term which is used to determine hardware requirement for SAP HANA system, such as RAM, Hard Disk and CPU, etc.

The main important sizing component is the Memory, and the second important sizing component is CPU. The third main component is a disk, but sizing is completely dependent on Memory and CPU.

In SAP HANA implementation, one of the critical tasks is to determine the right size of a server according to business requirement.

SAP HANA DB differ in sizing with normal DBMS in terms of:

  • Main Memory Requirement for SAP HANA (Memory sizing is determined by Metadata and Transaction data in SAP HANA).
  • CPU Requirement for SAP HANA (Forecast CPU is Estimated not accurate).
  • Disk Space Requirement for SAP HANA (Is calculated for data persistence and for logging data)

The Application server CPU and application server memory remain unchanged.

For sizing calculation SAP has provided various guidelines and method to calculate correct size.

We can use below method:

  1. Sizing using ABAP report.
  2. Sizing using DB Script.
  3. Sizing using Quicksizer Tool.

By using Quicksizer tool, Requirement will be displayed in below format-

SAP HANA Architecture, LandScape, Sizing: Complete Tutorial

0 Dislike
Follow 2

Please Enter a comment

Submit

Other Lessons for You

SAP Analytics Cloud(SAC), or SAP Cloud Analytics
Hi All For all those who are currently working on SAP-BW,SAP-HANA,SAP-BO,SAP-Lumira,Design Studio,S/4HANA,BW/4HANA suggested to update SAP Analytics Cloud(SAC) a cloud version of BI from SAP Which is...

Sap Hana: How To Start Hana Studio & Start Hana System To Understand The Components And Views?
D-Click on SAP HANA Studio from the desktop. Use the login your user name and password which you got from the system adminstrator. Once login in to HANA system. Click on Add System if need to add...

Top 15 SAP HANA Interview Questions & Answers
1) Mention what is SAP HANA? Ans. SAP HANA stands for High Performance Analytical Appliance- in-memory computing engine. HANA is linked to ERP systems; Frontend modeling studio can be used for replication...

Differences Between SAP HANA & SAP S/4HANA
Some levels of confusion between SAP HANA and SAP S/4HANA still exist with the majority of the people these days. In this article, I would like to provide clarity for those who are wrestling with the differences...

SAP HANA SQL Stored Procedure Tutorial
A procedure is a unit/module that perform a specific task. This procedure can be combined to form larger programs. This basically forms the 'Modular Design'. A procedure can be invoked by another procedure...
X

Looking for SAP HANA Training Classes?

The best tutors for SAP HANA Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn SAP HANA Training with the Best Tutors

The best Tutors for SAP HANA Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more