Open AccessPromising directions for the development of modern databases
Author(s) -
Alexey V Kalayda
Publication year - 2021
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/2131/2/022087
Subject(s) - computer science , nosql , asynchronous communication , scalability , sql , replication (statistics) , database , joins , distributed database , blocking (statistics) , cluster analysis , distributed computing , parallel computing , programming language , artificial intelligence , computer network , statistics , mathematics
In this article, we will compare the SQL and NoSQL models, their advantages and disadvantages, clarify the variations of using both approaches to database management and explain in which cases it is better to use one or the other model. Three main characteristics of the system were tested: parallel data processing, working with information stores, and data replication. The possibility of parallel data processing was evaluated by analyzing the mechanisms of blocking, multi-level parallel access control and ACID. Storage testing covered both physical media and RAM usage. Replication was tested in synchronous and asynchronous modes. During the tests, we found out that SQL databases with the possibility of clustering showed promising performance results per node and also have scalability.