CN102622415A - Method for synchronous transmission of power quality monitoring data for multiple platforms - Google Patents

Abstract

The invention discloses a method for synchronous transmission of power quality monitoring data for multiple platforms, which includes the steps: firstly, determining export required data in a synchronous data resource database; secondly, calling a packet function to convert the export required data in the step 1 into data in an appointed format; thirdly, recording and outputting the data in the appointed format; fourthly, receiving the data exported from the data source database, and extracting the data; and fifthly, converting the extracted data into a data sheet, and establishing a chart about mapping relation of identifiers of corresponding data in the data source database to identifiers in an object library. By the method for synchronous transmission of power quality monitoring data for different platforms, the problem of incompatibility of the different platforms in data transmission is solved, higher efficacy and stability are achieved, system flexibility is improved, and the data are more easily understandable to third parties.

Description

A kind ofly be used for multi-platform electric energy quality monitoring data synchronization transmission method

Technical field

The present invention is a kind of multi-platform electric energy quality monitoring data synchronization transmission method that is used for, and specifically referring to derives and introduction method based on the electric energy quality monitoring data of ORACLE storing process and XML file layout, belongs to the power technology field.

Background technology

Become increasingly complex in current software systems; Constantly under the situation of breadth and depth expansion, the data interaction demand of system becomes more and more urgent to service application between the data interaction between the same system disparate modules, the data interaction between the different system, the different manufacturers.The kind and the form of these data are various; The software platform that makes up these systems is also also inequality; And along with constantly the improving of operation flow, the data layout of software systems and classification also can constantly change, thereby have further brought challenge to synchronization of data.

The electric energy quality monitoring data between different platform, carry out data transmission because data volume is big, the degree of coupling is high; Often need be along with interface is constantly revised in the expansion of business; Need do substantive test again after each the modification could stablize, but stable interface has been crossed not the modification of how long need upgrading again usually in actual use.

Therefore, seek a kind of can flexible adaptation business demand change, cross-platform, method of data synchronization that exploitation is simple, efficient, open, guarantee system reliable and stable operation, be easy to system upgrade and safeguard that its essential meaning is arranged.

Summary of the invention

Fundamental purpose of the present invention is to solve existing electric energy quality monitoring data synchronization technology to be unfavorable for that heterogeneous platform uses, development and maintenance is disposed complicated; Synchrodata source end and the too high defective of data destination interface coupling provide a kind of more advanced, simple, open, high-efficiency method realization data sync.

Realize that technical scheme of the present invention is:

A kind ofly be used for multi-platform electric energy quality monitoring data synchronization transmission method, may further comprise the steps:

1) confirms the data that needs are derived in the synchrodata source database;

2) calling the packet function, is the data of specified format with the data-switching that needs in the step 1) to derive;

3) data of record and output specified format;

4) receive the data that derive in the data source data storehouse, extract data;

5) be tables of data with the data conversion of extracting, and set up the sign of corresponding data in the data source data storehouse and the mapping relations table of the sign in the object library.

The The data tables of data or the SQL statement that need in the said step 1) to derive are described.

Said step 2) data of specified format are the character string of XML form in.

The mapping relations table that said step 5) is set up Data Identification in sign and the object library of corresponding data in the data source data storehouse has three kinds of situation:

11) sign of importing data does not exist, and then in object library, inserts and imports data, increases mapping importing Data Identification and the sign mapping relations that import in the object library;

12) there is not sign in the importing data that exist in the mapping relations, then deletes corresponding data in the object library;

13) Data Identification that imports exists, and then upgrades corresponding data in the object library.

Technical scheme of the present invention comprises two aspects; One is to use the derivation of the PL/SQL storing process completion source end data of ORACLE, and the importing of destination data, and PL/SQL is suitable on all platforms; Solved cross-platform problem; Directly move in database server side simultaneously, efficient more and stable, and dispose simpler than other higher level lanquage development and maintenance.The 2nd, the data source end is derived to import with the data destination and is used XML form transmission data, and XML is the data layout of self-described, with platform independence, is easier to third party's understanding, when accomplishing synchronization scenario jointly with third party producer, links up more easily and cooperates.

Comprise two partly from program, some is that synchrodata source end is derived, and another partly is that the synchrodata destination imports.Be described below respectively:

Import and export handled data layout:

{ tables of data A length }, { tables of data B length }, { tables of data C length } ... { XML of the XML}{ tables of data B of tables of data A } { XML of tables of data C } ...

As implied above, the front is the length of tables of data, and the length of each tables of data is with CSV, and length is used with concrete data and separated, and suspension points is represented to repeat once to not limitting number of times.

