Modern real-world transactional workloads such as bills of materials or telecommunication billing need to process both short transactions and long transactions. Recent concurrency control protocols do not cope with such workloads since they assume only classical workloads (i.e., YCSB and TPC-C) that have relatively short transactions. To this end, we proposed a new concurrency control protocol Shirakami. Shirakami has two sub-protocols. Shirakami-LTX protocol is for long transactions based on multiversion concurrency control and Shirakami-OCC protocol is for short transactions based on Silo. Shirakami naturally integrates them with write preservation method and epoch-based synchronization. Shirakami is a module in Tsurugi system, which is a production-purpose relational database system.
翻译:现代现实世界中的事务处理工作负载(如材料清单或电信计费)需要处理短事务和长事务。最近的并发控制协议并不适用于这样的工作负载,因为它们假设只有经典工作负载(即 YCSB 和 TPC-C),这些工作负载具有相对较短的事务。为此,我们提出了一种新的并发控制协议 Shirakami。 Shirakami 有两个子协议。 Shirakami-LTX 协议用于基于多版本并发控制的长事务,Shirakami-OCC 协议用于基于 Silo 的短事务。 Shirakami 自然地将它们与写保护方法和基于 epoch 的同步集成在一起。 Shirakami 是 Tsurugi 系统中的一个模块,这是一个面向生产目的的关系型数据库系统。