Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Method for converting and importing CC2000 model into D5000 system

A model conversion and model technology, which is applied in the field of CC2000 model conversion and import into D5000 system, can solve the problems of slow data import/export and low description efficiency, and achieve the effect of wide data input range, easy application, and simple and clear process

Active Publication Date: 2013-04-03
CHINA ELECTRIC POWER RES INST +1
View PDF3 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0011] Due to some problems in the CIM / XML language, such as low description efficiency, slow data import / export speed, etc., on the basis of inheriting the advantages of the XML language, a new and efficient power system data model description language has been produced—— E language

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method for converting and importing CC2000 model into D5000 system
  • Method for converting and importing CC2000 model into D5000 system
  • Method for converting and importing CC2000 model into D5000 system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0064] A method for converting a CC2000 exported model into a D5000 system, including the following:

[0065] (1) This method establishes a connection bridge between the model data exported by CC2000 and the D5000 system, and performs parsing and preprocessing operations on the XML data, and uses the Microsoft Office Access database tool to form an Excel electronic file for the processed XML file. Then modify the generated electronic table according to the library table structure exported by D5000, and finally import the model data into the D5000 relational library with the help of the data migration tool DTS;

[0066] (2) The detailed workflow of this method is:

[0067] (1) The five-level naming is added to the CC2000 model XML format file, because the data item reflecting the model data relationship is not a complete XML start tag and end tag format, and needs to be uniformly processed into a data format format, which can be used for unified search and replacement In addit...

Embodiment 2

[0084] A method for CC2000 export model conversion import D5000 system, characterized in that it includes the following content:

[0085] (1) The method of CC2000 export model conversion and import into D5000 system is mainly composed of the following modules: XML data parsing and preprocessing module, importing Access to form Excel table module, D5000 system exporting database table structure module, modifying and forming Excel table module and Import model data into D5000 relational library module:

[0086] Parsing and preprocessing module for XML data

[0087] The five-level naming is added to CC2000 model XML format file, because the data item reflecting the model data relationship is not a complete format of XML start tag and end tag, and needs to be processed into a format of complete data form in a unified way, and the method of unified search and replacement can be used. In addition, the mRID of CC2000 is in the form of letters and numbers, and a LONG data item in the...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a method for converting and importing a CC2000 model into a D5000 system. The method comprises the following steps: (1), pretreating XML-format documents of the CC2000 model; (2), importing treated XML documents into Office Access to form data with the form of Excel spreadsheet; (3), exporting data and table structures in a relation database EMS of D5000; (4), copying Excel-format data exported by the CC2000 to a table and a field corresponding to Excel, reflecting the table structure and exported by the D 5000 according to a corresponding field of the table; (5), adding and calculating in Excel to generate an ID; (6), adding temporary fields to blank field in Excel, which are required to be nonblank fields by the D 5000; and (7), importing an Excel form of model data into the D5000. According to the method for converting and importing the CC2000 model into the D5000 system, analysis and pretreatment are performed to XML data, the treated XML documents are formed into an Excel spreadsheet by means of the database tool of Microsoft Office Access, then the generated spreadsheet is corrected according to the table structure exported by the D5000, and the model data is imported into the relation database of the D5000 by means of the data migration tool DTS (Data Transformation Services).

Description

technical field [0001] The invention belongs to the technical field of electric power automation, and in particular relates to a method for converting a CC2000 model into a D5000 system. Background technique [0002] Traditional power monitoring systems and information systems establish independent information models according to their specific needs. When different systems exchange information, the models need to be translated or converted, such as the model mismatch between system A and system B. , then when performing data exchange between system A and system B, after the data of system A arrives at system B, system B must first convert the data model of system A into its corresponding model, and then transfer the data to the system in B. If there are more than two systems that need information exchange, information sharing between different systems requires a lot of model translation or transformation, resulting in waste of resources. Therefore, the International Elect...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 袁荣昌李立新李强狄方春张大鹏花静
Owner CHINA ELECTRIC POWER RES INST
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products