SAP HANA Platform vs. Disk-Based Database with In-Memory Cache
YES - Because all hot data is automatically in-memory.
SAP HANA Platform is architected to manage data in-memory by default. Applications are automatically accelerated because the data they need is readily available in-memory. Additionally, both planned and unplanned questions are answered in real-time and drill-downs along any dimension are possible without additional DBA intervention. No data copies, indexes, pre aggregates or materialized view are required to deliver real-time performance.
Disk-Based Database with In-Memory Cache
NO - The database must be periodically reconfigured. More questions = More DBA time
Disk-based databases are architected to manage data on disk and use add-on in-memory caches and other data structures to accelerate performance. Before users can analyze data along new dimensions, DBAs need to configure and tune the database to ensure acceptable response times. This might involve copying data to the in-memory cache, dropping or creating new indexes, or creating materialized views. Some of these actions might negatively affect the performance of other applications and thus require additional tuning. For example, the time required to update indexes can slow down transactional applications.
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.