A Case Study of Cloud Query Performance Comparison Between SQL and NoSQL Database

Large volumes of data present a significant challenge and can lead to high costs for organizations. As datasets grow, the operational efficiency of applications tends to decline, which can result in customer attrition. Therefore, enhancing the performance of applications is crucial for capturing increasingly large amounts of customer data. Cloud computing services provide a practical solution to this performance issue by effectively managing both SQL and NoSQL databases. This paper outlines a case study aimed at identifying the most effective method for improving application performance with large and continuously expanding datasets. To achieve this, the query performance of SQL and NoSQL systems are compared. The comparison involves measuring the runtimes of queries executed on SQL and NoSQL databases hosted in the cloud, using the TPC benchmark. The experiment assesses the response times of both database types, ultimately indicating which method performs better.