Promising directions for the development of modern databases

Abstract

Abstract 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.