[Colloquium] Riki Otaki MS Presentation/Mar 10, 2025

[via Colloquium]

This is an announcement of Riki Otaki's MS Presentation
===============================================
Candidate: Riki Otaki

Date: Monday, March 10, 2025

Time:  3 pm CST

Location: JCL 298

Title: Bridging In-Memory and On-Disk Transaction Processing: Buffer Pool Management, Advanced Indexing, and the LIPAH Optimization

Abstract: This thesis presents an in-depth exploration of transactional processing techniques across different storage paradigms. We begin by reviewing the foundations of in-memory and on-disk transaction processing, and then illustrate key supporting technologies such as buffer pool management and advanced indexing structures like the Foster B-tree. The study further examines concurrency control strategies, contrasting optimistic and pessimistic latching approaches. Building on these insights, our proposed method, LIPAH, demonstrates a novel approach to reducing overhead in on-disk environments by skipping unnecessary indirections. This integrated analysis not only clarifies the operational trade-offs inherent in current systems but also highlights LIPAH's potential to enhance performance and scalability in modern database architectures.

Advisor: Aaron Elmore

Committee: Raul Castro Fernandez, Sanjay Krishnan, Aaron Elmore