A.S. Kuznetsov1, K.S. Sokolov2, M.N. Ushkar3

1,3 Moscow Aviation Institute (National Research University) (Moscow, Russia)

2 JSC «SPA of long-range radar named after academician A.L. Mints» (Moscow, Russia)

1 kuznetsovas@mai.ru, 3 ushkarmn@mai.ru

The requirements for shortening the design time and reducing the cost of designing REA necessitate the widespread use of high-availability modules that implement composite parts of the designed product. To date, a large amount of intellectual information on ready-made and manufactured modules has been accumulated in the electronic archives of enterprises, and this volume is continuously increasing, which leads to a significant increase in alternative versions of module sets covering the components of the product. For practical use of this information when designing a new product in a short time, it is necessary to automate the processes of forming the design basis of the designed product and choosing the preferred option for a set of modules covering its components.

Goal – to develop an automation methodology, as well as its practical implementation, and to form a constructive basis for the projected REA. The methodology is presented, and based on it, a software package is proposed that allows automating the processes of selecting from the electronic archives of the enterprise all the necessary data of the required ready-made modules and forming the initial constructive basis of the projected REA; synthesis of alternative sets of modules covering the components of the projected REA; analysis and classification of synthesized alternative sets of modules in order to selection of acceptable sets of modules of the projected REA; ranking of acceptable sets of modules according to a given criterion in order to select the preferred option for a set of REA modules. The developed automation technique is used for the practical implementation of the software package, which makes it possible to form the constructive basis of the designed REA product. The basis of the complex is the MS SQL Server database management system.

Kuznetsov A.S., Sokolov K.S., Ushkar M.N. Automation of the formation of the constructive basis of REE. Achievements of modern radioelectronics. 2025. V. 79. № 7. P. 62–72. DOI: https://doi.org/10.18127/j20700784-202507-04 [in Russian]

1. Itsik B., Deyan S., Ron T. Microsoft SQL Server 2012. Sozdanie zaprosov. Uchebnyy kurs Microsoft. M: Vysshaya shkola. 2014. [in Russian]
2. Bezrukov A.V. i dr. Proektirovanie radioelektronnykh sredstv: Ucheb. posobie. SPb.: Balt. gos. tekhn. un-t. 2019. [in Russian]
3. Spravochnik po radiolokatsii. Pod red. M.I. Skol'nika. Per. s angl. pod obshchey red. V.S. Verby. V 2-kh knigakh. Kn. 1. M.: Tekhnosfera. 2014. [in Russian]
4. Nosov V.A. Kombinatorika i teoriya grafov. M.: Moskovskiy gos. in-t elektroniki i matematiki (tekhnicheskiy universitet). 1999.
   [in Russian]
5. Kristofides N. Teoriya grafov. Algoritmicheskiy podkhod. M.: Mir. 1978. [in Russian]
6. Khaggarti R. Diskretnaya matematika dlya programmistov. M.: Tekhnosfera. 2016. [in Russian]
7. Virt N. Algoritmy i struktury dannykh. M.: Mir. 1989. [in Russian]
8. Ribson Ya., Veber D., Eifrem E. Grafovye bazy dannykh. M.: DMK-Press. 2016. [in Russian]
9. Khenderson Ken Professional'noe rukovodstvo po Transact-SQL. Per. s angl. SPb.: Piter. 2005. [in Russian]
10. Obrabotka grafov v SQL Server i Bazy dannykh SQL Azure. URL: https://learn.microsoft.com/ru-ru/sql/relational-databases/graphs/sql-graph-overview?view=sql-server-ver16. [in Russian]
11. Novikov F.A. Diskretnaya matematika: Uchebnik dlya vuzov. SPb.: Piter. 2017. [in Russian]
12. Polyakova L.N. Osnovy SQL: Ucheb. posobie dlya vuzov. Izd. 2-e, ispr. M.: Internet-Universitet Informatsionnykh Tekhnologi: Binom. Laboratoriya znaniy. 2007. [in Russian]
13. Sv-vo o gosud. registratsii programmy dlya EVM № 2023615662. Programma formirovaniya ranzhirovannogo ryada komplektov konstruktorskikh moduley proektiruemoy radioelektronnoy apparatury (REA). Kuznetsov A.S. Prior. ot 06.03.2023. [in Russian]