Method and device for processing multi-source heterogeneous data in coal mine

Abstract

The invention discloses a method and a device for processing multi-source heterogeneous data in a coal mine. The method comprises the following steps: acquiring first data of a unified construction system of a target coal mine enterprise and second data of a self-construction system of a molecular company of the target coal mine enterprise; the first data and the second data are pushed to a data center, and the data center is a data storage center deployed in a machine room of the molecular company; integrating the first data and the second data in the data center to obtain integrated data; processing the integrated data by using a data access mode of multi-source heterogeneous data to obtain processed integrated data; and providing the processed integrated data of the target coal mine enterprise for the third-party system through the data center. According to the invention, the technical problems that coal mine data is dispersed in each business system, no direct through channel exists, and the data is difficult to share outwards in the prior art are solved.

Description

Technical Field

[0001] The present invention relates to the technical field of data governance, and in particular to a method and device for processing multi-source heterogeneous data in a coal mine. Background Art

[0002] At present, coal mines have many systems, large data volumes, high real-time requirements and fast growth, and complex data structures. These problems severely limit the integration, sharing, and mining applications of data.

[0003] The existing technology has the following problems: 1). Coal mine data is scattered in various business systems. There is currently no direct channel for communication, and it is difficult to share data externally. 1) Some of the data submitted by the subsidiary to the data center are manually entered by the coal mine. This part of the data urgently needs further data source tracing to realize automatic data reporting and ensure the accuracy and consistency of the data; 2) Coal mine data includes business data, document data, video data, monitoring and surveillance data, etc. The data is mainly used to meet functional applications, and the overall enterprise-level data architecture design has not been formed. There is a lack of correlation between data, and cross-business data cannot be effectively connected. Data exchange and data sharing are difficult, and data redundancy, data integrity, compliance, and consistency issues are prominent; 3) Coal mines have many systems built in different business sectors, which belong to different business departments and built at different times. There is a lack of unified data standards. The data of each system is isolated and stored in a dispersed manner, forming data islands, making it difficult to achieve data connection, process connection, and business collaboration between systems. The system integration needs to be improved; 4) Coal mine data is an important resource for coal enterprises. The volume of coal mine unit data is large and the structure is complex. At present, there is a lack of overall resource management of data, resulting in insufficient data analysis and utilization, in-depth mining, and difficulty in realizing the value of data.

[0004] To address the above-mentioned problems, no effective solution has been proposed yet. Summary of the invention

[0005] The embodiment of the present invention provides a method and device for processing multi-source heterogeneous data in a coal mine, so as to at least solve the technical problem in the related art that the coal mine data is scattered in various business systems, there is no direct communication channel, and there is a certain difficulty in sharing the data externally.

[0006] According to one aspect of an embodiment of the present invention, a method for processing multi-source heterogeneous data in a coal mine is provided, comprising: obtaining first data of a unified system of a target coal mine enterprise and second data of a self-built system of a branch or subsidiary of the target coal mine enterprise; pushing the first data and the second data to a data center, wherein the data center is a data storage center deployed in a computer room of the branch or subsidiary; integrating the first data and the second data in the data center to obtain integrated data; processing the integrated data using a data access method for multi-source heterogeneous data to obtain the processed integrated data; and providing the processed integrated data of the target coal mine enterprise to a third-party system through the data center.

[0007] Optionally, pushing the first data and the second data to the data center includes: determining a first field of the data center that the self-built system needs to enter based on current system information 1 of the integrated system; determining a second field of the data center that the self-built system needs to enter based on current system information 2 of the self-built system; and pushing the first data and the second data to the data center based on the first field and the second field.

[0008] Optionally, the first data will be pushed to the data center based on the first field, including: encoding each employee data corresponding to the first field according to a predetermined encoding method to obtain the encoded first data; updating the encoded first data according to a predetermined period using a webservice interface to obtain updated first data; and pushing the updated first data to the data center.

[0009] Optionally, pushing the second data to the data center according to the second field includes: creating a first data table of the self-built system and a data field of the self-built system according to the second field; creating a corresponding view in the data center according to the first data table and the data field, so that the second data is pushed to the data center.

[0010] Optionally, pushing the second data to the data center according to the second field includes: performing data source configuration, collector configuration and task scheduling configuration for each business system in the self-built system to obtain configuration information; generating a scheduling task according to the configuration information; and regularly pushing the second data of each business system to the data center according to the second field according to the scheduling task.

[0011] Optionally, the method for processing multi-source heterogeneous data in the coal mine further includes: when there is a host computer in the production system of the target coal mine enterprise, obtaining measurement point data from the host computer, and converting the measurement point data into production system data through a protocol; when there is no host computer in the production system of the target coal mine enterprise, obtaining measurement point data from the underlying equipment of the target coal mine enterprise through a programmable logic controller (PLC) protocol, and converting the measurement point data into the production system data through a protocol.

[0012] Optionally, the processed integrated data of the target coal mining enterprise is provided to a third-party system through the data center, including: when the third-party system monitors the webservice interface, after detecting the data call instruction, the data center is controlled to push the integrated data to the third-party system through the webservice interface for processing.

[0013] According to another aspect of an embodiment of the present invention, a device for processing multi-source heterogeneous data in a coal mine is also provided, including: a first acquisition module, used to acquire first data of a unified system of a target coal mine enterprise and second data of a self-built system of a branch or subsidiary of the target coal mine enterprise; a push module, used to push the first data and the second data to a data center, wherein the data center is a data storage center deployed in a computer room of the branch or subsidiary; an integration module, used to integrate the first data and the second data in the data center to obtain integrated data; a first processing module, used to process the integrated data using a data access method for multi-source heterogeneous data to obtain the processed integrated data; and a providing module, used to provide the processed integrated data of the target coal mine enterprise to a third-party system through the data center.

[0014] Optionally, the push module includes: a first determination unit, used to determine the first field of the data center that the self-built system needs to enter based on current system information 1 of the integrated system; a second determination unit, used to determine the second field of the data center that the self-built system needs to enter based on current system information 2 of the self-built system; and a first push unit, used to push the first data and the second data to the data center based on the first field and the second field.

[0015] Optionally, the first push unit includes: an encoding subunit, used to encode each employee data corresponding to the first field according to a predetermined encoding method to obtain the encoded first data; an updating subunit, used to update the encoded first data according to a predetermined period using a webservice interface method to obtain the updated first data; a first pushing subunit, used to push the updated first data to the data center.

[0016] Optionally, the first pushing unit includes: a first creation subunit, used to create a first data table of the self-built system and a data field of the self-built system according to the second field; a second creation subunit, used to create a corresponding view in the data center according to the first data table and the data field, so that the second data is pushed to the data center.

[0017] Optionally, the first push unit includes: a configuration subunit, used to perform data source configuration, collector configuration and task scheduling configuration for each business system in the self-built system to obtain configuration information; a generation subunit, used to generate a scheduling task according to the configuration information; and a second push subunit, used to push the second data of each business system to the data center according to the second field at a scheduled time according to the scheduling task.

[0018] Optionally, the processing of multi-source heterogeneous data in the coal mine also includes: a second processing module, which is used to obtain measurement point data from a host computer when there is a host computer in the production system of the target coal mine enterprise, and convert the measurement point data into production system data through a protocol; a third processing module, which is used to obtain measurement point data from the underlying equipment of the target coal mine enterprise through a programmable logic controller (PLC) protocol when there is no host computer in the production system of the target coal mine enterprise, and convert the measurement point data into the production system data through a protocol.

[0019] Optionally, the providing module includes: a second pushing unit, which is used to control the data center to push the integrated data to the third-party system for processing through the webservice interface after detecting a data call instruction during the process of the third-party system monitoring the webservice interface.

[0020] According to another aspect of an embodiment of the present invention, a system for processing multi-source heterogeneous data in a coal mine is provided. The system for processing multi-source heterogeneous data in a coal mine uses any one of the above methods for processing multi-source heterogeneous data in a coal mine.

[0021] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is provided, the computer-readable storage medium comprising a stored program, wherein the program executes any one of the above-mentioned methods for processing multi-source heterogeneous data in a coal mine.

[0022] According to another aspect of an embodiment of the present invention, a processor is provided, the processor being used to run a program, wherein the program, when running, executes any one of the above-mentioned methods for processing multi-source heterogeneous data in a coal mine.

[0023] According to another aspect of an embodiment of the present invention, a computer program product is provided, comprising computer instructions, which, when executed by a processor, execute any one of the above-mentioned methods for processing multi-source heterogeneous data in a coal mine.

[0024] In an embodiment of the present invention, the first data of the unified system of the target coal mine enterprise and the second data of the self-built system of the branch and subsidiary of the target coal mine enterprise are obtained; the first data and the second data are pushed to the data center, wherein the data center is a data storage center deployed in the computer room of the branch and subsidiary; the first data and the second data are integrated in the data center to obtain integrated data; the integrated data is processed by using the data access method of multi-source heterogeneous data to obtain the processed integrated data; and the processed integrated data of the target coal mine enterprise is provided to the third-party system through the data center. Through the technical scheme provided by the present invention, the unified system of the group headquarters, the self-built system, the production control system of each mine, the safety monitoring system, the personnel positioning system, the risk pre-control system, and the rubber-wheeled vehicle system are integrated with the coal mine data center through the intelligent mining system, and at the same time, the data is standardized, the coal production is monitored in real time and transparently, and the panoramic data view of the coal mine is displayed, thereby realizing the data resourceization of the coal sector, the association fusion, exchange sharing, mining and analysis of heterogeneous data, and the technical effect of exerting the value of data, improving the efficiency of data sharing and transmission, and thus solving the technical problem that the coal mine data in the related technology is scattered in various business systems, there is no direct through channel, and there is a certain difficulty in sharing data externally. BRIEF DESCRIPTION OF THE DRAWINGS

[0025] The drawings described herein are used to provide a further understanding of the present invention and constitute a part of this application. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute an improper limitation of the present invention. In the drawings:

[0026] Figure 1 It is a hardware structure block diagram of a mobile terminal of a method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention;

[0027] Figure 2is a flow chart of a method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention;

[0028] Figure 3 is an integrated relationship diagram of overall application of a data center of a method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention;

[0029] Figure 4 is a schematic diagram of the statistical system integration relationship of the method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention;

[0030] Figure 5 is a schematic diagram of the self-built system integration relationship of the method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention;

[0031] Figure 6 is a schematic diagram of the business data flow and integration relationship of a self-built business system according to an embodiment of the present invention;

[0032] Figure 7 is a flow chart of the overall design concept of data import according to an embodiment of the present invention;

[0033] Figure 8 is a flowchart of specific steps of data import according to an embodiment of the present invention;

[0034] Fig. 9 is a schematic diagram of the coal mine application integration relationship of the method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention;

[0035] Fig.10 It is a flowchart of the collection and release of production system data (excluding the power system) according to the method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention;

[0036] Fig.11 is a flow chart of power system data collection and release of a method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention;

[0037] Fig.12 is a flow chart of an interface solution of a method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention;

[0038] Fig.13 is a schematic diagram of a device for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention. DETAILED DESCRIPTION

[0039] In order to enable those skilled in the art to better understand the scheme of the present invention, the technical scheme in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work should fall within the scope of protection of the present invention.

[0040] It should be noted that the terms "first", "second", etc. in the specification and claims of the present invention and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of the present invention described herein can be implemented in an order other than those illustrated or described herein. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, system, product or device that includes a series of steps or units is not necessarily limited to those steps or units that are clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or devices.

[0041] As introduced in the background technology, in the related technology, coal mine data is scattered in various business systems, there is no direct channel for communication, and there is a technical problem that data sharing is difficult. In view of the above defects, in the embodiments of the present invention, a method and device for processing multi-source heterogeneous data in a coal mine, a system for processing multi-source heterogeneous data in a coal mine, a computer-readable storage medium, a processor, and a computer program product are provided.

[0042] The technical solutions in the embodiments of the present invention will be described clearly and completely below in conjunction with the accompanying drawings in the embodiments of the present invention.

[0043] The method embodiments provided in the embodiments of the present invention can be executed in a mobile terminal, a computer terminal or a similar computing device. Taking running on a mobile terminal as an example, Figure 1 1 is a hardware structure block diagram of a mobile terminal of a method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention. Figure 1 As shown, the mobile terminal may include one or more ( Figure 1 Only one is shown in the figure) a processor 102 (the processor 102 may include but is not limited to a processing device such as a microprocessor MCU or a programmable logic device FPGA) and a memory 104 for storing data, wherein the mobile terminal may also include a transmission device 106 and an input / output device 108 for communication functions. It can be understood by those skilled in the art that Figure 1The structure shown is only for illustration and does not limit the structure of the mobile terminal. Figure 1 More or fewer components as shown, or with Figure 1 Different configurations are shown.

[0044] The memory 104 can be used to store computer programs, for example, software programs and modules of application software, such as the computer program corresponding to the method for processing multi-source heterogeneous data in coal mines in the embodiment of the present invention. The processor 102 executes various functional applications and data processing by running the computer program stored in the memory 104, that is, the above method is implemented. The memory 104 may include a high-speed random access memory, and may also include a non-volatile memory, such as one or more magnetic storage devices, flash memory, or other non-volatile solid-state memory. In some examples, the memory 104 may further include a memory remotely arranged relative to the processor 102, and these remote memories can be connected to the mobile terminal via a network. Examples of the above-mentioned network include but are not limited to the Internet, an intranet, a local area network, a mobile communication network, and a combination thereof. The transmission device 106 is used to receive or send data via a network. The above-mentioned specific example of the network may include a wireless network provided by a communication provider of the mobile terminal. In one example, the transmission device 106 includes a network adapter (Network Interface Controller, referred to as NIC), which can be connected to other network devices through a base station so as to communicate with the Internet. In one example, the transmission device 106 may be a radio frequency (RF) module, which is used to communicate with the Internet wirelessly.

[0045] According to an embodiment of the present invention, a method embodiment of a method for processing multi-source heterogeneous data in a coal mine is provided. It should be noted that the steps shown in the flowchart of the accompanying drawings can be executed in a computer system such as a set of computer executable instructions, and although a logical order is shown in the flowchart, in some cases, the steps shown or described may be executed in an order different from that shown here.

[0046] Figure 2 is a flow chart of a method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention. Figure 2 As shown, the method comprises the following steps:

[0047] Step S202, obtaining first data of the unified system of the target coal mining enterprise and second data of the self-built system of the subsidiary company of the target coal mining enterprise.

[0048] It should be noted that the above-mentioned target coal mining enterprises refer to enterprises that need to carry out data governance.

[0049] In this embodiment, the master data (ie, first data) of the target coal mining enterprise's unified system and the business data (ie, second data) of the subsidiary's self-built system can be obtained to facilitate subsequent normalization and other processing.

[0050] Step S204: Push the first data and the second data to a data center, wherein the data center is a data storage center deployed in a computer room of the subsidiary company.

[0051] Figure 3 : is an integrated relationship diagram of the overall application of the data center of the method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention, such as Figure 3 As shown, the group's unified system and the subsidiary's self-built system can transmit data to and from the subsidiary's computing data center.

[0052] It should be noted that the above-mentioned data center management system is a subsidiary branch, which is a second-level unit of the group company, and the coal mine is a subordinate unit of the subsidiary branch.

[0053] In this embodiment, the data of the group's unified system and the data of the subsidiary's self-built system can be pushed to the data center, that is, the data storage center deployed in the subsidiary's computer room, which can realize centralized management of data and facilitate unified management and operation.

[0054] Step S206: Integrate the first data and the second data in the data center to obtain integrated data.

[0055] In this embodiment, the data of the group's unified system and the data of the subsidiary's self-built system can be integrated in the data center to obtain integrated data, which can integrate the data in different systems into a unified data warehouse to improve the efficiency of data processing.

[0056] Step S208, processing the integrated data using a data access method for multi-source heterogeneous data to obtain processed integrated data.

[0057] It should be noted that the above-mentioned multi-source heterogeneous data refers to data from different data sources, which may have different formats, structures, semantics and qualities.

[0058] In this embodiment, the integrated data can be processed using the data access method of multi-source heterogeneous data, and the data from different data sources can be integrated together to form a more comprehensive and complete data set, and the processed integrated data can be obtained to provide more comprehensive information support for decision-making and promote data sharing and collaboration.

[0059] Step S210: providing the processed integrated data of the target coal mining enterprise to the third-party system through the data center.

[0060] In this embodiment, the data center can be opened to third-party systems to provide processed integrated data of the target coal mining enterprise, thereby helping the third-party system to better understand and utilize the data of the coal mining enterprise and improve data processing efficiency and reliability.

[0061] like Figure 3 As shown, the construction of the data center management system mainly includes the following steps: 1) Pushing the data of the group's unified system to the data center to achieve the docking of the main data; 2) Pushing the data of the subsidiary's self-built system to the data center to achieve the docking of business data; 3) Pushing the data of the coal mines of the subsidiary's subordinate units to the data center to achieve the docking of mine-end data; 4) Integrating the data of various business systems, using data access of multi-source heterogeneous data to realize real-time production, safety monitoring and business management data collection, conversion and cleaning tools. The source system access data should comply with data standards and be displayed; 5) Opening the data center data to third-party systems.

[0062] As can be seen from the above, in the embodiment of the present invention, the first data of the unified system of the target coal mining enterprise and the second data of the self-built system of the branch and subsidiary of the target coal mining enterprise are obtained; the first data and the second data are pushed to the data center, wherein the data center is a data storage center deployed in the computer room of the branch and subsidiary; the first data and the second data are integrated in the data center to obtain integrated data; the integrated data is processed using the data access method of multi-source heterogeneous data to obtain processed integrated data; and the processed integrated data of the target coal mining enterprise is provided to the third-party system through the data center. Through the technical solution provided by the present invention, the unified system of the group headquarters, the self-built system, the production control system of each mine, the safety monitoring system, the personnel positioning system, the risk pre-control system, and the rubber-wheeled vehicle system are integrated with the coal mine data center through the intelligent mining system. At the same time, the data is standardized, the coal production is monitored dynamically and transparently, and the panoramic data view of the coal mine is displayed, thereby realizing the data resourceization of the coal sector, the association fusion, exchange sharing, mining and analysis of heterogeneous data, and the technical effect of giving full play to the value of data, and improving the efficiency of data sharing and transmission.

[0063] The technical solution provided by the embodiment of the present invention solves the technical problem in the related art that coal mine data is scattered in various business systems, there is no direct communication channel, and there are certain difficulties in sharing data externally.

[0064] According to the above embodiment of the present invention, the first data and the second data are pushed to the data center, including: determining the first field of the self-built system that needs to enter the data center according to the current system information 1 of the integrated system; determining the second field of the self-built system that needs to enter the data center according to the current system information 2 of the self-built system; and pushing the first data and the second data to the data center according to the first field and the second field.

[0065] Figure 4 is a schematic diagram of the statistical system integration relationship of the method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention, such as Figure 4 As shown, based on the current status of the integrated system, the fields that the self-built system needs to enter the data center are sorted out.

[0066] Figure 5 is a schematic diagram of the self-built system integration relationship of the method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention, such as Figure 5 As shown, based on the current status of the self-built system, the fields that the self-built system needs to enter the data center are sorted out.

[0067] Optionally, the above-mentioned integrated systems may include: MDM master data, ERP MM material management system, ERR PS project management system, ERP SRM bidding and sourcing management system, ERP FICO financial management system, ERP PM equipment management system, cMES electromechanical module, ERP SD sales management system, ERP CRM customer supplier management system, ERP HR human resources management system and legal system ERP BCS financial statements; the above-mentioned self-built systems may include: water and electricity metering system, internal marketization system, target-transmitted performance system, education and training system, material price information management system, coal metering system, contract fulfillment system, coal sales system, Jiuqi reporting system, EPS business accounting system, and trade union digital platform.

[0068] In this embodiment, the corresponding first field and second field can be determined according to the current system information 1 of the current unified system and the current system information 2 of the self-built system, and the first data and the second data can be pushed to the data center through the interface.

[0069] In the above embodiment of the present invention, the first data will be pushed to the data center according to the first field, including: encoding each employee data corresponding to the first field according to a predetermined encoding method to obtain the encoded first data; using the webservice interface method to update the encoded first data according to a predetermined period to obtain the updated first data; and pushing the updated first data to the data center.

[0070] In this embodiment, the employee data corresponding to the first field can be encoded according to the 8-bit fixed-length digital serial code encoding rules, and the encoded first data can be updated and pushed to the data center according to the webservice interface method. The employee data can be uniquely encoded to ensure the uniqueness of the data and realize real-time synchronization and updating of the data.

[0071] The specific steps are as follows: 1) Definition of employee master data: According to the definition, employees refer to all natural persons who have signed labor contracts with "units" in all subordinate business departments (including departments, sections, teams, and teams) in the "organizational structure" category of the master data (including group companies, subsidiaries (branches) at all levels, units and branches with legal person qualifications at all levels under subsidiaries (branches) at all levels, and until the legal person qualifications units and branches at the last level are analogized) and have signed labor contracts with "units", including various forms of employment. 2) Coding rules in accordance with unified requirements: Adopt 8-digit fixed-length digital serial code coding rules, and duplicate checking rules make human resources coding globally unique. Coding rule explanation: Employee coding adopts 8-digit fixed-length digital serial code, with a coding range of 00000001-99999999, and all coding is done with numbers, without English letters or other special characters. Employee codes correspond to employees one by one, and once generated, they will not change for life. After an employee leaves, his / her code will no longer be used. 3) According to the webservice interface method, data is updated and modified at 12 o'clock every night. Push MDM master data, ERP MM material management system, ERR PS project management system, ERP SRM bidding and sourcing management system, ERP FICO financial management system, ERP PM equipment management system, cMES electromechanical module, ERPSD sales management system, ERP CRM customer supplier management system, ERP HR human resources management system, and legal system ERP BCS financial statements to the data center.

[0072] In the above embodiment of the present invention, the second data is pushed to the data center according to the second field, including: creating a first data table of the self-built system and a data field of the self-built system according to the second field; creating a corresponding view in the data center according to the first data table and the data field, so that the second data is pushed to the data center.

[0073] Figure 6 Schematic diagram of the business data flow and integration relationship of the self-built business system according to an embodiment of the present invention. Figure 6As shown, the fields that the self-built system needs to enter the data center are as follows: 1) Water and electricity metering system: mainly obtain the master data employee and organization data of the head office. The source of the master data is the internal marketization system, and other business data fields come from the water and electricity metering system. 2) Internal marketization system: mainly obtain the master data employee and organization data of the group company. The source of the master data is the human resources system, and other business data fields come from the internal marketization system. 3) Target-conducting performance system: mainly obtain the master data employee and organization data of the group company. The source of the master data is the human resources system, and other business data fields come from the target-conducting performance system. 4) Education and training system: mainly obtain the master data employee and organization data of the group company. The source of the master data is the human resources system, and other business data fields come from the education and training system. 5) Material price information management system: mainly obtain the master data of the group company's master data materials and supplier master data. The source of the master data is the material submission platform and the supplier system. It is recommended to quote the master data including employee, organization, and equipment master data. Other business data fields come from the material price information management system. 6) Coal metering system: mainly obtain the master data of the group company that the group does not obtain, and other business data fields come from the coal metering system. 7) Contract fulfillment system: mainly obtains the master data of the group company, including employee and organization data. The source of master data is the human resources system, legal system, and supplier system. It is recommended to quote master data including employee and organization master data, and other business data fields come from the contract fulfillment system. 8) Coal sales system: mainly obtains the master data of the group company, including material master data and customer master data. The source of master data is the material submission platform and supplier system. Other business data fields come from the coal sales system. 9) Jiuqi reporting system: mainly obtains the master data of the group company, including employee, organization, material, customer, and supplier. The source of master data is the human resources system, supplier system, MDM master data, and material submission platform. Other business data fields come from Jiuqi reporting system. 10) EPS business reimbursement system: mainly obtains the master data of the group company, including employee, organization, material, customer, and supplier. The source of master data is the human resources system, supplier system, MDM master data, and material submission platform. Other business data fields come from the EPS business reimbursement system. 11) Union digital platform: mainly obtains the master data of the group company, including employee and organization data. The source of master data is the human resources system. Other business data fields come from the union digital platform.

[0074] Figure 7 is a flow chart of the overall design idea of ​​data import according to an embodiment of the present invention, such as Figure 7As shown, according to the access system, the tables and fields of the water and electricity metering system, internal marketization system, target-based performance system, education and training system, material price information management system, coal metering system, contract fulfillment system, coal sales system, Jiuqi reporting system, EPS business accounting system, and trade union digital platform need to create corresponding views in the data center (production database). If the entire table is pushed, no view needs to be created, and table-to-table push can be performed directly.

[0075] In this embodiment, a first data table and data fields may be created to better organize and store the second data. Creating a corresponding view in the data center enables the second data to be easily accessed and analyzed, thereby improving the availability and visualization of the data. Centralized management of the data may be achieved by pushing the second data to the data center.

[0076] In the above embodiment of the present invention, the second data is pushed to the data center according to the second field, including: performing data source configuration, collector configuration and task scheduling configuration on each business system in the self-built system to obtain configuration information; generating a scheduling task according to the configuration information; and pushing the second data of each business system to the data center according to the second field according to the scheduling task.

[0077] Figure 8 is a flowchart of specific steps of data import according to an embodiment of the present invention, such as Figure 8 As shown, in the data management system, the business systems (water and electricity metering system, internal marketization system, target-based performance system, education and training system, material price information management system, coal metering system, contract fulfillment system, coal sales system, Jiuqi reporting system, EPS business accounting system, and trade union digital platform) are configured with data source, collector, and task scheduling, and scheduling tasks are issued to push the data of each business system to the data center on a regular basis.

[0078] In addition, you will need to create related tables based on the structure of the views or tables created in the production database. The tables need to have primary keys with creation and modification times, and the fields in the self-built system and the data center (production database) need to correspond one to one.

[0079] In this embodiment, the data collection tasks of each business system can be flexibly managed by configuring the data source, collector and task scheduling, and the data can be pushed to the data center on a regular basis according to demand, so as to realize centralized management and unified analysis of the data.

[0080] According to the above embodiment of the present invention, the method for processing multi-source heterogeneous data in the coal mine also includes: when there is a host computer in the production system of the target coal mine enterprise, obtaining measurement point data from the host computer, and converting the measurement point data into production system data through a protocol; when there is no host computer in the production system of the target coal mine enterprise, obtaining measurement point data from the underlying equipment of the target coal mine enterprise through a programmable logic controller (PLC) protocol, and converting the measurement point data into production system data through a protocol.

[0081] Fig. 9 is a schematic diagram of the coal mine application integration relationship of the method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention, such as Fig. 9 As shown in the figure, the data center is connected to the mine-side production centralized control system and the safety centralized monitoring system (production control system, safety monitoring system, personnel positioning system, risk pre-control system, rubber-wheeled vehicle system integration and coal mine data center of each mine), and the fields that need to be entered into the data center by the self-built system are sorted out. The specific steps are as follows: 1) ① Data collection: coal mining face monitoring system, tunneling face monitoring system, power supply monitoring system, (ground box-type substation, ground substation, underground substation, mining area substation, mobile substation), main drainage monitoring system, main transportation monitoring system, ventilator monitoring system, hoist monitoring system The data collection scope includes the following systems: (inclined shaft hoisting, vertical shaft hoisting), compressed air nitrogen production monitoring system, water supply automation system, refrigeration and cooling monitoring system, boiler room monitoring system, mine pressure monitoring system, hydrological monitoring system, mine water treatment monitoring system, fire pump room monitoring system, overhead passenger monitoring system, monorail crane system, infinite rope winch system, water and electricity metering monitoring system, safety monitoring system, fire bundle pipe monitoring system, personnel positioning system, emergency broadcast system, industrial video system, intelligent video monitoring system, rubber-wheeled vehicle transportation monitoring system, and industrial ring network. Data collection is carried out for systems with access conditions. The data collection scope of each system is based on the measuring points currently connected to each system in the existing mine. Centrally store the real-time status data obtained from various equipment, devices or monitoring and surveillance systems on site, establish the association between the measuring points and the equipment, and realize effective monitoring of the real-time status of the equipment. 2) Protocol conversion and data release: The mine-end servers of each coal mine under the subsidiary company will convert the collected production system data according to the unified standards according to the requirements of Guoneng, publish it as OPC service, and provide external data interface. Complete data connection with the subsidiary company data center. Discuss the collection and release of production system data (excluding power system) and power system data collection and release.

[0082] Fig.10 : is a flowchart of the production system data (excluding the power system) collection and release according to the method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention, such as Fig.10As shown in the figure, the collection and release of system data include the following two situations: 1) If there is a host computer in the production system, the measurement point data is obtained from the host computer first, then converted through the protocol, and finally released by publishing OPC services to provide data. 2) If the measurement point data cannot be obtained from the host computer, after the consent of the mine, the data is directly obtained from the underlying device through the PLC protocol, then converted through the protocol, and finally released by publishing OPC services to provide data.

[0083] Fig.11 is a flow chart of power system data collection and release according to a method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention, such as Fig.11 As shown, the power system generally has a host computer, and the measurement point data is obtained from the host computer first, and then converted through 103 protocol / 104 protocol / ModbusTCP protocol, and finally provided by publishing OPC service.

[0084] In addition, it is necessary to sort out the measurement points in the data collection file, sort out the data of each subsystem, and fill in the measurement point name and description in the file according to the template required by the data center. According to the business data structure sorting method and template, master data concept and group master data dissemination, sort out the business data structure, collect and organize the business data structure.

[0085] In this embodiment, the generation system data obtained through protocol conversion can be used to monitor and analyze the generation situation of the target coal mining enterprise. By obtaining real-time data, problems in the production process can be discovered in time for timely processing, thereby realizing the acquisition of real-time measurement point data from the generation system of the target coal mining enterprise.

[0086] According to the above embodiment of the present invention, the processed integrated data of the target coal mining enterprise is provided to the third-party system through the data center, including: in the process of the third-party system monitoring the webservice interface, after detecting the data call instruction, the data center is controlled to push the integrated data to the third-party system for processing through the webservice interface.

[0087] Fig.12 is a flow chart of an interface scheme of a method for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention, such as Fig.12As shown in the figure, the data center provides a Web Service interface for the third-party platform to facilitate future docking with the third-party system. The third-party interface design of the data center is as follows: 1) Design the interface solution, which can include: all field contents, field requirements, data transmission frequency, interface mode, and data transmission direction of the statistical system, self-built system, and mining system. 2) Design the interface solution. The data center sends the data synchronization request to the third-party system interface by actively pushing. The third-party system monitors the webservice interface. When the call instruction is obtained, the data center pushes the data to the third-party system through the webservice interface for processing and log recording.

[0088] It should be noted that the processing mode of the above interface is asynchronous, data is transmitted in an incremental manner, the data direction is from the data center to the third-party system, and the call cycle is real-time.

[0089] In this embodiment, the control data center and the third-party system can push the integrated data processed by the target coal mining enterprise to the third-party system for processing after the third-party system detects the data call instruction through the webservice interface.

[0090] like Figure 3 As shown, the master data references and sources of the self-built business systems of the subsidiary companies were sorted out and confirmed, and the master data sources that the relevant systems need to apply were recommended, including the following steps: 1) According to the current status of the unified system, sort out the fields that the self-built system needs to enter the data center. 2) According to the current status of the self-built system, sort out the fields that the self-built system needs to enter the data center. 3) Import the data of the self-built system into the data center. 4) The data center is connected to the mine-side production centralized control system and the safety centralized monitoring system, and sort out the fields that the self-built system needs to enter the data center. 5) Data governance and standardization. 6) Data center third-party interface design.

[0091] It should be noted that the above-mentioned data governance and standardization is to govern the measurement point data through the data center data governance platform.

[0092] Among them, the data governance and standardization part mainly includes the following steps: 1) Data standard management: a. Establish a preliminary data standard management system, including document management, information item management, data standard query feedback, and code compliance inspection. b. Establish management data standards, establish data standard processes, definitions, analysis and systems, customer information data standards, information models, data standard definitions, information items, codes, coverage, and distribution analysis. c. Continuously improve data standards and other subject information data standards. 2) Data quality management: a. Establish a preliminary data quality management system, standard indicator definition, problem discovery, verification scheduling engine, knowledge base management, and data governance reports. b. Establish data standards for the business level of statistical systems and self-built systems, and establish preliminary metadata connections. Implement all data quality indicators, business indicator definitions, indicator group definitions, manual verification, and problem lineage analysis. c. Establish a complete data quality management system and fully implement data quality management. 3) Metadata management: a. Establish a preliminary metadata management system, including metadata collection, metadata update management functions, metadata impact analysis, metadata lineage analysis, data maintenance functions, and version management. b. Improve data standards and the degree of sharing between data quality. Get through the collection of business, technology and other metadata, and connect the direct links of business, technology and operation metadata. Open third-party callable interfaces to facilitate third-party platforms to retrieve data and strengthen metadata analysis functions. c. Establish support for the complete life cycle of demand-driven element data and fully implement metadata management. Improve the links between business, technology and operation metadata to provide support for process management of data quality issues. Establish support for automatic production of ETL scripts based on metadata changes.

[0093] Through the technical solution provided by the above embodiment of the present invention, through an intelligent mine system with data as the core, integration as the main line, and integrating panoramic real-time monitoring of mine status, comprehensive real-time insight into production execution, integrated coordination of business scheduling, real-time control of the overall operation and management, and data fusion integrated intelligent analysis, the group headquarters unified system, self-built system, production control system of each mine, safety monitoring system, personnel positioning system, risk pre-control system, and rubber-wheeled vehicle system are integrated with the coal mine data center; through the mine enterprise-level theme data view, the association fusion, exchange sharing, mining and analysis of heterogeneous data are realized to give full play to the value of data. It avoids the problems of multiple systems of coal mine units, large data volume, high and fast data real-time requirements, and complex data structure in traditional methods. Relying on the general PaaS platform and the coal industry model component library, with the support of coal industry application construction as the core, the coal mine cloud computing data center is constructed to realize the resourceization of coal sector data, and provide support for the construction of industrial applications such as global production monitoring, multi-level business supervision, production process optimization, and upstream and downstream ecological collaboration.

[0094] That is, the above technical solutions provided by the embodiments of the present invention comprehensively consider various factors and solve the following technical problems: 1) Data center, in compliance with the data standards of the coal industry, normalizes the data, realizes automatic data reporting, and provides accurate data sources for projects such as the intelligent integrated management and control system of mines. Provide accurate and unified data sources. 2) Fusion and sharing services between mine systems, group master data systems and business systems to data center systems, standardized basic services such as horizontal integration and interconnection, vertical collaborative intercommunication, and data consistency between systems, support data penetration, integration and sharing between systems, and realize intelligent interconnection. Support data penetration, integration and sharing between systems. 3) Mining area data center, real-time dynamic monitoring and transparent monitoring of each link of coal production, washing, transportation, and sales, give full play to the support and promotion of coal production big data assets to the business, effectively improve the safety production and operation level of enterprises, and improve the safety production and operation level of mining areas. 4) The intelligent integrated mine management and control system, the data, business data and master data of each coal mine, in accordance with the data governance standards of the corporate headquarters, gathers the real-time data of the control system, the master data of the corporate headquarters and the business data of the subsidiary companies and factories and mines’ self-built systems, and displays the panoramic data view of the coal mine; provides data sharing and distribution through the coal mine data center, and provides standard data for the corporate headquarters, subsidiary companies, factories and mines and local applications. Support the production operation of the mining area and the integrated production operation of the subsidiary companies, and provide strong support for the intelligent development of coal mines.

[0095] It should be noted that, for the aforementioned method embodiments, for the sake of simplicity, they are all expressed as a series of action combinations, but those skilled in the art should be aware that the present application is not limited by the described order of actions, because according to the present application, certain steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all preferred embodiments, and the actions and modules involved are not necessarily required by the present application.

[0096] Through the description of the above implementation methods, those skilled in the art can clearly understand that the method according to the above embodiment can be implemented by means of software plus a necessary general hardware platform, and of course by hardware, but in many cases the former is a better implementation method. Based on such an understanding, the technical solution of the present application, or the part that contributes to the prior art, can be embodied in the form of a software product, which is stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk), and includes a number of instructions for a terminal device (which can be a mobile phone, computer, server, or network device, etc.) to execute the methods of each embodiment of the present application.

[0097] According to an embodiment of the present invention, a device for processing multi-source heterogeneous data in a coal mine for implementing the above-mentioned method for processing multi-source heterogeneous data in a coal mine is also provided. Fig.13is a schematic diagram of a device for processing multi-source heterogeneous data in a coal mine according to an embodiment of the present invention. Fig.13 As shown, the device includes: a first acquisition module 1301, a push module 1303, an integration module 1305, a first processing module 1307 and a providing module 1309. The risk analysis device in the operation process of the power grid is described below.

