Shirakami: A Hybrid Concurrency Control Protocol for Tsurugi Relational Database System
This addresses performance issues for database systems handling evolving workloads like bill-of-materials and telecommunications billing, though it is incremental as it builds on existing protocols like Silo and multiversion view serializability.
The paper tackles the challenge of processing mixed workloads of short and long read-write transactions in databases by proposing Shirakami, a hybrid concurrency control protocol, which in experiments showed Tsurugi with 19.7 times lower latency than PostgreSQL and Shirakami-LTX with 680 times higher throughput than Shirakami-OCC.
Bill-of-materials and telecommunications billing applications, need to process both short transactions and long read-write transactions simultaneously. Recent work rarely addresses such evolving workloads. To deal with these workloads, we propose a new concurrency control protocol, Shirakami. Shirakami is a hybrid protocol. The first protocol, Shirakami-LTX, is for long read-write transactions based on multiversion view serializability. The second protocol, Shirakami-OCC, is for short transactions based on Silo. Shirakami naturally integrates them with the write-preservation and epoch-based synchronization. It does not require dynamic protocol switching and provides stable performance. We implemented Shirakami as the transaction processing module of the Tsurugi system, which is a production-grade relational database system. The experimental results demonstrated that Tsurugi exhibited 19.7 times lower latency than PostgreSQL, and Shirakami-LTX exhibited 680 times higher throughput than Shirakami-OCC.