Open Access   Article Go Back

Comparative Study of Integrity Constraints, Storage and Profile Management of Relational and Non-Relational Database using MongoDB and Oracle

V.J. Dindoliwala1 , R.D. Morena2

Section:Review Paper, Product Type: Journal Paper
Volume-6 , Issue-7 , Page no. 831-837, Jul-2018

CrossRef-DOI:   https://doi.org/10.26438/ijcse/v6i7.831837

Online published on Jul 31, 2018

Copyright © V.J. Dindoliwala, R.D. Morena . 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

XML View
PDF Download

How to Cite this Paper

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

IEEE Style Citation: V.J. Dindoliwala, R.D. Morena, “Comparative Study of Integrity Constraints, Storage and Profile Management of Relational and Non-Relational Database using MongoDB and Oracle,” International Journal of Computer Sciences and Engineering, Vol.6, Issue.7, pp.831-837, 2018.

MLA Style Citation: V.J. Dindoliwala, R.D. Morena "Comparative Study of Integrity Constraints, Storage and Profile Management of Relational and Non-Relational Database using MongoDB and Oracle." International Journal of Computer Sciences and Engineering 6.7 (2018): 831-837.

APA Style Citation: V.J. Dindoliwala, R.D. Morena, (2018). Comparative Study of Integrity Constraints, Storage and Profile Management of Relational and Non-Relational Database using MongoDB and Oracle. International Journal of Computer Sciences and Engineering, 6(7), 831-837.