[0098] The first acquisition module 1301 is used to acquire first data of the unified system of the target coal mining enterprise and second data of the self-built systems of the branches and subsidiaries of the target coal mining enterprise.

[0099] The push module 1303 is used to push the first data and the second data to a data center, wherein the data center is a data storage center deployed in a computer room of a branch or subsidiary.

[0100] The integration module 1305 is used to integrate the first data and the second data in the data center to obtain integrated data.

[0101] The first processing module 1307 is used to process the integrated data by using the data access method of multi-source heterogeneous data to obtain processed integrated data.

[0102] A module 1309 is provided, which is used to provide the processed integrated data of the target coal mining enterprise to the third-party system through the data center.

[0103] It should be noted here that the above-mentioned first acquisition module 1301, push module 1303, integration module 1305, first processing module 1307 and providing module 1309 correspond to steps S202 to S210 in the above-mentioned embodiments, and the five modules are the same as the instances and application scenarios implemented by the corresponding steps, but are not limited to the contents disclosed in the above-mentioned embodiments.

[0104] As can be seen from the above, in the scheme recorded in the above-mentioned embodiment of the present invention, firstly, the first acquisition module can be used to obtain the first data of the unified system of the target coal mining enterprise and the second data of the self-built system of the branch and subsidiary of the target coal mining enterprise; then the push module can be used to push the first data and the second data to the data center, wherein the data center is a data storage center deployed in the computer room of the branch and subsidiary; secondly, the integration module can be used to integrate the first data and the second data in the data center to obtain integrated data; then the first processing module can be used to process the integrated data using the data access method of multi-source heterogeneous data to obtain processed integrated data; finally, the providing module can be used to provide the processed integrated data of the target coal mining enterprise to the third-party system through the data center, so as to achieve the goal of integrating the unified system of the group headquarters, the self-built system, the production control system of each mine, the safety monitoring system, the personnel positioning system, the risk pre-control system, and the rubber-wheeled vehicle system with the coal mine data center through the intelligent mining system, and at the same time, the data is standardized, the coal production is monitored dynamically and transparently in real time, and the purpose of displaying the panoramic data view of the coal mine is achieved, thereby realizing the resourceization of coal sector data, the association fusion, exchange sharing, mining and analysis of heterogeneous data, and the technical effect of giving play to the value of data, and improving the efficiency of data sharing and transmission.

[0105] The technical solution provided by the embodiment of the present invention solves the technical problem in the related art that coal mine data is scattered in various business systems, there is no direct communication channel, and there are certain difficulties in sharing data externally.

[0106] In an optional embodiment, the push module includes: a first determination unit, used to determine the first field that the self-built system needs to enter the data center based on current system information 1 of the integrated system; a second determination unit, used to determine the second field that the self-built system needs to enter the data center based on current system information 2 of the self-built system; and a first push unit, used to push the first data and the second data to the data center based on the first field and the second field.

[0107] In an optional embodiment, the first push unit includes: an encoding subunit, used to encode each employee data corresponding to the first field according to a predetermined encoding method to obtain the encoded first data; an updating subunit, used to update the encoded first data according to a predetermined period using a webservice interface method to obtain the updated first data; and a first pushing subunit, used to push the updated first data to a data center.

[0108] In an optional embodiment, the first pushing unit includes: a first creation subunit, used to create a first data table of the self-built system and a data field of the self-built system according to the second field; a second creation subunit, used to create a corresponding view in the data center according to the first data table and the data field, so that the second data is pushed to the data center.

[0109] In an optional embodiment, the first push unit includes: a configuration subunit, which is used to perform data source configuration, collector configuration and task scheduling configuration for each business system in the self-built system to obtain configuration information; a generation subunit, which is used to generate a scheduling task according to the configuration information; and a second push subunit, which is used to push the second data of each business system to the data center according to the second field according to the scheduling task.

[0110] In an optional embodiment, the processing device for multi-source heterogeneous data in the coal mine also includes: a second processing module, which is used to obtain measurement point data from a host computer when there is a host computer in the production system of the target coal mine enterprise, and convert the measurement point data into production system data through a protocol; a third processing module, which is used to obtain measurement point data from the underlying equipment of the target coal mine enterprise through a programmable logic controller (PLC) protocol when there is no host computer in the production system of the target coal mine enterprise, and convert the measurement point data into production system data through a protocol.

[0111] In an optional embodiment, a module is provided, including: a second push unit, which is used to control the data center to push the integrated data to the third-party system through the webservice interface for processing after detecting a data call instruction during the process of the third-party system monitoring the webservice interface.

[0112] According to another aspect of an embodiment of the present invention, a system for processing multi-source heterogeneous data in a coal mine is provided. The system for processing multi-source heterogeneous data in a coal mine uses any one of the above-mentioned methods for processing multi-source heterogeneous data in a coal mine.

[0113] According to another aspect of an embodiment of the present invention, a processor is provided, and the processor is used to run a program, wherein when the program is run, any one of the above-mentioned methods for processing multi-source heterogeneous data in a coal mine is executed.

[0114] According to another aspect of an embodiment of the present invention, a computer program product is provided, including computer instructions, which, when executed by a processor, execute any one of the above-mentioned methods for processing multi-source heterogeneous data in a coal mine.

[0115] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is provided, the computer-readable storage medium including a stored program, wherein the program executes any one of the above-mentioned methods for processing multi-source heterogeneous data in a coal mine.

[0116] Optionally, in this embodiment, the computer-readable storage medium may be located in any one of the computer terminals in a computer terminal group in a computer network, or in any one of the communication devices in a communication device group.

[0117] Optionally, in this embodiment, the computer-readable storage medium is configured to store program codes for executing the following steps: obtaining first data of the unified system of the target coal mining enterprise and second data of the self-built system of the branch or subsidiary of the target coal mining enterprise; pushing the first data and the second data to a data center, wherein the data center is a data storage center deployed in a computer room of the branch or subsidiary; integrating the first data and the second data in the data center to obtain integrated data; processing the integrated data using a data access method for multi-source heterogeneous data to obtain processed integrated data; and providing the processed integrated data of the target coal mining enterprise to a third-party system through the data center.

