Real Time Analytics with SAP HANA

Different modeling artifacts in SAP HANA

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