Industry 4.0
Vol. 7 (2022), Issue 3, pg(s) 95-97

DOMINANT TECHNOLOGIES IN “INDUSTRY 4.0”

SQL vs NoSQL databases from developer point of view

  • 1 Faculty of Information Technology, Polytechnic University of Tirana

Abstract

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.

Keywords

References

  1. 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
  2. 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.
  3. Vatika Sharma, Meenu Dave: SQL and NoSQL Databases. International Journal of Advanced Research in Computer Science and Software Engineering
  4. https://www.geeksforgeeks.org/sql-vs-nosql-which-one-is-better-to-use/
  5. Ramez Elmasri, Shamkant B. Navathe: Fundamentals of Database Systems 7th Edition
  6. Guy Harrison, Next Generation databases: NoSQL, NewSQL, and Big Data
  7. 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.
  8. Rick Cattell. 2011. Scalable SQL and NoSQL data stores. SIGMOD Rec. 39, 4 (May 2011), 12-27.
  9. https://www.bmc.com/blogs/sql-vs-nosql/
  10. https://en.wikipedia.org/wiki/Graph_database

Article full text

Download PDF