Skip to main content

SAP HANA Architecture, Landscape Overview | SAP HANA Online Tutorial


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. Learn database concepts from SAP HANA training.
Learn IT Training is a dynamic SAP training podium which provides you virtual environment with effective learning experience by industry experts across India, USA, Canada, Australia, and UAE & UK. We impart technology which takes you to improved performance and focus on growth and innovation.
SAP HANA advantages are 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.
  • Row type storage
  • Column type storage
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 (These tools are included in SAPHANA ADMIN training) in respective Schema- by right-clicking and selecting the option "Unload/Load".
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.
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. Learn database concepts from SQL server training by Learn IT. 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.
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.
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:

  • 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.
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.
  • The user runs update / insert query on the table (Physical Operator is SQL statements.).
  • Data first go to L1. When L1 moves data further (L1- Uncommitted data)
  • Then data goes to L2-delta buffer, which is column oriented. (L2- Committed data)
  • 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.
Want to learn more about SAP HANA and learn practical implementation then join with Learn IT Training  register here. www.learnittraining.com/student-registration
For more details visit: www.learnittraining.com
Email: contact@learnittraining@gmail.com
Contact: INDIA  +91 9912989639  USA +12108585008




Comments

Popular posts from this blog

What is SAP HANA 2.0? Questions About SAP HANA 2

What is SAP HANA 2? SAP HANA 2 is the new generation of the SAP HANA platform It offers new functionalities for database management, data management, analytical intelligence, and application development, and was designed specifically with companies embracing the digital transformation in mind. What new technical functions are available compared to the current SAP HANA version? Database management : There are multiple enhancements for high availability and security. For example, the new “active/active read-enabled” option allows IT organizations to leverage secondary systems – previously used only for system replication – to off-load read-intensive workloads for improved operations. Data management : The SAP HANA-based Web application SAP Enterprise Architecture Designer allows customers to visualize the impact of new technologies on their architecture before they are implemented. In addition, a tiered storage enhancement allows the distributed storage of data by priority re...

Sap Hana Certification| Sap Hana Courses | Learn sap hana online Training

About SAP HANA Certification training Course This SAP HANA online training will ensure you get a good grasp of SAP HANA fundamentals, learn and deploy real-time analytics. HANA is an on-premise application that is used for gathering real-time insights. In this SAP HANA training you will learn about SAP HANA Studio, Modeling, Security features and various other aspects. You will understand why SAP HANA is a fundamentally different database engine What you will learn in SAP HANA Training Course? Learn about SAP HANA basics, features, architecture and terminology involved Work on HANA Studio Modelers and gain expertise in modelling Master SAP HANA Interface, client and connectivity Auto documentation process and SAP BO Analysis Learn SAP HANA administration activities like managing users, storage and security Master System Replication, data provisioning and SAP ABAP online Data flow Configuring, reporting, monitoring & dashboard creation using SAP HANA Work on r...

Explore The Difference Between SAP HANA and SAP HANA 2.0 | SAP HANA Online Tutorials

SAP HANA 2 is being hailed by SAP as the latest platform for Digital Transformation. SAP HANA 2 is an offering that leverages cutting edge data management and database technology. SAP has also looked into the analytical intelligence capabilities and advanced application development tools on an integrated in-memory platform. This frees up precious human resources and capital for new and state-of-the-art application development to meet mission-critical business goals. Database management and database have been improved with high security, workload management and availability along with Data Integration, Data Quality and Enterprise Modeling. When a professional is deploying or developing modern applications which are able to access data from anywhere and integrate transactions with analytical processing of an advanced nature. SAP HANA 2 has revolutionized analytical intelligence an application development. There are highly significant changes in terms of analytical processing engi...