Performance analysis of relational and NoSQL databases according to operating system, running environment and web technologies

With the increasing use of internet technology, the use of web technologies has also grown, leading to a significant increase in data volume. Nowadays, almost everything is connected to the internet, resulting in the generation of large amounts of data. Internet users create data through various activities such as uploading photos to social media platforms, sharing messages, watching and downloading videos. The growing data volume has led to increased querying of traditional database systems, an increase in the use of NoSQL database systems, and the rise of cloud technologies, which are internet-based computing services. There is a complex interaction between databases, operating systems, web technologies, and working environments. Operating systems play a crucial role in ensuring the efficient functioning of databases. Similarly, web technologies and working environments can also impact database performance. In this study, the parameters affecting the performance of relational database MySQL and non-relational databases Cassandra, HBase, and MongoDB were examined. The aim of this study is to obtain results through performance comparisons among different operating systems, programming languages, database systems, and working environments. Data volume was also considered as an important parameter. In the study, data volume was increased up to 100,000 records in multiples of 10, and tests were conducted with different operating systems (Ubuntu, Windows), web technologies (Node.js, PHP), and working environments (Cloud System, Personal Computer). Operations such as reading, insertion, deletion, and updating were performed in these tests and query response time latency is used as performance metric. Among these operations, Cassandra database yielded the best results except for the read operation. Generally, cloud systems showed better performance results when compared to personal computers in terms of working environment. Regarding operating systems, Ubuntu performed better than Windows. However, there were no significant performance differences observed between the two operating systems. When it comes to web technologies, it was observed that there were no significant performance differences.