Nuclear power plant electric instrument equipment aging data vertical search method and system

Abstract

The invention belongs to the technical field of nuclear power plant electric instrument equipment aging data searching, and discloses a nuclear power plant electric instrument equipment aging data vertical searching method and system.The method comprises the steps that equipment position numbers are extracted from all databases to serve as main concern information, and corresponding data are searched in the databases according to the equipment position numbers input at the front end; extracting a system number in the equipment code from the maintenance information database, matching the system number with a system number of a system responsible person, and generating an aging identification to-do item; the system comprises a data extraction module, a data annotation module, a data matching module, a data storage module, an equipment basic information module, a maintenance information module, an aging identification information module, a task distribution module, an aging identification module and a data statistics module. According to the invention, the working efficiency of nuclear power plant equipment aging management workers can be improved to a great extent, and the working preparation time which needs several hours originally is shortened to several minutes.

Description

Technical Field

[0001] The present application belongs to the technical field of aging data search for electrical instrumentation equipment in nuclear power plants, and in particular, relates to a vertical search method and system for aging data for electrical instrumentation equipment in nuclear power plants. Background Art

[0002] The aging analysis and management of electrical equipment runs through the entire life cycle of a nuclear power plant, and one of the foundations for aging management is to establish a comprehensive and complete electrical equipment aging management information database. Traditional data collection and recording methods are varied and are affected by human errors, which leads to various data quality problems such as unreliable data, incomplete data, data duplication, data omission, and ambiguous expression when recording data, processing data, and using data to communicate related information, which affects the judgment results and causes unnecessary losses. Its main disadvantages include:

[0003] (1) Nuclear power plant equipment management staff will use a large amount of files and data during their work, including inventory quantities, defect work orders, basic equipment information, etc. These data are usually scattered in different systems and need to be manually searched based on experience. This requires high personal skills and knowledge reserves of staff. Staff need to clearly know the location of various files before they can search;

[0004] (2) Human errors are prone to occur during the work preparation process. Workers need to enter search content into various systems to find corresponding materials. Errors are prone to occur during the information input and search process, which leads to problems in work preparation and affects work execution.

[0005] (3) Each file cannot be automatically associated with other information and requires manual matching analysis;

[0006] (4) The system manager needs to proactively query the work orders of the system he is responsible for, identify and judge aging, and have a high sense of responsibility. Summary of the invention

[0007] The main purpose of this application is to provide a method and system for vertical search of aging data of electrical instrumentation equipment in nuclear power plants, reduce the risk of human error caused by poor readability of equipment files and data, and better perform aging analysis of electrical instrumentation equipment.

[0008] Another object of the present application is to provide a method and system for vertical search of aging data of electrical instrumentation equipment in nuclear power plants, so as to improve the information level of aging management of electrical instrumentation equipment in nuclear power plants.

[0009] Another purpose of the present application is to provide a method and system for vertical search of aging data of electrical instrument equipment in nuclear power plants, which aggregates key data of electrical instrument aging and uniformly displays them to users, realizes vertical search of electrical instrument aging data, and reduces unnecessary data query time.

[0010] Another object of the present application is to provide a method and system for vertically searching aging data of electrical instrumentation equipment in a nuclear power plant, so as to realize automatic allocation of aging identification tasks and automatic statistics of equipment defect data.

[0011] In order to achieve the above objectives, this application provides the following technical solutions:

[0012] In a first aspect, the present application provides a method for vertically searching aging data of electrical instrumentation equipment in a nuclear power plant, comprising:

[0013] Step 101, obtain data in the EAM system, data in the ERP system, and import data;

[0014] Step 102: parse the data in step 101 and store them in different databases;

[0015] Step 103: extract the device number from each database as the main information of interest, and search for corresponding data in the database according to the device number input by the front end;

[0016] Step 104: Display all data found in the database and historical data read from the PI in the software interface;

[0017] Step 105: extract the system number in the equipment code from the maintenance information database, match it with the system number of the system manager, and generate an aging identification to-do item;

[0018] Step 106: according to the aging identification result input by the front end, the specific data corresponding to the device is saved in the maintenance database;

[0019] Step 107: Count the aging recognition history data.

[0020] In some embodiments, the data obtained from the EAM system includes pre-maintenance data and completion report data.

[0021] In some embodiments, the pre-maintenance data includes monitoring period, completion date, PM title, and predefined range.

