CN111597166A - Power database model construction method, device, computer equipment and storage medium - Google Patents

Abstract

The application relates to a power database model construction method and device, computer equipment and a storage medium. The method comprises the following steps: acquiring a plurality of electric power data acquired by a plurality of electric power service systems and data fields of the plurality of electric power data; converting the data field into a general field of a power grid general model according to a preset field mapping table; the field mapping table stores the corresponding relation between the data field of the power data and the general field of the power grid general model; writing the electric power data into the power grid general model according to the general fields to form a plurality of power grid general service models; performing data splicing on the power data of the plurality of power grid general service models, and establishing an incidence relation of the plurality of power grid general service models; and constructing a power database model based on the incidence relation. By adopting the method, the construction of the power database with unified power information can be realized.

Description

Power database model construction method, device, computer equipment and storage medium

technical field

The present application relates to the technical field of power data processing, and in particular, to a method, apparatus, computer equipment and storage medium for constructing a power database model.

Background technique

With the continuous development of power business applications, the demand for collaborative maintenance and information sharing in various power departments is increasing. In order to better manage power information, power departments usually implement information sharing by building a public grid information database. For example, the production department usually builds a distribution network database for the distribution network equipment to realize the data flow of the distribution network equipment data in other power departments, such as the marketing department.

However, at present, different power departments usually use different storage methods for the storage of power information. For example, the description methods and storage field formats of distribution network equipment are different between the production department and the marketing department. Therefore, it is difficult to build a unified power information system. Electricity database.

SUMMARY OF THE INVENTION

Based on this, it is necessary to provide a method, apparatus, computer equipment and storage medium for constructing a power database model in view of the above technical problems.

A method for constructing a power database model, the method comprising:

acquiring multiple power data collected by multiple power service systems, and data fields of the multiple power data;

The data fields are converted into general fields of the general grid model according to a preset field mapping table; wherein, the field mapping table stores the data fields of the power data and the general fields of the general grid model. Correspondence;

Writing the power data into the general grid model according to the general field to form a plurality of general grid business models;

performing data splicing on the power data of the multiple power grid general business models, and establishing an association relationship of the multiple power grid general business models;

Based on the association relationship, a power database model is constructed.

In one embodiment, the plurality of grid general business models include a first grid general business model and a second grid general business model; the power data of the plurality of grid general business models are data spliced to establish all the grid general business models. The association relationship of the multiple power grid general business models includes: obtaining a splicing field and splicing data under the splicing field; the splicing field is a general field of the power grid general model, used for multiple power grid general services The field for data splicing of the power data of the model; if the first splicing data that matches the second splicing data stored in the second grid general business model is stored in the first power grid general business model, the The first power grid general business model and the second power grid general business model are data spliced, and an association relationship between the first power grid general business model and the second power grid general business model is established.

In one embodiment, the splicing field includes: a power device code corresponding to the power data; the power device code includes a first power device code and a second power device code; the if the first power grid is common The first splicing data that matches the second splicing data stored in the second power grid general business model is stored in the business model, and the first power grid general business model and the second power grid general business model are used for data analysis. splicing, and establishing an association relationship between the first power grid general business model and the second power grid general business model, including: if the first power grid general business model stores data stored in the second power grid general business model The code of the second power equipment is the same as the code of the first power equipment, then the data splicing of the general business model of the first power grid and the general business model of the second power grid is performed, and the general business model of the first power grid and the general business model of the power grid are established. The association relationship of the general business model of the second power grid.

In one embodiment, the splicing field includes: a name of an electric device corresponding to the electric power data; the name of the electric device includes a name of a first electric device and a name of a second electric device; the name of the electric device if the first power grid is common The first splicing data that matches the second splicing data stored in the second power grid general business model is stored in the business model, and the first power grid general business model and the second power grid general business model are used for data analysis. splicing, and establishing an association relationship between the first power grid general business model and the second power grid general business model, including: if the first power grid general business model stores data stored in the second power grid general business model For the first power device name that matches the keyword of the second power device name, the first power grid general business model and the second power grid general business model are data spliced to establish the first power grid general business model. The relationship between the business model and the general business model of the second power grid.

In one of the embodiments, the method further includes: if the general field of the grid general model corresponding to the data field of the power data is not stored in the field mapping table, using the data field of the power data as the grid Common fields of the common model are stored in the field mapping table.

