CN112765232A - Data management method and system for nuclear power plant major equipment - Google Patents
Data management method and system for nuclear power plant major equipment Download PDFInfo
- Publication number
- CN112765232A CN112765232A CN202110009306.3A CN202110009306A CN112765232A CN 112765232 A CN112765232 A CN 112765232A CN 202110009306 A CN202110009306 A CN 202110009306A CN 112765232 A CN112765232 A CN 112765232A
- Authority
- CN
- China
- Prior art keywords
- data
- service
- display model
- equipment
- power plant
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000013523 data management Methods 0.000 title claims abstract description 28
- 238000000034 method Methods 0.000 title claims abstract description 25
- 238000007781 pre-processing Methods 0.000 claims abstract description 18
- 230000036541 health Effects 0.000 claims abstract description 15
- 238000006243 chemical reaction Methods 0.000 claims abstract description 12
- 238000004140 cleaning Methods 0.000 claims abstract description 9
- 238000000605 extraction Methods 0.000 claims description 32
- 230000004927 fusion Effects 0.000 claims description 20
- 238000012545 processing Methods 0.000 claims description 10
- 238000003860 storage Methods 0.000 claims description 9
- 230000008859 change Effects 0.000 claims description 4
- 238000007499 fusion processing Methods 0.000 claims description 3
- 238000012544 monitoring process Methods 0.000 abstract description 10
- 238000007726 management method Methods 0.000 description 7
- 230000000007 visual effect Effects 0.000 description 7
- 238000007689 inspection Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000012423 maintenance Methods 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 238000013075 data extraction Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000007547 defect Effects 0.000 description 2
- 238000003745 diagnosis Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000000737 periodic effect Effects 0.000 description 2
- 230000002159 abnormal effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000007705 chemical test Methods 0.000 description 1
- 238000010219 correlation analysis Methods 0.000 description 1
- 238000013480 data collection Methods 0.000 description 1
- 238000013506 data mapping Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 238000002474 experimental method Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000005065 mining Methods 0.000 description 1
- 239000000126 substance Substances 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
- 238000012800 visualization Methods 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2462—Approximate or statistical queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/283—Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Probability & Statistics with Applications (AREA)
- Economics (AREA)
- Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- Human Resources & Organizations (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Testing And Monitoring For Control Systems (AREA)
- Monitoring And Testing Of Nuclear Reactors (AREA)
Abstract
The invention relates to a data management method and a system for major equipment of a nuclear power plant, wherein the data management method comprises the following steps in a Hadoop platform: extracting various types of data from different business systems; preprocessing the extracted data, wherein the preprocessing comprises data cleaning and data format conversion; summarizing the preprocessed data according to the service requirement; and visually displaying the summarized data according to the service requirements. By implementing the technical scheme of the invention, the comprehensive monitoring and health assessment of the running state of the heavy equipment by the user are realized.
Description
Technical Field
The invention relates to the field of nuclear power, in particular to a data management method and system for major equipment of a nuclear power plant.
Background
Along with the gradual production on-line of a nuclear power unit, the installed capacity is continuously created, the data volume generated by each service system is continuously increased while the services in the nuclear power field are continuously expanded, and the data management has more and more important effect display on the aspects of enterprise service enabling and performance improvement. At present, data related to 8+1 major equipment in a nuclear power plant are distributed in different systems of the power plant, data formats of the systems are not unified, a data island exists, and visual and unified display on numerous data cannot be realized, so that an engineer is inconvenient and inefficient when inquiring the related data of the 8+1 major equipment, the labor cost is wasted, the data cannot be subjected to correlation analysis, and the operation state of the major equipment can be known from the whole situation.
Disclosure of Invention
The invention aims to solve the technical problem of providing a data management method and system for important equipment of a nuclear power plant, aiming at the defect that a large number of data cannot be displayed in a unified manner in the prior art.
The technical scheme adopted by the invention for solving the technical problems is as follows: a data management method for nuclear power plant major equipment is constructed, and the following steps are carried out in a Hadoop platform:
s10, extracting various types of data from different service systems;
s20, preprocessing the extracted data, wherein the preprocessing comprises data cleaning and data format conversion;
s30, summarizing the preprocessed data according to the service requirements;
and S40, visually displaying the summarized data according to the service requirements.
Preferably, before step S30, the method further includes:
s50, acquiring real-time data from an aigret database through a micro service or an interface;
the step S30 includes:
and summarizing the real-time data and the preprocessed data according to the service requirement.
Preferably, the step S30 includes:
determining a corresponding association mode according to the service requirement;
and performing data association on the preprocessed data according to the determined association mode, wherein the data association mode comprises the following steps: a function position correlation mode, a service scene correlation mode, a service flow correlation mode, a statistical index demand correlation mode and a label correlation mode.
Preferably, the step S30 further includes:
determining a corresponding data fusion architecture according to business requirements and data characteristics, wherein the data fusion architecture comprises a virtualized data fusion architecture and a physical data fusion architecture;
and performing fusion processing on the preprocessed data according to the determined data fusion architecture.
Preferably, the step S40 includes:
determining a corresponding service display model according to service requirements, and visually displaying the summarized data by using the determined service display model, wherein the service display model comprises: the system comprises a three-dimensional display model, an individualized cockpit display model, a statistical form display model, an equipment archive display model, an equipment statistical index display model and an equipment health report display model.
Preferably, the step S10 includes:
determining extraction strategies and extraction frequencies of various data according to business requirements and data characteristics, wherein the extraction strategies comprise: full extraction, incremental extraction, new addition and change extraction;
and extracting corresponding data from the corresponding service system according to the determined extraction strategy and the extraction frequency.
Preferably, the method further comprises the following steps:
s60, establishing a data warehouse, and storing data in corresponding data layers of the data warehouse in a layered storage mode, wherein the first data layer is used for storing the extracted data; the second data layer is used for storing the preprocessed data; and the third data layer is used for storing the summarized data.
The invention constructs a data management system of nuclear power plant major equipment, which comprises the following components:
the extraction module is used for extracting various types of data from different business systems;
the preprocessing module is used for preprocessing the extracted data, and the preprocessing comprises data cleaning and data format conversion;
the summarizing processing module is used for summarizing the preprocessed data according to the service requirement;
and the display module is used for visually displaying the summarized data according to the service requirements.
Preferably, a real-time data acquisition module is also included, and,
the real-time data acquisition module is used for acquiring real-time data from the aigret database through a micro service or an interface;
and the summarizing processing module is used for summarizing the real-time data and the preprocessed data according to the service requirements.
Preferably, the display module is configured to determine a corresponding service display model according to a service requirement, and perform visual display on the summarized data by using the determined service display model, where the service display model includes: the system comprises a three-dimensional display model, an individualized cockpit display model, a statistical form display model, an equipment archive display model, an equipment statistical index display model and an equipment health report display model.
According to the technical scheme provided by the invention, relevant data of the major equipment scattered in each isolated service system of the nuclear power plant can be collected, combed and summarized, and the data of the major equipment can be displayed in a multidimensional and centralized manner according to service requirements, so that the comprehensive monitoring and health assessment of the running state of the major equipment by a user can be realized.
Drawings
In order to illustrate the embodiments of the invention more clearly, the drawings that are needed in the description of the embodiments will be briefly described below, it being apparent that the drawings in the following description are only some embodiments of the invention, and that other drawings may be derived from those drawings by a person skilled in the art without inventive effort. In the drawings:
FIG. 1 is a flow chart of a first embodiment of a method for managing data of a nuclear power plant capital equipment in accordance with the present invention;
FIG. 2 is a technical architecture diagram of the present invention for implementing data management of a nuclear power plant's critical equipment in a Hadoop platform;
FIG. 3 is a schematic illustration of the present invention using an equipment archive presentation model for visual presentation;
fig. 4 is a logical structure diagram of a first embodiment of the data management system of the nuclear power plant significant equipment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
According to the invention, the data related to the 8+1 major equipment scattered in each isolated system of the power plant at present is collected, analyzed, processed by service combing and summarized, and the data of the 8+1 major equipment is displayed in a multidimensional and centralized manner, so that the comprehensive monitoring and health assessment of the 8+1 major equipment operation state by a user are realized.
The technical scheme of the invention is developed based on a star-loop Hadoop platform, provides various component tools such as HDFS, Yarn, Zookeeper, Spark and the like in the existing Hadoop ecology, improves the stability, safety, speed and the like of the performance of each component on the basis of an open source platform, and simultaneously provides a support standard SQL interface for conveniently transferring data stored in a power plant and in a traditional relational database to the TDH platform, thereby realizing the fusion of relevant service data of '8 + 1' major equipment.
Fig. 1 is a flowchart of a first embodiment of the data management method for the nuclear power plant significant equipment according to the present invention, the data management method for the nuclear power plant significant equipment of the embodiment is based on a Hadoop platform and related visualization tools, and performs steps S10 to S40, where each step is described below:
and S10, extracting various types of data from different business systems.
S20, preprocessing the extracted data, wherein the preprocessing comprises data cleaning and data format conversion;
s30, summarizing the preprocessed data according to the service requirements;
and S40, visually displaying the summarized data according to the service requirements.
Further, before step S30, the method further includes:
s50, acquiring real-time data from an aigret database through a micro service or an interface;
further, step S30 includes: and summarizing the real-time data and the preprocessed data according to the service requirement.
Further, the data management method of the nuclear power plant significant equipment further comprises the following steps:
s60, establishing a data warehouse, and storing data in corresponding data layers of the data warehouse in a layered storage mode, wherein the first data layer is used for storing the extracted data; the second data layer is used for storing the preprocessed data; and the third data layer is used for storing the summarized data.
The contents of the various steps in some specific embodiments are described below in conjunction with FIG. 2:
in step S10, it is first explained that the relevant data of the "8 + 1" major equipment in the nuclear power plant is derived from different business systems, has different storage manners and data formats, and has both structured data and semi-structured and unstructured data, specifically, as shown in the interface system summary table shown in table 1 and the access system database type and deployment location condition table shown in table 2:
TABLE 1
TABLE 2
In step S20, the extracted data needs to be preprocessed, including data cleaning and data format conversion. The data cleaning processing comprises removing invalid values and filling missing values; regarding data format conversion, it should be noted that, formats of data in different service systems of a nuclear power plant are not uniform at present, so that data is difficult to fuse and analyze, and in order to improve data standardization degree and facilitate subsequent data integration, analysis and use, information of each field in the data needs to be identified and unified, and a data format conversion rule is as follows:
(1) power station: data is derived from the basic data part of the equipment management big data platform, for example, D: gulf of asia; l: ling ao.
(2) The unit: the data is from a basic data part of an equipment management big data platform, for example, 1-6 parts are special for a power plant unit; 0: the factory is special; 9: special for machine set No. 1/2; 8: special for machine set No. 3/4; 7: specific to set No. 5/6.
(3) System code: data is derived from the basic data part of the equipment management big data platform, such as ARE: the steam generator is a main water supply system.
In addition, the function position conversion rule is shown in table 3:
TABLE 3
In connection with table 3, the conversion logic is:
the first section is a station code (1 bit or 2 bits), the code occupies 2 bits, if 1 bit, the 2 nd bit is not filled;
the second section is a unit number (1 bit), and the unit number of the original function position is taken;
the third section is a system classification code (2 bits), and the system classification code is obtained by searching a system classification list table according to the system code correlation of the original function position;
the fourth segment is system code (3 bits or 4 bits), the original function position is taken to code the system code, generally 3 bits, if more than 3 bits, the fourth bit is complemented
And the fifth, sixth and seventh sections take the residual values of the original function positions to fill up.
In one embodiment, step S30 may include:
s31, determining a corresponding association mode according to the service requirement;
s32, performing data association on the preprocessed data according to the determined association mode, wherein the data association mode comprises the following steps: a function position correlation mode, a service scene correlation mode, a service flow correlation mode, a statistical index demand correlation mode and a label correlation mode.
In this embodiment, the data association manner is analyzed and determined according to the actual service of the power plant, and the detailed description of the five association manners is as follows:
1. the association is made by functional location: different types of data scattered in each service system are associated through the common field of the function position, all relevant data of a certain or a plurality of function positions can be obtained through the method, and the function position/equipment file information is formed, so that a user can conveniently inquire and know the 'foregone and today' of the function position;
2. performing association through a service scene: according to different role requirements of nuclear safety engineers, operation engineers, system engineers, point inspection engineers and the like, analyzing the levels (units, systems, equipment and the like), dimensions, types and the like of concerned data of the nuclear safety engineers, the operation engineers, the system engineers, the point inspection engineers and the like, associating the related data aiming at specific service scenes, displaying the related data to a user in a personalized cockpit mode, and displaying the data required by the engineers in different roles in daily work in a one-stop mode;
3. performing association through a business process: researching and analyzing the service flow managed by the equipment, selecting one or more main line service flows, associating related data in the flows according to the requirements of data required to be filled/referred in the flow process, realizing automatic acquisition and display of the service data in the flows, providing the data required in the flow process of the service flow for users, improving the analysis, management, application and operation capacity of the data, and improving the operation efficiency of the service flow;
4. correlation is performed through statistical index requirements: according to various indexes of the equipment CHR, ERI, SHR and the like and the statistical requirements of various parts of services required in work, correlation and statistics are carried out on related data, so that index data calculation and daily statistics are facilitated for users, and the working efficiency of the users is improved;
5. association by tag: the user can mark different labels on various acquired data according to the requirement in daily work, and the system can correlate various data according to the label marked by the user or others, so that the user can acquire and analyze the data conveniently according to the label.
In a specific embodiment, step S30 further includes:
s33, determining a corresponding data fusion framework according to business requirements and data characteristics, wherein the data fusion framework comprises a virtualized data fusion framework and a physical data fusion framework;
and S34, carrying out fusion processing on the preprocessed data according to the determined data fusion framework.
In the embodiment, a proper data fusion architecture is selected according to business requirements, system and data characteristics, and in order to improve the utilization rate, data quality and standardization degree of data and simultaneously consider the characteristics of fixed real-time data mapping relation and large data volume, the embodiment adopts a physical and virtual data fusion architecture. Two architectures will be described below, and their respective advantages and disadvantages will be analyzed:
1. virtualized data fusion architecture: when a system is queried by a user defined by a virtual layer, related data sources to be queried are judged first, then the data sources are decomposed into different sub-queries according to different data sources, the sub-queries are executed by proper data sources, and the data are properly combined and then fed back to the user.
2. The physical data fusion architecture comprises the following steps: the data will be instantiated at a global level in the same data warehouse. The data warehouse will merge data from multiple data sources that are extracted, converted, and loaded (ETL) into the data warehouse. The physical architecture has the advantages that after data integration is completed, the data can be more conveniently multiplexed, the data can be applied to other systems through means such as interfaces, micro services and the like, the project development cost is saved, the resource utilization rate is improved, and the problems of maintenance of an incremental view and synchronization between a data warehouse and a bottom data source are faced.
In the technical scheme of the embodiment, the data to be accessed mainly comprises various data such as real-time monitoring data, schema, intelligent diagnosis, periodic experiment, maintenance, QDR, chemical data, vibration, routing inspection, equipment problems and the like, wherein the real-time monitoring data is uniformly stored in an aigret database, and other data are distributed in different business systems. The project adopts a virtual and materialized architecture mode, wherein the real-time data is fused in the virtualization architecture mode due to the reasons of large data volume, fixed data source and fixed association relation; and other types of data are fused in a physical architecture mode, and are extracted and stored in a data warehouse through an ETL tool for application.
In one embodiment, step S40 includes: determining a corresponding service display model according to service requirements, and visually displaying the summarized data by using the determined service display model, wherein the service display model comprises: the system comprises a three-dimensional display model, an individualized cockpit display model, a statistical form display model, an equipment archive display model, an equipment statistical index display model and an equipment health report display model.
In the embodiment, taking the three-dimensional display model as an example, the three-dimensional display model can be combined with a power plant service scene to comb a three-dimensional model of existing important equipment of a nuclear power plant, construct a three-dimensional service scene with the important equipment as a center, analyze service logic among information systems, and realize dynamic association of the three-dimensional model with real-time monitoring data and historical offline data. In addition, the display model of the individual cockpit, the display model of the statistical report form, the display model of the equipment file, the display model of the equipment statistical index and the display model of the equipment health report can be used for carrying out visual display. For example, as shown in fig. 3, when the device archive display model is used for displaying, the data association mode is a functional location association mode, and the following data are displayed in a text mode, a chart mode, an audio-video mode, and the like: data of the equipment design stage, two-dimensional information of the equipment, three-dimensional information of the equipment, real-time data of the equipment, SAP operation, inspection, monitoring and debugging information of the equipment, basic information/experience feedback information of the equipment and the like.
Further, in a specific embodiment, step S10 includes:
determining extraction strategies and extraction frequencies of various data according to business requirements and data characteristics, wherein the extraction strategies comprise: full extraction, incremental extraction, new addition and change extraction;
and extracting corresponding data from the corresponding service system according to the determined extraction strategy and the extraction frequency.
In this embodiment, the extraction policy includes: full, incremental, new and changed, i.e. storing complete data, storing newly added data and changed data; the extraction frequency is how often the data is updated.
In practical application, except that all data needs to be stored in full amount when the data is initialized for the first time, data extraction frequency and strategy are analyzed and formulated subsequently according to the characteristics of the total amount of data, data addition and change frequency, data increment and the like in the system. If the data storage capacity in the service system is less, the data can be completely extracted by using a full-quantity updating strategy; if the data volume is large and the original data cannot be changed, incremental backup is adopted; and if the phenomenon of upgrading the original data exists, adopting a newly increased and changed data updating strategy.
The data extraction frequency is determined according to the data updating frequency in the service system, for example, the data in the equipment reliability database is updated once a year, the data cannot be edited in the period, and the data extraction frequency is determined to be once a year or half a year; for online data, a real-time updating mode is adopted due to high real-time performance.
Therefore, corresponding extraction frequency and extraction strategies can be determined for different types of data according to the service and data characteristics of the power plant, and the data can be extracted according to established strategies through ETL/SAP SLT, micro-service and the like based on the Hadoop platform.
In addition, regarding the storage of data, in step S60, the data is stored in the corresponding data layer of the data warehouse in a hierarchical storage manner. Specifically, the data layer includes the following three layers: the system comprises an ODS layer (a first data layer), a DWD layer (a second data layer) and a DWS layer (a third data layer), wherein the ODS layer is the layer closest to a source data system and used for storing data extracted from each service system in an original form, the data structure of the ODS layer is consistent with that of the source data structure, no processing is performed, and data collection is performed efficiently; the DWD layer is a detail data layer and is used for storing the cleaned and converted data. The DWS layer is a service data layer, and various data are counted and summarized based on the DWD layer according to the equipment management service.
Fig. 4 is a logical structure diagram of a first embodiment of the data management system of the nuclear power plant significant equipment, and the data management system of the embodiment includes: the system comprises an extraction module 10, a preprocessing module 20, a summary processing module 30 and a display module 40, wherein the extraction module 10 is used for extracting various types of data from different business systems; the preprocessing module 20 is configured to perform preprocessing on the extracted data, where the preprocessing includes data cleaning and data format conversion; the summarizing processing module 30 is used for summarizing the preprocessed data according to the service requirement; the display module 40 is configured to visually display the summarized data according to the service requirement, and specifically, the display module 40 may be configured to determine a corresponding service display model according to the service requirement, and visually display the summarized data by using the determined service display model, where the service display model includes: the system comprises a three-dimensional display model, an individualized cockpit display model, a statistical form display model, an equipment archive display model, an equipment statistical index display model and an equipment health report display model.
Furthermore, the data management system also comprises a real-time data acquisition module, wherein the real-time data acquisition module is used for acquiring real-time data from the aigrette database through a micro service or an interface; and the summarizing processing module is used for summarizing the real-time data and the preprocessed data according to the service requirements.
Furthermore, the data management system of the invention further comprises a storage module, wherein the storage module is used for establishing a data warehouse and storing data in corresponding data layers of the data warehouse in a layered storage mode, and the first data layer is used for storing the extracted data; the second data layer is used for storing the preprocessed data; and the third data layer is used for storing the summarized data.
The technical scheme of the invention integrates and visually displays the service data required by equipment management of the nuclear power plant, and specifically, the data with different dimensions and different types of main pumps, turbines, steam generators, diesel engines, generators, main transformers, condensers, important pump sets and cold sources are integrated, and the integrated data are visually displayed in various ways, so that technical support and auxiliary decision support are provided for the management and health assessment of the large equipment.
According to the invention, multi-source data are analyzed and sorted, various data such as 8+1 major equipment real-time monitoring, outline, intelligent diagnosis, periodic test, maintenance, chemical test, vibration, inspection, defect problem and the like are fused based on a large data processing platform and tools thereof, statistics and analysis are carried out on the multi-source data, the multi-source data are visually displayed through various means such as three-dimension and report forms, a set of complete 8+1 major equipment state monitoring visual platform is formed, and the comprehensive monitoring and health assessment of the running state of the 8+1 major equipment are realized. Therefore, the following beneficial effects are achieved:
1. existing information resources of a power plant are fully utilized, data links among systems are opened, data islands are broken, source data summarization is achieved, data standards and formats are unified, and a good foundation is laid for mining data values;
2. the visual display model is constructed, various types of relevant data of 8+1 major equipment are combined with the three-dimensional model, the equipment state is more visually and intuitively displayed, the health state information of the equipment is displayed in real time, the abnormal equipment can be quickly positioned, the health evaluation is carried out, and the fault early warning is visual.
3. The health file of the equipment is established, data can be checked at any time, changes of indexes can be monitored at any time, working requirements of field operators and operation and maintenance personnel are met in the modes of characters, charts (bar charts, pie charts, tree charts, broken line charts, scatter diagrams, radar charts and the like), audios and videos and the like, and information of required equipment can be acquired quickly.
The above description is only a preferred embodiment of the present invention and is not intended to limit the present invention, and various modifications and changes may be made by those skilled in the art. Any modification, equivalent replacement, or improvement made within the spirit and principle of the present invention should be included in the scope of the claims of the present invention.
Claims (10)
1. A data management method for nuclear power plant major equipment is characterized in that the following steps are carried out in a Hadoop platform:
s10, extracting various types of data from different service systems;
s20, preprocessing the extracted data, wherein the preprocessing comprises data cleaning and data format conversion;
s30, summarizing the preprocessed data according to the service requirements;
and S40, visually displaying the summarized data according to the service requirements.
2. The data management method for the nuclear power plant significant equipment according to claim 1, before the step S30, further comprising:
s50, acquiring real-time data from an aigret database through a micro service or an interface;
the step S30 includes:
and summarizing the real-time data and the preprocessed data according to the service requirement.
3. The data management method for the nuclear power plant significant equipment according to claim 1, wherein the step S30 includes:
determining a corresponding association mode according to the service requirement;
and performing data association on the preprocessed data according to the determined association mode, wherein the data association mode comprises the following steps: a function position correlation mode, a service scene correlation mode, a service flow correlation mode, a statistical index demand correlation mode and a label correlation mode.
4. The data management method for the nuclear power plant significant equipment according to claim 1, wherein the step S30 further includes:
determining a corresponding data fusion architecture according to business requirements and data characteristics, wherein the data fusion architecture comprises a virtualized data fusion architecture and a physical data fusion architecture;
and performing fusion processing on the preprocessed data according to the determined data fusion architecture.
5. The data management method for the nuclear power plant significant equipment according to claim 1, wherein the step S40 includes:
determining a corresponding service display model according to service requirements, and visually displaying the summarized data by using the determined service display model, wherein the service display model comprises: the system comprises a three-dimensional display model, an individualized cockpit display model, a statistical form display model, an equipment archive display model, an equipment statistical index display model and an equipment health report display model.
6. The data management method for the nuclear power plant significant equipment according to claim 1, wherein the step S10 includes:
determining extraction strategies and extraction frequencies of various data according to business requirements and data characteristics, wherein the extraction strategies comprise: full extraction, incremental extraction, new addition and change extraction;
and extracting corresponding data from the corresponding service system according to the determined extraction strategy and the extraction frequency.
7. The data management method for the nuclear power plant significant equipment according to claim 1, further comprising:
s60, establishing a data warehouse, and storing data in corresponding data layers of the data warehouse in a layered storage mode, wherein the first data layer is used for storing the extracted data; the second data layer is used for storing the preprocessed data; and the third data layer is used for storing the summarized data.
8. A data management system for a nuclear power plant capital equipment, comprising:
the extraction module is used for extracting various types of data from different business systems;
the preprocessing module is used for preprocessing the extracted data, and the preprocessing comprises data cleaning and data format conversion;
the summarizing processing module is used for summarizing the preprocessed data according to the service requirement;
and the display module is used for visually displaying the summarized data according to the service requirements.
9. The data management system for the nuclear power plant capital equipment of claim 8, further comprising a real-time data acquisition module, and,
the real-time data acquisition module is used for acquiring real-time data from the aigret database through a micro service or an interface;
and the summarizing processing module is used for summarizing the real-time data and the preprocessed data according to the service requirements.
10. The data management system for nuclear power plant capital equipment according to claim 8,
the display module is used for determining a corresponding service display model according to service requirements and visually displaying the summarized data by using the determined service display model, wherein the service display model comprises: the system comprises a three-dimensional display model, an individualized cockpit display model, a statistical form display model, an equipment archive display model, an equipment statistical index display model and an equipment health report display model.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110009306.3A CN112765232B (en) | 2021-01-05 | 2021-01-05 | Data management method and system for major equipment of nuclear power plant |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110009306.3A CN112765232B (en) | 2021-01-05 | 2021-01-05 | Data management method and system for major equipment of nuclear power plant |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112765232A true CN112765232A (en) | 2021-05-07 |
| CN112765232B CN112765232B (en) | 2024-03-19 |
Family
ID=75699509
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110009306.3A Active CN112765232B (en) | 2021-01-05 | 2021-01-05 | Data management method and system for major equipment of nuclear power plant |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112765232B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114281877A (en) * | 2021-12-24 | 2022-04-05 | 北京锐安科技有限公司 | Data management system and method |
| CN115034744A (en) * | 2022-05-25 | 2022-09-09 | 岭澳核电有限公司 | Public index collection method and system for system health season report of nuclear power plant |
| CN115098477A (en) * | 2022-06-23 | 2022-09-23 | 中核核电运行管理有限公司 | Data standard management method and device for production data of nuclear power station |
Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130031130A1 (en) * | 2010-12-30 | 2013-01-31 | Charles Wilbur Hahm | System and method for interactive querying and analysis of data |
| CN108447534A (en) * | 2018-05-18 | 2018-08-24 | 灵玖中科软件（北京）有限公司 | A kind of electronic health record data quality management method based on NLP |
| CN109582717A (en) * | 2018-10-16 | 2019-04-05 | 中国电力科学研究院有限公司 | A kind of database unified platform and its read method towards electric power big data |
| CN110489459A (en) * | 2019-08-07 | 2019-11-22 | 国网安徽省电力有限公司 | A kind of enterprise-level industry number fused data analysis system based on big data platform |
| CN111159180A (en) * | 2019-12-18 | 2020-05-15 | 国家电网有限公司大数据中心 | Data processing method and system based on data resource directory construction |
| CN111459923A (en) * | 2020-03-16 | 2020-07-28 | 上海维信荟智金融科技有限公司 | Mobile BI business intelligence solution method and system |
| CN111861241A (en) * | 2020-07-28 | 2020-10-30 | 四川轻化工大学 | Industrial fusion degree index calculation and visualization method |
| CN112102111A (en) * | 2020-09-27 | 2020-12-18 | 华电福新广州能源有限公司 | Intelligent processing system for power plant data |
| CN112116186A (en) * | 2020-03-20 | 2020-12-22 | 中国辐射防护研究院 | Method for selecting terrestrial reference organisms of nuclear power plant |
| US20200412767A1 (en) * | 2015-10-28 | 2020-12-31 | Qomplx, Inc. | Hybrid system for the protection and secure data transportation of convergent operational technology and informational technology networks |
-
2021
- 2021-01-05 CN CN202110009306.3A patent/CN112765232B/en active Active
Patent Citations (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130031130A1 (en) * | 2010-12-30 | 2013-01-31 | Charles Wilbur Hahm | System and method for interactive querying and analysis of data |
| US20200412767A1 (en) * | 2015-10-28 | 2020-12-31 | Qomplx, Inc. | Hybrid system for the protection and secure data transportation of convergent operational technology and informational technology networks |
| CN108447534A (en) * | 2018-05-18 | 2018-08-24 | 灵玖中科软件（北京）有限公司 | A kind of electronic health record data quality management method based on NLP |
| CN109582717A (en) * | 2018-10-16 | 2019-04-05 | 中国电力科学研究院有限公司 | A kind of database unified platform and its read method towards electric power big data |
| CN110489459A (en) * | 2019-08-07 | 2019-11-22 | 国网安徽省电力有限公司 | A kind of enterprise-level industry number fused data analysis system based on big data platform |
| CN111159180A (en) * | 2019-12-18 | 2020-05-15 | 国家电网有限公司大数据中心 | Data processing method and system based on data resource directory construction |
| CN111459923A (en) * | 2020-03-16 | 2020-07-28 | 上海维信荟智金融科技有限公司 | Mobile BI business intelligence solution method and system |
| CN112116186A (en) * | 2020-03-20 | 2020-12-22 | 中国辐射防护研究院 | Method for selecting terrestrial reference organisms of nuclear power plant |
| CN111861241A (en) * | 2020-07-28 | 2020-10-30 | 四川轻化工大学 | Industrial fusion degree index calculation and visualization method |
| CN112102111A (en) * | 2020-09-27 | 2020-12-18 | 华电福新广州能源有限公司 | Intelligent processing system for power plant data |
Non-Patent Citations (1)
| Title |
|---|
| 鲜燕: "中石由四川销售成品油库优化配置研究", 《CNKI优秀硕士学位论文全文库经济与管理科学》, 15 February 2015 (2015-02-15), pages 1 - 82 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114281877A (en) * | 2021-12-24 | 2022-04-05 | 北京锐安科技有限公司 | Data management system and method |
| CN115034744A (en) * | 2022-05-25 | 2022-09-09 | 岭澳核电有限公司 | Public index collection method and system for system health season report of nuclear power plant |
| CN115098477A (en) * | 2022-06-23 | 2022-09-23 | 中核核电运行管理有限公司 | Data standard management method and device for production data of nuclear power station |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112765232B (en) | 2024-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112765232B (en) | Data management method and system for major equipment of nuclear power plant | |
| CN107402976B (en) | Power grid multi-source data fusion method and system based on multi-element heterogeneous model | |
| CN106557991B (en) | Voltage monitoring data platform | |
| CN105574652B (en) | Intelligent power distribution network planning big data management and control system and method | |
| CN105955243B (en) | A kind of aircraft diagnosis and repair method and its device based on fault case | |
| CN106533754A (en) | Fault diagnosis method and expert system for college teaching servers | |
| CN111815132A (en) | Network security management information publishing method and system for power monitoring system | |
| CN103902816A (en) | Electrification detection data processing method based on data mining technology | |
| CN105574593B (en) | Track state static detection and control system and method based on cloud computing and big data | |
| CN111241129B (en) | Industrial production enterprise index data acquisition and calculation system | |
| CN112084385B (en) | Part-process-equipment association relationship topological view generation method based on digital twinning | |
| CN111259073A (en) | Intelligent business system running state studying and judging system based on logs, flow and business access | |
| CN107844962B (en) | Distribution network engineering cost data collection system based on standard data structure | |
| CN109450094A (en) | A kind of substation relay protection method for inspecting and system | |
| CN116771576B (en) | Comprehensive fault diagnosis method for hydroelectric generating set | |
| CN111985716B (en) | Passenger traffic volume prediction system with passenger traffic information visualization function | |
| CN113435703A (en) | Wind turbine generator system fault analysis system based on SCADA data modeling | |
| CN112488502A (en) | Standard water resource management integrated management and control platform | |
| CN108647860A (en) | Power equipment state monitoring based on OpenStack and assessment cloud platform | |
| CN108921307A (en) | Method and system for automatically generating patrol plan work object by power plant station equipment | |
| CN117331794A (en) | Big data-based application software monitoring analysis system and method | |
| CN116340437A (en) | Multi-clustering method for large-scale multi-source heterogeneous data | |
| CN112117756A (en) | Integrated operation and maintenance method and system for scheduling control system | |
| CN108052637B (en) | Real-time image-text monitoring method for power grid time scale measurement data access full life cycle | |
| CN103383649A (en) | Design model of complex virtual instrument system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |