The service model of a heterogeneous distributed database for software system scaling
DOI:
https://doi.org/10.34185/1562-9945-4-153-2024-13Keywords:
distributed DBMS, database cluster, OLTP, ACID, JSON, geospatial data, horizontal scaling, database performance.Abstract
The article explores the topicality of horizontal scaling for software systems that re-quire the use of database management systems (DBMS) to process large volumes of structured, JSON, and geospatial data, while maintaining requirements for ACID proper-ties and data integrity. An analysis of existing products is conducted, outlining their main advantages, disadvantages and identifying issues such as single points of failure, techni-cal limitations, and lack of support for necessary functionality. To solve these issues, a service model of a heterogeneous distributed database is developed, providing a descrip-tion of its characteristics and architecture. Using Kubernetes technology, performance metrics of the database cluster based on the developed model are investigated, demon-strating superior performance compared to the products discussed.
References
Design and Development of a Relational Database Management System (RDBMS) with Open Source Tools for the Processing of Data Monitored in a Set of Photo-voltaic (PV) Plants / D. Trillo-Montero et al. Applied Sciences. 2023. Vol. 13, no. 3. P. 1357. URL: https://doi.org/10.3390/app13031357 (date of access: 12.04.2024).
A framework and databases for measuring entrepreneurial ecosystems / E.Johnson, I. Hemmatian, L. Lanahan, A. M. Joshi. // Research Policy. – 2022. – no. 2.
Simanjuntak E., Surantha N. Multiple time series database on microservice archi-tecture for IoT-based sleep monitoring system. Journal of Big Data. 2022. Vol. 9, no. 1. URL: https://doi.org/10.1186/s40537-022-00658-4 (date of access: 09.04.2024).
Wu A., Guo J., Yang P. Research on Data Sharing Architecture for Ecological Monitoring Using Iot Streaming Data. IEEE Access. 2020. Vol. 8. P. 195385–195397. URL: https://doi.org/10.1109/access.2020.3034466 (date of access: 12.04.2024).
Citus: distributed PostgreSQL for data-intensive applications / [U. Cubukcu, O. Erdogan, S. Pathak and other.]. // SIGMOD. – 2021. – P. 2490–2502.
Cockroach Labs Documentation Team. CockroachDB Docs. CockroachDB Docs. URL: https://www.cockroachlabs.com/docs/ (date of access: 12.04.2024).
Pina E., Sá F., Bernardino J. NewSQL Databases Assessment: CockroachDB, MariaDB Xpand, and VoltDB. Future Internet. 2022. Vol. 15, no. 1. P. 10. URL: https://doi.org/10.3390/fi15010010 (date of access: 12.04.2024).
Fedorchuk Y., Andriukhanov I. The method of redistribution of data in a cluster environment. Youth, education and science through today’s challenges : XII Interna-tional Science Conference, Bordeaux France, 4 Dec. 2023. P. 450–453. URL: https://eu-conf.com/wp-content/uploads/2023/11/YOUTH-EDUCATION-AND-SCIENCE-THROUGH-TODAYS-CHALLENGES.pdf
Downloads
Published
Issue
Section
License
Copyright (c) 2024 System technologies
This work is licensed under a Creative Commons Attribution 4.0 International License.
