• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

SAP HANA Database Concepts

SAP HANA Database Overview

The SAP HANA database is a hybrid in-memory database 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 which allows business users to upload data to the SAP HANA database and to 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 information view that can be consumed by SAP Bo tools.

BUSINESS / INTELLIGENCE

(Business Objects) – It is a reporting tool of generate reports from views provided by 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 Xclaries

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

 SAP HANA STUDIO

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

At TekSlate, we offer resources that help you in learning various IT courses. We avail both written material and demo
 video tutorials. To gain in-depth knowledge and be on par with  practical experience, 
then explore SAP HANA Training Material PDF.

Pre-requistes

SAP HANA Hardware

Multi core Architecture/HANA DB

SAP HANA Software

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

SAP HANA DB Overview

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

Advantages of Column level stage

Sligh data compression rata\e

Sligh performance on column operation

Elimination of Traditional materialized view concept

Elimination of unnecessary index

Normal DB H/WHANA H/W
  • Limited in RAM
  • Disk based storage
  • Everything we used in RAM
  • Mute core storage

Screenshot_11

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

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

Role of HANA studio in HANA Database System

It helps us to create analytical, calculate views

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

Screenshot_12

Learn more about SAP HANA Interview Questions in this blog post.

Initially the Data ERP BW Mixed Source

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

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

Once the data 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 optimized. For that this is given to HANA studio by request parser to prepare the views (Analytical / Attribute / Calculated views)

We can maintain these views & Data store in HANA meta data Manager which is given to the reporting analysis

SAP HANA Security

HANA Lands cape has got different levels in different phases

Screenshot_13

Database Development

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

Screenshot_14

Modeling Level

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

Screenshot_15

At Reporting level

Authorization for HANA ODBC.

Authorization to create semantic layer using HANA DB.

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

Screenshot_16

For an Indepth knowledge on SAP HANA, click on below

Summary
Review Date
Reviewed Item
SAP HANA Database Concepts
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on SAP HANA Database Concepts"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.