The article is devoted to the design of a test automation system for the DBaaS Postgres Pro cloud database management manager. New approaches, concepts and definitions of the theory of test automation are formulated and old ones are updated. An analysis of modern tools widely used in commercial software development is carried out. The features of the system under test were studied, including the specifics of working with cloud computing and the Postgres DBMS. Based on the data obtained, an optimal technology stack was formed that is planned to be used in development, and functional requirements for the test automation system were developed. In practical terms, the use of this system on a DBaaS project will reduce labor intensity and speed up work at the testing and development stages, increase the efficiency of testing and the quality of the software product.
Keywords: software testing automation, DBaaS, cloud database, Postgres DBMS, GO programming language
The article is devoted to the development of automated information systems (AIS) for electronic document management in the educational field. Using the example of the process of accreditation monitoring of basic professional educational programs implemented in university departments, functional requirements, user algorithms and a prototype AIS (web system) for generating documents have been developed. The use of the considered AIS allows you to flexibly customize the structure of documents and data completion forms for accreditation monitoring, add and edit the required data about teachers in visual web interfaces, automatically generate documents based on information stored in the database, manage the life cycles of documents, evaluate the quality of the documents compiled. The labor intensity of working with documents is significantly simplified compared to existing business processes. The proposed approach can be applied to the development of document flow subsystems for various business processes of a university within the framework of educational, methodological, scientific and other types of activities of employees and, as a result, towards the creation of a unified AIS for electronic document management of the university, based on the integration of all subsystems. The described functionality and algorithms can be adapted to the creation of web systems for electronic document management of computer training complexes (CTC) for collecting and processing data on the progress of students, managing the life cycle of developing exercises for the CTC and performing them by trainees.
Keywords: automated information systems, electronic document management, information technologies in education, document life cycle, UML graphic notation
The production of ultra high molecular weight polyethylene (UHMWPE) is associated with significant dust emissions into the production room, so the aspiration system plays an important role in the technological process. The study of dust in industrial product waste released into the work area is one of the objectives of the ongoing research. This work provides information on the dispersed composition of ultra-high molecular weight polyethylene (UHMWPE) particles, and various graphs are constructed based on the data obtained. Data on the deposition rate of UHMWPE particles were obtained experimentally. A comparative analysis of the obtained data with theoretical data obtained using formulas was carried out.
Keywords: ultra high molecular weight polyethylene, UHMWPE, dispersed composition of ultra high molecular weight polyethylene, sedimentation rate of ultra high molecular weight polyethylene particles, method for studying the properties of raw high molecular weight
Relevance and goals. The article describes a project in the field of solving the problem of managing organizational systems through the development of a system for remote monitoring and control of spatially distributed objects using LoRa network technology. Materials and methods. The project provides testing and practical use of LoRa networks. The developed system consists of 3 main modules: Devices, server part, and client application. In turn, devices are divided into gateways and end devices. Results. An automated system for managing spatial objects was designed, gateway devices and end devices that form a prototype of the Internet of Things network were developed and tested, as well as the server part of an automated system for remote control of spatially distributed devices. Conclusions. The system was tested and debugged, and a streamlined system for remote monitoring and control of spatially distributed objects was obtained based on the concept of the Internet of Things using LoRa network technology. It is assumed that the results of R&D will be in demand in organizations whose activities involve the use of spatially distributed resources.
Keywords: Internet of things, management of geographically distributed systems, LoRa networks, geosystem approach, spatial data infrastructures
The drilling and blasting method is currently the most widely used for mining rocks. An indicator of the high–quality drilling and blasting operations is the uniform granulometric composition of the exploded rock mass - the percentage of oversized ore pieces should be minimal. The percentage of oversized and its increase have a significant impact on the technical processes of transporting rock mass, leading to an increase in the costs of loading and transportation operations and secondary crushing of oversized ore masses. The paper describes the results of a study of methods for determining the granulometric composition of drilling and blasting operations using neural networks of segmentation Unet and FPN. Images taken from UAVs are used for analysis. A method of classifying ore by size has also been developed, which ensures the accuracy of the proportion of correct answers of more than 0.91. The expected result of the introduction of the system for automatic determination of the granulometric composition of drilling and blasting operations is the possibility of more accurate control over the quality of their performance.
Keywords: granulometric composition, Unet, FPN, classification, segmentation
The above study is aimed at calculating the market value of a land plot free from development, located in the city of Vsevolozhsk, Leningrad region. The authors consider a comparative approach to the assessment of the object, its positive sides and disadvantages are indicated. The features of the implementation of the method of comparative sales and the construction of regression models are noted. The dependence of the cost of land plots on the distance from the local center in the territory of elite cottage development was revealed. Vsevolozhsk. The conclusion is formulated about the influence of a set of factorial features and the method of their accounting on the reliability and compliance of the result with the current situation in the real estate market.
Keywords: comparative approach, comparative sales method, correlation and regression analysis, real estate market, market information, price-forming factor, analogue object, real estate object, land plot, individual housing construction
In this work, the developed system for detecting areas with defects in the development of corn crops was investigated from a photograph taken by an unmanned aerial vehicle (UAV) using computer vision. To solve the problem of detecting such sites, the structures of the YOLOv5 and YOLOv8 neural networks were considered. The use of the developed software will reduce labor and time costs for image analysis, which in turn will reduce the response time when problem areas are detected in agricultural fields to achieve higher yields.
Keywords: instance segmentation, YOLOv5, YOLOv8
The paper describes the process of modeling 3D structures of synthetic gas burners, with the analysis of the simulation results obtained for several types of models and the selection of optimal modes for them. The main use of the burner is planned for boiler equipment for household needs in private as well as apartment buildings, in the absence of central heating. In addition, the article provides a justification for the thermal parameters at the inlet and outlet of the burner.
Keywords: synthesis gas, combustion, design parameters, combustion chamber, nozzle, modeling
The concept of a two-dimensional associative masking mechanism, introduced earlier and necessary for further consideration, is used to protect the data of cartographic scenes represented by point, linear and areal objects. The masking mechanism is the basis of associative steganography. In this case, the objects and coordinates of the scene are represented by code words in the alphabet of postal symbols and are masked with the further formation of stegocontainers. A set of masks is a secret key used further to recognize a scene represented in a protected form by a set of stegocontainers. The article deals with the organization of specialized DBMS for the protection of cartographic scene data with the introduction of two levels of such DBMS – server and client. Mono- and multicluster organization of request processing is offered for the server part of the DBMS. Practical recommendations on the use of mono- and multiclusters are given.
Keywords: associative steganography, masking, stegomessage, cartographic databases, parallel DBMS, mono- and multicluster, scene analysis, cryptography, stegostability, information security
The article provides an overview of the analysis and diagnosis of product surface defects, evaluated using digital image processing. The search for scientific publications was carried out mainly in the Scopus and RSCI scientometric bases for the period 2019-2023. The purpose of this article is to determine the best methods for assessing the destruction of materials using digital images. The main methods of processing and analyzing digital images are considered. The perspective of unification of segmentation modes by digital image acquisition sources and combining images from various recording sources to obtain objective information on the nature of material destruction is shown. To reduce the time for assessing the degree of destruction of materials, it is proposed to gradually use the methods of segmentation, filtering digital images of defects in metal products with subsequent calculation by a neural network.
Keywords: defect, control, digital image, neural network.
This article represents the initial stage of research on the material layer of the architectural-natural environment of the mountainous territories of North Ossetia. The study involves analyzing and studying the traditional settlement structure in this region, taking into account architectural-compositional features. The main goal of the research is to understand and describe different architectural approaches used in traditional settlements of North Ossetia. To achieve the set goals, the study utilizes geographic information systems and programming. Geographic information systems enable the analysis of spatial data and visualization of compositional forms of settlement structures in mountainous territories. Programming allows automating data processing and analysis processes. The research also takes into account the natural and landscape features of the region. Natural conditions of the mountainous territories of North Ossetia influence architectural decisions, such as material usage, adaptation to uneven terrain, and more. It is important to understand how architectural-compositional features are combined with natural features and contribute to the formation of sustainable and harmonious settlements. The obtained results of the research will have practical value for the preservation and use of traditional architecture and cultural heritage of North Ossetia. They can be used in the planning and design of new settlements, considering the unique architectural-compositional features of this region and with the aim of preserving its unique cultural and natural environment.
Keywords: settlement structure, mountainous territory, composition, shape, natural landscape, relief, architectural composition, North Ossetia, Alania, mountain settlement
The impact of the alkali NaOH on the structure and morphology of cellulose has been considered. Using X-ray spectroscopic microanalysis and electron microscopy, it has been determined that treatment of wood cellulose with aqueous solutions of NaOH allows to reduce the content of lignin in cellulose and significantly improve the topography of the fibers. A comparative analysis of alkali cellulose samples was conducted, obtained during treatment with NaOH solutions of 13.7% and 12.3% concentration for a process duration of 5.5 hours, at a temperature of 124 °C. It has been established that at the considered concentrations of NaOH, approximately ~75% and ~50% of lignin is removed from the original cellulose, respectively. The results of infrared spectroscopy indicate an increase in the amorphization of alkali cellulose. Alkali cellulose, formed at a NaOH concentration of 13.7%, exhibits superior morphological uniformity and a lower lignin content.
Keywords: wood cellulose, chemical treatment, alkalinity, lignin, X-ray spectral microanalysis, electron microscopy
The article raises the problems of preserving historical architectural and natural complexes on the example of the Peter and Paul Park in Yaroslavl. In the Introduction to the article, attention is drawn to the importance of the problem of preserving historical monuments of architecture or art not only in the capital cities, but also on the periphery. The following are the main methods used in the work to assess the state of the architectural and park ensemble, to identify its characteristic architectural and landscape features and to develop a theoretical conservation model. In the main part of the article, the historical stages of the formation of the architectural and park ensemble of the Peter and Paul Park, their influence on the final appearance of the ensemble are considered; a comparative analysis with similar architectural and park ensembles is given, common characteristic features are identified and the principles of the formation of the Peter and Paul Park are established. As a result of the conducted research, a model of preservation of the Petropavlovsk architectural and park ensemble of Yaroslavl is proposed, presented in the form of a master plan of the park territory, which contains proposals for the reorganization of the territory, pedestrian park network and restoration of historically significant structures. In the final part of the article, the main conclusions based on the results of the study are formulated.
Keywords: architectural and park ensemble, Peter and Paul Park, Yaroslavl Big Manufactory, regular layout, theoretical model of conservation
This article presents a research study dedicated to the application of the YOLOv8 neural network model for road sign detection. During the study, a model based on YOLOv8 was developed and trained, which successfully detects road signs in real-time. The article also presents the results of experiments in which the YOLOv8 model is compared to other widely used methods for sign detection. The obtained results have practical significance in the field of road traffic safety, offering an innovative approach to automatic road sign detection, which contributes to improving speed control, attentiveness, and reducing accidents on the roads.
Keywords: machine learning, road signs, convolutional neural networks, image recognition
This paper examines the impact of regulations on cultural heritage protection zones on the cost of land plots intended for hotel accommodation. The application of the theory of fuzzy sets to assess the influence of cultural heritage objects on the value of commercial land plots is substantiated. The result of the study is a methodology for estimating the share of the value of a commercial land plot attributable to the presence of a cultural heritage protection zone, based on the methodology for determining easement fees and the theory of fuzzy sets.
Keywords: hotel, historical and cultural monument, phasification, market value, cadastral value, type of permitted use, term-set, restrictions of use, adaptation, sustainable development