In one of the embodiments, the power service system includes at least one of a power grid dispatching system, a geographic information system, a production system, a marketing system or a metering automation system.

In one embodiment, the power data includes: at least one of main network model data, first geographic information data, second geographic information data, production data, marketing data or power metering data; the acquiring multiple The multiple power data collected by the power service system includes: acquiring the main network model data from the power grid dispatching system according to the dispatching system file transfer protocol; acquiring the first data from the geographic information system by means of data synchronization extraction Geographic information data, and monitoring the electronic handover interface of the geographic information system through the monitoring system to obtain the second geographic information data; obtaining the production data from the production database of the production system through the data replication tool of the headquarters data center data, and obtaining the marketing data from a marketing database of the marketing system; and/or obtaining the electricity metering data from the metering automation system in accordance with a metering system file transfer protocol.

An apparatus for constructing a power database model, the apparatus comprising:

an electric power data acquisition module, configured to acquire a plurality of electric power data collected by a plurality of electric power service systems, and data fields of the plurality of electric power data;

A general field conversion module, configured to convert the data field into a general field of the grid general model according to a preset field mapping table; wherein, the data field storing the power data in the field mapping table is general to the grid The correspondence between the common fields of the model;

a general model writing module, configured to write the power data into the general grid model according to the general field to form a plurality of general grid business models;

a power data splicing module, configured to perform data splicing on the power data of the multiple power grid general business models, and establish an association relationship of the multiple power grid general business models;

The power model building module is used for building a power database model based on the association relationship.

A computer device includes a memory and a processor, the memory stores a computer program, and the processor implements the steps of the above method when the processor executes the computer program.

A computer-readable storage medium on which a computer program is stored, and when the computer program is executed by a processor, implements the steps of the above-mentioned method.

The above power database model construction method, device, computer equipment and storage medium, obtain multiple power data collected by multiple power business systems, and data fields of multiple power data; convert the data fields into power grids according to a preset field mapping table The general field of the general model; wherein, the field mapping table stores the corresponding relationship between the data field of the power data and the general field of the grid general model; the power data is written into the grid general model according to the general field to form multiple grid general services Model; splicing the power data of multiple power grid general business models to establish the association relationship of multiple power grid general business models; based on the association relationship, build a power database model. The present application converts the data fields of the power data collected by multiple power business systems into the common fields of the power grid general model, after forming the power grid general business model, the association relationship of the general business model is established by data splicing, and the power grid is constructed based on the association relationship. Database, so as to realize the construction of a unified power database of power information.

Description of drawings

1 is a schematic flowchart of a method for constructing a power database model in one embodiment;

2 is a schematic flowchart of data splicing of the power data of the multiple power grid general business models to establish the association relationship of the multiple power grid common business models in one embodiment;

3 is a schematic flowchart of a method for constructing a power database model in another embodiment;

4 is a schematic flowchart of a CIM-based grid resource service design method in an application example;

FIG. 5 is a schematic flow chart of accessing data in a power grid dispatching system, a GIS platform, a production database, a marketing database, and a metering automation system in an application example;

6 is a structural block diagram of an apparatus for constructing a power database model in one embodiment;

FIG. 7 is a diagram of the internal structure of a computer device in one embodiment.

Detailed ways

In order to make the purpose, technical solutions and advantages of the present application more clearly understood, the present application will be described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application, but not to limit the present application.

In one embodiment, as shown in FIG. 1 , a method for constructing a power database model is provided. In this embodiment, the method is applied to a power system server as an example. It can be understood that the method can also be applied to a power system. The terminal can also be applied to a system including a terminal and a server, and is realized through interaction between the terminal and the server. In this embodiment, the method includes the following steps:

Step S101, the power system server acquires multiple power data collected by multiple power service systems, and data fields of the multiple power data.

Among them, the power data is the data collected by the power service system, which can be the working voltage of the transformer used by a power service system or the model of the transformer and the purchase cost of the transformer, etc., and the data field of the power data is the above-mentioned power data. Data fields stored in the power business system. For example, if the working voltage of transformer A is a1, the model is a2 and the purchase cost is a3, the working voltage of transformer B is b1, the model is b2 and the purchase cost is b3, then the power service system stores the power Data a1, a2, a3, b1, b2, b3, and the data fields of the stored power data include operating voltage, model, and purchase cost.

Step S102, the power system server converts the data fields into the general fields of the general grid model according to the preset field mapping table; wherein, the field mapping table stores the correspondence between the data fields of the power data and the general fields of the general grid model .

