Performance testing of NoSQL and RDBMS for storing big data in e-applications

Abstract

The development of big data and the Internet of Things (IoT) is rapidly accelerating and affecting all areas of communication technologies and businesses by increasing the benefits for organizations and individuals. The growth of data produced via IoT has played a major role on the big data landscape. The paper is concerned with respect to the Big Data key-value pairs from different database types using the latest version of Elasticsearch 6.0 and classic relational database as MySQL 5.5. This stands for the crucial topics since many databases are used these days and it is difficult to choose the right database for specific scenario. The correct choice for specific scenario is very important in e-applications or communication systems, because it is supposed to save a lot of money and effort. This work aims at comparing and testing Elasticsearch and MySQL DB (Database) with related frameworks e.g., Spring Data. This particular comparison is done via searching values in larger key-value datasets. At this point, it is very important to know which database to choose in this scenario, because it is often used in e-applications e.g., when e-application wants to store session ID and user time spent in e-app. Simulation scenarios in this paper were created using real data sets provided by IBM internal e-learning app. Based on performed tests, authors provide the community with a suitable way of storing data.