Перегляд за автором "Mazurova, O."

Зараз показано 1 - 2 з 2
  • Зображення мініатюри
    Публікація
    NoSQL database logic design methods for mongodb and Neo4j
    (ХНУРЕ, 2022) Mazurova, O.; Syvolovskyi, I.; Syvolovska, O.
    Modern developers of gaming mobile and Internet applications almost do not imagine themselves without the use of NoSQL databases, if they pursue the goal of creating scalable databases with high-performance and wide functionality. When designing a database for any NoSQL system, the developer needs a clear understanding of the logic of such databases and the capabilities of the tools offered by the corresponding DBMS. However, unfortunately, they do not have unified methods of logical design of such models, as in relational databases. Thus, there is a problem of developing effective methods for the logical design of such databases that would provide the necessary performance when implementing the business logic of the corresponding applications. The subject of the research is approaches to the logical design of NoSQL document and graph databases. The goal of the work is to propose unified logical modeling methods for MongoDB and Neo4j NoSQL systems based on an experimental study of their performance. The following tasks are solved in the work: analysis of current approaches to the logical design of document and graph databases, the development of logical design methods for them; planning and experimental study of the performance of the proposed methods on the example of models developed with their help. The following methods are used: database design methods, database performance evaluation methods, development methods are based on MongoDB 5.0.5, Neo4j 4.4.3 DBMS, Visual Studio 2022 development environment. The following results are obtained: unified logical design methods for MongoDB and Neo4j NoSQL systems are proposed; on their basis, the corresponding logical models have been developed; experimental measurements of the number of resources required working with the developed models; recommendations on the proposed methods are formed. Conclusions: The proposed modeling methods for MongoDB have their own aspects of their effective use for different types of applications. The strengths and weaknesses of both methods were identified, but a mixed method based on a combination of modeling through normalization and denormalization was recommended. Even though Neo4j lost out to MongoDB in terms of consumed resources in most experiments, both DBMS's' demonstrate good productivity, taking into account the orientation to different tasks.
  • Зображення мініатюри
    Публікація
    Research of acid transaction implementation methods for distributed databases using replication technology distributed database
    (ХНУРЕ, 2021) Mazurova, O.; Naboka, A.; Shirokopetleva, M.
    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.