blackmetИзвестия высших учебных заведений. Черная МеталлургияIzvestiya. Ferrous Metallurgy0368-07972410-2091National University of Science and Technology "MISIS"10.17073/0368-0797-2017-7-573-579blackmet-1131Research ArticleИНФОРМАЦИОННЫЕ ТЕХНОЛОГИИ И АВТОМАТИЗАЦИЯ В ЧЕРНОЙ МЕТАЛЛУРГИИINFORMATION TECHNOLOGIES AND AUTOMATIC CONTROL IN FERROUS METALLURGYВЕБ-ТЕХНОЛОГИИ ПОСТРОЕНИЯ АВТОМАТИЗИРОВАННЫХ ИНФОРМАЦИОННО-МОДЕЛИРУЮЩИХ СИСТЕМ ТЕХНОЛОГИЧЕСКИХ ПРОЦЕССОВ В МЕТАЛЛУРГИИWEB-TECHNOLOGIES FOR CONSTRUCTION OF AUTOMATED INFORMATION-MODELING SYSTEMS OF TECHNOLOGICAL PROCESSES IN METALLURGYГуринИ. А.GurinI. A.

аспирант кафедры «Теплофизика и информатика в металлургии»

ivan.gurin@urfu.ruЛавровВ. В.LavrovV. V.

д.т.н., профессор кафедры «Теплофизика и информатика в металлургии»

v.v.lavrov@urfu.ruСпиринН. А.SpirinN. A.

д.т.н., профессор кафедры «Теплофизика и информатика в металлургии»

n.a.spirin@urfu.ruНикитинА. Г.NikitinA. G.

д.т.н., доцент, директор института машиностроения и транспорта, заведующий кафедрой механики и машиностроения

dir.imit@mail.ruУральский федеральный университет имени первого Президента России Б.Н. ЕльцинаРоссияUral Federal University named after the first President of Russia B.N. YeltsinRussian FederationСибирский государственный индустриальный университетРоссияSiberian State Industrial UniversityRussian Federation201719082017607573579Copyright © Гурин И.А., Лавров В.В., Спирин Н.А., Никитин А.Г., 20172017Гурин И.А., Лавров В.В., Спирин Н.А., Никитин А.Г.Gurin I.A., Lavrov V.V., Spirin N.A., Nikitin A.G.Данная работа распространяется под лицензией Creative Commons Attribution 4.0.This work is licensed under a Creative Commons Attribution 4.0 License.https://fermet.misis.ru/jour/article/view/1131

