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.

翻译：物料清单与电信计费应用需要同时处理短事务与长读写事务。近期研究鲜少关注此类动态演化的负载类型。为应对此类负载，我们提出新型并发控制协议Shirakami。该协议采用混合架构：首个协议Shirakami-LTX基于多版本视图可串行化理论，专为长读写事务设计；次协议Shirakami-OCC基于Silo框架，面向短事务优化。通过写操作保持机制与基于周期的同步策略，Shirakami实现了两种协议的自然融合，无需动态协议切换即可提供稳定的性能表现。我们将Shirakami实现为Tsurugi系统的事务处理模块，该系统为生产级关系数据库系统。实验结果表明：Tsurugi的延迟较PostgreSQL降低19.7倍，且Shirakami-LTX的吞吐量达到Shirakami-OCC的680倍。