[0118] Optionally, in this embodiment, the computer-readable storage medium is configured to store program codes for executing the following steps: determining a first field that the self-built system needs to enter into the data center based on current system information one of the integrated system; determining a second field that the self-built system needs to enter into the data center based on current system information two of the self-built system; and pushing the first data and the second data to the data center based on the first field and the second field.

[0119] Optionally, in this embodiment, the computer-readable storage medium is configured to store program codes for executing the following steps: encoding each employee data corresponding to the first field according to a predetermined encoding method to obtain the encoded first data; updating the encoded first data according to a predetermined period using a webservice interface method to obtain updated first data; and pushing the updated first data to a data center.

[0120] Optionally, in this embodiment, the computer-readable storage medium is configured to store program code for performing the following steps: creating a first data table of the self-built system and a data field of the self-built system based on the second field; creating a corresponding view in the data center based on the first data table and the data field so that the second data is pushed to the data center.

[0121] Optionally, in this embodiment, the computer-readable storage medium is configured to store program code for executing the following steps: performing data source configuration, collector configuration and task scheduling configuration for each business system in the self-built system to obtain configuration information; generating a scheduling task based on the configuration information; and pushing the second data of each business system to the data center according to the second field according to the scheduling task.

[0122] Optionally, in this embodiment, the computer-readable storage medium is configured to store program codes for executing the following steps: in a case where there is a host computer in the production system of the target coal mining enterprise, obtaining measurement point data from the host computer, and converting the measurement point data into production system data through a protocol; in a case where there is no host computer in the production system of the target coal mining enterprise, obtaining measurement point data from the underlying equipment of the target coal mining enterprise through a programmable logic controller (PLC) protocol, and converting the measurement point data into production system data through a protocol.

[0123] Optionally, in this embodiment, the computer-readable storage medium is configured to store program code for executing the following steps: when the third-party system monitors the webservice interface, after detecting the data call instruction, the control data center pushes the integrated data to the third-party system through the webservice interface for processing.

[0124] The serial numbers of the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.

[0125] In the above embodiments of the present invention, the description of each embodiment has its own emphasis. For parts that are not described in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0126] In the several embodiments provided in this application, it should be understood that the disclosed technical content can be implemented in other ways. Among them, the device embodiments described above are only schematic. For example, the division of the units can be a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of units or modules, which can be electrical or other forms.

[0127] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple units. Some or all of the units may be selected according to actual needs to achieve the purpose of the present embodiment.

[0128] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.

[0129] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions for a computer device (which can be a personal computer, a server or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: U disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), mobile hard disk, magnetic disk or optical disk and other media that can store program codes.

[0130] The above is only a preferred embodiment of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principle of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A method for processing multi-source heterogeneous data in a coal mine, characterized in that: include: Acquire first data of a unified system of a target coal mining enterprise and second data of a self-built system of a branch or subsidiary of the target coal mining enterprise; Pushing the first data and the second data to a data center, wherein the data center is a data storage center deployed in a computer room of the branch company; Integrating the first data and the second data in the data center to obtain integrated data; Processing the integrated data using a data access method for multi-source heterogeneous data to obtain the processed integrated data; The processed integrated data of the target coal mining enterprise is provided to a third-party system through the data center.

2. The method for processing multi-source heterogeneous data in a coal mine according to claim 1, characterized in that: Pushing the first data and the second data to a data center includes: Determine, according to the current system information of the integrated system, the first field of the data center that the self-built system needs to enter; Determining, according to current system information 2 of the self-built system, that the self-built system needs to enter a second field of the data center; The first data and the second data are pushed to the data center according to the first field and the second field.

3. The method for processing multi-source heterogeneous data in a coal mine according to claim 2, characterized in that: Pushing the first data to the data center according to the first field includes: Encode each employee data corresponding to the first field according to a predetermined encoding method to obtain the encoded first data; Using a webservice interface to update the encoded first data according to a predetermined period to obtain updated first data; The updated first data is pushed to the data center.

4. The method for processing multi-source heterogeneous data in a coal mine according to claim 2, characterized in that: Pushing the second data to the data center according to the second field includes: Creating a first data table of the self-built system and a data field of the self-built system according to the second field; A corresponding view is created in the data center according to the first data table and the data field, so that the second data is pushed to the data center.

5. The method for processing multi-source heterogeneous data in coal mines according to claim 2, characterized in that: Pushing the second data to the data center according to the second field includes: Perform data source configuration, collector configuration and task scheduling configuration on each business system in the self-built system to obtain configuration information; Generate a scheduling task according to the configuration information; According to the scheduling task, the second data of each business system is pushed to the data center according to the second field.

6. The method for processing multi-source heterogeneous data in a coal mine according to claim 1, characterized in that: Also includes: In the case where a host computer exists in the production system of the target coal mining enterprise, measuring point data is obtained from the host computer, and the measuring point data is converted into production system data through a protocol; In the case that there is no host computer in the production system of the target coal mining enterprise, the measuring point data is obtained from the underlying equipment of the target coal mining enterprise through the programmable logic controller (PLC) protocol, and the measuring point data is converted through the protocol to obtain the production system data.

7. The method for processing multi-source heterogeneous data in a coal mine according to claim 1, characterized in that: Providing the processed integrated data of the target coal mining enterprise to a third-party system through the data center includes: When the third-party system monitors the webservice interface and detects a data call instruction, the control data center pushes the integrated data to the third-party system for processing through the webservice interface.

8. A device for processing multi-source heterogeneous data in a coal mine, characterized in that: include: A first acquisition module is used to acquire first data of a unified system of a target coal mining enterprise and second data of a self-built system of a branch or subsidiary of the target coal mining enterprise; A push module, used to push the first data and the second data to a data center, wherein the data center is a data storage center deployed in a computer room of the branch company; An integration module, configured to integrate the first data and the second data in the data center to obtain integrated data; A first processing module, configured to process the integrated data using a data access method for multi-source heterogeneous data to obtain the processed integrated data; A module is provided, for providing the processed integrated data of the target coal mining enterprise to a third-party system through the data center.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium includes a stored program, wherein the program executes the method for processing multi-source heterogeneous data in a coal mine as described in any one of claims 1 to 7.

10. A computer program product comprising computer instructions, characterized in that: When the computer instructions are executed by the processor, the method for processing multi-source heterogeneous data in a coal mine as described in any one of claims 1 to 7 is performed.

Images