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

Main Article Content

Wajid Ali
Muhammad Usman Shafique
Muhammad Arslan Majeed
Ali Raza

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.

Keywords:
Database, NoSQL, relational databases, data stores, big data analytics.

Article Details

How to Cite
Ali, W., Shafique, M. U., Majeed, M. A., & Raza, A. (2019). Comparison between SQL and NoSQL Databases and Their Relationship with Big Data Analytics. Asian Journal of Research in Computer Science, 4(2), 1-10. https://doi.org/10.9734/ajrcos/2019/v4i230108
Section
Review Article

References

Raut AB. NOSQL database and its comparison with RDBMS. International Journal of Computational Intelligence Research. 2017;13(7):1645-1651.

Moniruzzaman ABM, Syed Akhter Hossain. NoSQL database: New era of databases for big data analytics-classification, characteristics and comparison. arXiv Preprint arXiv: 1307.0191; 2013.

Băzăr Cristina, Cosmin Sebastian Iosif. The transition from RDBMS to NoSQL. A comparative analysis of three popular non-relational solutions: Cassandra, MongoDB and couchbase. Database Systems Journal. 2014;5(2):49-59.

Anonymous. Introduction of MongoDB. 2018;17:8.
(Accessed 15 August 2019)
Available:http://www.mongodb.org/about/introduction

Mason Robert T. NoSQL databases and data modeling techniques for a document-oriented NoSQL database. In Proceedings of Informing Science and IT Education Conference (InSITE). 2015;259-268.

Pothuganti, Abinav. Big data analytics: Hadoop-Map reduce & NoSQL databases. International Journal of Computer Science and Information Technologies. 2015;6(1): 522-527.

Smolan Rick, Jennifer Erwitt. The human face of big data. Against All Odds Production; 2012.

Turban Efraim, Ramesh Sharda, Dursun Delen. Business intelligence and analytics: Systems for decision support. Pearson Higher Ed; 2014.

Venkatraman Sitalakshmi, Kiran Fahd, Samuel Kaspi, Ramanathan Venkatraman. SQL versus NoSQL movement with big data analytics. Int. J. Inform. Technol. Comput. Sci. 2016;8:59-66.

Ohlhorst, Frank J. Big data analytics: Turning big data into big money. John Wiley & Sons. 2012;65.

Kaur Pankaj Deep, Amneet Kaur, Sandeep Kaur. Performance analysis in bigdata. International Journal of Information Technology and Computer Science (IJITCS). 2015;7:55-61.

Prasad Abhishek, Bhavesh N. Gohil. A comparative study of NoSQL databases. International Journal of Advanced Research in Computer Science. 2014;5(5).

Choi Yong-Lak, Woo-Seong Jeon, Seok-Hwan Yoon. Improving database system performance by applying NoSQL. JIPS. 2014;10(3):355-364.

Adam Fowler. Advantages NoSQL over RDBMS. 2017;11:6.
(Accessed 22 August 2019)
Available:http://www.mongodb.org/about/introduction

Floratou Avrilia, Nikhil Teletia, David J. DeWitt, Jignesh M. Patel, Donghui Zhang. Can the elephants handle the NoSQL onslaught? Proceedings of the VLDB Endowment. 2012;5(12):1712-1723.

Anonymous. NoSQL. 2019;17:8.
(Accessed 3 September 2019)
Available:http://en.wikipedia.org/wiki/NoSQL

Nayak Ameya, Anil Poriya, Dikshay Poojary. Type of NOSQL databases and its comparison with relational databases. International Journal of Applied Information Systems. 2013;5(4):16-19.

Agrawal Rakesh, Anastasia Ailamaki, Philip A. Bernstein, Eric A. Brewer, Michael J. Carey, Surajit Chaudhuri, AnHai Doan, et al. The Claremont report on database research. ACM Sigmod Record. 2008;37(3):9-19.

Cassandra Planet. NoSQL databases defined and explained; 2016.

Nayak Ameya, Anil Poriya, Dikshay Poojary. Type of NOSQL databases and its comparison with relational databases. International Journal of Applied Information Systems. 2013;5(4):16-19.

Padhy Rabi Prasad, Manas Ranjan Patra, Suresh Chandra Satapathy. RDBMS to NoSQL: Reviewing some next-generation non-relational database’s. International Journal of Advanced Engineering Science and Technologies. 2011;11(1):15-30.

MongoDB. Top 5 considerations when evaluating NoSQL databases. 2015;6:8.
(Accessed 5 September 2019)
Available:http://s3.amazonaws.com/info-mongodbcom/10gen_Top_5_NoSQL_Considerations

Tudorica Bogdan George, Cristian Bucur. A comparison between several NoSQL databases with comments and notes. In 2011 RoEduNet International Conference 10th Edition: Networking in Education and Research. IEEE. 2011;1-5.

MongoDB. Why NoSQL? 2014;25:20.
(Accessed 22 September 2019)
Available:http://www.mongodb.com/nosql-explained

Fotache Marin, Dragos Cogean. NoSQL and SQL databases for mobile applications. case study: MongoDB versus PostgreSQL. Informatica Economica. 2013;17(2).

Ullah Md Arman. A digital library for plant information with performance comparison between a relational database and a NoSQL database (RDF Triple Store); 2015.

Moniruzzaman ABM. NoSQL database: New era of databases for big data analytics – Classification, characteristics and comparison. 2013;13:6.
(Accessed 7 September 2019)
Available:https://www.researchgate.net/publication/243963821_NoSQL_Database_New_Era_of_Databases_for_Big_data_Analytics_Classification_Characteristics_and_Comparison/figures?lo=1