Intellectual Analysis of Spatial Data for Information Support in Management of Technical Component of Complex Distributed Information Systems Elena Brekotkina brekotkina@mail.ru 0 Ramil Gilyazov 0 Sergey Pavlov 0 Vladislav Trubin 0 Ufa State Aviation Technical University , K. Marx Street, 12, Ufa, 450008 , Russia

Management of complex distributed systems, at present, is carried out using information systems designed to collect and manage a large amount of heterogeneous information of an organization or institution. The technical component of such information systems is itself a complex distributed system, and information about the location and mutual arrangement of its individual components, as well as the location of the associated infrastructure and main users, is essential for its high-quality functioning. A method of spatial data mining that suggested in this paper, proposed for formalizing the process of creating specialized databases for the implementation (creation) of individual subsystems as part of complex distributed information systems. The results of the application of this method for the construction of one of the subsystems, namely, the subsystem of information support for the management of the technical component of the information system, as part of a complex distributed information system, are presented on the example of the geoinformation system of the Ufa State Aviation Technical University. The proposed approach to intelligent analysis and representation of spatial data, consisting in a formalized description of various thematic data applied to solving specific problems of information management support in complex distributed systems, can be applied to the construction of complex information systems in significantly distributed organizational and infrastructure. Spatial data, complex distributed systems, data mining, information management support, GraphiCon 2021: 31st International Conference on Computer Graphics and Vision, September 27-30, 2021, Nizhny Novgorod, Russia ORCID: 0000-0002-2281-8351 (E. Brekotkina); 0000-0003-4918-013X (R. Gilyazov); 0000−0001−9672−7623 (S. Pavlov); 0000-00028787-9833 (V. Trubin); 0000−0002−3987−6582(O. Khristodulo)

 Distributed -

technical component of information systems

 1. Introduction Modern approaches to organizing the management of complex distributed systems (CDS), which

are characterized by a significant removal of their subsystems and objects, are based on the use of information systems (IS) designed for the collection, management and intellectual analysis of large amounts of heterogeneous information about the state and functioning of the CDS and its environment.

 On the one hand, the IS is an integral component (subsystem) of CDS, on the other hand, it represents CPC itself, as its main components are distributed in separate subsystems of CDS, and needs to analyze

the state, support the performance and management. One of the most important subsystems of such IS is its technical component, which includes a variety of computing resources (servers, stationary computers, mobile devices), input-output devices (printers, monitors, scanners, multifunction devices), united in a computer network by special means (communication lines, routers, switches, etc.).

 Obviously, the technical component of the IS is also the CDS and to ensure its quality creation and operation, the information about the location and mutual location of its individual components, as well

2021 Copyright for this paper by its authors. as the location of the associated infrastructure (floor plans, power supply network, etc.) and the main users (consumers) of its functioning is essential, which leads to the need for automated processing of these types of information, which is called spatial, using geoinformation systems.

 This paper considers some approaches to the analysis, structuring and organization of heterogeneous

(spatial and attributive) data for information management support of the technical component of complex distributed information systems on the example of the Ufa State Aviation Technical University (USATU), which includes many remote from each other (up to 300 km) departments, each of which operates the appropriate IS components, including their technical component.

 2. Intellectual analysis of spatial data for information support

For effective use of spatial information in the management of the university, GIS USATU is created [1], whose structure is shown in Fig. 1, where as one of the subsystems, the subsystem of information management support of the technical component (IMSTC) is selected. The central (most important) part of the system is the database, which includes the main types of planning and cartographic information: maps of territories, floor plans of all buildings, plans of individual rooms and structures, which include the main information layers of engineering communications, as well as their attributive data. ( 1 ) ( 2 ) where n is the number of maps and plans needed to manage the university. The order in which the cartographic data are arranged in the DBPC set is not essential, so for certainty let's arrange them in order of increasing degree of detail of spatial objects:  K1 – map of the Republic of Bashkortostan with USATU objects on it;  K2 – map of the city of Ufa;  K3 – map of Kumertau;  K4 – map of Ishimbay;  Maps K2, K3, K4 show the location of USATU facilities; where DBPC is a database (or set) of planning and cartographic data, which includes geographical maps of the territories where the facilities and units of USATU are located, as well as schemes of individual buildings and structures [3, 4]. Hereinafter, for the sake of brevity, maps and plans will be referred to the same way, i.e.

= { }, = ̅1̅̅,̅̅,

K5 – master plan of the university buildings (complex placement of educational buildings of

the university);

 K6 – master plan of the campus (complex accommodation of university dormitories). Under some numbers in this set are floor plans of all buildings and plans of individual rooms: .... .... K1 1 – plan of the first floor of the first campus building; K1 2 – plan of the second floor of the first campus building; K6 1 – plan of the first floor of the sixth campus building; K6 2 – plan of the second floor of the sixth campus building; K6 101 – plan of classroom 101 of the sixth campus building; K6 102 – plan of classroom 102 of the sixth campus building, and so on.

