Introduction To SAP HANA Database- For Beginners

SAP HANA

SAP HANA is an in-memory database:

– It is a combination of hardware and software made to process massive real time data using In-Memory computing.
– It combines row-based, column-based database technology.
– Data now resides in main-memory (RAM) and no longer on a hard disk.
– It’s best suited for performing real-time analytics, and developing and deploying real-time applications.

An in-memory database means all the data is stored in the memory (RAM). This is no time wasted in loading the data from hard-disk to RAM or while processing keeping some data in RAM and temporary some data on disk. Everything is in-memory all the time, which gives the CPUs quick access to data for processing.

The speed advantages offered by this RAM storage system are further accelerated by the use of multi-core CPUs, and multiple CPUs per board, and multiple boards per server appliance.

Complex calculations on data are not carried out in the application layer, but are moved to the database.

SAP HANA is equipped with multiengine query processing environment which supports relational as well as graphical and text data within same system. It provides features that support significant processing speed, handle huge data sizes and text mining capabilities.

SAP HANA Architecture

SAP HANA Architecture