Method for realizing data integration of oily water treatment system and data base

Abstract

The invention relates to a method for realizing data integration of an oily water treatment system and a data base. The method comprises the following steps: acquiring oily water data stored in the data base; identifying the treatment process type and the technical characteristic type of the oily water treatment system, and collecting the type characteristics of the oily water treatment system; inputting the type characteristics and the oily water data into a data processing model and a transmission protocol matching model; and establishing a bidirectional data transmission channel between the oily water treatment system and the data base based on the matched data transmission protocol. According to the method, the treatment process type characteristics and the technical characteristic type characteristics of the oily water treatment system which is subjected to data integration in advance are collected, and based on the type characteristics and the oily water data, corresponding data format conversion is performed on the oily water data, and a corresponding data transmission protocol is matched to establish a bidirectional data transmission channel; the method has the effect of improving the flexibility and adaptability of data integration of the oily water treatment system and the data base.

Description

Technical Field

[0001] The present application relates to the technical field of data integration, and in particular to a method for realizing data integration between an oily wastewater treatment system and a data base. Background Art

[0002] The oily wastewater treatment system is an important part of the modern industrial environmental protection field. It is mainly responsible for treating and purifying oily wastewater to ensure that the discharged water quality meets environmental protection standards. The oily wastewater treatment system usually includes a variety of treatment processes, such as physical separation, chemical treatment and biodegradation, to adapt to oily wastewater of different sources and properties. With the development of industry and the improvement of environmental protection requirements, the oily wastewater treatment system is gradually evolving towards intelligence and efficiency.

[0003] As a platform for centralized storage and processing of data, the data base can provide powerful data support and analysis capabilities for the oily wastewater treatment system. However, in the current field of oily wastewater treatment, there is a lack of an efficient and comprehensive data integration method with the data base. Specifically, the existing data integration methods are often designed for specific systems or scenarios and lack sufficient flexibility to adapt to the needs of different oily wastewater treatment systems. When the system type, treatment process or operating environment changes, the existing integration solution may not work effectively. Summary of the invention

[0004] In order to improve the flexibility and adaptability of data integration between an oily wastewater treatment system and a data base, the present application provides a method for implementing data integration between an oily wastewater treatment system and a data base.

[0005] The above-mentioned invention objective of the present application is achieved through the following technical solutions:

[0006] A method for realizing data integration between an oily wastewater treatment system and a data base comprises the steps of:

[0007] Obtain the oily wastewater data stored in the data base;

[0008] Identify the treatment process type and technical characteristics of the oily wastewater treatment system, and collect its type characteristics;

[0009] Input the type characteristics and oily wastewater data into a pre-built data processing model so that the model can convert the data format of the oily wastewater data based on the type characteristics;

[0010] Input the oily wastewater data after type characteristics and data format conversion into a pre-built transmission protocol matching model, so that the oily wastewater data after type characteristics and data format conversion matches the preset corresponding data transmission protocol;

[0011] A two-way data transmission channel between the oily wastewater treatment system and the data base is established based on the matched data transmission protocol.

[0012] By adopting the above technical scheme, oily sewage data related to oily sewage is obtained from the data base, the treatment process type and technical characteristic type of the oily sewage treatment system for data integration are identified, and the corresponding type characteristics are collected, and the type characteristics and the oily sewage data are input into a pre-built data processing model so that it performs corresponding data format conversion on the oily sewage data, so as to realize data docking between different systems; the oily sewage data after the type characteristics and data format conversion are input into a pre-built transmission protocol matching model so that it matches the preset corresponding data transmission protocol based on the type characteristics to ensure accurate data transmission; a two-way data transmission channel between the oily sewage treatment system and the data base is established based on the matched data transmission protocol, thereby realizing data integration of the oily sewage system and the data base; the present application collects the treatment process type characteristics and technical characteristic type characteristics of the oily sewage treatment system for data integration, and based on the type characteristics and the oily sewage data, performs corresponding data format conversion on the oily sewage data and matches the corresponding data transmission protocol to establish a two-way data transmission channel, which has the effect of improving the flexibility and adaptability of data integration between the oily sewage treatment system and the data base.

[0013] In a preferred example, the present application may be further configured as follows: after the step of establishing a bidirectional data transmission channel between the oily wastewater treatment system and the data base based on the matched data transmission protocol, the following steps are performed:

[0014] The heartbeat detection mechanism is deployed in the two-way data transmission channel, so as to receive the heartbeat signal responded by the data base and the oily wastewater treatment system at a preset frequency;

[0015] When any of the data base and the oily wastewater treatment system responds abnormally, the abnormal type is identified and the fault detection mechanism is triggered based on the abnormal type;

[0016] Execute the corresponding fault recovery process based on the fault detection mechanism results.

