Performance Evaluation of Relational Databases and Non-Relational Databases

Dr. Fahad A al Qurashi, Maha H Alotibi

Abstract: Currently, it is noticeable that NoSQL databases have been increased in popularity, which was due to the current emphasis on “Big Data”. Such databases are believed to implement well again the traditional SQL databases. Therefore, this research aims to investigate independently the performance of SQL databases and some of NoSQL DBs, taking into consideration the key-value stores, compare the Redis database operations such as write, read, and delete implemented on key-value stores with SQL and NoSQL databases. An abstract framework of pair of key-value that support these processes is implemented and designed using all the tested databases. The outcomes of the experiment compute the time taken by these operations. The findings prove that not necessary all NoSQL act better than the SQL databases. Moreover, some of them were found to be much worse. In addition, the evaluation for each database showed that the performing be different with each operation, whereby some show a slow performance to read, but it is fast deleting and writing, and the rest were fast in reading, but slow in the other operations.

Keywords: Relational Database, non-relational database, SQL, NoSQL, RavenDB, Cassandra, Redis, MS SQL Express.

Title: Performance Evaluation of Relational Databases and Non-Relational Databases

Author: Dr. Fahad A al Qurashi, Maha H Alotibi

International Journal of Computer Science and Information Technology Research

ISSN 2348-1196 (print), ISSN 2348-120X (online)

Research Publish Journals

Vol. 7, Issue 3, July 2019 - September 2019

Citation
Share : Facebook Twitter Linked In

Citation
Performance Evaluation of Relational Databases and Non-Relational Databases by Dr. Fahad A al Qurashi, Maha H Alotibi