A New Cache Management Approach for Transaction Processing on Flash-Based Database

Database is an important part of web information system, the IO performance of which is a key factor of the responsiveness of the whole system. Existing databases usually adopt magnetic disks as storage devices. Now, low IO performance of magnetic disks becomes the bottle neck to the performance of the entire web information system. Flash memory, as a new electronic storage device, has high read/write performance when compared with magnetic disk. However existing disk-based databases can not take full advantage of flash memory, especially transaction processing because of the special characteristics of flash memory. Based on analysis of mismatch between "stealing page" and "not force page" in traditional transaction processing and flash memory, this paper proposes a new cache management mechanism for transaction processing. The average access time (AAT) and log-based write of our method are proposed to enhance the IO performance. Our method can not only eliminate the problems of traditional databases on SSD, but also make full use of flash memory to achieve higher IO performance for transaction processing. Besides the improvement of IO performance, our method can also extend the life span of flash memory and maintain wear-levering. The experiments show high efficiency of our method.