PERFORMANCE EVALUATION OF SQL AND NOSQL DATABASE MANAGEMENT SYSTEMS IN A CLUSTER

Christine Niyizamwiyitira and Lars Lundberg
Department of Computer Science and Engineering, Blekinge Institute of Technology, SE37179 Karlskrona, Sweden.

ABSTRACT

In this study, we evaluate the performance of SQL and NoSQL database management systems namely; Cassandra, CouchDB, MongoDB, PostgreSQL, and RethinkDB. We use a cluster of four nodes to run the database systems, with external load generators.The evaluation is conducted using data from Telenor Sverige, a telecommunication company that operates in Sweden. The experiments are conducted using three datasets of different sizes.The write throughput and latency as well as the read throughput and latency are evaluated for four queries; namely distance query, k-nearest neighbour query, range query, and region query. For write operations Cassandra has the highest throughput when multiple nodes are used, whereas PostgreSQL has the lowest latency and the highest throughput for a single node. For read operations MongoDB has the lowest latency for all queries. However, Cassandra has the highest throughput for reads. The throughput decreasesas the dataset size increases for both write and read, for both sequential as well as random order access. However, this decrease is more significant for random read and write. In this study, we present the experience we had with these different database management systems including setup and configuration complexity.

KEYWORDS
Trajectory queries, cluster computing, SQL database, NoSQL database, Cassandra, CouchDB, MongoDB, PostgreSQL, RethinkDB

Full Text: https://aircconline.com/ijdms/V9N6/9617ijdms01.pdf

Comments

Post a Comment

Popular posts from this blog

3rd International Conference on Computer Science, Engineering and Artificial Intelligence (CSEAI 2025)

Image
 * Registration is currently open * Call for Research Papers!!! Free – Extended Paper will be published as free of cost. 3rd International Conference on Computer Science, Engineering and Artificial Intelligence (CSEAI 2025)   May 30 ~ 31, 2025, Virtual Conference Submission Deadline: January 25, 2025 Submission System Link:  https://cseai2025.org/submission/index.php Contact us: Here's where you can reach us : cseai@cseai2025.org or cseaiconf@gmail.com For More details visit here: https://cseai2025.org/index #computerscience #computersciencemajor #computersciencejoke #computersciencehumor #computerscienceforall #computersciencestudent #computerscienceengineering #computerscienceacademy #computersciencemajorproblems #computersciences #datamining #dataminingfordummies #internetofthings #iot #iota #iotd #iotaphitheta #iotworld #iotiran #iotsecurity #iotnews #iotas #iotmcz #ioteeilmare #iotifolecce #iotproject #iothinks #iotweek #iotproducts #iotsolutions #iotafitness #iotiam...
Read more

A REVIEW OF THE USE OF R PPROGRAMMING FOR DATA SCIENCE RESEARCH IN BOTSWANA

Image
  International Journal of Database Management Systems (IJDMS) IJDMS is indexed World Journal Clout Index (WJCI) ISSN: 0975-5705 (Online); 0975-5985 (Print) http://airccse.org/journal/ijdms/index.html A REVIEW OF THE USE OF R PPROGRAMMING FOR DATA SCIENCE RESEARCH IN BOTSWANA Simisani Ndaba Department of Computer Science, University of Botswana, Gaborone, Botswana https://aircconline.com/ijdms/V15N1/15123ijdms01.pdf
Read more

HYBRID ENCRYPTION ALGORITHMS FOR MEDICAL DATA STORAGE SECURITY IN CLOUD DATABASE

Image
  HYBRID ENCRYPTION ALGORITHMS FOR MEDICAL DATA STORAGE SECURITY IN CLOUD DATABASE Fenghua Zhang1，Yaming Chen2，Weiming Meng3 and Qingtao Wu4 1Computer Technology, Henan University of Science and Technology, Luo Yang, China 2,3Computer Science and Technology, Henan University of Science and Technology, Luo Yang, China 4Professor, Henan University of Science and Technology, Luo Yang, China ABSTRACT Cloud database are derivatives of Cloud computing. At present, most medical institutions store data in cloud database. Although the cloud database improves the efficiency of use, it also poses a huge impact and challenge to the secure storage of data. The article proposes a hybrid algorithm to solve the data security problem in the hospital cloud database. First, the AES algorithm is improved. The improved algorithm is called P-AES algorithm. The P-AES algorithm is then combined with the RSA algorithm, called a hybrid algorithm. The experimental results show that the hybrid enc...
Read more