CN106326488A - XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof - Google Patents
XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof Download PDFInfo
- Publication number
- CN106326488A CN106326488A CN201610808097.8A CN201610808097A CN106326488A CN 106326488 A CN106326488 A CN 106326488A CN 201610808097 A CN201610808097 A CN 201610808097A CN 106326488 A CN106326488 A CN 106326488A
- Authority
- CN
- China
- Prior art keywords
- xml
- data
- database
- schema
- processing module
- 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
- 238000000034 method Methods 0.000 title claims abstract description 29
- 230000005540 biological transmission Effects 0.000 title claims abstract description 17
- 230000009466 transformation Effects 0.000 title claims abstract description 16
- 238000012545 processing Methods 0.000 claims abstract description 35
- 238000013499 data model Methods 0.000 claims abstract description 21
- 238000013507 mapping Methods 0.000 claims abstract description 21
- 230000008569 process Effects 0.000 claims abstract description 5
- 238000011161 development Methods 0.000 abstract description 3
- 230000008901 benefit Effects 0.000 abstract description 2
- 238000013497 data interchange Methods 0.000 description 4
- 230000010354 integration Effects 0.000 description 4
- 230000006870 function Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000012544 monitoring process Methods 0.000 description 2
- 238000012795 verification Methods 0.000 description 2
- 241001269238 Data Species 0.000 description 1
- 238000004458 analytical method Methods 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 239000012141 concentrate Substances 0.000 description 1
- 230000005611 electricity Effects 0.000 description 1
- 230000007613 environmental effect Effects 0.000 description 1
- 230000036541 health Effects 0.000 description 1
- 238000009434 installation Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000013178 mathematical model Methods 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000005012 migration Effects 0.000 description 1
- 238000013508 migration Methods 0.000 description 1
- 239000000203 mixture Substances 0.000 description 1
- 238000009666 routine test Methods 0.000 description 1
- 230000009897 systematic effect Effects 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/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
- G06F16/83—Querying
-
- 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
- G06F16/84—Mapping; Conversion
Abstract
The invention discloses a XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof. The XML-based electric transmission and transformation equipment state data exchange adapter is used for building the corresponding data exchange relationship between the data of source database and that of target database through XML Schema processing, and comprises a XML-to-relational database mapping method module, a data model XML Schema processing module, a database processing module and a XML-to-target database mapping process module. The XML-based electric transmission and transformation equipment state data exchange adapter has the advantages that: through an adapter, the required data can be obtained directly from the database, as long as it is ensured that the interfaces provided by the adapter for business system call remain consistent, the adapter can adapt to different business systems; through the connection of dynamic configuration, definition implementation and application system, the users who need data do not need to face a specific database and the details of a data source, just need to tell the required data model to a data exchange center, so the development efficiency is greatly improved, the burden on the staff is reduced, and the system can easily be extended.
Description
Technical field
The present invention relates to data adapter unit technical field, refer in particular to a kind of power transmission and transformation equipment state data based on XML and hand over
Changer adapter and using method thereof.
Background technology
Powernet monitoring system run in, the Data Source of equipment state is the most varied, have from production
Management system, condition monitoring system, the system of these sing on web application often uses different development platforms and technology, it is achieved
Each the data base management system of business demand is the most different；Have dispatches from the factory report, on-the-spot routine test form etc. from equipment
Document, these scattered status datas are not only originated and are differed, and there is also the features such as classification is different, form differs, form is different.
Therefore, schedule has just been put on, by by enterprises to improve the foundation of this situation, data interchange platform and data center
The data of each application system all concentrate on data center and ask to the power transmission and transformation equipment state data integration solving multi-source heterogeneous system
Topic.
Data adapter unit is the important component part of data interchange platform, is the connection of application system and data interchange platform
The application system of device, i.e. Dispersed heterogeneous is connected with data interchange platform by adapter, so with other application system numbers
According to exchange.Adapter refers to carry out the quick and convenient modular software being connected with concrete application system, and it passes through data base
Access interface, specific api function and other application integration point, integrate the data between different operation systems and interface,
Eliminate application software produced various problems in the complex process of transmission message or calling interface.
At present, the method solving multi-source heterogeneous system data integrated has: database migration and conversion, multidatabase system,
The middleware of software vendor is integrated, set up data warehouse.But from realizing the analysis ratio of heterogeneous databases integration situation both at home and abroad
Relatively, any of the above scheme cuts both ways, and in terms of practical angle, such scheme the most not can solve problem.
Summary of the invention
The invention aims to overcome above-mentioned not enough offer a kind of power transmission and transformation equipment state data based on XML exchange
Adapter and using method thereof, compared with prior art, incorporate Demand-side, power source planning in uncertain linear programming model
And the installation problem such as dilatation, with the cost minimization of satisfied prediction electricity needs as object function, it is considered to load growth rate, system can
By founding mathematical models such as property, environmental constraints, seek preferred plan scheme.
For achieving the above object, the present invention is for processing the data of source database and target data by XML Schema
Corresponding data commutative relation is set up in storehouse, arrives the mapping method module of relevant database, data model XML Schema including XML
Processing module, database processing module and XML are to the mapping processing module of target database；Described XML is to relevant database
Mapping method module input connect with source database, the mapping method module outfan of described XML to relevant database
Connecting with input, the input of database processing module of data model XML Schema processing module respectively, described XML arrives
The input of the mapping processing module of target database respectively with input, the data of data model XML Schema processing module
The outfan connection of storehouse processing module.
The using method of a kind of power transmission and transformation equipment state data based on XML exchange adapter, it comprises the following steps:
1) select to need to carry out each source database of XML Schema data check and corresponding target database, dress
Enter list XML Schema data model, after relation schema standardization, according to the list XML Schema data model loaded
Data message is written in XML normative document；
2) the XML Schema of foundation reservation semantic constraint is to the mapping method of relevant database, will comprise isomeric data
In storehouse, the XML file of data message is sent to destination server end；
3) XML Schema is utilized to resolve, then by XML data file in the destination server of storage XML file
It is converted into the logical structure of local data base, completes the data on destination server and update.
Further, described database processing module is provided with the data base being connected and selects unit and data base directory
Signal generating unit.
Further, described XML Schema processing module is provided with the Schema loading location that is connected and
Schema catalogue signal generating unit.
As preference, between described XML Schema processing module and target database, it is provided with the catalogue joint being connected
Point map unit.
It is an advantage of the current invention that: by adapter, directly can obtain the data of needs from data base, as long as ensureing
Adapter is supplied to the interface that operation system calls and keeps consistent, it is possible to adapt to different operation systems, by dynamically configuration,
Definition realizes and the connection of application system, and need that the user of data is not required in the face of concrete database and data source is thin
Joint, it is only necessary to the data pattern that it is wanted tells data switching center, thus substantially increases development efficiency, alleviates
The burden of staff, system is also readily obtained extension.It will have wider application at the big data age of electric power.
Detailed description of the invention
A kind of power transmission and transformation equipment state data based on XML of present invention exchange adapter and using method thereof, it is used for will
The data of source database are processed by XML Schema and set up corresponding data commutative relation with target database, arrive pass including XML
It is that the mapping method module of type data base, data model XML Schema processing module, database processing module and XML are to target
The mapping processing module of data base；Described XML connects to the mapping method module input of relevant database with source database,
Described XML is to mapping method module outfan defeated with data model XML Schema processing module respectively of relevant database
Entering the input connection of end, database processing module, the input of the mapping processing module of described XML to target database is respectively
Connect with input, the outfan of database processing module of data model XML Schema processing module.At described data base
Reason module is provided with the data base being connected and selects unit and data base directory signal generating unit.Described XML Schema processes mould
Block is provided with the Schema loading location being connected and Schema catalogue signal generating unit.Described XML Schema processing module with
The directory node map unit being connected it is provided with between target database.
The using method of a kind of power transmission and transformation equipment state data based on XML exchange adapter, it comprises the following steps:
1) select to need to carry out each source database of XML Schema data check and corresponding target database, dress
Enter list XML Schema data model, after relation schema standardization, according to the list XML Schema data model loaded
Data message is written in XML normative document；
2) the XML Schema of foundation reservation semantic constraint is to the mapping method of relevant database, will comprise isomeric data
In storehouse, the XML file of data message is sent to destination server end；
3) XML Schema is utilized to resolve, then by XML data file in the destination server of storage XML file
It is converted into the logical structure of local data base, completes the data on destination server and update.
The present invention solves this problem and the technical scheme used is as follows:
XML has natural cross-platform characteristic, and XML Schema may be used for based on XML onboard data type and user
The verification of the text element of user-defined dada type, it is also possible to there is the succession concept of object oriented language, reuse one rapidly
A little conventional data forms.Therefore, from the standpoint of isomer data integration, XML and Schema verification scheme is used to solve many
The data source interaction problems of data mode.
Owing to relevant database is when setting up, its main foreign key constraint, table name etc. contain certain semantic information, in order to
Retaining these information as far as possible, we have employed the XML Schema retaining semantic constraint to the mapping side of relevant database
Method.Typically such as a tables of data of relational database, when being mapped to XML, can be expressed as a complicated type, additionally, our pin
Critical field therein is carried out special constraint.
Consideration based on the aspect such as systematic function, set expandability, whole architecture uses star-like on physical topology
Structure.In the present system, data switching center is in center, and the data between each application system exchange by XML conduct
The medium of exchange.By the data model of exchange both sides is identified, finds out the difference of both data model, then set up one
Planting changes the mechanism sets up a seamless interaction platform between data exchange both sides.This project uses XML Schema
Definition (XSD) is as data model modeling and the instrument of expression.So extract relational database pattern information be into
One necessary links of row data exchange, the physical model then extracted is changed automatically by " relation schema modular converter "
For XML model of equal value.Write object library (equipment health account) time, need again with XML Schema carry out resolve and
Load, then by deriving adapter write object library.Here the modelling of XML Schema is to write xsd literary composition according to demand
Part realizes.Data exporting adapter, the parsing of XML file and task queue etc. are real by modes such as Web Service
Existing.Process the XML file with transport layer in the case of data model change is little, it is considered to realize in same server.
Above embodiments of the invention are described, but the invention is not limited in above-mentioned specific embodiment party
Formula, above-mentioned detailed description of the invention is only schematic rather than restrictive, and those of ordinary skill in the art is at this
Under bright enlightenment, in the case of without departing from present inventive concept and scope of the claimed protection, it may also be made that a lot of form, this
Within belonging to the protection of the present invention a bit.
Claims (5)
1. power transmission and transformation equipment state data based on an XML exchange adapter, it is for passing through XML by the data of source database
Schema processes and sets up corresponding data commutative relation with target database, it is characterised in that: include that XML is to relevant database
Mapping method module, data model XML Schema processing module, database processing module and XML are to the mapping of target database
Processing module；
Described XML connects to the mapping method module input of relevant database with source database, and described XML is to relationship type number
According to storehouse mapping method module outfan respectively with input, the database processing mould of data model XML Schema processing module
Block input connection, the input of the mapping processing module of described XML to target database respectively with data model XML
The input of Schema processing module, the outfan connection of database processing module.
2. the using method of power transmission and transformation equipment state data based on an XML exchange adapter, it is characterised in that under it includes
Row step:
1) select to need to carry out each source database of XML Schema data check and corresponding target database, load table
Single XML Schema data model, after relation schema standardization, according to the list XML Schema data model loaded by number
It is believed that breath is written in XML normative document；
2) the XML Schema of foundation reservation semantic constraint is to the mapping method of relevant database, will comprise in heterogeneous database
The XML file of data message is sent to destination server end；
3) utilize XML Schema to resolve in the destination server of storage XML file, then XML data file is changed
Become the logical structure of local data base, complete the data on destination server and update.
3. exchanging adapter according to a kind of power transmission and transformation equipment state data based on XML described in claim 1, its feature exists
In: described database processing module is provided with the data base being connected and selects unit and data base directory signal generating unit.
4. exchanging adapter according to a kind of power transmission and transformation equipment state data based on XML described in claim 1, its feature exists
In: described XML Schema processing module is provided with the Schema loading location being connected and Schema catalogue signal generating unit.
5. exchanging adapter according to a kind of power transmission and transformation equipment state data based on XML described in claim 1, its feature exists
In: it is provided with, between described XML Schema processing module and target database, the directory node map unit being connected.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610808097.8A CN106326488A (en) | 2016-09-07 | 2016-09-07 | XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610808097.8A CN106326488A (en) | 2016-09-07 | 2016-09-07 | XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106326488A true CN106326488A (en) | 2017-01-11 |
Family
ID=57787656
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610808097.8A Pending CN106326488A (en) | 2016-09-07 | 2016-09-07 | XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106326488A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109582391A (en) * | 2018-12-04 | 2019-04-05 | 中国航空工业集团公司西安航空计算技术研究所 | A kind of device tree configuration method based on XML |
| CN112632185A (en) * | 2020-12-16 | 2021-04-09 | 浪潮云信息技术股份公司 | Multi-type database synchronization method, device and equipment based on CPU environment |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101593103A (en) * | 2008-05-29 | 2009-12-02 | 国际商业机器公司 | Realize the system and method for relation perdurability and semantic network style access simultaneously |
| US7926064B2 (en) * | 2003-07-11 | 2011-04-12 | Computer Associates Think, Inc. | Business transformation logic engine and handlers |
| CN102207980A (en) * | 2011-07-11 | 2011-10-05 | 东莞市盈达信息科技股份有限公司 | Data exchange method based on extensive makeup language (XML) and database (DB), and data adapter |
| CN102646039A (en) * | 2012-02-29 | 2012-08-22 | 河海大学 | Software interface generating system and method based on extensible markup language (XML) Schema |
| CN104200402A (en) * | 2014-09-11 | 2014-12-10 | 国家电网公司 | Publishing method and system of source data of multiple data sources in power grid |
-
2016
- 2016-09-07 CN CN201610808097.8A patent/CN106326488A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7926064B2 (en) * | 2003-07-11 | 2011-04-12 | Computer Associates Think, Inc. | Business transformation logic engine and handlers |
| CN101593103A (en) * | 2008-05-29 | 2009-12-02 | 国际商业机器公司 | Realize the system and method for relation perdurability and semantic network style access simultaneously |
| CN102207980A (en) * | 2011-07-11 | 2011-10-05 | 东莞市盈达信息科技股份有限公司 | Data exchange method based on extensive makeup language (XML) and database (DB), and data adapter |
| CN102646039A (en) * | 2012-02-29 | 2012-08-22 | 河海大学 | Software interface generating system and method based on extensible markup language (XML) Schema |
| CN104200402A (en) * | 2014-09-11 | 2014-12-10 | 国家电网公司 | Publishing method and system of source data of multiple data sources in power grid |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109582391A (en) * | 2018-12-04 | 2019-04-05 | 中国航空工业集团公司西安航空计算技术研究所 | A kind of device tree configuration method based on XML |
| CN109582391B (en) * | 2018-12-04 | 2022-05-24 | 中国航空工业集团公司西安航空计算技术研究所 | XML-based equipment tree configuration method |
| CN112632185A (en) * | 2020-12-16 | 2021-04-09 | 浪潮云信息技术股份公司 | Multi-type database synchronization method, device and equipment based on CPU environment |
| CN112632185B (en) * | 2020-12-16 | 2023-05-09 | 浪潮云信息技术股份公司 | Method, device and equipment for synchronizing multi-type databases based on CPU environment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2022160707A1 (en) | Human-machine interaction method and apparatus combined with rpa and ai, and storage medium and electronic device | |
| CN107256443B (en) | Line loss real-time computing technique based on business and data integration | |
| CN106296378B (en) | XBRL-based intelligent financial cloud platform system, construction method and service implementation method | |
| CN111382214B (en) | Comprehensive pipe rack operation and maintenance management system based on 3DGIS BIM | |
| US8555248B2 (en) | Business object change management using release status codes | |
| CN101388904B (en) | GIS service aggregating method, device and system | |
| CN103455540B (en) | The system and method for generating memory model from data warehouse model | |
| CN107862153A (en) | A kind of transformer station digitizes managing and control system | |
| CN104615617A (en) | Dispatch monitoring information processing system for substation equipment | |
| CN106164867A (en) | The increment parallel processing of data | |
| CN102306355A (en) | Management system for IT (Information Technology) operation and maintenance configuration | |
| CN103455591A (en) | Standard data exchange interface method of parallel cooperative system | |
| CN108860223A (en) | A kind of data processing system and method | |
| CN103295164A (en) | Power grid safety monitoring management information system and management method | |
| CN103729742A (en) | Data resource management system based on SOA framework and model drive framework | |
| CN106326488A (en) | XML-based electric transmission and transformation equipment state data exchange adapter and use method thereof | |
| CN104881739A (en) | Marketing and distribution data consistency verification method based on IEC61970-61968 CIM standard | |
| CN110033195A (en) | Adjust grid model splicing method to a kind of province based on CIM/CIS | |
| CN107067301A (en) | A kind of joint project machine and equipment leasing system | |
| CN101470734A (en) | Data identification and analyzing method and apparatus | |
| CN103377241B (en) | The method and system of power grid data integration | |
| CN115829461A (en) | Material purchasing method based on material purchasing standard full-process through | |
| CN107273219A (en) | Apparatus control method and device | |
| CN112364772A (en) | Mobile operation terminal system based on cloud platform | |
| CN106682230A (en) | Information service system based on HTML5 and CSS3 mobile display technological architecture |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20171205 Address after: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant after: State Grid Corporation of China Applicant after: State Grid Gansu Electric Power Company Applicant after: Electric Power Research Institute, State Grid Fujian Electric Power Co., Ltd. Applicant after: State Grid Fujian Electric Power Co., Ltd. Applicant after: Wuhan Nari Limited Liability Company of State Grid Electric Power Research Institute Address before: 100031 Xicheng District West Chang'an Avenue, No. 86, Beijing Applicant before: State Grid Corporation of China Applicant before: State Grid Gansu Electric Power Company Applicant before: State Grid Fujian Electric Power Co., Ltd. Applicant before: Wuhan Nari Limited Liability Company of State Grid Electric Power Research Institute |
|
| TA01 | Transfer of patent application right | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20170111 |
|
| RJ01 | Rejection of invention patent application after publication |