NOSQL DATABASE LOGIC DESIGN METHODS FOR MONGODB AND NEO4J
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...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Kharkiv National University of Radio Electronics
2022-06-01
|
| Series: | Сучасний стан наукових досліджень та технологій в промисловості |
| Subjects: | |
| Online Access: | https://itssi-journal.com/index.php/ittsi/article/view/327 |
| _version_ | 1818162756593909760 |
|---|---|
| author | Oksana Mazurova Illia Syvolovskyi Olena Syvolovska |
| author_facet | Oksana Mazurova Illia Syvolovskyi Olena Syvolovska |
| author_sort | Oksana Mazurova |
| collection | DOAJ |
| description |
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.
|
| first_indexed | 2024-12-11T16:38:43Z |
| format | Article |
| id | doaj.art-08614db272ec4122818e2fb5b0ba0656 |
| institution | Directory Open Access Journal |
| issn | 2522-9818 2524-2296 |
| language | English |
| last_indexed | 2024-12-11T16:38:43Z |
| publishDate | 2022-06-01 |
| publisher | Kharkiv National University of Radio Electronics |
| record_format | Article |
| series | Сучасний стан наукових досліджень та технологій в промисловості |
| spelling | doaj.art-08614db272ec4122818e2fb5b0ba06562022-12-22T00:58:23ZengKharkiv National University of Radio ElectronicsСучасний стан наукових досліджень та технологій в промисловості2522-98182524-22962022-06-012 (20)10.30837/10.30837/ITSSI.2022.20.052NOSQL DATABASE LOGIC DESIGN METHODS FOR MONGODB AND NEO4JOksana Mazurova0Illia Syvolovskyi1Olena Syvolovska2Kharkiv National University of Radio ElectronicsKharkiv National University of Radio ElectronicsUkrainian State University of Railway Transport 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. https://itssi-journal.com/index.php/ittsi/article/view/327databaselogical design methodDB DESIGNNeo4jNoSQLMongoDB |
| spellingShingle | Oksana Mazurova Illia Syvolovskyi Olena Syvolovska NOSQL DATABASE LOGIC DESIGN METHODS FOR MONGODB AND NEO4J Сучасний стан наукових досліджень та технологій в промисловості database logical design method DB DESIGN Neo4j NoSQL MongoDB |
| title | NOSQL DATABASE LOGIC DESIGN METHODS FOR MONGODB AND NEO4J |
| title_full | NOSQL DATABASE LOGIC DESIGN METHODS FOR MONGODB AND NEO4J |
| title_fullStr | NOSQL DATABASE LOGIC DESIGN METHODS FOR MONGODB AND NEO4J |
| title_full_unstemmed | NOSQL DATABASE LOGIC DESIGN METHODS FOR MONGODB AND NEO4J |
| title_short | NOSQL DATABASE LOGIC DESIGN METHODS FOR MONGODB AND NEO4J |
| title_sort | nosql database logic design methods for mongodb and neo4j |
| topic | database logical design method DB DESIGN Neo4j NoSQL MongoDB |
| url | https://itssi-journal.com/index.php/ittsi/article/view/327 |
| work_keys_str_mv | AT oksanamazurova nosqldatabaselogicdesignmethodsformongodbandneo4j AT illiasyvolovskyi nosqldatabaselogicdesignmethodsformongodbandneo4j AT olenasyvolovska nosqldatabaselogicdesignmethodsformongodbandneo4j |