Shirakami: A Hybrid Concurrency Control Protocol for Tsurugi Relational Database System
Fuente:
arXiv
Salvato in:
| Autori principali: | , , , , , , , |
|---|---|
| Natura: | Preprint |
| Pubblicazione: |
2023
|
| Soggetti: | |
| Accesso online: | |
| Tags: |
Aggiungi Tag
Nessun Tag, puoi essere il primo ad aggiungerne!!
|
| _version_ | 1866915870185357312 |
|---|---|
| author | Tanabe, Takayuki Umegane, Shinichi Arakawa, Suguru Kurosawa, Ryoji Hoshino, Takashi Kawashima, Hideyuki Tanaka, Masahiro Kambayashi, Takashi |
| author_facet | Tanabe, Takayuki Umegane, Shinichi Arakawa, Suguru Kurosawa, Ryoji Hoshino, Takashi Kawashima, Hideyuki Tanaka, Masahiro Kambayashi, Takashi |
| contents | 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. |
| format | Preprint |
| id |
arxiv_https___arxiv_org_abs_2303_18142 |
| institution | arXiv |
| publishDate | 2023 |
| record_format | arxiv |
| spellingShingle | Shirakami: A Hybrid Concurrency Control Protocol for Tsurugi Relational Database System Tanabe, Takayuki Umegane, Shinichi Arakawa, Suguru Kurosawa, Ryoji Hoshino, Takashi Kawashima, Hideyuki Tanaka, Masahiro Kambayashi, Takashi Databases 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. |
| title | Shirakami: A Hybrid Concurrency Control Protocol for Tsurugi Relational Database System |
| topic | Databases |
| url | https://arxiv.org/abs/2303.18142 |