The power grid general model may be an enterprise public information model promulgated by China Southern Power Grid Corporation, which includes standard specifications for core data models such as power grid resources, equipment, customers, and measurements, and stores corresponding common fields. Since the data fields of the power data used by different business systems may be different, the power system server can use the pre-stored field mapping table that stores the correspondence between the data fields of the power data and the general fields of the general model of the power grid. The data fields of different power data in each power business system are converted into common fields of a unified grid general model.

For example: the same manufacturer of a certain transformer, for the power service system A, the data field used may be the manufacturer, while for the power service system B, the data field used may be the transformer manufacturer, and the two power services Although the system records the data of the manufacturer of the transformer, it uses different data fields. At this time, the power system server can convert different data fields into common fields of the general model of the power grid through the field mapping table. The common field can be the transformer manufacturer, and the field mapping table stores the fields of the manufacturer and the transformer manufacturer. Mapping and mapping between transformer manufacturer and transformer manufacturer fields, so as to convert the manufacturer of power business system A and the transformer manufacturer in power business system B into the general field transformer manufacturer of the power grid general model.

Step S103, the power system server writes the power data into the general grid model according to the general field to form a plurality of general grid business models.

Specifically, after the data fields in the power business system are converted into the common fields of the power grid general model, the power system server can write the corresponding power data into the power grid general model according to the common field model, for example, the manufacturer field in the power business system A The stored power data is written under this general field of the transformer manufacturer in the general model of the power grid.

In step S104, the power system server performs data splicing of the power data of the multiple grid general business models, and establishes an association relationship of the multiple grid general business models.

The relationship of the general business model of the power grid refers to the relationship of data between different general business models of the power grid. Specifically, a certain power data can be stored in two different power business systems, for example: the transformer data of a certain transformer It may be partially stored in the power business system A, such as the production system, or partially stored in the power business system B, such as the marketing system, and the number of the transformer has been unified through the data fields of the production system and the marketing system that may exist in step S103. Therefore, the power system server can splicing the relevant data of the transformer data after the unified data field according to the same transformer number, so as to establish the relationship between the production system and the marketing system.

Step S105, the power system server builds a power database model based on the association relationship.

In step S104, after the power system server obtains the association relationships of the plurality of electric power business systems, it can construct a power database model based on the above association relationships. For example, a corresponding production and marketing model can be constructed according to the correspondence between the production system and the marketing system, thereby A production and marketing model including both production system data and marketing system data has been successfully constructed, as the information model of the power database for the unified power information.

In the above method for constructing a power database model, the power system server obtains multiple power data collected by multiple power service systems, and data fields of the multiple power data; and converts the data fields into the general power grid model according to the preset field mapping table. fields; wherein, the corresponding relationship between the data fields of the power data stored in the field mapping table and the general fields of the power grid general model is stored; the power data is written into the power grid general model according to the common fields to form multiple power grid general business models; The power data of each power grid general business model is spliced, and the association relationship of multiple power grid general business models is established; based on the association relationship, a power database model is constructed. The present application converts the data fields of the power data collected by multiple power business systems into the common fields of the general grid model through the power system server, and after forming the general business model of the power grid, establishes the association relationship of the general business model by means of data splicing, and based on the association The power database is constructed by relational relationship, so as to realize the construction of the power database with the unified power information.

In one embodiment, as shown in FIG. 2 , the multiple grid general business models may include a first grid general business model and a second grid general business model, and step S104 may include:

Step S201, the power system server obtains the splicing field and the splicing data under the splicing field; the splicing field is a field in the general fields of the general power grid model, used to perform data splicing on the power data of a plurality of general business models of the power grid;

Wherein, the splicing field is a field used for data splicing of the power data of the multiple grid general business models among the general fields of the power grid general model. Specifically, the splicing field can be selected according to different power business systems through the power system server. For example, for the production system and the marketing system, the splicing field can be selected as a common equipment number, etc. The field for data splicing of the power data of the grid general business model formed by the system.

Step S202, if the first power grid general service model stores the first splicing data that matches the second stitching data stored in the second power grid general service model, the power system server compares the first power grid general service model with the second power grid. The general business model performs data splicing to establish an association relationship between the first power grid general business model and the second power grid general business model.

