Search Paper
  • Home
  • Login
  • Categories
  • Post URL
  • Academic Resources
  • Contact Us

 

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

google+
Views: 480                 

Author :  Christine Niyizamwiyitira and Lars Lundberg

Affiliation :  Department of Computer Science and Engineering, Blekinge Institute of Technology, SE- 37179 Karlskrona

Country :  sweden

Category :  DBWorld: Database Management Systems

Volume, Issue, Month, Year :  9, 6, December, 2017

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.

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

Journal/ Proceedings Name :  International Journal of Database Management Systems ( IJDMS )

URL :  http://aircconline.com/ijdms/V9N6/9617ijdms01.pdf

User Name : nchristine8
Posted 10-01-2018 on 20:11:04 AEDT



Related Research Work

  • A Review On Privacy Preservation In Data Mining
  • Smartbark: An Automated Dog Barking Detection And Monitoring System Using Ai And Deep Learning
  • The Technology Of Using A Data Warehouse To Support Decision-making In Health Care
  • Matbase – A Tool For Transparent Programming While Modelling Data At Conceptual Levels

About Us | Post Cfp | Share URL Main | Share URL category | Post URL
All Rights Reserved @ Call for Papers - Conference & Journals