MES system complex electronic equipment commissioning and testing data management method and system

Abstract

The invention discloses an MES system complex electronic equipment commissioning and testing data management method and system, and relates to the technical field of commissioning and testing data management. According to the method, the relation between MES system task flow information and electronic equipment commissioning and testing data can be established, value mining on the commissioning and testing data from multiple dimensions and multiple perspectives is supported, and the method specifically comprises screening, calculation and statistical analysis; a set of complex electronic equipment commissioning and testing data management and evaluation model is provided, and quantitative evaluation is carried out on the working efficiency and reliability of the equipment.

Description

Technical Field

[0001] The present invention relates to the technical field of debugging data management, and particularly relates to a method and system for managing debugging data of complex electronic equipment in a MES system. Background Art

[0002] The statements in this section only provide background information related to the present disclosure and may not constitute prior art.

[0003] Debugging data management is crucial for the manufacturing process of complex electronic equipment. Based on the debugging data, the main performance indicators of the electronic equipment can be calculated, and the environmental adaptability of the electronic equipment can be analyzed by combining different debugging environment parameters and their test results.

[0004] The debugging data of electronic equipment needs to be associated with the task information flow (including equipment model, serial number, environmental parameters, test index items, etc.) in the Manufacturing Execution System (MES) of the enterprise production process to better explore the data value. Currently, there is a related Chinese patent CN202411027757, "A Test Data Management System and Method Based on an Evaluation Model". This patent discloses a test data management system and method based on an evaluation model, which needs to identify performance fluctuation characteristics based on a test data set and predict the performance trend. It is not applicable to complex electronic equipment with a small amount of debugging data samples and performance fluctuations that cannot be predicted by historical test data, nor does it provide a method for modeling and managing debugging data based on MES. Summary of the Invention

[0005] The purpose of the present invention is to provide a method and system for managing debugging data of complex electronic equipment in a MES system, which models the attributes and methods of the debugging data of the electronic equipment, manages the lineage relationship of the debugging data and the equipment data in the MES system based on a relational database and a time series database, and supports screening, calculation, and statistical analysis of the debugging data from multiple dimensions and perspectives, aiming at the problem that the MES system and the debugging data of complex electronic equipment are still not integrated and managed, and the debugging data cannot be effectively mined, applied, and utilized.

[0006] The technical solution of the present invention is as follows:

[0007] A method for managing debugging data of complex electronic equipment in a MES system includes:

[0008] Step S1: Model the debugging data according to the working environment of the electronic equipment and the requirements of the station tasks. The modeling content includes data attribute modeling and evaluation method modeling;

[0009] Step S2: Establish a database system that includes a relational database, a time-series database, and an XML storage structure to manage the data lineage of equipment, the status record data of the debugging process, and the test results of performance indicators respectively;

[0010] Step S3: Build an offline and online dual-mode data exchange interface to achieve data synchronization between the debugging workstations and the server database;

[0011] Step S4: Develop an analysis application tool for electronic equipment debugging data that includes functions such as data extraction, qualification verification, statistical analysis, and visualization display.

[0012] Further, the step S1 includes:

[0013] Step S11: Generate a general attribute label set through the union operation of multiple single-model electronic equipment debugging data attribute label sets;

[0014] Step S12: Establish a data processing method set that includes maintenance, analysis, and evaluation categories.

[0015] Further, the operation formula for the union operation is as follows:

[0016]

[0017] Where:

[0018] Lc represents the general attribute set of electronic equipment debugging data;

[0019] Li represents the attribute label set of the debugging data of the i-th model of electronic equipment.

[0020] Further, the data processing methods in the maintenance category include: data addition, deletion, modification, and query methods;

[0021] The data processing methods in the analysis category include: obtaining the characteristics of each performance indicator of the equipment through arithmetic processing of the debugging data;

[0022] The data processing methods in the evaluation category include: quantitatively evaluating the performance status of the electronic equipment based on the analysis results and the evaluation result calculation formula.

[0023] Further, the evaluation result calculation formula is as follows:

[0024]

[0025] Where:

[0026] Sc represents the quantitative evaluation result of the equipment;

[0027] Ki is the weight factor of this indicator in the equipment evaluation activity;

[0028] f(Di) represents the quality level of this indicator.

[0029] Further, when it is determined as qualified when the measured value Di is greater than the criterion value Dt, the calculation formula of f(Di) is as follows:

[0030] f(Di) = (Di - Dt) / Dt

[0031] When it is determined as appropriate when the measured value Di is less than the criterion value Dt, the calculation formula of f(Di) is as follows:

[0032] f(Di) = (Dt - Di) / Dt.

[0033] Further, the step S2 includes:

[0034] Establish a multi-dimensional relationship model of equipment blood relationship using the relational database SQL Server, including the task hierarchical relationship and the debugging process sequence relationship;

[0035] Build a tree-node storage structure for recording the status of the debugging process using the time-series database IoTDB;

[0036] Store the test results of equipment performance indicators in XML format.

[0037] Further, the offline data exchange interface includes:

[0038] The SQLite database is used to locally store blood relationship data;

[0039] The TsFile file format stores the debugging process records;

[0040] The XML file stores the test results of performance indicators;

[0041] After connecting to the network, data synchronization is achieved through file import.

[0042] Further, the online exchange interface includes:

[0043] The WebService service interface realizes writing to the SQL Server database;

[0044] The RestAPI interface realizes writing to the IoTDB time-series database.

[0045] Further, the step S4 includes:

[0046] Step S41: Develop a data extraction interface. When the screening condition is the attribute label of the debugging data, data screening is performed based on the structured query language SQL; when the screening condition is a specified data block in the test results, screening is performed through the node selection function of XML;

[0047] Step S42: Configure the qualified verification parameters using EXCEL, including the index name, criterion type, qualified criterion value, and position of the data block to be verified. The EXCEL configuration file and its lineage relationship in the MES system are centrally managed by the server;

[0048] Step S43: Develop a tool for statistical analysis of electronic equipment debugging data;

[0049] Step S44: Develop a visual display module, provide a user interaction interface, receive the user's data screening and visual display requirements, perform data extraction, processing and calculation work, and present the processing results to the user in the form of graphs and tables through the software interface.

[0050] The present invention also proposes a complex electronic equipment debugging data management system for the MES system, including:

[0051] An equipment debugging data model management module for maintaining a general attribute set and an evaluation method function library;

[0052] A database management module integrating a SQL Server relational database, an IoTDB time series database, and an XML storage structure;

[0053] A dual-mode data exchange interface module including a RestAPI online interface and a SQLite / TsFile offline interface;

[0054] A data analysis tool module integrating a data screening engine, a verification configurator, an analysis algorithm library, and a visual display platform.

[0055] Compared with the existing technology, the beneficial effects of the present invention are:

[0056] The present invention can establish the connection between the MES system task flow information and the electronic equipment debugging data, support the value mining of the debugging data from multiple dimensions and perspectives, specifically including screening, calculation, and statistical analysis; provide a set of complex electronic equipment debugging data management and evaluation models to quantitatively evaluate the equipment working efficiency and reliability. Description of the Drawings

[0057] Figure 1 It is a structural schematic diagram of a complex electronic equipment debugging data management method for the MES system;

[0058] Figure 2 It is a flow schematic diagram of a complex electronic equipment debugging data management method for the MES system;

[0059] Figure 3 It is a lineage relationship schematic diagram of a complex electronic equipment debugging data management method for the MES system. Detailed Embodiments

[0060] It should be noted that relational terms such as "first" and "second" are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship or order between these entities or operations. Moreover, the terms "comprising", "including" or any other variant thereof are intended to cover non-exclusive inclusion, such that a process, method, article or device comprising a series of elements includes not only those elements but also other elements not expressly listed, or elements inherent to such process, method, article or device. Without further limitation, an element defined by the statement "comprising a..." does not exclude the presence of additional identical elements in the process, method, article or device comprising the element.

[0061] The features and performance of the present invention will be further described in detail below in conjunction with embodiments.

[0062] Embodiment 1

[0063] Please refer to Figures 1-3 , a method for managing debugging data of complex electronic equipment in a MES system, comprising:

[0064] Step S1: Model the debugging data according to the working environment of the electronic equipment and the requirements of the station tasks. The modeling content includes data attribute modeling and evaluation method modeling;

[0065] Step S2: Establish a database system including a relational database, a time series database and an XML storage structure to manage the lineage relationship of equipment data, the recorded data of the debugging process status and the test results of performance indicators respectively; that is, establish a database to manage the lineage relationship of equipment data (referring to a relationship similar to the blood relationship in human society formed during the generation, processing, transfer and extinction of data), the recorded data of the debugging process status and the test result data of performance indicators.

[0066] Step S3: Construct an offline and online dual-mode data exchange interface to realize data synchronization between the debugging station and the server database.

[0067] Step S4: Develop an electronic equipment debugging data analysis application tool including functions of data extraction, qualification verification, statistical analysis and visual display.

[0068] In this embodiment, specifically, the step S1 includes:

[0069] Step S11: Generate a general attribute label set through the union operation of the debugging data attribute label sets of multiple single-model electronic devices; that is, design a debugging data attribute label set for single-model electronic devices based on the principle of "being able to quickly locate debugging data and obtain the key status of electronic devices", and find the union of the attribute label sets of different models of electronic devices according to the physical meaning of the attribute labels to obtain a general attribute label set.

[0070] Step S12: Establish a data processing method set including maintenance, analysis, and evaluation categories.

[0071] In this embodiment, specifically, the operation formula for the union operation is as follows:

[0072]

[0073] Where:

[0074] Lc represents the general attribute set of the debugging data of the electronic device;

[0075] Li represents the debugging data attribute label set of the i-th model of electronic device.

[0076] In this embodiment, specifically, the data processing methods for the maintenance category include: data addition, deletion, modification, and query methods;

[0077] The data processing methods for the analysis category include: obtaining the characteristics of each performance index of the device by performing arithmetic processing on the debugging data;

[0078] The data processing methods for the evaluation category include: quantitatively evaluating the performance status of the electronic device based on the analysis results and the evaluation result calculation formula;

[0079] That is, design a data processing method set according to the application scenarios of the electronic device debugging data analysis. The data processing methods are divided into three categories: maintenance, analysis, and evaluation. Maintenance includes data addition, deletion, modification, and query methods. Analysis means obtaining the characteristics of each performance index of the device by performing arithmetic processing on the debugging data, such as the true value, boundary value, root mean square, standard deviation, etc. of the output power. Evaluation is to quantitatively evaluate the performance status of the electronic device based on the analysis results and the evaluation formula.

[0080] In this embodiment, specifically, the evaluation result calculation formula is as follows:

[0081]

[0082] Where:

[0083] Sc represents the quantitative evaluation result of the device, which is calculated from the weight values, measured values, and criterion values of each index;

[0084] $K_i$ is the weight factor of this indicator in the equipment evaluation activity. The more critical the indicator, the higher the weight factor. The sum of the weight factors of all indicators is 1;

[0085] $f(D_i)$ represents the quality level of this indicator.

[0086] In this embodiment, specifically, when it is determined as qualified when the measured value $D_i$ is greater than the criterion value $D_t$, the calculation formula of $f(D_i)$ is as follows:

[0087] $f(D_i)=(D_i - D_t) / D_t$

[0088] When it is determined as appropriate when the measured value $D_i$ is less than the criterion value $D_t$, the calculation formula of $f(D_i)$ is as follows:

[0089] $f(D_i)=(D_t - D_i) / D_t$.

[0090] In this embodiment, specifically, the step S2 includes:

[0091] Establish a multi-dimensional relationship model of equipment blood relationship using the relational database SQL Server, including task hierarchical relationship and debugging process sequence relationship;

[0092] Build a tree-node storage structure for recording the status of the debugging process using the time-series database IoTDB;

[0093] Store the test results of equipment performance indicators in XML format;

[0094] That is, for the equipment blood relationship information, it is managed through the relational database SQL server, and a multi-dimensional and multi-level blood relationship is established for the debugging data attribute values based on the task flow information of the MES system, including task hierarchical relationship, debugging process sequence relationship, etc.; for the record of the equipment debugging process status, tree nodes are established in the time-series database IoTDB according to the physical meaning of the data, and the equipment status information during the debugging process is recorded according to the time stamp; for the test results of heterogeneous and complex equipment performance indicators, they are stored in the extensible markup language XML.

[0095] In this embodiment, specifically, the offline data exchange interface includes:

[0096] The SQLite database is used to locally store the blood relationship data;

[0097] The TsFile file format stores the debugging process records;

[0098] The XML file stores the test results of performance indicators;

[0099] After connecting to the network, data synchronization is achieved through file import.

[0100] In this embodiment, specifically, the online exchange interface includes:

[0101] The WebService service interface realizes writing to the SQL Server database;

[0102] The RestAPI interface realizes writing to the IoTDB time series database;

[0103] That is, during offline testing, the debugging data is temporarily stored in the work station in the form of a form or a file. After networking, it is synchronized to the server database through the database read and write interface or file import. The lineage relationship data is stored in the local lightweight database SQLite of the work station, and the debugging process record is exported and stored as a TsFile file, and the performance index test result is exported and stored as an XML file. During online testing, the lineage relationship data and the performance index test result are written to the SQL server database through the data read and write interface packaged by the WebService service, and the debugging process record is written to the ioTDB database through the RestAPI data read and write interface exposed by IoTDB.

[0104] In this embodiment, specifically, the step S4 includes:

[0105] Step S41: Develop a data extraction interface. When the screening condition is the attribute label of the debugging data, data screening is performed based on the Structured Query Language (SQL). When the screening condition is a specified data block in the test result, screening is performed through the node selection function of XML;

[0106] Step S42: Configure the qualified verification parameters in EXCEL, including the index name, criterion type, qualified criterion value, position of the data block to be verified, etc. The EXCEL configuration file and its lineage relationship in the MES system are centrally managed by the server;

[0107] Step S43: Develop a tool for statistical analysis of the debugging data of electronic equipment;

[0108] Step S44: Develop a visual display module, provide a user interaction interface, receive the user's data screening and visual display requirements, perform data extraction, processing and calculation, etc., and present the processing results to the user in the form of graphics, tables, etc. through the software interface.

[0109] This embodiment also proposes a complex electronic equipment debugging data management system for the MES system, including:

[0110] The equipment debugging data model management module is used to maintain the general attribute set and the evaluation method function library; the equipment debugging data model management module is used to manage the debugging data model, including data attribute management and evaluation method management; specifically, the data attribute management creates an equipment model form through the SQL server database, maintains the general attribute set in the equipment model form, and stores the specific attribute values corresponding to each equipment in the general attribute set.

[0111] The evaluation method management is responsible for maintaining the function information of various evaluation methods in the equipment model form, including function name, function, input parameter type and name, output parameter type and name, and the entity acquisition method for function implementation, etc.

[0112] The database management module integrates the SQL Server relational database, the IoTDB time series database, and the XML storage structure; that is, the database management module is responsible for establishing a relational database and a time series database on the server, and managing the lineage relationship (explained before and referenced later) and equipment data of the equipment debugging data respectively.

[0113] The dual-mode data exchange interface module includes the RestAPI online interface and the SQLite / TsFile offline interface; that is, the dual-mode data exchange interface includes an online exchange interface and an offline exchange interface. The online exchange interface is used when the debugging station is connected to the server database network, and the database reads and writes are performed based on the RestAPI. The offline exchange interface is used when the debugging station is not connected to the server database network, and data synchronization is achieved by importing the local database and local files of the debugging station.

[0114] The data analysis tool module integrates a data screening engine, a verification configurator, an analysis algorithm library, and a visualization display platform; that is, the data analysis tool includes an analysis tool library and a visualization configuration. The analysis tool library contains various tools for analyzing and applying the equipment debugging data, and the visualization configuration is responsible for configuring the display content and form of the debugging data.

[0115] Embodiment 2

[0116] Embodiment 2 is a method for managing the debugging data of complex electronic equipment in an MES system proposed based on Embodiment 1. Please refer to Figure 2 , specifically including:

[0117] Step S1: Model the debugging data according to the working environment and station task requirements of electronic equipment A and electronic equipment B. The modeling content includes data attributes and evaluation methods. It includes:

[0118] Step S11: finding the union of the attribute tag sets of electronic equipment A and electronic equipment B to obtain a common attribute tag set, including equipment type, model, batch number, serial number, test environment, process number, process name, indicator name, and test conclusion.

[0119] Step S12: Design a set of processing methods, including data addition, deletion, query and modification methods, data analysis methods (FFT operation, boundary value extraction, root mean square calculation, standard deviation calculation), and data evaluation methods. The evaluation of electronic equipment A and electronic equipment B involves receiving index 1 and communication index 2. Electronic equipment A is mainly used to receive and analyze signals and has no communication function. The weight of index 1 is 1 and the weight of index 2 is 0. Electronic equipment B is used for communication and takes into account the transceiver function. The weight of index 1 is 0.5 and the weight of index 2 is 0. After obtaining the actual measured value of the index during the commissioning process, the evaluation result can be obtained by combining the qualified criterion value of the index and the weight factor and calculating according to Formula 2 in the manual.

