@article{MD0F40272,
title = "A Study on Buffer Management for Read-Once Pages Using a Read Buffer",
journal = "Journal of KIISE, JOK",
year = "2025",
issn = "2383-630X",
doi = "10.5626/JOK.2025.52.7.611",
author = "Seongjae Moon, Sang-Won Lee, Young Ik Eom",
keywords = "buffer management, solid-state drive, read-once page, I/O serialization",
abstract = "The relational database systems store pages in main memory to minimize storage access and improve transaction throughput. However, read-once pages, referenced only once before eviction, may force dirty pages to be flushed, reducing the page hit ratio. In SSD-based DBMS, read-once pages cause I/O serialization, forcing faster read operations to wait for slower write operations to complete. We analyze the I/O serialization caused by read-once pages and their characteristics, and propose a buffer management scheme to isolate read-once pages by using a read buffer. In the TPC-C benchmark, dirty pages evicted due to read-once pages account for about 8.9% of all flush operations. By isolating read-once pages into the read buffer, we reduced single page flushes by 56% and the page miss ratio in the normal buffer by 32% while increasing transaction throughput by 8% compared to Vanilla MySQL."
}