CN104657443A - XML (extensive markup language) native database-based hybrid access method for power network data model - Google Patents
XML (extensive markup language) native database-based hybrid access method for power network data model Download PDFInfo
- Publication number
- CN104657443A CN104657443A CN201510058697.2A CN201510058697A CN104657443A CN 104657443 A CN104657443 A CN 104657443A CN 201510058697 A CN201510058697 A CN 201510058697A CN 104657443 A CN104657443 A CN 104657443A
- Authority
- CN
- China
- Prior art keywords
- xml
- database
- network data
- name
- field 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.)
- Pending
Links
- 238000013499 data model Methods 0.000 title claims abstract description 43
- 238000000034 method Methods 0.000 title claims abstract description 23
- 238000005194 fractionation Methods 0.000 claims description 3
- 238000003860 storage Methods 0.000 abstract description 12
- 238000006243 chemical reaction Methods 0.000 abstract description 6
- 238000005192 partition Methods 0.000 abstract 1
- 238000000354 decomposition reaction Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000013467 fragmentation Methods 0.000 description 1
- 238000006062 fragmentation reaction Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Supply And Distribution Of Alternating Current (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides an XML (extensive markup language) native database-based hybrid access method for a power network data model. The hybrid access method comprises the following steps of determining the power network data model, and dividing the power network data model into a basic data type and a complex data type; storing the basic data type by basic data type of a relational database, and storing the complex data type by XML native data type; performing multi-stage partition on the complex data type, and repeating the steps; extracting the power network data model according to a unique number. According to the XML database-based hybrid access method for the power network data model, provided by the invention, based on the object-oriented strategy, by comprehensively utilizing the advantages of the relational database and an XML format, rapid storage, query and conversion of power network data are realized.
Description
Technical field
The present invention relates to and belong to power system information technical field, be specifically related to a kind of hybrid access method of electric network data model based on XML native database.
Background technology
CIM (Common Information Model, common information model) and model data are the significant data types of power domain, describe the information such as power network topology and component parameters.Along with intelligent grid development, between system, model data exchanges day by day frequent, the electric network data of relational data library storage faces the problem of inefficiency to the conversion of XML (Extensible Markup Language, extend markup language) form electrical network exchange model data.
At present, the storage of grid model data mainly adopts relevant database, and model exchanges and then mainly adopts XML format (CIM/RDF, CIM/XSD).Relational data is conventional storage means, strict logic but there is fragmentation problem, and the reconstruction of relations efficiency between power network object and attribute is not high.Although XML format clear in structure, relation is directly perceived, and query conversion efficiency is lower.
Summary of the invention
In order to overcome above-mentioned the deficiencies in the prior art, the invention provides a kind of hybrid access method of electric network data model based on XML native database, based on OO strategy, the advantage of comprehensive utilization relevant database and XML format, realizes the quick storage of grid model data, inquiry and conversion.
In order to realize foregoing invention object, the present invention takes following technical scheme:
The invention provides a kind of hybrid access method of electric network data model based on XML native database, it is characterized in that: said method comprising the steps of:
Determine electric network data model, and described electric network data model is divided into basic data type and complex data type;
Basic data type is stored with relational database basic data type, and complex data type is stored with XML native data type;
Complex data type is carried out multistage fractionation, repeats above-mentioned steps;
Electric network data model is extracted according to unique number.
Determine described electric network data model according to IEC 61970/61968, described electric network data model is feeder line model.
When basic data type and complex data type store, need to be stored in the unique number in electric network data model.
Complex data type is stored in the XML Body field of relation database table with XML native data type.
Described relation database table comprises database isolating switch table, database switch list, database plant stand table, database AC line table and database fuse table.
In each database table, basic data type and complex data type are stored as String basic data type and XML native data type respectively.
In described database isolating switch table, field name mRID represents that isolating switch identifies, and field name name represents isolating switch title, and field name aliasName represents isolating switch alias name, and field name XML Body represents isolating switch details.
In described database switch list, field name mRID represents switch mark, and field name name represents switch names, and field name aliasName represents switch alias name, and field name XML Body represents switch details.
In described database plant stand table, field name mRID represents that plant stand identifies, and field name name represents plant stand title, and field name aliasName represents product station alias name, and field name XML Body represents plant stand details.
In described database AC line table, field name mRID represents that AC line identifies, and field name name represents AC line title, and field name aliasName represents AC line alias name, and field name XML Body represents AC line details.
In described database fuse table, field name mRID represents that fuse identifies, and field name name represents fuse title, and field name aliasName represents fuse alias name, and field name XML Body represents fuse details.
Compared with prior art, beneficial effect of the present invention is:
The present invention take power network object as storage unit, and conventional determinant attribute is as the field of relation database table, and the XML part of power network object is then direct stored in XML field.This hybrid storage means combines the advantage of relevant database and XML format, make use of the fast query advantage of relational database on the one hand, on the other hand power network object is directly saved as XML, compared with carrying out storage mode with traditional being broken by data model, improve the decomposition of grid model data and assembled efficiency, effectively can promote model data inquiry and the conversion efficiency of application system.
Accompanying drawing explanation
Fig. 1 is feeder line model structure figure in the embodiment of the present invention.
Embodiment
Below in conjunction with accompanying drawing, the present invention is described in further detail.
The present invention proposes the hybrid storage means of electric network data model based on XML native database: take power network object as storage unit, and conventional determinant attribute is as the field of relation database table, and the XML part of power network object is then direct stored in XML field.This hybrid storage means combines the advantage of relevant database and XML format, make use of the fast query advantage of relational database on the one hand, on the other hand power network object is directly saved as XML, compared with carrying out storage mode with traditional being broken by data model, improve the decomposition of grid model data and assembled efficiency, effectively can promote model data inquiry and the conversion efficiency of application system.
Grid model data is widely used in power system information construction, and when electrical production needs to carry out exchanges data between business, model data, as connection object, is carried out reading and storing, and then completed power business stream between business.Now for distribution feeder, introduce and how to utilize relational database and the primary mixed mode of XML to carry out data storage electric network model.
The invention provides a kind of hybrid access method of electric network data model based on XML native database, it is characterized in that: said method comprising the steps of:
Determine electric network data model, and described electric network data model is divided into basic data type and complex data type;
Basic data type is stored with relational database basic data type, and complex data type is stored with XML native data type;
Complex data type is carried out multistage fractionation, repeats above-mentioned steps;
Electric network data model is extracted according to unique number.
Determine described electric network data model according to IEC 61970/61968, described electric network data model is feeder line model (as Fig. 1).
When basic data type and complex data type store, need to be stored in the unique number in electric network data model.
Complex data type is stored in the XML Body field of relation database table with XML native data type.Relational database feeder line table is as table 1:
Table 1
| Field name | Type | Remarks |
| mRID | String | Feeder line identifies |
| name | String | Feeder line title |
| aliasName | String | Feeder line alias name |
| breaker | XML | Isolating switch details belonging to feeder line |
| switch | XML | Switch details belonging to feeder line |
| Substation | XML | Plant stand details belonging to feeder line |
| ACLineSegment | XML | Alternating current circuit details belonging to feeder line |
| Fuse | XML | Fuse details belonging to feeder line |
| …… | XML | Other details belonging to feeder line |
Described relation database table comprises database isolating switch table, database switch list, database plant stand table, database AC line table and database fuse table.
In each database table, basic data type and complex data type are stored as String basic data type and XML native data type respectively.
In described database isolating switch table, field name mRID represents that isolating switch identifies, and field name name represents isolating switch title, and field name aliasName represents isolating switch alias name, and field name XML Body represents isolating switch details.As table 2:
Table 2
| Field name | Type | Remarks |
| mRID | String | Isolating switch identifies |
| name | String | Isolating switch title |
| aliasName | String | Isolating switch alias name |
| XMLBody | XML | Isolating switch details |
In described database switch list, field name mRID represents switch mark, and field name name represents switch names, and field name aliasName represents switch alias name, and field name XML Body represents switch details.As table 3:
Table 3
| Field name | Type | Remarks |
| mRID | String | Switch mark |
| name | String | Switch names |
| aliasName | String | Switch alias name |
| XMLBody | XML | Switch details |
In described database plant stand table, field name mRID represents that plant stand identifies, and field name name represents plant stand title, and field name aliasName represents product station alias name, and field name XML Body represents plant stand details.As table 4:
Table 4
| Field name | Type | Remarks |
| mRID | String | Plant stand identifies |
| name | String | Plant stand title |
| aliasName | String | Plant stand alias name |
| XMLBody | XML | Plant stand details |
In described database AC line table, field name mRID represents that AC line identifies, and field name name represents AC line title, and field name aliasName represents AC line alias name, and field name XML Body represents AC line details.As table 5:
Table 5
| Field name | Type | Remarks |
| mRID | String | AC line identifies |
| name | String | AC line title |
| aliasName | String | AC line alias name |
| XMLBody | XML | AC line details |
In described database fuse table, field name mRID represents that fuse identifies, and field name name represents fuse title, and field name aliasName represents fuse alias name, and field name XML Body represents fuse details.As table 6:
Table 6
| Field name | Type | Remarks |
| mRID | String | Fuse identifies |
| name | String | Fuse title |
| aliasName | String | Fuse alias name |
| XMLBody | XML | Fuse details |
Finally should be noted that: above embodiment is only in order to illustrate that technical scheme of the present invention is not intended to limit; those of ordinary skill in the field still can modify to the specific embodiment of the present invention with reference to above-described embodiment or equivalent replacement; these do not depart from any amendment of spirit and scope of the invention or equivalent replacement, are all applying within the claims of the present invention awaited the reply.
Claims (11)
1., based on the hybrid access method of electric network data model of XML native database, it is characterized in that: said method comprising the steps of:
Determine electric network data model, and described electric network data model is divided into basic data type and complex data type;
Basic data type is stored with relational database basic data type, and complex data type is stored with XML native data type;
Complex data type is carried out multistage fractionation, repeats above-mentioned steps;
Electric network data model is extracted according to unique number.
2. the hybrid access method of electric network data model based on XML native database according to claim 1, it is characterized in that: determine described electric network data model according to IEC 61970/61968, described electric network data model is feeder line model.
3. the hybrid access method of electric network data model based on XML native database according to claim 1, is characterized in that: when basic data type and complex data type store, need to be stored in the unique number in electric network data model.
4. the hybrid access method of electric network data model based on XML native database according to claim 1 or 3, is characterized in that: complex data type is stored in the XML Body field of relation database table with XML native data type.
5. the hybrid access method of electric network data model based on XML native database according to claim 4, is characterized in that: described relation database table comprises database isolating switch table, database switch list, database plant stand table, database AC line table and database fuse table.
6. the hybrid access method of electric network data model based on XML native database according to claim 5, it is characterized in that: in each database table, basic data type and complex data type are stored as String basic data type and XML native data type respectively.
7. the hybrid access method of electric network data model based on XML native database according to claim 5, it is characterized in that: in described database isolating switch table, field name mRID represents that isolating switch identifies, field name name represents isolating switch title, field name aliasName represents isolating switch alias name, and field name XML Body represents isolating switch details.
8. the hybrid access method of electric network data model based on XML native database according to claim 5, it is characterized in that: in described database switch list, field name mRID represents switch mark, field name name represents switch names, field name aliasName represents switch alias name, and field name XML Body represents switch details.
9. the hybrid access method of electric network data model based on XML native database according to claim 5, it is characterized in that: in described database plant stand table, field name mRID represents that plant stand identifies, field name name represents plant stand title, field name aliasName represents product station alias name, and field name XML Body represents plant stand details.
10. the hybrid access method of electric network data model based on XML native database according to claim 5, it is characterized in that: in described database AC line table, field name mRID represents that AC line identifies, field name name represents AC line title, field name aliasName represents AC line alias name, and field name XML Body represents AC line details.
The 11. hybrid access methods of electric network data model based on XML native database according to claim 5, it is characterized in that: in described database fuse table, field name mRID represents that fuse identifies, field name name represents fuse title, field name aliasName represents fuse alias name, and field name XML Body represents fuse details.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510058697.2A CN104657443A (en) | 2015-02-04 | 2015-02-04 | XML (extensive markup language) native database-based hybrid access method for power network data model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510058697.2A CN104657443A (en) | 2015-02-04 | 2015-02-04 | XML (extensive markup language) native database-based hybrid access method for power network data model |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104657443A true CN104657443A (en) | 2015-05-27 |
Family
ID=53248571
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510058697.2A Pending CN104657443A (en) | 2015-02-04 | 2015-02-04 | XML (extensive markup language) native database-based hybrid access method for power network data model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104657443A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106874498A (en) * | 2017-02-24 | 2017-06-20 | 深圳国泰安教育技术股份有限公司 | The access method and access device of a kind of finance data |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1622095A (en) * | 2004-12-27 | 2005-06-01 | 中国科学院软件研究所 | Method of storing extensible markup language file and inserting relational database sheet |
| US20080320023A1 (en) * | 2005-02-03 | 2008-12-25 | Fong Joseph S P | System and method of translating a relational database into an xml document and vice versa |
| CN102169509A (en) * | 2011-05-30 | 2011-08-31 | 中铁第一勘察设计院集团有限公司 | Method for storing metro comprehensive pipeline data based on relational database and XML file |
| CN102662997A (en) * | 2012-03-15 | 2012-09-12 | 北京播思软件技术有限公司 | Method of storing XML data into relational database |
| CN102760164A (en) * | 2012-06-12 | 2012-10-31 | 上海方正数字出版技术有限公司 | Method for exchanging data between relation database management system and XML (Extensive Makeup Language) database management system |
-
2015
- 2015-02-04 CN CN201510058697.2A patent/CN104657443A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1622095A (en) * | 2004-12-27 | 2005-06-01 | 中国科学院软件研究所 | Method of storing extensible markup language file and inserting relational database sheet |
| US20080320023A1 (en) * | 2005-02-03 | 2008-12-25 | Fong Joseph S P | System and method of translating a relational database into an xml document and vice versa |
| CN102169509A (en) * | 2011-05-30 | 2011-08-31 | 中铁第一勘察设计院集团有限公司 | Method for storing metro comprehensive pipeline data based on relational database and XML file |
| CN102662997A (en) * | 2012-03-15 | 2012-09-12 | 北京播思软件技术有限公司 | Method of storing XML data into relational database |
| CN102760164A (en) * | 2012-06-12 | 2012-10-31 | 上海方正数字出版技术有限公司 | Method for exchanging data between relation database management system and XML (Extensive Makeup Language) database management system |
Non-Patent Citations (1)
| Title |
|---|
| 周博曦等: "基于CIM的变电站与配电馈线一次接线图自动绘制算法", 《电力系统自动化》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106874498A (en) * | 2017-02-24 | 2017-06-20 | 深圳国泰安教育技术股份有限公司 | The access method and access device of a kind of finance data |
| CN106874498B (en) * | 2017-02-24 | 2020-03-24 | 深圳国泰安教育技术有限公司 | Financial data access method and access device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108170847B (en) | Big data storage method based on Neo4j graph database | |
| CN102750406B (en) | Multi-version management method for model set and difference model-based power grid model | |
| CN102693129B (en) | The model conversion method of IEC61850 to 61970 and device | |
| CN107657019B (en) | Network topology structure obtaining method and system of power grid system | |
| CN109327323B (en) | New energy grid-connected power communication network planning and optimizing method and system | |
| CN109494719B (en) | Hierarchical impedance analysis method for medium-low voltage hybrid power distribution network | |
| CN104317864A (en) | Automatic identification method of information model based on IEC61850 logical nodes | |
| CN111340327A (en) | Main and auxiliary integrated load analysis platform and implementation method thereof | |
| CN106599293A (en) | CIM XML power grid model used for integrated dispatching and distribution system | |
| CN102403718A (en) | Generating method for power grid topological relationship based on Arcgis | |
| CN113849944A (en) | Power grid topology service method, device and system based on graph data model | |
| CN104077395B (en) | A kind of method that electric system equivalent predigesting regenerates memory bank index | |
| CN104657443A (en) | XML (extensive markup language) native database-based hybrid access method for power network data model | |
| He et al. | Research on AC & DC hybrid power supply system with high‐proportion renewable energy of data centre | |
| CN102880988B (en) | Transformer station model introduction method and device based on topology comparison | |
| CN108287936B (en) | Electromagnetic transient model of traction power supply system | |
| CN104735172A (en) | Protocol conversion method of intelligent electricity using information collecting terminal | |
| CN115375084B (en) | Graph database construction method and system based on power data | |
| CN102760194B (en) | Method and system for combining common information models (CIMs) of transformer substations and master scheduling station | |
| CN202268746U (en) | Micro-grid telemechanical communication unit | |
| Wang et al. | A new load survey method and its application in component based load modeling | |
| CN107480109A (en) | The incomplete Parallel Implementation method of state estimation based on network structure dynamic partition | |
| CN102509161A (en) | Line loss four-Ins management system and partial pressure, bus and main modified line loss construction method therefor | |
| CN205081317U (en) | Go into wall formula smart jack | |
| CN206362850U (en) | A kind of sample circuit of circuit of power factor correction |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| ASS | Succession or assignment of patent right |
Owner name: CHINA ELECTRIC POWER RESEARCH INSTITUTE STATE GRID Free format text: FORMER OWNER: CHINA ELECTRIC POWER RESEARCH INSTITUTE SHENYANG POWER SUPPLY COMPANY, STATE GRID LIAONING ELECTRIC POWER CO., LTD. Effective date: 20150505 |
|
| C41 | Transfer of patent application or patent right or utility model | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20150505 Address after: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant after: State Grid Corporation of China Applicant after: China Electric Power Research Institute Applicant after: State Grid Shandong Electric Power Company Applicant after: Shenyang Power Supply Company of State Grid Liaoning Electric Power Co., Ltd. Address before: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant before: State Grid Corporation of China Applicant before: China Electric Power Research Institute Applicant before: Shenyang Power Supply Company of State Grid Liaoning Electric Power Co., Ltd. |
|
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150527 |
|
| RJ01 | Rejection of invention patent application after publication |