Said step 2) the packet function that provides in is DBMS_XMLGEN.NEWCONTEXT and DBMS_XMLGEN.GETXML.

The function that provides in the said step 5) is XMLTABLE.

The present invention is because through the abundant function that uses ORACLE itself to provide; Carry out the mutual conversion of XML and tables of data; The PL/SQL that while ORACLE provides is a language efficient, easy to use, has simplified the development amount, has also improved stability simultaneously; The online implementing of customer in response in time, upgrading requirement, and can under any platform, accomplish deployment.Because synchrodata source end and data destination use XML form in return, also can call simultaneously, improve the dirigibility of system for different manufacturers, different platforms.

Description of drawings

The process flow diagram that Fig. 1 derives for data importing of the present invention.

Embodiment

The process flow diagram that Fig. 1 derives for data importing of the present invention is divided into the derivation storing process and imports storing process.Derive storing process; The derivation storing process of beginning data; At first specified data source end needs synchronous concrete data, and describes with tables of data or SELECT statement, then to each type data; Calling DBMS_XMLGEN.NEWCONTEXT and DBMS_XMLGEN.GETXML function respectively one by one and accomplish the conversion of database data to XML format string data, is that storing process is finally exported with all XML data combinations that convert.Import storing process; Receive the data of the XML form of deriving storing process output; Through call XML TABLE function; XML is reduced to the data of database sheet form, and set up corresponding data in the data source data storehouse, identify with object library in the mapping relations table of Data Identification, the mapping relations table of setting up Data Identification in the sign of corresponding data in the data source data storehouse and the object library has three kinds of situation: 11) sign of importing data does not exist; Then in object library, insert and import data, increase mapping and import Data Identification and the sign mapping relations that import in the object library; 12) there is not sign in the importing data that exist in the mapping relations, then deletes corresponding data in the object library; 13) Data Identification that imports exists, and then upgrades corresponding data in the object library.

Power supply administration, transformer station, bus, track data in certain concrete provincial main website of net level main website and subordinate are synchronous, have used this programme, and scene is following:

Newly-built PROC_EXPORT_CELL process in province of subordinate main website database; In realization process; The function DBMS_XMLGEN.NEWCONTEXT of the processing XML that provides through ORACLE itself and DBMS_XMLGEN.GETXML are the XML character string with the data conversion of power supply administration's table (TSUPPLIER), transformer station table (TSTATION), bus table (TMLINE), circuit table (TLINE); Assignment is given the output parameter of PROC_EXPORT_CELL process, thereby uses the data sync receiving end to call the XML form that this process can be obtained synchrodata.

In net level main website database; Newly-built PROC_IMPORT_CELL process, and set up the relation mapping table T_ID_MAP of data source end and destination, mainly comprise TYPE (type; Be used to represent map type; Like power supply administration, transformer station, bus, circuit mapping), TRUNK_ID (host stand ID, be that the data source end data imports the new mark ID that the host stands and forms), BRANCH_ID (ID of province main website is the sign ID of synchrodata in the source goes on foot), BRANCH_SITE fields such as (province main website titles); Output through the PROC_EXPORT_CELL of province of receiving and analyzing subordinate main website process; XMLTABLE through calling ORACLE and providing is a tables of data with the XML data conversion, and through whether having had mapping relations among the T_ID_MAP, determines whether to carry out that data are inserted, upgraded, still original data that import of deletion.

Claims (4)

1. one kind is used for multi-platform electric energy quality monitoring data synchronization transmission method, it is characterized in that may further comprise the steps:

1) confirms the data that needs are derived in the synchrodata source database;

2) calling the packet function, is the data of specified format with the data-switching that needs in the step 1) to derive;

3) data of record and output specified format;

4) receive the data that derive in the data source data storehouse, extract data;

5) be tables of data with the data conversion of extracting, and set up the sign of corresponding data in the data source data storehouse and the mapping relations table of the sign in the object library.

2. according to claim 1ly be used for multi-platform electric energy quality monitoring data synchronization transmission method, it is characterized in that needs are derived in the said step 1) The data tables of data or SQL statement describe.

3. according to claim 1ly be used for multi-platform electric energy quality monitoring data synchronization transmission method, it is characterized in that said step 2) in the data of specified format be the character string of XML form.

4. according to claim 1ly be used for multi-platform electric energy quality monitoring data synchronization transmission method, it is characterized in that said step 5) sets up sign and the mapping relations of sign in object library of corresponding data in the data source data storehouse three kinds of situation are arranged:

11) sign of importing data does not exist, and then in object library, inserts and should import data;

12) importing data that exist in the mapping relations but do not have sign are then deleted corresponding data in the object library;

13) Data Identification that imports exists, and then upgrades corresponding data in the object library.

Images