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.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.