In step S201, after the power system server obtains the splicing field, firstly, the power data under the splicing field can be extracted from the first power grid general business model transformed from the power service system A from the splicing field, as the first splicing data, and at the same time. The power data under the connection field is extracted from the second power grid general business model transformed by the power service system B as the second splicing data. If the second splicing data matches the first splicing data, then based on the splicing data, the The data stored in the general business model of the first power grid and the data stored in the general business model of the second power grid are spliced to establish an association relationship between the general business model of the first power grid and the general business model of the second power grid.

Further, the splicing field may include: a power device code corresponding to the power data; the power device code includes a first power device code and a second power device code, and step S202 may further include:

If the first power grid general service model stores the same first power equipment code as the second power equipment code stored in the second power grid general service model, the power system server stores the first power grid general service model with the second power grid general service model. The model performs data splicing, and establishes an association relationship between the general business model of the first power grid and the general business model of the second power grid.

The splicing field adopted by the power system server may be the code of the power equipment corresponding to the power data. For the transformer equipment, the form of the transformer code may be used to perform data splicing between multiple general business models of the power grid. Specifically, the power system server may extract the first transformer codes of all transformer equipment stored in the first power grid general business model from the first power grid general business model, and extract the first power grid codes stored in the second power grid general business model from the second power grid general business model. For the second transformer codes of all transformer devices in the second power grid general business model, select the first transformer codes that are the same as the second transformer codes from the first transformer codes, and use them as power data for data splicing. The power data corresponding to the first transformer code in the power grid general business model and the power data corresponding to the second transformer code in the second power grid general business model are selected for data splicing, thereby establishing the first power grid general business model and the second power grid general business. Model.

As for the power data that cannot be represented in the form of digital encoding but can only be represented by text, for example, the splicing field may also include the name of the power device corresponding to the power data, and the name of the power device may also include the name of the first power device and the name of the second power device , then step S202 may further include:

If the first power grid general business model stores the first power equipment name that matches the keyword of the second power equipment name stored in the second power grid general business model, then the first power grid general business model is stored with the second power grid. The general business model performs data splicing to establish an association relationship between the first power grid general business model and the second power grid general business model.

Specifically, the power system server can extract the name of the first power equipment from the general business model of the first power grid, and extract the keywords in the name of the first power equipment, and select the name of the first power equipment by means of fuzzy matching of keywords. The name of the second power equipment that matches the name keyword, and based on the device name, data splicing is performed on the general business model of the first power grid and the general business model of the second power grid, and then the general business model of the first power grid and the general business model of the second power grid are established. connection relation.

In the above embodiment, the power system server implements data splicing of power data stored in different grid general business models based on the general fields of the unified grid general model, thereby establishing an association relationship between multiple grid general business models. By selecting different splicing fields and different splicing methods, a variety of data splicing methods are provided, which further improves the achievability of building a power database model.

In one embodiment, if the general field of the general grid model corresponding to the data field of the power data is not stored in the field mapping table, the power system server stores the data field of the power data as the general field of the general grid model into the field map surface.

Since the field mapping table is a mapping table used for the correspondence between the data fields of the power data and the general fields of the general power grid model, there may be a general lack of the general power grid model corresponding to the data field of a certain power data in the mapping table. field conditions. Therefore, in this case, the power system server can directly use the data field of the missing power data in the mapping table as the common field of the grid general model, and store the field in the field mapping table, and at the same time, the power data of the data field can be stored in the field mapping table. Write under the new general field in the general model of the grid.

In the above embodiment, by writing the data field of the power data not included in the field mapping table into the field mapping table, it is realized that the power data under the data field can also be written into the corresponding power grid general model, and the power data is guaranteed. Integrity, thus ensuring the data integrity of the constructed power database model.

In one embodiment, the power business system includes at least one of a power grid dispatching system, a geographic information system, a production system, a marketing system, or a metering automation system.

Among them, the power grid dispatching system is mainly used to collect the main network information, data monitoring and security analysis of the main network information, etc. The geographic information system, namely the GIS system, is mainly used to collect geographic location information, such as the location of power equipment And so on, while the production system and marketing system store the production information and marketing information of power equipment, such as physical equipment information and customer information, etc., while the metering automation system stores metering information, which is used to record and describe the measurement of customers and electric energy meters. relationship information.

