NVDIMM-N Persistent Memory and its Impact on Two Relational Databases

The architecture of Database Management Systems (DBMS) is closely related to the characteristics of the storage hierarchy, because durability and response time are highly dependent on the physical properties of the target storage. Main memory volatility requires a DBMS to provide durability by software means as data continuously moves between volatile memory buffers and input/output persistent media. In traditional storage systems applications use complex concurrency control schemes to reduce latency and increase throughput and in order to utilize multicore hardware and shared system resources. New persistent memory (PM) devices emerging in the last decade, such as PCM, RRAM and MRAM, exhibit near-DRAM speed and characteristics, provide data persistence, and could be game changing for storage bound applications. In this paper we focus on benefits of persistent memory and their impact on database management systems. We consider methods for application speedup that are applicable to DBMSs that use PM. These optimization methods depend on the characteristics of PM storage. We consider concurrency and mutual resource contention, explore and rethink major application components, and finally combine static code optimization. Running the on-line transaction processing (OLTP) workload, the DBMSs explored here show performance gains relative to traditional storage systems by a factor of 3.17 and 1.79 for PostgreSQL and SQLite respectively.