Relational model of a communication network node device for telecommunication systems

Relevance. Modern development of telecommunication networks requires technologies for constructing an analytical system of operational support of the network using inventory, technological and analytical information on communication nodes for designing nodes and communication lines, routes and other telecommunication services. Planning and optimization of the communication network structure is of great importance for optimizing network loads when changing data traffic, the number of users, requirements for service availability and the quality of communication services provided.

Purpose. Modeling of the device of a communication network node for a prototype of a  network support system, its representation in the form of an ER diagram.

Materials and methods. Domestic DWDM/SDH equipment manufactured by T8 and Supertel OJSC (Russia) was used. Results. A fairly universal relational model of a communication node device was developed.

Conclusions. The model is applicable to any equipment of any configuration used to provide telecommunication services.

1. Koucheryavy A., Vladyko A., Kirichek R., Makolkina M., Paramonov A., Vybornova A., Pirmagomedov R. The prospects for research in the field of communications networks on the 2017–2020 years. Telecom IT. 2016;4(3):1–14 (In Russ.).

2. Cholda P., Mykkeltveit A., Helvik B.E., Wittner O.J., Jajszczyk A. A. survey of resilience differentiation frameworks in communication networks. IEEE Communications Surveys & Tutorials. 2007;9(4):32–55. https://doi.org/10.1109/COMST.2007.4444749

3. Wiatr P., Chen J., Monti P., Wosinska L. Energy efficiency versus reliability performance in optical backbone networks. Journal of Optical Communications and Networking. 2025;7(3): A482-A491. https://doi.org/10.1364/JOCN.7.00A482

4. Chechin G.V. Mathematical Model for Analyzing Communication Networks with One or Several Traffic Exchange Nodes. Electrosvyaz. 2019;(7):50–55. (In Russ.).

5. Ivanov R.M. Functional model of the structure of a special-purpose communication node of a dispersed (modular) control center. News of Tula State University. Technical sciences. 2021;(9):231–236. (In Russ.). https://doi.org/10.24412/2071–6168–2021–9–231–236

6. Naniy O.E., Starikov P.P., Petrov S.V. and etc. Engineering and technical solutions for building a backbone and regional communication network using OTN/DWDM technology. Information and communication. 2019. № 1. р. 74–83. (In Russ.). https://doi.org/10.34219/2078–8320–2019–10–1–74–83. EDN ZCPWYX

7. Zaikova E.A., Morgunov E.P. Overview of existing database backup tools in POSTGRESQL database management system. Current problems of aviation and cosmonautics. 2 (2021): 248–250. (In Russ.).

8. Makris A., Tserpes K., Spiliopoulos G. et al. MongoDB Vs PostgreSQL: A comparative study on performance aspects. Geoinformatica. 2021;25(2):243–268. https://doi.org/10.1007/s10707–020–00407-w

9. Truskowski W., Klewek R., Skublewska-Paszkowska, M. (2020). Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization. Journal of Computer Sciences Institute, 16, 279–284. https://doi.org/10.35784/jcsi.2026

10. Mohammed M.A., Muhammed D.A., Abdullah J.M. Practical Approaches of Transforming ER Diagram into Tables. International Journal of Multidisciplinary and Scientific Emerging Research. 2015;4(22):2349–6037.

11. Starushenkova E.E. The main stages of database design. E-Scio. 2021;(11):318-323. (In Russ.). EDN OLOOIR

12. Sinitsyn A.V., Sinitsyn A.A., Zhavoronkova O.G. An algorithm for building optimal routing for a fault-tolerant communication network. Informatization and communication. 2023;(5):49–56. (In Russ.). DOI: 10.34219/2078-8320-2023-14-5-49-56

13. Ivashchenko V.A., Babintsev Y.N., Karnaukh D.I., Lukyanov S.E., Suprun A.P., Betin V.N. Forecasting the traffic of telecommunication networks and their optimization. Informatization and communications. 2023;(4):53–58. (In Russ.). https://doi.org/10.34219/2078–8320–2023–14–4–53–58. EDN CPWWJP.