Integration of NoSQL and Relational Databases for Efficient Data Management in Hybrid Cloud Architectures
Aravindhan Ragunathan
Senior Full Stack Software Developer, Digital Factory, Instrumentation Laboratory, 180 Hartwell Road, Bedford, MA 01730-2443, United States of America.
NoSQL and relational databases have been integrated in response to the increasing demand for scalable and efficient data management in hybrid cloud environments. The differences in data structures and query processing methods between these databases present both challenges and opportunities when designing an optimized hybrid system. This study explores the integration of NoSQL and relational databases to maximize data storage, retrieval, and processing efficiency across multiple cloud systems. NoSQL databases excel in handling unstructured and semi-structured data, offering flexibility and scalability, whereas relational databases provide robust consistency and structured query capabilities. Despite the wide availability of relational databases, certain applications require the dynamic adaptability of NoSQL systems, making integration a viable solution. The research evaluates key performance parameters, including query execution speed, scalability, data consistency, and resource utilization. Cloudsim is used for simulation, allowing for an in-depth comparison between standalone and hybrid database models. Experimental results indicate that the proposed hybrid model improves query performance by 30%, reduces latency by 20%, and enhances scalability by 40% compared to using relational or NoSQL databases alone. The novelty of this approach lies in its ability to overcome the limitations of each database type by their strengths in a dynamic cloud environment. The results highlight the effectiveness of hybrid database integration in optimizing cloud-based data management while ensuring seamless operation, adaptability, and resource efficiency.
Keywords
Hybrid Cloud, NoSQL, Relational Databases, Data Management, Scalability, CloudSim.
M. Kvet, J. Papan, and M. H. Durneková, “Treating Temporal Function References in Relational Database Management System,” IEEE Access, vol. 12, pp. 54518–54535, 2024, doi: 10.1109/access.2024.3387046.
T. Taipalus, “Vector database management systems: Fundamental concepts, use-cases, and current challenges,” Cognitive Systems Research, vol. 85, p. 101216, Jun. 2024, doi: 10.1016/j.cogsys.2024.101216.
A. Malik, A. Burney, and F. Ahmed, “A Comparative Study of Unstructured Data with SQL and NO-SQL Database Management Systems,” Journal of Computer and Communications, vol. 08, no. 04, pp. 59–71, 2020, doi: 10.4236/jcc.2020.84005.
W. Khan, T. Kumar, C. Zhang, K. Raj, A. M. Roy, and B. Luo, “SQL and NoSQL Database Software Architecture Performance Analysis and Assessments—A Systematic Literature Review,” Big Data and Cognitive Computing, vol. 7, no. 2, p. 97, May 2023, doi: 10.3390/bdcc7020097.
R. Aravindhan, R. Shanmugalakshmi, and K. Ramya, “Circumvention of Nascent and Potential Wi-Fi Phishing Threat Using Association Rule Mining,” Wireless Personal Communications, vol. 94, no. 4, pp. 2331–2361, Jul. 2016, doi: 10.1007/s11277-016-3451-1.
B. A. Reddy, G. Someswara Reddy, K. Lokesh, S. B, and R. M, “AI-Driven Stress Analysis and Management: A Novel Approach Leveraging OpenAI and NoSQL Databases to Empower Students in Stress Management and Promote Overall Student Well-being and Academic Progression,” 2024 International Conference on Computational Intelligence and Computing Applications (ICCICA), pp. 210–215, May 2024, doi: 10.1109/iccica60014.2024.10584920.
K. Nguyễn, “NoSQL Languages and Systems,” NoSQL Data Models, pp. 1–20, Aug. 2018, doi: 10.1002/9781119528227.ch1.
Y. Wang, “Application of large language models based on knowledge graphs in question-answering systems: A review,” Applied and Computational Engineering, vol. 71, no. 1, pp. 78–82, Aug. 2024, doi: 10.54254/2755-2721/71/20241636.
I. Carvalho, F. Sá, and J. Bernardino, “NoSQL Document Databases Assessment: Couchbase, CouchDB, and MongoDB,” Proceedings of the 11th International Conference on Data Science, Technology and Applications, pp. 557–564, 2022, doi: 10.5220/0011352700003269.
R. Aravindhan, R. Shanmugalakshmi, K. Ramya, and Selvan C., “Certain investigation on web application security: Phishing detection and phishing target discovery,” 2016 3rd International Conference on Advanced Computing and Communication Systems (ICACCS), pp. 1–10, Jan. 2016, doi: 10.1109/icaccs.2016.7586405.
Z. Zhang, A. Megargel, and L. Jiang, “Performance Evaluation of NewSQL Databases in a Distributed Architecture,” IEEE Access, vol. 13, pp. 11185–11194, 2025, doi: 10.1109/access.2025.3529740.
J. A. Shamsi and M. A. Khojaye, “NewSQL Systems,” Big Data Systems, pp. 171–180, Apr. 2021, doi: 10.1201/9780429155444-10.
S. V. Salunke and A. Ouda, “A Performance Benchmark for the PostgreSQL and MySQL Databases,” Future Internet, vol. 16, no. 10, p. 382, Oct. 2024, doi: 10.3390/fi16100382.
B. F. Cooper, A. Silberstein, E. Tam, R. Ramakrishnan, and R. Sears, “Benchmarking cloud serving systems with YCSB,” Proceedings of the 1st ACM symposium on Cloud computing, Jun. 2010, doi: 10.1145/1807128.1807152.
W. Truskowski, R. Klewek, and M. Skublewska-Paszkowska, “Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization,” Journal of Computer Sciences Institute, vol. 16, pp. 279–284, Sep. 2020, doi: 10.35784/jcsi.2026.
K. Grolinger, W. A. Higashino, A. Tiwari, and M. A. Capretz, “Data management in cloud environments: NoSQL and NewSQL data stores,” Journal of Cloud Computing: Advances, Systems and Applications, vol. 2, no. 1, Dec. 2013, doi: 10.1186/2192-113x-2-22.
P. Atzeni, F. Bugiotti, L. Cabibbo, and R. Torlone, “Data modeling in the NoSQL world,” Computer Standards & Interfaces, vol. 67, p. 103149, Jan. 2020, doi: 10.1016/j.csi.2016.10.003.
C. Chen, X. Yan, F. Zhu, J. Han, and P. S. Yu, “Graph OLAP: Towards Online Analytical Processing on Graphs,” 2008 Eighth IEEE International Conference on Data Mining, pp. 103–112, Dec. 2008, doi: 10.1109/icdm.2008.30.
E. M. Kuszera, L. M. Peres, and M. Didonet Del Fabro, “Exploring data structure alternatives in the RDB to NoSQL document store conversion process,” Information Systems, vol. 105, p. 101941, Mar. 2022, doi: 10.1016/j.is.2021.101941.
S. Abbas FADHEL and E. Ali JAMEEL, “A Comparison Between Nosql And Rdbms: Storage And Retrieval,” MINAR International Journal of Applied Sciences and Technology, vol. 04, no. 03, pp. 172–184, Sep. 2022, doi: 10.47832/2717-8234.12.18.
V. F. de Oliveira, M. A. de O. Pessoa, F. Junqueira, and P. E. Miyagi, “SQL and NoSQL Databases in the Context of Industry 4.0,” Machines, vol. 10, no. 1, p. 20, Dec. 2021, doi: 10.3390/machines10010020.
S. Sicari, A. Rizzardi, and A. Coen-Porisini, “Security&privacy issues and challenges in NoSQL databases,” Computer Networks, vol. 206, p. 108828, Apr. 2022, doi: 10.1016/j.comnet.2022.108828.
CRediT Author Statement
The authors confirm contribution to the paper as follows:
Conceptualization: Aravindhan Ragunathan, Bhavani K, Archana Sasi and Sathish Kumar R;
Methodology: Aravindhan Ragunathan and Bhavani K;
Software: Archana Sasi and Sathish Kumar R;
Data Curation: Aravindhan Ragunathan and Bhavani K;
Writing- Original Draft Preparation: Aravindhan Ragunathan, Bhavani K, Archana Sasi and Sathish Kumar R;
Visualization: Aravindhan Ragunathan and Bhavani K;
Investigation: Archana Sasi and Sathish Kumar R;
Supervision: Aravindhan Ragunathan and Bhavani K;
Validation: Archana Sasi and Sathish Kumar R;
Writing- Reviewing and Editing: Aravindhan Ragunathan, Bhavani K, Archana Sasi and Sathish Kumar R;
All authors reviewed the results and approved the final version of the manuscript.
Acknowledgements
We would like to thank Reviewers for taking the time and effort necessary to review the manuscript. We sincerely appreciate all valuable comments and suggestions, which helped us to improve the quality of the manuscript.
Funding
No funding was received to assist with the preparation of this manuscript.
Ethics declarations
Conflict of interest
The authors have no conflicts of interest to declare that are relevant to the content of this article.
Availability of data and materials
Data sharing is not applicable to this article as no new data were created or analysed in this study.
Author information
Contributions
All authors have equal contribution in the paper and all authors have read and agreed to the published version of the manuscript.
Corresponding author
Aravindhan Ragunathan
Senior Full Stack Software Developer, Digital Factory, Instrumentation Laboratory, 180 Hartwell Road, Bedford, MA 01730-2443, United States of America.
Open Access This article is licensed under a Creative Commons Attribution NoDerivs is a more restrictive license. It allows you to redistribute the material commercially or non-commercially but the user cannot make any changes whatsoever to the original, i.e. no derivatives of the original work. To view a copy of this license, visit https://creativecommons.org/licenses/by-nc-nd/4.0/
Cite this article
Aravindhan Ragunathan, Bhavani K, Archana Sasi and Sathish Kumar R, “Integration of NoSQL and Relational Databases for Efficient Data Management in Hybrid Cloud Architectures”, Journal of Machine and Computing, pp. 1277-1287, April 2025, doi: 10.53759/7669/jmc202505100.
