=Paper=
{{Paper
|id=Vol-2843/shortpaper40
|storemode=property
|title=Formation of an integrated model for providing information support for organizational decisions (short paper)
|pdfUrl=https://ceur-ws.org/Vol-2843/shortpaper040.pdf
|volume=Vol-2843
|authors=Olga Matyunina,Natalia Zavalko,Veronika Kozhina,Alexander Rezin
}}
==Formation of an integrated model for providing information support for organizational decisions (short paper)==
https://ceur-ws.org/Vol-2843/shortpaper040.pdf
Formation of an integrated model for providing
information support for organizational decisions*
Olga Matyunina1, Natalia Zavalko2, Veronika Kozhina3 and Alexander Rezin4
1
Autonomous non-commercial organization of higher education “Russian New University”,
22, Radio st., Moscow, Russia
2
Financial University under the Government of the Russian Federation, 49, Leningradskiy
prospect, Moscow, Russia
3
ANOHE “Moscow international university”, 17, Leningradskiy prospect, Moscow, Russia
4
Omsk State Pedagogical University, 14, Tukhachevsky Embankment, Omsk, Russia
olgam333@mail.ru
Abstract. The article describes modern information systems that automate the
process of collecting, accumulating, processing and transmitting information
flows. In the work, various information platforms were studied, which allowed
the authors of the study to form an integrated model for providing information
support for organizational decisions at different stages of the functioning of in-
dustrial enterprises.
Keywords: Information technology, Monitoring of government support meas-
ures, Government information systems, Client-server model.
1 Introduction
The use of information technology to support organizational decisions is a prerequi-
site for the effective functioning of industries. The development of a system of state
support requires timely monitoring of the state of affairs in industries that use state
support measures [1].
For a more efficient operation of the monitoring system for various measures of
state support provided by the state to enterprises, decision-making models based on
the GIS system can be distinguished. On the basis of GIS, platforms are being created
that can solve a fairly wide range of problems. These platforms help users to research,
compose, and produce accurate calculations for effective organizational decisions [4].
These technologies provide the ability to display analysis results on maps or satellite
images. Such GIS applications to support and evaluate decisions made have been used
in many areas of research, such as marketing, strategic planning [2].
*
Copyright © 2021 for this paper by its authors. Use permitted under Creative Commons License Attribu-
tion 4.0 International (CC BY 4.0).
2 Materials and methods
To solve complex decision-making situations, intelligent systems such as expert sys-
tems or knowledge-based systems have been integrated into GIS. This integration has
led to the creation of environments commonly known as "smart GIS".
Internet technologies have been assimilated into GIS, leading to the emergence of
various GIS web applications. Several researchers have demonstrated the use of the
Internet and GIS to develop applications to improve decision making. Despite some
progress in using the Internet as a medium for the exchange of economic data and
data visualization. Currently, there is an increased interest in continuing the develop-
ment of the WEB to support more effective decision-making and formulating the
vector of policy development [3].
3 Results and Discussion
The client-server model used in the development of Internet GIS (or WEB GIS) ap-
plications allows users to access GIS databases through an open connection to the
databases. However, a client can only access one source at a time with predefined
connection platforms. It is even possible that, if necessary, the client may have a dy-
namic ability to access various sources. As network computing gains momentum and
the network provides the infrastructure necessary to materialize peer-to-peer comput-
ing, we believe there will be a lot of demand for a mobile version of GIS, which will
enable small and medium-sized enterprises and innovative enterprises to participate
effectively in the monitoring system. Mobile GIS is created by separating the client
and server sides of an application into self-contained units that can interact between
networks, integrating languages, applications, tools, and operating systems. Advances
in wireless technology have led to the development of mobile support systems that
provide access to spatial data as well as decision support applications using handheld
devices from remote locations [5].
The whole program consists of 7 files linked to each other:
─ Form1.cs [constructor] - sets the appearance of the main screen Map;
─ Settings.cs [constructor] - sets the appearance of the Settings screen;
─ Form2.cs [constructor] - sets the appearance of the Legends screen;
─ Program.cs - the file from which the program starts and which opens the Map
screen (where the most popular support measures by territory and industry will be
displayed);
─ Form1.cs - file with functions executed from the Map screen;
─ Settings.cs - a file with functions executed from the Settings screen;
─ Form2.cs - file with functions executed from the Legend screen.
Program.cs file
The file from which the execution of the program starts opens the "Map" window,
global variables are created in it, which are presented in any part of the code:
─ year is an integer variable containing the selected year;
─ nomberList1 is an integer variable containing the page number in the Excel work-
book of the selected database (which reflects existing support measures);
─ nomberList2 is an integer variable containing the number of the additional page in
the Excel workbook of the selected database, necessary if the indicator is obtained
by the ratio of two parameters, for example, the indicator “R&D cost subsidization
(ratio provided / not provided);
─ pokazatel - an integer variable containing the number of the selected indicator (for
example, number 1 - exemption from VAT when performing scientific research);
─ pokazatelString is a string variable containing the name of the selected indicator,
which is required to be sent to the label on the main Map screen;
─ mean, mean1, mean2, mean3, mean4, mean5 - row variables containing the aver-
age value of the selected indicator for the country and for each group of support
measures, respectively. Needed to send these values to the Legend window;
─ variation1, variation2, variation3, variation4, variation5 are line variables contain-
ing the variation value for each group of support measures, respectively. Needed to
send these values to the Legend window;
─ min1, min2, min3, min4, max2, max3, max4, max5 - string variables containing the
minimum and maximum values of the indicator for each group of support meas-
ures, respectively. Needed to send these values to the Legend window;
─ leder, loser - string variables containing the name of the best and worst region for
the selected indicator. Needed to send these values to the Legend window.
Also in this file, the Group class was created, which contains the name of the re-
gion, its number in the ordered list, the value of the indicator and the polygon that will
be displayed on the map [6].
Form1.cs file
First, global variables are created, which are visible in all functions of this file:
─ 85 variables of the Group type for each subject of the Russian Federation (this type
is described in the Program.cs file), which already contain the name of the subject;
─ 85 variables of the StreamReader type with the specified directions to the files with
the coordinates of each subject;
─ Canvas overlay to which all branches of the regions are added;
─ Array of coordinate files MassFileOfCoordinate;
─ Array MassGroup and MassGroupOld of Group variables containing the data of
the selected indicator and the previous selection, respectively;
─ Variable "bulling" of the firstStart type, which takes the value true at the first start
of the program and the value false at the next start;
─ Three variables of type Image containing images for buttons of years.
The file includes the functions:
─ CoordinatOfRegion - a function that accepts one variable of the StreamReader type
containing the coordinates of a constituent entity of the Russian Federation and re-
turns a list of coordinates of enterprises using support measures in a specific con-
stituent entity of the Russian Federation;
─ MassOfData1 - a function that takes a variable containing the sheet number of the
Excel workbook. It reads data from the SDDataYear database and creates a dataset
for a specific measure of support per year;
─ MassOfData2 - a function that accepts variables containing the numbers of two
sheets of the Excel workbook with the data of the indicators, the ratio of which we
need. It reads data from the SDDataYear database and creates an array of data;
─ MassOfData3 - A function that reads data from the Sustainability Year database
and creates a dataset;
─ ColorPoligon1 - a function that takes a variable of the Group type and, by number
in the ordered list, assigns a specific color to the extent that this variable is sup-
ported;
─ ColorPoligonInversion is a function that works like ColorPoligon1, but is used if a
higher value corresponds to a better rating group. For example, the more busi-
nesses used the support measure, the better;
─ ColorPoligon2 - a function that works like ColorPoligon1, but is used when the
indicator "Demand for measures of state support in the region" is selected;
─ CleanFlags - a function that removes flags from the rating group display switches;
─ VisibleFlag - a function that takes a variable of the selected indicator. Responsible
for displaying specific radio buttons for selecting a rating group, depending on the
indicator;
─ ShowPoligons1 - the function responsible for displaying regions on the map. The
first thing it does is call the CleanFlags and VisibleFlag functions. Then, depending
on the indicator, the function for creating an array of data (MassOfData1, Mas-
sOfData2 or MassOfData3) is called, after which the data is sorted and each meas-
ure of government support is assigned a number in an ordered list, depending on
which the function ColorPoligon1, ColorPoligonInversion or ColorPoligon2 as-
signs the desired color to the measure. At the end, state support measures are added
to the canvas and the canvas is displayed on the map [7];
─ ShowPoligons2 - the function of displaying regions with a selected group of meas-
ures for indicators from "Measures to support promising enterprises";
─ ShowPoligons3 - function of displaying support measures for the selected rating
group for the indicator "Demand for support measures for the industry";
─ RegionJump - a function for checking changes in the group of demand for support
measures by region.
The following features are enabled when interacting directly with form elements:
─ Form1 - starts when the Map window is opened. Here, the setting of the map pa-
rameters and its display are initialized, the already created variables of the Stream-
Reader type with the files of the coordinates of enterprises by industry of the sub-
jects of the Russian Federation are added to the MassFileOfCoordinate and Mass-
Group arrays;
─ button1_Click…button14_Click, except for button11_Click and button12_Click -
are triggered when you click on the year selection buttons. Inside each function,
the variable year is assigned a specific year and the button color changes, after
which the ShowPoligons1 function is initialized, which displays the measure of
support;
─ button11_Click - starts when you click on the "Indicator" button and opens the
settings window;
─ button12_Click - starts when you click on the "Legend" button. Within this button,
statistical indicators are calculated and the result of calculations is stored in the
variables mean, mean1, mean2, mean3, mean4, mean5, variation1, variation2,
variation3, variation4, variation5, min1, min2, min3, min4, max2, max3, max4,
max5 , leder, loser and opens the Legend window;
─ checkBox1_CheckedChanged…checkBox5_CheckedChanged - run when the sup-
port measures group selection switch is changed and initialize the ShowPoligons2
function;
─ checkBox6_CheckedChanged…checkBox12_CheckedChanged - triggered when
the industry group selection switch changes and initializes the ShowPoligons3
function;
─ checkBox14_CheckedChanged and checkBox15_CheckedChanged - are triggered
when the switches for displaying subjects who have improved / worsened their po-
sition are changed. Inside, using the RegionJump function, the change in the group
of demanded support measures by industry for each subject is checked and the
necessary entities are displayed.
Settings.cs file
This file contains the following functions:
─ NomberOfList is a function that checks which indicator is selected and sends in-
formation to the variables nomberList1, nomberList2, pokazatel, pokazatelString;
─ MainMark1_CheckedChanged - triggered when the "Demand for support measures
for the industry" radio button is selected. It displays information about a given in-
dicator and sends information to the variables pokazatel, pokazatelString;
─ MainMark2_CheckedChanged - starts when the "Measures to support promising
enterprises" radio button is selected. Displays possible metrics;
─ button1_Click - starts when you click on the "Map" button. Initializes the Nom-
berOfList and ShowPoligons1 function, and then closes the Settings screen.
Form2.cs file
This file draws a table that is displayed in the Legend window and displays the
values of the variables mean, mean1, mean2, mean3, mean4, mean5, variation1,
variation2, variation3, variation4, variation5, min1, min2, min3, min4, max2, max3,
max4 , max5, leder, loser.
Database
For a full-fledged work, 2 main databases are required. They are implemented in
the form of Microsoft Excel tables, divided into sheets according to various indicators
[8].
The first SDDataYear database includes annual indicators for support measures
used by industry enterprises in a specific region, as a result of which the demand for
support methods used in various industries is assessed and monitored, allowing the
assessment and monitoring of support mechanisms by enterprise, industry and terri-
tory.
The second database is a list of enterprises and projects that have benefited from
support measures [9].
4 Conclusion
User-visible screen displaying statistics on required support measures. Depending on
the selected parameter, the screen may look in two ways [10]. On the one hand, such
an image allows enterprises to make decisions on new support measures and evaluate
the most effective ones, on the other hand, the control system over the use of certain
measures allows state bodies to assess the situation from different angles and make
decisions aimed at developing support measures that turned out to be the most in de-
mand and proved to be economically significant for the development of industries,
individual enterprises and projects.
References
1. Zavalko, N.A., Matyunina, O.E., Kozhina ,V.O., Sokolov, A.A., Lebedev, K.A.: The digi-
tal economy and its impact on state and municipal governance. Economics and Entrepre-
neurship, 11 (100), 101-104 (2018).
2. Matyunina, O.E.: Development of digital technologies in the context of globalization.
Economics and Entrepreneurship, 1 (114), 1210-1213 (2020).
3. Matyunina, O.E., Zavalko, N.A., Kozhina, V.O., Sokolov, A.A., Lebedeva, O.E.: Devel-
opment of financial infrastructure in the system of state regulation of the digital economy.
Economics and Entrepreneurship, 12 (101), 26-29 (2018).
4. Ragulina, Yu.V., Zavalko, N.A., Kozhina, V.O.: Management decisions in the system of
state and municipal government. Textbook: Moscow (2019).
5. Shedko, Yu.N., Zavalko, N.A.: Improvement of the infrastructure of support and informa-
tion support of the monitoring and control system of federal projects. Financial life, 3, 44-
46 (2020).
6. Blokhina, O.A., Beketova, O.N., Kuzmina, E.E., Lebedeva, O.Ye., Podzorova, M. I.: Im-
proving the technology of innovation systems management at an enterprise. International
Journal of Civil Engineering and Technology, 9, 13 137-143 (2018).
7. Demkina, N.I., Kostikov, P.A., Lebedev, K.A.: Formation of professional competence of
future specialists in the field of information environment. Espacios, 40, 23 (2019).
8. Zavalko, N.A., Krasyukova, N.L., Plotitsyna, L.A., Gladyshev, A.G., Boyko, A.N.: Neural
network system for processing large-volume diagnostic data. International Journal of Ad-
vanced Trends in Computer Science and Engineering, 9, 3, 3211-3215 (2020).
9. Zavalko, N.A., Kozhina, V.O., Zhakevich, A.G., Matyunina, O.E., Lebedeva, O.Ye.: Me-
thodical approaches to rating the quality of financial control at the enterprise. Quality Ac-
cess to Success, 18, 161, 69-72 (2017).
10. Yudina, E.V., Zavalko, N.A., Beketova, O.N., Kozhina, V.O., Lavrenova, A.V.: Innova-
tive approaches to business modeling at an enterprise. Revista Inclusiones, 7, S1-1, 84-92
(2020).