Tuesday, August 6, 2013

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 .............

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.