Nuclear power overhaul data management platform management method

Abstract

The present application relates to the technical field of nuclear power, and particularly relates to a nuclear power overhaul data management method. The method is as follows: data in an external system is collected at regular intervals and stored in a HIVE database to form source layer data; the source layer data is developed through stream computing, processed into a valuable form for business, and written into a HIVE target table; the HIVE target table is written into a target database; data in each target database is distributed to a corresponding target application library and stored in the form of a target table; when data is stored in the HIVE database, the target database and the target application library, the storage structure is the same as the front-end page display directory structure; a picture configuration obtains current front-end page display requirements, and according to the display directory structure, corresponding target tables are called from the target application library and returned. The present application forms a unified data standard and data layering, which facilitates secondary processing and production of display pictures by the picture configuration on the data in the middle platform.

Description

Technical Field

[0001] This invention relates to the field of nuclear power technology, and in particular to a data management method for nuclear power plant overhaul. Background Technology

[0002] Nuclear power plant overhauls, also known as refueling overhauls, involve shutting down most systems and equipment of a nuclear power unit to replace fuel assemblies and perform extensive system and equipment maintenance to ensure safe production in the next fuel cycle. During a nuclear power plant overhaul, overhaul team members need to direct, manage, and coordinate the entire overhaul process from the Outage Control Center (OCC). This is because the OCC's maintenance data platform retrieves the necessary data for each overhaul cycle of the nuclear power plant from different systems, processes it through aggregation, development, management, and service, and then sends it to the OCC's display panel. The display panel then performs secondary processing on the data from the data platform and creates visual displays, enabling overhaul team members to direct, manage, and coordinate the entire overhaul process. Due to the unique nature of nuclear power data, designing a data platform with unified data standards and data layering to facilitate secondary processing and display of the data from the display panel is an urgent problem to be solved. Summary of the Invention

[0003] The technical problem to be solved by this invention is to provide a data management method for nuclear power plant overhaul, which forms a unified data standard and data layering, facilitates the secondary processing of data in the data platform and the creation of display screens, and effectively reduces the occurrence of screen display delays or inaccuracies caused by data calculation delays.

[0004] This invention provides a data management method for nuclear power plant overhauls, comprising the following steps:

[0005] Step S1: Data Acquisition: Periodically collect data from external systems and store it in the HIVE database to form source layer data;

[0006] Step S2: Data Processing: Develop the source layer data through streaming computing, process it into a form that is valuable to the business, and write it into the HIVE target table;

[0007] Step S3: Add a data mart: Write the HIVE target table from the HIVE database to the target database;

[0008] Step S4: Data Distribution: Distribute the data from each target database to the corresponding target application library and store it in the form of a target table; when the data is stored in the HIVE database, the target database, and the target application library, the storage structure is set to be the same as the directory structure displayed on the front-end page;

[0009] Step S5: The screen configuration obtains the current front-end page display requirements, and retrieves the corresponding target table from the target application library and returns it based on the display directory structure.

[0010] Preferably, the external system includes: SAP system and Oracle database.

[0011] Preferably, for Oracle databases, the data platform communicates directly and extracts data, which is then stored in the HIVE database to form source layer data;

[0012] For SAP systems, the data acquisition method is as follows:

[0013] The SAP modules required for the overhaul screen display are obtained, and corresponding configuration templates are generated for different SAP modules in different power plant SAP systems, so as to connect the RFC interface corresponding to the SAP module through the configuration module.

[0014] Obtain the data requirements needed to display the current overhaul screen, and configure the corresponding template based on the data requirements.

[0015] The actively acquired data is stored in a pre-defined HIVE database to form the source layer data.

[0016] Preferably, the configuration template includes a basic information configuration unit, an input parameter template configuration unit, and an output parameter template configuration unit.