[0022] In some embodiments, the completion report data includes the work order task number, work order task title, equipment code, brief description of work completion, cause of defect, detailed description of work completion, material code of spare parts consumption page, material name, and practical quantity.

[0023] In some embodiments, the data obtained from the ERP system includes normal inventory, available quantity, total available quantity, and quantity in purchase.

[0024] In some embodiments, the system number of the 2nd to 4th digits in the device code is extracted as the information of interest.

[0025] In some embodiments, the aging identification history data includes the work order number, system number, equipment number, evaluation result, work task title, completion time, defect cause, work completion summary, person in charge, and identification status.

[0026] In a second aspect, the present application provides a vertical search system for aging data of electrical instrumentation equipment in a nuclear power plant, comprising:

[0027] Data extraction module, used to read data, parse compressed packages and extract table data;

[0028] Data annotation module, used to automatically annotate and classify the read data;

[0029] A data matching module is used to match the read data;

[0030] A data storage module, used to store the marked data in corresponding databases;

[0031] Equipment basic information module, used to display equipment basic information;

[0032] Maintenance information module, used to display equipment defect maintenance information, maintenance experience feedback information of peer power plants and preventive maintenance information;

[0033] Aging identification information module, used to display aging identification information and aging improvement measures;

[0034] The task allocation module is used to automatically allocate the completion report to the corresponding system owner according to the data matching rules and generate aging identification to-do items;

[0035] The aging identification module is used to manually determine whether the item is a defect. If it is a defect, a pop-up window will prompt the user to fill in the measures, and the relevant information will be synchronized to the maintenance information for display, and the number of faults will automatically increase by one;

[0036] Data statistics module, used to statistically identify historical data.

[0037] In a third aspect, the present application provides an electronic device, including a memory and a processor, wherein computer-readable instructions are stored in the memory, and the described method is implemented when the processor executes the computer-readable instructions.

[0038] In a fourth aspect, the present application provides a computer-readable storage medium, in which computer-readable instructions are stored, and the method described is implemented when the computer-readable instructions are executed.

[0039] Compared with the prior art, the vertical search method and system for aging data of electrical instrumentation equipment in nuclear power plants provided by the present application has the following beneficial effects:

[0040] This application can greatly improve the work efficiency of nuclear power plant equipment aging management personnel, shortening the work preparation time that originally took several hours to a few minutes.

[0041] Furthermore, this application realizes the large-scale integration of various types of data, based on the extensive practical needs of the commissioning, operation and maintenance stages of million-kilowatt nuclear power units, and has strong practical significance in improving work efficiency and big data processing and utilization. At the same time, it brings about the optimization of work methods and the liberation of manpower, and the spillover value generated far exceeds the direct economic value.

[0042] Furthermore, this application is associated with common production systems in nuclear power plants, including EAM and ERP systems, and reads work order data, preventive maintenance data, inventory information, etc. in the system. It also has the function of manually importing information to establish a basic information database of electrical equipment aging, a defect work order database, and an aging detection database.

[0043] Furthermore, all databases established in the present application are created based on the equipment number, and all data can be matched and associated through the equipment number.

[0044] Furthermore, this application matches the work order with the personnel information, generates action items, automatically pushes the identification task to the relevant person in charge, and sets a time limit for email reminders. BRIEF DESCRIPTION OF THE DRAWINGS

[0045] In order to more clearly illustrate the technical solution of the present application, the following is a brief introduction to the drawings required for the technical description.

[0046] Figure 1 A flowchart of a vertical search method for aging data of electrical and instrument equipment in a nuclear power plant provided for this application;

[0047] Figure 2 A flowchart of one-stop search for data provided for this application;

[0048] Figure 3 A schematic diagram of the structure of the vertical search system for aging data of electrical and instrument equipment in nuclear power plants provided for this application;

[0049] Figure 4 Functional diagram of the vertical search system for aging data of electrical and instrument equipment in nuclear power plants provided for this application. DETAILED DESCRIPTION

[0050] The following is further explained in detail through specific implementation methods.

[0051] like Figure 1 and Figure 2 As shown, the present application provides a method for vertically searching aging data of electrical instrumentation equipment in a nuclear power plant, comprising:

[0052] Step 101: Read relevant data from the EAM interface, read relevant data from the ERP interface, and obtain manually imported data. Through step 101, data in the EAM system (existing system) is obtained, data in the ERP system (existing system) is obtained, and manually imported data is obtained.

