Revisiting SQL Statement Logging for SQLite on AWS S3

This paper presents SSL-S3, a novel approach that revisits SQL Statement Logging to fully exploit the newly introduced S3 append feature. When a transaction commits, SSL-S3 captures update SQL statements and appends them to S3. Unlike conventional physical logging such as Snapshot and Incremental logging, which incur redundant writes by storing physical data changes, SSL-S3 appends only update statements to S3. Our experimental results demonstrate that SSL-S3 outperforms Snapshot logging by up to 3.5×, and Incremental logging by 1.4×. Moreover, SSL-S3 reduces the recovery time by a factor of 5 compared to Incremental logging and by one-sixth compared to Snapshot logging.