Before creating a new SAP HANA modeling artifact it is of paramount importance to know which types of modeling artifacts will be suitable for our business need. Depending on the scenario you are working in, your choice might vary. Factors that should be taken into consideration are:
The write- or read-intensive scenario, so as to decide between column and row storage
Data access need and resources for the replication method available
The application or client to be supported with your information model as different clients expose/consume data differently
Performance and functionality, as not all views can give the same functionality or performance
The first thing we need to decide is do we need a column table or row store. Once we have decided, we can have a glance at the following table and choose the views, if our requirement can be fulfilled by any of these:
|
Column table |
Analytical view |
Calculation view (SQL) |
Calculation view (CE function ) | |
|---|---|---|---|---|
|
Scenario... |