RESEARCH ON THE ARCHITECTURE OF DISTRIBUTED DATABASES IN PROCUREMENT MANAGEMENT SYSTEMS OF B2B COMPANIES

Abstract

This paper explores possible architectures of distributed databases as an innovative solution for procurement management systems in B2B (business-to-business) companies and provides a rationale for selecting a databases management system (DBMS). During the period of military aggression, Ukrainian companies face the need to transform their business models, with the active implementation of various managerial decisions. This, in turn, necessitates the improvement of corresponding information systems through the integration of local databases. Several distributed database architectures are proposed: client-server architecture with independent servers, client-server architecture with cooperating servers, and a hybrid architecture that includes cloud storage, local servers, and their integration, along with the use of CRM/ERP (Customer Relationship Management / Enterprise Resource Planning) systems and neural networks. An analysis of the most widely used database management systems is conducted, including PostgreSQL, Oracle Database, MySQL, Microsoft SQL Server, MongoDB, MariaDB, IBM DB2, and SAP HANA, in the context of their application in automated procurement management systems. Many modern database management systems demonstrate high adaptability to business processes of varying complexity. The presented results can serve as a methodological basis for the development of procurement information systems and for the adaptation of distributed technologies in the processes of corporate digital transformation.The scientific novelty lies in the substantiation of the feasibility of using a mixed (hybrid) client-server architecture for distributed databases in procurement management systems for B2B companies.