[0120] Step S2: Establish a database based on the commissioning data model, the blood relationship of the equipment, including the task hierarchy relationship, the commissioning process sequence relationship, etc. Figure 3 As shown, a form is established using Microsoft's SQL server 2012 for management; the equipment's debugging process status records, such as the status information reported by each module at different timestamps, are recorded through Tianmou Technology's IoTDB time series database; the equipment's performance debugging results, such as the sensitivity of each frequency point in different channels and modes, the output power test results and intermediate calculation parameters, are stored through the extensible markup language XML.

[0121] Step S3: Develop a data exchange interface for the commissioning database. During offline testing, the commissioning data is temporarily stored in the workstation. The lineage data is stored in the local lightweight database SQLite of the workstation. The commissioning process records are exported as TsFile files. The performance indicator test results are exported as XML files for storage. After connecting to the network, they are synchronized to the server database through the data read and write interface or file import. During online testing, the lineage data and performance indicator test results are written into the SQL server database through the data read and write interface of the WebService service, and the commissioning process records are written into the ioTDB database through the RestAPI data read and write interface exposed by IoTDB.

[0122] Step S4: Develop an application tool for electronic equipment commissioning data analysis and design implementation methods for functions such as data extraction, qualification verification, statistical analysis, and visual display, including:

[0123] Step S41: Develop a data extraction interface. When the filtering condition is general attribute information outside the test form, data filtering is performed based on the Structured Query Language (SQL). When the filtering condition is specified row and column information within the test form, filtering is performed through the node selection function of XML.

[0124] Step S42: Configure the qualified verification parameters in EXCEL, including the index name, criterion type, qualified criterion value, table index number where the data block to be verified is located, row range, and column range. The EXCEL configuration file and its lineage relationship in the MES system are centrally managed on the server.

[0125] Step S43: Develop a tool for statistical analysis of electronic equipment debugging data. Based on the Microsoft Visual Studio 2013 development platform, develop function packages such as FFT operation package, boundary value calculation package, RMS calculation package, and RMSE calculation package through the C# language.

[0126] Step S44: Develop a visual display module. Develop the backend through the C# language based on the Microsoft Visual Studio 2013 development platform, and build the frontend based on the DevExpress 18.1 control package to provide interactive functions for users. Receive the data filtering and visual configuration requirements of users, and present the processing results to users in the form of graphics, tables, etc. through the software interface.

[0127] To better implement the above method, this embodiment also proposes a complex electronic equipment debugging data management system, which includes an equipment debugging data model management module, a database management module, a data exchange interface module, and a data analysis tool module.

[0128] The described equipment debugging data model management module is used to manage the debugging data model, including data attribute management and evaluation method management.

[0129] Data attribute management creates an equipment model form through the SQL server database of Microsoft Corporation, maintains a general attribute set in the equipment model form, and stores the specific attribute values corresponding to each equipment in the general attribute set.

[0130] Evaluation method management is responsible for maintaining the function information of various evaluation methods in the equipment model form, including function name, function, input parameter type and name, output parameter type and name, and the dynamic link library path for function implementation.

[0131] The described database management module is responsible for establishing a relational database and a time series database on the server, and managing the lineage relationship of equipment debugging data and equipment data respectively.

[0132] The described data exchange interface includes an online exchange interface and an offline exchange interface. The online exchange interface reads and writes to the database based on RestAPI; the offline exchange interface realizes data synchronization by importing the local database and files of the debugging station.

[0133] The described data analysis tool includes an analysis tool library and visualization configuration. The analysis tool library contains a variety of tools for analyzing and applying the debugging data of electronic equipment, including FFT operation, boundary value calculation, RMS calculation, etc. Visualization configuration refers to configuring the display content and form of the debugging data, such as displaying the sensitivity test results of electronic equipment A in July 2024 according to user requirements and presenting them in the form of a curve.

[0134] The above embodiments only represent the specific implementation manners of the present application. The description is relatively specific and detailed, but it should not be construed as a limitation on the protection scope of the present application. It should be noted that for those of ordinary skill in the art, without departing from the concept of the technical solution of the present application, several deformations and improvements can still be made, and these all belong to the protection scope of the present application.

[0135] This background technology section is provided to generally present the context of the present invention. The work of the currently named inventors, to the extent described in this background technology section, and aspects of this section that do not constitute prior art at the time of filing this application are neither expressly nor impliedly admitted to be prior art of the present invention.

Claims

