Apr 4, 2016 9:40:00 AM by Guru99.com
SAP HANA stands for SAP’s High-Performance Analytic Appliance (HANA); it enables the processing of massive quantities of data in the main memory of the server in real time.
SAP is one of the largest ERP software and used by largest business organizations throughout the world. SAP system enables to store all the information they need and to perform all the business functions like managing customer's data, purchase orders, vendors data, manufacturing and so on. And SAP HANA is one of its module that handles data in real time. Some of the characteristics of SAP HANA are:
SAP HANA provides a single platform for integration of transactional data and analytical data in a single database. SAP HANA database is designed to run in main memory system making it more powerful and fast in comparison to traditional database system. Also, easy integration of SAP HANA with SAP application provides accelerated data processing for existing SAP application. It makes application hundred times faster by moving computation intensive processing logic from the application layer to the data layer. SAP HANA can be used in various places like
SAP HANA database architecture consists of multiple servers, in which the most important component or server is the Index server. SAP HANA contains Name server, Index server, Statistics server, Pre-processor server and XS engine.
Functions performed by each server
Usually, it remains a question in SAP HANA about, how to store data in the table? SQL queries that involve aggregation functions consume a lot of time on huge amounts of data because every single row is touched to collect the data for the query response. This information in columnar table is physically aligned next to each other, apparently increasing the speed of certain data queries.
In column arrangement, data is also compressed enabling shorter loading times. Column based table is usually recommended to store data as it allows fast aggregations, ad-hoc reporting and compression of data.
While, Row-based table is useful when application needs to only process a single record or row at one time.
In memory means, all data is stored straight away in the memory (RAM), there is no time wasted in loading the data from hard disk to RAM. Data is stored in the column as well as in row pattern; row is useful for Metadata while Column is useful for -10-20x Data Compression.
SAP HANA studio is an Eclipse Open Integrated Development Environment (IDE), that integrates different tools in a unified environment for data modeling activities, data and life cycle management and security. SAP HANA STUDIO can be used to start services, stop services, monitor system, configure system settings, manager users and authorization, manage tables and manage stored procedures. Let see some of the important components of SAP HANA studio.
For reporting and analysis of business data, it requires replication of the data from a source system to the SAP HANA database. In SAP HANA, data is replicated while transferring to the memory database. It can be done in two ways Application layer and Log file.
Log-Based Replication or Sybase Replication: This replication is based on the capturing table that changes from low-level database log files. Database changes are propagated on a per database transaction basis, and they are then re-played on the SAP HANA database. This method is based on database dependent. The replication agent uses table meta-data from the database to connect or link the raw log information with the existing table names.
SAP HANA offers different connectivity options such as BICS, MDX and SQL, etc. It runs JDBC and ODBC drivers which are standardized programming interfaces to access relational databases. Multidimensional expressions or MDX is an extensive query language for OLAP databases. Different front end can connect to HANA, and SAP suggest using frontends of the SAP business objects BI suite.
In SAP HANA, cloud platform is the platform-as-a-service offering available for SAP HANA. SAP HANA can be connected to cloud platform in two possible ways
SAP HANA cloud connectivity service is used to establish the technical connectivity for point to point integration or in combination with process integration solutions. SAP HANA cloud can be connected through Remote Service, On-premise Network and E-mail Provider.
In SAP HANA, database is stored in the file system of the operating system. SAP HANA uses the secure store in the file system (SSFS) to store all internal SAP HANA encryption keys. These keys are encrypted with the SSFS master key. The encryption key always remains with customer and responsible for decrypting, uncompressing and loading data into their SAP HANA DB services.
Actions performed in SAP HANA can be audited.
Actions that are audite
Content originally published at: http://www.guru99.com/sap-hana-tutorial.html
Written by Guru99.com
Guru99 is totally new kind of learning experience Here you learn by practice. We make tons of efforts to take boredom out of learning and make education a fun experience. Inside, you will find tons of video tutorials