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.
Cite
@article{arxiv.2303.18142,
title = {Shirakami: A Hybrid Concurrency Control Protocol for Tsurugi Relational Database System},
author = {Takayuki Tanabe and Shinichi Umegane and Suguru Arakawa and Ryoji Kurosawa and Takashi Hoshino and Hideyuki Kawashima and Masahiro Tanaka and Takashi Kambayashi},
journal= {arXiv preprint arXiv:2303.18142},
year = {2026}
}