РОЗРОБКА ТА СУПРОВОДЖЕННЯ СИСТЕМ ІЗ РОЗПОДІЛЕНИМИ БАЗАМИ ДАНИХ НА ОСНОВІ ТЕХНОЛОГІЙ POLYGLOT PERSISTENCE

Abstract

The analysis of modern methods and technologies used for solving the problems of creating and maintaining distributed databases with a multi-variant storage was carried out. Distributed databases with a single mechanism for accessing multi-variate data are singled out. The use of scalability mechanisms in the direction of horizontal scaling (in which a certain number of servers are increased within one system) is considered.The justification for the use of the Brewer'stheorem is given, in relation to restrictions and compromise solutions regard-ing properties: consistency, availability, partition tolerance. In relation to this theory, a formalization of the definition of prop-erties for distributed multimodel databases is presented. The extension to the Brewer'stheorem, which requires a trade-off between delays and consistency when applying a replication, and the principles for basic availability and eventual consistency are taken into account.The ways to create and support a highly loaded e-commerce system with support for distributed databases with multi-variate persistence are provided in the article. Examplesof possible architectural solutions for organizing access in such a system using a mix of relational and NoSQL (such as document, key-value, graph and column storage) are given. Such archi-tectural solution as distributed multi-model DBMS with a single access mechanism is proposed to overcome the problems of accessing databases with multi-variant saving from business logic. The shortcomings for such solution’s modern implementa-tions and ways of its improvement are shown. In particular, it is a support for all known data models and dynamic access to data loaded in one model in the format of another model.This work provides an opportunity to obtain and analyze experimental data at the next stages for the study of distributed multi-model dynamic databases using loading effects to obtain quantitative and qualitative characteristics of basic availability and partition tolerance for a fixed parameter of the eventual consistency for multimodel DBMS with a single access mechanism.