000 04048naa a22005657i 4500
001 UMUN-OA-20261005-SE-010
003 local
005 20261005174819.0
006 m o d
007 cr||||||||||||
008 261005s2023 xx o u000 0 eng d
024 7 _a10.3390/bdcc7020097
_2doi
035 _a(local)OpenAlex:W4376274168
040 _alocal
_beng
_clocal
041 0 _aeng
100 0 _aWisal Khan
_eauthor.
245 1 0 _aSQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review /
_cWisal Khan; Teerath Kumar; Cheng Zhang [and others].
264 1 _a[Place of publication not identified] :
_bMultidisciplinary Digital Publishing Institute,
_c2023.
300 _a1 online resource (1 article).
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
500 _aPublication type: Review article.
500 _aLinked open-access copy: published version.
506 0 _aOpen access; no subscription required for the linked open-access version.
_fUnrestricted online access
_2star
520 3 _aThe 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.
540 _aCreative Commons Attribution (licence family recorded by the source; version not supplied in metadata).
_uhttps://openalex.org/W4376274168
546 _aIn English.
588 0 _aDescription generated from OpenAlex bibliographic metadata retrieved on 5 October 2026; full text linked from the source.
590 _aCourse allocation: B. Sc. Software Engineering.
650 4 _aSQL database
650 4 _aNoSQL databases
650 4 _adatabase performance
650 4 _ainteroperability
650 4 _abig data processing
650 4 _ahorizontal scaling
653 _aB. Sc. Software Engineering
653 _aUMUN open access collection
653 _asoftware architecture
655 4 _aReview articles.
700 0 _aTeerath Kumar
_eauthor.
700 0 _aCheng Zhang
_eauthor.
700 0 _aKislay Raj
_eauthor.
700 0 _aArunabha M. Roy
_eauthor.
700 0 _aBin Luo
_eauthor.
773 0 _tBig Data and Cognitive Computing
_gVol. 7, no. 2, (2023), pages/article 97
_x2504-2289
856 4 0 _uhttps://www.mdpi.com/2504-2289/7/2/97/pdf?version=1686627571
_yRead open-access publication
_zOpen access. Access and licence reported by the source; this host could not be independently checked by automation.
_70
884 _aCourse selection and automated MARC21 enrichment from OpenAlex metadata.
_g20261005
_khttps://openalex.org/W4376274168
_qlocal
942 _n0
999 _c502
_d502