AUTOMATION OF ACCOUNTING THE NUMERIC PARTS AND UNITS AT MANUFACTURING ENTERPRISES
https://doi.org/10.21822/2073-6185-2017-44-3-103-111
Abstract
Objectives. The substantiation of the need and disclosure of the substantive and technological features of the design and development of an information system for the registration of numeric parts and units at a manufacturing enterprise.
Methods. Case-technology,object-oriented programming.
Results. The development mechanism of an information system for registering numeric parts and units at a manufacturing enterprise is described. The development process begins with an analysis of the subject area, wherein the requirements for the information system are defined. Two business processes related to the activity of the production preparation engineer are identified and the entities and types of these attributes are indicated. Using the case-tool DBdesigner 4, a data scheme is constructed and code is generated for scripts used to create a database in the SQL language. The database is implemented on MySQL. The web-interface of the information system is designed: website scheme, action sequence diagram, website logical structure and layout. The resulting data scheme is implemented within MySQL data base management system (DBMS) and a web-based system interface developed using object-oriented programming using Notepad ++ text editor. The web-interface allows a multi-user working mode to be provided with the information system. The separation of basic and summary data among different tabs is performed in order to simplify the work of personnel and minimise the human factor associated with the processing of disparate data. The requirements to be met by the developed information system are defined.All software used in the development process is free.
Conclusion. The selection of software tools for the development of a system for accounting of numeric parts and units at a manufacturing enterprise is implemented, allowing the conceptual, logical and physical design of a database – as well as its web interface – to be developed. All stages for creating an information system were realised.
About the Authors
E. S. Vasev
Nizhny Tagil State Social Pedagogical Institute
(Affiliated Branch of Russian State Vocational Pedagogical University)
Russian Federation
Russian Federation
57 Krasnogvardeyskaya Str., Nizhny Tagil 622031, Russia
Cand. Sci. (Pedagogical), Assoc.Prof., Department of Information Technologies
S. V. Kashin
JSC «Scientific and Production Corporation «Uralvagonzavod»
Russian Federation
Russian Federation
28 East highway, Nizhny Tagil 622007, Russia
Technological Engineer, Scientific and Production Corporation «Uralvagonzavod», the Office for Support of Products Life Cycle
References
1. Bourgeois D.T. Information Systems for Business and Beyond. 2014. 167 p.
2. Noran O.S. Businessmodelling: UML vs IDEF [Electronic resourse] URL:
3. http://www.academia.edu/22201964/UML_vs._IDEF_An_OntologyOriented_Comparative_Study_in_View_of_Business_Modelling (Access date: 15.10.2017).
4. Veytsman V.M. Proektirovanie informatsionnykh sistem. Yaroslavl': Obrazovatel'naya organizatsiya vysshego obrazovaniya «Mezhdunarodnaya akademiya biznesa i novykh tekhnologiy (MUBiNT)»; 2017. 274 s. [Veytsman V.M. Designing of information systems. Yaroslavl: Educational Organization of Higher Education ―International Academy of Business and New Technologies (MUBiNT)‖; 2017. 274 p. (In Russ.)]
5. Cheremnykh S.V., Semenov I.O., Ruchkin V.S. Modelirovanie i analizsistem. IDEF-tekhnologii: praktikum. M.: Finansy i statistika; 2006. 192 s. [Cheremnykh S.V., Semenov I.O., Ruchkin V.S. Modeling and analysis of systems. IDEF-technology: workshop. M.: Finansy i statistika; 2006. 192 p. (In Russ.)]
6. Statistika biznes-protsessov kompanii City consulting group [Elektronnyy resurs] URL: http://www.citycg.ru/services/business-process/metody-opisanija-processov (Data obrashcheniya: 15.10.2017). [Statistics of the business processes of City consulting group [Electronic resourse] URL: http://www.citycg.ru/services/business-process/metody-opisanija-processov (Access date: 15.10.2017). (In Russ.)]
7. Frolova T.P. Proektirovanieekonomicheskikhinformatsionnykhsistem. M.: Prioritet; 2009. 310 s. [Frolova T.P. Designing of economic information systems. M.: Prioritet; 2009. 310 p. (In Russ.)]
8. Zubrilina T.V., Yur'ev V.N. Bazy dannykh. Proektirovanie relyatsionnykh baz i khranilishch dannykh s ispol'zovaniem CASE-tekhnologiy: Ucheb.posobie. SPb.: Izd-vo Politekhnicheskogo universiteta; 2007. 44 s. [Zubrilina T.V., Yur'ev V.N. Database. Designing relation databases and data repository using CASEtechnologies: A Tutorial. SPb.: Publishing house of the Polytechnic University; 2007. 44 p. (In Russ.)]
9. Golitsina O.L., Maksimov N.V. Bazy dannykh. M.: FORUM: INFRA-M; 2008. 400 s. [Golitsina O.L., MaksimovN. V. Databases. M.: FORUM: INFRA-M; 2008. 400 p. (In Russ.)]
10. Gvozdeva T. Proektirovanie informatsionnykh sistem. M.: Feniks; 2009. 150 s. [Gvozdeva T. Designing information systems. M.: Feniks; 2009. 150 p. (In Russ.)]
11. Proektirovanie baz dannykh. [Elektronnyy resurs]. URL: http://dic.academic.ru/dic.nsf/ruwiki/1397350 (Data obrashcheniya: 15.10.2017) [Proektirovanie baz dannykh. [Electronic resourse]. URL: http://dic.academic.ru/dic.nsf/ruwiki/1397350 (access date: 15.10.2017) (In Russ.)]
12. DbDesigner.netTermsofService [Electronic resourse]URL: https://dbdesigner.net/terms-of-service (access date:15.10.2017).
13. Martishin S.A., Simonov V.L., Khrapchenko M.V. Proektirovanie i realizatsiya baz dannykh v SUBD MySQL s ispol'zovaniem MySQL Workbench. M.: Forum; 2012. 160 s. [Martishin S.A., Simonov V.L., Khrapchenko M.V. Designing and implementing databases in the MySQL database using MySQL Workbench. M.: Forum; 2012. 160 p. (In Russ.)]
14. Tsveloy V.A. Razrabotka baz dannykh v srede MySQL. Omsk: ―Omskiy ekonomicheskiy institut‖; 2012. 132 s. [Tsveloy V.A. Development of databases in the MySQL environment. Omsk: Omsk Economic Institute; 2012. 132 p. (In Russ.)]
15. Oracle. LegalNotices [Electronic resourse].URL:https://www.oracle.com/legal/terms.html (access date:15.10.2017).
16. DuBoisP. MySQL. Addison-Wesley Professional; 2008. 1326 p.
17. Statisticheskie dannye ispol'zovaniya relyatsionnykh sistem [Elektronnyyresurs] URL: http://tagline.ru/databasemanagement-systems-rating (Dataobrashcheniya: 15.10.2017). [16. Statistical data on the use of relational systems [Electronic resourse] URL: http://tagline.ru/database-management-systems-rating (access date: 15.10.2017). (In Russ.)]
18. Notepad++ Home. [Electronic resourse]. URL: https://notepad-plus-plus.org (access date: 15.10.2017).
19. Prokhorenok N., Dronov V. HTML, javascript, PHPиMySQL. Dzhentl'menskiy naborWeb-mastera. SPb.: BHVPeterburg; 2015. 766 s. [Prokhorenok N., Dronov V. HTML, javascript, PHPиMySQL. Gentlemen's set of a Webmaster. SPb.: BHV-Peterburg; 2015. 766 p. (In Russ.)]
20. Buch G. UML: Rukovodstvo pol'zovatelya. M.: DMK; 2008. 356 s. [Buch G. UML: User's Guide. M.: DMK; 2008. 356 p. (In Russ.)]
21. Bayron A., Berri E., Khog N., Iton Dzh., Uoker Dzh., Robbins Dzh. Drupal: Sozdanie i upravlenie saytom. SPb.: Simvol-Plyus; 2010. 576 s. [BayronA., BerriE., KhogN., ItonDzh., UokerDzh., RobbinsDzh. Drupal: Creation and management of the site. St. Petersburg: Simvol-Plyus; 2010. 576 p. (In Russ.)]
Review
For citations:
Vasev E.S., Kashin S.V. AUTOMATION OF ACCOUNTING THE NUMERIC PARTS AND UNITS AT MANUFACTURING ENTERPRISES. Herald of Dagestan State Technical University. Technical Sciences. 2017;44(3):103-111. (In Russ.) https://doi.org/10.21822/2073-6185-2017-44-3-103-111
Views:
900
Email this article 
