CN113094451A - Graph database-based model construction method, system, device and storage medium - Google Patents
Graph database-based model construction method, system, device and storage medium Download PDFInfo
- Publication number
- CN113094451A CN113094451A CN202110642955.7A CN202110642955A CN113094451A CN 113094451 A CN113094451 A CN 113094451A CN 202110642955 A CN202110642955 A CN 202110642955A CN 113094451 A CN113094451 A CN 113094451A
- Authority
- CN
- China
- Prior art keywords
- equipment
- information
- hydroelectric
- hydroelectric equipment
- business
- 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.)
- Pending
Links
- 238000010276 construction Methods 0.000 title claims abstract description 24
- 230000003068 static effect Effects 0.000 claims abstract description 38
- 238000000034 method Methods 0.000 claims abstract description 34
- 238000004519 manufacturing process Methods 0.000 claims description 48
- 230000010354 integration Effects 0.000 claims description 29
- 238000012423 maintenance Methods 0.000 claims description 27
- 238000004590 computer program Methods 0.000 claims description 19
- 238000013461 design Methods 0.000 claims description 19
- 238000000605 extraction Methods 0.000 claims description 17
- 238000013528 artificial neural network Methods 0.000 claims description 10
- 230000004927 fusion Effects 0.000 claims description 10
- 238000005259 measurement Methods 0.000 claims description 9
- 238000011144 upstream manufacturing Methods 0.000 claims description 9
- 230000001502 supplementing effect Effects 0.000 claims description 8
- 238000005516 engineering process Methods 0.000 abstract description 4
- 239000006185 dispersion Substances 0.000 abstract description 3
- 238000007726 management method Methods 0.000 description 37
- 238000010586 diagram Methods 0.000 description 8
- 230000005856 abnormality Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 238000001914 filtration Methods 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- 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/25—Integrating or interfacing systems involving database management systems
-
- 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)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Public Health (AREA)
- Water Supply & Treatment (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The method takes a graph database as a data structure of a storage carrier, can associate static information, dynamic information, model method information and other information related to equipment together in a network mode, can organize data of all dimensions of the equipment in a uniform view angle, and can finally construct advanced application based on the full life cycle of the equipment. In addition, multi-source heterogeneous data can be organized into an organic whole by taking the equipment as the center through an equipment object construction technology based on a graph data structure, the phenomenon of data dispersion and disorder in the past is changed, a service interface based on business is provided for the outside by taking the equipment as a uniform view angle, and various high-level applications of the equipment are supported.
Description
Technical Field
The present application relates to the field of power management, and in particular, to a graph database-based model building method, system, device, and storage medium.
Background
Graph database technology is a type of NoSQL database, and applies graph theory to store relationship information between entities, thereby providing a technical basis for conveniently and intuitively reflecting the mutual relationship between different data objects. Traditional equipment object construction is based on relational database construction, but is limited to limited expression capability and expansibility of a relational model, and cannot be applied to a complex and variable real world.
In the existing power plant, data generated by power equipment is complex, a plurality of production management data are classified and directly imported into a database, the data need to be screened layer by layer from the access and the check of the database, time is wasted when a plurality of data are obtained, the exported data result is different from the retrieved target data when a plurality of data are obtained, manual filtration is needed, the efficiency of power data management is low due to complex data query, access and check, and how to efficiently query and access the data of the power equipment needs further technical exploration.
Disclosure of Invention
In view of the above, it is necessary to provide a graph database-based model building method, system, device and storage medium for solving the above technical problems.
In a first aspect, an embodiment of the present invention provides a graph database-based model building method, including the following steps:
the method comprises the steps of obtaining production management data of a corresponding business system of the hydroelectric equipment, and classifying static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions;
the static parameters, the dynamic parameters and the maintenance and repair record information are associated together through a network ontology language according to a resource description framework, and a logical model of the hydroelectric equipment is constructed;
importing the logical model of the hydroelectric equipment into a graph database by taking the hydroelectric equipment as a center to complete the construction of the logical model of the hydroelectric equipment in graph data;
and extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information by using an extraction method of a fusion factor graph and a neural network for database log recording.
Further, the production management data of the corresponding business system of the hydroelectric equipment is obtained, and the static parameters, the dynamic parameters and the maintenance and repair record information of the production management data are classified according to different dimensions, and the method comprises the following steps:
performing information integration on the inherent characteristics of the hydroelectric equipment by taking the hydroelectric equipment as a center to obtain a first dimension, wherein the inherent characteristics comprise basic information and the static parameters of the hydroelectric equipment;
performing information integration on the use characteristics of the hydroelectric equipment to obtain a second dimension, wherein the use characteristics comprise standard measurement, standard faults, standard indexes and technical knowledge information;
and integrating information of the relation characteristics of the hydroelectric equipment to obtain a third dimension, wherein the relation characteristics comprise upstream and downstream connection topology and logic hierarchy of the hydroelectric equipment.
Further, the static parameters, the dynamic parameters and the maintenance and repair record information are associated together through a network ontology language according to the resource description framework to construct a logical model of the hydroelectric equipment, and the logical model comprises the following steps:
acquiring a power plant identification system code of a logical structure of the hydraulic power plant from the corresponding service system of the hydroelectric equipment;
combing out core main equipment and auxiliary equipment of the hydropower equipment from the power plant identification system according to the acquired power plant identification system information;
taking specific equipment in the combed power plant identification system as an object, and performing table structure design and integration on parameter information from three aspects of inherent characteristics, use characteristics and relation characteristics of the hydroelectric equipment;
and performing outline design according to the integrated information to construct the logical model of the hydropower equipment.
Further, the acquiring production management data of the corresponding service system of the hydroelectric equipment classifies static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions, and further comprises:
associating the business classification, the business attribute, the business label and the business dimension included in the production management data through the relation between the metadata and the data object of the hydropower equipment;
and supplementing the service specification and the association relation of the data object, and accessing, retrieving and querying the data object from the service layer.
On the other hand, the embodiment of the invention also provides a model construction system based on a graph database, which comprises the following steps:
the dimension classification module is used for acquiring production management data of a corresponding business system of the hydroelectric equipment and classifying static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions;
the information correlation module is used for correlating the static parameters, the dynamic parameters and the maintenance and repair record information together through a network ontology language according to the resource description framework to construct a logical model of the hydroelectric equipment;
the model construction module is used for importing the logical model of the hydroelectric equipment into a graph database by taking the hydroelectric equipment as a center so as to complete construction of the logical model of the hydroelectric equipment in graph data;
and the data acquisition module is used for extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information from the database by using an extraction method of a fusion factor graph and a neural network for log recording.
Further, the dimension classification module includes a characteristic integration unit, and the characteristic integration unit is configured to:
performing information integration on the inherent characteristics of the hydroelectric equipment by taking the hydroelectric equipment as a center to obtain a first dimension, wherein the inherent characteristics comprise basic information and the static parameters of the hydroelectric equipment;
performing information integration on the use characteristics of the hydroelectric equipment to obtain a second dimension, wherein the use characteristics comprise standard measurement, standard faults, standard indexes and technical knowledge information;
and integrating information of the relation characteristics of the hydroelectric equipment to obtain a third dimension, wherein the relation characteristics comprise upstream and downstream connection topology and logic hierarchy of the hydroelectric equipment.
Further, the information association module includes an information extraction unit, and the information extraction unit is configured to:
acquiring a power plant identification system code of a logical structure of the hydraulic power plant from the corresponding service system of the hydroelectric equipment;
combing out core main equipment and auxiliary equipment of the hydropower equipment from the power plant identification system according to the acquired power plant identification system information;
taking specific equipment in the combed power plant identification system as an object, and performing table structure design and integration on parameter information from three aspects of inherent characteristics, use characteristics and relation characteristics of the hydroelectric equipment;
and performing outline design according to the integrated information to construct the logical model of the hydropower equipment.
Further, the dimension classification module further includes a service association unit, and the service association unit is configured to:
associating the business classification, the business attribute, the business label and the business dimension included in the production management data through the relation between the metadata and the data object of the hydropower equipment;
and supplementing the service specification and the association relation of the data object, and accessing, retrieving and querying the data object from the service layer.
The embodiment of the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored in the memory and capable of running on the processor, and when the processor executes the computer program, the following steps are implemented:
the method comprises the steps of obtaining production management data of a corresponding business system of the hydroelectric equipment, and classifying static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions;
the static parameters, the dynamic parameters and the maintenance and repair record information are associated together through a network ontology language according to a resource description framework, and a logical model of the hydroelectric equipment is constructed;
importing the logical model of the hydroelectric equipment into a graph database by taking the hydroelectric equipment as a center to complete the construction of the logical model of the hydroelectric equipment in graph data;
and extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information by using an extraction method of a fusion factor graph and a neural network for database log recording.
An embodiment of the present invention further provides a computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the following steps:
the method comprises the steps of obtaining production management data of a corresponding business system of the hydroelectric equipment, and classifying static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions;
the static parameters, the dynamic parameters and the maintenance and repair record information are associated together through a network ontology language according to a resource description framework, and a logical model of the hydroelectric equipment is constructed;
importing the logical model of the hydroelectric equipment into a graph database by taking the hydroelectric equipment as a center to complete the construction of the logical model of the hydroelectric equipment in graph data;
and extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information by using an extraction method of a fusion factor graph and a neural network for database log recording.
The beneficial effect of this application is: the embodiment of the invention discloses a model construction method, a system, computer equipment and a storage medium based on a graph database, wherein the method takes the graph database as a data structure of a storage carrier, can associate static information, dynamic information, model method information and other information related to equipment together in a network mode, can organize data of each dimension of the equipment in a uniform view angle, and finally can construct advanced application based on the full life cycle of the equipment. In addition, multi-source heterogeneous data can be organized into an organic whole by taking the equipment as the center through an equipment object construction technology based on a graph data structure, the phenomenon of data dispersion and disorder in the past is changed, a service interface based on business is provided for the outside by taking the equipment as a uniform view angle, and various high-level applications of the equipment are supported. And by utilizing the characteristic that the self query of a non-relational database such as a graph database is simple and convenient and fast, a graph data model taking equipment as a center is established, all information data based on the equipment are covered, and data service is rapidly provided.
Drawings
FIG. 1 is a schematic flow chart diagram illustrating a method for graph database-based model construction, as disclosed in one embodiment;
FIG. 2 is a schematic flow chart diagram illustrating classification of information by feature integration as disclosed in one embodiment;
FIG. 3 is a schematic diagram of a data information extraction process in one embodiment;
FIG. 4 is a schematic flow diagram of business association by a hydroelectric facility in one embodiment;
FIG. 5 is a block diagram of a graph database based model building system in one embodiment;
FIG. 6 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In one embodiment, as shown in FIG. 1, there is provided a graph database based model building method comprising the steps of:
102, associating the static parameters, the dynamic parameters and the maintenance and repair record information together through a network ontology language according to a resource description framework to construct a logical model of the hydroelectric equipment;
103, taking the hydroelectric equipment as a center, importing the logical model of the hydroelectric equipment into a graph database, and completing construction of the logical model of the hydroelectric equipment in graph data;
and 104, extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information by using an extraction method of a fusion factor graph and a neural network for database log recording.
Specifically, the embodiment discloses a model construction method based on a graph database, which takes the graph database as a data structure of a storage carrier, can associate static information, dynamic information, model method information and other information related to equipment together in a network manner, can organize data of each dimension of the equipment in a uniform view, and finally can construct advanced applications based on the full life cycle of the equipment. In addition, multi-source heterogeneous data can be organized into an organic whole by taking the equipment as the center through an equipment object construction technology based on a graph data structure, the phenomenon of data dispersion and disorder in the past is changed, a service interface based on business is provided for the outside by taking the equipment as a uniform view angle, and various high-level applications of the equipment are supported.
In one embodiment, as shown in FIG. 2, the process of classifying information by feature integration includes:
202, integrating the use characteristics of the hydroelectric equipment to obtain a second dimension, wherein the use characteristics comprise standard measurement, standard faults, standard indexes and technical knowledge information;
and 203, integrating information of the relation characteristics of the hydroelectric equipment to obtain a third dimension, wherein the relation characteristics comprise upstream and downstream connection topology and logic hierarchy of the hydroelectric equipment.
Specifically, the hydroelectric equipment logic model comprises: the method comprises the steps of hydraulic power plant equipment logic structure design and data object model design, wherein the equipment data object logic model design takes equipment as a center, and all information of the hydraulic power equipment is integrated from the following 3 dimensions. The first dimension is inherent characteristics of hydroelectric equipment, including basic information of the hydroelectric equipment and static parameters of the equipment; the second dimension is the use characteristics of the hydroelectric equipment, and comprises information such as standard measurement, standard faults, standard indexes, technical knowledge and the like; the third dimension is the relation characteristic of the hydroelectric equipment, and comprises the connection topology of the upstream and downstream of the equipment, a logic level and the like.
In one embodiment, as shown in figure 3, the flow of data information extraction for a hydroelectric installation comprises the following steps:
301, acquiring a power plant identification system code of a hydraulic power plant logical structure from a service system corresponding to the hydroelectric equipment;
and 304, designing a schema according to the integrated information, and constructing the logical model of the hydropower equipment.
Specifically, the data information of the hydroelectric equipment includes: the system comprises a production management data system, a power plant identification system information, an operation ticket, a work ticket, a maintenance record and other information, and further comprises various equipment measuring point parameter information and data records of a time sequence database, and the mutual relation among the information is related by taking equipment as a center. The logical structure design of the hydropower station equipment basically follows the information code of the power station identification system of the hydropower station equipment, the power station identification system information has obvious parent-child structural characteristics, and the equipment can be displayed in a parent-child hierarchy mode in a power station-unit-equipment-component-part mode in a manner of naming the power station identification system information.
In one embodiment, as shown in fig. 4, the process of business association by a hydroelectric device comprises:
In the process of carrying out business association through the hydroelectric equipment, the data breadth and range of the hydroelectric equipment are expanded by carrying out business association on various hydroelectric equipment, so that more complete data support can be provided by carrying out subsequent business access, retrieval and query.
It should be understood that, although the steps in the above-described flowcharts are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least a portion of the steps in the above-described flowcharts may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, and the order of performing the sub-steps or the stages is not necessarily sequential, but may be performed alternately or alternatingly with other steps or at least a portion of the sub-steps or stages of other steps.
In one embodiment, as shown in FIG. 5, a graph database based model building system is disclosed, comprising:
the dimension classification module 501 is used for acquiring production management data of a corresponding business system of the hydroelectric equipment, and classifying static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions;
the information correlation module 502 is used for correlating the static parameters, the dynamic parameters and the maintenance and repair record information together through a network ontology language according to a resource description framework to construct a logical model of the hydroelectric equipment;
the model construction module 503 is configured to import the logical model of the hydroelectric equipment into a graph database with the hydroelectric equipment as a center, and complete construction of the logical model of the hydroelectric equipment in graph data;
and the data acquisition module 504 is used for extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information from the database by using an extraction method of a fusion factor graph and a neural network for log recording.
In one embodiment, the dimension classification module 501 includes a characteristic integration unit 5011, the characteristic integration unit 5011 to:
performing information integration on the inherent characteristics of the hydroelectric equipment by taking the hydroelectric equipment as a center to obtain a first dimension, wherein the inherent characteristics comprise basic information and the static parameters of the hydroelectric equipment;
performing information integration on the use characteristics of the hydroelectric equipment to obtain a second dimension, wherein the use characteristics comprise standard measurement, standard faults, standard indexes and technical knowledge information;
and integrating information of the relation characteristics of the hydroelectric equipment to obtain a third dimension, wherein the relation characteristics comprise upstream and downstream connection topology and logic hierarchy of the hydroelectric equipment.
In one embodiment, the information association module 502 comprises an information extraction unit 5021, the information extraction unit 5021 is configured to:
acquiring a power plant identification system code of a logical structure of the hydraulic power plant from the corresponding service system of the hydroelectric equipment;
combing out core main equipment and auxiliary equipment of the hydropower equipment from the power plant identification system according to the acquired power plant identification system information;
taking specific equipment in the combed power plant identification system as an object, and performing table structure design and integration on parameter information from three aspects of inherent characteristics, use characteristics and relation characteristics of the hydroelectric equipment;
and performing outline design according to the integrated information to construct the logical model of the hydropower equipment.
In one embodiment, the dimension classification module 501 further comprises a business association unit 5012, the business association unit 5012 is configured to:
associating the business classification, the business attribute, the business label and the business dimension included in the production management data through the relation between the metadata and the data object of the hydropower equipment;
and supplementing the service specification and the association relation of the data object, and accessing, retrieving and querying the data object from the service layer.
For specific definition of the graph database-based model building system, reference may be made to the definition of the graph database-based model building method above, and details are not repeated here. The various modules of the graph database-based model building system described above may be implemented in whole or in part by software, hardware, and combinations thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
FIG. 6 is a diagram illustrating an internal structure of a computer device in one embodiment. As shown in fig. 6, the computer apparatus includes a processor, a memory, a network interface, an input device, and a display screen connected through a system bus. Wherein the memory includes a non-volatile storage medium and an internal memory. The non-volatile storage medium of the computer device stores an operating system and may also store a computer program that, when executed by the processor, causes the processor to implement the method of privilege anomaly detection. The internal memory may also have a computer program stored therein, which when executed by the processor, causes the processor to perform the method for detecting an abnormality of authority. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the architecture shown in fig. 6 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the following steps when executing the computer program:
the method comprises the steps of obtaining production management data of a corresponding business system of the hydroelectric equipment, and classifying static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions;
the static parameters, the dynamic parameters and the maintenance and repair record information are associated together through a network ontology language according to a resource description framework, and a logical model of the hydroelectric equipment is constructed;
importing the logical model of the hydroelectric equipment into a graph database by taking the hydroelectric equipment as a center to complete the construction of the logical model of the hydroelectric equipment in graph data;
and extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information by using an extraction method of a fusion factor graph and a neural network for database log recording.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
performing information integration on the inherent characteristics of the hydroelectric equipment by taking the hydroelectric equipment as a center to obtain a first dimension, wherein the inherent characteristics comprise basic information and the static parameters of the hydroelectric equipment;
performing information integration on the use characteristics of the hydroelectric equipment to obtain a second dimension, wherein the use characteristics comprise standard measurement, standard faults, standard indexes and technical knowledge information;
and integrating information of the relation characteristics of the hydroelectric equipment to obtain a third dimension, wherein the relation characteristics comprise upstream and downstream connection topology and logic hierarchy of the hydroelectric equipment.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
acquiring a power plant identification system code of a logical structure of the hydraulic power plant from the corresponding service system of the hydroelectric equipment;
combing out core main equipment and auxiliary equipment of the hydropower equipment from the power plant identification system according to the acquired power plant identification system information;
taking specific equipment in the combed power plant identification system as an object, and performing table structure design and integration on parameter information from three aspects of inherent characteristics, use characteristics and relation characteristics of the hydroelectric equipment;
and performing outline design according to the integrated information to construct the logical model of the hydropower equipment.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
associating the business classification, the business attribute, the business label and the business dimension included in the production management data through the relation between the metadata and the data object of the hydropower equipment;
and supplementing the service specification and the association relation of the data object, and accessing, retrieving and querying the data object from the service layer.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of:
the method comprises the steps of obtaining production management data of a corresponding business system of the hydroelectric equipment, and classifying static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions;
the static parameters, the dynamic parameters and the maintenance and repair record information are associated together through a network ontology language according to a resource description framework, and a logical model of the hydroelectric equipment is constructed;
importing the logical model of the hydroelectric equipment into a graph database by taking the hydroelectric equipment as a center to complete the construction of the logical model of the hydroelectric equipment in graph data;
and extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information by using an extraction method of a fusion factor graph and a neural network for database log recording.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
performing information integration on the inherent characteristics of the hydroelectric equipment by taking the hydroelectric equipment as a center to obtain a first dimension, wherein the inherent characteristics comprise basic information and the static parameters of the hydroelectric equipment;
performing information integration on the use characteristics of the hydroelectric equipment to obtain a second dimension, wherein the use characteristics comprise standard measurement, standard faults, standard indexes and technical knowledge information;
and integrating information of the relation characteristics of the hydroelectric equipment to obtain a third dimension, wherein the relation characteristics comprise upstream and downstream connection topology and logic hierarchy of the hydroelectric equipment.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
acquiring a power plant identification system code of a logical structure of the hydraulic power plant from the corresponding service system of the hydroelectric equipment;
combing out core main equipment and auxiliary equipment of the hydropower equipment from the power plant identification system according to the acquired power plant identification system information;
taking specific equipment in the combed power plant identification system as an object, and performing table structure design and integration on parameter information from three aspects of inherent characteristics, use characteristics and relation characteristics of the hydroelectric equipment;
and performing outline design according to the integrated information to construct the logical model of the hydropower equipment.
In one embodiment, the processor, when executing the computer program, further performs the steps of:
associating the business classification, the business attribute, the business label and the business dimension included in the production management data through the relation between the metadata and the data object of the hydropower equipment;
and supplementing the service specification and the association relation of the data object, and accessing, retrieving and querying the data object from the service layer.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method for constructing a model based on a graph database, comprising the steps of:
the method comprises the steps of obtaining production management data of a corresponding business system of the hydroelectric equipment, and classifying static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions;
the static parameters, the dynamic parameters and the maintenance and repair record information are associated together through a network ontology language according to a resource description framework, and a logical model of the hydroelectric equipment is constructed;
importing the logical model of the hydroelectric equipment into a graph database by taking the hydroelectric equipment as a center to complete the construction of the logical model of the hydroelectric equipment in graph data;
and extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information by using an extraction method of a fusion factor graph and a neural network for database log recording.
2. The graph database-based model building method according to claim 1, wherein the obtaining production management data of a corresponding business system of a hydroelectric device, and classifying static parameters, dynamic parameters, and maintenance and repair record information of the production management data according to different dimensions comprises:
performing information integration on the inherent characteristics of the hydroelectric equipment by taking the hydroelectric equipment as a center to obtain a first dimension, wherein the inherent characteristics comprise basic information and the static parameters of the hydroelectric equipment;
performing information integration on the use characteristics of the hydroelectric equipment to obtain a second dimension, wherein the use characteristics comprise standard measurement, standard faults, standard indexes and technical knowledge information;
and integrating information of the relation characteristics of the hydroelectric equipment to obtain a third dimension, wherein the relation characteristics comprise upstream and downstream connection topology and logic hierarchy of the hydroelectric equipment.
3. The graph database-based model building method according to claim 1, wherein the building of the logical model of the hydroelectric equipment by associating the static parameters, the dynamic parameters and the maintenance and repair record information together through a network ontology language according to the resource description framework comprises:
acquiring a power plant identification system code of a logical structure of the hydraulic power plant from the corresponding service system of the hydroelectric equipment;
combing out core main equipment and auxiliary equipment of the hydropower equipment from the power plant identification system according to the acquired power plant identification system information;
taking specific equipment in the combed power plant identification system as an object, and performing table structure design and integration on parameter information from three aspects of inherent characteristics, use characteristics and relation characteristics of the hydroelectric equipment;
and performing outline design according to the integrated information to construct the logical model of the hydropower equipment.
4. The graph database-based model building method according to claim 2, wherein the obtaining of production management data of a business system corresponding to a hydroelectric device, the classifying of static parameters, dynamic parameters, maintenance and repair record information of the production management data according to different dimensions, further comprises:
associating the business classification, the business attribute, the business label and the business dimension included in the production management data through the relation between the metadata and the data object of the hydropower equipment;
and supplementing the service specification and the association relation of the data object, and accessing, retrieving and querying the data object from the service layer.
5. A graph database based model building system, comprising:
the dimension classification module is used for acquiring production management data of a corresponding business system of the hydroelectric equipment and classifying static parameters, dynamic parameters and maintenance and repair record information of the production management data according to different dimensions;
the information correlation module is used for correlating the static parameters, the dynamic parameters and the maintenance and repair record information together through a network ontology language according to the resource description framework to construct a logical model of the hydroelectric equipment;
the model construction module is used for importing the logical model of the hydroelectric equipment into a graph database by taking the hydroelectric equipment as a center so as to complete construction of the logical model of the hydroelectric equipment in graph data;
and the data acquisition module is used for extracting information on the entity level of the hydroelectric equipment, extracting production management information related to the hydroelectric equipment from a relational database, and extracting information from the database by using an extraction method of a fusion factor graph and a neural network for log recording.
6. The graph database-based model building system according to claim 5, wherein said dimension classification module comprises a property integration unit for:
performing information integration on the inherent characteristics of the hydroelectric equipment by taking the hydroelectric equipment as a center to obtain a first dimension, wherein the inherent characteristics comprise basic information and the static parameters of the hydroelectric equipment;
performing information integration on the use characteristics of the hydroelectric equipment to obtain a second dimension, wherein the use characteristics comprise standard measurement, standard faults, standard indexes and technical knowledge information;
and integrating information of the relation characteristics of the hydroelectric equipment to obtain a third dimension, wherein the relation characteristics comprise upstream and downstream connection topology and logic hierarchy of the hydroelectric equipment.
7. A graph database-based model building system according to claim 5, wherein said information correlation module comprises an information extraction unit for:
acquiring a power plant identification system code of a logical structure of the hydraulic power plant from the corresponding service system of the hydroelectric equipment;
combing out core main equipment and auxiliary equipment of the hydropower equipment from the power plant identification system according to the acquired power plant identification system information;
taking specific equipment in the combed power plant identification system as an object, and performing table structure design and integration on parameter information from three aspects of inherent characteristics, use characteristics and relation characteristics of the hydroelectric equipment;
and performing outline design according to the integrated information to construct the logical model of the hydropower equipment.
8. The graph database-based model building system of claim 5, wherein said dimension classification module further comprises a business association unit for:
associating the business classification, the business attribute, the business label and the business dimension included in the production management data through the relation between the metadata and the data object of the hydropower equipment;
and supplementing the service specification and the association relation of the data object, and accessing, retrieving and querying the data object from the service layer.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the steps of the method of any of claims 1 to 4 are implemented when the computer program is executed by the processor.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110642955.7A CN113094451A (en) | 2021-06-09 | 2021-06-09 | Graph database-based model construction method, system, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110642955.7A CN113094451A (en) | 2021-06-09 | 2021-06-09 | Graph database-based model construction method, system, device and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113094451A true CN113094451A (en) | 2021-07-09 |
Family
ID=76666050
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110642955.7A Pending CN113094451A (en) | 2021-06-09 | 2021-06-09 | Graph database-based model construction method, system, device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113094451A (en) |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107194533A (en) * | 2017-04-07 | 2017-09-22 | 中国电力科学研究院 | A kind of power distribution network full information model building method and system |
| CN108197132A (en) * | 2017-10-09 | 2018-06-22 | 国网陕西省电力公司 | A kind of electric power asset portrait construction method and device based on chart database |
| CN108874783A (en) * | 2018-07-12 | 2018-11-23 | 国网福建省电力有限公司 | Power information O&M knowledge model construction method |
| CN111026883A (en) * | 2019-12-11 | 2020-04-17 | 南方电网数字电网研究院有限公司 | Knowledge graph construction method, device, equipment and medium of power business data |
-
2021
- 2021-06-09 CN CN202110642955.7A patent/CN113094451A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107194533A (en) * | 2017-04-07 | 2017-09-22 | 中国电力科学研究院 | A kind of power distribution network full information model building method and system |
| CN108197132A (en) * | 2017-10-09 | 2018-06-22 | 国网陕西省电力公司 | A kind of electric power asset portrait construction method and device based on chart database |
| CN108874783A (en) * | 2018-07-12 | 2018-11-23 | 国网福建省电力有限公司 | Power information O&M knowledge model construction method |
| CN111026883A (en) * | 2019-12-11 | 2020-04-17 | 南方电网数字电网研究院有限公司 | Knowledge graph construction method, device, equipment and medium of power business data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Liu et al. | Big data platform architecture under the background of financial technology: In the insurance industry as an example | |
| Wang et al. | Industrial big data analytics: challenges, methodologies, and applications | |
| Huang et al. | Big-data-driven safety decision-making: a conceptual framework and its influencing factors | |
| Huang et al. | [Retracted] Knowledge Graph Construction and Application of Power Grid Equipment | |
| CN107256247A (en) | Big data data administering method and device | |
| CN105139281A (en) | Method and system for processing big data of electric power marketing | |
| CN112434024B (en) | Relational database-oriented data dictionary generation method, device, equipment and medium | |
| CN112181960B (en) | Intelligent operation and maintenance framework system based on AIOps | |
| CN101093512A (en) | Data filtering method and data filtering system | |
| CN111680855A (en) | Automatic risk detection and early warning method and system for whole process of project | |
| CN104281891A (en) | Time-series data mining method and system | |
| Ren et al. | Multifactor correlation analysis and modeling for product low-carbon design | |
| CN103838937A (en) | Energy consumption simulation modeling system | |
| CN105653830A (en) | Data analysis method based on model driving | |
| Wu et al. | An auxiliary decision-making system for electric power intelligent customer service based on Hadoop | |
| Wang et al. | Data Factory: An Efficient Data Analysis Solution in the Era of Big Data | |
| CN113722564A (en) | Visualization method and device for energy and material supply chain based on space map convolution | |
| Tayeb et al. | Time series database preprocessing for data mining using Python | |
| CN113254517A (en) | Service providing method based on internet big data | |
| Wang et al. | A Web-based CBR knowledge management system for PC troubleshooting | |
| Stefani et al. | Constituent elements for prescriptive analytics systems | |
| CN113094451A (en) | Graph database-based model construction method, system, device and storage medium | |
| Yindong et al. | Advances and future challenges in electric power big data | |
| TWI785724B (en) | Method for creating data warehouse, electronic device, and storage medium | |
| CN113886465A (en) | Big data analysis platform for automobile logistics |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20210709 |