CN111597166A - Power database model construction method and device, computer equipment and storage medium - Google Patents
Power database model construction method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111597166A CN111597166A CN202010410723.4A CN202010410723A CN111597166A CN 111597166 A CN111597166 A CN 111597166A CN 202010410723 A CN202010410723 A CN 202010410723A CN 111597166 A CN111597166 A CN 111597166A
- Authority
- CN
- China
- Prior art keywords
- power
- data
- power grid
- model
- general
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000003860 storage Methods 0.000 title claims abstract description 19
- 238000010276 construction Methods 0.000 title abstract description 6
- 238000000034 method Methods 0.000 claims abstract description 54
- 238000013507 mapping Methods 0.000 claims abstract description 44
- 238000004519 manufacturing process Methods 0.000 claims description 43
- 238000004590 computer program Methods 0.000 claims description 13
- 238000012544 monitoring process Methods 0.000 claims description 11
- 230000005540 biological transmission Effects 0.000 claims description 8
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 230000001360 synchronised effect Effects 0.000 claims description 6
- 238000012546 transfer Methods 0.000 claims description 6
- 238000000605 extraction Methods 0.000 claims description 5
- 230000010076 replication Effects 0.000 claims description 5
- 238000009826 distribution Methods 0.000 description 11
- 238000013461 design Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000004891 communication Methods 0.000 description 2
- 238000005259 measurement Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000004927 fusion Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000003068 static effect 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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- 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
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y04—INFORMATION OR COMMUNICATION TECHNOLOGIES HAVING AN IMPACT ON OTHER TECHNOLOGY AREAS
- Y04S—SYSTEMS INTEGRATING TECHNOLOGIES RELATED TO POWER NETWORK OPERATION, COMMUNICATION OR INFORMATION TECHNOLOGIES FOR IMPROVING THE ELECTRICAL POWER GENERATION, TRANSMISSION, DISTRIBUTION, MANAGEMENT OR USAGE, i.e. SMART GRIDS
- Y04S10/00—Systems supporting electrical power generation, transmission or distribution
- Y04S10/50—Systems or methods supporting the power network operation or management, involving a certain degree of interaction with the load-side end user applications
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Public Health (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (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)
- Supply And Distribution Of Alternating Current (AREA)
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
Technical Field
The application relates to the technical field of power data processing, in particular to a method and a device for building a power database model, computer equipment and a storage medium.
Background
With the continuous development of power business applications, the requirements of cooperative maintenance and information sharing of each power department are increasingly enhanced, and in order to better manage power information, the power departments usually implement information sharing by constructing a power grid public information database. For example, a production department typically constructs a distribution network database for distribution network devices to realize data circulation of distribution network device data in other power departments, such as a marketing department.
However, different storage manners are generally adopted for storing the power information by different power departments at present, for example, the description manner and the storage field format of the distribution network device by the production department and the marketing department are different, and therefore, it is difficult to construct a power database with unified power information.
Disclosure of Invention
In view of the above, it is necessary to provide a power database model building method, device, computer device and storage medium for solving the above technical problems.
A method of building a model for a power database, the method comprising:
the method comprises the steps of obtaining 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;
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.
In one embodiment, the plurality of power grid generic service models comprises a first power grid generic service model and a second power grid generic service model; the data splicing is carried out on the electric power data of the plurality of power grid general service models, and the incidence relation of the plurality of power grid general service models is established, and the method comprises the following steps: acquiring a splicing field and splicing data under the splicing field; the splicing field is a field which is used for splicing the power data of the power grid general service models in the general field of the power grid general model; and if the first power grid universal service model stores first splicing data matched with second splicing data stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing an incidence relation between the first power grid universal service model and the second power grid universal service model.
In one embodiment, the concatenation field comprises: the power equipment codes corresponding to the power data; the power device code comprises a first power device code and a second power device code; if the first power grid universal service model stores first splicing data matched with second splicing data stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing an incidence relation between the first power grid universal service model and the second power grid universal service model, including: and if the first power equipment code which is the same as the second power equipment code stored in the second power grid general service model is stored in the first power grid general service model, performing data splicing on the first power grid general service model and the second power grid general service model, and establishing the incidence relation between the first power grid general service model and the second power grid general service model.
In one embodiment, the concatenation field comprises: the electric power equipment name corresponding to the electric power data; the power equipment names comprise a first power equipment name and a second power equipment name; if the first power grid universal service model stores first splicing data matched with second splicing data stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing an incidence relation between the first power grid universal service model and the second power grid universal service model, including: and if the first power grid universal service model stores the first power equipment name matched with the keyword of the second power equipment name stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing the incidence relation between the first power grid universal service model and the second power grid universal service model.
In one embodiment, the method further comprises the following steps: and if the field mapping table does not store the general field of the power grid general model corresponding to the data field of the power data, storing the data field of the power data into the field mapping table as the general field of the power grid general model.
In one embodiment, the power service system comprises: at least one of a grid scheduling 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 a main network model data, a first geographic information data, a second geographic information data, a production data, a marketing data or an electric power metering data; the acquiring of the plurality of power data collected by the plurality of power service systems includes: acquiring the master network model data from the power grid dispatching system according to a dispatching system file transmission protocol; acquiring the first geographic information data from the geographic information system in a data synchronous extraction mode, and acquiring the second geographic information data by monitoring an electronic handover interface of the geographic information system through a monitoring system; obtaining the production data from a production database of the production system and obtaining the marketing data from a marketing database of the marketing system through a data replication tool of a headquarters data center; and/or acquiring the electric power metering data from the metering automation system according to a metering system file transfer protocol.
A power database model building device, the device comprising:
the power data acquisition module is used for acquiring a plurality of power data acquired by a plurality of power service systems and data fields of the plurality of power data;
the universal field conversion module is used for converting the data field into a universal field of the power grid universal 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;
the universal model writing module is used for writing the electric power data into the power grid universal model according to the universal fields to form a plurality of power grid universal service models;
the power data splicing module is used for performing data splicing on the power data of the power grid general service models and establishing the incidence relation of the power grid general service models;
and the electric power model building module is used for building an electric power database model based on the incidence relation.
A computer device comprising a memory storing a computer program and a processor implementing the steps of the above method when executing the computer program.
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 above-mentioned method.
The power database model building method, the power database model building device, the computer equipment and the storage medium acquire a plurality of power data acquired by a plurality of power service systems and data fields of the plurality of 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. According to the method and the device, the data fields of the electric power data collected by the plurality of electric power service systems are converted into the general fields of the power grid general model, the incidence relation of the general service model is established in a data splicing mode after the power grid general service model is formed, and the electric power database is established based on the incidence relation, so that the establishment of the electric power database with unified electric power information is realized.
Drawings
FIG. 1 is a schematic flow chart illustrating a method for building a model of a power database according to an embodiment;
fig. 2 is a schematic flow chart illustrating a process of performing data splicing on the power data of the plurality of power grid general service models to establish an association relationship between the plurality of power grid general service models in one embodiment;
FIG. 3 is a schematic flow chart of a method for constructing a model of a power database in another embodiment;
FIG. 4 is a flow chart illustrating a CIM-based power grid resource service design method in an application example;
FIG. 5 is a schematic diagram of a process for 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;
FIG. 6 is a block diagram that illustrates the structure of a power database model building device in one embodiment;
FIG. 7 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
In an embodiment, as shown in fig. 1, a power database model building method is provided, which is exemplified by applying the method to a power system server, and it is understood that the method may also be applied to a power system terminal, and may also be applied to a system including a terminal and a server, and is implemented by interaction between the terminal and the server. In this embodiment, the method includes the steps of:
step S101, a power system server acquires a plurality of power data collected by a plurality of power service systems and data fields of the plurality of power data.
The power data is data collected by the power service system, and may be a working voltage or a model of a transformer used by a certain power service system, an acquisition cost of the transformer, and the like, and the data field of the power data is a data field of the power data stored in the power service system. For example: the power service system stores the operating voltage of the transformer a as a1, the model as a2 and the purchase cost as a3, the operating voltage of the transformer B as B1, the model as B2 and the purchase cost as B3, and then stores the power data as a1, a2, a3, B1, B2 and B3, and the data field of the stored power data includes the operating voltage, the model and the purchase cost.
Step S102, the power system server converts 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.
The power grid general model can be an enterprise public information model issued by southern power grid companies, comprises core data model standard specifications such as power grid resources, equipment, customers and measurement, and stores corresponding general fields. Because the data fields of the power data adopted by different service systems may be different, the power system server may convert the data fields of different power data in the plurality of power service systems into the unified general field of the power grid general model through a pre-stored field mapping table storing the correspondence between the data fields of the power data and the general field of the power grid general model.
For example: similarly, for a certain transformer manufacturer, the data field used by the power service system a may be the manufacturer, and for the power service system B, the data field used may be the transformer manufacturer, and the two power service systems adopt different data fields although both record the data of the transformer manufacturer. At this time, the power system server may convert the different data fields into a general field of the power grid general model through a field mapping table, where the general field may be a transformer manufacturer, and then the field mapping table stores a mapping between a manufacturer and a transformer manufacturer field and a mapping between a transformer manufacturer and a transformer manufacturer field, so as to convert both a manufacturer of the power service system a and a transformer manufacturer in the power service system B into the general field transformer manufacturer of the power grid general model.
And step S103, writing the power data into the power grid general model by the power system server according to the general fields to form a plurality of power grid general service models.
Specifically, after the data field in the power service system is converted into the general field of the power grid general model, the power system server may write the corresponding power data into the power grid general model according to the general field model, for example, write the power data stored in the field of the manufacturer in the power service system a into the general field of the transformer manufacturer in the power grid general model.
And step S104, the power system server performs data splicing on the power data of the plurality of power grid general service models, and establishes the incidence relation of the plurality of power grid general service models.
The incidence relation of the power grid general service models refers to the incidence relation of data between different power grid general service models, and specifically, certain power data may be stored in two different power service systems, for example: the transformer data of a certain transformer may be partially stored in the power service system a, such as a production system, or partially stored in the power service system B, such as a marketing system, and the number of the transformer has been normalized by the data fields of the production system and the marketing system in step S103, so that the power system server may splice the transformer data after the normalized data fields according to the same transformer number, thereby establishing the association relationship between the production system and the marketing system.
Step S105, the power system server builds a power database model based on the incidence relation.
After the power system server obtains the association relations of the plurality of power service systems in step S104, the power database model may be constructed based on the association relations, for example, a corresponding production marketing model may be constructed according to the correspondence relations between the production systems and the marketing systems, so that the production marketing model including both the production system data and the marketing system data is successfully constructed as the information model of the power database with unified power information.
In the method for constructing the power database model, a power system server acquires a plurality of power data acquired by a plurality of power service systems and data fields of the plurality of 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. According to the method and the system, the data fields of the electric power data collected by the electric power service systems are converted into the general fields of the electric power grid general model through the electric power system server, the incidence relation of the general service model is established through a data splicing mode after the electric power grid general service model is formed, and the electric power database is established based on the incidence relation, so that the establishment of the electric power database with unified electric power information is realized.
In one embodiment, as shown in fig. 2, the plurality of power grid generic service models may include a first power grid generic service model and a second power grid generic service model, and step S104 may include:
step S201, the power system server obtains a splicing field and splicing data under the splicing field; the splicing field is a field which is used for carrying out data splicing on the electric power data of the plurality of power grid general service models in the general field of the power grid general model;
the splicing field is a field which is used for performing data splicing on the electric power data of the plurality of power grid general service models in the general field of the power grid general model. Specifically, the concatenation field may be selected by the power system server according to different power service systems, for example: for the production system and the marketing system, the splicing field can be selected as a common equipment number and the like, and is used as a field for performing data splicing on the power data of the power grid general service model formed by the production system and the marketing system.
Step S202, if the first power grid general service model stores first splicing data matched with second splicing data stored in the second power grid general service model, the power system server performs data splicing on the first power grid general service model and the second power grid general service model, and establishes an incidence relation between the first power grid general service model and the second power grid general service model.
After the power system server obtains the splicing field in step S201, first, power data under the splicing field may be extracted from the splicing field from the first power grid general service model obtained by converting the power service system a, respectively, to be used as first splicing data, and simultaneously, power data under the splicing field may be extracted from the second power grid general service model obtained by converting the power service system B, to be used as second splicing data, and if there is a match between the second splicing data and the first splicing data, data splicing is performed on data stored in the first power grid general service model and the second power grid general service model based on the splicing data, so as to establish an association relationship between the first power grid general service model and the second power grid general service model.
Further, the concatenation field may include: the power equipment codes 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:
and if the first power equipment code which is the same as the second power equipment code stored in the second power grid general service model is stored in the first power grid general service model, the power system server performs data splicing on the first power grid general service model and the second power grid general service model, and establishes the incidence relation between the first power grid general service model and the second power grid general service model.
The splicing field adopted by the power system server can be a power equipment code corresponding to power data, and for transformer equipment, data splicing among a plurality of power grid general service models can be carried out in a transformer code mode. Specifically, the power system server may extract, from the first power grid general service model, first transformer codes of all transformer devices stored in the first power grid general service model, extract, from the second power grid general service model, second transformer codes of all transformer devices stored in the second power grid general service model, select, from the first transformer codes, first transformer codes identical to the second transformer codes, as power data for data splicing, and select, from the first power grid general service model, power data corresponding to the first transformer codes and power data corresponding to the second transformer codes in the second power grid general service model, and perform data splicing, thereby establishing the first power grid general service model and the second power grid general service model.
For the power data that cannot be represented in a digitally encoded form only by words, for example, the concatenation field may further include a power device name corresponding to the power data, and the power device name may further include a first power device name and a second power device name, then step S202 may further include:
and if the first power grid universal service model stores the first power equipment name matched with the keyword of the second power equipment name stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing the incidence relation between the first power grid universal service model and the second power grid universal service model.
Specifically, the power system server may extract a first power equipment name from the first power grid general service model, extract keywords in the first power equipment name, select a second power equipment name matched with the keywords of the first power equipment name in a keyword fuzzy matching manner, perform data splicing on the first power grid general service model and the second power grid general service model based on the equipment name, and further establish an association relationship between the first power grid general service model and the second power grid general service model.
In the embodiment, the power system server realizes data splicing of the power data stored in different power grid general service models based on the general fields of the unified power grid general model, and further establishes the incidence relation of the multiple power grid general service models.
In one embodiment, if the field mapping table does not store the general field of the power grid general model corresponding to the data field of the power data, the power system server stores the data field of the power data into the field mapping table as the general field of the power grid general model.
Since the field mapping table is a mapping table for correspondence between data fields of power data and general fields of the power grid general model, there may be a case where a general field of the power grid general model corresponding to a data field of certain power data is missing in the mapping table. Therefore, in this case, the power system server may directly use the data field of the power data lacking in the mapping table as the general field of the power grid general model, store the field in the field mapping table, and write the power data of the data field into the newly added general field in the power grid general model.
In the embodiment, the data field of the power data which is not contained in the field mapping table is written into the field mapping table, so that the power data in the data field can be written into the corresponding power grid universal model, the integrity of the power data is ensured, and the data integrity of the constructed power database model is ensured.
In one embodiment, a power service system includes: at least one of a grid scheduling system, a geographic information system, a production system, a marketing system, or a metering automation system.
The power grid dispatching system is mainly used for acquiring main grid information, monitoring data of the main grid information, analyzing safety and the like, the geographic information system is a GIS system and is mainly used for acquiring geographic position information such as the position of power equipment and the like, the production system and the marketing system respectively store production information and marketing information of the power equipment such as physical equipment information and customer information, and the metering automation system stores metering information used for recording and describing metering relation information of customers and the electric energy meter.
Further, the power data may include: at least one of a main network model data, a first geographic information data, a second geographic information data, a production data, a marketing data or an electric power metering data; step S101, may further include: the power system server acquires main network model data from a power grid dispatching system according to a dispatching system file transmission protocol; acquiring first geographic information data from a geographic information system in a data synchronous extraction mode, and acquiring second geographic information data by monitoring an electronic handover interface of the geographic information system through a monitoring system; acquiring production data from a production database of a production system through a data replication tool of a headquarter data center, and acquiring marketing data from a marketing database of a marketing system; and/or acquiring power metering data from the metering automation system according to a metering system file transfer protocol.
The first geographic information data represents geographic information data acquired from a geographic information system at the first stage, and the second geographic information data represents geographic information data acquired from a geographic information system at the middle and later stages. Specifically, the power system server may obtain a plurality of power data from different power service systems in different manners, for example, the main network information of the power grid scheduling system and the metering information of the metering automation system may be obtained and updated in a manner of reading an E file in a File Transfer Protocol (FTP) manner; reading first-stage GIS data from a GIS platform in a data synchronous extraction mode, monitoring an electronic handover interface through a monitoring system, and synchronously acquiring later-stage GIS data; production data can also be obtained from a production database of the production system and marketing data can also be obtained from a marketing database of the marketing system through a data replication tool of the headquarters data center.
In the above embodiment, the power system server respectively acquires the power data acquired by different power service systems, and synchronously acquires the power data from the different power service systems by using different data acquisition manners on the basis, which is beneficial to improving the real-time performance and accuracy of the acquired power data, and further can improve the accuracy of the power data stored in the constructed power database.
In an embodiment, as shown in fig. 3, a method for building a power database model is provided, where this embodiment is exemplified by applying this method to a power system server, and in this embodiment, this method includes the following steps:
step S301, a power system server acquires a plurality of power data acquired by a plurality of power service systems and data fields of the plurality of power data;
step S302, the power system server converts 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;
step S303, if the field mapping table does not store the general field of the power grid general model corresponding to the data field of the power data, the power system server stores the data field of the power data into the field mapping table as the general field of the power grid general model;
step S304, the power system server writes the power data into a power grid universal model according to the universal fields to form a plurality of power grid universal business models;
step S305, the power system server acquires a splicing field and splicing data under the splicing field; the splicing field is a field which is used for performing data splicing on the electric power data of the plurality of electric network general service models in the general field of the electric network general model; the concatenation field includes: the power equipment codes corresponding to the power data and the power equipment names corresponding to the power data;
step S306, if a first power equipment code which is the same as a second power equipment code stored in a second power grid general service model is stored in the first power grid general service model, the power system server performs data splicing on the first power grid general service model and the second power grid general service model, and establishes an incidence relation between the first power grid general service model and the second power grid general service model;
step S307, if the first power grid universal service model stores a first power equipment name matched with the keyword of the second power equipment name stored in the second power grid universal service model, the power system server performs data splicing on the first power grid universal service model and the second power grid universal service model, and establishes an incidence relation between the first power grid universal service model and the second power grid universal service model;
step S308, based on the incidence relation, the power system server constructs a power database model.
In the method for constructing the power database model provided in the above embodiment, the power system server converts the data fields of the power data acquired by the plurality of power service systems into the general fields of the power grid general model, establishes the association relationship of the general service model in a data splicing manner after forming the power grid general service model, and constructs the power database based on the association relationship, thereby implementing the construction of the power database with unified power information. In addition, various data splicing modes are provided by selecting different splicing fields and different splicing modes, the realizability of building the power database model is further improved, and the power data under the data fields can be written into the corresponding power grid universal model by writing the data fields of the power data which are not contained in the field mapping table into the field mapping table, so that the integrity of the power data is ensured, and the data integrity of the built power database model is ensured.
In an application example, a CIM-based power grid resource service design method is provided, and as shown in fig. 4, the application example may include the following steps:
step s1, accessing data in the power grid dispatching system, the GIS platform, the production database, the marketing database and the metering automation system, including: the method comprises the steps of obtaining main network model data from a scheduling system, obtaining layers and attribute data of power transmission equipment, medium and low voltage equipment from a GIS platform, obtaining functional position and physical equipment data from a production database, obtaining data of customers, metering points and electric energy meters from a marketing database, and obtaining relation data of households, meters and terminals from a metering automation system.
Specifically, as shown in fig. 5, the scheduling model data in the scheduling system and the metering model data in the metering automation system are updated by reading the E file through the FTP; the method comprises the steps that GIS data in a GIS platform are synchronously acquired through a database at the first stage, and an electronic handover interface is monitored through an SOA at the later stage, so that real-time synchronous acquisition is realized; production and marketing data are synchronously acquired through OGG copying of a headquarter data center, and the data are all accessed into a power grid resource model database.
Step s2, converting the model data to eliminate the difference of data semantics and format between different data sources, including: the method comprises the steps of converting main network model data into main network power grid resources, converting power transmission and medium and low voltage equipment layers and attribute data into power transmission and medium and low voltage power grid resources, converting functional position and physical equipment data into power grid resources and equipment assets, converting client, metering points and electric energy meter data into client, metering points and electric energy meter models, and converting household, meter and terminal relation data into acquisition terminals and metering point models.
Specifically, CIM files in a scheduling system are converted into CIM data tables of transformer substations and equipment (including power transmission lines) through initialization and increment synchronization programs, measuring points in the CIM are converted into measuring point tables, and the measuring point tables are stored in a CIM library; distribution lines, transmission lines, distribution station room internal equipment, low-voltage lines and fire points in the GIS system are pushed into a GIS graph layer table and are converted into a CIM library through a storage process; and the production and marketing data are converted into a CIM library through a storage process.
And step s3, matching and splicing the scheduling data, the GIS data, the production data, the marketing data and the metering data. And after model conversion, a model meeting the requirements of unified information fusion semantics and format is formed, and the hanging connection on the whole network unified model is realized by using the name and the ID.
Specifically, the correspondence of power grid resources of main network scheduling and production, topological splicing between a main network transformer substation and a distribution network feeder line, medium-voltage users of GIS distribution transformer and marketing, correlation between meter information under a fire point and low-voltage users of marketing, communication of topological relations of scheduling, distribution network and marketing, and establishment of measuring point relations of main transformer, line, distribution transformer and metering automation are realized respectively.
And step s4, constructing a power grid uniform resource model. And integrating a main network model in the dispatching system, a distribution network model taking the GIS platform data as a framework, marketing users and a metering point model based on the IEC61970,61968 standard, and constructing a full-voltage-level power grid unified model containing power supply, power grid and customer information.
Specifically, model design is optimized around four main lines of power grid resources, assets, customers, measurement and the like, and a unified topology model, a power grid resource model, an equipment asset model, a customer model, a metering point model and a measuring point model are constructed.
According to the power grid resource service design method based on CIM, a full power grid standardized unified model based on model splicing is designed, all business systems can develop business application based on the model, sharing of unified power grid model data in a full power grid range is achieved, relevant standard systems are perfected, data links among all links and all businesses are opened, data transverse integration and longitudinal communication are achieved, and the sharing utilization level and the integrated management level of data inside a power grid are further improved.
It should be understood that although the various steps in the flow charts of fig. 1-5 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 some of the steps in fig. 1-5 may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed in turn or alternately with other steps or at least some of the other steps.
In one embodiment, as shown in fig. 6, there is provided a power database model building device including: the system comprises 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 model construction module 605, wherein:
the electric power data acquisition module 601 is configured to acquire a plurality of electric power data acquired by a plurality of electric power service systems and a plurality of data fields of the electric power data;
a general field conversion module 602, configured to convert the data field into a general field of the 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;
a general model writing module 603, configured to write the power data into the power grid general model according to the general field, so as to form a plurality of power grid general service models;
the power data splicing module 604 is configured to perform data splicing on the power data of the multiple power grid general service models, and establish an association relationship between the multiple power grid general service models;
and an electric power model building module 605, configured to build an electric power database model based on the association relationship.
In one embodiment, the plurality of grid generic service models includes a first grid generic service model and a second grid generic service model; the power data splicing module 604 is further configured to obtain a splicing field and splicing data in the splicing field; the splicing field is a field which is used for carrying out data splicing on the electric power data of the plurality of power grid general service models in the general field of the power grid general model; and if the first power grid universal service model stores first splicing data matched with second splicing data stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing an incidence relation between the first power grid universal service model and the second power grid universal service model.
In one embodiment, the concatenation field includes: the power equipment codes corresponding to the power data; the power device codes comprise a first power device code and a second power device code; the power data splicing module 604 is further configured to, if a first power device code that is the same as a second power device code stored in the second power grid general service model is stored in the first power grid general service model, perform data splicing on the first power grid general service model and the second power grid general service model, and establish an association relationship between the first power grid general service model and the second power grid general service model.
In one embodiment, the concatenation field includes: the power equipment name corresponding to the power data; the power equipment names comprise a first power equipment name and a second power equipment name; the power data splicing module 604 is further configured to, if the first power grid general service model stores a first power equipment name that matches a keyword of a second power equipment name stored in the second power grid general service model, perform data splicing on the first power grid general service model and the second power grid general service model, and establish an association relationship between the first power grid general service model and the second power grid general service model.
In an embodiment, the general field conversion module 602 is further configured to, if the field mapping table does not store the general field of the general power grid model corresponding to the data field of the power data, store the data field of the power data into the field mapping table as the general field of the general power grid model.
In one embodiment, a power service system includes: at least one of a grid scheduling 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 a main network model data, a first geographic information data, a second geographic information data, a production data, a marketing data or an electric power metering data; the electric power data acquisition module 601 is further configured to acquire master network model data from a power grid scheduling system according to a scheduling system file transfer protocol; acquiring first geographic information data from a geographic information system in a data synchronous extraction mode, and acquiring second geographic information data by monitoring an electronic handover interface of the geographic information system through a monitoring system; acquiring production data from a production database of a production system through a data replication tool of a headquarter data center, and acquiring marketing data from a marketing database of a marketing system; and acquiring electric power metering data from the metering automation system according to a metering system file transfer protocol.
For specific limitations of the power database model building device, reference may be made to the above limitations of the power database model building method, which are not described herein again. Each module in the above power database model building device may be implemented in whole or in part by software, hardware, and a combination 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.
In one embodiment, a computer device is provided, which may be a power system server, the internal structure of which may be as shown in fig. 7. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used to store power data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a power database model building method.
Those skilled in the art will appreciate that the architecture shown in fig. 7 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 further provided, which includes a memory and a processor, the memory stores a computer program, and the processor implements the steps of the above method embodiments when executing the computer program.
In an embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.
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. Any reference to memory, storage, database or other medium used in the embodiments provided herein can include at least one of non-volatile and volatile memory. Non-volatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical storage, or the like. Volatile Memory can include Random Access Memory (RAM) or external cache Memory. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others.
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 power database model building method is characterized by comprising the following steps:
the method comprises the steps of obtaining 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;
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.
2. The method of claim 1, wherein the plurality of grid generic service models comprises a first grid generic service model and a second grid generic service model;
the data splicing is carried out on the electric power data of the plurality of power grid general service models, and the incidence relation of the plurality of power grid general service models is established, and the method comprises the following steps:
acquiring a splicing field and splicing data under the splicing field; the splicing field is a field which is used for splicing the power data of the power grid general service models in the general field of the power grid general model;
and if the first power grid universal service model stores first splicing data matched with second splicing data stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing an incidence relation between the first power grid universal service model and the second power grid universal service model.
3. The method of claim 2, wherein the concatenation field comprises: the power equipment codes corresponding to the power data; the power device code comprises a first power device code and a second power device code;
if the first power grid universal service model stores first splicing data matched with second splicing data stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing an incidence relation between the first power grid universal service model and the second power grid universal service model, including:
and if the first power equipment code which is the same as the second power equipment code stored in the second power grid general service model is stored in the first power grid general service model, performing data splicing on the first power grid general service model and the second power grid general service model, and establishing the incidence relation between the first power grid general service model and the second power grid general service model.
4. The method of claim 2, wherein the concatenation field comprises: the electric power equipment name corresponding to the electric power data; the power equipment names comprise a first power equipment name and a second power equipment name;
if the first power grid universal service model stores first splicing data matched with second splicing data stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing an incidence relation between the first power grid universal service model and the second power grid universal service model, including:
and if the first power grid universal service model stores the first power equipment name matched with the keyword of the second power equipment name stored in the second power grid universal service model, performing data splicing on the first power grid universal service model and the second power grid universal service model, and establishing the incidence relation between the first power grid universal service model and the second power grid universal service model.
5. The method of any of claims 1 to 4, further comprising:
and if the field mapping table does not store the general field of the power grid general model corresponding to the data field of the power data, storing the data field of the power data into the field mapping table as the general field of the power grid general model.
6. The method of claim 1, wherein the power service system comprises: at least one of a grid scheduling system, a geographic information system, a production system, a marketing system, or a metering automation system.
7. The method of claim 6, wherein the power data comprises: at least one of a main network model data, a first geographic information data, a second geographic information data, a production data, a marketing data or an electric power metering data;
the acquiring of the plurality of power data collected by the plurality of power service systems includes:
acquiring the master network model data from the power grid dispatching system according to a dispatching system file transmission protocol;
acquiring the first geographic information data from the geographic information system in a data synchronous extraction mode, and acquiring the second geographic information data by monitoring an electronic handover interface of the geographic information system through a monitoring system;
obtaining the production data from a production database of the production system and obtaining the marketing data from a marketing database of the marketing system through a data replication tool of a headquarters data center;
and/or
And acquiring the electric power metering data from the metering automation system according to a metering system file transfer protocol.
8. A power database model building device, the device comprising:
the power data acquisition module is used for acquiring a plurality of power data acquired by a plurality of power service systems and data fields of the plurality of power data;
the universal field conversion module is used for converting the data field into a universal field of the power grid universal 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;
the universal model writing module is used for writing the electric power data into the power grid universal model according to the universal fields to form a plurality of power grid universal service models;
the power data splicing module is used for performing data splicing on the power data of the power grid general service models and establishing the incidence relation of the power grid general service models;
and the electric power model building module is used for building an electric power database model based on the incidence relation.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
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 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010410723.4A CN111597166B (en) | 2020-05-15 | 2020-05-15 | Power database model construction method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010410723.4A CN111597166B (en) | 2020-05-15 | 2020-05-15 | Power database model construction method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111597166A true CN111597166A (en) | 2020-08-28 |
| CN111597166B CN111597166B (en) | 2023-10-27 |
Family
ID=72191034
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010410723.4A Active CN111597166B (en) | 2020-05-15 | 2020-05-15 | Power database model construction method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111597166B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112306990A (en) * | 2020-10-29 | 2021-02-02 | 广东电网有限责任公司 | Power grid data acquisition method, device, equipment and storage medium |
| CN115133532A (en) * | 2022-09-01 | 2022-09-30 | 南方电网数字电网研究院有限公司 | Management and control method, device, equipment and storage medium for power system |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5848426A (en) * | 1993-03-05 | 1998-12-08 | Metanetics Corporation | Automatic data translation between different business systems |
| US20050086199A1 (en) * | 1998-03-31 | 2005-04-21 | Champagne Darryl G. | Transferring records between two databases |
| CN102063509A (en) * | 2011-01-12 | 2011-05-18 | 南京南瑞继保电气有限公司 | Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system |
| CN102495850A (en) * | 2011-11-18 | 2012-06-13 | 中国南方电网有限责任公司 | Method for splicing multi-stage multi-region interconnected power grid relay protection model |
| CN103365960A (en) * | 2013-06-18 | 2013-10-23 | 国家电网公司 | Off-line searching method of structured data of electric power multistage dispatching management |
| CN104484738A (en) * | 2014-11-24 | 2015-04-01 | 广东电网有限责任公司电力科学研究院 | Method and system for centralized management of power grid data |
| US20150113025A1 (en) * | 2013-10-17 | 2015-04-23 | Sap Ag | System for customizing specific database models using specific database views |
| WO2018005666A8 (en) * | 2016-06-29 | 2018-02-08 | Amazon Technologies, Inc. | Network-accessible data volume modification |
| US10509764B1 (en) * | 2015-06-19 | 2019-12-17 | Amazon Technologies, Inc. | Flexible remote direct memory access |
-
2020
- 2020-05-15 CN CN202010410723.4A patent/CN111597166B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5848426A (en) * | 1993-03-05 | 1998-12-08 | Metanetics Corporation | Automatic data translation between different business systems |
| US20050086199A1 (en) * | 1998-03-31 | 2005-04-21 | Champagne Darryl G. | Transferring records between two databases |
| CN102063509A (en) * | 2011-01-12 | 2011-05-18 | 南京南瑞继保电气有限公司 | Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system |
| CN102495850A (en) * | 2011-11-18 | 2012-06-13 | 中国南方电网有限责任公司 | Method for splicing multi-stage multi-region interconnected power grid relay protection model |
| CN103365960A (en) * | 2013-06-18 | 2013-10-23 | 国家电网公司 | Off-line searching method of structured data of electric power multistage dispatching management |
| US20150113025A1 (en) * | 2013-10-17 | 2015-04-23 | Sap Ag | System for customizing specific database models using specific database views |
| CN104484738A (en) * | 2014-11-24 | 2015-04-01 | 广东电网有限责任公司电力科学研究院 | Method and system for centralized management of power grid data |
| US10509764B1 (en) * | 2015-06-19 | 2019-12-17 | Amazon Technologies, Inc. | Flexible remote direct memory access |
| WO2018005666A8 (en) * | 2016-06-29 | 2018-02-08 | Amazon Technologies, Inc. | Network-accessible data volume modification |
Non-Patent Citations (1)
| Title |
|---|
| 任开银;孔震;叶敏;: "通用数据交换系统架构设计与实现", 电力系统自动化, no. 20 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112306990A (en) * | 2020-10-29 | 2021-02-02 | 广东电网有限责任公司 | Power grid data acquisition method, device, equipment and storage medium |
| CN115133532A (en) * | 2022-09-01 | 2022-09-30 | 南方电网数字电网研究院有限公司 | Management and control method, device, equipment and storage medium for power system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111597166B (en) | 2023-10-27 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107357856B (en) | Implementation method of data integration and data service based on grid panorama business model | |
| US7111018B1 (en) | System and method for integrating electrical power grid and related data from various proprietary raw data formats into a single maintainable electrically connected database | |
| Rohjans et al. | Requirements for smart grid ICT-architectures | |
| CN106203890A (en) | Battalion based on CIM auxiliary tone integration data modeling method | |
| CN113849944A (en) | Grid topology service method, device and system based on graph data model | |
| Kim et al. | QVT-based model transformation to support unification of IEC 61850 and IEC 61970 | |
| CN103077212A (en) | Transformer substation configuration file control method and system | |
| KR102063024B1 (en) | System for integrated process of data for smart city and method thereof | |
| US20150317127A1 (en) | System for metamodeling unification | |
| CN111597166B (en) | Power database model construction method, device, computer equipment and storage medium | |
| CN112580178A (en) | Graph-model bidirectional verification method and device for energy management system | |
| US20160092604A1 (en) | Method for metamodeling unification | |
| CN111563304A (en) | Power distribution network frame meta-model construction method | |
| CN104881739A (en) | Marketing and distribution data consistency verification method based on IEC61970-61968 CIM standard | |
| CN112541711A (en) | Model construction method and device, computer equipment and storage medium | |
| CN112286884B (en) | Method, system and medium for automatically generating topology of ring main unit of power distribution network | |
| US20160098023A1 (en) | System for metamodeling transformation | |
| CN103294878A (en) | Unified modeling method of multidimensional grid models based on DMS (database management system) | |
| CN117453690A (en) | Data processing method, device and computer medium for power grid data warehouse | |
| CN117273632A (en) | Intelligent substation secondary equipment testing method, device, equipment and medium | |
| CN117034509A (en) | Construction method, device and storage medium of venue power supply guarantee panoramic information model | |
| Paludetto et al. | MESP-an interoperable platform for multi-energy systems | |
| CN116108740A (en) | Modeling method and device for power equipment | |
| CN105184676A (en) | Power utilization data processing method and apparatus | |
| Bhargava et al. | An open source tool for reliability evaluation of distribution system using Monte Carlo simulation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |