Can I achieve predictable response times for ad hoc queries with SAP HANA?
SAP HANA Platform vs. Disk-Based Database with In-Memory Cache
SAP HANA YES - Predictable response times
SAP HANA Platform maintains data in-memory by default, and all queries - planned and unplanned (ad-hoc) - have real-time access to the data they need and can return results in a predictable amount of time. It is possible to estimate response times using processors' scan speed, memory access time and size of data accessed by a query. SAP HANA also maintains one single copy of the data to be used for both analytical and transactional workloads, eliminating possible delays related to data synchronization and ensuring all queries are performed on fresh data.
Disk-Based Database with In-Memory Cache NO - No predictable response times
Disk-based databases are architected to manage data on disk and use add-on in-memory caches to accelerate access to portions of data. Only queries that exclusively access cached data can return results in a predictable time. All other queries experience delays because access times depend on parameters such as where the data is placed on disk, which indexes are used, and the number of parallel processes accessing the disk. Ad-hoc queries will experience unpredictable response times when some or all of the data required is available only on disk.
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.