MODERN METHODOLOGY AND COMPUTER TECHNOLOGIES FOR CREATING SOFTWARE OF MODEL SYSTEMS SUPPORTING DECISION-MAKING IN METALLURGY (on the example of blast-furnace production)

 Experience shows that the creation and successful introduction of  modern automated information systems into the practice of metallurgical enterprises largely depends on the technologies used to develop and  to select the tools for their software implementation. The article briefly  reflects the main technologies and software used to create software  for information modeling systems to solve technological problems in  metallurgy. The basis is the use of a flexible development methodology  – the Agile method, which focuses on the use of iterative develop ment, the dynamic formation of user requirements, and the provision  of their implementation as a result of constant interaction within working groups consisting of specialists of various profiles (users, analysts,  programmers, testers). Iteration is a relatively short development time  (usually a month), after which the users are provided with the next tested version of the software product with new functional properties. The  list of realized functional properties is priority for users and is formed  from the general list of requirements before the beginning of each  itera tion. During each iteration, the following processes are sequentially performed: checking the correctness of the calculation algorithm  (if necessary, entering new calculated indicators); functional modeling  of the system; improvement of the structure of the subsystem; conceptual modeling of the database, generation of the database model;  loading test data into the database; creation of functional diagrams of  mathematical library; implementation of client software subsystems; testing and debugging of software; development of reference documentation. Managing individual tasks and monitoring the progress of  their implementation in the course of collective software development  are carried out on the basis of the Atlassian JIRA system. Code storage  and versioning of software are performed in a remote repository on the  Atlasian Bitbucket platform. The use of modern technologies, tools  and techniques for developing software products makes it possible to  create functional, reliable, easy-to-use, followed, integrated systems  with minimal risks and at acceptable times. 

1. Vyatkin V . Software engineering in industrial automation: state-ofthe-art review. IEEE Transactions on Industrial Informatics. 2013,  vol. 9, no. 3, pp. 1234–1249.

2. 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. 36th International Convention on Information and Communication Technology, Electronics and Microelectronics, MIPRO 2013; Opatija; Croatia; 20­24, May 2013. Article no. 6596383, pp. 891–895. 

3. Odintsov I.O. Professional’noe programmirovanie. Sistemnyi podkhod [Professional programming. Systems approach]. St. Petersburg: BKhV-Peterburg, 2004, 624 p. (In Russ.).

4. McConnell S. Code complete. Microsoft Press, 2004, 960 p. (Russ. ed.: McConnell S. Sovershennyi kod. Master­klass. St. Petersburg:  Piter, 2007, 896 p.).

5. Cohn  M.  Succeeding with agile: Software Development Using Scrum. Addison-Wesley Professional, 2009. (Russ.ed.: Cohn M.  Scrum: gibkaya razrabotka PO.  Moscow:  ID  Vil’yams,  2011,  576  p.).

6. Meyer B. Agile! The Good, the Hype and the Ugly. Springer, 2014.  (Russ.ed.: Meyer B. Agile! Prekrasnyi, uzhasnyi, shumnyi. Moscow,  Tver: NAU “INTUIT” – ZAO NII TsPS, 2015, 248 p.).

7. Maklakov S.V . Modelirovanie biznes­protsessov s AllFusion Process Modeler (BPwin 4.1) [Modeling of business processes with  AllFusion Process Modeler (BPwin 4.1)]. Moscow: Dialog–MIFI,  2004, 220 p. (In Russ.).

8. Dubeikovskii V.I. Effektivnoe modelirovanie s CA ERwin Process Modeler (BPwin; AllFusion Process Modeler) [Effective modeling  with CA ERwin Process Modeler (BPwin; AllFusion Process Modeler)]. Moscow: Dialog–MIFI, 2009, 384 p. (In Russ.).

9. Maklakov S.V . Sozdanie informatsionnykh sistem s AlIFusion Mode ling Suite [Creation of information systems with AlIFusion Modeling Suite]. Moscow: DIALOG-MIFI, 2003, 432 p. (In Russ.).

10. Date C.J. An introduction to database systems. 8th Edition. Pearson,  2003. (Russ.ed.: Date C.J. Vvedenie v sistemy baz dannykh. Moscow: ID Vil’yams, 2006, 1328 p.).

11. Maklakov S.V., Tumanov V.E. Proektirovanie relyatsionnykh khranilishch dannykh [Designing Relational Data Warehousing]. Moscow: Dialog–MIFI, 2007, 336 p. (In Russ.).

12. Hamilton B. Ado. Net. Cookbook. Beijing: O’Reilly Media, 2003.  (Russ.ed.: Hamilton B. ADO.NET. Sbornik retseptov. St. Petersburg:  Piter, 2005, 576 p.).

13. Troelsen A. Pro C# 5.0 and the. NET 4.5 framework. Apress, 2012.  (Russ.ed.: Troelsen A. Yazyk programmirovaniya C# 5.0 i platforma .NET 4.5. Moscow: OOO ID Vil’yams, 2015, 1312 p.).

14. Flenov M.E. Bibliya C# [Bible С#]. St. Petersburg: BKhV-Peterburg, 2011, 560 p. (In Russ.).

15. Larson B. Delivering business intelligence with Microsoft® SQL Server™ 2005. Mcgraw-Hill, 2008. (Russ.ed.: Larson B. Razrabotka biznes­analitiki v Microsoft SQL Server 2005. St. Petersburg: Piter, 2008, 684 p.).

16. Larson B. Microsoft SQL Server™ 2005 Reporting Services. Essential Skills for Database Professionals. Arden Hills, MN. (Russ.ed.:  Larson B. Microsoft SQL Server 2005 Reporting Services. Traditsionnye i interaktivnye otchety. Sozdanie, redaktirovanie i upravlenie.  Moscow: NT Press, 2008, 608 p.).

17. Spirin N.A., Lavrov V.V., Rybolovlev V.Yu. etc. Model’nye sistemy podderzhki prinyatiya reshenii v ASU TP domennoi plavki metallurgii [Model decision support systems in the automated process  control system of blast furnace smelting in metallurgy]. Spirin N.A.  ed. Ekaterinburg: UrFU, 2011, 462 p. (In Russ.).

18. Onorin O.P., Spirin N.A., Terent’ev V.L. etc. Komp’yuternye metody modelirovaniya domennogo protsessa [Computer methods for modeling the domain process]. Spirin N.A. ed. Ekaterinburg: UGTU– UPI, 2005, 301 p. (In Russ.).

19. Spirin N.A., Lavrov V.V., Rybolovlev V.Yu. etc. Matematicheskoe modelirovanie metallurgicheskikh protsessov v ASU TP: uchebnoe posobie [Mathematical modeling of metallurgical processes in the  automated process control system: Manual]. Spirin N.A. ed. Ekaterinburg: UrFU, 2014, 558 p. (In Russ.).

20. Spirin N.A., Ipatov Yu.V., Lobanov V.I. etc. Informatsionnye sistemy v metallurgii: uchebnik dlya vuzov [Information systems in metallurgy]. Spirin N.A. ed. Ekaterinburg: UGTU–UPI, 2001, 617 p.  (In Russ.).

21. Spirin N.A., Lavrov V.V., Rybolovlev V.Y., Krasnobaev A.V., Pavlov A.V . Use of contemporary information technology for analyzing the blast furnace process. Metallurgist. 2016, vol. 60, no. 5-6.  pp.  471–477.