Fundamentals of SAP HANA Relational Database


In HANA You can build a database as Relational Database or Informational Models

HANA as a  Relational Database:
SAP HANA is a relational database whose tables can be stored in memory in a columnar format. This 
particular storage method is completely transparent for the designer who will see the usual logical 
representation of tables as rows and columns of data.  As a normal relational database, HANA, has the concepts of tables, joins, keys and SQL views (not to be confused with OLAP views but called HANA information models. HANA can be accessed via ODBC and JDBC drivers and its tables can be defined and queried with SQL language. Tables are managed with a tool called HANA Studio.

Hana Relational Database

HANA as Informational Model
In HANA, it is possible to build business or calculation models on the tables. These models are called 
Information models and they are also known under the name of "column views", "HANA views", "HANA 
models" or “HANA cubes”.  These models can provide a dimensional representation of the data in HANA 
and, in some circumstances, can be compared to OLAP cubes.  

Hana Information Model






Tags: HANA Cubes, HANA Information Models, HANA relational Database,Fundamentals of SAP HANA Relational Database , HANA Engines, OLAP engine, calculation engine, JOIN engine, SQL, to R and L languages used for statistical and predictive analysis, 




Share this article :

Post a Comment

 
Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved