Skip to content
Research Article Open access CC BY 4.0

Comparison between SQL and NoSQL Databases and Their Relationship with Big Data Analytics

Wajid Ali, Muhammad Usman Shafique, Muhammad Arslan Majeed, Ali Raza

Asian Journal of Research in Computer Science · pp. 1–10 · Published 21 Oct 2019

10.9734/ajrcos/2019/v4i230108

Abstract

A key ingredient in the world of cloud computing is a database that can be used by a great number of users. Distributed storage mechanisms become the de-facto method for data storage used by companies for the new generation of web applications. In the world of data storage, NoSQL (usually interpreted as "not only SQL" by developers) database is a growing trend. It is said that NoSQL alternates with the most widely used relational databases for the data storage, but, as the name implies, it does not fully replace the SQL. In this paper we will discuss about SQL and NoSQL databases, comparison of traditional SQL with NoSQL databases for Big Data analytics, NoSQL data models, types of NoSQL data stores, characteristics and features of each data store, advantages and disadvantages of NoSQL and RDBMS.

Database NoSQL relational databases data stores big data analytics.

Cited by 50

A Smart Distributed Marketplace

E. Kapassa, Marios Touloupos, D. Kyriazis · European, Mediterranean and Middle Eastern Conference on Information Systems · 2019

Profitability concepts of non-emission energy production aided by big data.

Chudzicki Mariusz, Dobosz Piotr, Knop Michał · Procedia Computer Science · 2022

Self-Adaptable Infrastructure Management for Analyzing the Efficiency of Big Data Stores

Konstantinos Mavrogiorgos, Athanasios Kiourtis, Argyro Mavrogiorgou · Journal of Advances in Information Technology · 2022

NoSQL: Will it be an alternative to a relational database? MySQL vs MongoDB comparison

Basit alyasiri, Bushra Sahi, N. Al-khafaji · Proceedings of 2nd International Multi-Disciplinary Conference Theme: Integrated Sciences and Technologies, IMDC-IST 2021, 7-9 September 2021, Sakarya, Turkey · 2022

Metaheuristics and Optimization in Computer and Electrical Engineering

Navid Razmjooy, M. Ashourian, Zahra Foroozandeh Editors · 2021

Impact of Data Compression on the Performance of Column-oriented Data Stores

Tsvetelina Mladenova, Yordan Kalmukov, M. Marinov · International Journal of Advanced Computer Science and Applications · 2021

Models and data quality in information systems applicable in the mining industry

Yordanka Anastasova, N. Yanev · E3S Web of Conferences · 2021

Analysis of Big Data Storage Tools for Data Lakes based on Apache Hadoop Platform

V. Belov, E. Nikulchev · International Journal of Advanced Computer Science and Applications · 2021

Article metrics

Real usage data collected on this platform.

0

Page views

0

PDF downloads

0

Outbound clicks

50

Citations

Views by country

Approximate, from request IP at view time — not citizenship or institution. Countries with fewer than 5 views are grouped as "Other".

No views recorded yet.

Traffic sources

Referring site, by host.

No traffic recorded yet.

Views and downloads exclude known bots/crawlers. Citations combines this platform's own DOI-resolved index with each external source's own reported total — see Cited by above for individually listed citing works. Last refreshed 0 seconds ago.