The service model of a heterogeneous distributed database for software system scaling


  • Andriukhanov I.
  • Korotyeyeva T.



distributed DBMS, database cluster, OLTP, ACID, JSON, geospatial data, horizontal scaling, database performance.


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.


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: (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: (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: (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: (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: (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: