Benchmarking In-Memory & On-Disk Databases with Hard-Disk, SSD and Memory-Tier NAND Flash
In-memory database systems (IMDSs) eliminate I/O latency associated with traditional on-disk database management systems (DBMSs), but some applications require a higher level of data durability. As a solution, IMDSs offer transaction logging, in which changes to the database are recorded on persistent media. But critics object that logging re-introduces the storage-related latency of on-disk DBMSs. Will an IMDS with transaction logging outperform a traditional DBMS? Will type of storage—hard disk drive vs. solid state drive vs. state-of-the-art memory-tier products—affect the results? The report answers these questions, with results using commercially available hardware including Fusion ioDrive2 NAND flash memory from Fusion-io.