Blog RSS Feed
Via E-mail
Twitter
Facebook
Hana Admin Modern Database for Modern Hardware
It is therefore apparent that traditional databases do not always make the most efficient use of current hardware. So, what are the ideal characteristics of a database system running on modern hardware?
In-memory database
All relevant data should be available in main memory, which avoids the performance penalty of disk I/O.
To use the advantages of in-memory computation, a cache-conscious implementation of data structures and algorithms is necessary.
Support for parallel execution
Higher CPU execution speeds are currently achieved by adding more cores to a CPU package.
Multiple CPUs call for new parallel algorithms to be used in databases in order to fully utilize the computing resources available. SAP HANA addresses these requirements by storing all of its data in RAM and also enabling queries to be split and optimized across multiple CPU cores and multiple SAP
HANA servers.
Disk storage
Disk storage is still required to ensure the ability to restart in case of power failure and for
permanent persistency. However, this is not a performance issue as the required disk write
operations can be performed asynchronously as a background task.
SAP HANA database tries to optimize the performance from the different storage types, like main memory, solid state disks (SSD), and traditional mechanical hard drives (HDD).
full course details please visit our website www.magnifictraining.com
Duration for course is 30 days or 45 hours and special care will be taken. It is a one to one training with hands on experience.
* Resume preparation and Interview assistance will be provided.
For any further details please contact +91-9052666559 or
visit www.magnifictraining.com
please mail us all queries to info@magnifictraining.com
It is therefore apparent that traditional databases do not always make the most efficient use of current hardware. So, what are the ideal characteristics of a database system running on modern hardware?
In-memory database
All relevant data should be available in main memory, which avoids the performance penalty of disk I/O.
To use the advantages of in-memory computation, a cache-conscious implementation of data structures and algorithms is necessary.
Support for parallel execution
Higher CPU execution speeds are currently achieved by adding more cores to a CPU package.
Multiple CPUs call for new parallel algorithms to be used in databases in order to fully utilize the computing resources available. SAP HANA addresses these requirements by storing all of its data in RAM and also enabling queries to be split and optimized across multiple CPU cores and multiple SAP
HANA servers.
Disk storage
Disk storage is still required to ensure the ability to restart in case of power failure and for
permanent persistency. However, this is not a performance issue as the required disk write
operations can be performed asynchronously as a background task.
SAP HANA database tries to optimize the performance from the different storage types, like main memory, solid state disks (SSD), and traditional mechanical hard drives (HDD).
full course details please visit our website www.magnifictraining.com
Duration for course is 30 days or 45 hours and special care will be taken. It is a one to one training with hands on experience.
* Resume preparation and Interview assistance will be provided.
For any further details please contact +91-9052666559 or
visit www.magnifictraining.com
please mail us all queries to info@magnifictraining.com
