DEVELOPMENT OF THE SECURE CONSOLIDATED INFORMATION RESOURCE FOR ANALYSIS OF THE ACTIVITIES OF SEA PORTS OF UKRAINE

Abstract

The dominant problem in the formation of effective principles for managing various technical, business, social, political structures in Ukraine is the creation of a safe and effective mechanism for recording, processing, accumulating information, as well as its criteria-based search capabilities. In the modern world with a large number of diverse business entities and their databases in any field of human activity, the problem arises of combining them and creating a single information space. In particular, in the infrastructure of seaports, there is a disorder in the powerful information database necessary for the management of such facilities. At the same time, a deep understanding of the principles and mechanisms of shipping management allows us to achieve a significant increase in its income, and therefore requires the creation of an appropriate approach to the development of an analytical mechanism for processing information in this area, taking into account a wide range of factors of influence and the possibility of creating reports on different search criteria. Thus, the authors propose to solve such problems to develop an appropriate secure consolidated information resource, which will allow a qualitative analysis of the activities of marine infrastructure in Ukraine. The purpose of the article is to optimize the processes of processing information flows in the work of the seaports of Ukraine by developing and implementing an appropriate consolidated information resource, which allows you to get productive and secure: registration, storage and creation of reporting information. The main objectives of the article are: analysis of the problems of high-quality information support for the functioning of the management system of seaports of Ukraine; creation of a database

management system; adhere to information protection standards; implementation of a secure consolidated information resource for the analysis of the activity of seaports of Ukraine. Methods used in the article: for designing a database, the article uses the “entity-relationship” method; relational relations method was used to create a database of ER-model of a consolidated information resource; the normalization method is used to convert database relationships to sequential normal forms, that is, to optimize relationships in the created database; for the creation of database tables, the PostgreSQL database management system is used, which makes designing UML class diagrams and relations. The results of the article are: the consolidated information resource for analyzing the activities of the seaports of Ukraine is designed to be protected, its use allows optimizing the operation of seaports, making management decisions faster and better, and accordingly increasing the profitability of such an industry.