350 rub
Journal Science Intensive Technologies №7 for 2021 г.
Article in number:
Analysis of the main methods of storing and retrieving information in databases
Type of article: scientific article
DOI: https://doi.org/10.18127/j19998465-202107-03
UDC: 004.005
Authors:

N.E. Sadkovskaya1, A.A. Suslov2, N.Yu. Kotlyarova3, M.S. Anferova4, A.Yu. Kuzmich5

1–4 Moscow Aviation Institute (National Research University) (Moscow, Russia)

2,5 Public Joint-Stock Company "Scientific and Production Association «ALMAZ» (Moscow, Russia)

3 Open joint-stock company «NIIDAR Scientific and Production Complex» (Moscow, Russia)

5 Ryazan State Radio Engineering University named after V.F. Utkin

Abstract:

In the present the moment in the Russian Federation exists the global national objective of import substitution set for different industries including the enterprises of defense industry complex (further – OPK), in particular and before the enterprises of the radioelectronic industry.

At import substitution there is a need for search, storage, the analysis and processing of a huge information stream and data. Especially sharply it is shown in production of the knowledge-intensive products. Now for the solution of this problem databases (further – a DB) which are realized in the form of information massifs are used. In such DB data are had on the grouping sign established in planning process and design (most often by the name of the stored files), however similar realization fully does not allow to process now big data streams that, in turn, negatively affects on developments and modernizations the equipment of new generation. The DB realized in the form of information massifs represents the table of admissible replacements of electroradio products of import production (further – ERP IP). In the majority replacement ERP IP of one producer on ERP IP of other producer prevails. Replacement ERP IP on domestic analogs is realized only in insignificant volume that does not allow to solve the state program of import substitution properly.

Use of mathematico-static methods and the principles of ranging of statistical signs of the available information for creation of a DB, can significantly simplify this task, and, in further, and will allow to create and use such DB at various stages of product lifecycle (at stages of planning, development and modernization of modern knowledge-intensive radar stations and the systems of airspace). Results of similar realization can be used for the problem resolution of import substitution by realization of the most effective application of a DB at the enterprises of various branch orientation.

During the work in the field of import substitution there is a need to apply various methods of information analysis and use of certain algorithms of its search in a DB.

Acceptances of the analysis of the empirical information allow to process and organize the available material. By means of these actions there is "consolidation" of information and, further, expansion of area of similarity. After that new limits of differences in the mass of empirical data are established.

After the analysis of the empirical information through groups and classifications by allocation of properties and types of information, use of mathematico-static methods and ranging of statistical signs information takes the structured form. Such type of information is applied to implementation of convenient and fast information search in certain storages and a DB.

The algorithm of realization of a DB with application of mathematico-static methods and use of ranging of statistical signs allows to obtain the most relevant information, that is information obtained on the basis of semantic search which is most "adequate" to required request.

It is possible to draw a conclusion that realization of a DB on the basis of semantic search with application of mathematico-static methods and use of ranging of statistical signs of information will allow to perform faster and reliable (relevant) search. It will provide the most effective application of a DB at the enterprises.

It is possible to use the DB realized in this way at stages of product lifecycle, namely at stages of planning, development and modernization of a product. Within the state program of import substitution this realization will allow how to improve development of new modern details and knots of the innovation products, and to provide more effective modernization of already available products.

Pages: 22-28
For citation

Sadkovskaya N.E., Suslov A.A., Kotlyarova N.Yu., Anferova M.S., Kuzmich A.Yu. Analysis of the main methods of storing and retrieving information in databases. Science Intensive Technologies. 2021. V. 22. № 7. P. 22−28. DOI: https://doi.org/10.18127/j19998465-202107-03 (in Russian)

References
  1. Animica E.G., Animica P.E., Glumov A.A. Importozameshchenie v promyshlennom proizvodstve regiona: konceptual'no-teoreticheskie i prikladnye aspekty. Ekonomika regiona. 2015. № 3. S. 163–164 (in Russian).
  2. Baryshnikova N.Yu. Obuchenie yazyku zaprosov na osnove ispol'zovaniya bazy znanij shablonov programmnogo koda. XVIII Mezhdunarodnaya nauchno-prakticheskaya konferenciya «Novye informa-cionnye tekhnologii v obrazovanii»: Sbornik trudov. 2018 (in Russian).
  3. Donskih D.N., Barabanov V.F. Ispol'zovanie ekspertnoj sistemy s produkcionnoj bazoj znanij i nejronnoj seti dlya raspoznavaniya signalov, 2020. S. 438–442 (in Russian). 
  4. Odincov. B.E. Robotizaciya processa aktualizacii baz znanij intellektual'nyh informaci-onnyh sistem predpriyatiya – Obshchestvo s ogranichennoj otvetstvennost'Yu «1S-Pablishing», 2020. S. 42–45 (in Russian).
  5. Gorelikov R.S., Gorelikova Yu.S. Razrabotka bazy znanij dlya soprovozhdeniya raboty s porta-lom znanij. Nauchnyj zhurnal. 2018. T. 4. № 4. S. 1 (in Russian). 
  6. Suslov A.A., Sarychev A.V., Sokova E.A. SamoobuchaYushchiesya intellektual'nye poiskovye si-stemy. Gagarinskie chteniya–2018: XLIV Mezhdunar. molodezhnaya nauch. konf. Sbornik tezisov i dokladov v 4-h t. M.: Moskovskij aviacionnyj institut (nacional'nyj issledovatel'skij uni-versitet). 2018. T. 1. S. 333 (in Russian).
  7. Suslov A.A. Evristika i evristicheskie metody resheniya zadachi. Gagarinskie chteniya–2016: XLII Mezhdunar. molodezhnaya nauch. konf. Sbornik tezisov dokladov v 4-h t. M.: Moskovskij avia-cionnyj institut (nacional'nyj issledovatel'skij universitet). 2016. T. 1. S. 40 (in Russian).
  8. Sarychev A.V., Suslov A.A., Grapenenko O.F. Upravlenie zhiznennym ciklom produkcii. Ga-garinskie chteniya–2018: XLIV Mezhdunar. molodezhnaya nauch. konf. Sbornik tezisov i dokladov v 4-h t. M.: Moskovskij aviacionnyj institut (nacional'nyj issledovatel'skij universitet). 2018. T. 1. S. 111 (in Russian).
  9. Suslov A.A. Primenenie iskusstvennogo intellekta pri razrabotke RLS novogo pokoleniya, osnovannogo na evristicheskih metodah: Vypusknaya kvalifikacionnaya rabota magistra (magister-skaya dissertaciya). M.: Moskovskij aviacionnyj institut (nacional'nyj issledovatel'skij uni-versitet). 2018. 124 c. (in Russian).
  10. Segaran T., Evans C., Taylor J. Programming the Semantic Web. 2009 (in Russian).
Date of receipt: 26.07.2021
Approved after review: 12.08.2021
Accepted for publication: 14.10.2021