CN102063509A - Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system - Google Patents
Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system Download PDFInfo
- Publication number
- CN102063509A CN102063509A CN 201110005486 CN201110005486A CN102063509A CN 102063509 A CN102063509 A CN 102063509A CN 201110005486 CN201110005486 CN 201110005486 CN 201110005486 A CN201110005486 A CN 201110005486A CN 102063509 A CN102063509 A CN 102063509A
- Authority
- CN
- China
- Prior art keywords
- container
- data
- attribute
- model
- name
- 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
- 238000000034 method Methods 0.000 title claims abstract description 54
- 230000010354 integration Effects 0.000 title abstract description 6
- 238000013507 mapping Methods 0.000 claims abstract description 41
- 238000007726 management method Methods 0.000 claims description 10
- 238000005259 measurement Methods 0.000 claims description 9
- 238000009795 derivation Methods 0.000 claims description 6
- 238000013499 data model Methods 0.000 claims description 2
- 238000000605 extraction Methods 0.000 claims description 2
- 238000009472 formulation Methods 0.000 claims 1
- 239000000203 mixture Substances 0.000 claims 1
- 238000012423 maintenance Methods 0.000 abstract description 13
- 238000011161 development Methods 0.000 abstract description 3
- 238000004458 analytical method Methods 0.000 description 3
- 238000013459 approach Methods 0.000 description 2
- 238000010276 construction Methods 0.000 description 2
- 238000007796 conventional method Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 230000008676 import Effects 0.000 description 2
- 238000013519 translation Methods 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000002950 deficient Effects 0.000 description 1
- 230000004069 differentiation Effects 0.000 description 1
- 239000006185 dispersion Substances 0.000 description 1
- 238000006317 isomerization reaction Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 238000003786 synthesis reaction Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a model and modeling method of the multi-dimensional data integration of heterogeneous databases of an electric power information system. The modeling method comprises the following steps of: (a) establishing a basic container hierarchical structure, predefining a template for each container, i.e. standardizing the problem of loading objects during the actualization of the containers according to the type of the containers, classifying the abstract containers into a plurality of types, and modeling by utilizing the container templates and the hierarchical relational structure thereof; (b) establishing a uniform and standardized common naming method for managing heterogeneous object models of the electric power information system so that a private object of each data source can be reduced to a same common object; (c) loading the common object to private object mapping relationship, establishing common object information, private object information of the heterogeneous databases and the mapping relationship of the common object information and the private object information of the heterogeneous databases through XML (Extensive Makeup Language) description files which are derived by the data sources and contain common names, and loading the objects and the mapping relationship thereof into a hierarchical container model established in the step (a). The invention reduces the complexity and the cost of the data integration without secondary development and maintenance.
Description
Technical field
The present invention relates to the integrated technology of power information system database, especially special, relate to integrated model and the modeling method of a kind of power information system heterogeneous database various dimensions, by making up the intelligent mapping model of this method, with the model and the data integration of each power information system.Thereby realize providing a unified common data platform to electric power enterprise.
Background technology
The infosystem of a new generation's electric power enterprise need be considered the safe operation in the Power Market and the requirement of commercial operation.The basis of its application is common data platform of structure; surely arrange management system, technical support system for power market, Fault Management System, equipment monitoring system, water to transfer automated system, scheduling MIS and lightning location system etc. to unify interconnection SCADA/EMS/DTS, electric energy metering system, relay protection, automatic safety device and intelligence, realize that the height of data and resource is shared.
Automation system for the power network dispatching is the real time data source of other non real-time system.Especially in Power Market, need offer a large amount of real-time and historical network load data of each decision-making and management system.Simultaneously, automation system for the power network dispatching also needs to come from the supplementary of other facilities and administration systems as the main system of power system monitor and management, makes analysis-by-synthesis and judgement.On the other hand, raising along with grid automation level, for the quantity of information of an equipment have the data of a plurality of measurement systems, as telemechanical multi-source data, wide area measurement data, high-density acquisition time series data etc., power network dispatching system also must be selected the data in different system source as requested.Therefore, must need mutual platform between each system.
At present, prefecture-level and above network system has all been set up several power information systems that comprise power network dispatching system.Have following difficult point alternately between these systems: the measuring point of (1) each system is different with the equipment name, electric network model there are differences; (2) each system interface language difference of having the data of different types model, data being handled; (3) different, the memory location dispersion of each system database running environment.On logic and space, form the isomery infosystem thus.
Existing data demonstration, though now a lot of relevant for the integrated approach of electric power dispatching system uniform data platform,, have certain defective.Reason is as follows:
Application model unitized aspect, existing method is to build a maximum as far as possible common model system, it has contained all application models of existing system.But the method for this one-time construction large-sized model system has been brought the problem of complicacy and extendability.The too complicated retardation that loads and handle on calculating that brought of model, the large-sized model of having built well simultaneously only is suitable for the integrated of existing system, needs when integrated as new application system, and this common model is difficult to expansion.
Device object unitized aspect, because the construction difference in period of each professional system, the name differentiation of device object is very big, rule can not be unified, existing method is to set up an equipment name table for each system, call when the data query, but can't embody in each system common relevance like this same physical equipment.Each database lacks the unified object naming and the formatted file of model description.
In view of existing method can not fine processing power information system heterogeneous database multidimensional data modeling problem when integrated, thereby press for a kind of administrative model of new common object, this integrated management model adopts the flexible modeling technique of easily expansion and the common equipment object factory method of standard, can take into full account the isomerism of different pieces of information system, obtain than conventional method more comprehensive consistent and electric network model and more efficient unified data platform more convenient maintenance.
Summary of the invention
The present invention seeks to: in order to solve the complicacy that a plurality of databases of existing power infosystem exist when integrated and the problem of extendability, a kind of new integrated modeling method of power information system heterogeneous database multidimensional data has been proposed, adopt a kind of new intelligent mapping model, by flexibly towards the abstract modeling of container, common equipment object naming safeguard, the main method of each data source multidimensional data Object Management group, solved the model and the object unified management problem of the multidimensional data of different isomerization data system.
Technical scheme of the present invention is: a kind of power information system heterogeneous database multidimensional data integrated intelligent mapping model and modeling method of being used for.In this model, comprised following information: public power model information, public power object information, each heterogeneous database private object information, the mapping relations from the private object to the common object.Model is in the middle layer of integrated power information system common data platform, and it provides the interface service of device object information translation between public model, various dimension to upper layer application; Simultaneously as core metadata, instruct to down and each heterogeneous data source carry out alternately, obtain the information such as model, device object, data structure of each database.
Technical scheme of the present invention is: a kind of integrated mould of power information system heterogeneous database multidimensional data that is used for newly reaches modeling method, has comprised following content:
A) by based on abstract container level model, conclude each isomery infosystem application model, create a kind of laminated vessel structure, be used to load the common information model of electric system; This model can define any container and be used to load corresponding any object, and the hierarchical relationship between its container also can dispose arbitrarily and expand.So just guaranteed the dirigibility of this modeling based on abstract container, and under the condition of not considering database volume, its extensibility can be unlimited.Any container of system definition loads corresponding any object, and the hierarchical relationship between its container also is configuration arbitrarily and expands.
But abstract container model is a kind of hierarchical data model of self-contained infinite expanding wherein, comprises following data structure:
Each attribute definition of Container (container), the definition of ContainerDescDefine (the container masterplate is described definition), and the definition of ContainerDesc (container is described attribute).
Step a) further comprises: the otherness of considering the application model of a plurality of heterogeneous systems, compatibility and extensibility that characteristics of this modeling method are its application models, whether the mode of its enforcement is by setting up the mode of concrete model, but the notion by abstract container, the relation that " comprises " in general tissue and the things is interpreted as the hypotaxis of containers at different levels, can adapts to the model of various different application.For convenience to the management of Container Type, for each container pre-defined masterplate, i.e. method by Container Type, standard load the problem of object during the container realization.Be categorized into some types with container is abstract, utilize abstract structure of container, carry out modeling:
The first step, definition container masterplate, the description attribute of this container of standard;
In second step, the container masterplate with an abstract container association has defined generates concrete container;
In the 3rd step, concrete object is loaded in the concrete container;
The 4th step defined the next stage container that this container comprises, and repeated for first to three step, realization subordinate container;
The 5th step, realization lower-level container;
Until the N step, finish N level level structure of container model; Each grade container is equipped with some grades of containers;
B) by the public naming method of unified standard and the XML description document of each data source derivation, create common object information and each heterogeneous database private object information and their mapping relations, and in the laminated vessel model of being created in being loaded into these objects and mapping relations thereof a); Step b) further comprises: the loading of finishing common object and private object information by the XML description document of analyzing the unified standard that each data source systems derives, common object information is to have extracted the object information part of each heterogeneous data source, by public naming method the private object information of each system is concluded, extract common object information, and common object information, private object information and their mapping relations are loaded into the concrete container model structure of having set up.
Wherein step b) is concluded the private object information of each system by public naming method, extract common object information, and common object information, private object information and their mapping relations are loaded into the concrete container model structure of having set up; This mapping is a kind of dynamic intelligent mapping, finishes fully automatically, and each data source systems does not need to make any change, and this modeling method is this mapping of adjustment according to intelligence after the XML file analysis of its derivation.
Wherein public naming method is to concern the association of common object to private object.Common object information is to have extracted the object information part of each heterogeneous data source, by public naming method the private object information of each system is concluded, extract common object information, and common object information, private object information and their mapping relations are loaded in the concrete container model structure of having set up;
The electric network data of unified equipment and measuring point name is integrated, and is the object resource naming rule by standard, realizes the standardization of object resource name.Mode by each data source systems object factory XML file of standard imports these object information;
The step of the mapping relations of common object information and each heterogeneous database private object information and the XML description document of derivation:
The XML model description file of the standard that each data source systems generates comprises the description with the common object of public naming method; Corresponding device comprises bus, switch, disconnecting link, circuit; Measuring point is described and is comprised active power, reactive power, electric current, voltage etc. under the equipment.These common object information will be loaded in the container, describe by the common object type definition.
This modeling method is finished the loading of common object and private object information by the XML description document of the unified standard analyzing each data source systems and derive, is filled in the structure of container and sets up and shine upon.This mapping is a kind of dynamic intelligent mapping, finishes fully automatically, and each data source systems does not need to make any change, according to this mapping of adjustment of intelligence after the XML file analysis of its derivation.This model has comprised following information: public power model information, public power object information, each heterogeneous database private object information, the mapping relations from common object to many private objects.Model is in the middle layer of integrated power information system common data platform, and it provides the interface service of device object information translation between public model, various dimension to upper layer application; Simultaneously as core metadata, instruct to down and each heterogeneous data source carry out alternately, obtain the information such as model, device object, data structure of each database.
The invention has the beneficial effects as follows: the model that this method is set up is an intelligent mapped system, owing to adopt a kind of modeling method based on abstract container, under the condition that database volume allows, its extended capability that adapts to the types of applications model almost is unlimited, it all is that modeling is finished automatically that all objects services administer and maintain work, do not need to carry out secondary development and manual maintenance, reduced the complexity and the cost price of data integration greatly.Under the information automation system of electric power enterprise of new generation need the active demand with a plurality of power information data system integrations and the unified platformization, utilize the inventive method, can set up the power information system common data platform of many isomeric datas origin system, obtain than conventional method more comprehensive consistent and electric network model and more efficient unified data platform more convenient maintenance.The required secondary development amount of this integrated modelling approach is little, and model extension is strong, the efficient height of data platform, is a kind of very practical method.
Description of drawings
The present invention is described in more detail below in conjunction with the drawings and specific embodiments.
The mapping relations of object in storage global object and each data source in Fig. 1 container
Fig. 2 container and common object adeditive attribute are described
Fig. 3 common object model and public data services
The XML of Fig. 4 common object information and private object information describes
Fig. 5 model system is safeguarded flow process automatically
Embodiment
Integrated for each heterogeneous database system of power information system of finishing convenient quick low-cost, the invention provides a kind of new intelligent mapping, modeling method, comprise following content: the automatic loading and the maintaining method of power model information (2) the common object information that (1) is public and mapping relations (3) model of each heterogeneous database private object information based on abstract container.
One, based on the common model of abstract container
Based on characteristics of the model system of abstract container be exactly its application model compatibility and extensibility, the mode of its enforcement is no longer by setting up the mode of concrete model, but the notion by abstract container, the relation that " comprises " in general tissue and the things is interpreted as the hypotaxis of containers at different levels, can set up the model of various different application, thereby have dirigibility and great extendability.
In Fig. 1, can set up a kind of three layers of structure of container (Container1, Container2, Container3 represent three layers) and represent three layers of subordinate relation flexibly, between each level DList (1:N mapping) relation.Such abstract structure can be represented the concrete model of various different meanings.For example can in Container1, store " generating plant ", storage " genset " in Container2, storage " device attribute " in Container3.So just set up a concrete hierarchical relationship model:
The generating plant-(1:N)-affiliated genset-(1:N)-the corresponding device attribute;
Perhaps
The area-(1:N)-affiliated transformer station-(1:N)-affiliated transformer;
Perhaps
Electric pressure-(1:N)-affiliated bus-(1:N)-affiliated voltage measured value;
Perhaps
Circuit-(1:N)-affiliated two ends transformer station-(1:N)-affiliated meritorious, idle, magnitude of current measured value.
For container is added concrete feature when the modeling, for the container C ontainer of each realization, some additional characteristic attributes (RefDescAttribute) etc. are arranged all, these adeditive attributes all use unidirectional quoting to represent.Also store it in the container simultaneously and comprised the data link table (Contains_Container_i) of next stage container.
Each attribute definition of Container (container) is as follows:
| Attribute-name | Data type | Describe |
| ?name | DT_STRING | Title |
| ?alias | DT_STRING | Another name |
| ?RefDescAttribute_1 | DT_S_REF_SIM | The |
| ?RefDescAttribute_2 | DT_S_REF_SIM | The |
| ?RefDescAttribute_3 | DT_S_REF_SIM | The related attribute 3 of describing points to description the unidirectional of attribute list and quotes |
| ?RefDescAttribute_4 | DT_S_REF_SIM | The |
| ?RefObjectType | DT_S_REF_SIM | Association type, the unidirectional of point at objects type list quoted |
| ?Contains_Container_i | DT_S_DLIST | Comprise subordinate's container |
| ?Contains_Container_SourceID | DT_S_DLIST | Comprise the ID in the data source |
For convenience to the management of Container Type, for each container pre-defined masterplate, i.e. method by Container Type, standard load the problem of object during the container realization.Each container has all been stored a kind of container and has been described set of properties (ContainerDescDefine) among Fig. 2, and it has comprised a plurality of containers and has described attribute (ContainerDesc).
ContainerDescDefine (container is described definition) is defined as follows:
| Attribute-name | Data type | Describe |
| name | DT_STRING | Title |
| alias | DT_STRING | Another name |
| DContains_DescAtttibute | DT_S_DARRAY_COMP | Comprise the description attribute |
ContainerDesc (container is described attribute) is defined as follows:
| Attribute-name | Data type | Describe |
| name | DT_STRING | Title |
| ?alias | DT_STRING | Describe |
| ?attributeValue | DT_LONG | Property value |
| ?DMemberOf_DescAtttibuteDefine | DT_S_DARRAY_MATE | Belong to the description attribute definition |
For example in model " generating plant-(1:N)-affiliated genset-(1:N)-corresponding device attribute ", can define " generating plant container " earlier, be loaded into concrete generating plant, subordinate's definition " genset container " at " generating plant container " is loaded into a plurality of genset that belong to this generating plant again, and the subordinate's definition " device attribute container " at " genset container " is loaded into a plurality of device attributes that belong to this genset again.
As can be seen, this modeling method can define any container and load corresponding any object, and the hierarchical relationship between its container also can dispose arbitrarily and expand.So just guaranteed the dirigibility of this modeling based on abstract container, and under the condition of not considering database volume, its extensibility is unlimited.
Two, the mapping relations of common object information and each heterogeneous database private object information
Common object information is to have extracted the object information part of each heterogeneous data source, by public naming method the private object information of each system is concluded, extract common object information, and common object information, private object information and their mapping relations are loaded in the concrete container model structure of having set up, as shown in Figure 3.
The electric network data of unified equipment and measuring point name is integrated, and is the object resource naming rule by reasonable standard, realizes the standardization of object resource name.Mode by each data source systems object factory XML file of standard imports these object information.For example based on public naming rule:
The station class @ name of station @ of the factory electric pressure @ equipment class @ implementor name @ of area @ factory measures class @ and measures name
According to the variation of factory station class, equipment class, measurement class, it can corresponding multiple level structure of container:
Transformer station-(1:N)-corresponding device-(1:N)-affiliated measurement
The generating plant-(1:N)-affiliated genset-(1:N)-affiliated measurement
Transformer-(1:N)-each volume of transformer-(1:N)-affiliated measurement
Circuit-(1:N)-each opposite end of circuit-(1:N)-affiliated measurement
Load-(1:N)-the son load-(1:N)-affiliated measurement
Electric pressure-(1:N)-affiliated bus-(1:N)-affiliated measuring value;
……
The XML model description file of the standard that each data source systems generates as shown in Figure 4.This document has comprised the description of the common object at factory station; Corresponding device comprises bus, switch, disconnecting link, circuit; Measuring point is described and is comprised active power, reactive power, electric current, voltage etc. under the equipment.These common object information will be loaded in the container, describe by common object type definition (ObjectTypeDefine).
PubObjectTypeDefine (common object type definition) is defined as follows:
| Attribute-name | Data type | Describe |
| name | DT_STRING | Title |
| alias | DT_STRING | Another name |
| inContainer_1 | DT_BOOL | Allow the one-level container to load |
| inContainer_2 | DT_BOOL | The permission secondary containers is loaded |
| inContainer_3 | DT_BOOL | Allow three grades of containers to load |
| DContains_ObjectType | DT_S_DARRAY_COMP | Comprise object type |
Also derived the private information of each object in the XML file, among the source container ID that is loaded under the container to be comprised, shown in figure one.These information such as data type (IDType) data length (IDSize) source database (refSourceDB) etc.Can comprise a plurality of source container ID under each container.
Container_1_SourceID (one-level source container ID) is defined as follows:
| Attribute-name | Data type | Describe |
| ID | DT_OID | Object ID |
| IDType | DT_ENUM | The ID data type |
| IDSize | DT_USHORT | The ID data length |
| isChecked | DT_BOOL | Whether verify |
| invalidTimestamp | DT_STIME | The inefficacy markers |
| refSourceDB | DT_S_REF_SIM | The associated source database points to the unidirectional of SourceDB and quotes |
| MemberOf_Container_1 | DT_S_DLIST_MATE | Belong to the one-level container |
Three, model loads automatically and safeguards
The automodel maintenance system is finished the loading of common object and private object information by the XML description document of the unified standard analyzing each data source systems and derive, is filled in the structure of container and sets up and shine upon.This mapping is a kind of dynamic intelligent mapping, finishes fully automatically, and each data source systems does not need to make any change, and the automodel maintenance system is this mapping of adjustment according to intelligence after the XML file analysis of its derivation.The process of model maintenance comprises: the foundation of container and maintenance, the maintenance of mapping relations between each data source object.
By abstract structure of container described above, can do following basic modeling process, carry out the foundation and the maintenance of container:
The first step, definition container masterplate, the description attribute of this container of standard
In second step, the container masterplate with an abstract container association has defined generates concrete container
In the 3rd step, concrete object is loaded in the concrete container
The 4th step defined the next stage container that this container comprises, and repeated for first to three step, realization subordinate container
The 5th step, realization lower-level container
......
In the N step, finish N level level structure of container model
By the XML file that each data source systems is derived according to its level container model, the automodel maintenance system can carry out the maintenance of common object information and each data source private object information and their mapping relations automatically:
The first step is extracted the body part structure in first data source XML file, sets up the laminated vessel model according to its hierarchical relationship;
In second step, in the laminated vessel model of setting up, insert common object information;
In the 3rd step, the private object information attribute of extraction body part is inserted the source container ID under the container, and carry is under container;
In the 4th step, analyze the XML description document of safeguarding second data origin system;
N goes on foot, and finishes the XML description document of N data origin system.
Comprehensive above-mentioned part, system safeguards flow process as shown in Figure 5 automatically, has comprised the mapping process of setting up process, common object information and each data source private object information of model based on the level container, has finished the foundation and the maintenance of model system.
Claims (7)
1. one kind is used for the integrated model of power information system heterogeneous database multidimensional data, it is characterized in that having comprised following content: a) multi-level abstract structure of container, be used to conclude each isomery infosystem application model, and load the public information object of electric system; Notion by abstract container, the relation that " comprises " in general tissue and the things is interpreted as the hypotaxis of containers at different levels, to adapt to the model of various different application, during modeling the related a kind of container masterplate type of abstract container, just abstract container can be become a concrete container, be used to load common object, the subordinate of container can also comprise a plurality of containers simultaneously, forms multilayered structure;
B) the integrated mapping relations of object, by public naming method the private object information of each power information system is concluded, extract common object information, and common object information, private object information and their mapping relations are loaded into the concrete container model structure of having set up.
2. integrated modeling method of power information system heterogeneous database multidimensional data that is used for according to claim 1 is characterized in that having comprised following content in this modeling method:
A) create basic container floor level structure, for convenience to the management of Container Type, for each container pre-defined masterplate, i.e. method by Container Type, standard load the problem of object during the container realization; Abstract container is categorized into some types, utilizes container masterplate and their hierarchical relationship structure to carry out modeling;
B) the public naming method of the unified standard of formulation is used to manage the isomery object model of each power information system, makes the private object of each data source can conclude same common object; By public naming method the private object information of each system is concluded, integrated the electric network data of unified equipment and measuring point name, realize the standardization of object resource name;
C) load common object to the private object mapping relations, the XML description document that comprises public name by each data source derivation, create common object information and each heterogeneous database private object information and their mapping relations, and in the laminated vessel model of being created in being loaded into these objects and mapping relations thereof a).
3. a kind of integrated method of power information system heterogeneous database multidimensional data that is used for as claimed in claim 2, it is characterized in that: but wherein a) under abstract container model be a kind of hierarchical data model of self-contained infinite expanding, can define any container and load corresponding any object, and the hierarchical relationship between its container also can dispose arbitrarily and expand.So just guaranteed the dirigibility of this modeling based on abstract container, and under the condition of not considering database volume, its extensibility can be unlimited.Any container of system definition loads corresponding any object, and the hierarchical relationship between its container also is configuration arbitrarily and expands.Comprise following data structure:
Each attribute definition of SContainer (container) is as follows:
ContainerDescDefine (container is described definition) is defined as follows:
ContainerDesc (container is described attribute) is defined as follows:
4. a kind of method that is used for the integrated model of power information system heterogeneous database multidimensional data as claimed in claim 2, it is characterized in that: b wherein) under the mapping of common object information and each heterogeneous data source private object information be a kind of dynamic intelligent mapping, this mapping relations attribute common object type definition by changing the common object that container loads and a series of data fields of private object container are dynamically adjusted, each data source systems does not need to make any change, comprises following data structure:
PubObjectTypeDefine (common object type definition) is defined as follows:
Container_1_SourceID (private object container) is defined as follows:
5. a kind of integrated modeling method of power information system heterogeneous database multidimensional data that is used for as claimed in claim 2, it is characterized in that: step a) further comprises:
The first step, definition container masterplate, the description attribute of this container of standard;
In second step, the container masterplate with an abstract container association has defined generates concrete container;
In the 3rd step, concrete object is loaded in the concrete container;
The 4th step defined the next stage container that this container comprises, and repeated for first to three step, realization subordinate container;
The 5th step, realization lower-level container;
Until the N step, finish N level level structure of container model.
6. a kind of integrated modeling method of power information system heterogeneous database multidimensional data that is used for as claimed in claim 2, it is characterized in that: the public naming rule of step b) further comprises:
Rule: the regional @ station class @ name of station @ of the factory electric pressure @ equipment class @ implementor name @ of factory measures class @ and measures name
According to the variation of factory station class, equipment class, measurement class, it can corresponding multiple level structure of container,
7. a kind of integrated modeling method of power information system heterogeneous database multidimensional data that is used for as claimed in claim 2, it is characterized in that: the step c) general characteristic is the XML file of being derived according to its level container model by each data source systems, finish the loading of common object and private object information, be filled in the structure of container and set up mapping steps:
The first step: the XML model description file that each data source systems generates standard comprises: the common object information of describing with public naming method: corresponding device information comprises transformer, bus, switch, disconnecting link, circuit, load etc.; Measuring point is described and is comprised active power, reactive power, electric current, voltage etc. under the equipment.Private object information attribute: private object ID, data type, data length, source database etc.
Second step, extract the body part structure in first data source XML file, set up the laminated vessel model according to its hierarchical relationship;
The 3rd step, in the laminated vessel model of setting up, insert common object information, describe by the common object type definition;
In the 4th step, the private object information attribute of extraction body part is inserted the source container ID under the container, and carry can comprise a plurality of source container ID under each container under container;
In the 5th step, analyze the XML description document of safeguarding second data origin system;
Until the N step, finish the XML description document of N data origin system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110005486 CN102063509B (en) | 2011-01-12 | 2011-01-12 | Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110005486 CN102063509B (en) | 2011-01-12 | 2011-01-12 | Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102063509A true CN102063509A (en) | 2011-05-18 |
| CN102063509B CN102063509B (en) | 2013-07-03 |
Family
ID=43998784
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110005486 Expired - Fee Related CN102063509B (en) | 2011-01-12 | 2011-01-12 | Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102063509B (en) |
Cited By (30)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102243676A (en) * | 2011-07-13 | 2011-11-16 | 国电南瑞科技股份有限公司 | Three-level modeling method of new energy comprehensive monitoring system |
| CN102262563A (en) * | 2011-08-09 | 2011-11-30 | 南京南瑞继保电气有限公司 | Method for data interaction and modeling of dispatching subsystem |
| CN102647027A (en) * | 2012-04-25 | 2012-08-22 | 河北省电力研究院 | Method for realizing construction of power quality data exchanging interface |
| CN102750358A (en) * | 2012-06-12 | 2012-10-24 | 中国电力科学研究院 | Mapping method and system of system data model to common information model (CIM) |
| CN102760184A (en) * | 2012-06-12 | 2012-10-31 | 中国电力科学研究院 | Information interaction method for heterogeneous electric power application system |
| CN102930479A (en) * | 2012-09-13 | 2013-02-13 | 中国电力科学研究院 | Formalization method for procedure knowledge of power system and formalization system thereof |
| CN102968666A (en) * | 2012-11-02 | 2013-03-13 | 中国电力科学研究院 | Storage definition method for electric power system data holographic complete time domain management |
| CN103049820A (en) * | 2012-12-20 | 2013-04-17 | 中国电力科学研究院 | Construction method of district power supply mode of heterogeneous system |
| CN103164532A (en) * | 2013-04-07 | 2013-06-19 | 广东电网公司电力科学研究院 | Classification and partitioning extract method of power grid model data and system |
| CN103294878A (en) * | 2012-02-26 | 2013-09-11 | 杭州市电力局 | Unified modeling method of multidimensional grid models based on DMS (database management system) |
| CN103729732A (en) * | 2013-12-18 | 2014-04-16 | 国家电网公司 | Distributed energy resource information modeling and information interacting method |
| CN103995932A (en) * | 2014-05-22 | 2014-08-20 | 中国南方电网有限责任公司电网技术研究中心 | Unified modeling method adopting generalized measurement transverse association mode |
| CN104035804A (en) * | 2014-06-26 | 2014-09-10 | 北京中电普华信息技术有限公司 | Application integrating method and application integrating device |
| CN105184676A (en) * | 2015-09-17 | 2015-12-23 | 国网北京市电力公司 | Power utilization data processing method and apparatus |
| CN105335900A (en) * | 2015-11-19 | 2016-02-17 | 南方电网科学研究院有限责任公司 | Data integration processing method based on power equipment state monitoring system |
| CN105701718A (en) * | 2016-01-12 | 2016-06-22 | 国网上海市电力公司 | Transformer substation information system facing power transformation engineering |
| CN105704184A (en) * | 2014-11-28 | 2016-06-22 | 国网河南省电力公司南阳供电公司 | Power grid organization analysis system based on level framework and analysis method |
| CN106412036A (en) * | 2016-09-18 | 2017-02-15 | 国电南瑞科技股份有限公司 | Mixed multi-source data collection method applied to power dispatching automation system |
| CN106775757A (en) * | 2016-12-31 | 2017-05-31 | 惠州市蓝微新源技术有限公司 | A kind of MATLAB modeling integrated approaches of BMS |
| CN107045544A (en) * | 2017-03-14 | 2017-08-15 | 华电电力科学研究院 | A kind of method for building up of electricity power group's unit shared device information model data structure |
| CN107451188A (en) * | 2017-06-26 | 2017-12-08 | 中国电力科学研究院 | A kind of dissemination method and system of power grid regulation model data multistage combination of nodes |
| CN107545046A (en) * | 2017-08-17 | 2018-01-05 | 北京奇安信科技有限公司 | A kind of fusion method and device of multi-source heterogeneous data |
| CN109194704A (en) * | 2018-07-06 | 2019-01-11 | 广东省智能制造研究所 | A kind of end B/S three-dimensional modeling data storage method, device and storage medium |
| CN109460228A (en) * | 2018-11-05 | 2019-03-12 | 用友网络科技股份有限公司 | A kind of method and system of support distribution formula service model dynamic expansion |
| CN109947784A (en) * | 2019-02-28 | 2019-06-28 | 国网浙江省电力公司 | A kind of data virtualization system and method based on CIM model entity relationship |
| CN110012070A (en) * | 2019-03-06 | 2019-07-12 | 中国南方电网有限责任公司 | A method of the intelligent oscillograph same source data multi domain based on NameSpace |
| CN111597166A (en) * | 2020-05-15 | 2020-08-28 | 海南电网有限责任公司 | Power database model construction method and device, computer equipment and storage medium |
| CN112214483A (en) * | 2019-07-11 | 2021-01-12 | 广联达科技股份有限公司 | Method and device for analyzing, associating, storing and accessing data in urban information model |
| CN112765134A (en) * | 2020-12-29 | 2021-05-07 | 广东电网有限责任公司电力科学研究院 | Generation method and system of electric power internet of things level object model |
| CN116450609A (en) * | 2023-04-14 | 2023-07-18 | 北京友友天宇***技术有限公司 | Method and equipment for modeling on heterogeneous data source based on unified grammar |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101807816A (en) * | 2009-07-22 | 2010-08-18 | 北京科东电力控制***有限责任公司 | Realization method and system of electric power data public access service interfaces in heterogeneous environment |
| CN101866361A (en) * | 2010-06-30 | 2010-10-20 | 山东中创软件工程股份有限公司 | Heterogeneous data integration method and device |
-
2011
- 2011-01-12 CN CN 201110005486 patent/CN102063509B/en not_active Expired - Fee Related
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101807816A (en) * | 2009-07-22 | 2010-08-18 | 北京科东电力控制***有限责任公司 | Realization method and system of electric power data public access service interfaces in heterogeneous environment |
| CN101866361A (en) * | 2010-06-30 | 2010-10-20 | 山东中创软件工程股份有限公司 | Heterogeneous data integration method and device |
Non-Patent Citations (3)
| Title |
|---|
| 《电力***及其自动化学报》 20050630 叶彬等 数据仓库在电力***中的应用 全文 1－3 第17卷, 第3期 * |
| 《电力自动化设备》 20061031 谷海彤 地区电力调度数据仓库建模与数据处理 全文 1－3 第26卷, 第10期 * |
| 《计算机***应用》 20101231 喻太峰等 电力应用***数据交换平台 全文 1－3 第19卷, 第11期 * |
Cited By (41)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102243676A (en) * | 2011-07-13 | 2011-11-16 | 国电南瑞科技股份有限公司 | Three-level modeling method of new energy comprehensive monitoring system |
| CN102243676B (en) * | 2011-07-13 | 2012-12-05 | 国电南瑞科技股份有限公司 | Three-level modeling method of new energy comprehensive monitoring system |
| CN102262563B (en) * | 2011-08-09 | 2013-04-24 | 南京南瑞继保电气有限公司 | Method for data interaction and modeling of dispatching subsystem |
| CN102262563A (en) * | 2011-08-09 | 2011-11-30 | 南京南瑞继保电气有限公司 | Method for data interaction and modeling of dispatching subsystem |
| CN103294878A (en) * | 2012-02-26 | 2013-09-11 | 杭州市电力局 | Unified modeling method of multidimensional grid models based on DMS (database management system) |
| CN102647027A (en) * | 2012-04-25 | 2012-08-22 | 河北省电力研究院 | Method for realizing construction of power quality data exchanging interface |
| CN102750358A (en) * | 2012-06-12 | 2012-10-24 | 中国电力科学研究院 | Mapping method and system of system data model to common information model (CIM) |
| CN102760184A (en) * | 2012-06-12 | 2012-10-31 | 中国电力科学研究院 | Information interaction method for heterogeneous electric power application system |
| CN102760184B (en) * | 2012-06-12 | 2014-12-31 | 中国电力科学研究院 | Information interaction method for heterogeneous electric power application system |
| CN102930479A (en) * | 2012-09-13 | 2013-02-13 | 中国电力科学研究院 | Formalization method for procedure knowledge of power system and formalization system thereof |
| CN102968666A (en) * | 2012-11-02 | 2013-03-13 | 中国电力科学研究院 | Storage definition method for electric power system data holographic complete time domain management |
| CN102968666B (en) * | 2012-11-02 | 2014-03-12 | 中国电力科学研究院 | Storage definition method for electric power system data holographic complete time domain management |
| CN103049820A (en) * | 2012-12-20 | 2013-04-17 | 中国电力科学研究院 | Construction method of district power supply mode of heterogeneous system |
| CN103049820B (en) * | 2012-12-20 | 2014-10-08 | 中国电力科学研究院 | Construction method of district power supply mode of heterogeneous system |
| CN103164532A (en) * | 2013-04-07 | 2013-06-19 | 广东电网公司电力科学研究院 | Classification and partitioning extract method of power grid model data and system |
| CN103164532B (en) * | 2013-04-07 | 2015-08-12 | 广东电网有限责任公司电力科学研究院 | The classification piecemeal abstracting method of grid model data and system |
| CN103729732A (en) * | 2013-12-18 | 2014-04-16 | 国家电网公司 | Distributed energy resource information modeling and information interacting method |
| CN103995932A (en) * | 2014-05-22 | 2014-08-20 | 中国南方电网有限责任公司电网技术研究中心 | Unified modeling method adopting generalized measurement transverse association mode |
| CN104035804A (en) * | 2014-06-26 | 2014-09-10 | 北京中电普华信息技术有限公司 | Application integrating method and application integrating device |
| CN105704184A (en) * | 2014-11-28 | 2016-06-22 | 国网河南省电力公司南阳供电公司 | Power grid organization analysis system based on level framework and analysis method |
| CN105184676A (en) * | 2015-09-17 | 2015-12-23 | 国网北京市电力公司 | Power utilization data processing method and apparatus |
| CN105335900A (en) * | 2015-11-19 | 2016-02-17 | 南方电网科学研究院有限责任公司 | Data integration processing method based on power equipment state monitoring system |
| CN105701718A (en) * | 2016-01-12 | 2016-06-22 | 国网上海市电力公司 | Transformer substation information system facing power transformation engineering |
| CN106412036B (en) * | 2016-09-18 | 2019-06-25 | 国电南瑞科技股份有限公司 | A kind of mixing multi-source data acquisition method for electric power scheduling automatization system |
| CN106412036A (en) * | 2016-09-18 | 2017-02-15 | 国电南瑞科技股份有限公司 | Mixed multi-source data collection method applied to power dispatching automation system |
| CN106775757A (en) * | 2016-12-31 | 2017-05-31 | 惠州市蓝微新源技术有限公司 | A kind of MATLAB modeling integrated approaches of BMS |
| CN107045544A (en) * | 2017-03-14 | 2017-08-15 | 华电电力科学研究院 | A kind of method for building up of electricity power group's unit shared device information model data structure |
| CN107451188A (en) * | 2017-06-26 | 2017-12-08 | 中国电力科学研究院 | A kind of dissemination method and system of power grid regulation model data multistage combination of nodes |
| CN107545046B (en) * | 2017-08-17 | 2021-05-25 | 北京奇安信科技有限公司 | Fusion method and device for multi-source heterogeneous data |
| CN107545046A (en) * | 2017-08-17 | 2018-01-05 | 北京奇安信科技有限公司 | A kind of fusion method and device of multi-source heterogeneous data |
| CN109194704A (en) * | 2018-07-06 | 2019-01-11 | 广东省智能制造研究所 | A kind of end B/S three-dimensional modeling data storage method, device and storage medium |
| CN109460228A (en) * | 2018-11-05 | 2019-03-12 | 用友网络科技股份有限公司 | A kind of method and system of support distribution formula service model dynamic expansion |
| CN109947784A (en) * | 2019-02-28 | 2019-06-28 | 国网浙江省电力公司 | A kind of data virtualization system and method based on CIM model entity relationship |
| CN110012070B (en) * | 2019-03-06 | 2022-02-15 | 中国南方电网有限责任公司 | Method for applying homologous data of intelligent wave recorder in multiple domains based on name space |
| CN110012070A (en) * | 2019-03-06 | 2019-07-12 | 中国南方电网有限责任公司 | A method of the intelligent oscillograph same source data multi domain based on NameSpace |
| CN112214483A (en) * | 2019-07-11 | 2021-01-12 | 广联达科技股份有限公司 | Method and device for analyzing, associating, storing and accessing data in urban information model |
| CN111597166A (en) * | 2020-05-15 | 2020-08-28 | 海南电网有限责任公司 | Power database model construction method and device, computer equipment and storage medium |
| CN111597166B (en) * | 2020-05-15 | 2023-10-27 | 海南电网有限责任公司 | Power database model construction method, device, computer equipment and storage medium |
| CN112765134A (en) * | 2020-12-29 | 2021-05-07 | 广东电网有限责任公司电力科学研究院 | Generation method and system of electric power internet of things level object model |
| CN116450609A (en) * | 2023-04-14 | 2023-07-18 | 北京友友天宇***技术有限公司 | Method and equipment for modeling on heterogeneous data source based on unified grammar |
| CN116450609B (en) * | 2023-04-14 | 2024-01-30 | 北京友友天宇***技术有限公司 | Method and equipment for modeling on heterogeneous data source based on unified grammar |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102063509B (en) | 2013-07-03 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102063509B (en) | Model and modeling method of multi-dimensional data integration of heterogeneous databases of electric power information system | |
| CN107402976B (en) | Power grid multi-source data fusion method and system based on multi-element heterogeneous model | |
| CN101873008B (en) | Method for converting SCD (Substation Configuration Description) model into dispatching center CIM (Common Information Model) | |
| CN103440367B (en) | Transformer station's panoramic view data modeling method | |
| CN102214228B (en) | Large-grid distributed real-time database system and data management method thereof | |
| CN102262563B (en) | Method for data interaction and modeling of dispatching subsystem | |
| CN103970887A (en) | Information stream display system and method based on GIS distribution network graphs | |
| CN104504485A (en) | Integrative power system relay protection setting calculation method | |
| CN101661499A (en) | Electric power application support system and distributed real-time data center thereof | |
| CN101964542A (en) | Method for accessing IEC61970 dispatching EMS system to IEC61850 digital transformer substation | |
| CN102426525A (en) | Panoramic modeling method of multi-application system | |
| CN104967115B (en) | Distributed cluster type network topology coloring method for power system | |
| CN109272248B (en) | Comprehensive energy integration e-CIM model design method based on metadata | |
| CN104200331A (en) | Power grid model joining method and system of power system | |
| CN104778551A (en) | Designing and analyzing method of visualization grid | |
| CN104299051A (en) | Network system used for technical and economic analysis and comment of power grid project | |
| CN105743870A (en) | Design method of intelligent substation integrated business platform service interfaces | |
| CN104881739A (en) | Marketing and distribution data consistency verification method based on IEC61970-61968 CIM standard | |
| CN105740296B (en) | Intelligent substation data subscription method based on access model | |
| CN107194010B (en) | Object-oriented electricity consumption information management system and method thereof | |
| CN116826709A (en) | Automatic matching method, device and storage medium for adjustable load resource and scheduling master station model | |
| CN105574204B (en) | Retrieval method and system for distributed power grid regulation and control operation data | |
| CN102760194B (en) | Method and system for combining common information models (CIMs) of transformer substations and master scheduling station | |
| CN106845802B (en) | Historical data statistics-based power failure construction period judgment method | |
| CN104199663A (en) | Comprehensive automated information table automatic generating method and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20130703 |
|
| CF01 | Termination of patent right due to non-payment of annual fee |