[0053] The relevant data read from the EAM interface include: pre-maintenance data (monitoring period, completion date, PM title, predefined scope), completion report data (work order task number, work order task title, equipment (work item) code, brief description of work completion, cause of defect, detailed description of work completion, spare parts consumption page (if any) material code, material name, practical quantity).

[0054] The relevant data read from the ERP interface include: normal inventory, available quantity, total available quantity, and quantity in purchase.

[0055] There are two ways to obtain manually imported data. One is to batch import basic equipment information, maintenance information, and aging identification information, which needs to be organized into Excel tables and compressed into rar or zip; the other is for users to manually enter relevant information in the specified format on the software interface.

[0056] Step 102: parse the data in step 101, classify them into different categories according to their source, file name, and file content, and store them in different databases.

[0057] The database includes: equipment basic database (including unit number, system number, equipment position number, equipment classification, equipment photo, component name, component code, component classification, component model, material code, manufacturer, component type, component installed quantity, working frequency, operating environment), maintenance information database work task title, completion time, defect cause, work completion summary, measures taken, experience feedback, number of failures, layout life starting point, commissioning starting point, PMID, PMRQ, PM title, pre-maintenance cycle, last overhaul number), aging identification information database (manufacturer / standard recommended life, spare parts supply, component aging mitigation strategy, sensitive components, key aging factors, aging mechanism, failure mode, component manufacturer model).

[0058] Step 103: extract the device number from each database as the main information of interest, and search for corresponding data in the database according to the device number input by the software front end.

[0059] Step 104: Display all data found in the database and historical data read from the PI in the software interface.

[0060] Step 105: extract the 2nd to 4th digit system number in the equipment (work item) code from the maintenance information database as the main concern information, match it with the system number of the system manager, and generate an aging identification to-do item.

[0061] Step 106: According to the aging identification result input by the front end, the specific data corresponding to the device is saved in the maintenance database.

[0062] Specific data includes: work task title, completion time, defect cause, brief description of work completion, measures taken, and the number of failures of the equipment in the maintenance database also changes accordingly.

[0063] Step 107: Count the aging recognition history data.

[0064] The aging identification history data includes: work order number, system number, equipment number, evaluation result (defect, non-defect, empty), work task title, completion time, defect reason, work completion summary, person in charge, identification status (identified / unidentified), and is displayed in the interface in a list form.

[0065] In addition, if Figure 3 and Figure 4 As shown, the present application also provides a vertical search system for aging data of electrical instrument equipment in nuclear power plants, which has data processing function, data vertical search function, and aging identification function. The system includes a data extraction module, a data annotation module, a data matching module, a data storage module, an equipment technical information module, a maintenance information module, an aging identification information module, a task allocation module, an aging identification module, and a data statistics module. It is worth noting that the aging identification information module is the aging information that can be identified through existing standards / data, and the aging information that the aging identification module reversely identifies through equipment defects is a complementary relationship.

[0066] The data processing functions of this system include data extraction, data labeling, and data matching.

[0067] The data extraction module is used to read data, parse compressed packages and extract table data, and read input data.

[0068] The data extraction module reads relevant data from the EAM interface. The relevant data includes: pre-maintenance data (monitoring period, completion date, PM title, predefined scope), completion report data (work order task number, work order task title, equipment (work item) code, work completion summary, defect cause, work completion details, spare parts consumption page (if any) material code, material name, practical quantity).

[0069] The data extraction module reads relevant data from the ERP interface. The relevant data includes: general inventory, available quantity, total available quantity, and quantity in purchase.

[0070] The data extraction module is used to parse the manually imported zip / rar format compressed package and extract the Excel table data contained therein.

[0071] The relevant data entered by the user in the software interface is read through the data extraction module.

[0072] The data annotation module is used to automatically annotate and classify the read data. The data types are divided into: basic equipment information, maintenance information, and aging identification information.

[0073] The data annotation module identifies the type and characteristics of the data and automatically classifies it into three main types based on preset rules and algorithms: basic equipment information, maintenance information, and aging identification information.

[0074] For each type of data, the data annotation module will apply corresponding annotation rules. For example, basic equipment information includes equipment model, component model, etc.; maintenance information includes maintenance time, maintenance content, defect cause, etc.

[0075] The data matching module is used to match the read data according to specific rules. Specifically, the completion report with the work order type of CM / DM is filtered, and the system number of the 2nd to 4th digits of the equipment (work item) code in the completion report is matched with the list of system responsible persons to achieve matching between the completion report and the system responsible person.

[0076] The data storage module is used to store the labeled data in the corresponding databases. According to the type of data and the labeling results, the data storage module stores the data in different databases. For example, basic equipment information is stored in the equipment database, while maintenance information is stored in the maintenance record database.

[0077] The data vertical search function of the system is mainly used for data display. When the equipment manager is preparing for work, he only needs to enter an equipment number, and the platform will automatically push relevant data. This will optimize the equipment management process, reduce human errors, and avoid staff spending a lot of time looking for information. The modules used to implement this function include equipment basic information module, maintenance information module, and aging identification information module.

[0078] The equipment basic information module is used to display the basic information of the equipment. The basic information includes: unit number, system number, equipment position number, equipment classification, equipment photo, component name, component code, component classification, component model, material code, manufacturer, component type, component installed quantity, working frequency, and operating environment.

[0079] The maintenance information module is used to display equipment defect maintenance information, maintenance experience feedback information of peer power plants, and preventive maintenance information. The maintenance information specifically includes: work task title, completion time, defect cause, work completion summary, measures taken, experience feedback, number of failures, layout life start point, commissioning start point, PMID, PMRQ, PM title, pre-maintenance cycle, and the last overhaul number.

[0080] Fault statistics and analysis are performed through the maintenance information module, which records and counts the number of faults and provides analysis of fault distribution, frequency and trend, so as to facilitate the identification of common failure modes and potential problems of equipment and provide a basis for preventive maintenance.

[0081] The aging identification information module is used to display aging identification information and aging improvement measures. The aging identification information includes: manufacturer / standard recommended life, spare parts supply, component aging mitigation strategy, sensitive components, key aging factors, aging mechanism, failure mode, and component manufacturer model.

[0082] In one embodiment, the aging identification information module identifies and displays sensitive components and key aging factors of the equipment, as well as their impact on equipment performance and lifespan, so as to help relevant personnel identify key maintenance objects and take targeted maintenance measures.

[0083] In one embodiment, the aging identification information module analyzes the aging mechanism and failure mode of the equipment and provides a scientific explanation and prediction of equipment aging, so as to help relevant personnel understand the nature and laws of equipment aging and provide a basis for formulating maintenance strategies.

[0084] In one embodiment, the aging identification information module records the manufacturer and model information of each component in the equipment so as to quickly find suitable spare parts or replacement products when needed.

[0085] In one embodiment, the aging identification information module provides references for relevant personnel to implement aging mitigation strategies based on the aging status and maintenance requirements of the equipment. These strategies include replacing aging components, adjusting operating parameters, and strengthening monitoring to delay the aging process of the equipment and improve equipment reliability.

[0086] The aging recognition function of the system is realized through the task allocation module, aging recognition module and data statistics module.

[0087] The task assignment module is used to automatically assign the completion report to the corresponding system manager according to the data matching rules and generate aging identification to-do items. The to-do items are displayed in a list, which includes: work order number, system number, equipment number, work task title, completion time, defect cause, work completion summary, and manager. The details of the to-do items can be viewed through each line of work order number, and the list can be exported and fuzzy query can be performed.

[0088] The aging identification module is used to manually determine whether the item is a defect. If it is a defect, a pop-up window will prompt the user to fill in the measures, and the relevant information will be synchronized to the maintenance information for display. At the same time, the number of faults will automatically increase by one.

[0089] After entering the details of the to-do item, determine whether the item is a defect. If it is a defect, a pop-up window will prompt the user to fill in the measures, and the relevant information (work task title, completion time, defect cause, brief description of work completion, measures taken) will be synchronized to the maintenance information for display, and the number of failures will be automatically increased by one; if it is not a defect, close the interface, define the type as empty, and synchronize the situation to the data statistics module.

[0090] The data statistics module is used to count the recognition history in the form of a list.

[0091] The list information includes: work order number, system number, equipment number, evaluation result (defect, non-defect, empty), work task title, completion time, defect cause, work completion summary, person in charge, and identification status (identified / unidentified).

[0092] In addition, the present application also provides an electronic device, including a memory and a processor, wherein the memory stores computer-readable instructions, and when the processor executes the computer-readable instructions, the vertical search method for aging data of electrical instrument equipment in a nuclear power plant is implemented.

[0093] In addition, the present application also provides a computer-readable storage medium, on which computer-readable instructions are stored. When the computer-readable instructions are executed, the vertical search method for aging data of electrical instrument equipment in a nuclear power plant described above is implemented.

