SAP HANA Architecture - UI5CN Course

Опубликовано: 03 Ноябрь 2024
на канале: UI5 Community Network
457
12

HANA® SQL Professional and Advanced is a unique course which will allow you to understand HANA® Native development in details from :

https://www.ui5cn.com/courses/hana-sq...

✓ SQL side

✓ Procedure development

✓ Architecture side

✓ Data provisioning side

✓ HANA® data modelling side


Details of the topics covered are:

✓ HANA® is an in-memory data platform details.

✓ HANA® Data Modeling

✓ HANA® Administration

HANA Database Architecture

✓ Index Server

✓ Persistence Layer

✓ Preprocessor Server

✓ Statistic Server

✓ Name Server

✓ Session and Transaction Manager

✓ XS Engine

✓ Data Provisioning in one single suite.

✓ Row store concept

The table needs to store a limited number of records.

When accessing one row at a time.

When all the record is accessed from the table.

✓ Column Store concept

Calculation is limited for a limited number of columns.

Searching the table with a limited number of columns.

Number of columns is very high.

Number of records in the table is very high.

✓ Parallel Processing.

✓ Limitations for Storage

✓ Data Types.

✓ SQL Statements.

Data Definition Language (DDL).

Data Manipulation Language (DML)

Transaction Control Language (TCL).

and much more...