[0017] By adopting the above technical solution, after the two-way data transmission channel is established, in order to ensure the stability of the channel and the continuous transmission of data, a heartbeat detection mechanism is deployed in the two-way data transmission channel, so that a heartbeat signal is sent to the data base and the oily wastewater treatment system at a preset frequency, and they are required to respond. The online status and response capabilities of the two systems are monitored by receiving the responded heartbeat signal. During the heartbeat detection process, if the response of the data base or the oily wastewater treatment system is found to be abnormal, such as the loss of the heartbeat signal, delayed response or incorrect response content, the abnormal type is identified, and according to the different abnormal types, the corresponding fault detection mechanism is triggered to further analyze the cause and scope of the problem. After the fault detection mechanism completes the analysis, the corresponding fault recovery process is executed according to the detection result; by detecting the abnormality based on the heartbeat detection mechanism and executing the corresponding fault recovery process, the problems in the data transmission channel are solved in time, ensuring that the data interaction between the oily wastewater treatment system and the data base is not affected, and improving the overall stability and availability of the system. At the same time, it also reduces the risk of data loss or processing delay caused by system failure, and ensures the efficiency and accuracy of oily wastewater treatment.

[0018] In a preferred example, the present application can be further configured as follows: the step of obtaining the oily wastewater data stored in the data base includes the steps of:

[0019] Identify a preset data requirement tag of the oily wastewater treatment system, wherein the data requirement tag includes a time requirement tag and a frequency requirement tag;

[0020] Based on the data demand tag, the original data of oily wastewater stored in the data base is obtained, wherein the original data of oily wastewater includes real-time monitoring data, historical processing data and real-time environmental parameters;

[0021] The raw data of oily wastewater is preprocessed to obtain oily wastewater data.

[0022] By adopting the above technical solution, the preset data requirement tags of the oily wastewater treatment system are identified, which include the requirements for obtaining historical time and frequency. The original data of the oily wastewater stored in the data base is obtained based on the data requirement tags, and the data is preprocessed to obtain the oily wastewater data. By obtaining the original data of the oily wastewater based on the historical time requirements and frequency requirements and performing corresponding preprocessing, the quality and availability of the data are improved, ensuring that the subsequent data processing and analysis results are more accurate.

[0023] In a preferred example, the present application can be further configured as follows: the type feature includes a treatment process feature and a technical characteristic feature, and the step of identifying the treatment process type and technical characteristic type of the oily wastewater treatment system and collecting its type feature includes the steps of:

[0024] Obtaining system parameter characteristics of the oily wastewater treatment system, thereby identifying its treatment process type, wherein the treatment process type includes a physical process type, a chemical process type, a biological process type, and a combined process type;

[0025] Obtaining technical characteristic parameters of the oily wastewater treatment system and comparing them with preset technical characteristic indicators, thereby identifying its technical characteristic type, wherein the technical characteristic type includes the degree of automation and the degree of environmental adaptability;

[0026] Based on the preset collection strategy, the treatment process characteristics and technical characteristics of the oily wastewater treatment system are collected respectively.

[0027] By adopting the above technical scheme, the system parameter characteristics of the oily wastewater treatment system are obtained to identify its treatment process type, the technical characteristic parameters of the oily wastewater treatment system are obtained and compared with the preset technical characteristic indicators to identify its technical characteristic type, and the treatment process characteristics and technical characteristic characteristics of the oily wastewater treatment system are collected based on the preset collection strategy.

[0028] In a preferred example, the present application can be further configured as follows: the system parameter characteristics include equipment parameter characteristics and drug information characteristics, and the steps of obtaining the system parameter characteristics of the oily wastewater treatment system to identify its treatment process type, wherein the treatment process type includes a physical process type, a chemical process type, a biological process type, and a combined process type, include the steps of:

[0029] Collect equipment parameter characteristics of oily wastewater treatment system;

[0030] Obtain historical drug information of the oily wastewater treatment system and extract drug information features;

[0031] The equipment parameter characteristics and drug information characteristics are input into the pre-trained type recognition model to identify the processing type.

[0032] By adopting the above technical scheme, the equipment parameter characteristics of the oily wastewater treatment system are collected to obtain a preliminary understanding of the equipment used in the oily wastewater treatment system and its performance, obtain the historical drug information of the oily wastewater treatment system, and extract its drug information characteristics based on the historical drug information, and input the equipment parameter characteristics and drug information characteristics into a pre-trained type recognition model for treatment process type identification; by inputting the equipment parameter characteristics and drug information characteristics into a pre-trained type recognition model for treatment process type identification, the treatment process type adopted by the oily wastewater treatment system can be accurately and quickly determined, which provides strong support for subsequent data format conversion and transmission protocol matching, and helps to improve the system's processing efficiency and operational stability.

[0033] In a preferred example, the present application can be further configured as follows: the transmission protocol matching model includes an identification layer and a matching layer, and the step of inputting the oily wastewater data after type characteristics and data format conversion into a pre-built transmission protocol matching model so that the oily wastewater data after type characteristics and data format conversion matches the preset corresponding data transmission protocol includes the steps of:

[0034] The recognition layer identifies the input type characteristics and the transmission requirement characteristics of the oily wastewater data after data format conversion;

[0035] The matching layer matches the corresponding preset data transmission protocol based on the transmission requirement characteristics.

[0036] By adopting the above technical solution, the transmission protocol matching model includes an identification layer and a matching layer. The identification layer identifies the input type characteristics and the transmission requirements of the oily wastewater data after data format conversion, thereby obtaining the transmission requirement characteristics. The matching layer matches the corresponding preset transmission protocol based on the transmission requirement characteristics to meet the type characteristics and the transmission requirements of the oily wastewater data, thereby meeting the transmission requirements of the data base and the oily wastewater system.

[0037] The second object of the invention is achieved by the following technical solutions:

[0038] A system for realizing data integration between an oily wastewater treatment system and a data base, comprising:

[0039] A data acquisition module, used to acquire the oily wastewater data stored in the data base;

[0040] Type identification module, used to identify the treatment process type and technical characteristic type of the oily wastewater treatment system, and collect its type characteristics;

[0041] A data input module is used to input the type characteristics and oily wastewater data into a pre-built data processing model so that the model can perform data format conversion on the oily wastewater data based on the type characteristics;

[0042] A feature input module is used to input the type features and the oily wastewater data after data format conversion into a pre-built transmission protocol matching model, so that the oily wastewater data after type features and data format conversion matches the preset corresponding data transmission protocol based on the model;

[0043] The transmission channel establishment module is used to establish a two-way data transmission channel between the oily wastewater treatment system and the data base based on the matched data transmission protocol.

[0044] By adopting the above technical scheme, a data acquisition module is used to acquire the oily wastewater data stored in the data base; a type identification module is used to identify the treatment process type and technical characteristic type of the oily wastewater treatment system, and collect its type characteristics; a data input module is used to input the type characteristics and the oily wastewater data into a pre-built data processing model, so that it can convert the data format of the oily wastewater data based on the type characteristics; a feature input module is used to input the type characteristics and the oily wastewater data after the data format conversion into a pre-built transmission protocol matching model, so that the oily wastewater data after the type characteristics and the data format conversion is matched with the preset corresponding data transmission protocol based on the type characteristics and the data format conversion; a transmission channel establishment module is used to establish a two-way data transmission channel between the oily wastewater treatment system and the data base based on the matched data transmission protocol.

[0045] In a preferred example, the present application can be further configured as follows:

[0046] A heartbeat deployment module is used to deploy the heartbeat detection mechanism in a two-way data transmission channel, thereby receiving the heartbeat signal responded by the data base and the oily sewage treatment system at a preset frequency;

[0047] A fault detection module is used to identify the abnormality type and trigger the fault detection mechanism based on the abnormality type when either the data base or the oily wastewater treatment system responds abnormally;

[0048] The fault recovery module is used to execute the corresponding fault recovery process based on the fault detection mechanism results.

[0049] By adopting the above technical solution, a heartbeat deployment module is provided, which is used to deploy the heartbeat detection mechanism in a two-way data transmission channel, so as to receive the heartbeat signals responded by the data base and the oily wastewater treatment system at a preset frequency; a fault detection module is provided, which is used to identify the abnormality type and trigger the fault detection mechanism based on the abnormality type when either the data base or the oily wastewater treatment system responds abnormally; and a fault recovery module is provided, which is used to execute the corresponding fault recovery process based on the result of the fault detection mechanism.

[0050] In summary, the present application includes at least one of the following beneficial technical effects:

[0051] 1. This application collects the processing process type characteristics and technical characteristics type characteristics of the oily sewage treatment system for data integration, and based on the type characteristics and oily sewage data, performs corresponding data format conversion on the oily sewage data and matches the corresponding data transmission protocol to establish a two-way data transmission channel, which has the effect of improving the flexibility and adaptability of data integration between the oily sewage treatment system and the data base;

[0052] 2. By detecting anomalies based on the heartbeat detection mechanism and executing the corresponding fault recovery process, problems in the data transmission channel can be solved in a timely manner to ensure that the data interaction between the oily wastewater treatment system and the data base is not affected, thereby improving the overall stability and availability of the system. At the same time, it also reduces the risk of data loss or processing delays caused by system failures, and ensures the efficiency and accuracy of oily wastewater treatment;

[0053] 3. By inputting the equipment parameter characteristics and drug information characteristics into the pre-trained type recognition model for treatment process type recognition, the treatment process type adopted by the oily wastewater treatment system can be accurately and quickly determined, which provides strong support for subsequent data format conversion and transmission protocol matching, and helps to improve the system's processing efficiency and operational stability. BRIEF DESCRIPTION OF THE DRAWINGS

[0054] Figure 1 This is a flow chart of an embodiment of a method for realizing data integration between an oily wastewater treatment system and a data base in the present application;

[0055] Figure 2 This is a flowchart of an implementation after step S50 in an embodiment of a method for implementing data integration between an oily wastewater treatment system and a data base in the present application;

[0056] Figure 3 This is a flowchart of step S10 in an embodiment of a method for realizing data integration between an oily wastewater treatment system and a data base in the present application;

[0057] Figure 4 This is a flowchart of step S20 in an embodiment of a method for realizing data integration between an oily wastewater treatment system and a data base in the present application;

[0058] Figure 5 It is a flow chart for implementing step S21 in an embodiment of a method for implementing data integration between an oily wastewater treatment system and a data base in the present application. DETAILED DESCRIPTION

[0059] The following is combined with Figure 1-5 This application is described in further detail.

[0060] In one embodiment, if Figure 1 As shown, the present application discloses a method for realizing data integration between an oily wastewater treatment system and a data base, which specifically includes the following steps:

[0061] S10: Obtaining the oily wastewater data stored in the data base;

[0062] In this embodiment, the data base is an infrastructure for storing, managing and processing data; the oily wastewater data is the relevant data generated during the oily wastewater treatment process;

[0063] Specifically, oily wastewater data related to oily wastewater is obtained from a data base;

[0064] S20: Identify the treatment process type and technical characteristic type of the oily wastewater treatment system, and collect its type characteristics;

[0065] In this embodiment, the treatment process type is the specific treatment method or technology adopted by the oily wastewater treatment system, including physical treatment (such as sedimentation, filtration), chemical treatment (such as coagulation, oxidation) and biological treatment (such as activated sludge method), etc.; the technical characteristic type is the characteristics of the specific technology or equipment adopted by the oily wastewater treatment system, including the degree of automation and the degree of environmental adaptability; the type characteristics are the characteristic parameters and indicators that represent or describe the treatment process type and the technical characteristic type;

[0066] Specifically, identify the treatment process type and technical characteristic type of the oily wastewater treatment system for data integration, and collect its corresponding type characteristics;

[0067] S30: inputting the type characteristics and the oily wastewater data into a pre-built data processing model so that the model performs data format conversion on the oily wastewater data based on the type characteristics;

[0068] In this embodiment, the data processing model is a mathematical model for processing, analyzing and converting oily wastewater data, specifically for converting data into a format based on type features for use in subsequent data transmission and analysis;

[0069] Furthermore, the data processing model establishes data mapping for the oily wastewater data before data format conversion and the oily wastewater data after data format conversion;

[0070] Specifically, the type characteristics and oily wastewater data are input into a pre-built data processing model so that the model can convert the oily wastewater data into a corresponding data format, so as to achieve data docking between different systems;

[0071] S40: inputting the oily wastewater data after type characteristics and data format conversion into a pre-built transmission protocol matching model, so that the oily wastewater data after type characteristics and data format conversion is matched with a preset corresponding data transmission protocol based on the model;

[0072] In this embodiment, the transmission protocol matching model is a model used to match the preset corresponding data transmission protocol according to the type characteristics, specifically used to select a suitable data transmission protocol according to the treatment process type and technical characteristic type to ensure accurate, efficient and reliable data transmission; the data transmission protocol is a protocol used to specify the format, encoding, synchronization, error handling and other rules of data during the transmission process, specifically used to ensure that the data between the oily wastewater treatment system and the data base can be accurately and efficiently transmitted and exchanged;

[0073] Specifically, the oily wastewater data after type characteristics and data format conversion are input into a pre-built transmission protocol matching model, so that it matches the preset corresponding data transmission protocol based on the type characteristics to ensure accurate data transmission;

[0074] S50: establishing a bidirectional data transmission channel between the oily wastewater treatment system and the data base based on the matched data transmission protocol;

[0075] In this embodiment, the bidirectional data transmission channel is a channel that can support bidirectional data transmission between two systems or devices, specifically used to realize real-time data exchange and sharing between the oily wastewater treatment system and the data base, so as to perform data monitoring, analysis and optimization operations;

[0076] Specifically, a two-way data transmission channel between the oily wastewater treatment system and the data base is established based on the matched data transmission protocol.

[0077] In one embodiment, if Figure 2 As shown, after step S50, the following steps are performed:

[0078] S60: deploying a heartbeat detection mechanism in a bidirectional data transmission channel, thereby receiving heartbeat signals responded by the data base and the oily wastewater treatment system at a preset frequency;

[0079] S70: When any one of the data base and the oily wastewater treatment system responds abnormally, identifying the abnormality type and triggering a fault detection mechanism based on the abnormality type;

[0080] S80: Execute the corresponding fault recovery process based on the fault detection mechanism result;

[0081] In this embodiment, the heartbeat detection mechanism is a mechanism for monitoring and detecting whether the network connection or system status is normal. It confirms the survival status of the connection or system by regularly sending and receiving specific signals (called "heartbeat signals"). If the expected heartbeat signal is not received within a period of time, it is considered that the connection or system is abnormal; the abnormal type is the abnormal connection or system status detected during the heartbeat detection process, including network disconnection, device failure, and data error; the fault detection mechanism is a mechanism for detecting and analyzing the cause of system failure. When the heartbeat detection mechanism identifies an abnormality, the fault detection mechanism is triggered to further diagnose and analyze the fault to determine the specific cause and location of the fault; the fault recovery process is the measures taken to restore the normal operation of the system after a system failure is detected, including restarting the device, repairing the network connection, and restoring data backup;

[0082] Specifically, after the two-way data transmission channel is established, in order to ensure the stability of the channel and the continuous transmission of data, a heartbeat detection mechanism is deployed in the two-way data transmission channel, so that a heartbeat signal is sent to the data base and the oily wastewater treatment system at a preset frequency, and they are required to respond. The online status and response capabilities of the two systems are monitored by receiving the responded heartbeat signal. During the heartbeat detection process, if the response of the data base or the oily wastewater treatment system is found to be abnormal, such as the loss of the heartbeat signal, delayed response or incorrect response content, the abnormal type is identified, and according to the different abnormal types, the corresponding fault detection mechanism is triggered to further analyze the cause and scope of the problem. After the fault detection mechanism completes the analysis, the corresponding fault recovery process is executed according to the detection results; by detecting abnormalities based on the heartbeat detection mechanism and executing the corresponding fault recovery process, problems in the data transmission channel are solved in a timely manner, ensuring that the data interaction between the oily wastewater treatment system and the data base is not affected, and improving the overall stability and availability of the system. At the same time, it also reduces the risk of data loss or processing delays due to system failures, and ensures the efficiency and accuracy of oily wastewater treatment.

[0083] In one embodiment, if Figure 3 As shown, step S10 includes the steps of:

[0084] S11: Identify a preset data requirement tag for the oily wastewater treatment system, wherein the data requirement tag includes a time requirement tag and a frequency requirement tag;

[0085] S12: acquiring the original data of the oily wastewater stored in the data base based on the data demand tag, wherein the original data of the oily wastewater includes real-time monitoring data, historical processing data and real-time environmental parameters;

[0086] S13: pre-processing the original data of oily wastewater to obtain oily wastewater data;

[0087] In this embodiment, the data requirement tag is a tag used to describe the data type, time range and frequency required by the oily sewage treatment system, specifically including a time requirement tag (used to specify the time range of the required data) and a frequency requirement tag (used to specify the frequency of data update); the raw data of oily sewage is the unprocessed or preliminarily processed data generated in the process of oily sewage treatment, including real-time monitoring data (such as real-time parameters such as sewage flow, composition, temperature, etc.), historical processing data (such as data records generated in the past processing process) and real-time environmental parameters (such as ambient temperature, humidity, air pressure, etc. at the treatment site); preprocessing is the preliminary processing of data before further analysis or processing of the data; oily sewage data is the data used for analysis and processing of the oily sewage treatment system after preprocessing;

[0088] Specifically, identify the data requirement tags preset in the oily wastewater treatment system, which include the requirements for obtaining historical time and frequency, obtain the original data of the oily wastewater stored in the data base based on the data requirement tags, and preprocess it to obtain the oily wastewater data; by obtaining the original data of the oily wastewater based on historical time requirements and frequency requirements and performing corresponding preprocessing, the quality and availability of the data are improved, ensuring that the subsequent data processing and analysis results are more accurate.

[0089] In one embodiment, the type features include processing features and technical characteristics, such as Figure 4 As shown, step S20 includes the steps of:

[0090] S21: Obtaining system parameter characteristics of the oily wastewater treatment system, thereby identifying its treatment process type, wherein the treatment process type includes a physical process type, a chemical process type, a biological process type, and a combined process type;

[0091] S22: obtaining technical characteristic parameters of the oily wastewater treatment system and comparing them with preset technical characteristic indicators, thereby identifying its technical characteristic type, wherein the technical characteristic type includes the degree of automation and the degree of environmental adaptability;

[0092] S23: collecting treatment process characteristics and technical characteristics of the oily wastewater treatment system based on a preset collection strategy;

[0093] In this embodiment, the treatment process characteristics are characteristic parameters or indicators of the treatment process or method adopted by the oily wastewater treatment system, including the type, process, and equipment configuration of the treatment process; the technical characteristics are characteristic parameters or indicators of the technical characteristics or performance of the oily wastewater treatment system, including the automation level of the system and the degree of environmental adaptability, wherein the automation level of the system is preset to include high automation, medium automation, and low automation, and the environmental adaptability is preset to include strong environmental adaptability and weak environmental adaptability; the system parameter characteristics are the parameter characteristics of the drug information in each key device and key node in the oily wastewater treatment system, as well as the overall configuration and operation parameters of the system; the preset collection strategy is a preset collection method for collecting type characteristics that meet the requirements, including the time point, frequency, and storage format of the collection;

[0094] Specifically, the system parameter characteristics of the oily wastewater treatment system are obtained to identify its treatment process type, the technical characteristic parameters of the oily wastewater treatment system are obtained and compared with the preset technical characteristic indicators to identify its technical characteristic type, and the treatment process characteristics and technical characteristic characteristics of the oily wastewater treatment system are collected based on the preset collection strategy.