[0017] The basic information is fixed after the configuration template is generated, and is used to represent the SAP module corresponding to the configuration module. The input parameter template configuration unit is used to configure the input parameter description of the RFC interface, including all input parameter field information corresponding to the SAP module; the output parameter template configuration unit is used to configure the output parameter description of the RFC interface, including all output parameter field information corresponding to the SAP module.

[0018] Preferably, step S2 specifically includes:

[0019] S21 Data Extraction: Filter the source layer data according to preset conditions to obtain the basic data required for front-end page display;

[0020] S22 Data Analysis: Based on the front-end display requirements, perform streaming calculations on the basic data, obtain the data directly required by the front-end page, and store it in the HIVE target table.

[0021] Preferably, in step S4: the display directory structure includes at least three levels: the first level is the component name, the second level is the indicator name, which is used to characterize the specific display items of each component, and the third level is the indicator value of each display item, which is calculated and obtained through the aforementioned step S22; the data storage standards of the HIVE database and the target database are set in the same way as the target structure directory, which is also at least three levels of storage.

[0022] Preferably, the names of the first-level components include: critical path and milestones, safety monitoring, project schedule, critical path water level, and quality management.

[0023] Preferably, the display items for the critical path and milestone components include the previous milestone and the next milestone;

[0024] The specific safety supervision demonstration items include nuclear safety, industrial safety, fire protection, radiation protection, and chemical control;

[0025] The project progress is displayed in detail below the project level, including statistics on completed, ongoing, and unstarted projects, as well as work order completion statistics.

[0026] The critical path water level map specifically displays: planned water level, actual water level, and predicted water level;

[0027] The specific presentation of quality management includes statistics on incomplete and completed tasks, and W / H witness statements.

[0028] Preferably, in step S5, the current front-end page display requirement is to display a single image or multiple images simultaneously.

[0029] After obtaining the current front-end page display requirements, the screen configuration sends a request to the data platform. The data platform parses the command, determines the information to be displayed, and searches for the component name, indicator name, and indicator value in the target table of the target application library according to the display directory. It then directly retrieves the above information and returns it to the screen configuration, which can then display the information directly.

[0030] Compared with existing technologies, the nuclear power plant overhaul data management method of the present invention has the following advantages:

[0031] (1) It can realize the functions of data collection, development, management and service required for the life cycle of each nuclear power unit overhaul, and combine the data of the nuclear power itself to form a unified data standard and data layering, so as to facilitate the secondary processing of the data in the middle platform and the production of display screens in the screen configuration.

[0032] (2) The data platform directly calculates and obtains the values ​​corresponding to each display item in the display catalog structure;

[0033] (3) Provide a unified display catalog structure. Since the data platform has calculated and obtained the values ​​corresponding to each display item in the display catalog structure and stored the data according to the display catalog structure, when the screen configuration is displaying the screen, it sends a request to the data platform. After the data platform obtains the request, it parses the command to obtain the display catalog structure required for the current screen to be displayed. Then, based on the specific information of the display catalog structure, it searches for the corresponding target table in the target application library and returns the above information to the screen configuration. The screen configuration can directly display the screen based on the above information without additional calculation work, which can effectively improve the speed of screen display.

[0034] (4) It can display multiple screens at the same time, effectively meeting the data display needs during nuclear power plant overhauls and effectively reducing the occurrence of screen display delays or inaccuracies caused by data calculation delays.

[0035] (5) When SAP collects data, it generates corresponding configuration templates for each SAP module required for the screen display according to the overhaul screen display requirements. Each configuration template includes a basic information configuration unit, an input parameter template configuration unit, and an output parameter template configuration unit. The basic information is fixed after the configuration template is generated and is used to represent the correspondence between the configuration template and the SAP module. The input parameter template configuration unit and the output parameter template configuration unit include all the input and output parameters of the current SAP module. After the configuration template is published, it can be connected to the RFC interface corresponding to the specified SAP module through the configuration template. During operation, according to the current screen display requirements, the corresponding input and output parameters in the input parameter template configuration unit and the output parameter template configuration unit can be selected to extract the specified data of the SAP module, thereby effectively solving the data collection and extraction problem of the SAP system. Attached Figure Description

