Skip to main content

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

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.

Processor Server:

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




Comments

Post a Comment

Popular posts from this blog

The importance of forests

Man has been cutting down forests indiscriminately and today the trend is not only to save natural forests but to create artificial ones. Deserts are made to bloom! The Imperial Valley of the Sonoran desert in southern California has been converted into a green patch which yields crops all the year round. Forests are not to be considered merely as a direct source of wealth; they are to be considered in relation to the national economy and geography. Forests serve many purposes. They hold together the soil and prevent or minimize soil erosion. The oxygen in the air is replenished by forests and plankton in the sea. Trees and plants, during photosynthesis, absorb carbon dioxide and release oxygen. Scientists fear that if forests are destroyed indiscriminately, there will be an increase in carbon dioxide and eventually the sun's rays will become hotter, the polar caps will melt and the ocean level rise and submerge much of our land. Vegetable mould that forests supply increases the fe...
Post a Comment
Read more

The importance of water

Introduction  Life, both animal and plant, is impossible without water. Without water men die of dehydration About 70% of the human body is water. Of the total surface of the earth, 75 % is water and just below the surface of the land in most areas there is a saturated layer known as the water table. Animals and plants have large percentages of water in their make-up and some animals regulate their movements according to the water sources. Water: If there is no water there can be no life. The moon is a sterile desert because there is no water in it. It is to be remembered that it was water that determined the location of human settlements and without the Nile the Egyptian Civilization would not have developed The Nile provided the Egyptians facilities for irrigation and transport. As Herodotus said, Egypt is the "Gift of the Nile". Importance of water: The urban man rarely thinks of the importance of water. When he needs water, all he has to do is to turn on the tap. The only...
Post a Comment
Read more