CN111597166B - Power database model construction method, device, computer equipment and storage medium - Google Patents
Power database model construction method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111597166B CN111597166B CN202010410723.4A CN202010410723A CN111597166B CN 111597166 B CN111597166 B CN 111597166B CN 202010410723 A CN202010410723 A CN 202010410723A CN 111597166 B CN111597166 B CN 111597166B
- Authority
- CN
- China
- Prior art keywords
- power
- data
- model
- field
- power grid
- 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.)
- Active
Links
- 238000003860 storage Methods 0.000 title claims abstract description 18
- 238000010276 construction Methods 0.000 title claims abstract description 15
- 238000013507 mapping Methods 0.000 claims abstract description 47
- 238000000034 method Methods 0.000 claims abstract description 40
- 238000004519 manufacturing process Methods 0.000 claims description 42
- 238000004590 computer program Methods 0.000 claims description 14
- 238000012544 monitoring process Methods 0.000 claims description 11
- 230000005540 biological transmission Effects 0.000 claims description 9
- 238000006243 chemical reaction Methods 0.000 claims description 6
- 230000010076 replication Effects 0.000 claims description 6
- 230000001360 synchronised effect Effects 0.000 claims description 6
- 238000000605 extraction Methods 0.000 claims description 5
- 230000005611 electricity Effects 0.000 claims description 4
- 238000009826 distribution Methods 0.000 description 11
- 238000012546 transfer Methods 0.000 description 5
- 238000013461 design Methods 0.000 description 4
- 238000010586 diagram Methods 0.000 description 4
- 238000005259 measurement Methods 0.000 description 3
- 230000003068 static effect Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000013499 data model Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000002349 favourable effect Effects 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
- 230000035515 penetration Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
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)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Water Supply & Treatment (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Marketing (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (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, a device, computer equipment and a storage medium. The method comprises the following steps: acquiring a plurality of pieces of power data acquired by a plurality of power service systems and data fields of the plurality of pieces of power data; converting the data field into a universal field of a universal power grid model according to a preset field mapping table; the field mapping table stores the corresponding relation between the data field of the electric power data and the general field of the general model of the electric network; writing the electric power data into a power grid universal model according to the universal field to form a plurality of power grid universal service models; performing data splicing on the power data of the plurality of power grid general service models, and establishing association relations of the plurality of power grid general service models; and constructing a power database model based on the association relation. By adopting the method, the construction of the electric power database with unified electric power information can be realized.
Description
Technical Field
The present application relates to the field of power data processing technologies, and in particular, to a method and apparatus for constructing a power database model, a computer device, and a storage medium.
Background
With the continuous development of power business application, the demands of cooperative maintenance and information sharing of each power department are increasing, and in order to better manage power information, the power departments generally implement information sharing by adopting a mode of constructing a public information database of a power grid. For example, a production department typically builds a distribution network database for distribution network devices to enable distribution network device data to be circulated in other power departments, such as a marketing department.
However, at present, different power departments generally store power information in different storage modes, for example, the description mode and the storage field format of the distribution network equipment by a production department and a marketing department are different, so that it is difficult to construct a power database with unified power information.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a power database model construction method, apparatus, computer device, and storage medium.
A power database model building method, the method comprising:
acquiring a plurality of pieces of power data acquired by a plurality of power service systems and data fields of the plurality of pieces of power data;
converting the data field into a universal field of a universal power grid model according to a preset field mapping table; wherein, the field mapping table stores the corresponding relation between the data field of the electric power data and the general field of the general model of the electric network;
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 electric power data of the plurality of power grid general service models, and establishing an association relation of the plurality of power grid general service models;
and constructing a power database model based on the association relation.
In one embodiment, the plurality of grid-generic business models includes a first grid-generic business model and a second grid-generic business model; the step of performing data splicing on the power data of the plurality of power grid general service models to establish the association relationship of the plurality of power grid general service models, includes: acquiring a spliced field and spliced data under the spliced field; the splicing field is used for carrying out data splicing on the electric power data of the plurality of electric network universal service models in the universal field of the electric network universal model; and if the first splicing data matched with the second splicing data stored in the second power grid general service model is stored in the first power grid general service model, carrying out data splicing on the first power grid general service model and the second power grid general service model, and establishing an association relation 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 codes corresponding to the power data; the power device code includes a first power device code and a second power device code; if the first splicing data matched with the second splicing data 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 an association relationship between the first power grid general service model and the second power grid general service model, including: and if the first power equipment codes which are the same as the second power equipment codes stored in the second power grid general service model are 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 an association relation between the first power grid general service model and the second power grid general service model.
In one embodiment, the concatenation field includes: a power device name corresponding to the power data; the power device names include a first power device name and a second power device name; if the first splicing data matched with the second splicing data 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 an association relationship between the first power grid general service model and the second power grid general service model, including: and if the first power equipment name matched with the keyword of the second power equipment name 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 an association relation between the first power grid general service model and the second power grid general service model.
In one embodiment, the method further comprises: and if the field mapping table does not store the universal field of the power grid universal model corresponding to the data field of the power data, storing the data field of the power data as the universal field of the power grid universal model into the field mapping table.
In one embodiment, the power service system includes: at least one of a 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 electricity metering data; the acquiring the plurality of power data acquired by the plurality of power service systems includes: acquiring the main 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 monitoring an electronic handover interface of the geographic information system through a monitoring system to acquire the second geographic information data; acquiring the production data from a production database of the production system and the marketing data from a marketing database of the marketing system through a data replication tool of a headquarter data center; and/or acquiring the power metering data from the metering automation system according to a metering system file transfer protocol.
A power database model building apparatus, the apparatus comprising:
the power data acquisition module is used for acquiring a plurality of power data acquired by a plurality of power business 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 a power grid universal model according to a preset field mapping table; wherein, the field mapping table stores the corresponding relation between the data field of the electric power data and the general field of the general model of the electric network;
the universal model writing module is used for writing the electric power data into the electric network universal model according to the universal field to form a plurality of electric network universal service models;
the power data splicing module is used for carrying out data splicing on the power data of the plurality of power grid general service models and establishing the association relation of the plurality of power grid general service models;
and the power model construction module is used for constructing a power database model based on the association relation.
A computer device comprising a memory storing a computer program and a processor implementing the steps of the method described above when the processor executes the computer program.
A computer readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the method described above.
The method, the device, the computer equipment and the storage medium for constructing the power database model 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 universal field of a universal power grid model according to a preset field mapping table; the field mapping table stores the corresponding relation between the data field of the electric power data and the general field of the general model of the electric network; writing the electric power data into a power grid universal model according to the universal field to form a plurality of power grid universal service models; performing data splicing on the power data of the plurality of power grid general service models, and establishing association relations of the plurality of power grid general service models; and constructing a power database model based on the association relation. According to the application, the data fields of the power data acquired by the power business systems are converted into the universal fields of the power grid universal model, the association relation of the universal business model is established in a data splicing mode after the power grid universal business model is formed, and the power database is constructed based on the association relation, so that the construction of the power database with unified power information is realized.
Drawings
FIG. 1 is a flow diagram of a method of power database model construction in one embodiment;
fig. 2 is a schematic flow chart of performing data splicing on the electric power data of the plurality of electric network universal service models and establishing an association relationship of the plurality of electric network universal service models in one embodiment;
FIG. 3 is a flowchart of a method for constructing a power database model according to another embodiment;
fig. 4 is a flow chart of a CIM-based power grid resource service design method in an application example;
FIG. 5 is a schematic flow chart of accessing data in a 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 of a power database model building apparatus in one embodiment;
fig. 7 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
The present application will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present application more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the application.
In one embodiment, as shown in fig. 1, a method for constructing a power database model is provided, and this embodiment is illustrated by applying the method to a power system server, where 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 implemented through interaction between the terminal and the server. In this embodiment, the method includes the steps of:
In step S101, the 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 working voltage or model of a transformer used by a certain power service system, purchase cost of the transformer, 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 business system stores the working voltage a1, the model a2 and the purchase cost a3 of the transformer A, the working voltage B1, the model B2 and the purchase cost B3 of the transformer B, then the power business system stores the power data a1, a2, a3, B1, B2 and B3, and the data field of the stored power data comprises the working voltage, the model and the purchase cost.
Step S102, a power system server converts a data field into a general field of a general model of a power grid according to a preset field mapping table; the field mapping table stores the corresponding relation between the data field of the electric power data and the general field of the general model of the electric network.
The general power grid model can be an enterprise public information model issued by a southern power grid company, comprises core data model standard specifications of power grid resources, equipment, clients, measurement and the like, and stores corresponding general fields. Because the data fields of the power data adopted by different service systems are possibly different, the power system server can convert the data fields of the different power data in the plurality of power service systems into the universal fields of the unified power grid universal model through a pre-stored field mapping table storing the corresponding relation between the data fields of the power data and the universal fields of the power grid universal model.
For example: the data fields adopted by a certain manufacturer of the transformer can be the manufacturer for the power service system A, the data fields adopted by the power service system B can be the transformer manufacturer, and the two power service systems adopt different data fields although the data of the manufacturers of the transformers are recorded. At this time, the power system server may convert different data fields into general fields of the general power grid model through the field mapping table, where the general fields may be the transformer manufacturer, and then the field mapping table stores the mapping between the manufacturer and the transformer manufacturer fields and the mapping between the transformer manufacturer and the transformer manufacturer fields, so as to convert the manufacturer of the power service system a and the transformer manufacturer in the power service system B into general field transformer manufacturers of the general power grid model.
Step S103, the power system server writes the power data into the power grid general model 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 power service system a in the manufacturer field into the general field of the transformer manufacturer in the power grid general model.
Step S104, the power system server performs data splicing on the power data of the power grid general service models, and establishes association relations of the power grid general service models.
The association relationship of the power grid general service models refers to the association relationship of data between different power grid general service models, 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 the production system, or may be partially stored in the power service system B, such as the marketing system, and the number of the transformer has unified the data fields of the production system and the marketing system that may exist through step S103, so that the power system server may splice the transformer data after the unified data fields into relevant data 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 constructs a power database model based on the association relationship.
After the association relations of the plurality of power service systems are obtained by the power system server 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 relation between the production system and the marketing system, so that a production marketing model including both the production system data and the marketing system data is successfully constructed, and is used as an information model of the power database with unified power information.
In the above power database model construction method, 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 universal field of a universal power grid model according to a preset field mapping table; the field mapping table stores the corresponding relation between the data field of the electric power data and the general field of the general model of the electric network; writing the electric power data into a power grid universal model according to the universal field to form a plurality of power grid universal service models; performing data splicing on the power data of the plurality of power grid general service models, and establishing association relations of the plurality of power grid general service models; and constructing a power database model based on the association relation. According to the application, the data fields of the power data acquired by the power system servers are converted into the universal fields of the power grid universal model, the association relation of the universal service model is established in a data splicing mode after the power grid universal service model is formed, and the power database is constructed based on the association relation, so that the construction of the power database with unified power information is realized.
In one embodiment, as shown in fig. 2, the plurality of grid-generic service models may include a first grid-generic service model and a second grid-generic service model, and step S104 may include:
step S201, a power system server acquires a spliced field and spliced data under the spliced field; the splicing field is used for carrying out data splicing on the electric power data of the plurality of electric network universal service models in the universal field of the electric network universal model;
the splicing fields are used for carrying out data splicing on the electric power data of the plurality of electric network universal service models in the universal fields of the electric network universal models. Specifically, the spliced 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 or the like, and is used as a field for carrying out data splicing on the electric 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 an association relationship between the first power grid general service model and the second power grid general service model is established.
After the electric power system server in step S201 obtains the spliced field, the electric power data under the spliced field may be extracted from the first electric power grid general service model obtained by converting the electric power service system a in the spliced field, as first spliced data, and meanwhile, the electric power data under the spliced field is extracted from the second electric power grid general service model obtained by converting the electric power service system B, as second spliced data, if there is a match between the second spliced data and the first spliced data, data splicing is performed on the data stored in the first electric power grid general service model and the second electric power grid general service model based on the spliced data, so as to establish an association relationship between the first electric power grid general service model and the second electric power grid general service model.
Further, the concatenation field may include: encoding power equipment corresponding to the power data; the power device codes include a first power device code and a second power device code, and step S202 may further include:
if the first power equipment codes which are the same as the second power equipment codes stored in the second power grid general service model are 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 an association relation between the first power grid general service model and the second power grid general service model is established.
The splicing field adopted by the power system server can be a power equipment code corresponding to the power data, and for the transformer equipment, the data splicing among the plurality of power grid general service models can be performed 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, and simultaneously 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, a first transformer code identical to the second transformer code 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 for 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 digital coding form only by text, for example, the splicing field may further include a power device name corresponding to the power data, where the power device name may further include a first power device name and a second power device name, and step S202 may further include:
And if the first power equipment name matched with the keyword of the second power equipment name 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 an association relation between the first power grid general service model and the second power grid general service model.
Specifically, the power system server may extract a first power equipment name from the first power grid general service model, extract a keyword in the first power equipment name, select a second power equipment name matched with the keyword of the first power equipment name in a keyword fuzzy matching manner, and perform data splicing on the first power grid general service model and the second power grid general service model based on the equipment name, so as to establish an association relationship between the first power grid general service model and the second power grid general service model.
In the above embodiment, the power system server performs data splicing on the power data stored by different power grid general service models based on the general fields of the unified power grid general model, so as to establish the association relationship of a plurality of power grid general service models.
In one embodiment, if the field mapping table does not store a generic field of the grid generic model corresponding to a data field of the power data, the power system server stores the data field of the power data as a generic field of the grid generic model into the field mapping table.
Since the field map is a map for correspondence between data fields of power data and general fields of a grid general model, there may be a case where general fields of the grid general model corresponding to data fields of certain power data are missing in the map. Therefore, in this case, the power system server may directly use the data field of the power data that is missing in the mapping table as a general field of the power grid general model, store the field into 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.
According to the embodiment, the data fields of the electric power data which are not contained in the field mapping table are written into the field mapping table, so that the electric power data under the data fields can be written into the corresponding power grid universal model, the integrity of the electric power data is ensured, and the data integrity of the constructed electric power database model is ensured.
In one embodiment, a power service system includes: at least one of a grid dispatching 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 collecting main network information, carrying out data monitoring, safety analysis and the like on the main network information, the geographic information system is a GIS system and is mainly used for collecting geographic position information such as the position and the like of power equipment, 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 and is used for recording metering relation information describing customers and electric energy meters.
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 electricity 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 and marketing data from a marketing database of a marketing system through a data replication tool of a headquarter data center; and/or acquiring power metering data from the metering automation system according to a metering system file transfer protocol.
Wherein the first geographic information data represents geographic information data acquired from the geographic information system at the first time, and the second geographic information data represents geographic information data acquired from the geographic information system at the later time. Specifically, the power system server may acquire various power data from different power service systems in different manners, for example, may acquire and update main network information of the power grid dispatching system and metering information of the metering automation system in a manner of reading an E file through a File Transfer Protocol (FTP); reading first-period 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-period GIS data; production data may also be obtained from a production database of the production system and marketing data from a marketing database of the marketing system via a data replication tool of the headquarter data center.
In the above embodiment, the power system server acquires the power data acquired by different power service systems respectively, and synchronously acquires the power data from different power service systems by using different data acquisition modes on the basis, which is favorable for improving the instantaneity and accuracy of the acquired power data, and further can improve 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, and the method is applied to a power system server for illustration, and in the embodiment, the 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, a power system server converts a data field into a general field of a general model of a power grid according to a preset field mapping table; the field mapping table stores the corresponding relation between the data field of the electric power data and the general field of the general model of the electric network;
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 as the general field of the power grid general model into the field mapping table;
step S304, the power system server writes the power data into a power grid general model according to general fields to form a plurality of power grid general service models;
step S305, the power system server acquires splicing fields and splicing data under the splicing fields; the splicing field is used for carrying out data splicing on the electric power data of the plurality of electric network universal service models in the universal field of the electric network universal model; the splicing field includes: the power equipment codes corresponding to the power data and the power equipment names corresponding to the power data;
Step S306, if the first power equipment codes which are the same as the second power equipment codes stored in the second power grid general service model are 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 an association relation between the first power grid general service model and the second power grid general service model is established;
step S307, if the first power grid general service model stores a first power equipment name matched with the keyword of the second power equipment name 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 association relationship between the first power grid general service model and the second power grid general service model;
step S308, the power system server builds a power database model based on the association relation.
According to the power database model construction method provided by the embodiment, the power system server converts the data fields of the power data acquired by the plurality of power service systems into the universal fields of the power grid universal model, establishes the association relation of the universal service model in a data splicing mode after the power grid universal service model is formed, and constructs the power database based on the association relation, so that the construction of the power database with unified power information is realized. In addition, by selecting different splicing fields and different splicing modes, various data splicing modes are provided, the realizability of constructing the power database model is further improved, the data fields of the power data which are not contained in the field mapping table are written into the field mapping table, the power data under the data fields can be written into the corresponding power grid universal model, the integrity of the power data is ensured, and therefore the data integrity of the constructed power database model is ensured.
In an application example, a CIM-based power grid resource service design method is provided, as shown in fig. 4, where the application example may include the following steps:
step s1, accessing data in a power grid dispatching system, a GIS platform, a production database, a marketing database and a metering automation system, wherein the step comprises the following steps: main network model data are obtained from a dispatching system, power transmission, middle-low voltage equipment layers and attribute data are obtained from a GIS platform, functional position and physical equipment data are obtained from a production database, customer, metering point and electric energy meter data are obtained from a marketing database, and household, meter and terminal relation data are obtained 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 obtained and updated by reading the E file through FTP; the GIS data in the GIS platform is synchronously acquired through a database at the first stage, and the electronic handover interface is monitored through an SOA at the later stage, so that real-time synchronous acquisition is realized; the production and marketing data are synchronously acquired through OGG replication of a headquarter data center, and the data are accessed into a power grid resource model database.
Step s2, converting the model data, eliminating the difference of data semantics and formats 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, middle-low voltage equipment image layers and attribute data into power transmission, middle-low voltage power grid resources, converting functional position and physical equipment data into power grid resources and equipment assets, converting customer, metering point and electric energy meter data into customer, metering point and electric energy meter models, and converting household, meter and terminal relation data into acquisition terminal and metering point models.
Specifically, CIM files in the dispatching system are converted into CIM data tables of transformer substations and equipment (including 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; the distribution line, the transmission line, the internal equipment of a distribution station room, the low-voltage line and the fire drop point in the GIS system are pushed to a GIS layer table and are converted into a CIM library through a storage process; the production and marketing data are transferred to the 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. After model conversion, a model meeting the requirements of unified information fusion semantics and format is formed, and the hitching on the whole network unified model is realized by using names and IDs.
Specifically, the method and the system respectively realize the topology splicing between a main network substation and a distribution network feeder, the GIS distribution transformer and a marketing medium-voltage user are associated with meter information under a fire drop point and a marketing low-voltage user, the topology relationship of the dispatching, distribution network and marketing is opened, and the measurement point relationship of the main transformer, the line, the distribution transformer and the metering automation is established.
And step s4, constructing a unified resource model of the power grid. And integrating a main network model, a distribution network model taking the GIS platform data as a framework, marketing users and a metering point model in the dispatching system based on IEC61970,61968 standard, and constructing a full-voltage-level power grid unified model containing power supply, power grid and customer information.
Specifically, a unified topology model, a power grid resource model, an equipment asset model, a client model, a metering point model and a measuring point model are built around four main lines of power grid resources, assets, clients, measurement and the like by optimizing model design.
According to the CIM-based power grid resource service design method, the model-based integrated unified power grid model is designed, each business system can develop business application based on the model, sharing of unified power grid model data in the whole power grid range is achieved, a relevant standard system is sound, data links between links and businesses are opened, transverse integration and longitudinal penetration of data are achieved, and the internal data sharing utilization level and the integrated management level of the power grid are further improved.
It should be understood that, although the steps in the flowcharts of fig. 1-5 are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in fig. 1-5 may include multiple steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor do the order in which the steps or stages are performed necessarily performed in sequence, but may be performed alternately or alternately with at least a portion of the steps or stages in other steps or other steps.
In one embodiment, as shown in fig. 6, there is provided a power database model building apparatus including: a power data acquisition module 601, a general field conversion module 602, a general model writing module 603, a power data stitching module 604, and a power model building module 605, wherein:
the power data acquisition module 601 is configured to acquire a plurality of power data acquired by a plurality of power service systems, and a data field of the plurality of power data;
the universal field conversion module 602 is configured to convert 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 electric power data and the general field of the general model of the electric network;
the universal model writing module 603 is configured to write the power data into the power grid universal model according to the universal field to form a plurality of power grid universal service models;
the power data splicing module 604 is configured to perform data splicing on power data of the plurality of power grid general service models, and establish an association relationship of the plurality of power grid general service models;
the power model building module 605 is configured to build a power database model based on the association relation.
In one embodiment, the plurality of grid-generic business models includes a first grid-generic business model and a second grid-generic business model; the power data splicing module 604 is further configured to obtain a spliced field and spliced data under the spliced field; the splicing field is used for carrying out data splicing on the electric power data of the plurality of electric network universal service models in the universal field of the electric network universal model; and if the first splicing data matched with the second splicing data 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 an association relation between the first power grid general service model and the second power grid general service model.
In one embodiment, the splice field includes: encoding power equipment corresponding to the power data; the power device codes include a first power device code and a second power device code; the power data splicing module 604 is further configured to, if the first power device code that is the same as the 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 splice field includes: a power device name corresponding to the power data; the power device names include a first power device name and a second power device name; the power data splicing module 604 is further configured to, if the first power device name matching the keyword of the second power device name 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 universal field conversion module 602 is further configured to store the data field of the electric power data as the universal field of the electric power universal model into the field mapping table if the universal field of the electric power universal model corresponding to the data field of the electric power data is not stored in the field mapping table.
In one embodiment, a power service system includes: at least one of a 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 electricity metering data; the power data acquisition module 601 is further configured to acquire main network model data from the power grid dispatching system according to a dispatching 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 and marketing data from a marketing database of a marketing system through a data replication tool of a headquarter data center; and acquiring power metering data from the metering automation system according to a metering system file transfer protocol.
For specific limitations on the power database model construction apparatus, reference may be made to the above limitations on the power database model construction method, and no further description is given here. The respective modules in the above-described power database model building apparatus may be implemented in whole or in part by software, hardware, and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above 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 includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer device is for storing power data. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program when executed by a processor implements a power database model building method.
It will be appreciated by those skilled in the art that the structure shown in FIG. 7 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In an embodiment, there is also provided a computer device comprising a memory and a processor, the memory having stored therein a computer program, the processor implementing the steps of the method embodiments described above when the computer program is executed.
In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when executed by a processor, carries out the steps of the method embodiments described above.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, or the like. Volatile memory can include random access memory (Random Access Memory, RAM) or external cache memory. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples illustrate only a few embodiments of the application, which are described in detail and are not to be construed as limiting the scope of the application. It should be noted that it will be apparent to those skilled in the art that several variations and modifications can be made without departing from the spirit of the application, which are all within the scope of the application. Accordingly, the scope of protection of the present application is to be determined by the appended claims.
Claims (10)
1. A method of constructing a power database model, the method comprising:
acquiring a plurality of pieces of power data acquired by a plurality of power service systems and data fields of the plurality of pieces of power data; different power service systems in the plurality of power service systems use different data fields, wherein the data fields comprise manufacturer fields and transformer manufacturer fields;
Converting the data field into a universal field of a universal power grid model according to a preset field mapping table; wherein, the field mapping table stores the corresponding relation between the data field of the electric power data and the general field of the general model of the electric network; the general field comprises a transformer manufacturer field, and the field mapping table stores the mapping between the manufacturer field and the transformer manufacturer field and the mapping between the transformer manufacturer and the transformer manufacturer field;
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 electric power data of the plurality of power grid general service models, and establishing an association relation of the plurality of power grid general service models;
and constructing a power database model based on the association relation.
2. The method of claim 1, wherein the plurality of grid-generic business models comprises a first grid-generic business model and a second grid-generic business model;
the step of performing data splicing on the power data of the plurality of power grid general service models to establish the association relationship of the plurality of power grid general service models, includes:
Acquiring a spliced field and spliced data under the spliced field; the splicing field is used for carrying out data splicing on the electric power data of the plurality of electric network universal service models in the universal field of the electric network universal model;
and if the first splicing data matched with the second splicing data stored in the second power grid general service model is stored in the first power grid general service model, carrying out data splicing on the first power grid general service model and the second power grid general service model, and establishing an association relation between the first power grid general service model and the second power grid general service model.
3. The method of claim 2, wherein the concatenation field includes: 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;
if the first splicing data matched with the second splicing data 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 an association relationship between the first power grid general service model and the second power grid general service model, including:
And if the first power equipment codes which are the same as the second power equipment codes stored in the second power grid general service model are 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 an association 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 includes: a power device name corresponding to the power data; the power device names include a first power device name and a second power device name;
if the first splicing data matched with the second splicing data 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 an association relationship between the first power grid general service model and the second power grid general service model, including:
and if the first power equipment name matched with the keyword of the second power equipment name 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 an association relation between the first power grid general service model and the second power grid general service model.
5. The method according to any one of claims 1 to 4, further comprising:
and if the field mapping table does not store the universal field of the power grid universal model corresponding to the data field of the power data, storing the data field of the power data as the universal field of the power grid universal model into the field mapping table.
6. The method of claim 1, wherein the power service system comprises: at least one of a grid dispatching 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 main network model data, first geographic information data, second geographic information data, production data, marketing data, or electricity metering data;
the acquiring the plurality of power data acquired by the plurality of power service systems includes:
acquiring the main 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 monitoring an electronic handover interface of the geographic information system through a monitoring system to acquire the second geographic information data;
Acquiring the production data from a production database of the production system and the marketing data from a marketing database of the marketing system through a data replication tool of a headquarter data center;
and/or
And acquiring the electric power metering data from the metering automation system according to a metering system file transmission protocol.
8. An apparatus for modeling a power database, the apparatus comprising:
the power data acquisition module is used for acquiring a plurality of power data acquired by a plurality of power business systems and data fields of the plurality of power data; different power service systems in the plurality of power service systems use different data fields, wherein the data fields comprise manufacturer fields and transformer manufacturer fields;
the universal field conversion module is used for converting the data field into a universal field of a power grid universal model according to a preset field mapping table; wherein, the field mapping table stores the corresponding relation between the data field of the electric power data and the general field of the general model of the electric network; the general field comprises a transformer manufacturer field, and the field mapping table stores the mapping between the manufacturer field and the transformer manufacturer field and the mapping between the transformer manufacturer and the transformer manufacturer field;
The universal model writing module is used for writing the electric power data into the electric network universal model according to the universal field to form a plurality of electric network universal service models;
the power data splicing module is used for carrying out data splicing on the power data of the plurality of power grid general service models and establishing the association relation of the plurality of power grid general service models;
and the power model construction module is used for constructing a power database model based on the association relation.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any of claims 1 to 7 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any 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 CN111597166A (en) | 2020-08-28 |
| CN111597166B true 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) |
Families Citing this family (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 |
| CN115133532B (en) * | 2022-09-01 | 2022-11-25 | 南方电网数字电网研究院有限公司 | Method for realizing electric power system management and control based on digital power grid application development model |
Citations (7)
| 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 |
| 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 |
| 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 |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6925477B1 (en) * | 1998-03-31 | 2005-08-02 | Intellisync Corporation | Transferring records between two databases |
| US10255241B2 (en) * | 2013-10-17 | 2019-04-09 | Sap Se | System for customizing specific database models using specific database views |
-
2020
- 2020-05-15 CN CN202010410723.4A patent/CN111597166B/en active Active
Patent Citations (7)
| 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 |
| 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 |
| 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 |
|---|
| 通用数据交换系统架构设计与实现;任开银;孔震;叶敏;;电力系统自动化(20);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111597166A (en) | 2020-08-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| 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 | |
| US20090187579A1 (en) | System, Method and Product for Processing Utility Data | |
| CN103955789A (en) | Power supply path analyzing method based on integrated model for allocation | |
| CN103077212A (en) | Transformer substation configuration file control method and system | |
| CN111597166B (en) | Power database model construction method, device, computer equipment and storage medium | |
| Kim et al. | QVT-based model transformation to support unification of IEC 61850 and IEC 61970 | |
| US20150317127A1 (en) | System for metamodeling unification | |
| CN112580178B (en) | Graph-model bidirectional verification method and device for energy management system | |
| US20160092604A1 (en) | Method for metamodeling unification | |
| McMorran et al. | Addressing the challenge of data interoperability for off-line analysis of distribution networks in the Smart Grid | |
| CN105704184A (en) | Power grid organization analysis system based on level framework and analysis method | |
| CN104881739A (en) | Marketing and distribution data consistency verification method based on IEC61970-61968 CIM standard | |
| CN111666456A (en) | Automatic net rack topology construction method based on multi-source distribution network | |
| JP2009213238A (en) | Power information integrated management system | |
| Hargreaves et al. | Foundations of a metamodel repository for use with the IEC common information model | |
| US20160098023A1 (en) | System for metamodeling transformation | |
| CN108876445A (en) | A kind of data interoperation application based on battalion's distribution end-equipment common information model | |
| CN116108740A (en) | Modeling method and device for power equipment | |
| CN103294878A (en) | Unified modeling method of multidimensional grid models based on DMS (database management system) | |
| CN103617141A (en) | Method for electrical equipment field test and characteristic evaluation management | |
| CN103023740A (en) | Information interaction bus system and electric power data transmission method | |
| Ma et al. | Extended common information model for distribution network production repair platform | |
| KR20180037487A (en) | Method and recording medium for compatibility between iec61850 and opc ua | |
| Cico et al. | Implementation of enterprise GIS in power distribution utilities | |
| CN103560910A (en) | Communication resource management system accuracy detection system dynamic configuration method and device |
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 |