Application developers mostly must choose between two main categories of the database: SQL (Structured Query Language) and NoSQL (Not Only SQL) to build their solutions. SQL databases, also known as relational databases, have been in use for a very long time and despite their age, SQL databases remain extremely popular with developers. Six of the top 10 results on DB-Engines’ list of most popular DBMS are relational DBs (September 2021). In the meantime, NoSQL databases or non-relational databases, have gained popularity year after year. One of the most widely used NoSQL databases is MongoDB, ranked 5th on DB-Engines’ list. In this article, we will explore what are the differences between SQL and NoSQL, and which database to use for application development.
- Roman Čerešňák, Michal Kvet : Comparison of query performance in relational a non-relation databases. 13th International Scientific Conference on Sustainable, Modern and Safe Transport (TRANSCOM 2019). Transportation Research Procedia 40 (2019) 170–177
- Supriya S. Pore, Swalaya B. Pawar.: Comparative Study of SQL & NoSQL Databases. International Journal of Advanced Research in Computer Engineering & Technology (IJARCET), Volume 4 Issue 5, May 2015.
- Vatika Sharma, Meenu Dave: SQL and NoSQL Databases. International Journal of Advanced Research in Computer Science and Software Engineering
- Ramez Elmasri, Shamkant B. Navathe: Fundamentals of Database Systems 7th Edition
- Guy Harrison, Next Generation databases: NoSQL, NewSQL, and Big Data
- Han J, Haihong E, Le G, et al: Survey on NoSQL database[C] Pervasive computing and applications (ICPCA), 2011 6th international conference on. IEEE, 2011: 363-366.
- Rick Cattell. 2011. Scalable SQL and NoSQL data stores. SIGMOD Rec. 39, 4 (May 2011), 12-27.