SAP HANA, short for “High-Performance Analytic Appliance” is an in-memory;
column-oriented, relational database management system developed by SAP.
Data
now resides in main-memory (RAM) and no longer on a hard disk.
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.
It’s
best
suited for performing real-time analytics on massive data, and
developing & deploying real-time applications.
An
in-memory database means all the data is stored in the memory (RAM). No time
wasted in loading the data from hard-disk to RAM or storing the data in
hard-disk. Everything is stored inside memory for all the time, which gives
quick access ability to the CPUs while processing data.
The
SAP HANA database is developed in C++ and runs on SUSE Linux Server. SAP HANA database consists of multiple servers and
the most important component is the Index Server which contains SQL/MDX
processor to handle query statements for database. (Learn to write queries from
SQL Server training by Learn IT
Training)
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.
SAP
HANA is equipped with Multiengine Query Processing Environment which supports
relational as well as graphical and text data within the same system. It
provides features that support significant processing speed, handle huge data
sizes and text mining capabilities.
Why SAP HANA is fast?
SAP
HANA is an in-memory database which means all the data resides in RAM. But there
is also a disc memory just for backup purpose.
With
the help of technology like SLT replication, data can be moved to HANA in real
time. It is also possible to copy data from SAP BW or other database into SAP
HANA. You can avail SAP BW training
from Learn IT Training.
In-memory
computing is safe: The SAP HANA database holds the bulk of its data in memory
for maximum performance, but still uses persistent storage to provide a
fallback in case of failure.
After
a power failure, the database can be restarted like any disk-based database and
returns to its last consistent state by replaying the log since the last save
point.
Learn
IT Training is resource of all IT technology online courses providing training
throughout India, USA, UK, Newzealand, Canada and many other countries. We
impart technology which takes you to improved performance and focus on growth
and innovation.
Register here with us to get a free
demo
For
more details visit: www.learnittraining.com
Email: contact@learnittraining.com
Contact: India +91 9912989639
USA +12108585008
USA +12108585008
Comments
Post a Comment