Using relational databases in process design

Authors: Zavaryko A.Yu., Startsev А.А.
Published in issue: #10(51)/2020
DOI: 10.18698/2541-8009-2020-10-650
Category: Informatics, Computer Engineering and Control | Chapter: Automation, Control of Technological Processes, and Industrial Control
Keywords: database management system, Microsoft Access, relational database, SQL Server, production preparation, industrial automation, information and communication technologies, server administration
Published: 26.11.2020

Now, all large enterprises need to store, process and use large amounts of information. For this, databases are created that speed up and simplify the process of working with information. The analysis is carried out of the software used in the preparation of modern production of rocket and space technology products for the design of technological processes. An example is given of comparing the work of currently demanded software products that implement database management systems. A relational database made for a department of one of the enterprises of the rocket and space industry is considered. The conclusion is made about the advantages of using the designed database.

References

[1] Date C.J. An Introduction to database systems. Addison Wesley, 2004. (Russ. ed.: Vvedenie v sistemy baz dannykh. Moscow, Vil’yams Publ., 2006.)

[2] Kogalovskiy M.R. Perspektivnye tekhnologii informatsionnykh system [Advanced technologies of information systems]. Moscow, DMK Press Publ., Kompaniya AyTi Publ., 2003 (in Russ.).

[3] Kogalovskiy M.R. Entsiklopediya tekhnologiy baz dannykh [Encyclopedia of database technology]. Moscow, Finansy i statistika Publ., 2002 (in Russ.).

[4] Kuznetsov S.D. Osnovy baz dannykh [Fundamentals of database]. Moscow, Internet-Un-t Inform. Tekhn. Publ., Binom Publ., 2007 (in Russ.).

[5] D’yakonov M.Yu., Kuznechenkova A.V. Modern innovations in education. Sistemnye tekhnologii [System Technologies], 2017, no. 3, pp. 58–61 (in Russ.).

[6] Osnovnye svedeniya o bazakh dannykh [Basic information about databases]. support.microsoft.com: website (in Russ.) URL: https://support.office.com/ru-ru/article/Osnovnye-svedeniya-o-bazakh-dannykh-a849ac16-07c7-4a31-9948-3c8c94a7c204 (accessed: 05.05.2020).

[7] Sravnitel’naya kharakteristika dvukh SUBD MS Access iSQL Server 2005 [Comparative analysis of MS Access iSQL Server 2005 two DBMS]. itfb.com.ua: website (in Russ.). URL: https://itfb.com.ua/templates/itfb.com.ua/pdf/MS%20Access%20MS%20SQL%20Server%202005.pdf (accessed: 06.05.2020).

[8] Abyshev I.A. Using of ICT will raise education quality. Distancionnoe i virtual’noe obuchenie, 2011, no. 3, pp. 56–64 (in Russ.).

[9] DB-engines ranking. db-engines.com: website. URL: https://db-engines.com/en/ranking (accessed: 06.05.2020).

[10] Rassuzhdenie na temu, kakuyu bazu dannykh vybirat’ [Argument about database choice]. habr.com: website (in Russ.). URL: https://habr.com/ru/post/348220 (accessed: 05.05.2020).

[11] Konyukhov V.G. Database. Concept, meaning and role in the modern world. Sistemnye tekhnologii [System Technologies], 2017, no. 3, pp. 61–64 (in Russ.).