EUVIMEDEUVIMED entdecken
Systematische ÜbersichtOpen Access · CC BY 4.0

SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review

Wisal Khan, Teerath Kumar, Cheng Zhang, Kislay Raj, Arunabha M. Roy, Bin Luo

Big Data and Cognitive Computing · 12.05.2023 · 7 (2) · 97

DOI: 10.3390/bdcc7020097 ↗

Kurz gefasst

Systematische Übersicht in der Zeitschrift Big Data and Cognitive Computing, online erschienen am 12.05.2023. Verfasst von Wisal Khan und 5 weiteren Autor:innen. Die Arbeit wurde bisher 135-mal zitiert (Crossref) und nennt 170 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0). Gefördert von: the National High Technology Research and Development Program of China (863 programs), NSFC, the Chinese Government Scholarship (CSC).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

The competent software architecture plays a crucial role in the difficult task of big data processing for SQL and NoSQL databases. SQL databases were created to organize data and allow for horizontal expansion. NoSQL databases, on the other hand, support horizontal scalability and can efficiently process large amounts of unstructured data. Organizational needs determine which paradigm is appropriate, yet selecting the best option is not always easy. Differences in database design are what set SQL and NoSQL databases apart. Each NoSQL database type also consistently employs a mixed-model approach. Therefore, it is challenging for cloud users to transfer their data among different cloud storage services (CSPs). There are several different paradigms being monitored by the various cloud platforms (IaaS, PaaS, SaaS, and DBaaS). The purpose of this SLR is to examine the articles that address cloud data portability and interoperability, as well as the software architectures of SQL and NoSQL databases. Numerous studies comparing the capabilities of SQL and NoSQL of databases, particularly Oracle RDBMS and NoSQL Document Database (MongoDB), in terms of scale, performance, availability, consistency, and sharding, were presented as part of the state of the art. Research indicates that NoSQL databases, with their specifically tailored structures, may be the best option for big data analytics, while SQL databases are best suited for online transaction processing (OLTP) purposes.

Förderung

  • the National High Technology Research and Development Program of China (863 programs)
  • NSFC
  • the Chinese Government Scholarship (CSC)

Zitieren

APA

Khan, W., Kumar, T., Zhang, C., Raj, K., Roy, A. M., & Luo, B. (2023). SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review. Big Data and Cognitive Computing, 7(2), 97. https://doi.org/10.3390/bdcc7020097

Vancouver

Khan W, Kumar T, Zhang C, Raj K, Roy AM, Luo B. SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review. Big Data and Cognitive Computing. 2023;7(2):97. doi:10.3390/bdcc7020097

BibTeX
@article{Khan2023,
  author = {Khan, Wisal and Kumar, Teerath and Zhang, Cheng and Raj, Kislay and Roy, Arunabha M. and Luo, Bin},
  title = {SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review},
  journal = {Big Data and Cognitive Computing},
  year = {2023},
  volume = {7},
  number = {2},
  pages = {97},
  doi = {10.3390/bdcc7020097}
}
Kostenlos starten →