SAP HANA Platform vs. Disk-Based Database with In-Memory Cache
YES - SAP HANA stores data in memory first.
With SAP HANA neither specialized caches nor multiple data copies are needed. SAP HANA is architected to manage data in-memory by default and uses a columnar store to seamlessly run both analytics and transactions. Additionally, it uses CPU caches to work on compressed data, leverages multi-core processors to scan columns in parallel and uses SIMD instructions to simultaneously process multiple data sets, delivering unmatched performance without indexes or materialized views. Applications are automatically accelerated because the data they need is readily available in real-time, without DBA intervention.
Disk-Based Database with In-Memory Cache
NO - All data is on the disk by default.
Disk-based databases are architected to manage data on disk and use add-on in-memory caches to selectively accelerate access to portions of data. To accelerate applications, DBAs identify what data to accelerate and ensure it is duplicated in the appropriate in-memory cache. Additionally they maintain indexes and other data structures to ensure that performance of both transactional and analytical workloads is acceptable. The task is
daunting since it is often challenging to predict what data needs acceleration and to ensure mixed workload performance, which leads to extensive testing and tuning.
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.