SAP HANA

SAP HANA:

SAP HANA converges database and application platform capabilities
in-memory to transform transactions, analytics, text analysis, predictive and spatial processing so businesses can operate in real-time.

The Below Articles will helps for HANA learning.

HANA Start up and Initial setup 

HANA Database Schemas and Database Tables 




Look here for more Article .............

Read More

HANA Database Schemas and Database Tables

HANA Database Schemas and Database Tables

The below artifacts are major part of the SAP HANA Database.

Schemas

Tables

SQL views

Sequences

Procedures and Etc….

Schema:

The schema contains the logical group of Database objects and it is the mandatory database object in the HANA and all database objects below to schema. So below establish to develop any database artifacts we need to create schema.

Data base objects are like a

Tables

Views

Procedures

Sequences

…

  

Steps to create Schema:

Go to Project Explorer - > Right click -> New -> File and it brings the pop up

Provide the schema name with the extension of the “.hdbschema” and Click Finish Button. It creates new window in HANA management studio to provide the syntax to provide schema.

Issue the command schema_name = “WORKSHOPA_00”;

Save the File.

Right click on the schema name and issue the Commit and Activate it.

Read More