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.