Open Access   Article Go Back

Query Performance Analysis in NoSQL and Relational Dtabases: MongoDB Vs MySQL

Benymol Jose1 , Sajimon Abraham2 , Praveen Kumar V S3

Section:Research Paper, Product Type: Journal Paper
Volume-06 , Issue-04 , Page no. 179-182, May-2018

Online published on May 31, 2018

Copyright © Benymol Jose, Sajimon Abraham, Praveen Kumar V S . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: Benymol Jose, Sajimon Abraham, Praveen Kumar V S , “Query Performance Analysis in NoSQL and Relational Dtabases: MongoDB Vs MySQL,” International Journal of Computer Sciences and Engineering, Vol.06, Issue.04, pp.179-182, 2018.

MLA Style Citation: Benymol Jose, Sajimon Abraham, Praveen Kumar V S "Query Performance Analysis in NoSQL and Relational Dtabases: MongoDB Vs MySQL." International Journal of Computer Sciences and Engineering 06.04 (2018): 179-182.

APA Style Citation: Benymol Jose, Sajimon Abraham, Praveen Kumar V S , (2018). Query Performance Analysis in NoSQL and Relational Dtabases: MongoDB Vs MySQL. International Journal of Computer Sciences and Engineering, 06(04), 179-182.

BibTex Style Citation:
@article{Jose_2018,
author = {Benymol Jose, Sajimon Abraham, Praveen Kumar V S },
title = {Query Performance Analysis in NoSQL and Relational Dtabases: MongoDB Vs MySQL},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {5 2018},
volume = {06},
Issue = {04},
month = {5},
year = {2018},
issn = {2347-2693},
pages = {179-182},
url = {https://www.ijcseonline.org/full_spl_paper_view.php?paper_id=377},
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
UR - https://www.ijcseonline.org/full_spl_paper_view.php?paper_id=377
TI - Query Performance Analysis in NoSQL and Relational Dtabases: MongoDB Vs MySQL
T2 - International Journal of Computer Sciences and Engineering
AU - Benymol Jose, Sajimon Abraham, Praveen Kumar V S
PY - 2018
DA - 2018/05/31
PB - IJCSE, Indore, INDIA
SP - 179-182
IS - 04
VL - 06
SN - 2347-2693
ER -

           

Abstract

To improve the data processing of the unstructured data generated, a NoSQL framework can be used to achieve better distribution of storage and analysis work of the collected big data. NoSQL is particularly helpful when a venture needs to get to and investigate huge measure of unstructured information or information that is put away on numerous virtual servers. MongoDB uses an extensive variety of methods to solve the huge information execution issues that ordinary databases were not intended to solve. Relational databases like MySQL are storing data in structured format in tables as rows and columns. This paper concentrates on the advantages of NoSQL databases over relational databases in the analysis of the big data. It mainly uses MongoDB which is one of the boosting technology of NoSQL databases and makes a performance comparison of a particular query in MySQL and MongoDB and justifies why MongoDB is preferred over MySQL.

Key-Words / Index Term

Unstructured Data, NoSQL Databases, MongoDB, Relational Databases, MySQL

References

[1] Yesha Mehta, and Sanjay Buch, “Big Data Mining and Semantic Technologies: Challenges and Opportunities”, Int. J. on Recent and Innovation Trends in Computing and Communications(ISSN 2321-8169) ,Vol.3, Issue.7,pp.4907-4913, 2015.
[2] Lidong Wang ,and Cheryl Ann Alexander, ”Big Data Driven Supply Chain Management and Business Administration”, American Journal of Economics and Business Administration,Vol.7, Issue.2, pp.60-67, 2015.
[3] Dipina Damodaran B , Shirin Salim, Surekha Marium Vargese ,”Performance Evaluation of MySQL and MongoDB databases”, Int.J of Cybernetics and Informatics,Vol.5, Issue.2,pp.387-394, 2016.
[4] Sanobar Khan, Vanita Mane, “SQL support over MongoDB using metadata”. International Journal of Scientific and Research publications, Vol.3,Issue.10,pp.1-5,2013.
[5] Seyyed Hamid Aboutorabi, Mehdi Rezapour, Milad Moradi, Nasser Ghadiri, “Performance evaluation of SQL and MongoDB databases for big e-commerce data”, International Symposium on Computer Science and Software Engineering (CSSE),Tabriz, Iran,pp.72-78, 2015.
[6] Zhu Wei-ping, Li Ming-xin, Chen Huan,” Using MongoDB to implement textbook management system instead of MySQL”, IEEE 3rd International Conference on Communication Software and Networks, Xi’an, China, pp.828-830, 2011.
[7] Enqing Tang, Yushun Fan, “Performance Comparison between Five NoSQL Databases”, 7th International Conference on Cloud Computing and Big Data (CCBD), Macau, China, pp.105-109, 2016.
[8] Azhi Faraj,Bilal Rashid,Twana Shareef, ”Comparative Study of Relational and Non Relations Database Performance using ORACLE and MongoDB Systems”, International Journal of Computer Engineering & Technology,Vol.5,Issue.11,pp.11-22, 2014.
[9] Nancy Bhardwah, Gurvinder Kaur, “Greedy based privacy preserving in Data Mining using NoSQL”, International Journal of Engineering Development and Research, Vol.5, Issue.1, pp.9-17, 2017