DEMETER: Hardware-assisted Database Checkpointing
- Title
- DEMETER: Hardware-assisted Database Checkpointing
- Author
- 정형수
- Keywords
- database checkpointing; near-data processing
- Issue Date
- 2020-03
- Publisher
- ACM
- Citation
- SAC '20: Proceedings of the 35th Annual ACM Symposium on Applied Computing, Page. 394-403
- 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.
- URI
- https://dl.acm.org/doi/10.1145/3341105.3375756https://repository.hanyang.ac.kr/handle/20.500.11754/162003
- ISBN
- 978-1-4503-6866-7
- DOI
- 10.1145/3341105.3375756
- Appears in Collections:
- COLLEGE OF ENGINEERING[S](공과대학) > COMPUTER SCIENCE(컴퓨터소프트웨어학부) > Articles
- Files in This Item:
There are no files associated with this item.
- Export
- RIS (EndNote)
- XLS (Excel)
- XML