Published February 12, 2025 | Version v1
Journal article Open

Hybrid Database System for Big Data Storage and Management

Authors/Creators

Description

Relational database systems have been the standard storage system over the last forty years. Recently, advancements in technologies have led to an exponential increase in data volume, velocity and variety beyond what relational databases can handle. Developers are turning to NoSQL which is a non- relational database for data storage and management. Some core features of database system such as ACID have been compromised in NOSQL databases. This work proposed a hybrid database system for the storage and management of extremely voluminous data of diverse components known as big data, such that the two models are integrated in one system to eliminate the limitations of the individual systems. The system is implemented in MongoDB which is a NoSQL database and SQL. The results obtained, revealed that having these two databases in one system can enhance storage and management of big data bridging the gap between relational and NoSQL storage approach.

Files

7417ijcsea02.pdf

Files (786.0 kB)

Name Size Download all
md5:d893d479fd64ffde13e1c66830d7d8c0
786.0 kB Preview Download

Additional details

Identifiers

URL
https://aircconline.com/ijcsea/V7N4/7417ijcsea02.pdf

Related works

Documents
https://aircconline.com/ijcsea/V7N4/7417ijcsea02.pdf (URL)

Dates

Copyrighted
2017

References

  • [1] Codd, E. F. (1970). "A relational model of data for large shared data banks", Communications of the ACM Vol. 13, No. 6, pp 377–387. [2] Hecht, R., Jablonski, S. (2011) " NoSQL evaluation: A use case oriented survey" Cloud and Service Computing (CSC) International Conference. pp336 – 341 [3] Konstantinou, I., Angelou, E., Boumpouka, C., Tsoumakos, D. and Koziris, N. (2011) "On the elasticity of NoSQL databases over cloud management platforms" In Proceedings of the 20th ACM international conference on Information and knowledge management (CIKM '11), New York, NY, USA [4] Van der Veen, J.S., van der Waaij, B.,Meijer, R.J.(2012) "Sensor Data Storage Performance: SQL or NoSQL, Physical or Virtual" IEEE 5th International Conference on Cloud Computing (CLOUD) pp. 431 – 438. [5] Singh, N., Garg,N.& Mittal,V.(2012). "Big data- Insight, Motivation and Challenges" Internal Journal of Scientific and Engineering Research, Vol. 4 [6] Schram, A., Anderson, K. M. (2012) "MySQL to NoSQL: data modelling challenges in supporting scalability" Proceedings of the 3rd annual conference on Systems, programming, and applications: software for humanity (SPLASH '12). ACM, New York, NY, USA, pp. 191-202. [7] Indrawan-Santiago, M. (2012). "Database Research: Are We at a Crossroad? Reflection on NoSQL." Proceedings of the 15th International Conference on Network-Based Information Systems, pp 45-51. [8] Tauro Clarence T.,Patil,Baswanth R., Prashant K.V.(2013). "A comparative analysis of different NoSQL databases on data model, query model, and replication model" Internal Conference on Emerging Research in Communication and Application ERCICA. Bangalor India [9] Nayak, A. ,Poriya ,A.,Dikshay Poojary (2013)" Types of NoSQL databases and its comparison with relational databases". International Journal of Applied Information Systems Vol.5, No. 4 pp 16-19 [10] Grolinger, K.,Higashinow,T. Wari,Capretz,M.AM (2013)"Data Management in cloud environments: NoSQL and NewSQL data stores" Vo l2. No. 22 [11] Porkony, J. (2013). "NoSQL databases: A step to database scalability in web environment.", International Journal of Web Information Systems • Vol. 9, No.1 pp 69-82. [12] Wu, L., Yuan,L., Huai, Y. (2013). "Survey of large scale data management system for big data applications" Journal of Computer Science and Technology. Vol. 30 pp 163-183. [13] Moniruzzaman, A .B., Hossain, S.A.(2013). "NoSQL database: New era of databases for big data analytics-classification, characteristics and comparison" International Journal of Computer Science and Technology. Vol. 6 No. 4. [14] Nawsher Khan, Ibrar Yaqoob, Ibrahim Abaker Targio Hashem, Zakira Inayat,Waleed Kamaleldin Mahmoud Ali,Muhammad Alam,Muhammad Shiraz,Abdullah Gani (2014). "Big Data: Survey, Technologies, Opportunities, and Challenges" The Scientific World Journal Vol. 2014 , No. 712826 [15] Abramova, V., Bernardino,J., Furtado,P.(2014). "Experimental evaluation of: NoSQL databases" International Journal of Database Management System .Vol.6, No. 3 [16] Abramova, V., Bernardino,J., Furtado,P.(2014). "Which NoSQL database? A performance overview" Open Journal of Databases (OJDB). Vol. 1, Issue 2 [17] Wu, L., Yuan, L., You, J. (2014). "BASIC: An alternative to BASE for large scale data management systems", https://webdocs.cs.ualberta.ca/~yuan/papers/ieee_bigdata.pdf [18] Manoj,V.(2014) "Comparative study of NoSQL document, column store databases and evaluation of Cassandra" International Journal of Database Management Systems ( IJDMS) Vol.6, No.4 [19] Rakesh, K., Shilpi, C., Somya, B(2015)."Effective way to handling big data problems using NoSQL database (MongoDB)" Journal of Advanced Database Management & Systems. Vol. 2, pp 42–48. [20] Wu,C.M.,Huang,Y.F.,Lee,J.(2015). "Comparisons between MongoDB and MS-SQL databases on the TWC website" American Journal of Software Engineering and Applications. Vol. 4 No.2 pp 35-41. [21] GC, Deepak (20016) "A Critical Comparison of NOSQL Databases in the Context of Acid and Base" Culminating Projects inInformation Assurance. Paper 8. [22] Mukherjee, S.,Shaw R.(2016) "Big data concepts, applications, challenges and future scope" International Journal of Advanced Research in Computer and Communication Engineering Vol. 5, Issue 2 [23] http://refreshmymind.com/wpcontent/uploads/2016/02/nosql_documents_stores_mongodb couchdb.png [24] Albertas, Krisaunas, Benefits of NoSQL. https://www.devbridge.com/articles/benefits-of-nosql/# [25] Why NoSQL, http://img.blog.csdn.net/20151001143133915