CN111080479A - Method and device for establishing unified data model of power grid - Google Patents
Method and device for establishing unified data model of power grid Download PDFInfo
- Publication number
- CN111080479A CN111080479A CN201911274262.6A CN201911274262A CN111080479A CN 111080479 A CN111080479 A CN 111080479A CN 201911274262 A CN201911274262 A CN 201911274262A CN 111080479 A CN111080479 A CN 111080479A
- Authority
- CN
- China
- Prior art keywords
- service data
- data object
- core service
- model
- 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.)
- Granted
Links
- 238000013499 data model Methods 0.000 title claims abstract description 99
- 238000000034 method Methods 0.000 title claims abstract description 33
- 238000013507 mapping Methods 0.000 claims abstract description 64
- 238000009826 distribution Methods 0.000 claims description 13
- 230000010354 integration Effects 0.000 claims description 8
- 230000010076 replication Effects 0.000 claims description 6
- 238000012545 processing Methods 0.000 abstract description 6
- 238000007726 management method Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 6
- 238000004519 manufacturing process Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 238000013461 design Methods 0.000 description 3
- 238000010276 construction Methods 0.000 description 2
- 230000003044 adaptive effect Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000007774 longterm Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000003860 storage Methods 0.000 description 1
Images
Classifications
-
- 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
-
- 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
-
- 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 invention provides a method for creating a unified data model of a power grid, which comprises the steps of determining a core service data object set of the power grid; respectively establishing a mapping relation between an entity in an IEC CIM model and a corresponding core service data object in a power grid core service data object set, a mapping relation between an entity in an SG-ERP model and a corresponding core service data object in a power grid core service data object set, and a mapping relation between an entity in an SG-CIM3.0 model and a corresponding core service data object in a power grid core service data object set to obtain a logic model of each subject domain in a power grid; integrating the logic model of each subject domain according to the cross-professional service data object in the power grid core service data object to obtain a standardized logic model of a power grid unified data model; and based on the standardized logic model, a physical data model of the unified data model of the power grid is created, and data sharing and service cooperative processing among power grid systems are realized.
Description
Technical Field
The invention relates to the technical field of data models, in particular to a method and a device for creating a unified data model of a power grid.
Background
In order to accelerate the construction of the global energy Internet and realize the aim of comprehensively constructing the modern company of 'one-strong three-excellent', the national power grid company puts higher requirements on the full-service cooperation and full-process communication of the power grid system.
At present, a data model adopted by a power grid system cannot cover core services of a national power grid, and data sharing and service cooperative processing among power grid systems cannot be realized.
Disclosure of Invention
In view of this, the invention provides a method and a device for creating a unified data model of a power grid, which cover the core services of the national power grid and realize data sharing and service cooperative processing among power grid systems.
In order to achieve the above purpose, the invention provides the following specific technical scheme:
a method for creating a unified data model of a power grid comprises the following steps:
determining a power grid core service data object set;
respectively establishing a mapping relation between an entity in an IEC CIM model and a corresponding core service data object in the power grid core service data object set, a mapping relation between an entity in an SG-ERP model and a corresponding core service data object in the power grid core service data object set, and a mapping relation between an entity in an SG-CIM3.0 model and a corresponding core service data object in the power grid core service data object set to obtain a logic model of each subject domain in a power grid, wherein each subject domain comprises a plurality of logic models corresponding to the core service data objects;
integrating the logic model of each subject domain according to the cross-professional service data object in the power grid core service data object to obtain a standardized logic model of a power grid unified data model;
and creating a physical data model of the unified power grid data model based on the standardized logic model.
Optionally, the respectively establishing a mapping relationship between an entity in the IEC CIM model and a corresponding core service data object in the power grid core service data object set, a mapping relationship between an entity in the SG-ERP model and a corresponding core service data object in the power grid core service data object set, and a mapping relationship between an entity in the SG-CIM3.0 model and a corresponding core service data object in the power grid core service data object set to obtain a logic model of each topic domain in the power grid includes:
according to the IEC CIM model and the power grid core service data object set, determining a core service data object corresponding to an entity in the IEC CIM model in the power grid core service data object set to obtain a first core service data object set;
establishing a mapping relation between an entity in the IEC CIM model and each core service data object in the first core service data object set to obtain a logic model of each core service data object in the first core service data object set;
determining a core service data object corresponding to an entity in the SG-ERP model in the power grid core service data object set according to the SG-ERP model and the power grid core service data object set to obtain a second core service data object set;
establishing a mapping relation between an entity in the SG-ERP model and each core service data object in the second core service data object set to obtain a logic model of each core service data object in the second core service data object set;
determining a core service data object corresponding to an entity in the SG-CIM3.0 model in the power grid core service data object set according to the SG-CIM3.0 model and the power grid core service data object set to obtain a third core service data object set;
establishing a mapping relation between an entity in the SG-CIM3.0 model and each core service data object in the third core service data object set to obtain a logic model of each core service data object in the third core service data object set;
and acquiring the logic model of each theme domain according to the logic model of each core service data object in the power grid core service data object set and the theme domain to which each core service data object belongs.
Optionally, when a core service data object to be completed exists in the power grid core service data object set, the core service data object to be completed does not belong to the first core service data object set, the second core service data object set, and the third core service data object set, before the obtaining of the logic model of each topic domain according to the logic model of each core service data object in the power grid core service data object set and the topic domain to which each core service data object belongs, the method further includes:
and creating a logic model of the core service data object to be completed.
Optionally, the creating a logic model of the core service data object to be completed includes:
judging whether an entity of the same type as the core service data object to be completed exists in the entity of which the logic model is obtained;
if the core service data object to be perfected exists, creating a target class of an entity in the logic model of the core service data object to be perfected, wherein the target class inherits the class of the entity with the same type as the core service data object to be perfected;
if not, creating a target class of an entity in the logic model of the core service data object to be perfected;
adding attributes and relations to the entity corresponding to the core service data object to be completed, wherein the entity, the attributes and the relations corresponding to the core service data object to be completed form a logic model of the core service data object to be completed.
Optionally, the creating a physical data model of a unified data model of the power grid based on the standardized logical model includes:
converting the entities, attributes and relationships in the standardized logic model into data tables, fields, main foreign keys and association relationships in a physical data model;
dividing data tables in the physical data model into a replication table, a random distribution table, a Hash distribution table, a temporary table and a nocopies table according to the type of a preset database;
converting the field type in the data table in the physical data model into the data type supported by the preset database;
generating a library building script according to the division result of the data table in the physical data model and the converted data type;
and operating the database establishing script to complete the establishment of the physical data model of the power grid unified data model.
An apparatus for creating a unified data model of a power grid, comprising:
the object set determining unit is used for determining a power grid core service data object set;
a mapping relation establishing unit, configured to respectively establish a mapping relation between an entity in an IEC CIM model and a corresponding core service data object in the power grid core service data object set, a mapping relation between an entity in an SG-ERP model and a corresponding core service data object in the power grid core service data object set, and a mapping relation between an entity in an SG-CIM3.0 model and a corresponding core service data object in the power grid core service data object set, so as to obtain a logic model of each topic domain in a power grid, where each topic domain includes logic models corresponding to multiple core service data objects;
the logic model integration unit is used for integrating the logic model of each subject domain according to the cross-professional service data object in the power grid core service data object to obtain a standardized logic model of a power grid unified data model;
and the physical data model creating unit is used for creating a physical data model of the unified power grid data model based on the standardized logic model.
Optionally, the mapping relationship establishing unit is specifically configured to:
according to the IEC CIM model and the power grid core service data object set, determining a core service data object corresponding to an entity in the IEC CIM model in the power grid core service data object set to obtain a first core service data object set;
establishing a mapping relation between an entity in the IEC CIM model and each core service data object in the first core service data object set to obtain a logic model of each core service data object in the first core service data object set;
determining a core service data object corresponding to an entity in the SG-ERP model in the power grid core service data object set according to the SG-ERP model and the power grid core service data object set to obtain a second core service data object set;
establishing a mapping relation between an entity in the SG-ERP model and each core service data object in the second core service data object set to obtain a logic model of each core service data object in the second core service data object set;
determining a core service data object corresponding to an entity in the SG-CIM3.0 model in the power grid core service data object set according to the SG-CIM3.0 model and the power grid core service data object set to obtain a third core service data object set;
establishing a mapping relation between an entity in the SG-CIM3.0 model and each core service data object in the third core service data object set to obtain a logic model of each core service data object in the third core service data object set;
and acquiring the logic model of each theme domain according to the logic model of each core service data object in the power grid core service data object set and the theme domain to which each core service data object belongs.
Optionally, when a core service data object to be completed exists in the power grid core service data object set, and the core service data object to be completed does not belong to the first core service data object set, does not belong to the second core service data object set, and does not belong to the third core service data object set, the mapping relationship establishing unit further includes:
and the logic model perfecting subunit is used for creating a logic model of the core service data object to be perfected.
Optionally, the logic model perfecting subunit is specifically configured to:
judging whether an entity of the same type as the core service data object to be completed exists in the entity of which the logic model is obtained;
if the core service data object to be perfected exists, creating a target class of an entity in the logic model of the core service data object to be perfected, wherein the target class inherits the class of the entity with the same type as the core service data object to be perfected;
if not, creating a target class of an entity in the logic model of the core service data object to be perfected;
adding attributes and relations to the entity corresponding to the core service data object to be completed, wherein the entity, the attributes and the relations of the core service data object to be completed form a logic model of the core service data object to be completed.
Optionally, the physical data model creating unit is specifically configured to:
converting the entities, attributes and relationships in the standardized logic model into data tables, fields, main foreign keys and association relationships in a physical data model;
dividing data tables in the physical data model into a replication table, a random distribution table, a Hash distribution table, a temporary table and a nocopies table according to the type of a preset database;
converting the field type in the data table in the physical data model into the data type supported by the preset database;
generating a library building script according to the division result of the data table in the physical data model and the converted data type;
and operating the database establishing script to complete the establishment of the physical data model of the power grid unified data model.
Compared with the prior art, the invention has the following beneficial effects:
the invention discloses a method for establishing a unified data model of a power grid, which is characterized in that on the basis of determining a power grid core service data object set, a logical model of power grid production service according with an IEC standard is obtained by establishing a mapping relation between an entity in an IEC CIM model and a corresponding core service data object in the power grid core service data object set, a logical model of enterprise management in a power grid system is obtained by establishing a mapping relation between an entity in an SG-ERP model and a corresponding core service data object in the power grid core service data object set, a logical model of the existing core service is obtained by establishing a mapping relation between an entity in an SG-CIM3.0 model and a corresponding core service data object in the power grid core service data object set, and the power grid production, the enterprise management and the existing core service basically cover the national power grid core service, and integrating the logic model of each subject domain according to the cross-professional service data object in the power grid core service data object to obtain a standardized logic model of the power grid unified data model, and on the basis, creating a physical data model of the power grid unified data model to realize data sharing and service cooperative processing among power grid systems.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
Fig. 1 is a schematic flow chart of a method for creating a unified data model of a power grid according to an embodiment of the present invention;
fig. 2 is a schematic structural diagram of a device for creating a unified data model of a power grid according to an embodiment of the present invention.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The embodiment discloses a method for creating a unified data model of a power grid, which covers core services of a national power grid and realizes data sharing and service cooperative processing among power grid systems. Specifically, referring to fig. 1, the method for creating the unified data model of the power grid specifically includes the following steps:
s101: determining a power grid core service data object set;
the power grid core service data object is an atomic and non-detachable service data object.
The method for determining the power grid core service data object set can be implemented in various ways, such as extraction and identification of each power grid system, or input by experts.
Each core service data object in the power grid core service data object set comprises information such as definition, attributes, relationships, coding rules, affiliated service departments, data sources and the like.
The core service data objects in the power grid core service data object set respectively belong to each topic domain in the power grid, and the topic domains in the power grid comprise: personnel, finance, materials, projects, power grids, assets, customers, markets, security, integration, and the like.
And core service data objects which belong to two or more than two theme domains simultaneously in the power grid core service data object set are cross-professional service data objects.
S102: respectively establishing a mapping relation between an entity in an IEC CIM model and a corresponding core service data object in a power grid core service data object set, a mapping relation between an entity in an SG-ERP model and a corresponding core service data object in a power grid core service data object set, and a mapping relation between an entity in an SG-CIM3.0 model and a corresponding core service data object in a power grid core service data object set to obtain a logic model of each topic domain in a power grid, wherein each topic domain comprises a plurality of logic models corresponding to the core service data objects;
the IEC CIM model conforms to the International IEC 61970/61968/62325 standard.
Specifically, according to the IEC CIM model and the power grid core service data object set, determining a core service data object corresponding to an entity in the IEC CIM model in the power grid core service data object set, and obtaining a first core service data object set;
establishing a mapping relation between an entity in the IEC CIM model and each core service data object in the first core service data object set to obtain a logic model of each core service data object in the first core service data object set;
determining a core service data object corresponding to an entity in the SG-ERP model in the power grid core service data object set according to the SG-ERP model and the power grid core service data object set to obtain a second core service data object set;
establishing a mapping relation between an entity in the SG-ERP model and each core service data object in the second core service data object set to obtain a logic model of each core service data object in the second core service data object set;
determining a core service data object corresponding to an entity in the SG-CIM3.0 model in the power grid core service data object set according to the SG-CIM3.0 model and the power grid core service data object set to obtain a third core service data object set;
establishing a mapping relation between an entity in the SG-CIM3.0 model and each core service data object in the third core service data object set to obtain a logic model of each core service data object in the third core service data object set;
and acquiring the logic model of each theme domain according to the logic model of each core service data object in the power grid core service data object set and the theme domain to which each core service data object belongs.
It should be noted that, the mapping relationship between the entity in the IEC CIM model and each core service data object in the first core service data object set, the mapping relationship between the entity in the SG-ERP model and each core service data object in the second core service data object set, and the mapping relationship between the entity in the SG-CIM3.0 model and each core service data object in the third core service data object set may be established sequentially, without limiting the execution sequence, or may be executed in parallel.
It should be noted that a core service data object to be completed, which does not belong to the first core service data object set, does not belong to the second core service data object set, and does not belong to the third core service data object set, may also exist in the power grid core service data object set, and in this case, a logical model of the core service data object to be completed needs to be created.
The method for creating the logic model of the core service data object to be perfected comprises the following steps:
judging whether an entity of the same type as the core service data object to be completed exists in the entity of which the logic model is obtained;
if the core service data object to be perfected exists, creating a target class of an entity in the logic model of the core service data object to be perfected, wherein the target class inherits the class of the entity with the same type as the core service data object to be perfected;
if not, creating a target class of an entity in the logic model of the core service data object to be perfected;
adding attributes and relations to the entity corresponding to the core service data object to be completed, wherein the entity, the attributes and the relations corresponding to the core service data object to be completed form a logic model of the core service data object to be completed.
That is, the logical model of each core business data object consists of entities, attributes, and relationships.
S103: integrating the logic model of each subject domain according to the cross-professional service data object in the power grid core service data object to obtain a standardized logic model of a power grid unified data model;
the process of integrating the logical model for each topic domain includes: and carrying out standardization, unified semantics, duplicate removal, merging, integration and splitting on the logic model of each topic domain to form a set of unified SG-CIM4.0 logic model.
The logic model integration needs to follow the following principles:
①, establishing a mapping relation, aiming at the cross-professional business data objects without cross management, determining the association relation between the cross-domain entities by combining the association relation of the cross-professional business data objects;
② splitting and merging data table object, aiming at the same core service data object managed by different subject domains, the first design mode divides the core service data object into different entities to manage according to the management requirement of the subject domains, the second design mode belongs the management right of the core service data object to a certain subject domain and merges the attributes of other domains.
Preferably, the conceptual model can be reversely created according to the integrated logic model, so that different business functions and business scenes in the model can be traced conveniently.
S104: and creating a physical data model of the unified power grid data model based on the standardized logic model.
Specifically, the entities, attributes and relationships in the standardized logical model are converted into data tables, fields, main foreign keys and association relationships in a physical data model;
dividing data tables in the physical data model into a replication table, a random distribution table, a Hash distribution table, a temporary table and a nocopies table according to the type of a preset database, and realizing the optimal design of a database table;
converting the field type in the data table in the physical data model into the data type supported by the preset database;
generating a library building script according to the division result of the data table in the physical data model and the converted data type;
and operating the database establishing script to complete the establishment of the physical data model of the power grid unified data model.
After the power grid unified data model is established, application scene requirements such as operation, distribution and dispatching integration, asset life, project overall process, power supply service command and the like and actual database environments are combined, the physical data model can be deployed and implemented, data integration and scene application inspection are carried out, and the applicability of the power grid unified data model is verified.
The power grid unified data model is the core of national power grid enterprise informatization, and the construction of the power grid unified data model is not completed at once, and a long-term iterative perfect process is required. The power grid unified data model needs to be continuously subjected to iterative improvement and adaptive adjustment aiming at the power grid unified data model according to enterprise business strategic needs, business demand changes and demand feedback of comprehensive application demonstration.
Based on the method for creating a unified data model of a power grid disclosed in the foregoing embodiment, this embodiment correspondingly discloses a device for creating a unified data model of a power grid, please refer to fig. 2, which includes:
an object set determination unit 100, configured to determine an object set of power grid core service data;
a mapping relationship establishing unit 200, configured to respectively establish a mapping relationship between an entity in an IEC CIM model and a corresponding core service data object in the power grid core service data object set, a mapping relationship between an entity in an SG-ERP model and a corresponding core service data object in the power grid core service data object set, and a mapping relationship between an entity in an SG-CIM3.0 model and a corresponding core service data object in the power grid core service data object set, so as to obtain a logic model of each topic domain in the power grid, where each topic domain includes logic models corresponding to multiple core service data objects;
the logic model integration unit 300 is configured to integrate the logic model of each topic domain according to a cross-professional service data object in the power grid core service data object to obtain a standardized logic model of a power grid unified data model;
and a physical data model creating unit 400, configured to create a physical data model of the unified data model of the power grid based on the standardized logical model.
Optionally, the mapping relationship establishing unit is specifically configured to:
according to the IEC CIM model and the power grid core service data object set, determining a core service data object corresponding to an entity in the IEC CIM model in the power grid core service data object set to obtain a first core service data object set;
establishing a mapping relation between an entity in the IEC CIM model and each core service data object in the first core service data object set to obtain a logic model of each core service data object in the first core service data object set;
determining a core service data object corresponding to an entity in the SG-ERP model in the power grid core service data object set according to the SG-ERP model and the power grid core service data object set to obtain a second core service data object set;
establishing a mapping relation between an entity in the SG-ERP model and each core service data object in the second core service data object set to obtain a logic model of each core service data object in the second core service data object set;
determining a core service data object corresponding to an entity in the SG-CIM3.0 model in the power grid core service data object set according to the SG-CIM3.0 model and the power grid core service data object set to obtain a third core service data object set;
establishing a mapping relation between an entity in the SG-CIM3.0 model and each core service data object in the third core service data object set to obtain a logic model of each core service data object in the third core service data object set;
and acquiring the logic model of each theme domain according to the logic model of each core service data object in the power grid core service data object set and the theme domain to which each core service data object belongs.
Optionally, when a core service data object to be completed exists in the power grid core service data object set, and the core service data object to be completed does not belong to the first core service data object set, does not belong to the second core service data object set, and does not belong to the third core service data object set, the mapping relationship establishing unit further includes:
and the logic model perfecting subunit is used for creating a logic model of the core service data object to be perfected.
Optionally, the logic model perfecting subunit is specifically configured to:
judging whether an entity of the same type as the core service data object to be completed exists in the entity of which the logic model is obtained;
if the core service data object to be perfected exists, creating a target class of an entity in the logic model of the core service data object to be perfected, wherein the target class inherits the class of the entity with the same type as the core service data object to be perfected;
if not, creating a target class of an entity in the logic model of the core service data object to be perfected;
adding attributes and relations to the entity corresponding to the core service data object to be completed, wherein the entity, the attributes and the relations corresponding to the core service data object to be completed form a logic model of the core service data object to be completed.
Optionally, the physical data model creating unit is specifically configured to:
converting the entities, attributes and relationships in the standardized logic model into data tables, fields, main foreign keys and association relationships in a physical data model;
dividing data tables in the physical data model into a replication table, a random distribution table, a Hash distribution table, a temporary table and a nocopies table according to the type of a preset database;
converting the field type in the data table in the physical data model into the data type supported by the preset database;
generating a library building script according to the division result of the data table in the physical data model and the converted data type;
and operating the database establishing script to complete the establishment of the physical data model of the power grid unified data model.
The device for creating a unified data model of a power grid disclosed in this embodiment obtains a logical model of a power grid production service according with the IEC standard by establishing a mapping relationship between an entity in an IEC CIM model and a corresponding core service data object in a set of power grid core service data objects on the basis of determining a set of power grid core service data objects, obtains a logical model of an enterprise management service in a power grid system by establishing a mapping relationship between an entity in an SG-ERP model and a corresponding core service data object in a set of power grid core service data objects, and obtains a logical model of an existing core service by establishing a mapping relationship between an entity in an SG-CIM3.0 model and a corresponding core service data object in a set of power grid core service data objects, because the power grid production service, the enterprise management service and the existing core service basically cover the national power grid core service, and integrating the logic model of each subject domain according to the cross-professional service data object in the power grid core service data object to obtain a standardized logic model of the power grid unified data model, and on the basis, creating a physical data model of the power grid unified data model to realize data sharing and service cooperative processing among power grid systems.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
It is further noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in Random Access Memory (RAM), memory, Read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (10)
1. A method for creating a unified data model of a power grid is characterized by comprising the following steps:
determining a power grid core service data object set;
respectively establishing a mapping relation between an entity in an IEC CIM model and a corresponding core service data object in the power grid core service data object set, a mapping relation between an entity in an SG-ERP model and a corresponding core service data object in the power grid core service data object set, and a mapping relation between an entity in an SG-CIM3.0 model and a corresponding core service data object in the power grid core service data object set to obtain a logic model of each subject domain in a power grid, wherein each subject domain comprises a plurality of logic models corresponding to the core service data objects;
integrating the logic model of each subject domain according to the cross-professional service data object in the power grid core service data object to obtain a standardized logic model of a power grid unified data model;
and creating a physical data model of the unified power grid data model based on the standardized logic model.
2. The method of claim 1, wherein the establishing a mapping relationship between an entity in an IEC CIM model and a corresponding core service data object in the set of power grid core service data objects, a mapping relationship between an entity in an SG-ERP model and a corresponding core service data object in the set of power grid core service data objects, and a mapping relationship between an entity in an SG-CIM3.0 model and a corresponding core service data object in the set of power grid core service data objects, respectively, to obtain a logical model of each subject domain in the power grid comprises:
according to the IEC CIM model and the power grid core service data object set, determining a core service data object corresponding to an entity in the IEC CIM model in the power grid core service data object set to obtain a first core service data object set;
establishing a mapping relation between an entity in the IEC CIM model and each core service data object in the first core service data object set to obtain a logic model of each core service data object in the first core service data object set;
determining a core service data object corresponding to an entity in the SG-ERP model in the power grid core service data object set according to the SG-ERP model and the power grid core service data object set to obtain a second core service data object set;
establishing a mapping relation between an entity in the SG-ERP model and each core service data object in the second core service data object set to obtain a logic model of each core service data object in the second core service data object set;
determining a core service data object corresponding to an entity in the SG-CIM3.0 model in the power grid core service data object set according to the SG-CIM3.0 model and the power grid core service data object set to obtain a third core service data object set;
establishing a mapping relation between an entity in the SG-CIM3.0 model and each core service data object in the third core service data object set to obtain a logic model of each core service data object in the third core service data object set;
and acquiring the logic model of each theme domain according to the logic model of each core service data object in the power grid core service data object set and the theme domain to which each core service data object belongs.
3. The method according to claim 2, wherein when there is a core service data object to be completed in the power grid core service data object set that does not belong to the first core service data object set, does not belong to the second core service data object set, and does not belong to a third core service data object set, before the obtaining the logical model of each topic domain according to the logical model of each core service data object in the power grid core service data object set and the topic domain to which each core service data object belongs, the method further comprises:
and creating a logic model of the core service data object to be completed.
4. The method of claim 3, wherein the creating the logical model of the core business data object to be completed comprises:
judging whether an entity of the same type as the core service data object to be completed exists in the entity of which the logic model is obtained;
if the core service data object to be perfected exists, creating a target class of an entity in the logic model of the core service data object to be perfected, wherein the target class inherits the class of the entity with the same type as the core service data object to be perfected;
if not, creating a target class of an entity in the logic model of the core service data object to be perfected;
adding attributes and relations to the entity corresponding to the core service data object to be completed, wherein the entity, the attributes and the relations corresponding to the core service data object to be completed form a logic model of the core service data object to be completed.
5. The method of claim 1, wherein creating a physical data model of a unified data model of the power grid based on the standardized logical model comprises:
converting the entities, attributes and relationships in the standardized logic model into data tables, fields, main foreign keys and association relationships in a physical data model;
dividing data tables in the physical data model into a replication table, a random distribution table, a Hash distribution table, a temporary table and a nocopies table according to the type of a preset database;
converting the field type in the data table in the physical data model into the data type supported by the preset database;
generating a library building script according to the division result of the data table in the physical data model and the converted data type;
and operating the database establishing script to complete the establishment of the physical data model of the power grid unified data model.
6. An apparatus for creating a unified data model of a power grid, comprising:
the object set determining unit is used for determining a power grid core service data object set;
a mapping relation establishing unit, configured to respectively establish a mapping relation between an entity in an IEC CIM model and a corresponding core service data object in the power grid core service data object set, a mapping relation between an entity in an SG-ERP model and a corresponding core service data object in the power grid core service data object set, and a mapping relation between an entity in an SG-CIM3.0 model and a corresponding core service data object in the power grid core service data object set, so as to obtain a logic model of each topic domain in a power grid, where each topic domain includes logic models corresponding to multiple core service data objects;
the logic model integration unit is used for integrating the logic model of each subject domain according to the cross-professional service data object in the power grid core service data object to obtain a standardized logic model of a power grid unified data model;
and the physical data model creating unit is used for creating a physical data model of the unified power grid data model based on the standardized logic model.
7. The apparatus according to claim 6, wherein the mapping relationship establishing unit is specifically configured to:
according to the IEC CIM model and the power grid core service data object set, determining a core service data object corresponding to an entity in the IEC CIM model in the power grid core service data object set to obtain a first core service data object set;
establishing a mapping relation between an entity in the IEC CIM model and each core service data object in the first core service data object set to obtain a logic model of each core service data object in the first core service data object set;
determining a core service data object corresponding to an entity in the SG-ERP model in the power grid core service data object set according to the SG-ERP model and the power grid core service data object set to obtain a second core service data object set;
establishing a mapping relation between an entity in the SG-ERP model and each core service data object in the second core service data object set to obtain a logic model of each core service data object in the second core service data object set;
determining a core service data object corresponding to an entity in the SG-CIM3.0 model in the power grid core service data object set according to the SG-CIM3.0 model and the power grid core service data object set to obtain a third core service data object set;
establishing a mapping relation between an entity in the SG-CIM3.0 model and each core service data object in the third core service data object set to obtain a logic model of each core service data object in the third core service data object set;
and acquiring the logic model of each theme domain according to the logic model of each core service data object in the power grid core service data object set and the theme domain to which each core service data object belongs.
8. The apparatus according to claim 7, wherein when there is a core service data object to be completed in the power grid core service data object set that does not belong to the first core service data object set, does not belong to the second core service data object set, and does not belong to a third core service data object set, the mapping relationship establishing unit further includes:
and the logic model perfecting subunit is used for creating a logic model of the core service data object to be perfected.
9. The apparatus of claim 8, wherein the logic model perfecting subunit is specifically configured to:
judging whether an entity of the same type as the core service data object to be completed exists in the entity of which the logic model is obtained;
if the core service data object to be perfected exists, creating a target class of an entity in the logic model of the core service data object to be perfected, wherein the target class inherits the class of the entity with the same type as the core service data object to be perfected;
if not, creating a target class of an entity in the logic model of the core service data object to be perfected;
adding attributes and relations to the entity corresponding to the core service data object to be completed, wherein the entity, the attributes and the relations corresponding to the core service data object to be completed form a logic model of the core service data object to be completed.
10. The apparatus according to claim 6, wherein the physical data model creation unit is specifically configured to:
converting the entities, attributes and relationships in the standardized logic model into data tables, fields, main foreign keys and association relationships in a physical data model;
dividing data tables in the physical data model into a replication table, a random distribution table, a Hash distribution table, a temporary table and a nocopies table according to the type of a preset database;
converting the field type in the data table in the physical data model into the data type supported by the preset database;
generating a library building script according to the division result of the data table in the physical data model and the converted data type;
and operating the database establishing script to complete the establishment of the physical data model of the power grid unified data model.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911274262.6A CN111080479B (en) | 2019-12-12 | 2019-12-12 | Method and device for creating unified data model of power grid |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201911274262.6A CN111080479B (en) | 2019-12-12 | 2019-12-12 | Method and device for creating unified data model of power grid |
Publications (2)
Publication Number | Publication Date |
---|---|
CN111080479A true CN111080479A (en) | 2020-04-28 |
CN111080479B CN111080479B (en) | 2023-05-26 |
Family
ID=70314081
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201911274262.6A Active CN111080479B (en) | 2019-12-12 | 2019-12-12 | Method and device for creating unified data model of power grid |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN111080479B (en) |
Cited By (9)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112163049A (en) * | 2020-09-29 | 2021-01-01 | 北京中电普华信息技术有限公司 | Method and device for mapping business object into data entity |
CN112541711A (en) * | 2020-12-29 | 2021-03-23 | 广东电网有限责任公司广州供电局 | Model construction method and device, computer equipment and storage medium |
CN113407681A (en) * | 2021-08-18 | 2021-09-17 | 国网浙江省电力有限公司信息通信分公司 | Energy industry public data model construction method |
CN113723910A (en) * | 2021-08-05 | 2021-11-30 | 中核武汉核电运行技术股份有限公司 | Nuclear power plant parameter configuration method, device, equipment and computer readable storage medium |
CN113743885A (en) * | 2021-08-11 | 2021-12-03 | 南方电网数字电网研究院有限公司 | Construction method for enterprise-level data service access |
CN114880406A (en) * | 2022-05-05 | 2022-08-09 | 国网智能电网研究院有限公司 | Data management method and device |
CN115510159A (en) * | 2022-09-26 | 2022-12-23 | 煤炭科学研究总院有限公司 | Data sharing method and device based on coal industry theme domain and electronic equipment |
CN115952979A (en) * | 2022-12-13 | 2023-04-11 | 国家电网有限公司大数据中心 | Statistical big data logic model construction method and system based on data driving |
CN116450717A (en) * | 2023-03-14 | 2023-07-18 | 深圳市英捷软件有限公司 | Data integration method and information management system for cross-service modules |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105303292A (en) * | 2015-09-17 | 2016-02-03 | 国网北京市电力公司 | Distribution data storage method and device |
CN105335822A (en) * | 2015-10-29 | 2016-02-17 | 中国电力科学研究院 | Smart power grid unified data model modeling method for big data analysis |
CN105589886A (en) * | 2014-10-24 | 2016-05-18 | 国家电网公司 | Power network public information model construction method and power network public information model construction device |
US20170006135A1 (en) * | 2015-01-23 | 2017-01-05 | C3, Inc. | Systems, methods, and devices for an enterprise internet-of-things application development platform |
CN109558393A (en) * | 2018-11-28 | 2019-04-02 | 中国海洋石油集团有限公司 | A kind of data model construction method, device, equipment and storage medium |
CN109656912A (en) * | 2018-12-13 | 2019-04-19 | 成都四方伟业软件股份有限公司 | Data model management-control method, device and server |
-
2019
- 2019-12-12 CN CN201911274262.6A patent/CN111080479B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN105589886A (en) * | 2014-10-24 | 2016-05-18 | 国家电网公司 | Power network public information model construction method and power network public information model construction device |
US20170006135A1 (en) * | 2015-01-23 | 2017-01-05 | C3, Inc. | Systems, methods, and devices for an enterprise internet-of-things application development platform |
CN105303292A (en) * | 2015-09-17 | 2016-02-03 | 国网北京市电力公司 | Distribution data storage method and device |
CN105335822A (en) * | 2015-10-29 | 2016-02-17 | 中国电力科学研究院 | Smart power grid unified data model modeling method for big data analysis |
CN109558393A (en) * | 2018-11-28 | 2019-04-02 | 中国海洋石油集团有限公司 | A kind of data model construction method, device, equipment and storage medium |
CN109656912A (en) * | 2018-12-13 | 2019-04-19 | 成都四方伟业软件股份有限公司 | Data model management-control method, device and server |
Non-Patent Citations (6)
Title |
---|
刘汇慧;杨成月;吴丽莎;张翼英;: "面向智能电网二元复杂网络的电力统一空间信息模型" * |
刘鸿宁;孔晓昀;黄文思;李金湖;: "基于SG-CIM的企业数据库模型设计与应用" * |
周明宝;: "高校如何在优化配置教学资源中推进特色发展" * |
李毅松;杨琦;胡楠;何江;: "基于SG-CIM的电力信息通信系统监控模型" * |
江樱;王志强;戴波;刘鸿宁;: "企业级统一数据模型研究与设计" * |
邢子涯;郑少飞;王文博;魏澄宙;: "面向电网运营分析的数据存储模型的构建方法" * |
Cited By (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112163049A (en) * | 2020-09-29 | 2021-01-01 | 北京中电普华信息技术有限公司 | Method and device for mapping business object into data entity |
CN112163049B (en) * | 2020-09-29 | 2024-04-09 | 北京中电普华信息技术有限公司 | Method and device for mapping business object into data entity |
CN112541711A (en) * | 2020-12-29 | 2021-03-23 | 广东电网有限责任公司广州供电局 | Model construction method and device, computer equipment and storage medium |
CN113723910A (en) * | 2021-08-05 | 2021-11-30 | 中核武汉核电运行技术股份有限公司 | Nuclear power plant parameter configuration method, device, equipment and computer readable storage medium |
CN113743885A (en) * | 2021-08-11 | 2021-12-03 | 南方电网数字电网研究院有限公司 | Construction method for enterprise-level data service access |
CN113743885B (en) * | 2021-08-11 | 2024-04-19 | 南方电网数字电网研究院有限公司 | Construction method for enterprise-level data service access |
CN113407681A (en) * | 2021-08-18 | 2021-09-17 | 国网浙江省电力有限公司信息通信分公司 | Energy industry public data model construction method |
CN114880406B (en) * | 2022-05-05 | 2023-07-18 | 国网智能电网研究院有限公司 | Data management method and device |
CN114880406A (en) * | 2022-05-05 | 2022-08-09 | 国网智能电网研究院有限公司 | Data management method and device |
CN115510159B (en) * | 2022-09-26 | 2024-04-05 | 煤炭科学研究总院有限公司 | Data sharing method and device based on coal industry theme zone and electronic equipment |
CN115510159A (en) * | 2022-09-26 | 2022-12-23 | 煤炭科学研究总院有限公司 | Data sharing method and device based on coal industry theme domain and electronic equipment |
CN115952979A (en) * | 2022-12-13 | 2023-04-11 | 国家电网有限公司大数据中心 | Statistical big data logic model construction method and system based on data driving |
CN116450717A (en) * | 2023-03-14 | 2023-07-18 | 深圳市英捷软件有限公司 | Data integration method and information management system for cross-service modules |
CN116450717B (en) * | 2023-03-14 | 2023-10-20 | 深圳市英捷软件有限公司 | Data integration method and information management system for cross-service modules |
Also Published As
Publication number | Publication date |
---|---|
CN111080479B (en) | 2023-05-26 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN111080479A (en) | Method and device for establishing unified data model of power grid | |
EP3540662A1 (en) | Computer implemented method for supply chain management and provenance in a data processing network | |
US20130204847A1 (en) | Smart grid ontology update device | |
CN108520008A (en) | The construction method and construction device of data warehouse model | |
CN103929325A (en) | Organization mechanism and user right uniform control method in information system integration | |
US11782954B2 (en) | User identifier match and merge process | |
CN104881746A (en) | Platform-as-a-service Paas platform architecture in management information system | |
CN103685517A (en) | Storage hierarchical scheduling method and system based on service class characteristics | |
Meyer et al. | The Janus‐faced economy: Hong Kong firms as intermediaries between global customers and local producers in the electronics industry | |
CN108846755A (en) | A kind of right management method and device based on intelligent contract | |
CN204926097U (en) | Memory system is kept apart to data | |
Fukazawa et al. | Stabilization of neural network by combination with AR model in FastADR control of building air‐conditioner facilities | |
CN113220762A (en) | Method, device, processor and storage medium for realizing general record processing of key service field change in big data application | |
Groeneboom | Likelihood ratio type two‐sample tests for current status data | |
CN111737655A (en) | User authority management method, system and storage medium of cloud management platform | |
Wei et al. | Design and Implementation of Hotel Room Management System | |
Al Sadawi et al. | Blockchain-based carbon trading mechanism to elevate governance and smartness | |
CN115543428A (en) | Simulated data generation method and device based on strategy template | |
CN111026705B (en) | Building engineering file management method, system and terminal equipment | |
CN115270947A (en) | Standardized energy efficiency service model construction method, system, terminal and storage medium | |
CN114065254A (en) | Data processing method, device, electronic equipment, medium and product | |
CN111143322A (en) | Data standard treatment system and method | |
CN105488383A (en) | Permission management method and system | |
CN110060128B (en) | Data management method and system | |
CN104966025A (en) | Data isolated storage method and system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant |