Conceptual design of a coal database based on common genetic features
L.D. Pavlova1, A.V. Korneva1, D.Yu. Khudonogov2, Yu.F. Patrakov2, S.M. Nikitenko2
1 Siberian State Industrial University, Novokuznetsk, Russian Federation
2 Federal Research Center of Coal and Coal-Chemistry of Siberian Branch of the Russian Academy of Sciences, Kemerovo, Russian Federation
Russian Mining Industry №S2 / 2023 р. 108-113
Abstract: The operational efficiency of coal-fired thermal power plants designed to utilize designed / standardized fuel and coking plants largely depends on the quality characteristics of the supplied coal products, the main indicators of which are: calorific value, ash content, moisture content, volatile matter yield, sulfur and nitrogen content, particle size distribution. Coal of various grades is mined in Russia, but not more than one third can be classified as the designed fuel. Accordingly, there arises a need to make fuel mixtures with specified parameters. The article justifies the topicality to create a database of qualitative characteristics and indicators of various coal grades. Using the results of analytical review of normative documentation, coal classification options have been developed based on the list of quality indicators specified in the state standard for identification of coals and coal products. Logical structure of the data, entity, relationships between them, attributes and constraints have been defined at the design stage of the database. The type and content of the conceptual model are presented as an ER-model visualized in the form of a graphical notation of the entity-vs-relationship diagram. Based on the analysis performed, ways of transaction and input data sources for the supplied coal characteristics and processing technologies have been defined. Examples of data structure in the models of individual entities and methods to determine their parameters have been provided.
Keywords: coal database, coal grade, coal quality, coal classification, coal technological properties, industrial databases, systematic data analysis, classification graph
Acknowledgments: The research was supported by a grant from the Ministry of Education and Science of the Russian Federation (Agreement No.075-15-2022-1197 as of 28.09.2022).
For citation: Pavlova L.D., Korneva A.V., Khudonogov D.Yu., Patrakov Yu.F., Nikitenko S.M. Conceptual design of a coal database based on common genetic features. Russian Mining Industry. 2023;(S2):108–113. https://doi.org/10.30686/1609-9192-2023-S2-108-113
Article info
Received: 25.06.2023
Revised: 18.07.2023
Accepted: 19.07.2023
Information about the authors
Larisa D. Pavlova – Dr. Sci. (Eng.), Professor, Head of the Applied Mathematics and Informatics Department, Siberian State Industrial University, Novokuznetsk, Russian Federation
Anna V. Korneva – Cand. Sci. (Eng.), Associate Professor, Applied Mathematics and Informatics Department, Siberian State Industrial University, Novokuznetsk, Russian Federation
Danila Yu. Khudonogov – Lead Engineer, Laboratory of Advanced Management Methods for Mining Engineering Systems, Federal Research Center of Coal and Coal-Chemistry of Siberian Branch of the Russian Academy of Sciences, Kemerovo, Russian Federation; e-mail.: This email address is being protected from spambots. You need JavaScript enabled to view it.
Yury F. Patrakov – Dr. Sci. (Chem.), Professor, Head of the Laboratory for Scientific Basis of Coal Preparation Technologies, Federal Research Center of Coal and Coal-Chemistry of Siberian Branch of the Russian Academy of Sciences, Kemerovo, Russian Federation
Sergey M. Nikitenko – Dr. Sci. (Econ.), Associate Professor, Head of the Coal Economics Laboratory, Federal Research Center for Coal and Coal Chemistry of the Siberian Branch of the Russian Academy of Sciences, Kemerovo, Russian Federation; e-mail: This email address is being protected from spambots. You need JavaScript enabled to view it.
References
1. Kornienko I.L. Use of the unique coal database in the training of neural network information system to define the composition of the coal concentrate. In: Information and Telecommunication Systems and Technologies: Proceedings of the All-Russian Scientific and Practical Conference, Kemerovo, October 16–17, 2014. Kemerovo: T. F. Gorbachev Kuzbass State Technical University; 2014, p. 87. (In Russ.)
2. Kuznetsov P.Yu., Grib N.N., Каchaev А.V. The analysis of coal quality data according to the results of detaled geological prospecting for creating the complete data base. International Research Journal. 2016;(6):137–140. (In Russ.) https://doi.org/10.18454/IRJ.2016.48.081
3. Potapov V.P., Udovitskii V.I., Nifantov B.F., Kandinskaya I.V. Creation of the automated database of valuable elements in marketable coals of companies in the Kuznetsk Basin. Vestnik Kuzbasskogo gosudarstvennogo tekhnicheskogo universiteta = Bulletin of the Kuzbass State Technical University. 2003;(2):38–41. (In Russ.) Available at: https://journals.kuzstu.ru/article/1841.pdf
4. Kumar Di., Kumar De. Sustainable Management of Coal Preparation. Woodhead Publishing; 2018. 454 p.
5. Yang L., Bai X., Hu Y., Wang Q., Deng J. Construction of Trace Element in Coal of China Database Management System: Based on WebGIS. Sains Malaysiana. 2017;46(11):2195–2204. https://doi.org/10.17576/jsm-2017-4611-21
6. Mao S. Development of coal geological information technologies in China. International Journal of Coal Science & Technology. 2020;7:320–328. https://doi.org/10.1007/s40789-020-00340-1
