Method for integrating relational and non-relational databases in hybrid information systems
DOI:
https://doi.org/10.33216/1998-7927-2026-304-6-121-127Keywords:
NoSQL databases, relational databases (SQL), hybrid architectures, database integration, Big Data, artificial intelligence, digital transformationAbstract
This paper introduces a methodologically substantiated approach to integrating relational and non-relational databases within hybrid information systems. The proposed solution is based on the principles of polyglot persistence and considers both data characteristics and requirements related to consistency, performance, and distribution. The approach enables effective workload distribution between SQL and NoSQL components, achieving a balance between reliable transaction processing and efficient handling of large-scale data. Currently, the evolution of information technologies is characterized by a rapid increase in data volume, diversity of data formats, and growing demands for processing speed and scalability. Under such conditions, conventional relational databases, which emphasize rigid schemas and strong transactional guarantees, encounter difficulties when dealing with unstructured and semi-structured data. In contrast, NoSQL systems offer flexibility, horizontal scalability, and high performance in Big Data scenarios, yet they often lack robust mechanisms for ensuring consistency and supporting complex transactions. These challenges highlight the necessity of hybrid architectures that combine the advantages of both paradigms. The relevance of this study is driven by the rising demand for hybrid data management solutions in domains such as Big Data analytics, artificial intelligence (AI), the Internet of Things (IoT), and enterprise digital transformation. The expected outcomes of the research include improved system performance through adaptive selection of data storage models, reduced costs associated with scaling, and enhanced consistency in distributed environments. The scientific contribution of this work lies in the formalization of the integration process and the establishment of a foundation for developing universal hybrid data management platforms. The practical value of the proposed method is demonstrated by its applicability to intelligent decision support systems, analytical platforms, and high-load web applications.
References
1. Bjeladinovic S., Marjanovic Z., Babarogic S. A proposal of architecture for integration and uniform use of hybrid SQL/NoSQL database components // Journal of Systems and Software. 2020. Vol. 168. Article 110633. DOI: https://doi.org/10.1016/j.jss.2020.110633
2. Kazanavičius J., Mažeika D., Kalibatienė D. An approach to migrate a monolith database into multi-model polyglot persistence based on microservice architecture: A case study for mainframe database // Applied Sciences. 2022. Vol. 12, No. 12. Art. 6189. DOI: https://doi.org/10.3390/app12126189
3. Zhang L., Li X. JSON-based control model for SQL and NoSQL data integration in hybrid cloud storage // Journal of Cloud Computing: Advances, Systems and Applications. 2022. Vol. 11, No. 1. P. 1–13. DOI: https://doi.org/10.1186/s13677-022-00302-9
4. Tripathi N. NoSQL database education: A review of models, tools and teaching methods // Journal of Systems and Software. 2025. Vol. 226. Art. 112391. DOI: https://doi.org/10.1016/j.jss.2025.112391
5. Ragunathan A. Integration of NoSQL and Relational Databases for Efficient Data Management in Hybrid Cloud Architectures // Journal of Machine and Computing. 2025. Vol. 5, No. 2. P. 1277–1286. DOI: https://doi.org/10.53759/7669/jmc202505100
6. Bitton U. Using SQL and NoSQL Databases Together // Tech Odyssey. 2025. March 24. URL: https://medium.com/tech-odyssey/using-sql-and-nosql-databases-together-8452a32a9227
7. Bhupathi S. Building Scalable AI-Powered Applications with Cloud Databases: Architectures, Best Practices and Performance Considerations // arXiv. 2025. URL: https://arxiv.org/abs/2504.18793
8. Goze I. M., Erginer G., Dilber C., Pozut B., Ozpinar A. Hybrid Data Management Architecture with Microservices Integrating SQL and NoSQL Databases for Asset Management Companies // Oracle Journal of Research. 2024. Vol. 12, No. 1. P. 45–58. URL: https://journals.orclever.com/oprd/article/view/586