Further, the power data may include: at least one of main network model data, first geographic information data, second geographic information data, production data, marketing data or power metering data; step S101, may further include: a power system server Obtain the main network model data from the power grid dispatching system according to the dispatching system file transfer protocol; obtain the first geographic information data from the geographic information system through data synchronization extraction, and monitor the electronic handover interface of the geographic information system through the monitoring system to obtain the first geographic information data. 2. Geographic information data; obtain production data from the production database of the production system through the data replication tool of the headquarters data center, and obtain marketing data from the marketing database of the marketing system; and/or from the metering automation system in accordance with the metering system file transfer protocol Get power metering data.

The first geographic information data represents the geographic information data acquired from the geographic information system in the first phase, and the second geographic information data represents the geographic information data acquired from the geographic information system in the later period. Specifically, the power system server can obtain various power data from different power business systems in different ways. The main network information and the metering information of the metering automation system are obtained and updated; the first-phase GIS data is read from the GIS platform through data synchronization extraction, and the electronic handover interface is monitored through the monitoring system to obtain the later GIS data synchronously; The data replication tool of the headquarters data center obtains production data from the production database of the production system, and obtains the marketing data from the marketing database of the marketing system.

In the above embodiment, the power system server obtains the power data collected by different power service systems respectively, and on this basis, uses different data acquisition methods to obtain power data synchronously from different power service systems, which is beneficial to improve the real-time performance of the obtained power data. and accuracy, thereby improving the accuracy of the power data stored in the constructed power database.

In one embodiment, as shown in FIG. 3, a method for constructing a power database model is provided. This embodiment is illustrated by applying the method to a power system server. In this embodiment, the method includes the following steps:

Step S301, the power system server acquires multiple power data collected by multiple power service systems, and data fields of multiple power data;

Step S302, the power system server converts the data fields into the general fields of the general grid model according to the preset field mapping table; wherein, the field mapping table stores the correspondence between the data fields of the power data and the general fields of the general grid model ;

Step S303, if the general field of the grid general model corresponding to the data field of the power data is not stored in the field mapping table, the power system server stores the data field of the power data as the general field of the grid general model into the field mapping table;

Step S304, the power system server writes the power data into the general grid model according to the general field to form a plurality of general grid business models;

Step S305, the power system server obtains the splicing field and the splicing data under the splicing field; the splicing field is a field in the general fields of the general power grid model, which is used to perform data splicing on the power data of a plurality of general business models of the power grid; splicing The fields include: the power device code corresponding to the power data and the power device name corresponding to the power data;

Step S306, if the first power grid general business model stores the first power equipment code that is the same as the second power equipment code stored in the second power grid general business model, the power system server compares the first power grid general business model with the second power equipment code. The grid general business model performs data splicing, and establishes an association relationship between the first grid general business model and the second grid general business model;

Step S307, if the first power grid general business model stores a first power equipment name that matches the keyword of the second power equipment name stored in the second power grid general business model, the power system server stores the first power grid general business model. performing data splicing with the general business model of the second power grid to establish an association relationship between the general business model of the first power grid and the general business model of the second power grid;

Step S308, based on the association relationship, the power system server builds a power database model.

In the method for constructing a power database model provided by the above embodiment, the power system server converts the data fields of the power data collected by multiple power business systems into the common fields of the power grid general model, and then forms the power grid general business model by data splicing. The relationship between the business model and the power database are constructed based on the relationship, so as to realize the construction of a power database with unified power information. In addition, by selecting different splicing fields and different splicing methods, a variety of data splicing methods are provided, which further improves the achievability of building a power database model and writes the data fields of power data that are not included in the field mapping table. In the field mapping table, the power data under the data field can also be written into the corresponding power grid general model, which ensures the integrity of the power data and thus the data integrity of the constructed power database model.

In an application example, a CIM-based grid resource service design method is provided, as shown in Figure 4, the application example may include the following steps:

Step s1, access the data in the grid dispatching system, GIS platform, production database, marketing database, and metering automation system, including: obtaining the main network model data from the dispatching system, and obtaining power transmission, medium and low voltage equipment layers and layers from the GIS platform. Attribute data, obtain functional location and physical equipment data from the production database, obtain customer, metering point, energy meter data from the marketing database, and obtain household, meter, and terminal relationship data from the metering automation system.

Specifically, as shown in Figure 5, the scheduling model data in the scheduling system and the metering model data in the metering automation system are obtained and updated by reading the E file through FTP; the GIS data in the GIS platform is first synchronized through the database In the later stage, the electronic handover interface is monitored through SOA to achieve real-time synchronous acquisition; production and marketing data are synchronously acquired through OGG replication in the headquarters data center, and the data are all connected to the power grid resource model database.

