ARTICLE
TITLE

RESEARCH OF ACID TRANSACTION IMPLEMENTATION METHODS FOR DISTRIBUTED DATABASES USING REPLICATION TECHNOLOGY

SUMMARY

Today, databases are an integral part of most modern applications designed to store large amounts of data and to request from many users. To solve business problems in such conditions, databases are scaled, often horizontally on several physical servers using replication technology. At the same time, many business operations require the implementation of transactional compliance with ACID properties. For relational databases that traditionally support ACID transactions, horizontal scaling is not always effective due to the limitations of the relational model itself. Therefore, there is an applied problem of efficient implementation of ACID transactions for horizontally distributed databases. The subject matter of the study is the methods of implementing ACID transactions in distributed databases, created by replication technology. The goal of the work is to increase the efficiency of ACID transaction implementation for horizontally distributed databases. The work is devoted to solving the following tasks: analysis and selection of the most relevant methods of implementation of distributed ACID transactions; planning and experimental research of methods for implementing ACID transactions by using of NoSQL DBMS MongoDB and NewSQL DBMS VoltDB as an example; measurements of metrics of productivity of use of these methods and formation of the recommendation concerning their effective use. The following methods are used: system analysis; relational databases design; methods for evaluating database performance. The following results were obtained: experimental measurements of the execution time of typical distributed transactions for the subject area of e-commerce, as well as measurements of the number of resources required for their execution; revealed trends in the performance of such transactions, formed recommendations for the methods studied. The obtained results allowed to make functions of dependence of the considered metrics on loading parameters. Conclusions: the strengths and weaknesses of the implementation of distributed ACID transactions using MongoDB and VoltDB were identified. Practical recommendations for the effective use of these systems for different types of applications, taking into account the resources consumed and the types of requests.

 Articles related

Özlem Ete Aydemir,Kürsat Korkmaz,Faruk Özkutlu    

In this study, the effect of foliar L-Histidine and Methinonin amino acid applications on grain cadmium (Cd) and zinc (Zn) uptake on durum wheat grown in soil contaminated with Cd was investigated. The research was carried out according to the randomized... see more


Faeza A. Valdany,Yudi N Ihsan,Lintang PS Yuliadi,Noir P Purba    

This research aimed to observe the trend of acidity, nitrate, and phosphate in the Indonesia seas associated with oceanography. Analysis was done by looking at the horizontal condition from main data (acidity, nitrate, and phosphate) and ancillary data (... see more

Revista: Omni-Akuatika

Sergey Gokov, Yuri Kazarinov, Sergiy Kalenik, Valentin Kasilov, Tetiana Malykhina, Yegor Rudychev, Vitaliy Tsiats’ko    

The emergence of powerful sources of ionizing radiation, the needs of nuclear energy, technology and medicine, as well as the need to develop reliable methods of protection against the harmful effects of penetrating radiation stimulated the development o... see more


F Kurniasari, P Andayani    

An unbalanced diet with a very high protein intake causes high levels of uric acid in the body. Uric Acid is a disease caused by high levels of uric acid in the human body. In Indonesia, Uric Acid is one type of disease that many Indonesians suffer from.... see more


Witiyasti Imaningsih,Nadiya Dwi Rahayu,Safinah Surya Hakim    

Some types of fungi are known to have the ability to produce Indole Acetic Acid (IAA). Fungi can be isolated from the rhizosphere and tissues of various plants, including from the rhizosphere and the root "Galam" (Melaleuca cajuputi Powell.), which grow ... see more