[0095] In one embodiment, the system parameter features include device parameter features and drug information features, such as Figure 5 As shown, step S21 includes the steps of:

[0096] S211: Collect equipment parameter characteristics of oily wastewater treatment system;

[0097] S212: Obtain historical drug information of the oily wastewater treatment system and extract drug information features;

[0098] S213: Inputting equipment parameter characteristics and drug information characteristics into a pre-trained type recognition model to perform process type recognition;

[0099] In this embodiment, the drug information feature is the relevant information of the chemical or biological agents used in the oily wastewater treatment process, including the name, composition, and dosage of the agent; the historical drug information is the record and information of the chemical or biological agents used in the past treatment process of the oily wastewater treatment system, including the use history, effect evaluation, and adjustment plan of the agent; the pre-trained type recognition model is a pre-trained machine learning model, which is used to process the input feature data and output the recognition result, specifically, it is used to process the equipment parameter features and the drug information features to identify the treatment process type of the oily wastewater treatment system;

[0100] Specifically, the equipment parameter characteristics of the oily wastewater treatment system are collected to gain a preliminary understanding of the equipment used in the oily wastewater treatment system and its performance, the historical drug information of the oily wastewater treatment system is obtained, and the drug information characteristics are extracted based on the historical drug information, and the equipment parameter characteristics and drug information characteristics are input into a pre-trained type recognition model for treatment process type identification; by inputting the equipment parameter characteristics and drug information characteristics into a pre-trained type recognition model for treatment process type identification, the treatment process type adopted by the oily wastewater treatment system can be accurately and quickly determined, which provides strong support for subsequent data format conversion and transmission protocol matching, and helps to improve the system's processing efficiency and operational stability.

[0101] In one embodiment, the transmission protocol matching model includes an identification layer and a matching layer, and step S40 includes the following steps:

[0102] S41: The recognition layer recognizes the input type characteristics and the transmission requirement characteristics of the oily wastewater data after the data format conversion;

[0103] S42: The matching layer matches a corresponding preset data transmission protocol based on the transmission requirement characteristics;

[0104] In this embodiment, the recognition layer is the first layer of the transmission protocol matching model, which is used to identify the input characteristics and the transmission requirement characteristics of the data. The transmission requirement characteristics are the input characteristics and the requirements of the data on the transmission environment and parameters, including data type requirements, data volume requirements, real-time requirements, and security requirements; the matching layer is a layer with a built-in transmission protocol library, which includes a variety of standard or preset customized data transmission protocols, which is used to match the corresponding appropriate data transmission protocol based on the transmission requirement characteristics identified by the recognition layer;

[0105] Furthermore, the transmission demand characteristics based on the processing technology characteristics and technical characteristics include:

[0106] The treatment process characteristics of the physical process type usually involve the physical process of oily wastewater treatment, including sedimentation, filtration, centrifugation, etc. Its transmission demand characteristics include: the data type requirements of sensor data, the data volume requirements based on monitoring frequency and accuracy, and the real-time requirements based on feedback and control accuracy;

[0107] The treatment process characteristics of chemical process types usually involve chemical reactions in the oily wastewater treatment process, including coagulation, oxidation, neutralization, etc. Its transmission demand characteristics include: data type requirements reflecting reactant concentrations, temperatures, Ph values, etc., data volume requirements based on monitoring and recording frequencies, and high real-time requirements;

[0108] The treatment process characteristics of biological process type usually involve biodegradation processes in the oily wastewater treatment process, including activated sludge method, biofilm method, etc. Its transmission demand characteristics include: data type requirements reflecting values ​​such as microbial activity, dissolved oxygen concentration, and organic matter content, data volume requirements based on monitoring frequency and accuracy, and real-time requirements based on adjustment frequency;

[0109] The treatment process characteristics of the combined process type usually involve the comprehensive treatment of oily wastewater treatment process by combining physical, chemical and biological processes. Its transmission demand characteristics include: data type requirements reflecting physical, chemical and biological parameters, large data volume requirements based on multiple process monitoring, and high real-time requirements based on the linkage and coordination of various processes;

[0110] The transmission requirements of the technical characteristics of high automation, medium automation and low automation include the corresponding preset data volume requirements and real-time requirements;

[0111] Similarly, the transmission requirements of the oily wastewater data after data format conversion include data type requirements based on the data format after data format conversion, data volume requirements based on the oily wastewater data volume, and real-time requirements that are the same as the type characteristics;

[0112] Furthermore, the transmission requirement characteristics also include anti-interference requirements, and the transmission requirement characteristics of the technical characteristics of strong environmental adaptability and weak environmental adaptability include corresponding preset data volume requirements, real-time requirements and anti-interference requirements;

[0113] Among them, the security requirements depend on the confidentiality requirements preset by the oily wastewater treatment system;

