RESEARCH OF INTERACTIVE DATA MANAGEMENT TECHNOLOGIES ON THE EXAMPLE OF CUSTOMS DATABASES

Abstract

The application of interactive information systems in the field of analysis of foreign trade
information allows obtaining an objective view of the development trends of certain branches of the national
economy, including ferrous metallurgy. For this, customs databases are used, which contain detailed information
about the movement of goods across the state border, the commodity and geographical structure of exports,
customs value, etc. Analysis of such data makes it possible to quickly compare indicators by different countries,
products, time periods and other parameters.
Interactive data management and analysis systems (as part of business intelligence, BI) play a key role in
working with large arrays of information. A significant advantage of BI platforms is the interactivity of
visualizations, which acts not only as an auxiliary tool for presenting the results of analysis, but also as a full-
fledged analytical method of the investigation of complex economic processes, increases the transparency of
analysis and promotes informed decision-making in the field of foreign economic activity.
The following general approaches to program development were used: Visual Studio Code development
environment; Python programming language (backend); PostgreSQL DBMS (work with customs databases);
React library (frontend); Plotly library (interactive diagrams and graphs); Uvicorn (backend launch).
The use of VS Code made it possible to use its intelligent code editing capabilities, namely: advanced
syntax highlighting and automatic code addition, analyzes the structure of the program and provides context-
sensitive hints for variables, functions and classes, which significantly reduces the probability of syntactic and
logical errors.
Using Python makes it easy to develop and debug an application without a lengthy compilation process.
FastAPI supports asynchronous programming, which allows you efficiently process a large number of
simultaneous requests without blocking resources. The combination of React and FastAPI allows you to create
modern web applications with a clear division into frontend and backend, where React is responsible for the user
interface, and FastAPI processes logic, data and APIs. The Plotly library is used to create interactive graphs and
data visualizations that are available for Python. The corresponding listings of fragments of the program that was
developed are given.