[dropcap]S[/dropcap]AP HANA stands for High Performance Analytical Appliance.
This flexible appliance (combination of hardware and software) runs independently of the data source and can be used to analyze large data volumes in real time within the main memory (in-memory technology).
Software Components of SAP HANA
SAP HANA Core components
SAP HANA database, SAP HANA Studio, SAP HANA Client, SAP HANA Application Function Libraries (AFL—an optional component).
Software for data replication
SAP LT Replication Add-on and Server, SAP HANA Direct Extractor Connection (DXC), SAP BusinessObjects Data Services.
Software for direct data preparation
SAP HANA Client Package for Microsoft Excel, SAP HANA User Interface for Information Access (INA), SAP HANA Information Composer.
Lifecycle management components
SAP Host Agent, Software Update Manager for SAP HANA, SAP Solution Manager Diagnostics Agent.
Structure of the above mentioned SAP HANA components
SAP HANA Database
As a full relational database, SAP HANA provides functions similar to other relational (“traditional“) databases that are supported by SAP. Like these traditional databases, SAP HANA provides functions for data backup and recovery, supports the SQL standard (SQL 92 Entry-Level and some SQL 99 extensions), and guarantees data consistency by following the ACID principle (atomicity, consistency, isolation, durability) when executing
In contrast to other relational databases, SAP HANA can place all relevant business data in the main memory. It combines row-, column-, and objectbased database technologies and was optimized for the usage of parallel processing functionality provided by modern hardware technologies.You can use multi-core and multi-CPU architectures to their fullest potential.The SAP HANA database provides its own programming language (SQLScript)
SAP HANA Studio
SAP HANA Studio is comprised of the administration and development environment.
Note: Eclipse and its Significance for SAP.
Eclipse is a platform for development tools and environments (e.g., for Java, C/C++, or PHP). It is maintained and further developed by the Eclipse Foundation (see http://eclipse.org).
In addition to SAP HANA Studio and the ABAP Development Tools for SAP NetWeaver, the following SAP development environments are based on Eclipse:
- SAP NetWeaver Developer Studio (Java)
- SAP Eclipse Tools for SAP HANA Cloud Platform
- SAP UI Development Tools for HTML5
- SAP NetWeaver Gateway Plug-in for Eclipse
One of the main advantages of the Eclipse platform is the ability to integrate different tools into one installation so that the user benefits from a homogeneous development environment.
SAP HANA Studio: Usage areas
Starting and stopping database services
- Monitoring the system
- Specifying system settings
- Maintaining users and authorizations
- Configuring the audit log
SAP HANA Client
Using the SAP HANA Client, you can connect to the SAP HANA database via a network protocol. The following standards are supported.
- ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) for SQL-based access
- ODBO (OLE DB for OLAP) for MDX-based access (multi-dimensional expressions).
As the Eclipse platform is Java-based, SAP HANA Studio uses the JDBC client to establish the connection. This variant is also used in Java-based application servers.
The SAP NetWeaver Application Server (AS) ABAP uses the so-called Database Specific Library (DBSL) (which is embedded in the SQLDBC client) to connect to the SAP HANA database.
Special BI clients (business intelligence), such as add-ins for Microsoft Excel, typically use MDX-based access for multi-dimensional queries that are executed via the ODBO client.
SAP HANA Function Libraries
The functional scope of SAP HANA can be extended using special function libraries (Application Function Libraries, AFL) written in C++. With the current release level SAP HANA SPS5, these libraries must be installed manually using the SAP HANA on-site configuration tool after installing the database.
SAP HANA currently provides two application function libraries:
- Business Function Library (BFL) with its own standard business functions, and
- Predictive Analysis Library (PAL) for data mining and predictions based on existing historical data.