Methods, apparatus, electronic devices, and storage media for generating standard data for coal blending and combustion.

Abstract

The present application discloses a method, device, electronic device and storage medium for generating standard data for coal blending and combustion. The method includes: collecting data sources to be standardized; generating a coal type standard data table based on the coal type data source; generating a coal grinding system standard data table based on the coal type data source and the coal type contained therein, with the coal type number corresponding to the coal type as an entry; generating a stack position standard data table based on the coal type data source and the coal type contained therein, with the coal type number corresponding to the coal type as an entry; storing the coal type standard data table, coal grinding system standard data table and stack position standard data table in a relational database. Realize real-time and rapid data acquisition during coal blending and combustion, and fully reflect the standard data of the real-time working conditions of equipment such as boilers and coal mills in the coal grinding system. Standardized data facilitates the unification of data formats and interface specifications, and helps to realize cross-platform data sharing and algorithm calling.

Description

Technical Field

[0001] The present application relates to the technical field of coal blending and combustion data processing in coal-fired power plants, and in particular to a method, device, electronic equipment and storage medium for generating standard data for coal blending and combustion. Background Art

[0002] In order to meet the requirements of safety, environmental protection and efficiency, coal-fired power plants often need to blend coal of different types and qualities. Coal attribute parameters such as calorific value, ash content, and sulfur content directly affect the combustion efficiency, safety risks, and pollutant emissions of the boiler. The existing coal blending process needs to consider the operating boundaries of the boiler, the inventory of coal types in the coal yard, and the working conditions of the raw coal bin and the pulverizer. These factors directly affect the rationality of the final blending plan and the actual implementation effect. The current data generation method is relatively scattered and lacks a unified standardized processing method, which easily leads to inaccurate and untimely data processing, and cannot meet the informationization requirements for the storage and transmission of standard data.

[0003] Therefore, in order to optimize the operating efficiency of coal-fired power plants, it is necessary to develop a systematic data generation method to guide operations under coal blending scenarios. Summary of the invention

[0004] The embodiments of the present application provide a method, device, electronic device and storage medium for generating standard data for coal blending and combustion, so as to solve the problems of existing coal blending and combustion data having chaotic format, poor real-time performance, low docking efficiency and inability to realize information system management data.

[0005] In a first aspect, an embodiment of the present application provides a method for generating standard data for coal blending and combustion, comprising:

[0006] Collecting data sources to be standardized, the data sources including: a coal type data source, a coal grinding system data source and a stack data source, wherein the coal grinding system data source and the stack data source include at least one type of coal in the coal type data source;

[0007] Generate a coal type standard data table according to the coal type data source, wherein the coal type standard data table includes a coal type number generated according to the coal type;

[0008] According to the coal grinding system data source and the coal types contained therein, a coal grinding system standard data table is generated with the coal type numbers corresponding to the coal types as entries;

[0009] According to the stack data source and the coal types contained therein, a stack standard data table is generated with the coal type numbers corresponding to the coal types as entries;

[0010] The coal type standard data table, the coal grinding system standard data table and the stack position standard data table are stored in a relational database.

[0011] In a possible embodiment, the method further includes:

[0012] Inputting the customized boundary condition data into the coal grinding system standard data table;

[0013] Generate a constraint condition table according to the stack position standard data table and the coal grinding system standard data table containing the boundary condition data; and

[0014] The data source is used to generate the coal type standard data table, the coal grinding system standard data table, the stack position standard data table and the constraint condition table respectively through a customized computer language running script.

[0015] In a possible embodiment, the method for collecting data sources to be standardized includes:

[0016] Collect coal type attribute information and store it as the coal type data source, collect coal grinding system attribute information and store it as the coal grinding system data source, and collect inventory information and store it as the stack data source by means of historical records or automatic triggering; and / or

[0017] The collected historical records or the fuel blending data automatically triggered are classified and processed, and the classification basis is: storing the coal type attribute parameters as the coal type data source, storing the specific information and working attribute parameters of the coal grinding system as the coal grinding system data source, and storing the real-time inventory data in the coal yard as the stack data source.

[0018] In a possible embodiment, the step of generating a coal type standard data table according to the coal type data source includes:

[0019] The coal attribute parameters belonging to the same coal type in the coal data source are converted into units and then merged into one piece of coal attribute data, wherein the coal type includes pure coal and mixed coal, wherein the coal attribute data of the mixed coal is obtained by calculating the weighted average of the pure coal attribute data constituting the mixed coal according to the proportion;

[0020] Each piece of coal type attribute data is numbered to generate a coal type number.

[0021] In a possible embodiment, the step of generating a coal grinding system standard data table with the coal type number as an entry according to the coal grinding system data source and the coal type types contained therein comprises:

[0022] Convert the basic information and attribute parameters of each coal grinding system in the coal grinding system data source into units;

[0023] According to the type of coal loaded in the coal grinding system, at least one piece of coal grinding system attribute data is generated with the coal type number as an item, and the coal grinding system attribute data is numbered to generate a coal grinding system number;

[0024] The coal grinding system standard data table is generated based on at least one piece of the coal grinding system property data.

[0025] In a possible embodiment, the step of generating a stack standard data table according to the stack data source and the coal type contained therein, with the coal type number corresponding to the coal type as an entry, includes:

[0026] Merging the coal type number of the fuel stored in the stack data source and the inventory information of the corresponding stack;

[0027] According to the type of coal contained in the fuel stored in each stack in the stack data source, at least one stack inventory data is generated with the coal type number corresponding to the coal type as an entry, and the stack inventory data is numbered to generate a stack number;

[0028] The stack position standard data table is generated based on at least one piece of the stack position inventory data.

[0029] In a second aspect, an embodiment of the present application provides a standard data generation device for coal blending and combustion, comprising:

[0030] A data collection module, used for collecting data sources to be standardized, wherein the data sources include: a coal type data source, a coal grinding system data source and a stack data source, wherein the coal grinding system data source and the stack data source include at least one type of coal in the coal type data source;

[0031] A coal type standardization module, used to generate a coal type standard data table according to the coal type data source, wherein the coal type standard data table includes a coal type number generated according to the coal type;

[0032] A coal grinding system standardization module, used for generating a coal grinding system standard data table according to the coal grinding system data source and the coal types contained therein, with the coal type numbers corresponding to the coal types as entries;

[0033] A stack standardization module is used to generate a stack standard data table based on the stack data source and the coal types contained therein, with the coal type numbers corresponding to the coal types as entries;

[0034] The relational database is used to store standard data tables, wherein the standard data tables at least include the coal type standard data table, the coal grinding system standard data table and the stack position standard data table.

[0035] In a possible embodiment, the device further includes:

[0036] A constraint module is used to input customized boundary condition data into the coal grinding system standard data table, and generate a constraint condition table according to the stack position standard data table and the boundary condition data; and to generate the coal type standard data table, the coal grinding system standard data table, the stack position standard data table and the constraint condition table from the data source through a customized computer language running script.

[0037] In a third aspect, an embodiment of the present application provides an electronic device, comprising a processor and a memory, wherein the memory stores program code, and when the program code is executed by the processor, the processor executes any one of the methods of the first aspect above.

[0038] In a fourth aspect, the present application provides a computer-readable storage medium, which includes a program code. When the storage medium is run on an electronic device, the program code is used to enable the electronic device to execute any one of the methods of the first aspect above.

[0039] On the one hand, an embodiment of the present application provides a computer program product, which includes computer instructions, and the computer instructions are stored in a computer-readable storage medium; when a processor of an electronic device reads the computer instructions from the computer-readable storage medium, the processor executes the computer instructions, so that the electronic device executes any one of the methods of the first aspect above.

[0040] The beneficial effects of this application are as follows:

[0041] The embodiment of the present application provides a method, device, electronic device and storage medium for generating standard data for coal blending and combustion. The method for generating standard data for coal blending and combustion includes: collecting data sources to be standardized, the data sources include: coal type data source, coal grinding system data source and stack position data source, the coal grinding system data source and the stack position data source include at least one type of coal in the coal type data source; generating a coal type standard data table according to the coal type data source, the coal type standard data table includes coal type numbers generated according to coal type types; generating a coal grinding system standard data table according to the coal grinding system data source and the types of coal contained therein, with the coal type numbers corresponding to the coal type types as entries; generating a stack position standard data table according to the stack position data source and the types of coal contained therein, with the coal type numbers corresponding to the coal type types as entries; storing the coal type standard data table, the coal grinding system standard data table and the stack position standard data table in a relational database. In this way, data can be quickly and in real time obtained through the coal type standard data table during the coal blending and combustion process. The data in the coal type standard data table can be called in real time for dynamic operation, calculation, transmission and use because of the unified data specifications. Furthermore, standard data tables can be used to generate standard data that can fully reflect the real-time operating conditions of boilers, coal mills and other equipment in the coal grinding system. Standardized data facilitates the unification of data formats and interface specifications, and helps to realize cross-platform data sharing and algorithm calls.

[0042] Other features and advantages of the present application will be described in the following description, and partly become apparent from the description, or understood by practicing the present application. The purpose and other advantages of the present application can be realized and obtained by the structures specifically pointed out in the written description, claims, and drawings. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the related technologies, the drawings required for use in the embodiments or the related technical descriptions are briefly introduced below. Obviously, the drawings described below are only the embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on the provided drawings without paying any creative work.

[0044] Figure 1 This is a schematic diagram of an application scenario in an embodiment of the present application;

[0045] Figure 2 This is a flow chart of the implementation of the method for generating standard data for coal blending and combustion in the embodiment of the present application;

[0046] Figure 3 This is a schematic diagram of the structure of a standard data generation device for coal blending and combustion in an embodiment of the present application;

[0047] Figure 4 The figure is a schematic diagram of the composition structure of an electronic device in an embodiment of the present application. DETAILED DESCRIPTION

[0048] In order to make the purpose, technical scheme and advantages of the present application clearer, the technical scheme in the embodiment of the present application will be clearly and completely described below in conjunction with the drawings in the embodiment of the present application. Obviously, the described embodiment is only a part of the embodiment of the present application, rather than all the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of the present application. In the absence of conflict, the embodiments in the present application and the features in the embodiments can be arbitrarily combined with each other. In addition, although the logical order is shown in the flow chart, in some cases, the steps shown or described can be performed in an order different from that here.

[0049] The following is a brief introduction to the design concept of the embodiment of the present application:

[0050] The present application is applied to the coal blending and burning scenario of coal-fired power plants. In order to meet the safety, environmental protection and efficiency requirements of coal-fired power plants, it is often necessary to blend and burn different types and qualities of coal. The attribute parameters of coal types, such as the calorific value, ash content, sulfur content, moisture content, ash melting point and grindability coefficient of coal, directly affect the combustion efficiency, safety risks and pollutant emissions of the boiler. In the prior art, the coal blending and burning of coal-fired power plants are mostly based on experience and manual judgment, and some power plants use simple coal blending algorithms. In the daily operation of power plants, the instance basic information, real-time information and boundary information data in the coal blending and burning scenario mostly exist in offline paper documents and local electronic documents, where the local electronic documents also contain some descriptions of the logical relationship between the data. The transmission of real-time information in coal-fired power plants is mostly achieved through online shared documents, real-time communication software or tools, etc. The operating personnel of coal-fired power plants in the coal blending and burning scenario will use multiple documents and limited sensor parameters in the system as a reference to determine whether coal blending and recalculation are required. It can be seen that in the existing technology, the coal blending and combustion process mainly relies on static data, lacks a unified data generation standard and cannot be used across platforms, and is based on manual experience and judgment, resulting in low efficiency and high error rate.

[0051] In view of this, the embodiments of the present application provide a method, device, electronic device and storage medium for generating standard data for coal blending and combustion. The method for generating standard data for coal blending and combustion includes:

[0052] Collect data sources to be standardized, the data sources include: coal type data source, coal grinding system data source and stack position data source, the coal grinding system data source and the stack position data source include at least one type of coal from the coal type data source; generate a coal type standard data table according to the coal type data source, the coal type standard data table includes coal type numbers generated according to coal type types; generate a coal grinding system standard data table according to the coal grinding system data source and the types of coal types contained therein, with the coal type numbers corresponding to the coal type types as entries; generate a stack position standard data table according to the stack position data source and the types of coal types contained therein, with the coal type numbers corresponding to the coal type types as entries; store the coal type standard data table, the coal grinding system standard data table and the stack position standard data table in a relational database. In this way, data can be quickly and real-time acquired during the coal blending and combustion process by receiving standard data tables through coal type information. The data in the standard data tables of coal types have unified data specifications and can be called in real time for dynamic operation, calculation, transmission and use. Furthermore, standard data tables can be used to generate standard data that can fully reflect the real-time operating conditions of equipment such as boilers and coal mills in the coal grinding system. Standardized data facilitates the unification of data formats and interface specifications, and helps to realize cross-platform data sharing and algorithm calls.

[0053] The preferred embodiments of the present application are described below in conjunction with the drawings in the specification. It should be understood that the preferred embodiments described herein are only used to illustrate and explain the present application, and are not used to limit the present application. In addition, the embodiments and features in the embodiments of the present application may be combined with each other if there is no conflict.

[0054] like Figure 1 , which is a schematic diagram of an application scenario provided by an embodiment of the present application. In the schematic diagram of the application scenario, a terminal device 101 and a server 102 are included. The terminal device 101 and the server 102 communicate with each other through a communication network.

[0055] The terminal device 101 is an electronic device used by the target object, which may be a personal computer, mobile phone, tablet computer, notebook, e-book reader, vehicle-mounted terminal, etc. In addition, a client for collecting data sources and a client for viewing and managing standard data may be installed on the terminal device 101, and the client may be software (for example, APP, browser, etc.), or a web page, mini-program, etc. The target object may use the above-mentioned client for collecting data sources or the above-mentioned client for viewing and managing standard data through the terminal device 101 to view and obtain standardized coal blending and combustion data in real time. The target objects in this application scenario mainly include coal-fired power plant staff and staff who design coal blending and combustion plans.

[0056] The server 102 may be an independent physical server or an edge device 102 in the field of cloud computing. It may also be a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud storage, cloud functions, network services, cloud communications, middleware services, domain name services, security services, content delivery networks (English name: Content Delivery Network, abbreviated as CDN), as well as big data and artificial intelligence platforms.

[0057] There is no restriction on the number of the terminal devices 101 and / or servers 102 .

[0058] It should be noted that the standard data generation method for coal blending and combustion in the embodiment of the present application can be executed by the terminal device 101 or the server 102 alone, or can be executed by the terminal device 101 and the server 102 together. For example, when the terminal device 101 and the server 102 are executed together, the server 102 can accept the data source collected by the terminal device 101, and then generate a coal type standard data table according to the data source; then generate a coal grinding system standard data table and a stacking position standard data table according to the data source and the coal type number, respectively, and build an association relationship between the coal type standard data table and the coal grinding system standard data table and the stacking position standard data table based on the coal type number, and store the data in the database in the server 102. The terminal device 101 can obtain data once by means of the http protocol, and according to actual needs, a data acquisition method combining timed triggering, manual triggering, conditional triggering or multiple triggering methods can be used to collect the coal blending and combustion data source of the coal-fired power plant in real time, and upload the data to the server 102. After receiving the data source, the server 102 generates standard data and outputs it to the terminal device 101, which is provided to the target object for use, and the design of the coal blending and combustion scheme is completed.

[0059] The following is a description of the standard data generation method for coal blending provided by an exemplary embodiment of the present application in combination with the above-mentioned application scenarios and with reference to the accompanying drawings. It should be noted that the above-mentioned application scenarios are only shown to facilitate understanding of the spirit and principles of the present application, and the implementation methods of the present application are not subject to any limitations in this regard.

[0060] refer to Figure 2 , is an implementation flow chart of a method for generating standard data for blending and burning coal provided in an embodiment of the present application. Here, the server is used as the execution subject for introduction. The specific implementation process of the method is as follows:

[0061] S201, collect the data sources to be standardized, the data sources include: coal type data source, coal grinding system data source and stack data source. In practice, the data source can be the data of offline paper materials uploaded to the client or server of the terminal device through local data sorting, or it can be the import of existing data through the information system interface. When using the information system interface to import data, the http protocol can be used to set the method of automatically acquiring data. According to actual needs, the interface can be triggered to automatically collect data by timing triggering, manual triggering, conditional triggering or a combination of multiple triggering methods.

[0062] In this embodiment, there are at least two ways to collect the data source to be standardized: classified collection or classification after collection, and the two methods can also be used in combination. Among them, the classified collection method is: collecting coal type attribute information and storing it as the coal type data source, collecting coal grinding system attribute information and storing it as the coal grinding system data source, and collecting inventory information and storing it as the stack data source through historical records or automatic triggering; the classification method after collection is: classifying and processing the collected historical records or real-time fuel blending data, and the classification basis is: storing coal type attribute parameters as the coal type data source, storing specific information and working attribute parameters of the coal grinding system as the coal grinding system data source, and storing real-time inventory data in the coal yard as the stack data source. The collection method is flexibly selected according to the actual scenario of data collection. For example, if the existing data has been classified and stored according to coal type, coal grinding system, inventory information, and boundary conditions, the classified data collection method can be adopted to achieve efficient acquisition of data sources; for the existing data that has not been classified and stored according to coal type, coal grinding system, inventory information, and boundary conditions, it can be collected as a whole first, and then classified according to data attributes.

[0063] In some implementations, step S201 may include:

[0064] Inputting the customized boundary condition data into the coal grinding system standard data table;

[0065] A constraint condition table is generated according to the stack position standard data table and the coal grinding system standard data table containing the boundary condition data.

[0066] It should be noted that the embodiment of the present application divides the data source into: coal type data source, coal grinding system data source, stack position data source and boundary conditions, wherein the coal type data source mainly includes information on coal types, the coal grinding system data source mainly includes equipment information such as coal grinding machines and raw coal bins, and the stack position data source mainly includes real-time inventory information of all opposing positions in the coal yard. The boundary conditions are the staff who are responsible for coal blending and combustion. According to the coal blending and combustion scenario of the coal-fired power plant, the boundary condition data of the coal grinding system, the boundary condition data of the unit and other boundary condition data that need to be considered as part of the coal blending and combustion design scheme are defined, mainly including boundary conditions for assigning values ​​to data such as coal types, coal grinding systems, and stack positions, as well as the coal blending range that can be customized according to the coal blending and combustion scenario. In actual applications, depending on the scenario of coal blending and combustion, the information contained in each type of data source has subtle differences. In the scenario of this embodiment, the information contained in each type of data source is specifically classified as follows:

[0067] The specific attribute parameters of the coal types contained in the coal type data source include: the inspection composition data of the coal types, the calorific value, ash content, sulfur content, moisture content, ash melting point in degrees Celsius and calculated value of grindability coefficient of pure coal, mixed coal and coal types to be stored.

[0068] The coal mill system data source contains basic information and attribute parameters of the coal mill boiler and raw coal bunker, including: the rated output of the coal mill, the type of mill and the capacity of the raw coal bunker and their real-time data, that is, the real-time coal quantity and type in the raw coal bunker, the designed output of the coal mill and the actual output and other information.

[0069] The stack data source mainly includes inventory information, that is, the real-time inventory data of the coal yard, including: the inventory of different types of coal in the coal yard, stacking location, whether it is available, and other real-time data.

[0070] Boundary conditions include: the tendency of coal blending calculation, the upper limit of ash content, the lower limit of calorific value, the upper limit of sulfur content, the proportion of coal blending, the allowable range of mixed coal and other assignment constraints.

[0071] In some embodiments, the method may further include in step S201: using a customized computer language to run a script to generate the coal type standard data table, the coal grinding system standard data table, the stack position standard data table and the constraint condition table from the data source.

[0072] S202, generating a coal type standard data table according to the coal type data source, wherein the coal type standard data table includes a coal type number generated according to the coal type.

[0073] Specifically, based on the collected coal data source, a customized computer language is used to run the script to generate the following table named algo_info_coal (the coal type ID listed in the table is the coal type number generated according to the coal type):

[0074] Field Name Field Type Field Description

[0075] heating_value numeric(13,4) heating value kcal / t

[0076] ash_content numeric(13,4) ash content

[0077] ash_melting_po numeric(13,4) ash melting point in degrees Celsius

[0078] int

[0079]

[0080] As an implementation mode, the specific implementation steps of step S202 include:

[0081] First, the coal type attribute parameters belonging to the same coal type in the coal type data source are converted into units and merged into one coal type attribute data, wherein the coal type includes pure coal and mixed coal, wherein the coal type attribute data of the mixed coal is obtained by calculating the weighted average of the pure coal attribute data constituting the mixed coal in proportion. It should be noted that the coal type standard data table is composed of at least one coal type attribute data, and each coal type attribute data is generated by converting the specific attribute parameters of the same type of coal into units.

[0082] Then, each piece of coal type attribute data is numbered to generate a coal type number.

[0083] Here, the reason for converting the attribute parameters is that due to the diversity of data sources, the numerical units of the attribute parameters recorded in each data source may be different. After the unit conversion, the numerical units of the parameters of all data sources are guaranteed to be consistent. For example, the calorific value of the collected coal is 1kcal / kg. After the unit conversion, the calorific value of the coal in the data source is 1kcal / k×1000, and the 1000kcal / t in the coal standard data table is obtained.

[0084] In practice, there are not only pure coal types but also mixed coals of different types. In this case, as an implementation method, the specific implementation steps of step S202 also include:

[0085] Firstly, the coal type attribute parameters of the mixed coal in the coal type data source are weighted averaged according to the proportions of different types of coal in the mixed coal to obtain the mixed coal attribute parameters;

[0086] Then, the mixed coal attribute parameters are converted into units and merged into one mixed coal attribute data to generate a mixed coal number.

[0087] S203, based on the coal type data source of the coal grinding system and the coal types contained therein, a coal type number corresponding to the coal type is used as an entry to generate a coal grinding system standard data table. In practice, each device in the coal grinding system includes at least one type of coal. Based on the coal type number in the coal type standard data table, a customized computer language running script can be used to generate at least one coal grinding system standard data table containing a coal type number and coal grinding system data parameters from the coal grinding system data source, specifically, the following table with the table name algo_info_grinder:

[0088] Field Name Field Type Field Description boiler_id varchar(45) Boiler ID output_power numeric(13,4) Rated output t / h total_storage numeric(13,4) Raw coal bunker capacity t coal_id varchar(45) Coal type ID grinder_type varchar(45) Mill Type current_amount numeric(13,4) Current coal quantity in the raw coal bunker t ash_melting_point_upper_bound numeric(13,4) The upper limit of ash melting point of available coal types in raw coal bunker in degrees Celsius ash_melting_point_lower_bound numeric(13,4) The lower limit of ash melting point of available coal types in raw coal bunker in degrees Celsius heating_value_upper_bound numeric(13,4) Upper limit of calorific value kcal / t of available coal types in raw coal bunker heating_value_lower_bound numeric(13,4) The lower limit of calorific value kcal / t of coal types available in raw coal bunker grinder_id varchar(45) Coal grinding system ID

[0089] As an implementation mode, the specific implementation steps of step S203 include:

[0090] Firstly, the basic information and attribute parameters of each coal grinding system in the coal grinding system data source are converted into units.

[0091] Then, according to the type of coal loaded in the coal grinding system, at least one coal grinding system attribute data is generated with the coal type number as an entry, and the coal grinding system attribute data is numbered to generate a coal grinding system number. Specifically, the coal type number in the raw coal bunker equipment in the coal grinding system and the information of the raw coal bunker, coal type boiler and other equipment are combined into one piece of data, and the equipment in the coal grinding system, such as the boiler and the raw coal bunker, are numbered, and their numbers are consistent with the coal type number. For example, if the coal type id is: XX01, the corresponding coal grinding system number should be: the boiler id: XX01, the coal grinding system id: XX01.

[0092] Finally, the coal grinding system standard data table is generated based on at least one coal grinding system attribute data. The coal grinding system standard data table contains at least one coal grinding system attribute data. In practice, the corresponding number of coal grinding system attribute data is generated according to the number of coal types added to the coal grinding system.

[0093] S204: Generate a stack standard data table based on the stack data source and the coal types contained therein, with the coal type number corresponding to the coal type as an entry. In practice, each stack in the coal yard has at least one type of coal stored therein. Based on the coal type number in the coal type standard data table, the stack data source can be generated into at least one stack standard data table containing the coal type number and stack inventory data by running a script in a customized computer language, specifically the following table with the table name algo_info_stock_record:

[0094] Field Name Field Type Field Description coal_id varchar(255) Coal type ID stock_amount varchar(45) Inventory record_time timestamp Recording time pile_id varchar(45) Stack number availability varchar(45) Is it advisable in_stock_time timestamp Warehouse time

[0095] As an implementation mode, the specific implementation steps of step S204 include:

[0096] First, the coal type number of the fuel stored in the stack data source and the inventory information of the corresponding stack are merged;

[0097] Then, according to the type of coal contained in the fuel stored in each stack in the stack data source, at least one stack inventory data is generated with the coal type number corresponding to the coal type as an entry, and the stack inventory data is numbered to generate a stack number;

[0098] Finally, the stack standard data table is generated based on at least one of the stack inventory data. The stack standard data table contains at least one stack inventory data. In practice, a corresponding number of stack inventory data is generated according to the number of types of coal stored in the stack. If more than one type of coal is stored in the stack, it is converted into multiple data.

[0099] It should be noted that since the coal type standard data table can collect the latest data in the coal yard in real time, some values ​​in the coal type standard data table may be updated and overwritten, etc., which will cause unavailable coal types and the corresponding fields of the corresponding coal types will be assigned a value of 0.

[0100] S205, storing the coal type standard data table, the coal grinding system standard data table and the stack position standard data table in a relational database.

[0101] For standard data stored in a relational database, when used in actual coal blending and combustion, the coal blending and combustion scheme can be designed by referring to the constraints. According to the actual scenario, constraints with different names are set based on boundary conditions. A constraint table named algo_constraint_detail can be generated by running a script in a customized computer language, as follows:

[0102] Field Name Field Type Field Description constraint_name varchar(45) Constraint Name constraint_value json Constraint Value comment varchar(255) Constraint Description

[0103] Further, according to the data in the coal type standard data table, the coal grinding system standard data table and the stack position standard data table, a constraint value is assigned to each constraint condition. According to different constraint values, each constraint can generate a piece of data. The specific format is as follows:

[0104]

[0105]

[0106] Finally, all constraint data constitute the constraint condition table.

[0107] It can be seen that in this embodiment, by collecting the data source to be standardized; generating a coal type standard data table according to the coal type data source; generating a coal grinding system standard data table according to the coal type data source and the coal type contained therein, and based on the coal type number in the coal type data source; generating a stack position standard data table according to the coal type data source and the coal type contained therein, and based on the coal type number in the coal type data source; storing the coal type standard data table, the coal grinding system standard data table and the stack position standard data table in a relational database. In this way, data can be updated in real time and quickly according to the coal type standard data table during the coal blending and combustion process, and unified and standardized standard coal type data can be provided, and dynamic data call and calculation operations can be realized; standard data that can fully reflect the real-time working conditions of equipment such as boilers and coal mills in the coal grinding system is generated through the standard data table, and the standardization of data formats and interface specifications is facilitated through standardized data, which is helpful to realize cross-platform data sharing and algorithm call, and further, it can systematically solve the problem of being unable to realize the blending and combustion scene in the information system due to the chaotic data format, poor real-time performance and difficulty in docking in the blending and combustion scene. And it can be applied to similar scenarios of all boiler combustion to generate standard data that conforms to the information format. The method of this application can improve the degree of automation of coal blending and combustion, reduce manual intervention in system data, improve real-time response and dynamic adjustment capabilities, and give the data platform compatibility and system expansion capabilities.

[0108] Based on the same inventive concept, the present application embodiment also provides a standard data generation device for coal blending and combustion. Figure 3 As shown, it is a schematic diagram of the structure of a standard data generation device 300 for coal blending and combustion, which may include:

[0109] The data collection module 301 is used to collect data sources to be standardized, wherein the data sources include: a coal type data source, a coal grinding system data source, and a stack data source, wherein the coal grinding system data source and the stack data source include at least one type of coal in the coal type data source;

[0110] A coal type table generating module 302 generates a coal type standard data table according to the coal type data source, wherein the coal type standard data table includes coal type numbers generated according to coal type types;

[0111] A coal grinding system standardization module 303 is used to generate a coal grinding system standard data table based on the coal grinding system data source and the coal types contained therein, with the coal type numbers corresponding to the coal types as entries;

[0112] The stack position standardization module 304 is used to generate a stack position standard data table according to the stack position data source and the coal type contained therein, with the coal type number corresponding to the coal type as an entry;

[0113] The relational database 305 is used to store standard data tables, which at least include the coal type standard data table, the coal grinding system standard data table and the stack position standard data table.

[0114] In a possible embodiment, the standard data generating device 300 for coal blending and combustion further includes:

[0115] The constraint module 306 is used to input the customized boundary condition data into the coal grinding system standard data table, and generate a constraint condition table according to the stack position standard data table and the boundary condition data; and to generate the coal type standard data table, the coal grinding system standard data table, the stack position standard data table and the constraint condition table from the data source respectively through a customized computer language running script.

[0116] The standard data generation and storage for coal blending provided in the embodiment of the present application can collect data sources through the terminal device using the information system interface, or can obtain the data source through the server using data communication, and then obtain the data source to be standardized by collecting; generate a coal type standard data table according to the coal type data source; generate a coal grinding system standard data table according to the coal type data source and based on the coal type number in the coal type data source; generate a stack position standard data table according to the stack position data source and based on the coal type number in the coal type data source; store the coal type standard data table, the coal grinding system standard data table and the stack position standard data table in a relational database. In this way, the coal type standard data table can be updated in real time and quickly during the coal blending and blending process, and the coal type data can be quickly called for calculation and transmission according to different needs, and then the standard data table can be used to generate standard data that can fully reflect the real-time working conditions of equipment such as boilers and coal mills in the coal grinding system, and the standardized data facilitates the unification of data formats and interface specifications, which helps to realize cross-platform data sharing and algorithm calls, and further, it can systematically solve the problem of the inability to realize the blending scene in the information system due to the chaotic data format, poor real-time performance and difficulty in docking in the blending scene. And it can be applied to similar scenarios of all boiler combustion to generate standard data that conforms to the information format. The method of this application can improve the degree of automation of coal blending and combustion, reduce manual intervention in system data, improve real-time response and dynamic adjustment capabilities, and give the data platform compatibility and system expansion capabilities.

[0117] In some possible implementations, the standard data generation device for coal blending and combustion according to the present application may include at least a processor and a memory. The memory stores program code, and when the program code is executed by the processor, the processor executes the steps of the standard data generation method for coal blending and combustion according to various exemplary embodiments of the present application described in this specification. For example, the processor may execute the following steps: Figure 2 Follow the steps shown in .

[0118] Based on the same inventive concept, an electronic device is also provided in the embodiment of the present application, and the electronic device can realize the functions of the aforementioned standard data generation method and device for coal blending and combustion, referring to Figure 4 A schematic diagram of the structure of an electronic device in an embodiment, at the hardware level, the electronic device includes a processor 401, and optionally also includes an internal bus 400, a network interface 403, and a memory 402. Among them, the memory 402 may include a memory, such as a high-speed random access memory (Random-Access Memory, RAM), and may also include a non-volatile memory (non-volatile memory), such as at least one disk storage, etc. Of course, the electronic device may also include hardware required for other services.

[0119] The processor 401, the network interface 403 and the memory 402 can be connected to each other through the internal bus 400, which can be an ISA (Industry Standard Architecture) bus, a PCI (Peripheral Component Interconnect) bus or an EISA (Extended Industry Standard Architecture) bus, etc. The bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 4 Only one bidirectional arrow is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0120] The memory 402 is used to store programs. Specifically, the program may include program codes, and the program codes include computer operation instructions. The memory may include internal memory and non-volatile memory, and provide instructions and data to the processor.

[0121] In one possible implementation, the processor reads the corresponding computer program from the non-volatile memory into the memory and then runs it, and can also obtain the corresponding computer program from other devices to form a standard data generation device for coal blending and combustion at a logical level. The processor 401 executes the program stored in the memory 401 to implement the standard data generation method for coal blending and combustion provided in any embodiment of the present application through the executed program.

[0122] As described above, the present invention Figure 2The method performed by the standard data generating device for coal blending provided in the illustrated embodiment can be applied to the processor 401, or implemented by the processor 401. The processor 401 may be an integrated circuit chip with signal processing capability. In the implementation process, each step of the above method can be completed by an integrated logic circuit of hardware or software instructions in the processor 401. The above processor 401 can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components. The disclosed methods, steps and logic block diagrams in the embodiments of the present invention can be implemented or executed. The general-purpose processor can be a microprocessor or any conventional processor, etc.

[0123] The steps of the method disclosed in the embodiments of the present application can be directly embodied as being executed by a hardware decoding processor, or can be executed by a combination of hardware and software modules in the decoding processor. The software module can be located in a storage medium mature in the art such as a random access memory, a flash memory, a read-only memory, a programmable read-only memory, or an electrically erasable programmable memory, a register, etc. The storage medium is located in a memory, and the processor reads the information in the memory and completes the steps of the above method in combination with its hardware.

[0124] Based on the same inventive concept, an embodiment of the present application also provides a storage medium, which computer-readable storage medium stores one or more programs, and the one or more programs include instructions. When the instructions are executed by an electronic device including multiple applications, the electronic device can execute the standard data generation method for coal blending provided in any embodiment of the present application.

[0125] The systems, devices, modules or units described in the above embodiments may be implemented by computer chips or entities, or by products with certain functions. A typical implementation device is a computer. Specifically, the computer may be, for example, a personal computer, a laptop computer, a cellular phone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.

[0126] For the convenience of description, the above device is described as various units or modules according to their functions. Of course, when implementing the present invention, the functions of each unit or module can be implemented in the same or multiple software and / or hardware.

[0127] Those skilled in the art will appreciate that the embodiments of the present application may be provided as methods, systems, or computer program products. Therefore, the present application may adopt the form of a complete hardware embodiment, a complete software embodiment, or an embodiment in combination with software and hardware. Moreover, the present application may adopt the form of a computer program product implemented in one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) that include computer-usable program code.

[0128] The present application may be described in the general context of computer-executable instructions executed by a computer, such as program modules. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform specific tasks or implement specific abstract data types. The present invention may also be practiced in distributed computing environments where tasks are performed by remote processing devices connected through a communication network. In a distributed computing environment, program modules may be located in local and remote computer storage media, including storage devices.

