Oze: Decentralized Graph-based Concurrency Control for Real-world Long Transactions on BoM Benchmark

10/09/2022
by   Jun Nemoto, et al.
0

In this paper, we propose Oze, a new concurrency control protocol that handles heterogeneous workloads which include long-running update transactions. Oze explores a large scheduling space using a fully precise multi-version serialization graph to reduce false positives. Oze manages the graph in a decentralized manner to exploit many cores in modern servers. We also propose a new OLTP benchmark, BoMB (Bill of Materials Benchmark), based on a use case in an actual manufacturing company. BoMB consists of one long-running update transaction and five short transactions that conflict with each other. Experiments using BoMB show that Oze keeps the abort rate of the long-running update transaction at zero while reaching up to 1.7 Mtpm for short transactions with near linear scalability, whereas state-of-the-art protocols cannot commit the long transaction or experience performance degradation in short transaction throughput.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
03/31/2023

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

Modern real-world transactional workloads such as bills of materials or ...
research
10/03/2018

Improving High Contention OLTP Performance via Transaction Scheduling

Research in transaction processing has made significant progress in impr...
research
03/07/2019

Scheduling OLTP Transactions via Machine Learning

Current main memory database system architectures are still challenged b...
research
09/13/2017

Accelerating Analytical Processing in MVCC using Fine-Granular High-Frequency Virtual Snapshotting

Efficient transactional management is a delicate task. As systems face t...
research
10/17/2019

MV-PBT: Multi-Version Index for Large Datasets and HTAP Workloads

Modern mixed (HTAP) workloads execute fast update-transactions and long-...
research
01/25/2023

Scheduling Space Expander: An Extension of Concurrency Control for Data Ingestion Queries

With the continuing advances of sensing devices and IoT/Telecom applicat...
research
01/29/2022

Green NFTs: A Study on the Environmental Impact of Cryptoart Technologies

We introduce a model of greenhouse gas emissions due to on-chain activit...

Please sign up or login with your details

Forgot password? Click here to reset