Step s2, convert the model data to eliminate differences in data semantics and formats between different data sources, including: converting the main network model data into main network power grid resources, and converting power transmission, medium and low voltage equipment layers and attribute data into power transmission , medium and low voltage grid resources, convert functional location and physical equipment data into grid resources and equipment assets, convert customer, metering point, energy meter data into customer, metering point, energy meter models, and convert household, meter, terminal relationship data Models for collection terminals and measurement points.

Specifically, the CIM file in the dispatching system is converted into a CIM data table of substations and equipment (including transmission lines) through initialization and incremental synchronization procedures, and the measuring points in the CIM are converted into a measuring point table, which is stored in the CIM database; GIS system The distribution lines, transmission lines, internal equipment, low-voltage lines and fire-fall points in the distribution station are pushed to the GIS layer table, and converted to the CIM database through stored procedures; production and marketing data are converted to in the CIM library.

Step s3, matching and splicing scheduling data, GIS data, production data, marketing data, and measurement data. After model conversion, a model that meets the requirements of unified information fusion semantics and format is formed, and the connection to the unified model of the whole network is realized by name and ID.

Specifically, the grid resources corresponding to the main network scheduling and production, the topology splicing between the main network substations and the distribution network feeders, the medium-voltage users of GIS distribution transformers and marketing, the metering information under the fire point and the low-voltage users of marketing are realized respectively. Carry out correlation, open up the topological relationship of scheduling, distribution network, and marketing, and establish the relationship between measurement points of main transformer, line, distribution transformer and metering automation.

In step s4, a unified resource model of the power grid is constructed. Based on IEC61970, 61968 standards, integrate the main network model in the dispatching system, the distribution network model with the GIS platform data as the skeleton, the marketing user and metering point models, and build a full-voltage power grid including power supply, power grid and customer information. Unified model.

Specifically, around the four main lines of grid resources, assets, customers, and measurement, optimize the model design and build a unified topology model, grid resource model, equipment asset model, customer model, metering point model, and measurement point model.

The above-mentioned CIM-based power grid resource service design method designs a unified model of the entire power grid based on model splicing, and each business system can carry out business applications based on this model, which realizes the sharing of unified power grid model data in the entire power grid. The relevant standard system has opened up the data link between each link and each business, realized the horizontal integration and vertical connection of data, and further improved the level of data sharing and utilization and integrated management within the power grid.

It should be understood that although the steps in the flowcharts of FIGS. 1-5 are shown in sequence according to the arrows, these steps are not necessarily executed in the sequence shown by the arrows. Unless explicitly stated herein, the execution of these steps is not strictly limited to the order, and these steps may be performed in other orders. Moreover, at least a part of the steps in FIGS. 1-5 may include multiple steps or multiple stages. These steps or stages are not necessarily executed and completed at the same time, but may be executed at different times. The execution of these steps or stages The order is also not necessarily sequential, but may be performed alternately or alternately with other steps or at least a portion of the steps or phases within the other steps.

In one embodiment, as shown in FIG. 6, an apparatus for constructing a power database model is provided, including: a power data acquisition module 601, a general field conversion module 602, a general model writing module 603, a power data splicing module 604, and a power data splicing module 604. Model building block 605, where:

A power data acquisition module 601, configured to acquire multiple power data collected by multiple power service systems, and data fields of multiple power data;

The general field conversion module 602 is used to convert the data field into the general field of the general model of the power grid according to the preset field mapping table; wherein, the field mapping table stores the data field of the power data and the general field of the general model of the power grid. Correspondence;

The general model writing module 603 is used to write the power data into the general grid model according to the general fields to form a plurality of general grid business models;

The power data splicing module 604 is used for data splicing of the power data of the multiple power grid general business models to establish the association relationship of the multiple power grid general business models;

The power model building module 605 is configured to build a power database model based on the association relationship.

In one embodiment, the multiple power grid general business models include a first power grid general business model and a second power grid general business model; the power data splicing module 604 is further configured to obtain the splicing field and the splicing data under the splicing field; the splicing field In the general field of the power grid general model, it is a field used for data splicing of power data of multiple power grid general business models; if the first power grid general business model stores a second power grid general business model stored For the first splicing data that matches the data, data splicing is performed on the first power grid general business model and the second power grid general business model to establish an association relationship between the first power grid general business model and the second power grid general business model.

