DEMETER: Hardware-assisted database checkpointing
- Authors
- Oh, Hyeonseok; Jang, Hyeongwon; Kim, Jaeeun; Kim, Jongbin; Han, Hyuck; Kang, Sooyong; Jung, Hyungsoo
- Issue Date
- Mar-2020
- Publisher
- Association for Computing Machinery
- Keywords
- Database checkpointing; Near-data processing
- Citation
- Proceedings of the ACM Symposium on Applied Computing, pp.394 - 403
- Indexed
- SCOPUS
- Journal Title
- Proceedings of the ACM Symposium on Applied Computing
- Start Page
- 394
- End Page
- 403
- URI
- https://scholarworks.bwise.kr/hanyang/handle/2021.sw.hanyang/146034
- DOI
- 10.1145/3341105.3375756
- Abstract
- For the past four decades, database checkpointing has long been a major system activity triggering heavy I/O and leading to performance fluctuations. This is unpleasing to database systems pursuing good and steady performance on high-end computing platforms. Hence, commercial and open-source databases usually spawn massive page flushers to complete the required tasks with system disruptions being minimized. In this work, to reduce the hefty cost, we propose Demeter, designs for hardware-assisted database checkpointing that unbundles checkpointing by offloading the task of building new pages from physical changes onto storage devices equipped with near-data processing (NDP) capability. Demeter consists of two parts; a software component designed for generating physical updates without affecting foreground transactions and a hardware part constructing new pages from the changes. For evaluation, we have built a prototype system based on the Biscuit framework and integrated Demeter with MariaDB. Experimental results demonstrated that the Demeter-enabled engine substantially reduces the amount of I/O and its foreground transaction processing gains more throughput than the vanilla system under the OLTP workloads modifying a large volume of data pages.
- Files in This Item
-
Go to Link
- Appears in
Collections - 서울 공과대학 > 서울 컴퓨터소프트웨어학부 > 1. Journal Articles
![qrcode](https://api.qrserver.com/v1/create-qr-code/?size=55x55&data=https://scholarworks.bwise.kr/hanyang/handle/2021.sw.hanyang/146034)
Items in ScholarWorks are protected by copyright, with all rights reserved, unless otherwise indicated.