arXivDaily arXiv每日学术速递 周一至周五更新
arXiv 2303.18142cs.DB
收藏

Shirakami:一种用于Tsurugi关系数据库系统的混合并发控制协议

Shirakami: A Hybrid Concurrency Control Protocol for Tsurugi Relational Database System

Keio University(庆应义塾大学);NAUTILUS Technologies, Inc(NAUTILUS科技有限公司);Cybozu Labs, Inc(Cybozu实验室有限公司)

Takayuki Tanabe, Shinichi Umegane, Suguru Arakawa, Ryoji Kurosawa, Takashi Hoshino, Hideyuki Kawashima, Masahiro Tanaka, Takashi Kambayashi

AI总结:

Shirakami结合长读写事务的多版本视图可串行化和短事务的Silo,实现稳定性能,实验显示其比PostgreSQL快7.9倍,比Shirakami-OCC吞吐量高680倍。

摘要:

Bill-of-materials和电信计费应用需要同时处理短和长的读写事务。最近的研究很少涉及此类变化的工作负载。为了解决这些工作负载,我们提出了一种新的并发控制协议,Shirakami。Shirakami是一种混合协议。第一个协议,Shirakami-LTX,是基于多版本视图可串行化的长读写事务。第二个协议,Shirakami-OCC,是基于Silo的短事务。Shirakami自然地集成了写入保护和基于纪元的同步。它不需要动态协议切换,并提供了稳定的性能。我们实现了Shirakami作为Tsurugi系统的事务处理模块,这是一个生产级的关系数据库系统。实验结果表明,Tsurugi至少比PostgreSQL快7.9倍,而Shirakami-LTX的吞吐量比Shirakami-OCC高680倍。

英文摘要:

Bill-of-materials and telecommunications billing applications need to process both short 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 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 was at least 7.9x faster than PostgreSQL, and Shirakami-LTX exhibited 680x higher throughput than Shirakami-OCC.

机构、总结、中文摘要均由AI分析而来,可能存在错误,请以论文正文为准。

↑