A Buffer Based Scheme for SQLite on NAND Flash Memory

Abstract

Recently, SQLite is the popular database on smart phone which uses NAND flash memory to store data. Although SQLite is a lightweight and powerful database engine and NAND flash memory is very fast, the performance of SQLite is downgraded by physical limitation of flash memory such as erase-before-write characteristic. Whenever updating data, SQLite has to create or write back up data to a file called Journal file. This causes a lot of flash memory operations leading to reduction of overall performance of SQLite. To address this problem, this study introduces a buffer based scheme for SQLite on flash memory by using FRAM, called BBS. BBS can minimize the overhead by deploying the hybrid storage of FRAM and NAND flash memory. The experimental results show that BBS yields a good performance and improves the reliability.