SAP HANA Platform vs. Disk-Based Database with In-Memory Cache
YES - Because all hot data is automatically in-memory.
Since SAP HANA Platform maintains data in-memory by default, data can be aggregated on-the-fly along any dimension, without requiring indexes, pre-aggregates or materialized views. As a result, SAP HANA can not only return aggregates in real time but also allow users to drill down to any level of detail to analyze data. With SAP HANA, users can analyze data at any level of granularity in a self-service manner and obtain results in real-time.
Disk-Based Database with In-Memory Cache
NO - Because only pre-selected data is copied in-memory
Users are limited in the granularity of their real-time data analysis since disk-based databases are architected to manage data on disk and use a combination of add-on in-memory caches, indexes, pre-aggregates and materialized views to accelerate performance. For better performance the DBA has to duplicate data on in-memory caches and create data structures for data on disk before users can perform drill-downs. Additionally, if the size of the in-memory cache cannot accommodate all the required data, the DBA has to resize the system and potentially restart it.
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.