Graduate School of Natural and Applied Sciences
Permanent URI for this community
Browse
Browsing Graduate School of Natural and Applied Sciences by Author "ABBAS, Abdulbaset"
Now showing 1 - 1 of 1
Results Per Page
Sort Options
Item EVALUATING THE QUALITY ASPECTS OF SQL AND NOSQL DATABASES(2022-06-22) ABBAS, Abdulbaset; TOPALLI, DamlaWith the recent advances in technology and the growth of the data to be processed, choosing the suitable databases for your software has become a highly effective element that reflects directly on the overall quality and outcomes of any work. The most popular DBMS are either relational database management systems like SQL or non-relational database management systems like NoSQL; choosing between them at the early stages is essential. In this thesis, the key features of SQL and NoSQL databases have been discussed, considering the eight main software quality attributes affecting the database quality: Availability, Efficiency, Consistency, Durability, Maintainability, Reliability, Scalability, and Recovery Time. This study aims to understand the most effective quality attributes for SQL and NoSQL database implementation. Additionally, the popular DBMS tools for SQL and NoSQL implementation are discussed, considering four tools: MySQL, PostgreSQL, MongoDB, and Redis. To better understand the current implementation preferences, a questionnaire has been conducted with IT professionals: developers, database experts, testers, and managers to understand their preferences on SQL and NoSQL databases from the quality perspective. According to the questionnaire results, the highest important quality attributes for SQL are durability, consistency, and availability whereas, scalability, durability, and efficiency were the most critical quality attributes for NoSQL.