Tuesday, July 26, 2016

Ask Approyo: Can I simplify my IT landscape with an in-memory solution?

SAP HANA Platform vs. Disk-Based Database with In-Memory Cache

SAP HANA
YES - One copy of data for all requests

SAP HANA Platform simplifies IT landscapes by taking advantage of in-memory computing and by delivering application, database and integration services in one platform. By taking advantage of in-memory computing, it can efficiently process transactions,streams, graphs and advanced analytics, such as predictive, spatial and text, on the same system and on one copy of the data. Additionally, by delivering application, database and integration services in one platform, it reduces data movements and staging among operational systems and between database and application server. This results in better performance, a simplified IT infrastructure and lower administration costs.

Disk-Based Database with In-Memory Cache
NO - Multiple copies of data needed for different requests

Since disk-based databases are designed to manage data on disk, in-memory caches are deployed to accelerate data access.This involves the introduction of an additional technology layer as well as the synchronization and maintenance of multiple copies of data. As a result, the consumption of system resources, the burden of system administration and the complexity of the IT infrastructure increases

See the Benefits of SAP HANA today with Approyo!
Approyo can help your company deal with the changing world. Our SAP HANA and Big Data solutions address these important questions and more. Let us show you today! Set up a free consultation today.

 

Tuesday, July 19, 2016

Ask Approyo: Do my SAP Applications run better and faster on an in-memory platform?

SAP HANA Platform vs. Disk-Based Database with In-Memory Cache

SAP HANA
YES - SAP applications are optimized to run on SAP HANA.

Business logic resides inside the database

SAP HANA platform enables data-related business logic to run inside the database and provides a wealth of advanced business function libraries, algorithms and services to correlate and analyze data efficiently. SAP HANA also provides easy to use modeling capabilities to automatically push application logic to the database. SAP Business Suite takes full advantage of these capabilities, delivering increased performance.

Disk-Based Database with In-Memory Cache
NO - Performance needs to be tested on acase-by-case basis

SAP Business Suite runs efficiently on the leading RDBMSs,however, it has not been specifically optimized for any given RDBMS. At present, SAP Business Suite is not certified to run on the different RDBMSs with in-memory caches and performance on these extensions needs to be verified on a case-by-case basis.

See the Benefits of SAP HANA today with Approyo!
Approyo can help your company deal with the changing world. Our SAP HANA and Big Data solutions address these important questions and more. Let us show you today! Set up a free consultation today. 


Tuesday, July 12, 2016

Ask Approyo: Am I able to run my business in real time, with all my data in-memory, ready for processing with SAP HANA?

SAP HANA Platform vs. Disk-Based Database with In-Memory Cache

SAP HANA
YES - Because SAP HANA is designed to manage data in-memory.
​​
Future-proof – designed to run business at the speed of memory

SAP HANA in-memory Platform maintains one data copy for both transactional and analytical workloads. All data is in a compressed, columnar format to maximize access speed and the amount of data managed in-memory. Using the dynamic tiering capability, rarely accessed data can also be maintained on disk-based, columnar tables. Access to this data remains fast because it can be moved to memory for processing without being reorganized. In this way, SAP HANA can manage databases of any size without being limited by the amount of available memory in a system.

Disk-Based Database with In-Memory Cache
NO - Because the solution is designed to manage data on disk.

Business innovation is limited by the speed of the disk

Disk-based databases are architected to manage data on disk and use caches and other data structures to accelerate data access. In this way the disk latency can be mitigated but not eliminated because the core engine has been optimized to manage data that reside on disk and cannot function if the data is not maintained in it. While analytical workloads on cached data can be processed without accessing the disk, transactional
workloads always require disk access.

See the Benefits of SAP HANA today with Approyo!
Approyo can help your company deal with the changing world. Our SAP HANA and Big Data solutions address these important questions and more. Let us show you today! Set up a free consultation today. 

Tuesday, July 5, 2016

Ask Approyo: Can my application provide analytics while updating the same copy of data in real time with SAP HANA?

SAP HANA Platform vs. Disk-Based Database with In-Memory Cache

SAP HANA
YES - Transactions and queries performed on same data in-memory

SAP HANA Platform is an ACID, persistent, in-memory, columnar database that accelerates both queries and transactions using one data copy, in-memory. SAP HANA column table’s temporary delta store makes it efficient to process high-speed transactions. With SAP HANA Platform, applications can execute transactional and analytical workloads in parallel while preserving data integrity and system performance.

Disk-Based Database with In-Memory Cache
NO - The in-memory cache is not a database, it is just a read-only cache.

Disk-based databases with an in-memory cache typically process transactions (update, insert or delete operations) on disk and then update the data in the in-memory cache to ensure read consistency. Applications that perform both transactions and queries would have to wait for transactions to complete on disk before accessing the updated data in the cache. Since disk access is much slower than memory access these applications will experience delays.

See the Benefits of SAP HANA today with Approyo!
Approyo can help your company deal with the changing world. Our SAP HANA and Big Data solutions address these important questions and more. Let us show you today! Set up a free consultation today.