Basics of SAP HANA
SAP HANA is a combination of HANA Database, Data Modeling, HANA Administration and Data Provisioning in one single suite. In SAP HANA, HANA stands for High-Performance Analytic Appliance.
According to former SAP executive, Dr. Vishal Sikka, HANA stands for Hasso’s New Architecture. HANA developed interest by mid-2011 and various fortune 500 companies started considering it as an option to maintain Business Warehouse needs after that.
SAP HANA DATABASE
SAP HANA is an in-memory database. Firstly, all the data is stored in memory (RAM) and not on a hard disk that helps CPU quick access to data for processing operation. Secondly, it is best method for deploying and developing real time applications or analytics. Moreover, it is a combination of row-based and column-based database technology. SAP HANA supports relational, graphical and text data because it is equipped with multiengine query processing environment.
Hardware Partners of SAP HANA
SAP HANA is a combination of hardware and software and to leverage the full power of SAP HANA, right hardware infrastructure is needed.
Following are the hardware partners of SAP HANA:
SAP HANA Architecture
SAP HANA Database is developed in C++ and runs on SUSE Linux Enterprise Server. The most important component is the Index Server and it consists of many other servers as well such as Name server, Pre-processor server, Statistics server. Index Server contains the actual data stores and engines for processing the data. XS engine is an optional component which allows the users to access SAP HANA system via HTTP.
SAP HANA Studio
SAP HANA Studio is based on integrated development environment (IDE) that develops artifacts in a HANA server. It is also helpful for technical users to manage SAP HANA database for creating or managing user authorizations. It is utilized by system administrators and developers to configure system setting, monitor the system, to start/stop /security of servers and users and create data models, tables, Java Script, HTML.
SAP HANA Modelling
SAP HANA data modelling is also known as the heart of HANA application development. Modelling views can be create on top of database tables and consumed via JAVA, HTML based applications, SAP HANA native applications. Moreover, SAP tools like SAP Lumira or analysis office are also used to connect with HANA and report modelling views. Attribute, Analytic and Calculation are three modelling views that make implicit use of optimized SAP HANA in memory calculation engines at run time and give better performance.
SAP HANA Reporting
After creating all the modelling views, users can see the output in HANA Studio. It is non-technical end users that are consuming the modelling views to visualize various business scenarios. So, we need different reporting tools which can connect to SAP HANA, take data from modelling views and make it understandable. Reporting can be done in SAP HANA business objects BI suite of applications, tools that create and consume MDX data and queries and Microsoft Excel.