Abstract
The aim of the study is to increase the efficiency of the operation of the technological data warehouse in the multi-stage metallurgical production control system with a consistent linkage along hierarchical levels and integration into a single system for collecting and processing of information. In the course of the study, an analysis was made of the number of records in the Technological Data Store; analysis of the prerequisites for the transformation of the structure of the technological data warehouse for a large metallurgical enterprise with a production full cycle; a concept was developed to transform the structure of the technological data storage including the definition of the main entity: the basic unit of production, which follows the specified processing paths; the principle of splitting the basic unit of production into elements during the trajectory of processing through metallurgical conversions; the definition of the main trajectories of the promotion of the unit of production and its elements in the divisions of the enterprise (workshops); increasing the information flow in real time while promoting a unit of production and its elements along a selected trajectory. The study was conducted from 2017 to 2019 for the conditions of the PJSC “Magnitogorsk Metallurgical Plant” with the participation of Ausferr Research and Technological Center. In conducting the study, a conceptual modeling method was used to analyze material and information flows. The developed concept for the construction of a Process Data Storage Facility based on the Oracle DataBase 12c platform provides for the introduction of the main unit of production and its elements, which follow the specified processing paths and increase the information flow in real time. The new concept of building a technological data warehouse has improved the efficiency of access and extraction of the accumulated information for conducting analytical work with samples from large-scale arrays.
Keywords
Technological data warehouse, metallurgical enterprise, databases, database management systems, information systems, basic unit of production, elements of unit of production.
1. Starodubtsev M.V. Integration of workshop automated control systems with the corporate information system of OJSC MMK / Sb.tr. Vseross.nauch.-techn. “Conf. Sozdanie i vnedrenie korporativnykh informatsionnykh system (KIS) na promyshlennykh predpriyatiyakh Rossiyskoi federatsii” [Collection of scientific papers of the All-Russian scientific and technical conference. Creation and implementation of corporate information systems (CIS) at industrial enterprises of the Russian Federation]. Magnitogorsk: CPI LLC Prof-Print, 2005, pp. 405-411. (In Russian)
2. Vier I.V., Kaplan D.S., Kurban V.V., Arlazarov V.L., Berzigiyarov PK, Skvortsov N.V. The principle of implementation of the corporate management system of the MMC MMC / “Sb.tr. Vseross.nauch.-techn. Conf. Sozdanie i vnedrenie korporativnykh informatsionnykh system (KIS) na promyshlennykh predpriyatiyakh Rossiyskoi federatsii” [Collection of scientific papers of the All-Russian scientific and technical conference. Creation and implementation of corporate information systems (CIS) at industrial enterprises of the Russian Federation]. Magnitogorsk: CPI LLC Prof-Print, 2007. (In Russian)
3. Mironov V.V., Gusarenko A.S., Yusupova N.I. Situation-but-oriented databases as a virtual integration layer in WEB applications / Proceedings: Information Technologies for Intelligent Decision Making Support (ITIDS'2016), 2016, pp. 123-128.
4. Myalovsky V.A., Logunova O.S. Conceptual models of building an integration layer: a model of information flows and the implementation of feedback // Vestnik Cherepovetskogo gosudarstvennogo universiteta [Proceedings of Cherepovetsk State University]. 2019, no. 3, pp. 17-23. (In Russian)
5. Merv Adrian, Colin White. Beyond the Traditional Data Ware-house // 2010 TechTarget, BI Research, IT Market Strategy, pp. 4-10.
6. Payam Barnaghi, Amit Sheth, Cory Henson From Data to Actionable Knowledge: The Big Data Challenges // IEEE Intelligent Systems 2013.06 Nov.-Dec. 2013, vol. 28, pp. 6-11.
7. Xueyuan Su, Garret Swart Oracle in-database hadoop: when mapreduce meets RDBMS // SIGMOD '12 Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data, pp. 779-790.
8. Golov N.I., Kravchenko T.K. Designing a data warehouse for solving Big Data problems // Informatsionnye tekhnologii v proektirovanii i proizvodstve [Information technologies in design and production]. 2014, no. 1(153). pp. 56-61.
9. Ravi Murthy, Eric Sedlar. Flexible and efficient access control in oracle // SIGMOD '07 Progress of the 2007 ACM SIGMOD international conference on Management of data, pp. 973-980.
10. Sunil Chakkappen, Thierry Cruanes, Benoit Dageville, Linan Jiang, Uri Shaft, Hong Su, Mohamed Zait. Oracle 11g // SIGMOD '08 ProMedings of the 2008 ACM SIGMOD, pp. 1053-1064
11. Logunova O.S., Matsko I.I., Posokhov I.A. Sistema intellektualnoy podderzhki protsessov upravleniya proizvodstvom nepreryvnolitoy zagotovki [The system of intellectual support of management processes for the production of continuously cast billets]. Magnitogorsk: Publishing center of Nosov Magnitogorsk state tech. university, 2013. 175 p. (In Russian)
12. Logunova O.S., Matsko I.I., Posochov I.A. Integrated system of intelligent management support of multistage met-allurgical processes // Bulletin of Magnitogorsk State Technical University. G.I. Nosov, 2013, no 5(45), pp. 50-55.
13. Salvatore T. Marcha, Alan R. Hevner Integrated Decision Support Systems: A data warehousing perspective // Decision Support Systems, vol. 43, Issue 3, April 2007, pp. 1031-1043.
14. E. Ertugrul Karsak, C. Okan Özogul, Integrated decision-making approach for ERP system selection, Expert Systems with Applications, vol. 36, Issue 1, January 2009, pp. 660-667.
15. Abbas Asosheh, Soroosh Nalchigar, Mona Jamporazmey Information technology analysis and balanced scorecard approach // Ex-pert Systems with Applications, vol. 37, Issue 8, August 2010, pp. 5931-5938.
16. Velichko N.A., Mitreykin I.P. Big Data technology. Big Data Market Analysis // Sinergiya nauk [Synergy of Sciences]. 2018, no. 30, pp. 937-943. (In Russian)
17. Amir Gandomi, Murtaza Haider Beyond the hype: Big data concepts, methods, and analytics // International Journal of In-formation Management, vol. 35, Issue 2, April 2015, pp. 137-144.
18. Philipm C.L., Chun-Yang Zhang. Data-A-Big Data, Information Technologies, vol. 275, 10 August 2014, pp. 314-347.
19. Sharakhina, LV., Skvortsova, V., Using Big Data and Smart Data Technologies in Developing Effective Communication Strategies // Sotsialnye kommunikatsii: nauka, obrazovanie, professiya [Social Communications: Science, Education, Profession]. 2019, no. 1, pp. 266-272. (In Russia)
20. Ermolovich D.V. Information Overload: Big Data, Data Mining and Marketing Management // Big Data and Advanced Analytics. 2016, no. 2, pp. 245-250. (In Russian)
21. Shekhanova A.C., Polyakova A.G. Potential and features of using Big Data technology // Vestnik sovremennykh issledovaniy [Bulletin of modern research]. 2018, no. 2.1(17), pp. 99-101. (In Russian)
22. Gnevanov, M.V., Ivanov, N.A., Technologies of “Big Data” (Big Data) and Their Use in Urban Planning // Promyshlennoe i grazhdanskoe stroitelstvo [Industrial and Civil Construction]. 2018, no. 4, pp. 83-87. (In Russian)