CFP last date
01 July 2024
Call for Paper
August Edition
CAE solicits high quality original research papers for the upcoming August edition of the journal. The last date of research paper submission is 01 July 2024

Submit your paper
Know more
Reseach Article

SQL vs. NoSQL vs. NewSQL- A Comparative Study

by Sneha Binani, Ajinkya Gutti, Shivam Upadhyay
Communications on Applied Electronics
Foundation of Computer Science (FCS), NY, USA
Volume 6 - Number 1
Year of Publication: 2016
Authors: Sneha Binani, Ajinkya Gutti, Shivam Upadhyay

Sneha Binani, Ajinkya Gutti, Shivam Upadhyay . SQL vs. NoSQL vs. NewSQL- A Comparative Study. Communications on Applied Electronics. 6, 1 ( Oct 2016), 43-46. DOI=10.5120/cae2016652418

@article{ 10.5120/cae2016652418,
author = { Sneha Binani, Ajinkya Gutti, Shivam Upadhyay },
title = { SQL vs. NoSQL vs. NewSQL- A Comparative Study },
journal = { Communications on Applied Electronics },
issue_date = { Oct 2016 },
volume = { 6 },
number = { 1 },
month = { Oct },
year = { 2016 },
issn = { 2394-4714 },
pages = { 43-46 },
numpages = {9},
url = { },
doi = { 10.5120/cae2016652418 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
%0 Journal Article
%1 2023-09-04T19:56:37.615832+05:30
%A Sneha Binani
%A Ajinkya Gutti
%A Shivam Upadhyay
%T SQL vs. NoSQL vs. NewSQL- A Comparative Study
%J Communications on Applied Electronics
%@ 2394-4714
%V 6
%N 1
%P 43-46
%D 2016
%I Foundation of Computer Science (FCS), NY, USA

SQL Databases also known as RDBMS (Relational Database Management Systems) is the most common and traditional approach to database solutions. The data is stored in a structured way in form of tables or Relations. With advent of Big Data however, the structured approach falls short to serve the needs of Big Data systems which are primarily unstructured in nature. Increasing capacity of SQL although allows huge amount of data to be managed, it does not really count as a solution to Big Data needs, which expects fast response and quick scalability. To solve this problem a new kind of Database system called NoSQL was introduced to provide the scalability and unstructured platform for Big Data applications. NoSQL stands for Not Only SQL. NoSQL databases consist of key-value pair, Documents, graph databases or wide – column stores which do not have a standard schema which it needs to follow. It is also horizontally Scalable as opposed to vertical scaling in RDBMS. NoSQL provided great promises to be a perfect database system for Big Data applications; it however falls short because of some major drawbacks like NoSQL does not guarantee ACID properties (Atomicity, Consistency, Isolation and Durability) of SQL systems. It is also not compatible with earlier versions of database. This is where NewSQL comes into picture. NewSQL is a latest development in the world of database systems. NewSQL is a Relational Database with the scalability properties of NoSQL. This paper discusses each of these database systems and tries to find the ideal solution for Big Data requirements.

  1. Imtiaz Rashid : “Term Paper on Database Management System”
  2. Don Chamberlin : “SQL”, IBM Almaden Research Center, San Jose, CA
  3. Matthew Aslett :"451 Research delivers market sizing estimates for NoSQL, NewSQL and MySQL ecosystem” May 22nd, 2012
  4. Shiwei Yu : "ACID Properties in Distributed Databases" , 20096
  5. Ryan Betts : “SQL Time-Tested and still flourishing” , VoltDB, Bedford.
  6. Jenny Richards, Advantages and Disadvantages of NoSQL databases – what you should know, Hadoop360, September 24, 2015,
  7. Venkat Gudivada, Dhana Rao and Vijay Raghavan: "NoSQL Systems for Big Data Management”, June 2014, Conference: 2014 IEEE World Congress on Services, At Anchorage, Alaska.
  8. A B M Moniruzzaman: "NewSQL: Towards Next-Generation Scalable RDBMS for Online Transaction Processing (OLTP) for Big Data Management", Nov 2014.
  9. Hoff, Todd : "Google Spanner's Most Surprising Revelation: NoSQL is Out and NewSQL is In". Retrieved 2012-10-07.
  10. Stonebraker, Michael "NewSQL: An Alternative to NoSQL and Old SQL for New OLTP Apps". Communications of the ACM Blog. , 2012
  11. Vinay Jain "Rise of NewSQL". International Journal for Research in Emerging Science and Technology.
Index Terms

Computer Science
Information Sciences


NewSQL Big Data Features of NewSQL Difference between SQL NoSQL and NewSQL OLTP (On-Line Transaction Processing) and Big Data ACID properties BASE properties.