In one embodiment, the splicing field includes: a power device code corresponding to the power data; the power device code includes a first power device code and a second power device code; the power data splicing module 604 is further used for the first power grid general business model The first power equipment code that is the same as the second power equipment code stored in the second power grid general business model is stored in the second power grid. The relationship between the general business model and the general business model of the second power grid.

In one embodiment, the splicing field includes: the name of the electric device corresponding to the electric power data; the name of the electric device includes the name of the first electric device and the name of the second electric device; the electric power data splicing module 604 is further used if the first power grid general business model A first power equipment name matching the keyword of the second power equipment name stored in the second power grid general business model is stored in the second power grid general business model, then the first power grid general business model and the second power grid general business model are data spliced to establish a An association relationship between a general business model of a power grid and a general business model of a second power grid.

In one embodiment, the general field conversion module 602 is further configured to use the data field of the power data as the data field of the general power grid model if the general field of the general power grid model corresponding to the data field of the power data is not stored in the field mapping table. Common fields are stored in the field mapping table.

In one embodiment, the power business system includes at least one of a power grid dispatching system, a geographic information system, a production system, a marketing system, or a metering automation system.

In one embodiment, the power data includes: at least one of main network model data, first geographic information data, second geographic information data, production data, marketing data, or power metering data; the power data acquisition module 601 further uses Obtain the main network model data from the power grid dispatching system according to the dispatching system file transfer protocol; obtain the first geographic information data from the geographic information system through data synchronization extraction, and monitor the electronic handover interface of the geographic information system through the monitoring system to obtain The second geographic information data; obtain production data from the production database of the production system through the data replication tool of the headquarters data center, and obtain marketing data from the marketing database of the marketing system; obtain electricity from the metering automation system according to the metering system file transfer protocol metering data.

For the specific limitation of the power database model building apparatus, reference may be made to the above limitations on the power database model building method, which will not be repeated here. Each module in the above-mentioned power database model building apparatus can be implemented in whole or in part by software, hardware and combinations thereof. The above modules can be embedded in or independent of the processor in the computer device in the form of hardware, or stored in the memory in the computer device in the form of software, so that the processor can call and execute the operations corresponding to the above modules.

In one embodiment, a computer device is provided, and the computer device may be a power system server, and its internal structure diagram may be as shown in FIG. 7 . The computer device includes a processor, memory, and a network interface connected by a system bus. Among them, the processor of the computer device is used to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium, an internal memory. The nonvolatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the execution of the operating system and computer programs in the non-volatile storage medium. The computer equipment's database is used to store power data. The network interface of the computer device is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a method for constructing a power database model is implemented.

Those skilled in the art can understand that the structure shown in FIG. 7 is only a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the computer equipment to which the solution of the present application is applied. Include more or fewer components than shown in the figures, or combine certain components, or have a different arrangement of components.

In one embodiment, a computer device is also provided, including a memory and a processor, where a computer program is stored in the memory, and the processor implements the steps in the foregoing method embodiments when the processor executes the computer program.

In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored, and when the computer program is executed by a processor, implements the steps in the foregoing method embodiments.

Those of ordinary skill in the art can understand that all or part of the processes in the methods of the above embodiments can be implemented by instructing relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage In the medium, when the computer program is executed, it may include the processes of the above-mentioned method embodiments. Wherein, any reference to memory, storage, database or other media used in the various embodiments provided in this application may include at least one of non-volatile and volatile memory. The non-volatile memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, and the like. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, the RAM may be in various forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM).

The technical features of the above embodiments can be combined arbitrarily. In order to make the description simple, all possible combinations of the technical features in the above embodiments are not described. However, as long as there is no contradiction in the combination of these technical features It is considered to be the range described in this specification.

The above-mentioned embodiments only represent several embodiments of the present application, and the descriptions thereof are specific and detailed, but should not be construed as a limitation on the scope of the invention patent. It should be pointed out that for those skilled in the art, without departing from the concept of the present application, several modifications and improvements can be made, which all belong to the protection scope of the present application. Therefore, the scope of protection of the patent of the present application shall be subject to the appended claims.

Claims (10)

