350 rub
Journal Electromagnetic Waves and Electronic Systems №3 for 2018 г.
Article in number:
The choice of the database management system for the information system of industrial enterprise
Type of article: scientific article
UDC: 004.65
Authors:

V.E. Drach – Ph.D.(Eng.), Associate Professor, Department «Design and manufacturing of electronic equipment»,

Kaluga branch of the Bauman MSTU

E-mail: drach@bmstu-kaluga.ru

A.V. Rodionov – Ph.D.(Eng.), Associate Professor, Department «Computer systems and networks», 

Kaluga branch of the Bauman MSTU

E-mail: andviro@gmail.com

A.I. Chukhraeva – Student, Department «Economics and Organization of Production», 

Kaluga branch of the Bauman MSTU

E-mail: hhxpk@mail.ru

Abstract:

The choice of concrete DBMS represents a difficult multicriteria task and in order to complete it it's necessary to take into account: the maximum number of concurrent users accessing the database, the characteristics of the client software, server resources, an operating system, skill level of personnel, etc. The simplest approach at the choice of DBMS is based on how the existing systems meet the main requirements of the certain project of an information system of the industrial enterprise. In this article the most popular DBMS are discussed, their advantages and disadvantages, according to authors, what should help to choose a system which will satisfy as much as possible inquiries and requirements under concrete needs. To facilitate the choice, the article provides a summary table.

Pages: 71-79
References
  1. Belen’kij V.M., Spiridonov V.G. Proektirovanie bazy’ danny’x po bezopasnosti truda dlya organizaczij i promy’shlenny’x predpriyatij // Texnologii texnosfernoj bezopasnosti. 2012. № 2 (42). S. 12.
  2. Borsuk N.A., Troshkin D.O., Chuxraev I.V. Analiz funkczional’nogo napolneniya soczial’nogo servisa e’lektronnogo oborota kuponov // Voprosy’ radioe’lektroniki. 2015. № 8 (8). S. 57−62.
  3. Molchanov A.N., Burmistrov A.V., Grishunov S.S., Chuxraev I.V. Nekotory’e voprosy’ sbora i obrabotki danny’x v informaczionnoj sisteme vy’sshego uchebnogo zavedeniya // Izvestiya Tul’skogo gosudarstvennogo universiteta. Texnicheskie nauki. 2016. № 7-1. S. 191−198.
  4. Nemtinov V.A., Manaenkov A.M., Morozov V.V., Egorov E.S. Ispol’zovanie interneta pri informaczionnoj podderzhke prinyatiya reshenij po upravleniyu promy’shlenny’m predpriyatiem // Prikladnaya informatika. 2010. № 4 (28). S. 8−12.
  5. Drach V.E., Rodionov A.V., Chuxraev I.V., Lechenkova A.I. GIS-prilozhenie, integrirovannoe s soczial’ny’mi setyami // Voprosy’ radioe’lektroniki. 2016. № 2. S. 13−16.
  6. Stoyanova O.V., Dli M.I., Belozerskij A.Yu. Modeli predstavleniya danny’x slozhny’x proizvodstvenny’x proektov v avtomatizirovanny’x informaczionny’x sistemax promy’shlenny’x predpriyatij // Programmny’e produkty’ i sistemy’. 2015. № 4. S. 210−218.
  7. Burmistrov A.V., Belov Yu.S. Nedostatki relyaczionny’x baz danny’x // E’lektronny’j zhurnal: nauka, texnika i obrazovanie. 2015. № 3 (3). S. 25−34.
  8. Riyaj Shamsudeen Oracle Database 12c review. URL = https://www.infoworld.com/article/2611000/database/oracle-database-12creview--finally--a-true-cloud-database.html.
  9. Podxolzin I.A., By’kova M.I. SUBD MYSQL: dostoinstva, nedostatki, primenenie // Materialy’ XVII Mezhdunar. nauchno-metodicheskoj konf. «Informatika: problemy’, metodologiya, texnologii». 2017. S. 141−143.
  10. Petuxov I.S. Algoritm opredeleniya neobxodimy’x indeksov dlya optimizaczii zaprosov s soedineniem dvux tablicz v SUBD MYSQL (INNODB) // Nauchny’j vestnik GosNII GA. 2017. № 16. S. 98−107.
  11. Oti M. Voprosy’ po SQL Server // Windows IT Pro/RE. 2016. № 3. S. 29.
  12. Panchenko I. PostgreSQL: vchera, segodnya, zavtra // Otkry’ty’e sistemy’. SUBD. 2015. № 3. S. 34−37.
  13. Pan C.S. Development of a parallel DBMS on the basis of PostgreSQL // Trudy’ Instituta sistemnogo programmirovaniya RAN. 2011. T. 21. S. 357−370.
  14. MongoDB multi-document ACID tpansactions are coming. URL = https://www.mongodb.com/. Data obrashheniya 16.01.2016.
  15. Shmidt I.A., Vasenev N.V. Vy’bor optimal’noj JSON-modeli dlya xraneniya rezul’tatov ispy’tanij // Fundamental’ny’e issledovaniya. 2016. № 11-3. S. 620−625.
  16. MariaDB ob’‘edinyaet preimushhestva SQL i NOSQL // Otkry’ty’e sistemy’. SUBD. 2014. № 3. S. 3−9 s.
  17. IBM Db2 Database. URL = https://www.ibm.com/analytics/us/en/db2/. Data obrashheniya 01.01.2018.
  18. SAP HANA. URL = https://www.sap.com/products/hana.html. Data obrashheniya 20.12.2017.
  19. LINTER kak SUBD dlya intellektual’ny’x informaczionny’x sistem. Ch. 1 // Nejrokomp’yutery’: razrabotka, primenenie. 2009. № 2. S. 4−11.
  20. Markin S.P., Borisov V.L., Raspopov A.V., Maksimov V.E. SUBD LINTER dlya intellektual’ny’x informaczionny’x sistem. Chast’ 2, 3 // Nejrokomp’yutery’: razrabotka, primenenie. 2009. № 2. S. 12−29.
  21. Sistema upravleniya bazami danny’x Linter. URL = http://linter.ru/ru/. Data obrashheniya 01.12.2017.
  22. REDSOFT. URL = http://www.red-soft.ru/ru. Data obrashheniya 01.12.2017.
  23. Simakov R. SUBD «Red Baza Danny’x» dlya serverny’x OS // Sistemny’j administrator. 2015. № 7-8 (152−153). S. 108−109.
  24. Axel Fontaine Relational Database Popularity Ranking. URL = https://dzone.com/articles/relational-database-popularity. Data obrashheniya 25.11.2017.
  25. EVerSQL. URL = https://www.eversql.com/most-popular-databases-in-2017-according-to-stackoverflow-survey/. Data obrashheniya 12.12.2017.
Date of receipt: 6 апреля 2018 г.