S.S. Lyalkov1
1 MIREA – Russian Technological University (Moscow, Russia)

1 info@radiotec.ru

The article is devoted to the aspects of using the object-relational database management system (DBMS) PostgreSQL as the main storage of static and dynamic route information in modern river information systems deployed on the inland waterways of the Russian Federation. The mechanisms of data consolidation from several PostgreSQL DBMS have been considered. The main aspects of using PostgreSQL in river information systems for storing heterogeneous information and the possibility of linking it to virtual objects of shipping routes for exchanging electronic data between river vessels and coastal control points, including for exchanging route information on navigation conditions on waterways, have been covered. The world experience of using various information technologies for the implementation of software that meets the standards of notices to skippers and electronic single message systems in inland navigation has been summarized. The practical significance of the study lies in the consideration and implementation of fundamental approaches to the use of the object-relational database management system PostgreSQL, due to its reliability, performance and scalability, as the basis of river information service systems, and their implementation on inland waterways.

Lyalkov S.S. Object-relational DBMS PostgreSQL as a part of modern river information systems. Neurocomputers. 2025. V. 27. № 4. P. 81–87. DOI: https://doi.org/10.18127/j19998554-202504-08 (in Russian)

1. Rezolyutsiya № 57 ECE/TRANS/SC.3/175 «Rukovodyashchie printsipy i rekomendatsii dlya rechnykh informatsionnykh sluzhb (RIS)». 2005. (in Russian)
2. Rezolyutsiya № 60 ECE/TRANS/SC.3/175 «Mezhdunarodnye standarty, kasayushchiesya izveshchenij sudovoditelyam i sistem elektronnykh sudovykh soobshchenij vo vnutrennem sudokhodstve». 2007. (in Russian)
3. Rezolyutsiya № 80, peresmotr 1 ECE/TRANS/SC.3/199/Rev.1 «Mezhdunarodnyj standart dlya izveshchenij sudovoditelyam vo vnutrennem sudokhodstve». EEK OON. 2020. (in Russian)
4. Mou J., Ligteringen H., Dai J.F. Discussion on river information services (RIS) in China. International Technical Seminar. Beijing. 2008.
5. Bobkov V.A., Krest'yaninov V.V. Nauchno-tekhnicheskij kommentarij: «Kak sozdat' rechnye informatsionnye sluzhby v Rossijskoj Federatsii». SPb.: OOO MOSAR. 2007. (in Russian)
6. Kotsyuba I.Yu., Chunaev A.V., Shikov A.N. Osnovy proektirovaniya informatsionnykh sistem: Ucheb. posobie. SPb: Universitet ITMO. 2015. (in Russian)
7. Polozhenie «Ob obespechenii informatsiej sudovladel'tsev i sudovoditelej o putevykh usloviyakh plavaniya na vnutrennikh sudokhodnykh putyakh Rossijskoj Federatsii». 1995. (in Russian)
8. Gibadullin R., Vershinin I., Minyazev R. Realization of replication mechanism in PostgreSQL DBMS. 2017. P. 1–6. DOI: 10.1109/ICIEAM. 2017.8076380.