[0114] Specifically, the transmission protocol matching model includes an identification layer and a matching layer. The identification layer identifies the input type characteristics and the transmission requirements of the oily wastewater data after data format conversion, thereby obtaining the transmission requirement characteristics. The matching layer matches the corresponding preset transmission protocol based on the transmission requirement characteristics to meet the type characteristics and transmission requirements of the oily wastewater data, thereby meeting the transmission requirements of the data base and the oily wastewater system.

[0115] It should be understood that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0116] In one embodiment, a system for implementing data integration between an oily sewage treatment system and a data base is provided. The system for implementing data integration between an oily sewage treatment system and a data base corresponds one-to-one to a method for implementing data integration between an oily sewage treatment system and a data base in the above embodiment. The system for implementing data integration between an oily sewage treatment system and a data base includes:

[0117] A data acquisition module, used to acquire the oily wastewater data stored in the data base;

[0118] Type identification module, used to identify the treatment process type and technical characteristic type of the oily wastewater treatment system, and collect its type characteristics;

[0119] A data input module is used to input the type characteristics and oily wastewater data into a pre-built data processing model so that the model can perform data format conversion on the oily wastewater data based on the type characteristics;

[0120] A feature input module is used to input the oily wastewater data after type features and data format conversion into a pre-built transmission protocol matching model, so that the oily wastewater data after type features and data format conversion matches the preset corresponding data transmission protocol;

[0121] A transmission channel establishment module is used to establish a bidirectional data transmission channel between the oily wastewater treatment system and the data base based on the matched data transmission protocol;

[0122] Optionally, also include:

[0123] A heartbeat deployment module is used to deploy the heartbeat detection mechanism in a two-way data transmission channel, thereby receiving the heartbeat signal responded by the data base and the oily sewage treatment system at a preset frequency;

[0124] A fault detection module is used to identify the abnormality type and trigger the fault detection mechanism based on the abnormality type when either the data base or the oily wastewater treatment system responds abnormally;

[0125] A fault recovery module is used to execute the corresponding fault recovery process based on the fault detection mechanism result;

[0126] Optionally, the data acquisition module includes:

[0127] The demand tag acquisition submodule is used to identify the data demand tags preset by the oily wastewater treatment system, wherein the data demand tags include time demand tags and frequency demand tags;

[0128] The original data acquisition submodule is used to acquire the original data of oily wastewater stored in the data base based on the data demand tag, wherein the original data of oily wastewater includes real-time monitoring data, historical processing data and real-time environmental parameters;

[0129] The preprocessing submodule is used to preprocess the raw data of oily sewage to obtain oily sewage data;

[0130] Optionally, the type identification module includes:

[0131] The process type identification submodule is used to obtain the system parameter characteristics of the oily wastewater treatment system, so as to identify its treatment process type, which includes physical process type, chemical process type, biological process type and combined process type;

[0132] The characteristic type identification submodule is used to obtain the technical characteristic parameters of the oily wastewater treatment system and compare them with the preset technical characteristic indicators to identify its technical characteristic type, which includes the degree of automation and the degree of environmental adaptability;

[0133] The feature collection submodule is used to collect the treatment process characteristics and technical characteristics of the oily wastewater treatment system based on the preset collection strategy;

[0134] Optionally, the system parameter characteristics include equipment parameter characteristics and drug information characteristics, and the process type identification submodule includes:

[0135] Parameter collection submodule, used to collect equipment parameter characteristics of oily wastewater treatment system;

[0136] The drug feature extraction submodule is used to obtain the historical drug information of the oily wastewater treatment system and extract the drug information features;

[0137] The feature input submodule is used to input the equipment parameter features and drug information features into the pre-trained type recognition model for processing process type recognition;

[0138] Optionally, also include:

[0139] The recognition layer module is used to identify the input type characteristics and the transmission requirement characteristics of the oily wastewater data after data format conversion;

[0140] The matching layer module is used to match the corresponding preset data transmission protocol based on the transmission demand characteristics.

[0141] For the specific definition of a system for realizing data integration between an oily wastewater treatment system and a data base, please refer to the definition of a method for realizing data integration between an oily wastewater treatment system and a data base in the above text, which will not be repeated here. Each module in the above-mentioned system for realizing data integration between an oily wastewater treatment system and a data base can be implemented in whole or in part through software, hardware and a combination thereof. The above-mentioned modules can be embedded in or independent of a processor in a computer device in the form of hardware, or can be stored in a memory in a computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

[0142] The embodiments described above are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, a person skilled in the art should understand that the technical solutions described in the aforementioned embodiments may still be modified, or some of the technical features may be replaced by equivalents. Such modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

Claims

