TY  - JOUR
T1  - A Study on Buffer Management for Read-Once Pages Using a Read Buffer
AU  - Moon, Seongjae 
AU  - Lee, Sang-Won 
AU  - Eom, Young Ik 
JO  - Journal of KIISE, JOK
PY  - 2025
DA  - 2025/1/14
DO  - 10.5626/JOK.2025.52.7.611
KW  - buffer management
KW  - solid-state drive
KW  - read-once page
KW  - I/O serialization
AB  - 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.