A Systematic Literature Review on Performance Evaluation of SQL and NoSQL Database Architectures

Authors

  • Muqaddas Salahuddin Faculty of Computer Science and Information Technology, Superior University, Lahore, 54000, Pakistan.
  • Samra Majeed Faculty of Computer Science and Information Technology, Superior University, Lahore, 54000, Pakistan.
  • Sammia Hira Faculty of Computer Science and Information Technology, Superior University, Lahore, 54000, Pakistan.
  • Gohar Mumtaz Faculty of Computer Science and Information Technology, Superior University, Lahore, 54000, Pakistan.

Keywords:

MapReduce, DBaaS, ACID, NoSql Database and Sql Databases, BASE, Big Data, Aggregation

Abstract

The Maintaining large volumes of data in SQL and NoSql databases depends on programming architecture. NoSql databases excel in horizontal scalability and handling unstructured data, while SQL databases are designed for data organization and horizontal scalability. Choosing between SQL and NoSql databases can be challenging due to differences in database design and hierarchical needs. NoSql databases use a mixed-model strategy, complicating data movement between cloud storage providers, as different platforms experiment with various concepts. Systematic literature reviews (SLRs) analyze papers on NoSql and SQL database designs, interoperability, and cloud data portability. Recent research comparing Oracle RDBMS and MongoDB suggests that NoSql databases are better for big data analytics due to their customized architectures, whereas SQL databases are more suitable for online transaction processing (OTP).

Downloads

Published

2024-09-01

How to Cite

Muqaddas Salahuddin, Samra Majeed, Sammia Hira, & Gohar Mumtaz. (2024). A Systematic Literature Review on Performance Evaluation of SQL and NoSQL Database Architectures. Journal of Computing & Biomedical Informatics, 7(02). Retrieved from https://jcbi.org/index.php/Main/article/view/548

Issue

Vol. 7 No. 02 (2024): Journal of Computing & Biomedical Informatics

Section

Articles

License

This is an open Access Article published by Research Center of Computing & Biomedical Informatics (RCBI), Lahore, Pakistan under CCBY 4.0 International License