1. A method for constructing a power database model, wherein the method comprises: acquiring multiple power data collected by multiple power service systems, and data fields of the multiple power data; The data fields are converted into general fields of the general grid model according to a preset field mapping table; wherein, the field mapping table stores the data fields of the power data and the general fields of the general grid model. Correspondence; Writing the power data into the general grid model according to the general field to form a plurality of general grid business models; performing data splicing on the power data of the multiple power grid general business models, and establishing an association relationship of the multiple power grid general business models; Based on the association relationship, a power database model is constructed. 2 . The method according to claim 1 , wherein the plurality of grid general business models comprise a first grid general business model and a second grid general business model; 2 . The data splicing of the power data of the multiple grid general business models to establish the association relationship of the multiple grid general business models includes: Obtaining a splicing field and splicing data under the splicing field; the splicing field is a field in the general field of the power grid general model, used for data splicing of the power data of a plurality of power grid general business models; If the first grid general business model stores first splicing data that matches the second stitching data stored in the second grid general business model, then the first grid general business model and the second grid general business model are stored. The two power grid general business models perform data splicing to establish an association relationship between the first power grid general business model and the second power grid general business model. 3. The method according to claim 2, wherein the splicing field comprises: a power device code corresponding to the power data; the power device code comprises a first power device code and a second power device code; If the first splicing data matching the second splicing data stored in the second grid general business model is stored in the first power grid general business model, then the first power grid general business model is combined with the second grid general business model. performing data splicing on the second power grid general business model, and establishing an association relationship between the first power grid general business model and the second power grid general business model, including: If the first power grid general service model stores the first power equipment code that is the same as the second power equipment code stored in the second power grid general service model, the first power grid general service model is stored in the first power grid general service model. Data splicing is performed between the model and the second power grid general business model, and an association relationship between the first power grid general business model and the second power grid general business model is established. 4. The method according to claim 2, wherein the splicing field comprises: the name of the power device corresponding to the power data; the name of the power device comprises the name of the first power device and the name of the second power device; If the first splicing data matching the second splicing data stored in the second grid general business model is stored in the first power grid general business model, then the first power grid general business model is combined with the second grid general business model. performing data splicing on the second power grid general business model, and establishing an association relationship between the first power grid general business model and the second power grid general business model, including: If the first power grid general business model stores the first power equipment name that matches the keyword of the second power equipment name stored in the second power grid general business model, then the first power equipment name is stored in the first power grid general business model. Data splicing is performed between the grid general business model and the second grid general business model, and an association relationship between the first grid general business model and the second grid general business model is established. 5. The method according to any one of claims 1 to 4, further comprising: If the general field of the general grid model corresponding to the data field of the power data is not stored in the field mapping table, the data field of the electrical power data is stored in the field as the general field of the general grid model mapping table. 6 . The method according to claim 1 , wherein the power business system comprises: at least one of a power grid dispatching system, a geographic information system, a production system, a marketing system or a metering automation system. 7 . 7. The method according to claim 6, wherein the power data comprises: at least one of main network model data, first geographic information data, second geographic information data, production data, marketing data or power metering data A sort of; The obtaining of multiple power data collected by multiple power service systems includes: Acquire the main network model data from the power grid dispatching system according to the dispatching system file transfer protocol; Obtain the first geographic information data from the geographic information system by means of data synchronization extraction, and monitor the electronic handover interface of the geographic information system through a monitoring system to obtain the second geographic information data; Obtain the production data from the production database of the production system through the data replication tool of the headquarters data center, and obtain the marketing data from the marketing database of the marketing system; and / or The power metering data is obtained from the metering automation system according to a metering system file transfer protocol. 8. An apparatus for constructing a power database model, wherein the apparatus comprises: an electric power data acquisition module, configured to acquire a plurality of electric power data collected by a plurality of electric power service systems, and data fields of the plurality of electric power data; A general field conversion module, configured to convert the data field into a general field of the grid general model according to a preset field mapping table; wherein, the data field storing the power data in the field mapping table is general to the grid The correspondence between the common fields of the model; a general model writing module, configured to write the power data into the general grid model according to the general field to form a plurality of general grid business models; a power data splicing module, configured to perform data splicing on the power data of the multiple power grid general business models, and establish an association relationship of the multiple power grid general business models; The power model building module is used for building a power database model based on the association relationship. 9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, wherein the processor implements the steps of the method according to any one of claims 1 to 7 when the processor executes the computer program . 10. A computer-readable storage medium on which a computer program is stored, characterized in that, when the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images