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-LTX,以及基于Silo的短事务协议Shirakami-OCC。通过写保留策略与基于周期的同步机制,Shirakami自然实现了两者的整合。作为生产级关系数据库系统Tsurugi的模块,Shirakami已集成于该系统中。