SAP HANA: High-Performance Analytic Appliance (HANA) is an In-Memory Database from SAP to store data and analyze large volumes of non aggregated transactional data in Real-time with unprecedented performance ideal for decision support & predictive analysis.
In this article we will discuss about the architecture overview of the In-Memory Computing Engine of SAP HANA. The SAP HANA database is developed in C++ and runs on SUSE Linux Enterprise Server. SAP HANA database consists of multiple servers and the most important component is the Index Server. SAP HANA database consists of Index Server, Name Server, Statistics Server, Preprocessor Server and XS Engine.
SAP In-Memory Appliance (SAP HANA) software is a flexible, multipurpose, data source agnostic in-memory appliance that combines SAP software components optimized on hardware provided and delivered by SAP’s leading hardware partners.
The SAP HANA studio is a collection of applications for the SAP HANA appliance software. It enables technical users to Manage the SAP HANA database, to Create and Manage User Authorizations, and to Create new or Modify existing Models of data in the SAP HANA database. It is a client tool, which can be used to access local or remote SAP HANA databases.
Information Models are multiple database views of transactional data stored in the physical tables of SAP HANA Database used for Analytical purposes. Analytical Data Modeling is only Possible For Column Tables i.e. Information Modeler only works with column storage tables.
In this article we will see how to design Information Models in SAP HANA Database. So first of all we will create a Package and then we will model Attribute, Analytic and Calculation Views.