SAP HANA Database Concepts

Ratings:
(4.3)
Views: 2873
Banner-Img
Share this blog:

SAP HANA Database Overview

The SAP HANA database is a hybrid in-memory database that combines row-based, column-based, and object-based database technology.

It is optimized to exploit the partial processing capabilities of modem multi-core / CPU architectures. With this architecture, SAP applications can benefit from current bar-down technologies.

The SAP HANA database is the heart of SAP’s in-memory technology offering, helping customers to improve their operational efficiency, agility, and flexibility.

SAP HANA Information Composer

SAP HANA Information Composer is a Web-Based Environment that allows business users to upload data to the SAP HANA database and manipulate that data by creating information values.

The main features of Information Composer are as follows

Data acquisition

You can upload the data, preview, and cleanse this data, and create a physical table in the SAP HANA database.

Data Manipulation

You can select two objects in the SAP HANA database, combined them, add calculated fields, and create an informed view that can be consumed by SAP Bo tools.

BUSINESS / INTELLIGENCE

(Business Objects) – It is a reporting tool for generating reports from views provided by the HANA Information Composer studio.

We can generate reports from views in two ways

Direct Accessing views for crystal reports, Advanced Analysis, Explorer, Webi4.0, SAP Real-time Salaries

We can create UDT or IDT (Universe Design tool, Information Design tool) first and then create reports. 

SAP HANA STUDIO

Here we can perform modelling & administration on data that is available in HANA DB and produce views that are used to create reports and to build a dashboard in the SAP BO tool

Pre-requisite

SAP HANA Hardware

Multicore Architecture/HANA DB

SAP HANA Software

In-Memory Computing Engine Algorithm (Row/Column/Object)

If you want to enrich your career and become a professional in SAP Hana, then visit Tekslate - a global online training platform: "SAP Hana Administration Training" This course will help you to achieve excellence in this domain.

 

SAP HANA DB Overview

SQL DB HANA DB
  • Row
  • DB & Application in different architecture
  • SQL
  • Limited cache
  • SQL
  • Row & Colum
  • HANA DB & HANA apps are in the same architecture
  • SQL/MDX
  • For all data
  • SQL/HANA SQL scripts

Advantages of Column level stage

Sligh data compression rate

Sligh performance on column operation

Elimination of Traditional materialized view concept

Elimination of unnecessary index

Normal DBH/W HANA H/W
  • Limited in RAM
  • Disk-based storage
  • Everything we used in RAM
  • Mute core storage

sap hana data table view

In the HANA Table schema, we have not only a table but also views

In the Analytical view, Attribute view, and calculated view these are surrounded by tables and view

Role of HANA studio in HANA Database System

It helps us to create analytically, calculate views

HANA studio also helps us to do the turning of SQL Query & support for ANSI SQL

sap hana database system

Initially the Data ERP BW Mixed Source

Replicated (With Initial data volumes and lock) – It is mapped to the HANA DB persistence layer

When we load all data into memory and log volume data will be loaded into paging memory with the help of the HANA Management System

Once the data is loaded into cache memory we will prepare data stores (row/column/object)

These data stores can be optimized.

They can also use standard SQL Statements & scripts to optimize. For that, this is given to HANA studio by request parser to prepare the views (Analytical / Attribute / Calculated views)

We can maintain these views & Datastore in HANA metadata Manager which is given to the reporting analysis

Read these latest SAP HANA Interview Questions that help you grab high-paying jobs!

SAP HANA Security

HANA Landscape has got different levels in different phases

Screenshot_13

Database Development

At the DB level we define security for views & tables in terms of database repository owners' authorization for networks

Screenshot_14

Modelling Level

To prepare and process the view, accessing metadata manager, accessing request parser, and authorization to add data services as an external system in HANA studios.

Screenshot_15

At Reporting level

Authorization for HANA ODBC.

Authorization to create a semantic layer using HANA DB.

Authorization in accessing HANA Views, UNX files (4.0) in generating BO Business Intelligence

Screenshot_16

For in-depth knowledge of SAP HANA, click on below

You liked the article?

Like: 0

Vote for difficulty

Current difficulty (Avg): Medium

EasyMediumHardDifficultExpert
IMPROVE ARTICLEReport Issue

About Author

Authorlogo
Name
TekSlate
Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.