BibTex Style Citation:
@article{Dindoliwala_2018,
author = {V.J. Dindoliwala, R.D. Morena},
title = {Comparative Study of Integrity Constraints, Storage and Profile Management of Relational and Non-Relational Database using MongoDB and Oracle},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {7 2018},
volume = {6},
Issue = {7},
month = {7},
year = {2018},
issn = {2347-2693},
pages = {831-837},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=2520},
doi = {https://doi.org/10.26438/ijcse/v6i7.831837}
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
DO = {https://doi.org/10.26438/ijcse/v6i7.831837}
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=2520
TI - Comparative Study of Integrity Constraints, Storage and Profile Management of Relational and Non-Relational Database using MongoDB and Oracle
T2 - International Journal of Computer Sciences and Engineering
AU - V.J. Dindoliwala, R.D. Morena
PY - 2018
DA - 2018/07/31
PB - IJCSE, Indore, INDIA
SP - 831-837
IS - 7
VL - 6
SN - 2347-2693
ER -

VIEWS PDF XML
452 413 downloads 122 downloads
  
  
           

Abstract

In the last decade, there is a rapid development in web technologies, social media applications and mobile applications which generates unstructured data. The way these applications deal with data has been changed extensively over the last decade. These applications collect more data and more users are accessing these data concurrently than ever before. Thus it is a big challenge for relational databases in terms of scalability and performance to handle these data which has given boost to the initiation of various NoSQL databases. Among the several NoSQL databases, MongoDB is the most popular document store database because of its sharding and aggregation framework coupled with document validations and efficient data manipulation, fine-grained locking, replication facility, administration capabilities and so on. In this paper, we have studied how integrity constraints, contents and resources are managed by MongoDB and also studied various features provided by MongoDB and compared them with the widely used Oracle database.

Key-Words / Index Term

Relational databases, Non-Relational Databases, Integrity Constraints, Relationships, Resources, Profile

References

[1] P. Colombo, E. Ferrari, “Enhancing MongoDB with Purpose-Based Access Control”, IEEE Transactions on Dependable and Secure Computing, Vol. 14, Issue. 6, pp. 591 – 604, 2015.
[2] A MongoDB White Paper, “MongoDB Architecture Guide”, MongoDB 3.2.
[3] An Oracle White Paper, “Effective Resource Management Using Oracle Database Resource Manager”, 2011.
[4] A. Boicea, F. Radulescu, L. Gapin,“MongoDB vs Oracle -- Database Comparison”, Third International Conference on Emerging Intelligent Data and Web Technologies (EIDWT), 2012, doi: 10.1109/EIDWT.2012.32.
[5] K. Georgiev, “Referential Integrity and Dependencies between Documents in a Document Oriented Database”, GSTF Journal on Computing (JoC), Vol. 2, No. 4, pp. 24-28, 2013.
[6] H. Raja, ”Referential Integrity in Cloud NoSQL Databases”, A thesis submitted to the Victoria University of Wellington, 2012.
[7] V. J. Dindoliwala, R. D. Morena, ”Survey on Security Mechanisms In NoSQL Databases”, International Journal of Advanced Research in Computer Science, Vol. 8, No. 5, pp. 333-338, 2017, ISSN No. 0976-5697.

[8] S. Agrawal, J. Verma, B. Mahidhariya, N. Patel, A. Patel, “Survey on MongoDB: An Open-Source Document Database”, International Journal of Advanced Research in Engineering and Technology, Vol. 6, Issue. 12, pp. 01-11, 2015, ISSN Print: 0976-6480.
[9] Z. Parker, S. Poe, S. Vrbsky, “Comparing nosql Mongodb to an sql db”, proceeding of the 51th ACM Southest Conference, Article No. 5, 2013, ISBN: 978-1-4503-1901-0.
[10] Chaitanya. P, Ranjan H. P, Kiran T. S, Anitha. K, “Implementation of an Efficient MongoDB NoSQL Explorer for Big Data Visualization”, International Journal of Advanced Networking & Applications (IJANA), pp. 444 – 447, ISSN: 0975-0282.
[11] A MongoDB White Paper, “RDBMS to MongoDB Migration Guide”, Considerations and Best Practices, 2018.
[12] K. Bhamra, “A Comparative Analysis of MongoDB and Cassandra”, A thesis presented for the degree of Master of Science, Department of Informatics, University of Bergen, 2017.
[13] Swathi N, “Making your Application Highly Available and Highly Scalable using NoSQL Database (MONGODB)”, International Journal of Advanced Computational Engineering and Networking, Vol. 1, Issue. 7, pp. 40 – 43, 2013, ISSN: 2320-2106.
[14] L. Bonnet, A. Laurent, M. Sala, B. Laurent, N. Sicard, “Reduce, You Say: What NoSQL can do for Data Aggregation and BI in Large Repositories”, 22nd International Workshop on Database and Expert Systems Applications, pp. 483-488, 2011, doi: 10.1109/DEXA.2011.71,
[15] A. Nayak, A. Poriya, D. Poojary, ”Type of NoSQL Databases and its Comparison with Relational Databases”, International Journal of Applied Information Systems (IJAIS), Vol. 5, No. 4, pp. 16-19, 2013, ISSN : 2249-0868.
[16] N. Jatana, S. Puri, M. Ahuja, I. Kathuria, D. Gosain, “A Survey and Comparison of Relational and Non-Relational Database”, International Journal of Engineering Research & Technology, Vol. 1, Issue. 6, pp. 1-5, 2012, ISSN: 2278-0181.
[17] Y. Li, S. Manoharan, “A performance comparison of SQL and NoSQL databases”, IEEE Pacific Rim Conference on Communications, Computers and Signal Processing (PACRIM), pp. 15-19, 2013, Electronic ISBN: 978-1-4799-1501-9.
[18] K. Chodorow, “MongoDB: The Definitive Guide”, 2nd edition, O’Reilly, 2013, ISBN: 978-1-449-34468-9.
[19] B. Jose, S. Abraham, Praveen Kumar V. S., ”Query Performance Analysis in NoSQL and Relational Databases: MongoDB Vs MySQL”, International Journal of Computer Sciences and Engineering, Vol. 6, Special Issue. 4, pp. 179-182, 2018.