Performance Comparison between SQL and NoSQL in Terms of Use with Big Data

Abstract

Data nowadays is growing and increasing dramatically, which has become more complex to store and process effectively using traditional database management tools. NoSQL databases have now become highly popular because of their pursuit of improving performance from traditional SQL databases, which has led to the replacement of Traditional database management systems, with NoSQL databases. This paper aims to study NoSQL databases of various types and evaluate them in big data analysis, which helps users of this type of databases obtain an understanding of the strengths and weaknesses of their various methods to support applications that deal with huge amounts of data and compare traditional SQL databases with NoSQL databases. We developed prototypes for the two systems in the Visual Basic language.net programming language, and we designed the databases, non-relational databases of the MongoDB type to represent the NoSQL database, and relational databases of the SQL Server type were used to represent relational databases, and a data set containing 21,965 related records was used with bank statements. We compared the time of loading data for the two systems and performed the operations of adding, retrieving data, modification, and deletion, to test and evaluate performance and speed of implementation. Keywords: Database, NoSQL, SQL Server, Big Data.