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
This article analyzes the organizational and technological solutions used in the investment and construction sector, aimed at significantly increasing the efficiency of construction production and optimizing labor productivity. The process of implementing investment and construction activities is a multifaceted set of strategic maneuvers aimed at attracting capital investments, improving organizational and technological management and successfully completing project initiatives. The integration of innovative approaches in resource management and labor organization processes serves as the basis for the formation of a sustainable competitive advantage and maximizing performance in the dynamically developing construction industry. Organizational and technological schemes for the implementation of investment and construction projects are considered. Attention is paid to the issue of complex turnkey contracts, which involve the preparation of preliminary contract documentation in two stages. The contractor studies the requirements put forward by the customer, after which he sends him his proposals, after approval and acceptance of which the risk of constructive and organizational and technological solutions is reduced.
Keywords: organizational and technological solutions, investment and construction processes, facility, organizational management structures, reliability, efficiency
This paper investigates the effectiveness of the distance fields method for building 3D graphics in comparison with the traditional polygonal approach. The main attention is paid to the use of analytical representation of models, which allows to determine the shortest distance to the objects of the scene and provides high speed even on weak hardware. Comparative analysis is made on the possibility of wide model detailing, applicability of different lighting sources, reflection mapping and model transformation. Conclusions are drawn about the promising potential of the distance field method for 3D graphics, especially in real-time rendering systems. It is also emphasized that further research and development in this area is relevant. Within the framework of this work, a universal software implementation of the distance fields method was realized.
Keywords: computer graphics, rendering, 3D graphics, ray marching, polygonal graphics, 3D graphics development, modeling, 3D models
The article considers the possibility of measuring the temperature of cable transmission lines with the help of specially manufactured narrowed quartz optical fiber. The technology of manufacturing of narrowed optical fiber on a specially designed device is considered. The device of laboratory installation for revealing the expansion of optical fiber under the influence of temperature is considered. The influence of temperature on the laser beam deflection in the created quartz single-mode fiber is investigated.
Keywords: optical fiber, fiber optic sensor, temperature measurement, cable power lines
The article describes the methodology for developing a client-server application intended for constructing a virtual museum. The creation of the server part of the application with the functions of processing and executing requests from the client part, as well as the creation of a database and interaction with it, is discussed in detail. The client part is developed using the Angular framework and the TypeScript language; the three-dimensional implementation is based on the three.js library, which is an add-on to WebGL technology. The server part is developed on the ASP.NET Core platform in C#. The database schema is based on a Code-First approach using Entity Framework Core. Microsoft SQL Server is used as the database management system.
Keywords: client-server application, virtual tour designer, virtual museum, three.js library, framework, Angular, ASP.NET Core, Entity Framework Core, Code-First, WebGL
This article presents a study on the approach to the development of a medical decision support system (DSS) for the selection of formulas for calculating the optical strength of intraocular lenses (IOLs) used in the surgical treatment of cataracts. The system is based on the methods of building recommendation systems, which allows you to automate the process of choosing an IOL and minimize the risk of human error. The implementation of the system in the practice of medical organizations is expected to be highly accurate and efficient, significantly reduce the time allowed for decision-making, as well as improve the results of surgical interventions.
Keywords: intraocular lens, ophthalmology, formulas for calculating optical strength, web application, machine learning, eye parameters, prognostic model, recommendation system, prediction accuracy, medical decision
The article is devoted to the issue of making organizational and technological decisions when the stock of information for alternatives to choosing the required tasks is either very small, or they are changing drastically. Since it is not easy to make an organizational and technological business decision due to the fact that it is not clear what the result will be, it is proposed to use game theory in conditions of uncertainty. What kind of decision will be made and which of the available strategies the designer will adopt depends on what economic effect will be obtained as a result of the implementation of the organizational and technological solution being developed. Game theory is a special class of mathematical models for decision-making under specific conditions. By choosing solutions in the wake of uncertainty, game theory formalizes possible knowledge about the course of action of the participants in the game in certain conflict situations and allows you to mathematically substantiate knowledge about a rational course of action in certain conditions. When constructing construction projects in environmentally unfavorable conditions, the risk matrix is compared and the best option for the development of a construction project is determined.
Keywords: construction and technical expertise, reliability, organizational and technological solutions, diagnostic methods, efficiency.
This paper examines the problems and obstacles that arise during the implementation of investment projects in the field of capital construction, between the customer and the general contractor (a subsidiary of the customer). To solve the problems, it is proposed to develop specific measures to modernize the investment and construction activities of the customer company, in accordance with the economic development strategy adopted in Russia, based on digitalization. Information systems and technologies offer great opportunities for the development of various aspects of economic activity. One of them is information systems for managing investment projects. As a result of the work, the authors formulated the main directions of development and proposed solutions for modernizing the investment and construction activities of the customer company.
Keywords: investment and construction activities, investment project, industrial construction, customer, general contractor, information systems and technologies
Information technologies are used in all spheres of modern society. Databases and document flow in organizations must be clearly organized, streamlined, and the interconnected work of company departments and services must be ensured to collect and process information flows and make effective management decisions. The article reflects the place of the stages of planning and designing information technologies and methods of their development in the algorithm for forming the strategy of an organization's IT project. Approaches to the formation of automated workplaces are shown using the example of the organizational and managerial structure of an enterprise. The services and departments of the organization responsible for planning, accounting, analysis and control of its financial results have been identified, which led to the conclusion about the directions for improving the quality of IT project development.
Keywords: information system, IT project, planning, design, modeling, automated workstations
Automation of the production of butadiene-nitrile rubbers is one of the most important directions in the chemical industry. This article presents a systematic review of existing domestic and foreign solutions, as well as describes the methods of integrated control systems for automating the production of butadiene-nitrile rubbers. Modern technologies used in manufacturing enterprises are considered, including automated systems for control, management and monitoring of processes: from robotic manipulators to digitalization of production processes. The advantages and disadvantages of automation approaches are evaluated, and trends in the development of this area are highlighted. The article is intended for specialists in the field of chemical industry, process engineers, as well as anyone interested in modern production automation technologies in the chemical industry. Previous studies will be analyzed, and examples of successful implementation of automated.
Keywords: distributed control systems, automation, integration, data transfer, architecture of automation levels, automated control systems
The article offers a variant of the development of lighting design projects for outdoor architectural lighting. Based on the modeling of light distribution in the DIALux 4.13 program, brushes have been created using specific lighting devices that simulate lighting effects from real lighting devices. A variant of the sketch of outdoor architectural lighting using Adobe Photoshop has been created with the implementation of local lighting techniques using the example of a drama theater building. Using a three-dimensional model of the object, a light design project was created in the DIALux EVO program. The proposed method of creating sketches is useful in professional activities related to the development of sketches of lighting design projects based on their high-quality photographs without the need to develop three-dimensional models, for conceptual proposals of fragments of the urban light environment and landscape territories. Having developed a base of brushes (based on real light distributions of lighting devices), it is possible to create sketches of architectural lighting of buildings that implement various lighting techniques.
Keywords: adobe photoshop, dialux 4.13, dialux evo, sketch, brush, building facade, outdoor architectural lighting, lighting effect, lighting technique, architectural lighting concept
Providing the population with comfortable housing has always been a pressing issue. However, there are very few formalized criteria for this, apart from the regulation of minimum floor areas. In this context, the article deals with the problem of evaluating the efficiency of residential space design solutions in terms of their logistical comfort. For this purpose, a method is proposed that uses the apparatus of graph theory and allows to calculate the time cost of an "idle" move for a representative of a given social group in relation to the evaluated design solution. An idle move is a user's movement between characteristic functional zones of the layout. A special matrix is used to model the links between these zones, the construction of which is similar to that of the incident matrix in undirected graphs. As an example of the applicability of the proposed approach, several variants of layouts of one-room, two-room and three-room flats are considered. The comparison of the obtained results for different types of layouts, including those that existed 15-20 years ago and modern ones, indicates a tendency to increase the logistic comfort of modern layouts.
Keywords: planning solution, logistic comfort, idling, graph theory
The paper proposes a method for identifying patterns of the relative positions of buildings, which can be used to analyze the dispersion of air pollutants in urban areas. The impact of building configuration on pollutant dispersion in the urban environment is investigated. Patterns of building arrangements are identified. The methods and techniques for recognizing buildings are examined. The outcomes of applying the proposed method to identify building alignments are discussed.
Keywords: patterns of building location, geoinformation technologies, GIS, geoinformation systems, atmospheric air
The article discusses issues of improving the quality and safety of pedestrian and vehicle traffic in underground linear structures. The main parameters of traffic safety in tunnel-type transport structures are considered. The scope of application of luminescent and retroreflective materials in the construction and operation of concrete and asphalt concrete pavements has been determined. Recommendations are given for the use of special luminous materials in construction practice.
Keywords: concrete, asphalt concrete, reflective coatings, luminescent materials, traffic safety
This article is devoted to the development of a method for detecting defects on the surface of a product based on anomaly detection methods using a feature extractor based on a convolutional neural network. The method involves the use of machine learning to train classification models based on the obtained features from a layer of a pre-trained U-Net neural network. As part of the study, an autoencoder is trained based on the U-Net model on data that does not contain images of defects. The features obtained from the neural network are classified using classical algorithms for identifying anomalies in the data. This method allows you to localize areas of anomalies in a test data set when only samples without anomalies are available for training. The proposed method not only provides anomaly detection capabilities, but also has high potential for automating quality control processes in various industries, including manufacturing, medicine, and information security. Due to the advantages of unsupervised machine learning models, such as robustness to unknown forms of anomalies, this method can significantly improve the efficiency of quality control and diagnostics, which in turn will reduce costs and increase productivity. It is expected that further research in this area will lead to even more accurate and reliable methods for detecting anomalies, which will contribute to the development of industry and science.
Keywords: U-Net, neural network, classification, anomaly, defect, novelty detection, autoencoder, machine learning, image, product quality, performance