DATABASES FOR THE PROPERTY ACCOUNTING SYSTEM IN THE ARMED FORCES OF UKRAINE

Abstract

The article is devoted to the development and optimization of a database for an automated system of military property accounting in the Armed Forces of Ukraine. The relevance of the research is determined by the need to increase the efficiency of managing material and technical resources under wartime conditions, when data accuracy, operational speed, and information security are of strategic importance. A relational model consisting of six main entities (Category, Property, Storage, Movement, Inventory, Responsible_Personnel) was developed to ensure data integrity and consistency. Examples of SQL queries are provided to demonstrate data selection, aggregation, analytical operations, and accountability control. Particular attention is paid to the impact of indexing on query execution speed in the PostgreSQL DBMS. An experimental study was conducted to measure the average execution time of queries before and after the creation of indexes. It was found that the use of B-tree and composite indexes accelerates the execution of WHERE, JOIN, and ORDER BY queries by 11–16 times. The influence of data volume, denormalization, and statistics updates on system performance was analyzed. Recommendations are proposed regarding table structuring, transactional integrity maintenance, backup strategies, and the application of optimized indexes in distributed architectures. The obtained results have practical significance for developing reliable military information systems capable of fast data processing, transparent resource tracking, and robust information protection under cyberthreat conditions.