Qualitative Analysis of SQL and NoSQL Database with an Emphasis on Performance

Abstract

AbstractThe social networking sites and different real-time applications generate data in very large amount and unstructured in nature which makes it difficult for relational database management systems to handle such data. SQL databases face many new challenges to prove them effective databases to store and process big data or unstructured data as they require high-rise in read and write performance. The use of SQL databases has proved them inadequate when it comes to store and query dynamic user data, especially for bulky, highly parallel applications such as search engines and social networks. For these cases, the NoSQL database was created to deal with. This document provides a background introduction, features and their specifications, and available data models for NoSQL database. In addition, this paper stratifies NoSQL databases performance on the basis of CRUD operations which will mainstream the benefits and use cases provided by NoSQL databases to help companies choose NoSQL.KeywordsNoSQLSQLComparisonDatabase systemCRUD operationData model