[0036] Figure 1 This diagram illustrates the data interaction between the data platform and the screen configuration data. Detailed Implementation

[0037] To further understand the present invention, embodiments of the present invention are described below in conjunction with examples. However, it should be understood that these descriptions are only for further illustrating the features and advantages of the present invention, and not for limiting the present invention.

[0038] An embodiment of the present invention discloses a data management method for nuclear power plant overhaul, comprising the following steps:

[0039] Step S1: Data Acquisition: Periodically collect data from external systems and store it in the HIVE database to form source layer data;

[0040] The external systems include: SAP system and Oracle database.

[0041] For Oracle databases, the data platform communicates directly with and extracts data, then stores it in the HIVE database to form source layer data.

[0042] For SAP systems, since existing SAP systems do not support direct database connections and can only extract data through RFC interfaces, and the data extraction process varies between different SAP systems, the limitations of direct database connections can be addressed.

[0043] Therefore, the SAP system data acquisition method is as follows:

[0044] The SAP modules required for the overhaul screen display are obtained, and corresponding configuration templates are generated for different SAP modules in different power plant SAP systems, so as to connect the RFC interface corresponding to the SAP module through the configuration module.

[0045] Each configuration template includes a basic information configuration unit, an input parameter template configuration unit, and an output parameter template configuration unit. The basic information is fixed after the configuration template is generated and is used to represent the SAP module to which the configuration module is collected. The input parameter template configuration unit is used to configure the input parameter description of the RFC interface, including all input parameter field information corresponding to the SAP module. The output parameter template configuration unit is used to configure the output parameter description of the RFC interface, including all output parameter field information corresponding to the SAP module.

[0046] Obtain the data requirements needed for the current overhaul screen display, and configure the corresponding configuration template according to the data requirements. The configuration includes configuring some fields of the input and output parameter template configuration units according to the data requirements, so as to trigger the corresponding RFC interface to collect data from the SAP module.

[0047] The actively acquired data is stored in a pre-defined HIVE database to form the source layer data.

[0048] After each configuration module is released, the HIVE database will perform corresponding table structure modeling to store the data returned by the SAP system.

[0049] The above method generates corresponding configuration templates for each SAP module required for the overhaul display based on the display requirements. Each configuration template includes a basic information configuration unit, an input parameter template configuration unit, and an output parameter template configuration unit. The basic information is fixed after the configuration template is generated and is used to represent the correspondence between the configuration template and the SAP module. The input parameter template configuration unit and the output parameter template configuration unit include all the input and output parameters of the current SAP module. After the configuration template is published, it can be used to connect to the RFC interface corresponding to the specified SAP module. During operation, according to the current display requirements, the corresponding input and output parameters in the input parameter template configuration unit and the output parameter template configuration unit can be selected to extract specified data from the SAP module, thereby effectively solving the data collection and extraction problem of the SAP system.

[0050] Step S2: Data Processing: Develop the source layer data through streaming computing, process it into a form that is valuable to the business, and write it into the HIVE target table;

[0051] Specifically, it includes:

[0052] S21 Data Extraction: Filter the source layer data according to preset conditions to obtain the basic data required for front-end page display;

[0053] S22 Data Analysis: Based on the front-end display requirements, perform streaming calculations on the basic data, obtain the data directly required by the front-end page, and store it in the HIVE target table.

[0054] Since the display items of each component are different, in order to obtain the corresponding indicator values ​​for each item, the preset conditions for data filtering and the calculation logic of indicator values ​​in step S2 can be set according to the needs of the front-end display of the project. For example, if the previous milestone is used to indicate the current status, current time node, etc., the corresponding filtering condition is to perform a preliminary screening of the source layer data according to the current time to obtain the basic data related to the current time point; then, for the lower-level display items, two calculation logics are set for the current time node and current status respectively, so as to obtain the specific year, month, and day time information and grid connection status information from the basic data, and then store them in the HIVE database in two preset form formats before finally transmitting them to the target application library.

[0055] Step S3: Add a data mart: Write the HIVE target table from the HIVE database to the target database;

[0056] Considering that the data in the HIVE database is stored in file format and is located at a lower level, it cannot be directly used by the screen configuration. Therefore, in this embodiment, the data in the Hive database is imported into the target application library, i.e., the MySQL database, through the data mart in step S3, so that the screen configuration can directly retrieve it. Specifically, the data mart configures physical sources for each HIVE target table. The physical source records detailed MySQL information, including IP, address, and data source name, etc. The HIVE target table is then imported and stored into the MySQL database through the corresponding physical source.

[0057] Step S4: Data Distribution: Distribute the data from each target database to the corresponding target application library and store it in the form of a target table; when the data is stored in the HIVE database, the target database, and the target application library, the storage structure is set to be the same as the directory structure displayed on the front-end page;

[0058] When distributing line data, the target application library corresponding to the overhaul display can be found based on the physical source, and then the data required by the overhaul display can be finally transmitted to the target application library for storage, and then directly called by the screen configuration.

[0059] As a preferred embodiment, the display directory structure in this embodiment includes at least three levels: the first level is the component name, the second level is the indicator name, which is used to characterize the specific display items of each component, and the third level is the indicator value of each display item, which is calculated and obtained through the aforementioned step S22; the data storage standards of the HIVE database and the target database are set in the same way as the target structure directory, which is also at least three levels of storage.

[0060] The first-level component names include: Critical Path and Milestones, Safety Monitoring, Project Schedule, Critical Path Watermark, and Quality Management.

[0061] The critical path and milestone components include the previous milestone and the next milestone.

[0062] The specific safety supervision demonstration items include nuclear safety, industrial safety, fire protection, radiation protection, and chemical control;

[0063] The project progress is displayed in detail below the project level, including statistics on completed, ongoing, and unstarted projects, as well as work order completion statistics.

[0064] The critical path water level map specifically displays: planned water level, actual water level, and predicted water level;

[0065] The specific presentation of quality management includes statistics on incomplete and completed tasks, and W / H witness statements.

[0066] Step S5: The screen configuration obtains the current front-end page display requirements, and retrieves the corresponding target table from the target application library and returns it based on the display directory structure.

[0067] In step S5, the current front-end page display requirement is to display a single image or multiple images simultaneously.

[0068] After obtaining the current front-end page display requirements, the screen configuration sends a request to the data platform. The data platform parses the command, determines the information to be displayed, and searches for the component name, indicator name, and indicator value in the target table of the target application library according to the display directory. It then directly retrieves the above information and returns it to the screen configuration, which can then display the information directly.

[0069] The nuclear power plant overhaul data management system described in this invention can realize the functions of data aggregation, development, management, and service for the life cycle of each overhaul of nuclear power units. It also combines the nuclear power plant's own data to form a unified data standard and data hierarchy, facilitating secondary processing and display of the data by screen configuration tools. For example... Figure 1 As shown, since the data platform has already calculated and obtained the values ​​corresponding to each display item in the display catalog structure, and stored the data according to the display catalog structure, when the screen configuration is displaying a screen, it sends a request to the data platform. After receiving the request, the data platform parses the command to obtain the display catalog structure required for the current screen to be displayed. Then, based on the specific information of the display catalog structure, it searches for the corresponding information in the target table of the target application library and returns the above information to the screen configuration. The screen configuration can directly display the screen based on the above information without additional calculation work, which can effectively improve the speed of screen display. At the same time, when multiple screens need to be displayed, it can also effectively reduce the occurrence of screen display delays or inaccuracies caused by data calculation delays.