for all = ̅1̅̅,̅̅, here – the number of thematic layers of the i-th map.

To solve each specific task of university management, a certain set of maps and their layers is used, and part of the maps and layers is used to solve several (more than one, but not necessarily all) tasks, and the other part is used to solve only one task [2]. In works [1, 2] authors of this article considered in detail the problem of organization of storage of such data on the basis of formal analysis of their belonging to different objects and subsystems of CDS. In these studies, the main emphasis is placed on ensuring the consistency of all data stored in a distributed database, necessary for the management of specific CDS, by storing only one instance of data with preservation of all semantic relations. In this paper we consider the problem of maintaining the integrity and consistency of these data when they are used repeatedly by a large number of users (people or tasks) independent of each other.

For the first time, the proposed approach was used by the authors to solve the problem of information security management (ISM) of CDS [2]. As follows from ( 3 ) by the time of creating a new subsystem in the general management system of some CDS (in this article as an example, but without violating the generality of reasoning, it is USATU), each such map of ( 2 ) consists of thematic layers needed to solve current management problems[5]. For each specific task is used, as a rule, not all, but only part of the available layers included in the set ( 3 ) under specific numbers, for example, to solve the problem of public safety management on the territory of the university (its main part in the city of Ufa) the ≤ , 35 = { 1, 2, 3}, ( 3 ) (4) (5) (6) (7) following layers are used: 2 3 5 – layout of video cameras.

Let's introduce the set: 5 – scheme of electrical communications; 51 – the layout of buildings and structures of the campus; = { 1, 2, . . . , }, where – the number of layers of the i-th map required to solve the p-th management task, = ̅1̅,̅̅̅,

 Q – the total number of tasks (subsystems) included in the system (in our case – GIS USATU). Note

that that is, the number of layers of each map used to solve the p-th problem is less than the number of all map layers. For the layers used in (4) the set will have the form: indexes j1, j2 and j3 have certain numerical values in each case, but this is not essential for formalizing the process of data analysis.

 To solve a newly arisen (or newly set and ready for implementation) management problem (e.g.,

= ̅1̅̅,̅̅. It should be noted that for each new task it is possible that

IMSTC) all necessary maps are supplemented with new thematic layers [6] in the number 1, for each

1 = 0, (8) for some values of i, which means that there are no additional thematic layers for this problem in this map.

In order to develop and implement the IMSTC subsystem, it is necessary to add thematic layers containing spatial information about the university computing infrastructure objects to the base of planmap data. These additions refer to those maps from ( 2 ), which can display the corresponding spatial objects, so in Fig. 2 is a plan of equipment placement on one of the floors of the campus building, and in Fig. 3 is a layer-by-layer image of these objects in one of the rooms.

60315 = { 1, + 1, + 2, . . . , + 0}. (9) map       6 3+135 – furniture layout plan;

6 3+145 – layout plan for point objects of the power supply network;

6 3+155 – layout plan for linear objects of the power supply network. 6 3+125 – layout plan for linear objects of a computer network (communication lines); 6 3+115 – layout plan for point objects of a computer network (routers, switches, computers);

 And the set , fixing the layers of this map to create a subsystem of IMSTC, which has some

number = 0 in the general list of GIS USATU tasks, will have the form 1 6 315 – room boundaries; = 6 315 under the number 1[7]: number 0 = 61 315 = 5 and using one existing layer, which is included in the set of all layers of this infrastructure, which were created on the basis of layouts of equipment and passports of educational laboratories, supplemented by the results of the inspection of premises, and for each of these maps is formed set of used map layers, similar to (9), and the entire set of numbers (list) layers of all maps from ( 2 ) for this subsystem will be determined by the ratio 0 = ⋃ 0.

=1

= { },

All spatial objects are described both by their location reflected in the corresponding maps from ( 2 ) and by some attributive characteristics stored in the ADB from ( 1 ). At the same time, attributive information about objects of each thematic layer of each map is stored in one (without taking into account normalization) relation [8, 9], so that each layer of each map corresponds to exactly one relation. By analogy with the notation of layers, let us denote each relation by , then the whole attributive database is a set of such relations: where still = ̅1̅̅,̅̅, and = ̅1̅̅,̅̅̅̅.