[0094] Computer readable media include permanent and non-permanent, removable and non-removable media that can be implemented by any method or technology to store information. Information can be computer readable instructions, data structures, program modules or other data. Examples of computer storage media include, but are not limited to, phase change memory (PRAM), static random access memory (SRAM), dynamic random access memory (DRAM), other types of random access memory (RAM), read-only memory (ROM), electrically erasable programmable read-only memory (EEPROM), flash memory or other memory technology, compact disk read-only memory (CD-ROM), digital versatile disk (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices or any other non-transmission media that can be used to store information that can be accessed by a computing device.

[0095] The above description is only a specific implementation manner of the present application, but the protection scope of the present application is not limited thereto. Any changes or substitutions that can be easily conceived by any technician familiar with the technical field within the technical scope disclosed in the present application should be covered within the protection scope of the present application.

Claims

1. A vertical search method for aging data of electrical instrumentation equipment in a nuclear power plant, characterized in that: include: Step 101, obtain data in the EAM system, data in the ERP system, and import data; Step 102: parse the data in step 101 and store them in different databases; Step 103: extract the device number from each database as the main information of interest, and search for corresponding data in the database according to the device number input by the front end; Step 104: Display all data found in the database and historical data read from the PI in the software interface; Step 105: extract the system number in the equipment code from the maintenance information database, match it with the system number of the system manager, and generate an aging identification to-do item; Step 106: according to the aging identification result input by the front end, the specific data corresponding to the device is saved in the maintenance database; Step 107: Count the aging recognition history data.

2. The vertical search method for aging data of electrical instrumentation equipment in nuclear power plants according to claim 1 is characterized in that: In step 101, the data obtained from the EAM system includes pre-maintenance data and completion report data.

3. The vertical search method for aging data of electrical instrumentation equipment in nuclear power plants according to claim 2 is characterized in that: Pre-maintenance data includes monitoring period, completion date, PM title, and predefined scope.

4. The vertical search method for aging data of electrical instrumentation equipment in nuclear power plants according to claim 2 is characterized in that: The completion report data includes the work order task number, work order task title, equipment code, brief description of work completion, cause of defect, detailed description of work completion, material code of spare parts consumption page, material name, and practical quantity.

5. The vertical search method for aging data of electrical instrumentation equipment in nuclear power plants according to claim 1, characterized in that: In step 101, the data obtained from the ERP system includes normal inventory, available quantity, total available quantity, and quantity in procurement.

6. The vertical search method for aging data of electrical instrumentation equipment in nuclear power plants according to claim 1 is characterized in that: In step 105, the system number of the 2nd to 4th digits in the device code is extracted as the attention information.

7. The vertical search method for aging data of electrical instrumentation equipment in a nuclear power plant according to claim 1, characterized in that: In step 107, the aging identification historical data includes the work order number, system number, equipment number, evaluation result, work task title, completion time, defect cause, work completion summary, person in charge, identification status, and specialty.

8. A vertical search system for aging data of electrical equipment in nuclear power plants, characterized in that: include: Data extraction module, used to read data, parse compressed packages and extract table data; Data annotation module, used to automatically annotate and classify the read data; A data matching module is used to match the read data; A data storage module, used to store the marked data in corresponding databases; Equipment basic information module, used to display equipment basic information; Maintenance information module, used to display equipment defect maintenance information, maintenance experience feedback information of peer power plants and preventive maintenance information; Aging identification information module, used to display aging identification information and aging improvement measures; The task allocation module is used to automatically allocate the completion report to the corresponding system owner according to the data matching rules and generate aging identification to-do items; The aging identification module is used to manually determine whether the item is a defect. If it is a defect, a pop-up window will prompt the user to fill in the measures, and the relevant information will be synchronized to the maintenance information for display, and the number of faults will automatically increase by one; The data statistics module is used to count the recognition history, including the recognition history data and the recognition history information of the system owner.

9. An electronic device, characterized in that: The method comprises a memory and a processor, wherein the memory stores computer-readable instructions, and the processor implements the vertical search method for aging data of electrical instrument equipment in a nuclear power plant according to any one of claims 1 to 7 when executing the computer-readable instructions.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores computer-readable instructions, and when the computer-readable instructions are executed, the vertical search method for aging data of electrical instrumentation equipment in a nuclear power plant according to any one of claims 1 to 7 is implemented.

Images