[0070] The above description of the embodiments is only for the purpose of helping to understand the method and core ideas of the present invention. It should be noted that those skilled in the art can make several improvements and modifications to the present invention without departing from the principles of the present invention, and these improvements and modifications also fall within the protection scope of the claims of the present invention.

[0071] The above description of the disclosed embodiments enables those skilled in the art to make or use the invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the invention is not to be limited to the embodiments shown herein, but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A nuclear power plant overhaul data management platform management method, characterized in that, The method comprises the following steps: Step S1: data collection: collecting data in the SAP system in a timely manner and storing into the HIVE database to form the source-adhering layer data; for the SAP system, the data collection method is as follows: Obtaining the SAP module required for the overhaul picture display, and for different SAP modules in different power plant SAP systems, corresponding configuration templates are generated one by one to connect the RFC interface corresponding to the SAP module through the configuration module; Obtaining the data requirement required for the current overhaul picture display, and configuring the corresponding configuration template according to the data requirement, Storing the actively obtained data into the preset HIVE database to form the source-adhering layer data; Step S2: data processing: developing the source-adhering layer data through stream computing, processing it into a form valuable to the business, and writing it into the HIVE target table; Specifically comprising: S21 data extraction: screening the source-adhering layer data according to the preset condition to obtain the basic data required for the front-end page display; S22 data analysis: according to the front-end display requirement, performing stream computing on the basic data, obtaining the data required for the front-end page display, and storing it into the HIVE target table; Step S3: adding data mart: writing the HIVE target table in the HIVE database into the target database; Step S4: data distribution: distributing the data in each target database to the corresponding target application library and storing it in the form of a target table; the storage structure of the data in the HIVE database, the target database and the target application library is the same as the setting of the front-end page display directory structure; the display directory structure comprises at least three levels of structure: the first level is the component name, the second level is the index name: used to represent the specific display project of each component, and the third level is the index value of each display project, which is obtained by the foregoing step S22; the data storage standard of the HIVE database and the target database is the same as the setting of the target structure directory, and is also at least three levels of storage; Step S5: picture configuration: obtaining the current front-end page display requirement, and according to the display directory structure, calling the corresponding target table from the target application library and returning.

2. The nuclear power plant overhaul data management method of claim 1, wherein, The configuration template comprises a basic information configuration unit, an input parameter template configuration unit and an output parameter template configuration unit, The basic information is fixed after the configuration template is generated, and is used to represent the SAP module collected by the configuration module; the input parameter template configuration unit is used to configure the input parameter description of the RFC interface, including all input parameter field information corresponding to the SAP module; the output parameter template configuration unit is used to configure the output parameter description of the RFC interface, including all output parameter field information corresponding to the SAP module.

3. The nuclear power plant overhaul data management method of claim 1, wherein, The first level component name comprises: critical path and milestone, safety supervision, project progress, critical path water level diagram and quality management.

4. The nuclear power plant overhaul data management method of claim 3, wherein, The display projects of the critical path and milestone component include the last milestone and the next milestone; The specific display projects of the safety supervision include nuclear safety, industrial safety, fire protection, radiation protection and chemical control; The lower specific display projects of the project progress include completed, in progress, unstarted project statistics and work order completion statistics; The specific display of the critical path water level diagram includes: planned water level, actual water level, and predicted water level; The specific display of quality management includes unfinished, completed statistics, and W / H witness sheet.

5. The nuclear power plant overhaul data management method of claim 1, wherein, In the step S5, the current front-end page display requirement is to display a single screen or to display multiple screens simultaneously, After the screen configuration obtains the current front-end page display requirement, a request is sent to the data platform, the data platform analyzes the command, judges the information to be displayed this time, and according to the display directory, the target table of the target application library is searched for the component name, index name and index value, and then the above information is directly called and returned to the screen configuration. The screen configuration can directly display according to the above information.

Images