Further, by analogy with the formation and use of the used cartographic information on the basis of the already constructed sets , a set of used or newly added relations is formed:   computers); 61315 – attributive information about the room; 6 3+115 – attributive information for point objects of a computer network (routers, switches, (10) (11) lines); 6 3+125 – attributive information for linear objects of a computer network (communication 6 3+135 – attributive information about a furniture; 6 3+145 – attributive information for point objects of the power supply network; 6 3+155 – attributive information for linear objects of the power supply network.

The relationship of relations with the attributive information about the objects of computing infrastructure is presented in Fig. 4 in the form of an information model, and Fig. 5 shows the data of one of the elements of this model. Thus, to solve the problem of intelligent analysis of spatial information and the formation of specialized databases (SDB) based on the results of this analysis to solve individual management tasks (subsystems) of CDS, for example, for the task of information support for the management of technical component of such systems, an algorithm for the formation of each of these tasks in set , which can serve as a mapping function of the entire database system in

 This approach is used in the design, creation and use of the spatial database in the GIS USATU,

registered in the Russian Fund of programs and databases [10], including a common database for the entire system and specialized databases for some tasks (subsystems).

The use of spatial, including - attributive data on the objects of computing infrastructure to solve some problems of university management (initially in information and reference mode) is based on a specialized interface developed in the GIS software environment "InGeo". [11]. this SDB is proposed. for each = ̅1̅,̅̅̅.

 3. Conclusion

The proposed approach to intelligent analysis and representation of spatial data, consisting in a formalized description of various thematic data applied to solving specific problems of information management support in complex distributed systems, can be applied to the construction of complex information (especially – geoinformation) systems in significantly distributed organizational (institutions, enterprises, authorities, etc.) and infrastructure (pipelines, electricity, heat and gas supply networks, transport, etc.). Application of this approach to the construction of a distributed subsystem (information support for technical component management) of a complex distributed information system GIS USATU, which significantly reduced the time of creation and the number of errors in the design of the entire presented system.

 4. Acknowledgements 5. References The reported study was funded by RFBR, project number 20-08-00301.

[4] K.N. Markov, Structures, functionality, and characteristics of implementation of distributed geoinformation processing in the MGS-framework development environment, Geoinformatics 1 (2010) 22-29. [5] I.S. Rizaev, Geoinformation systems, Kazan National Research Technical University, Kazan,

Russia, 2013. [6] S.L. Beliacov, M.L. Beliacova, I.N. Rozenberg, Integrity constraint in visualizing spatial database,

 IzvestiyaSFedU. Engineering Sciences 5 (2013) 138-143.

[7] E.S. Antonov, D.V. Lisitsky, S.S. Yankelevich. Theoretical and methodological representation of the direct transition from geoinformation to geoscience, Bulletin of SGUGIT 26 (2021) 82–90.

DOI: 10.33764/2411-1759-2021-26-2-82-90 [8] M.A. Ahmad, I. Tvoroshenko, J.H. Baker, L. Kochura, V. Lyashenko, Interactive Geoinformation Three-Dimensional Model of a Landscape Park Using Geoinformatics Tools, International Journal on Advanced Science Engineering and Information Technology 10 (2020). DOI: 10.18517/ijaseit.10.5.11298 [9] Yu.B. Gritsenko, O.I. Zhukovskiy, Typical architectural decisions of information-analytical systems of support of the state and municipal management, Quality. Innovation. Education 1 (2012) 73–82. [10] Certificate of state registration of the database No. 2020621703. Database of the geoinformation system of the Ufa State Aviation Technical University (Ingeo). Application No. 2020621557: receipt. 09/07/2020: registration. 09/18/2020 / L.V. Akhmadieva, R.A. Gilyazov, V.D. Trubin, K.D. Shinova, 2020. [11] GIS "Ingeo". Center for System Research "Integro", 2021. URL: http://www.integro.ru/projects/gis/main_gis.htm

 [1] E.S. Brekotkina , A.S. Pavlov , S.V. Pavlov , O.I. Khristodulo , V.D. Trubin , Analysis and synthesis of spatial data structures for managing complex distributed systems , in: Proceedings of the 8th AllRussian Scientific Conference with International Participation "Information Technologies and Systems" , Khanty-Mansiysk, Russia, 2020 , pp. 120 - 124 . [2] E.S. Brekotkina , M.B. Guzairov , A.S. Pavlov , S.V. Pavlov , O.I. Khristodulo , Information support for managing the vulnerability of complex distributed systems based on the processing of spatial information , Modeling, optimization and information technology 8 ( 2020 ). DOI: 10 .26102/ 2310 - 6018 / 2020 .29.2. 023 [3] R.A. Bagutdinov , M.F. Stepanov , Methods of integration, reduction of sizes and normalization of processing of heterogeneous and multi-scale data , International Journal of Open Information Technologies 9 ( 2021 ) 39 - 44 .