Removing Double-Logging with Passive Data Persistence in LSM-tree Based Relational Databases

This course aims to teach learners how to address the double-logging problem in LSM-tree based Relational Databases by implementing a Passive Data Persistence Scheme (PASV). The course covers the background, key idea, challenges, solution, and conclusion of the proposed scheme. By the end of the course, students will have the skills to develop mechanisms for reliable and low-cost data persistence, improve system performance, increase throughput, reduce latency, save disk I/Os, and decrease recovery time. The teaching method involves presenting the theoretical concepts and practical implementation details of the PASV solution. This course is intended for individuals interested in storage engines, relational databases, LSM-trees, data persistence, and system performance optimization.