«Automation and Informatization of the fuel and energy complex»

Reality and illusions of databases import substitution within the framework of the information management system of the fuel and energy complex corporation

UDC: 620.19:621.43
DOI: -

Authors:

¹ Gazprom Diagnostics, St. Petersburg, Russia
² National University of Oil and Gas "Gubkin University", Moscow, Russia

Keywords: databases, information system, import substitution, technological risk

Annotation:

The authors of the article assess the process of the database import substitution for the information system of a fuel and energy complex corporation from the point of view of a risk-oriented approach. The data of the world ranking of database management systems (DBMS) are provided. The relevance of replacing an imported DBMS by a domestic one with the criterion of minimizing the loss of functionality during such a transition is emphasized. Linguistic, hardware, economic and other types of risks are additionally assessed and analyzed. Particular attention is paid to the description of operational risks, which ultimately determine the consuming qualities of the product at the output of such a transformation. It is noted that only the necessity of implementing a comprehensive and balanced approach with strict control of the entire import substitution process can give an acceptable result in practice.

Bibliography:

1. Filipenkov A.V., Kuz'min E.L. Sravnenie sushchestvuyushchikh sistem upravleniya bazami dannykh v tselyakh vybora nailuchshey pri realizatsii trebovaniy po sokrashcheniyu zatrat i importozameshcheniyu // Gazovaya prom-st'. – 2018. – № 4(767). – S. 24–29.
2. Vasilchenko M., Zavyalov A.P., Zhuchkov K.N. Increasing the Stability of a Spatially Distributed Information System using a Robust Algorithm for Filtering Anomalous Measurements // Information Technology in Industry. – 2020. – Vol. 8, No. 3. – P. 1–7.
3. Shcherbina T.A. Osobennosti gosudarstvennoy politiki importozameshcheniya v Rossii v sfere apparatnogo i programmnogo obespecheniya // Rossiya: tendentsii i perspektivy razvitiya: ezhegodnik: vyp. 11, ch. 3 / otv. red. V.I. Gerasimov. – M.: INION RAN, 2016. – S. 364–368.
4. Kokhno P.A., Prokopova T.V. Sovremennyy uroven' avtomatizatsii sistem prinyatiya resheniy predpriyatiyami oboronno-promyshlennogo kompleksa // Nauch. vestn. oboronno-prom. kompleksa Rossii. – 2017. – № 1. – S. 40–53.
5. Kurniawan M.S., Zaini O.K., Wihartika D. Implementation of Business Intelligence for Product Optimization to Enhance Profitability Through the Utilization of Synergies Among the Product Departments of the Look Company for the Period 2019-2022 // J. of Social Transformation and Regional Development. – 2024. – Vol. 6, No. 1. – P. 10–19. – DOI: 10.30880/jstard.2024.06.01.002
6. Suslov N.S., Khafizov A.M. Importozameshchenie na primere ERP sistemy: nyuansy, zadachi i podkhody // Inform. tekhnologii. Problemy i resheniya. – 2023. – № 4(25). – S. 18–21.
7. Opyt migratsii informatsionnoy sistemy otsenki tekhnicheskogo sostoyaniya tekhnologicheskikh ob"ektov gazovoy promyshlennosti v zashchishchennyy kontur Tsentra obrabotki dannykh PAO "Gazprom" / A.V. Shibanov, D.V. Tret'yakov, D.S. Pochikeev [i dr.] // Avtomatizatsiya i informatizatsiya TEK. – 2023. – № 5(598). – S. 5–15. – DOI: 10.33285/2782-604X-2023-5(598)-5-15
8. Prokhorov A N. Zachem nam voobshche zameshchat' "uslovnyy Oracle" // Tsifrovaya ekonomika. – 2018. – № 3(3). – S. 87–95.
9. Krivchikov M.A., Roganov V.A., Vasenin V.A. Opyt migratsii informatsionno-analiticheskoy sistemy bol'shikh naukometricheskikh dannykh na sistemu upravleniya PostgreSQL // Programmnaya inzheneriya. – 2024. – T. 15, № 2. – S. 59–72. – DOI: 10.17587/prin.15.59-72
10. Perenos dannykh s Oracle na PostgreSQL: osnovnye etapy, nesovpadayushchie tipy i formaty dannykh / Postgres Professional. – URL: https://habr.com/ru/companies/postgrespro/articles/676792/ (data obrashcheniya 26.02.2025).
11. Bunyaeva E.V., Romanova A.G. Razlichiya dialektov yazyka SQL v SUBD Microsoft SQL Server i Postgree SQL // Razvitie nauki i praktiki v global'no menyayushchemsya mire v usloviyakh riskov (shifr – MKRNP): sb. materialov XXIX Mezhdunar. nauch.-prakt. konf., M., 28 iyunya 2024 g. – M.: Ekonom. obrazovanie, 2024. – S. 232–241.
12. Migratsiya koda s Oracle na PostgreSQL: osobennosti i puti obkhoda, sredstva konvertatsii, vspomogatel'nye moduli / Postgres Professional. – URL: https://habr.com/ru/companies/postgrespro/articles/683764/ (data obrashcheniya 26.02.2025).
13. Baza znaniy Infostart. Migriruem s MS SQL na PostgreSQL. – URL: https://infostart.ru/1c/articles/1973932/ (data obrashcheniya 26.02.2025).
14. Obespechenie tekhnologicheskoy nezavisimosti sistem kompleksnoy avtomatizatsii proizvodstvenno-tekhnologicheskikh protsessov na predpriyatiyakh neftegazovoy otrasli / N.A. Kislenko, A.A. Burushkin, A.M. Mal'ko [i dr.] // Gazovaya prom-st'. – 2023. – № S4(857). – S. 58–65.
15. Shibanov A.V., Zhuchkov K.N., Korobeynikov A.S. Reshenie zadachi fil'tratsii anomal'nykh izmereniy s ispol'zovaniem kriteriya Neymana – Pirsona pri analize vremennykh ryadov v ISTS "Infotekh" // Avtomatizatsiya, telemekhanizatsiya i svyaz' v neftyanoy prom-sti. – 2020. – № 8(565). – S. 32–36. – DOI: 10.33285/0132-2222-2020-8(565)-32-36