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
2 comments:
Hi, sir I have seen your info on sap.. Especially on sap hana. The info you provided is very useful for any interested on sap. I am very much satisfied with your info. I wish I can get furthered info from you.I am very glad to say thanks for this info.thank you very much sir
sap hana admin online training
This SAP HANA ADMINISTRATION ONLINE TRAINING course not only gives an overview but provides you with a thorough in-depth knowledge about how the SAP HANA works.
sap bods online training
Post a Comment