Call for Paper

CAE solicits original research papers for the July 2021 Edition. Last date of manuscript submission is June 30, 2021.

Read More

SQL vs. NoSQL vs. NewSQL- A Comparative Study

Sneha Binani, Ajinkya Gutti, Shivam Upadhyay. Published in Databases.

Communications on Applied Electronics
Year of Publication: 2016
Publisher: Foundation of Computer Science (FCS), NY, USA
Authors: Sneha Binani, Ajinkya Gutti, Shivam Upadhyay
10.5120/cae2016652418

Sneha Binani, Ajinkya Gutti and Shivam Upadhyay. SQL vs. NoSQL vs. NewSQL- A Comparative Study. Communications on Applied Electronics 6(1):43-46, October 2016. BibTeX

@article{10.5120/cae2016652418,
	author = {Sneha Binani and Ajinkya Gutti and Shivam Upadhyay},
	title = {SQL vs. NoSQL vs. NewSQL- A Comparative Study},
	journal = {Communications on Applied Electronics},
	issue_date = {October 2016},
	volume = {6},
	number = {1},
	month = {Oct},
	year = {2016},
	issn = {2394-4714},
	pages = {43-46},
	numpages = {4},
	url = {http://www.caeaccess.org/archives/volume6/number1/669-2016652418},
	doi = {10.5120/cae2016652418},
	publisher = {Foundation of Computer Science (FCS), NY, USA},
	address = {New York, USA}
}

Abstract

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.

References

  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, http://www.hadoop360.com/blog/advantages-and-disadvantages-of-nosql-databases-what-you-should-k
  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. 

Keywords

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