How Poor Is the “Poor Man’s Search Engine”?

Burzańska, Marta; Wiśniewski, Piotr

doi:10.1007/978-3-319-99987-6_23

Cited by 2 publications

(1 citation statement)

References 6 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…When handling massive amounts of data, NoSQL databases, rather than SQL databases, are the best option for web applications [57,[104][105][106][107]. Geospatial and location data were also managed using NoSQL databases [108,109].…”

Section: Empirical Studies Analysismentioning

confidence: 99%

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

Khan

Kumar

Cheng

et al. 2023

BDCC

View full text Add to dashboard Cite

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.

show abstract