Article: Benchmarking of SQL and NoSQL performance on database management solutions and their respective data organisation frameworks Journal: International Journal of Internet Manufacturing and Services (IJIMS) 2025 Vol.11 No.3 pp.268 - 285 Abstract: Relational databases have been the predominant data management system for many years due to their ability to provide structured data storage and transactional integrity. However, the emergence of big data and web-scale applications has led to the need for more flexible and scalable database solutions. NoSQL databases have become a popular alternative, offering high availability and horizontal scalability for large volumes of unstructured or semi-structured data. This paper explores the rationale behind the NoSQL movement, including the rise of big data and the limitations of relational databases in clustered environments. It outlines several NoSQL data models, such as key-value, document, column family, and graph databases, which sacrifice some data consistency for scalability and availability. Features such as flexible schemas, MapReduce views, and the Cloudant query language provide more appropriate tools for this semi-structured data. The different use cases, architectures, and trade-offs between these database paradigms are compared and show that NoSQL databases are suitable for large-scale, distributed systems requiring flexible schemas and high scalability. Inderscience Publishers - linking academia, business and industry through research

Title: Benchmarking of SQL and NoSQL performance on database management solutions and their respective data organisation frameworks

Authors: Mohammed Ahmed Ali Abdualrhman; Nail Adeeb Ali Abdu

Addresses: Information Technology Department, Faculty of Engineering and Information Technology, Al-Saeed University, Taiz, Yemen ' Information Technology Department, Faculty of Engineering and Computing, University of Science and Technology, Aden, Yemen

Abstract: Relational databases have been the predominant data management system for many years due to their ability to provide structured data storage and transactional integrity. However, the emergence of big data and web-scale applications has led to the need for more flexible and scalable database solutions. NoSQL databases have become a popular alternative, offering high availability and horizontal scalability for large volumes of unstructured or semi-structured data. This paper explores the rationale behind the NoSQL movement, including the rise of big data and the limitations of relational databases in clustered environments. It outlines several NoSQL data models, such as key-value, document, column family, and graph databases, which sacrifice some data consistency for scalability and availability. Features such as flexible schemas, MapReduce views, and the Cloudant query language provide more appropriate tools for this semi-structured data. The different use cases, architectures, and trade-offs between these database paradigms are compared and show that NoSQL databases are suitable for large-scale, distributed systems requiring flexible schemas and high scalability.

Keywords: NoSQL databases; document-oriented data model; inventory system; CAP theory; map-reduce technique; cloudant query language.

DOI: 10.1504/IJIMS.2025.148604

International Journal of Internet Manufacturing and Services, 2025 Vol.11 No.3, pp.268 - 285

Received: 01 Feb 2024
Accepted: 16 Mar 2024
Published online: 15 Sep 2025 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article

Title: Benchmarking of SQL and NoSQL performance on database management solutions and their respective data organisation frameworks

Keep up-to-date