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 a mixture of DRAM and persistent memory can benefit databases, specifically for read caching.
Intel Optane persistent memory comes in two flavours (Memory Mode and App Direct Mode). This talk looks at the experience of using both these modes for an In-Memory SQL database called Oracle TimesTen. Persistent memory is great, but it is not magic and you still need to make hard design choices.
We look at things like NUMA effects and how the ratio of DRAM to persistent memory affects latency and system capacity.
We also look at the cost/benefits of using large DRAM machines versus using clusters of persistent memory machines for read caching.
I fell in love with Oracle TimesTen In-Memory Database as it is a really fast, simple and highly available RDBMS.
I have worked as a consultant, developer and product manager at Oracle over the years. My technical interests are making things go fast [OCI, ODBC and PLSQL] and getting things to work together. I am a fan of Go and I am looking for a good PowerPoint LLVM compiler ...