Explain SAP HANA Database Concepts ?


SAP HANA database is a very capable database system but it requires some understanding, and to be 
used correctly, to obtain good performance. In this section we will explore some key concepts of the 
SAP HANA database. Also an analysis of how you can approach modeling to achieve good results is 
presented.


HANA Tables, Views, and Star Schemas:

The SAP HANA database allows you to model your data as tables and views.

Tables are tabular data structures, each row identifying a particular entity, and each column having a unique name. The data fields of one row are called the attributes of the entity. The word “attribute” is used with different meanings in this document. It may denote a table column, a particular data field of a table row, or
the contents of such a data field. The respective meaning will be clear from the context.

Views are combinations and selections of data from tables modeled to serve a particular purpose.
Views always appear like readable tables, i.e. database operations which read from tables can also be
used to read data from views. For instance, you can create views which simply select some columns
from a table, or views which select some columns and some rows according to a filter pattern.
Throughout this document the term schema or database schema is used frequently. The term
schema referrers to the structure of the database, its tables and the relationships between them as
described by the SQL used to define the database.


Star schemas are a general pattern: Fact tables are lists of business transactions while the linked-in data are typically master data. These linked-in tables are often called dimension tables. A fact table surrounded by its linked-in dimension tables is often called a star schema because when it is expressed graphically it appears to look like a star. In SAP HANA a star schema can be created using tables or views by surrounding an analytic or calculation view with attribute views.



Tags: HANA Database concepts, HANA Tables, Views, Schemas definitions, Hana Database tutorials, Hana analytics concepts, HANA Modeller views,


Share this article :

Post a Comment

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