Doug Hood (Oracle)
The reality of using Intel Optane persistent memory with a SQL In-Memory Database
Everybody wants faster access to their data, but DRAM is expensive and limited in size. Persistent memory promises larger capacity at a cheaper price point, but with a higher latency than DRAM.
This talk investigates how Intel Optane persistent memory used in both App Direct Mode and Memory Mode works with the Oracle TimesTen In-Memory Database.
SQL benchmarks based on customer workloads are used to measure persistent writes, database load times and latency/throughput. The effects of cache hit ratios, concurrency and reads vs writes are considered.
As a developer and product manager for an In-Memory database, persistent memory is a big deal.
Understanding the engineering tradeoffs for DRAM, PMem, NVMe storage and RDMA are critical for design and execution of the worlds fastest databases.
Benchmarking technologies like Intel Optane persistent memory with customer workloads reveals the reality of these technologies beyond the marketing hype.
Doug is an evangelist for Oracle TimesTen In-Memory Database, Oracle In-Memory and Oracle NoSQL.