SAP HANA

[Former Member]

Introduction:

With the changing data management requirements, customers are looking for a data management system which can support complex business analytical processes and transactional workloads, traditional databases was very narrow for these heterogeneous, wide variety of interactive patterned applications. SAP HANA was able to provide database management services for specific needs of art of state applications.

SAP HANA stores all data in memory and in columnar format. SAP HANA is an in-memory platform and it is designed with latest hardware and in-memory technologies. SAP HANA also stores data into disk for backup so that in case of any disaster situation like failure /downtime the data can be restored from the tape backup.

SAP HANA can process unstructured, structured, text, text in binary files, streaming data etc. It is an integrated platform that can process almost all the data types. SAP HANA is designed to have columnar tables, advanced compression and can handle different workloads on single set of data; it can process large set of data very efficiently in the memory.SAP HANA uses advanced data compression methodology to store data in less space than its actual size. SAP HANA works on compressed data and avoids compression-decompression operations on the data. It does not require CPU cycles for redirecting workloads between disk and in memory stores and for synchronizing multiple data copies.

SAP HANA Appliance provides data management foundation for newly developed and renovated SAP apps. They provide real time data replication services and data transformation services to make the SAP and Non-SAP data movements easy to SAP HANA. They also provide Data modelling service with  SAP HANA as its core

Distinctive features of SAP HANA Database:

Multi-Engine query processing Environment:  SAP HANA Database Engine supports SQL querying to relationally structured data. Also it provides text search engine apart from query engine. Lastly, it has graph engine which supports to run graph algorithms to support planning and supply chain optimization etc.

Representation of app-Specific business objects: As opposed to classic relational databases, SAP HANA is able to give a deep understanding of underlying business objects in the application layer.

Using state-of-art hardware developments: SAP HANA database is built from scratch upto Execute parallel and main-memory centric environments.

Overview of Architecture:

SAP HANA has large capabilities of modern hardware like mutli-core CPU’s , large main memory.SAP HANA database has high-performance data storage and processing engines within HANA Appliances.Connection and session management can create and manage sessions/connections for database clients. Once a session has been established clients can use below languages like SQL,SQL script etc listed. The transaction manager controls the transactions and also controls trasactional isolation and keeps track of closed/open transactions.

The Optimizer and Plan Generator layer parses and optimizes the client requests. Based on optimized execeution plan execution engine invokes corresponding engines. SQL script and other supported languages are translated by corresponding compilers as Calculation models which are executed by Calculation engine. Authorization manager takes care of authorizing the users. Metadata manager manages SAP HANA metadata like tables, indexes,views etc

The Graph Engine supports the efficient representation and processing of data graphs with a flexible typing system.The Text Engine is used to provide text engine and search capablities like search for words and phrases.The Persitency layer is responsible for transactions durablity and atomicity.It is used to manage data and log volume on the disk and provide interfaces for writing and reading data that are influenced by all storage engines.