S-Space College of Engineering/Engineering Practice School (공과대학/대학원) Dept. of Computer Science and Engineering (컴퓨터공학부) Theses (Master's Degree_컴퓨터공학부)
An Efficient Protection of Partial Page Update and Buffer Scheme in a Database System Using Non-Volatile Memory
비휘발성 메모리를 사용한 데이터베이스의 효율적인 부분 페이지 갱신 방지 및 버퍼 기법
- 공과대학 컴퓨터공학부
- Issue Date
- 서울대학교 대학원
- databases ; partial page update ; page buffer scheme ; non-volatile memory ; redo logging ; I/O
- 학위논문 (석사)-- 서울대학교 대학원 : 컴퓨터공학부, 2016. 8. 염헌영.
- In this paper, we present an e cient approach that exploits persistence, fast data access and byte-addressable properties of non-volatile memory (NVM) to protect partial page update and improve transaction performance on ash SSD- based databases. Our scheme is to unify the protention scheme for partial page update (e.g., doublewrite in InnoDB and full-page write in PostgreSQL) and page bu er scheme for read/write operations with several optimizations using NVM to reduce SSD I/Os and related lock contention. In addition, we place redo log bu er on NVM to remove further I/O overhead for better performance. We implemented our scheme in MySQL InnoDB on an NVDIMM server and improved transaction performance 4X and endurance 3X on OLTP workload compared to the existing scheme.