[0129] Each embodiment in this application is described in a progressive manner, and the same or similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the system embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment.

[0130] Obviously, those skilled in the art can make various changes and modifications to the present application without departing from the spirit and scope of the present application. Thus, if these modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is also intended to include these modifications and variations.

Claims

1. A method for generating standard data for coal blending and combustion, characterized in that: include: Collecting data sources to be standardized, the data sources including: a coal type data source, a coal grinding system data source and a stack data source, wherein the coal grinding system data source and the stack data source include at least one type of coal in the coal type data source; Generate a coal type standard data table according to the coal type data source, wherein the coal type standard data table includes a coal type number generated according to the coal type; According to the coal grinding system data source and the coal types contained therein, a coal grinding system standard data table is generated with the coal type numbers corresponding to the coal types as entries; According to the stack data source and the coal types contained therein, a stack standard data table is generated with the coal type numbers corresponding to the coal types as entries; The coal type standard data table, the coal grinding system standard data table and the stack position standard data table are stored in a relational database.

2. The method according to claim 1, characterized in that: The method further comprises: Inputting the customized boundary condition data into the coal grinding system standard data table; Generate a constraint condition table according to the stack position standard data table and the coal grinding system standard data table containing the boundary condition data; and The data source is used to generate the coal type standard data table, the coal grinding system standard data table, the stack position standard data table and the constraint condition table respectively through a customized computer language running script.

3. The method according to claim 1, characterized in that: The method for collecting data sources to be standardized includes: Collect coal type attribute information and store it as the coal type data source, collect coal grinding system attribute information and store it as the coal grinding system data source, and collect inventory information and store it as the stack data source by means of historical records or automatic triggering; and / or The collected historical records or the fuel blending data automatically triggered are classified and processed, and the classification basis is: storing the coal type attribute parameters as the coal type data source, storing the specific information and working attribute parameters of the coal grinding system as the coal grinding system data source, and storing the real-time inventory data in the coal yard as the stack data source.

4. The method according to claim 1, characterized in that: The step of generating a coal type standard data table according to the coal type data source comprises: The coal attribute parameters belonging to the same coal type in the coal data source are converted into units and then merged into one piece of coal attribute data, wherein the coal type includes pure coal and mixed coal, wherein the coal attribute data of the mixed coal is obtained by calculating the weighted average of the pure coal attribute data constituting the mixed coal according to the proportion; Each piece of coal type attribute data is numbered to generate a coal type number.

5. The method according to claim 1, characterized in that: The step of generating a coal grinding system standard data table with the coal type number as an entry according to the coal grinding system data source and the coal type types contained therein comprises: Convert the basic information and attribute parameters of each coal grinding system in the coal grinding system data source into units; According to the type of coal loaded in the coal grinding system, at least one piece of coal grinding system attribute data is generated with the coal type number as an item, and the coal grinding system attribute data is numbered to generate a coal grinding system number; The coal grinding system standard data table is generated based on at least one piece of the coal grinding system property data.

6. The method according to claim 1, characterized in that: The step of generating a stack position standard data table according to the stack position data source and the coal type contained therein, with the coal type number corresponding to the coal type as an entry, comprises: Merging the coal type number of the fuel stored in the stack data source and the inventory information of the corresponding stack; According to the type of coal contained in the fuel stored in each stack in the stack data source, at least one stack inventory data is generated with the coal type number corresponding to the coal type as an entry, and the stack inventory data is numbered to generate a stack number; The stack position standard data table is generated based on at least one piece of the stack position inventory data.

7. A standard data generation device for coal blending and combustion, characterized in that: include: A data collection module, used for collecting data sources to be standardized, wherein the data sources include: a coal type data source, a coal grinding system data source and a stack data source, wherein the coal grinding system data source and the stack data source include at least one type of coal in the coal type data source; A coal type standardization module, used to generate a coal type standard data table according to the coal type data source, wherein the coal type standard data table includes a coal type number generated according to the coal type; A coal grinding system standardization module, used for generating a coal grinding system standard data table according to the coal grinding system data source and the coal types contained therein, with the coal type numbers corresponding to the coal types as entries; A stack standardization module is used to generate a stack standard data table based on the stack data source and the coal types contained therein, with the coal type numbers corresponding to the coal types as entries; The relational database is used to store standard data tables, wherein the standard data tables at least include the coal type standard data table, the coal grinding system standard data table and the stack position standard data table.

8. The device according to claim 7, characterized in that The device also includes: A constraint module is used to input customized boundary condition data into the coal grinding system standard data table, and generate a constraint condition table according to the stack position standard data table and the boundary condition data; and to generate the coal type standard data table, the coal grinding system standard data table, the stack position standard data table and the constraint condition table from the data source through a customized computer language running script.

9. An electronic device, characterized in that: The device comprises a processor and a memory, wherein the memory stores program codes, and when the program codes are executed by the processor, the processor executes any one of the methods in claims 1 to 6.

10. A computer-readable storage medium, characterized in that: The storage medium comprises a program code, and when the storage medium is run on an electronic device, the program code is used to enable the electronic device to execute any one of the methods of claims 1 to 6.

Images