View Modeling in SAP HANA
When using SAP HANA, you can calculate the outcome of your business directly, on the original data, in the main memory, without any need to transfer the data. Many of these calculations can be graphically modeled as special data views in SAP HANA Studio, without the need of any supplementary code. This paper focuses on the options that SAP HANA makes available for data modeling. These options lie at the core of the development process which produces HANA applications. The business data of a given field are memorized (usually in a normalized format) in tables from the database, which are connected via a foreign key (the so-called entity-relationship model). With the help of this data model, unique registrations can easily be made, selected or modified. Nevertheless, if the access to the data becomes more dynamic and complex, or if certain analyses or checks are necessary, the data needs to be transformed.