Leveraging Database Technologies for Efficient Data Modeling and Storage in Web Applications
DOI:
https://doi.org/10.32628/CSEIT25113374Keywords:
Database Technologies, RDBMS, NoSQL, Cloud Databases, Distributed Storage, Hybrid Models, Machine Learning (ML)Abstract
Today’s data-intensive digital environment is populated with web applications in every industry that hinge on a large amount of diverse and dynamic data, which requires sophisticated systems for managing this data in applications. The importance of data modelling and storage is discussed in this study the development of efficient, scalable, and reliable web applications. It is detailed in terms of data modeling fundamentals, such as the identification of the entities, mapping relationships, and optimizing the schema to ensure the data remains intact and the application logic is simple. It is a study that compares three major database technologies that are Relational (SQL), NoSQL, and NewSQL, and tries to compare their architecture, strengths, and ideal use cases. Moreover, it brings attention to recent database innovations, including cloud-native and serverless databases and AI and machine learning (ML) for self-managing of databases and data analytics. Schema optimization and all the rest of the strategies for storage data are also discussed. The paper synthesizes from current practices and emerging trends, and offers comprehensive insights to help developers and organizations make the best selection of data technologies that will help in improving overall application performance, data security, and real-time decision making.
Downloads
References
A. V. A. Krishna, “A Survey on Current Technologies for Web Development,” Int. J. Eng. Res., 2020, doi: 10.17577/ijertv9is060267.
J. Shetty, D. Dash, and A. K. Joish, “Review Paper on Web Frameworks, Databases and Web Stacks,” Int. Res. J. Eng. Technol., vol. 07, no. 04, pp. 5734–5738, 2020.
V. S. Thokala, “Efficient Data Modeling and Storage Solutions with SQL and NoSQL Databases in Web Applications,” Int. J. Adv. Res. Sci. Commun. Technol., vol. 2, no. 1, pp. 470–482, Apr. 2022, doi: 10.48175/IJARSCT-3861B.
B. Al-Ahmad and K. Al Debei, “Survey of Testing Methods for Web Applications,” Eur. Int. J. Sci. Technol., vol. 9, no. 12, pp. 1–22, 2020.
A. K. Sandhu, “Big data with cloud computing: Discussions and challenges,” Big Data Min. Anal., vol. 5, no. 1, pp. 32–40, 2022, doi: 10.26599/BDMA.2021.9020016.
V. S. Thokala, “A Comparative Study of Data Integrity and Redundancy in Distributed Databases for Web Applications,” IJRAR, vol. 8, no. 4, pp. 383–389, 2021.
R. Omollo and S. Alago, “Data modeling techniques used for big data in enterprise networks,” Int. J. Adv. Technol. Eng. Explor., vol. 7, no. 65, pp. 79–92, 2020.
J. Han, E. Haihong, G. Le, and J. Du, “Survey on NoSQL database,” in Proceedings - 2011 6th International Conference on Pervasive Computing and Applications, ICPCA 2011, 2011. doi: 10.1109/ICPCA.2011.6106531.
M. Shah and A. Gogineni, “Distributed Query Optimization for Petabyte-Scale Databases,” Int. J. Recent Innov. Trends Comput. Commun., vol. 10, no. 10, pp. 223–231, 2022.
J. Han, M. Song, and J. Song, “A novel solution of distributed memory NoSQL database for cloud computing,” in Proceedings - 2011 10th IEEE/ACIS International Conference on Computer and Information Science, ICIS 2011, 2011. doi: 10.1109/ICIS.2011.61.
B. G. Tudorica and C. Bucur, “A comparison between several NoSQL databases with comments and notes,” in Proceedings - RoEduNet IEEE International Conference, 2011. doi: 10.1109/RoEduNet.2011.5993686.
L. Okman, N. Gal-Oz, Y. Gonen, E. Gudes, and J. Abramov, “Security issues in NoSQL databases,” in Proc. 10th IEEE Int. Conf. on Trust, Security and Privacy in Computing and Communications, TrustCom 2011, 8th IEEE Int. Conf. on Embedded Software and Systems, ICESS 2011, 6th Int. Conf. on FCST 2011, 2011. doi: 10.1109/TrustCom.2011.70.
C. J. M. Tauro, A. S, and S. A.B, “Comparative Study of the New Generation, Agile, Scalable, High Performance NOSQL Databases,” Int. J. Comput. Appl., vol. 48, no. 20, pp. 1–4, Jun. 2012, doi: 10.5120/7461-0336.
A. Goyal, “Reducing Defect Rates with AI-Powered Test Engineering and JIRA Automation in Agile Workflows,” Int. J. Curr. Eng. Technol., vol. 13, no. 6, pp. 554–560, 2023, doi: 10.14741/ijcet/v.13.6.7.
S. Singamsetty, “Fuzzy-Optimized Lightweight Cyber-Attack Detection For Secure Edge-Based IoT Networks,” J. Crit. Rev., vol. 6, no. 07, 2019, doi: 10.53555/jcr.v6:i7.13156.
A. Alsirhani, P. Bodorik, and S. Sampalli, “Improving Database Security in Cloud Computing by Fragmentation of Data,” in 2017 International Conference on Computer and Applications, ICCA 2017, 2017. doi: 10.1109/COMAPP.2017.8079737.
A. W. S. Aurora, S. Pillai, and V. S. Thokala, “Data synchronisation strategies for distributed web applications using MySQL, MongoDB and AWS Aurora,” Int. J. Sci. Res. Arch., vol. 09, no. 01, pp. 779–793, 2023.
K. Gandhi and P. Verma, “ML in Energy Sector Revolutionizing the Energy Sector Machine Learning Applications for Efficiency, Sustainability and Predictive Analytics,” Int. J. Sci. Res. Arch., vol. 07, no. 01, pp. 533–541, 2022, doi: 10.30574/ijsra.2022.7.1.0226.
S. Tyagi, T. Jindal, S. H. Krishna, S. M. Hassen, S. K. Shukla, and C. Kaur, “Comparative Analysis of Artificial Intelligence and its Powered Technologies Applications in the Finance Sector,” in 2022 5th International Conference on Contemporary Computing and Informatics (IC3I), IEEE, Dec. 2022, pp. 260–264. doi: 10.1109/IC3I56241.2022.10073077.
Abhishek and P. Khare, “Cloud Security Challenges: Implementing Best Practices for Secure SaaS Application Development,” Int. J. Curr. Eng. Technol., vol. 11, no. 06, pp. 669–676, Nov. 2021, doi: 10.14741/ijcet/v.11.6.11.
O. J. Akindote, A. O. Adegbite, S. O. Dawodu, Adedolapo Omotosho, and Anthony Anyanwu, “Innovation in Data Storage Technologies: From Cloud Computing to Edge Computing,” Comput. Sci. IT Res. J., vol. 4, no. 3, pp. 273–299, Dec. 2023, doi: 10.51594/csitrj.v4i3.661.
K. D. Albab et al., “K9db: Privacy-Compliant Storage For Web Applications By Construction,” in Proceedings of the 17th USENIX Symposium on Operating Systems Design and Implementation, OSDI 2023, 2023.
M. A. Elmeiligy, A. I. E. Desouky, and S. M. Elghamrawy, “An efficient parallel indexing structure for multi-dimensional big data using spark,” J. Supercomput., 2021, doi: 10.1007/s11227-021-03718-3.
C. H. Costa, J. V. B. M. Filho, P. H. M. Maia, and F. C. M. B. Oliveira, “Sharding by hash partitioning: A database scalability pattern to achieve evenly sharded database clusters,” in ICEIS 2015 - 17th International Conference on Enterprise Information Systems, Proceedings, 2015. doi: 10.5220/0005376203130320.
S. Bagui and L. T. Nguyen, “Database Sharding: To Provide Fault Tolerance and Scalability of Big Data on the Cloud,” Int. J. Cloud Appl. Comput., vol. 5, no. 2, pp. 36–52, 2015, doi: 10.4018/ijcac.2015040103.
D. Bai, “Design of Artificial Intelligence Information System Using NoSQL Database and Ajax Technology,” in 2023 International Conference on Applied Physics and Computing (ICAPC), 2023, pp. 678–683. doi: 10.1109/ICAPC61546.2023.00133.
S. Hamouda, “Seamless Transition: Migrating from Relational Databases to Document-Oriented Databases,” in Proceedings of the IEEE International Conference on Intelligent Data Acquisition and Advanced Computing Systems: Technology and Applications, IDAACS, 2023. doi: 10.1109/IDAACS58523.2023.10348946.
S. N. Turhan, “Leveraging Graph Databases for Enhanced Healthcare Data Management: A Performance Comparison Study,” in Proceedings - 2023 IEEE International Conference on Big Data, BigData 2023, 2023. doi: 10.1109/BigData59044.2023.10386297.
H. Wang, R. Gao, C. Zhang, L. Wang, and H. Li, “Joint Workload Forecasting and Configuration Tuning to Achieve Cloud Database Performance Adaptation,” in Proceedings - 2023 International Conference on Frontiers of Robotics and Software Engineering, FRSE 2023, 2023. doi: 10.1109/FRSE58934.2023.00033.
J. Lian, S. Wang, and Y. Xie, “TDRB: An Efficient Tamper-Proof Detection Middleware for Relational Database Based on Blockchain Technology,” IEEE Access, 2021, doi: 10.1109/ACCESS.2021.3076235.
J. M. A. Araujo, A. C. E. De Moura, S. L. B. Da Silva, M. Holanda, E. D. O. Ribeiro, and G. L. Da Silva, “Comparative Performance Analysis of NoSQL Cassandra and MongoDB Databases,” in Iberian Conference on Information Systems and Technologies, CISTI, 2021. doi: 10.23919/CISTI52073.2021.9476319.
Downloads
Published
Issue
Section
License
Copyright (c) 2024 International Journal of Scientific Research in Computer Science, Engineering and Information Technology
This work is licensed under a Creative Commons Attribution 4.0 International License.