DEVELOPMENT OF A CONCEPTUAL MODEL OF OPERATIONAL – ANALYTICAL DATA MARTS
A.P. Raevich, B.S. Dobronets
The storages integrated with analytical systems are focused on dimensional data modeling, which provides quick execution of analytical queries, but has significant drawbacks when working with big data. The article proposes an approach to constructing a conceptual model of operational-analytical data marts, which allows combining the concepts of operational data marts and analytical data marts. Operational data marts are information slices of narrowly focused, thematic information, which designed to solve the problem of operational access to big data sources through the consolidation and ranking of information resources in terms of demand. In contrast to operational data marts that are dependent from sources, analytical data marts are considered as independent data sources created by users in order to provide data structuring for the tasks being solved. The paper provides a comparison of approaches to the construction of analytical queries based on linear queries and associative relationships. The results obtained in this work are used in building a BI cluster on the basis of fast design, analytics, development and implementation of business process models which are performed with using prepared operational-analytical data marts.
Keywords: business intelligence systems, operational-analytical data marts, associative data model.
APPLICATION OF THE MODEL TECHNOLOGIES OF THE SYSTEM ANALYSIS IN MANAGEMENT OF PERSONNEL FOR F-EM TERRITORIAL BODIES OF THE MIA OF RUSSIA
The article deals with the issues of improving the management of personnel provision of ATS. The author conducted the analysis of the dynamics of the basic parameters of the operating environment after the reform of the Warsaw Pact and came to the conclusion that along with the positive changes of mi in activities of OVD has a number of problematic issues that require special attention. A significant part of them lies in the field of personnel policy and personnel work. First of all, we are talking about a significant shortage of employees in the territorial units of the criminal investigation, inquiry, investigation, police stations. At the same time, the situation is aggravated by a decrease in the motivation of employees of these units to work in good faith and a high level of rotation, which steadily leads to a decrease in the efficiency of their activities. In order to find the main contradictions and ways to resolve them in this area, the author uses a typical technology of system analysis on the basis of procedures – MEASUREMENT, EVALUATION, decision-MAKING and component – INPUT, PROCESS, OUTPUT. As a direct object of the system analysis the model of personnel management of ATS is used. The system analysis of this model has allowed to reveal two actual problems of the CAD-work demanding the decision: improvement of methods of calculating staffing needs of the territory-promotion of ATS units with the purpose of optimizing the load on employees; improving the methodology for calculating the evaluation of the activities of ATS units on the basis of refusal to assess the results of work and the transition to the calculation of efficiency of human resources. As a tool for solving these problems, the author proposes to apply the method of system dynamics, represented by a mathematical expression reflecting the dynamic balance of the main elements of the operational environment-crime – personnel – efficiency
Keywords: system of staffing, the operational environment, the method of system dynamics, the dynamic equilibrium of the elements of the system “crime-resources-efficiency”, “bandwidth”, statistics show-tel.
MODEL OF THE PROCESS OF MANAGING A GENETIC ALGORITHM USING AN ARTIFICIAL NEURAL NETWORK BECAUSE OF STRUCTURAL-PARAMETRIC SYNTHESIS OF LARGE DISCRETE SYSTEMS
D.A. Petrosov, Al Saedi Mohanad Ridha Ghanim, S.Y. Beletskaya
In intelligent decision support systems aimed at solving the problems of structurally parametric synthesis of models of large discrete systems with a given behavior, based on genetic algorithms, it is often required to increase speed using not only hardware, but also mathematical ones. In this paper, we consider the processes that arise when using an evolutionary procedure consisting of four genetic algorithms adapted to the task of synthesizing under the control of an artificial neural network. Each model that is part of the decision-making block fulfills its function in the task of structural-parametric synthesis of simulation models of large discrete systems. That is, it searches for solutions based on: models of elements that make up the synthesized object; interelement connections; initial parameters of the functioning of the elements; parameters of the elements of the synthesized system, which can change in the synthesized model during its operation. As a control, the use of an artificial neural network is considered, which makes adjustments to the functioning parameters of the operators of the genetic algorithm and (or) the connection of various combinations of evolutionary procedures depending on the convergence of the evolutionary procedure. When creating a process model, modern methodologies IDEF0 and IDEF3 were used, aimed at solving problems of system analysis.
Keywords: evolutionary procedures, structural-parametric synthesis, genetic algorithms, artificial neural networks, system analysis, simulation.
DEVELOPMENT AND RESEARCH OF AUTOMATED INFORMATION SYSTEM OF THE ENTERPRISE WITH THE APPLICATION OF MEANS OF MODELING
K.R. Guseva, V.N. Knyazev
The article deals with topical issues of development of automated information systems (AIS) of enterprises on the example of a furniture company with the use of modern information technologies and appropriate modeling tools. Taking into account the obvious prospects of large-scale use of mobile devices in the information society, within the framework of the developed AIS, the design and software implementation of a mobile application for the convenience of customers of the furniture company was carried out. The developed AIS furniture company and mobile app allow you to increase the efficiency and comfort of the processing of customer requests for company personnel involved in this process and for the customers, placing orders and supervising their implementation with the help of mobile apps. Appropriate ontological, functional and visual modeling tools were used in the process of AIS and mobile application design. Taking into account actual and perspective tendencies of improvement of the automated information systems of management in modern management assuming active use of computer simulation modeling for research and improvement of parameters of functioning of the realized AIS development and research of simulation discrete-event GPSS-model is carried out. An important feature of the proposed model is that it, unlike similar models, is complex and allows to consider not only the managerial processes for the processing of applications and other business processes, such as Assembly, loading and delivery of furniture to customers and has funds research sojourn time of requests in the system taking into account the specific type of furniture and no such accounting controls placement of furniture in the back of the car taking into account the size of furniture, means of calculation of financial-economic parameters of the enterprise with the aim of maximising profits and other means of research. Based on the results of the study, practical recommendations are given to optimize the management and production processes of a furniture company in Penza.
Keywords: information technologies, automated information system, mobile application, modeling.
APPLICATION OF WEB SERVICES BASED ON SITUATION-ORIENTED DATABASE FOR MONITORING THE VIEWING OF THE EDUCATIONAL VIDEO-CONTENT
V.V. Mironov, A.S. Gusarenko, N.I. Yusupova
This article discusses the task of monitoring student views of educational videos hosted on YouTube video hosting. A solution to this problem is proposed based on the control and analysis of comments posted by students during viewing. The organization of this process is discussed, as well as the functionality of the video viewing monitoring subsystem, which provides for the collection and analysis of student comments, as part of the university educational system. The structure of a relational database for the accumulation of information about video views is considered. Examples of analytical reports on watching videos aimed at students and teachers are given. To fill the relational data warehouse (ETL process), as well as to generate analytical reports on video viewing, a situation-oriented database (SODB) is used. The SODB capabilities for organizing micro-services using the example of heterogeneous data management, which are extracted from the YouTube API and the database of the educational system storage, are demonstrated and then placed in a relational database based on the concept of virtual documents displayed on heterogeneous data sources. This implementation is explained when mapping virtual documents to web services such as the YouTube API. A set of REST-services is developed that is developed on the base of SODB to solve the task of monitoring views. The universality and simplicity of the hierarchical situational model of the SODB is noted both when defining web services and when managing them. The practical implementation of the subsystem for monitoring the views of educational videos on the PHP platform is described.
Keywords: educational videos, monitoring views, YouTube API, ETL-process, analytical reports, integration heterogeneous data, situation-oriented databases, REST-services, microservices.
EVALUATION OF EFFICIENCY OF MANAGEMENT DECISIONS ON SEGMENTATION OF THE MARKET OF SALES OF PRODUCTS PRODUCED BY ENTERPRISES OF THE CRIMINAL EXECUTIVE SYSTEM
The article discusses current issues and problems of developing systems for evaluating the effectiveness of managerial decisions on market segmentation at the enterprise level; the classification of mutual influences of market segments is made in order to identify the groups that have the greatest impact on the efficiency of the production and economic activity of the enterprise. The study of these issues showed that it is from the decisions taken at the planning stage that the network can ensure a stable increase in the company’s production indicators. A comprehensive assessment of management decisions made in the field of segmentation of the sales market is an urgent task for every enterprise striving for prosperity. However, as analysis shows, this problem has not yet received a proper solution. In the process of considering the above problem, a mathematical model was described and an algorithm was developed that provides an assessment of the effectiveness of management decisions on market segmentation at the enterprise level. This approach allows you to quantify the effectiveness of management decisions on segmenting the sales market of products manufactured by commercial enterprises, according to the following criterion: a management decision on market segmentation will be effective if the current sales volumes of products in the selected market segments are not less than the specified values. The developed five-stage algorithm is aimed at widespread use by commercial enterprises in the conditions of market competition.
Keywords: efficiency, criterion, mutual influence, model, algorithm
CHARACTERIZATION OF GEOGRAPHICALLY RELATED ORGANIZATIONAL SYSTEMS AND APPROACH TO INTELLECTUALIZATION OF THEIR MANAGEMENT
V.V. Goriachko, E. M. Lvovich
The article introduces a description of one of the classes of complex systems – geographically related organizational systems, widespread in the social and economic spheres. The characterization of the systems under study is given through classification features according to their belonging to territorial and industry clusters, according to the method of spatiotemporal information generation for effectiveness evaluation. A variety of combinations of these features leads to the three main tasks of geographically related organizational systems management: management of resource, productive and resource-productive interaction of objects of the main and related systems.It is represented that the mechanisms of the generation of spatio-temporal information play a special role in the intellectualization of decision-making in the listed managerial tasks. Such mechanisms are monitoring and rating. The first mechanism allows obtaining estimates of indicators characterizing the functioning of the main system objects and the results of interaction with objects of related systems in a set period of time. The second mechanism is aimed at aggregating the monitored indicators into an integrated assessment, based on which the position number of the main system object in the rating list is determined. The main fields of intellectualization of management of organizational systems class under the study, which are determined by the optimization condition of potential efficiency and require the development of problem-oriented methods for analyzing GIS-oriented spatio-temporal information and algorithms of decision-making intellectual support are substantiated.
Keywords: organizational system, management, interaction, efficiency, intellectualization, spatio-temporal information.
MANAGERIAL DECISION MAKING TO IMPROVE RESOURCE EFFICIENCY OF A NON-PROFIT ORGANIZATION BASED ON EXPERT AND VERIFICATION EVALUATION
The article considers the models and procedures of intellectual support of managerial decision making based on optimization and expert assessment. The main attention is paid to the long-term planning of the resource efficiency increase of a non-profit organization. The development of these theories for specific managerial problems is proposed. Non-profit, non-governmental organizations, organizations of the third sector serve as synonyms for NGOs. The issues of development and functioning of non-profit organizations, their socio-economic potential, mechanisms to increase the efficiency of their activities, tools to ensure partnerships with the government, are studied by economists, sociologists, and management specialists in social and economic systems. The so-called theories of the third sector that currently exist are aimed at analyzing NGOs as a management system, and economic mechanisms that affect the functioning of social movements and organizations with the use of regression and neural network models based on monitoring and rating information. The allocation of additional costs for the implementation of measures to improve resource efficiency is proposed to be carried out using a multi-step process of optimal decision making. As a result, we have many alternative solutions. To select a rational option, an expert assessment procedure has been developed with the involvement of a group of experts and the building of an inverse rank sequence and matrix of individual weighting coefficients. The final managerial decision choice is made by the logical conditions sequentially checking and obtaining a group compromise assessment.
Keywords: resource efficiency, multivariance, management, multi-step optimization, group expert assessment, ranking.
STUDY OF ARTIFICIAL INTELLIGENCE METHODS FOR CONSTRUCTING A CLASSIFICATION MODEL OF SUCCESSFUL TRANSACTION IMPLEMENTATION IN THE SS7 NETWORK
A.V. Roslyakov, S.V. Palmov, E.V. Glushak
Telecommunications have a decisive influence on the development of human society. The type of communication can be improved in various ways. Artificial intelligence allows to contribute to the solution of the abovementioned problem. However, there is the problem of choosing the method that is most suitable for solving a specific task in a particular subject area. This is due to the large number of existing artificial intelligence tools, as well as a significant variety of situations that require consideration of certain restrictions and nuances when analyzing them. The authors of the paper conduct an experiment that aimed to simplify the solution of the stated problem when it is necessary to build a classification model that determines the success of a SS7 network transaction implementation in the provision of voice and SMS services in a mobile communication network using transferred mobile subscriber numbers. The capabilities of the five methods are analyzed: decision tree, support vector machines, random forest, neural network and naive Bayes classifier. The classification models generated by the abovementioned methods test for compliance with two requirements: the reliable predictions generation and the results stability. Models quality evaluated by three metrics: F-measure, specificity and standard deviation. The experiment used real depersonalized statistics obtained in the network of a large mobile operator. After carrying out the relevant calculations and comparisons, it was found that the decision tree method usage seems to be the most preferable, since it forms the highest quality classification models.
Keywords: artificial intelligence, telecommunications, F-measure, decision tree, classification model, SS7.
SUPPORTING DECISION MAKING TO IMPROVE PSYCHO-PHYSICAL READINESS FOR PROFESSIONAL ACTIVITY ON BASIS OF INTELLECTUAL TECHNOLOGIES
M.B. Guzairov, N.I. Yusupova, O.N. Smetanina, T.V. Naumova, E.Y. Sazonova, A.I. Agadullina
The article presents the analysis results of current state of Data Mining problem and knowledge formalization to support decision-making. The importance of professionally important qualities (PIQ), which significantly affect the labor efficiency of any specialist, is given. Authors of this article focus on models and methods of intellectual decision support in the development of PIQ. A large amount of knowledge about relationships of PIQ, psycho-physical state of a person and effect of exercise on a person has accumulated to date. The source of such knowledge may be textbooks, monographs, expert knowledge. It is noted that taking into account the preparation of students in groups by identifying students with similar characteristics will make it possible to formulate recommendations for groups and conduct joint physical training. A formal statement of the problem of decision-making support in the development of PIQ is given for the effective performance of professional activities, which consists in formalizing expert knowledge (tests for assessing PIQ, exercises for developing PIQ) and implicit knowledge obtained using Data Mining test results for assessing PIQ. In this article authors don’t consider questions of knowledge extraction, but they study questions of knowledge formalization and use for making decisions in decision support systems the technology of expert systems
Keywords: technology of expert systems, decision support, Data Mining, professional qualities, knowledge formalization.