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

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

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

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

Preparation and Characterization of a Polyclonal Antibody against Brominated Protein

(Di)bromotyrosine is formed by the specific reaction of eosinophil peroxidase and can be used as an eosinophil activation marker. In the present study, an antibody for (di)bromotyrosine in proteins was prepared to investigate the pathogenesis of eosinophil-related diseases such as allergic responses. A rabbit polyclonal antibody was raised against brominated keyhole limpet hemocyanin. The specificity of the antiserum was investigated with an enzyme-linked immunosorbent assay (ELISA). The antiserum recognized brominated bovine serum albumin (BSA) and dibromotyrosine-conjugated BSA. The antiserum also reacted with chlorinated BSA and di-iodotyrosine-conjugated BSA. Moreover, the specificity of the antiserum was investigated using competitive ELISA. Dibromotyrosine and di-iodotyrosine inhibited the recognition of brominated BSA by the antiserum. However, the recognition of brominated BSA by the antiserum was not inhibited by bromotyrosine, chlorotyrosine, iodotyrosine, nitrotyrosine, aminotyrosine, phosphotyrosine, or tyrosine. These results suggested that the epitope of the antiserum is dihalogenated tyrosine. Immunohistochemically, the antiserum stained brominated rat eosinophils but not chlorinated or nitrated eosinophils. In conclusion, an antiserum for dihalogenated protein was prepared. It is expected that the antiserum will be useful for the analysis of the pathogenesis of allergic diseases such as asthma and atopic dermatitis

Behavior of Radiocesium in Sediments in Fukushima Coastal Waters: Verification of Desorption Potential through Pore Water

Concentrations of 137Cs in seawater, seabed sedi-ment, and pore water collected from the area around Fukushimawere investigated from 2015 to 2018, and the potential of coastalsediments to supply radiocesium to the bottom environment wasevaluated. The 137Cs concentration in the pore water ranged from33 to 1934 mBq L−1 and was 10−40 times higher than that in theoverlying water (seawater overlying within 30 cm on the seabed).At most stations, the 137Cs concentrations in the overlying waterand the pore water were approximately proportional to those in thesediment. The conditional partition coefficient between pore waterand sediment was [0.9−14] × 102 L kg−1, independent of the yearof sampling. These results indicated that an equilibrium of 137Cs between pore water and sediment has been established in a relatively short period, and 137Cs in the pore water is gradually exported to seawater near the seabed. A simple box model estimation based on these results showed that 137Cs in the sediment decreased by about 6% per year by desorption/diffusion of 137Cs from the seabed