1. A method for managing commissioning data of complex electronic equipment in an MES system, characterized in that: include: Step S1: Modeling the commissioning data according to the working environment of the electronic equipment and the workstation task requirements, the modeling content includes data attribute modeling and evaluation method modeling; Step S2: Establish a database system including a relational database, a time series database and an XML storage structure to manage equipment data lineage, commissioning process status record data and performance index test results respectively; Step S3: construct an offline and online dual-mode data exchange interface to achieve data synchronization between the commissioning station and the server database; Step S4: Develop an electronic equipment commissioning data analysis application tool that includes data extraction, qualification verification, statistical analysis, and visual display functions.

2. According to claim 1, a method for managing complex electronic equipment commissioning data of an MES system is characterized in that: The step S1 comprises: Step S11: generating a general attribute tag set by performing a union operation on a plurality of single-model electronic equipment commissioning data attribute tag sets; Step S12: Establish a data processing method set including maintenance, analysis and evaluation categories.

3. A method for managing complex electronic equipment commissioning data in an MES system according to claim 2, characterized in that: The calculation formula of the union operation is as follows: in: Lc represents the general attribute set of electronic equipment commissioning data; Li represents the attribute label set of the i-th type of electronic equipment commissioning data.

4. A method for managing complex electronic equipment commissioning data in an MES system according to claim 2, characterized in that: Maintenance data processing methods include: data addition, deletion, modification and query methods; Analytical data processing methods include: obtaining the characteristics of various performance indicators of equipment by performing calculations on the commissioning data; Evaluation data processing methods include: quantitative evaluation of the performance status of electronic equipment based on analysis results and evaluation result calculation formulas.

5. A method for managing complex electronic equipment commissioning data in an MES system according to claim 4, characterized in that: The evaluation result calculation formula is as follows: in: Sc represents the quantitative evaluation result of the equipment; Ki is the weight factor of this indicator in the equipment evaluation activity; f(Di) represents the degree of excellence of the indicator.

6. A method for managing complex electronic equipment commissioning data in an MES system according to claim 5, characterized in that: When the measured value Di is greater than the criterion value Dt and is judged to be qualified, the calculation formula of f(Di) is as follows: f(Di)=(Di-Dt) / Dt When the measured value Di is less than the criterion value Dt and is judged to be appropriate, the calculation formula of f(Di) is as follows: f(Di)=(Dt-Di) / Dt.

7. A method for managing complex electronic equipment commissioning data in an MES system according to claim 1, characterized in that: The step S2 comprises: Use relational database SQL Server to establish a multi-dimensional relationship model of equipment blood relationship, including task hierarchy relationship and commissioning process sequence relationship; The time series database IoTDB is used to build a tree node storage structure for debugging process status records; The XML format is used to store the test results of layer equipment performance indicators.

8. The method for managing complex electronic equipment commissioning data of an MES system according to claim 1, characterized in that: The offline data exchange interface includes: The SQLite database is used to store blood relationship data locally; TsFile file format stores debugging process records; XML files store performance indicator test results; After connecting to the Internet, data synchronization can be achieved through file import; The online exchange interface includes: WebService service interface implements SQL Server database writing; The RestAPI interface implements writing to the IoTDB time series database.

9. A method for managing complex electronic equipment commissioning data in an MES system according to claim 1, characterized in that: The step S4 comprises: Step S41: Develop a data extraction interface. When the screening condition is the attribute label of the commissioning data, data screening is performed based on the structured query language SQL; when the screening condition is a specified data block in the test result, screening is performed through the node selection function of XML; Step S42: Use EXCEL to configure the qualified verification parameters, including the indicator name, criterion type, qualified criterion value, and the location of the data block to be verified. The EXCEL configuration file and its relationship in the MES system are centrally managed by the server; Step S43: Developing a tool for statistical analysis of electronic equipment commissioning data; Step S44: Develop a visualization display module, provide a user interaction interface, receive user data screening and visualization display requirements, perform data extraction, processing and calculation work, and present the processing results to the user in the form of graphics and tables through the software interface.

10. A MES system complex electronic equipment commissioning data management system, characterized in that: include: Equipment commissioning data model management module, used to maintain common attribute sets and evaluation method function libraries; Database management module, integrating SQL Server relational database, IoTDB time series database and XML storage structure; Dual-mode data exchange interface module, including RestAPI online interface and SQLite / TsFile offline interface; The data analysis tool module integrates data screening engine, verification configurator, analysis algorithm library and visualization display platform.

Images