Рассмотрены особенности программного обеспечения (ПО) информационных систем (ИС) для работы инженерно-технологического персонала на металлургических предприятиях. ПО включает автоматизированные рабочие места, системы поддержки принятия решений, информационно-моделирующие системы, экспертные системы и др. Они представляют собой оконные (десктопные) приложения, написанные на высокоуровневых языках программирования (Visual C#, Visual Basic и др.). Обработка технологической информации, поступающей с сервера управления базами данных (СУБД) предприятия, включает в себя необходимость решения комплекса задач математического программирования, систем дифференциальных уравнений, задач математической физики и др. Такие задачи невозможно решить с помощью стандартного набора математических средств языков программирования общего назначения, поэтому разработка ин- формационно-моделирующих систем осуществляется при взаимодействии с внешним ПО, например Microsoft Excel, MATLAB. В основе взаимодействия с Microsoft Excel лежит технология COM Interop, предполагающая установку ПО Microsoft Office на каждый клиентский компьютер. Для взаимодействия с MATLAB требуется предварительная сборка библиотеки в среде MATLAB Compiler и ее подключение к программе. Выполнение на клиентском компьютере достигается установкой свободно распространяемого пакета MATLAB Runtime. Однако требования по функциональности, доступности и кроссплатформенной переносимости, предъявляемые к современным информационным системам предприятия, не могут быть выполнены в оконных приложениях, использующих Windows Forms. Этим обусловлен поиск новых технологий и средств создания информационных систем. Наиболее рациональной является технология построения веб-приложений на базе фреймворка ASP.NET MVC, позволяющая без модификации перенести математические библиотеки, модули взаимодействия с Microsoft Excel, MATLAB из Windows Forms. Представлена структура веб-приложения, используемая при разработке ПО, отвечающего современным требованиям к работе информационных систем, что предполагает наличие на веб-странице следующих функциональных областей: логотип и заголовок текущей страницы, меню состояния сеанса, функциональное меню, групповые операции, уведомления и рабочее пространство. 

The features of software of information systems for the work of engineering and technological staff at metallurgical enterprises are considered. The software includes automated workstations, decision support systems, information modeling systems, expertsystems, etc. It is desktop applications written in high-level programming languages (Visual  C#, Visual Basic, etc.). Processing of technological information coming from the enterprise database management server (DBMS) includes the need to solve  Runtime package. However, the functionality, availability, and crossplatform portability requirements for modern enterprise information systems cannot be met in desktop applications that use Windows Forms. This is due to the search for a new technology and means of creating information systems. The most rational is the technology for building web applications based on theASP.NET MVC framework, which allows to transfer mathematical libraries, interaction modules with Microsoft Excel, MATLAB from Windows Forms without modification. The concept of the structure of a web application used in the development of software that meets modern requirements for the operation of information systems is presented. This concept suggests the availability of the following functional areas on the web page: logo and title of the current page, session status menu, functional menu, group operations, notifications and tworkspace.a set of mathematical programming problems, systems of differential equations, problems of mathematical physics, etc. Such tasks cannot be solved with the help of a standard set of mathematical tools for general programming languages. So the development of information modeling systems is carried out by interacting with external software  – Microsoft Excel and MATLAB. The interaction with Microsoft Excel is based on COM Interop technology, which assumes the installation of Microsoft Office software on each client computer. To interact with MATLAB, you must pre-assemble the library in the MATLAB Compiler environment and connect it to the program. The execution on the client computer is achieved by installing the freely distributed MATLAB

информационная системапрограммное обеспечениеархитектуравеб-программированиематематическая библиотекадизайнWindows FormsASP.NET MVCMATLAB Runtimeinformation systemsoftwarearchitectureweb programmingmath librarydesignWindows FormsASP.NET MVCMATLAB RuntimeReferencesМатематическое моделирование металлургических процессов в АСУ ТП / Н.А. Спирин, В.В. Лавров, В.Ю. Рыболовлев и др.; под ред. Н.А. Спирина. – Екатеринбург: изд. УрФУ, 2014. – 558 с.Spirin N.A., Lavrov V.V., Rybolovlev V.Yu. etc. Matematicheskoe modelirovanie metallurgicheskikh protsessov v ASU TP [Mathe¬matical modeling of metallurgical processes in automated process control system]. Spirin N.A. ed. Ekaterinburg: UrFU, 2014, 558 p. (In Russ.).Spirin N.A., Gileva L.Y., Lavrov V.V. Information modeling system for blast furnace control. IOP Conference Series: Materials Science and Engineering [Proc. 19th International Scientific Conference on Metallurgy: Technologies, Innovation, Quality, Metallurgy 2015]. Novokuznetsk, 2016, Vol. 150, I. l. DOI: 10.1088/1757- 899X/150/1/012011.Spirin N.A., Gileva L.Y., Lavrov V.V. Information modeling system for blast furnace control. In: IOP Conference Series: Materials Science and Engineering. Proc. 19th International Scientific Conference on Metallurgy: Technologies, Innovation, Quality, Metallurgy 2015. Novokuznetsk, 2016, vol. 150, issue l.Spirin N.A., Lavrov V.V., Kosachenko I.E., Onorin O.P., Istomin A.S., Burykin A.A., Shchipanov K.A. Software for the raw-materials management system in blast-furnace smelting // Metallurgist. 2015. Vol. 59. I. 1. P. 104 – 112. DOI: 10.1007/s11015- 015-0068-7.Spirin N.A., Lavrov V.V., Kosachenko I.E., Onorin O.P., Istomin  A.S., Burykin A.A., Shchipanov K.A. Software for the raw-materials management system in blast-furnace smelting. Metallurgist. 2015, vol. 59, Issue 1, pp. 104–112.Lavrov V.V., Spirin N.A., Burykin A.A., Shchipanov K.A., Rybolovlev V.Y. Automatic control software for the blast-furnace shop // Steel in Translation. 2015. Vol. 45. I. 9. P. 669 – 673. DOI: 10.3103/ S0967091215090090.Lavrov V.V., Spirin N.A., Burykin A.A., Shchipanov K.A., Rybolovlev V.Y. Automatic control software for the blast-furnace shop. Steel in Translation, 2015, vol. 45, Issue 9, pp. 669–673.LavrovV.V., Spirin, N.A.Automated information systemfor analysis and prediction of production situations in blast furnace plant. IOP Conference Series: Materials Science and Engineering [Proc. 19th International Scientific Conference on Metallurgy: Technologies, Innovation, Quality, Metallurgy 2015]. Novokuznetsk. 2016. Vol. 150. I. l. DOI: 10.1088/1757-899X/150/1/012010.Lavrov V.V., Spirin, N.A. Automated information system for analysis and prediction of production situations in blast furnace plant. In: IOP Conference Series: Materials Science and Engineering. Proc. 19th International Scientific Conference on Metallurgy: Technologies, Innovation, Quality, Metallurgy 2015. Novokuznetsk, 2016, vol. 150, Issue. l.Кетков Ю.Л. MATLAB 7: программирование, численные методы. – СПб.: БХВ-Петербург, 2005. – 752 с.Ketkov Yu.L. MATLAB 7: programmirovanie, chislennye metody [MATLAB 7: programming, numerical methods]. St. Petersburg: BKhV-Peterburg, 2005, 752 p. (In Russ.).Vyatkin V. Software engineering in industrial automation: state-ofthe-art review // IEEE Transactions on Industrial Informatics. 2013. Vol. 9. № 3. P. 1234 – 1249.Vyatkin V. Software engineering in industrial automation: state-ofthe-art review. IEEE Transactions on Industrial Informatics. 2013, vol. 9, no. 3, pp. 1234–1249.Макдональд М. WPF: Windows Presentation Foundation в .NET 4.0 с примерами на C# 2010 для профессионалов. – М.: Вильямс, 2011. – 1024 с.Makdonal’d M. WPF: Windows Presentation Foundation v .NET 4.0 s primerami na C# 2010 dlya professionalov [WPF: Windows Presentation Foundation in .NET 4.0 with examples on C # 2010 for professionals]. Moscow: Vil’yams, 2011, 1024 p. (In Russ.).Dimitrov B.H., Nenov H.B., Marinov A.S. Comparative analysis between methodologies and their software realizations applied to modeling and simulation of industrial thermal processes [Proc. 36th International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2013]. Opatija; Croatia; 20-24 May 2013. Article number 6596383. P. 891 – 895.MacDonald Matthew. Pro WPF in C# 2010: Windows Presentation Foundation with .NET 4.0. Apress, 2010, 1181 p. (Russ.ed.: MacDonald M. WPF: Windows Presentation Foundation v .NET 4.0 s primerami na C# 2010 dlya professionalov. Moscow: Vil’yams, 2011, 1024 p.).Amalfitano D., FasolinoA.R., Maggio V., Tramontana P., Di Mare G., Ferrara F., Scala S. Migrating legacy spreadsheets-based systems to Web MVC architecture: An industrial case study. [Proc. Software Evolution Week - IEEE Conference on Software Maintenance, Reengineering, and Reverse Engineering 2014, CSMR-WCRE 2014]. Antwerp, Belgium. 3-6 February 2014. Article number 6747201. Р. 387 – 390. DOI: 10.1109/CSMR-WCRE.2014.6747201.Dimitrov B.H., Nenov H.B., Marinov A.S. Comparative analysis between methodologies and their software realizations applied to modeling and simulation of industrial thermal processes. In: Proc. 36th International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2013, Opatija; Croatia; 20-24 May 2013. Article number 6596383, pp.  891–895.Zhang B., Bao L., Zhou R., Hu S., Chen P. A black-box strategy to migrate GUI-based legacy systems to web services. SOSE 2008 [Proc. of the 4th IEEE International Symposium on Service-Oriented System Engineering]. Jhongli, Taiwan. 18-19 December 2008. Article number 4730458. Р. 25 – 31. DOI: 10.1109/SOSE.2008.8.Amalfitano D., Fasolino A.R., Maggio V., Tramontana P., Di Mare  G., Ferrara F., Scala S. Migrating legacy spreadsheets-based systems to Web MVC architecture: An industrial case study. In: Proc. Software Evolution Week – IEEE Conference on Software Maintenance, Reengineering, and Reverse Engineering 2014, CSMR-WCRE 2014. Antwerp, Belgium. 3-6 February 2014. Article number 6747201, pp. 387–390.Canfora G. Software evolution in the era of software services. [Proc. 7th International Workshop on Principles of Software Evolution, IWPSE 2004]. Kyoto, Japan. 6-7 September 2004. Р. 9 – 18.Zhang B., Bao L., Zhou R., Hu S., Chen P. A black-box strategy to migrate GUI-based legacy systems to web services. SOSE 2008. In: Proc. of the 4th IEEE International Symposium on Service-Oriented System Engineering, Jhongli, Taiwan. 18-19 December 2008. Article number 4730458, pp. 25–31.Zdun U. Reengineering to the Web: A reference architecture [Proc. of the European Conference on Software Maintenance and Reengineering, CSMR 2002]. Budapest, Hungary. 11-13 March 2002. Article number 995801. P. 164 – 173. DOI: 10.1109/ CSMR.2002.995801.Canfora G. Software evolution in the era of software services. In: Proc. 7th International Workshop on Principles of Software Evolution, IWPSE 2004, Kyoto, Japan. 6-7 September, pp. 9–18.Tilley S., Gerdes J., Hamilton T., Huang S., Müller H., Wong K. Adoption challenges in migrating to web services. [Proc. 4th International Workshop on Web Site Evolution, WSE 2002]. Montreal, Canada. 2 October 2002. Article number 1134086. P. 21 – 29. DOI: 10.1109/WSE.2002.1134086.Zdun U. Reengineering to the Web: A reference architecture. In: Proc. of the European Conference on Software Maintenance and Reengineering, CSMR 2002, Budapest, Hungary, 11-13 March 2002. Article number 995801, pp. 164–173.Sreedevi E., Prasanth Y. Critical review on web services and legacy systems – And its migration // International Journal of Applied Engineering Research. 2015. Vol. 10. I. 7. Р. 16321 – 16329.Tilley S., Gerdes J., Hamilton T., Huang S., Müller H., Wong K. Adoption challenges in migrating to web services. In: Proc. 4th International Workshop on Web Site Evolution, WSE 2002, Montreal, Canada, 2 October 2002. Article number 1134086, pp. 21–29.Kastner T. Concept to migrate an access based environmental information system into a Web-based front-end solution for the environmental management of a waste disposal company [Proc. 3rd International ICSC Symposium on Information Technologies in Environmental Engineering, ITEE 2007]. Oldenburg, Germany. 29-30 March, 2007. P. 559 – 566.Sreedevi E., Prasanth Y. Critical review on web services and legacy systems - And its migration. International Journal of Applied Engineering Research. 2015, vol. 10, Issue 7, pp. 16321–16329.Khalaf R., Keller A., Leymann F. Business processes for Web Services: Principles and applications // IBM Systems Journal, 2006. Vol.45. I. 2. P. 425 – 446. DOI: 10.1147/sj.452.0425.Kastner T. Concept to migrate an access based environmental information system into a Web-based front-end solution for the environmental management of a waste disposal company. In: Proc. 3rd International ICSC Symposium on Information Technologies in Environmental Engineering, ITEE 2007, Oldenburg, Germany, 29- 30 March, 2007, pp. 559–566.Patel K., Ragha L. Survey andAnalysis on Migration of Legacy System to Service Oriented Architecture // IOSR Journal of Computer Engineering, 2013. Vol. 9. I. 2. P. 32 – 35.Khalaf R., Keller A., Leymann F. Business processes for Web Services: Principles and applications. IBM Systems Journal. 2006, vol. 45, Issue 2, pp. 425–446.Stroulia E., El-Ramly M., Sorenson P. From legacy to web through interaction modeling [Proc. IEEE International Conference on Software Maintenance 2002]. Montreal, Canada. 3-6 October, 2002. P. 320 – 329.Patel K., Ragha L. Survey and Analysis on Migration of Legacy System to Service Oriented Architecture. IOSR Journal of Computer Engineering. 2013, vol 9, Issue 2, pp. 32–35. 20. Stroulia E., El-Ramly M., Sorenson P. From legacy to web through interaction modeling. In: Proc. IEEE International Conference on Software Maintenance 2002, Montreal, Canada, 3-6 October, 2002, pp. 320–329.Mijan J.L., Garrigos I., Firmenich S. Supporting personalization in legacy web sites through client-side adaptation. [Proc. 16th InternationalConference onWebEngineering,ICWE2016].Lugano, Switzerland. 6-9 June, 2016. P. 588 – 592. DOI: 10.1007/978-3-319- 38791-8_54.Mijan J.L., Garrigos I., Firmenich S. Supporting personalization in legacy web sites through client-side adaptation. In: Proc. 16th International Conference on Web Engineering, ICWE 2016, Lugano, Switzerland, 6-9 June, 2016, pp. 588–592.MaoC.-Y., LuY.-S.Amethod formeasuring the structure complexity of Web application // Wuhan University Journal of Natural Sciences, 2006. Vol. 11. I. 1. P. 143 – 150. DOI: 10.1007/BF02831720.Mao C.-Y., Lu Y.-S. A method for measuring the structure complexity of Web application. Wuhan University Journal of Natural Sciences. 2006, vol. 11, Issue 1, pp. 143–150.Rossi G., Schwabe D. Object-oriented design structures in Web application models // Annals of Software Engineering, 2002. Vol. 13. I. 1-4. P. 97 – 110. DOI: 10.1023/A:1016593309733.Rossi G., Schwabe D. Object-oriented design structures in Web application models. Annals of Software Engineering. 2002, vol. 13, Issue 1-4, pp. 97–110.

The authors declare that there are no conflicts of interest present.