A log-structured buffer for database systems using non-volatile memory
- Authors
- Son, Y.; Kang, H.; Yeom, H.Y.; Han, H.
- Issue Date
- Apr-2017
- Publisher
- Association for Computing Machinery
- Keywords
- Database system; Flash-based SSD; Non-volatile memory
- Citation
- Proceedings of the ACM Symposium on Applied Computing, v.Part F128005, pp 880 - 886
- Pages
- 7
- Journal Title
- Proceedings of the ACM Symposium on Applied Computing
- Volume
- Part F128005
- Start Page
- 880
- End Page
- 886
- URI
- https://scholarworks.bwise.kr/cau/handle/2019.sw.cau/60831
- DOI
- 10.1145/3019612.3019675
- ISSN
- 0000-0000
- Abstract
- Emerging next-generation non-volatile memory (NVM) technologies, including PCM and STT-MRAM, provide low latency, high bandwidth, non-volatility, and high capacity. Recently, NVM has drawn much attention from the database community to improve transaction processing (e.g., writeahead logging). As a complement to existing work, we investigate NVM for atomic page updates in database systems. Atomic page update is required for consistent recovery, and database systems generally use redundant writes to support atomic page update (e.g., doublewrite buffer in MySQL/InnoDB). However, redundant writes negatively affect the database and lifetime of storage devices (e.g., flashbased SSD). In this paper, we present LSBM, a log-structured buffer manager which updates pages atomically and efficiently using NVM. LSBM updates pages in an out-of-place manner to achieve atomicity and performs page buffering to improve performance. LSBM also reclaims the buffered pages on the fly to reduce the write traffic to storage. We implement LSBM using an NVDIMM as NVM and ported it to MySQL/InnoDB. The experimental results demonstrate that LSBM improves database performance and reduces write traffic on OLTP workloads.
- Files in This Item
-
- Appears in
Collections - College of Software > School of Computer Science and Engineering > 1. Journal Articles
Items in ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.