1. A method for realizing data integration between an oily wastewater treatment system and a data base, characterized in that: Includes steps: Obtain the oily wastewater data stored in the data base; Identify the treatment process type and technical characteristics of the oily wastewater treatment system, and collect its type characteristics; Input the type characteristics and oily wastewater data into a pre-built data processing model so that the model can convert the data format of the oily wastewater data based on the type characteristics; Input the oily wastewater data after type characteristics and data format conversion into a pre-built transmission protocol matching model, so that the oily wastewater data after type characteristics and data format conversion matches the preset corresponding data transmission protocol; A two-way data transmission channel between the oily wastewater treatment system and the data base is established based on the matched data transmission protocol.

2. A method for realizing data integration between an oily wastewater treatment system and a data base according to claim 1, characterized in that: After the step of establishing a bidirectional data transmission channel between the oily wastewater treatment system and the data base based on the matched data transmission protocol, the following steps are performed: The heartbeat detection mechanism is deployed in the two-way data transmission channel, so as to receive the heartbeat signal responded by the data base and the oily wastewater treatment system at a preset frequency; When any of the data base and the oily wastewater treatment system responds abnormally, the abnormal type is identified and the fault detection mechanism is triggered based on the abnormal type; Execute the corresponding fault recovery process based on the fault detection mechanism results.

3. A method for realizing data integration between an oily wastewater treatment system and a data base according to claim 1, characterized in that: The step of obtaining the oily wastewater data stored in the data base comprises the steps of: Identify a preset data requirement tag of the oily wastewater treatment system, wherein the data requirement tag includes a time requirement tag and a frequency requirement tag; Based on the data demand tag, the original data of oily wastewater stored in the data base is obtained, wherein the original data of oily wastewater includes real-time monitoring data, historical processing data and real-time environmental parameters; The raw data of oily wastewater is preprocessed to obtain oily wastewater data.

4. A method for realizing data integration between an oily wastewater treatment system and a data base according to claim 1, characterized in that: The type characteristics include treatment process characteristics and technical characteristic characteristics. The steps of identifying the treatment process type and technical characteristic type of the oily wastewater treatment system and collecting the type characteristics thereof include the steps of: Obtaining system parameter characteristics of the oily wastewater treatment system, thereby identifying its treatment process type, wherein the treatment process type includes a physical process type, a chemical process type, a biological process type, and a combined process type; Obtaining technical characteristic parameters of the oily wastewater treatment system and comparing them with preset technical characteristic indicators, thereby identifying its technical characteristic type, wherein the technical characteristic type includes the degree of automation and the degree of environmental adaptability; Based on the preset collection strategy, the treatment process characteristics and technical characteristics of the oily wastewater treatment system are collected respectively.

5. A method for realizing data integration between an oily wastewater treatment system and a data base according to claim 4, characterized in that: The system parameter characteristics include equipment parameter characteristics and drug information characteristics. The steps of obtaining the system parameter characteristics of the oily wastewater treatment system to identify its treatment process type, wherein the treatment process type includes a physical process type, a chemical process type, a biological process type and a combined process type, include the following steps: Collect equipment parameter characteristics of oily wastewater treatment system; Obtain historical drug information of the oily wastewater treatment system and extract drug information features; The equipment parameter characteristics and drug information characteristics are input into the pre-trained type recognition model to identify the processing type.

6. A method for realizing data integration between an oily wastewater treatment system and a data base according to claim 1, characterized in that: The transmission protocol matching model includes an identification layer and a matching layer. The step of inputting the oily wastewater data after type characteristics and data format conversion into the pre-built transmission protocol matching model so that the oily wastewater data after type characteristics and data format conversion matches the preset corresponding data transmission protocol includes the following steps: The recognition layer identifies the input type characteristics and the transmission requirement characteristics of the oily wastewater data after data format conversion; The matching layer matches the corresponding preset data transmission protocol based on the transmission requirement characteristics.

7. A system for realizing data integration between oily wastewater treatment system and data base, characterized in that: include: A data acquisition module, used to acquire the oily wastewater data stored in the data base; Type identification module, used to identify the treatment process type and technical characteristic type of the oily wastewater treatment system, and collect its type characteristics; A data input module is used to input the type characteristics and oily wastewater data into a pre-built data processing model so that the model can perform data format conversion on the oily wastewater data based on the type characteristics; A feature input module is used to input the type features and the oily wastewater data after data format conversion into a pre-built transmission protocol matching model, so that the oily wastewater data after type features and data format conversion matches the preset corresponding data transmission protocol based on the model; The transmission channel establishment module is used to establish a two-way data transmission channel between the oily wastewater treatment system and the data base based on the matched data transmission protocol.

8. A system for realizing data integration between an oily wastewater treatment system and a data base according to claim 7, characterized in that: Also includes: A heartbeat deployment module is used to deploy the heartbeat detection mechanism in a two-way data transmission channel, thereby receiving the heartbeat signal responded by the data base and the oily sewage treatment system at a preset frequency; A fault detection module is used to identify the abnormality type and trigger the fault detection mechanism based on the abnormality type when either the data base or the oily wastewater treatment system responds abnormally; The fault recovery module is used to execute the corresponding fault recovery process based on the fault detection mechanism results.

Images