The deriving method that the transformer station model data filtering is processed
Technical field
The invention belongs to the substation data control field, in particular a kind of deriving method of transformer station model data filtering processing.
Background technology
Transformer station is important foundation and the support of intelligent grid, and it is the key concept of transformer station that source is safeguarded.Transformer station is as the source of scheduling/centralized control system data acquisition, but should provide the configuration parameter of various self-describeds, only need when safeguarding to utilize unified configuration tool to be configured in transformer station, generate standard configuration file, comprise parameter and the data models such as Substation Bus Arrangement figure, network topology.Electric substation automation system and scheduling/centralized control system can obtain the standard configuration file of transformer station automatically, and automatically import in self system database.Simultaneously, the main wiring diagram of electric substation automation system and split screen graphic file should offer scheduling/centralized control system with the test pattern form.Data just realize standardization from the source, be convenient to the various applications exploitings in back, can significantly increase work efficiency, and reduce repeated work.
The implementation that current source is safeguarded is that transformer station's end is derived figure SVG file and model data CIMXML file, and these file transfer by main station system verification, importing, then generate figure and model data automatically behind main website.The transformer station model data can all derive, but the model data file of all deriving needs to increase too much extra Processing tasks after importing for main website, and some data content can not correctly be processed.Based on above problem, in deriving transformer station model data CIM XML file process, the transformer station model data to be filtered and processed, the model data content that the CIM XML file of derivation is comprised is the least model set of needed transformer station of main website.This model data set-inclusion all active datas of current transformer station, and do not comprise redundant information, do not need main website to do extra analysis, filtration and work for the treatment of, the speed that improves main website importing data loading has just become present problem demanding prompt solution with efficient.
Summary of the invention
The object of the invention is to overcome the existing reduced model data CIM XML of transformer station file, content is various, repeats, and the transmission efficiency that causes lack of standardization is low, the deficiency of main website difficult treatment provides a kind of simple and effective filtration treatment method to the reduced model data CIM XML of transformer station file.
The present invention solves its technical matters and takes following technical scheme to realize:
The deriving method that a kind of transformer station model data filtering is processed, the method comprises the steps:
(1), selects the transformer substation system model data: need to select the transformer substation system model data file of derivation in intelligent substation information integral platform source, enter the reduced model data program;
(2), derive pre-service: comprise to the transformer substation system model data remove rubbish equipment, check the title uniqueness and revise and check incidence relation mistake and the processing of revising;
(3), derive to process: comprise that record to the identical ID of transformer substation system data or title distributes new ID and title and to the processing of incidence relation mistake;
(4), filtration treatment: according to the prior agreement of main website, reject agreement transformer substation system derived type data, device data in addition;
(5), special processing: on the basis of transformer substation system "current" model data, for necessary but with standard, standard and arrange the processing that conflicting data are carried out, make its requirement that meets the 61970CIM model specification and by the correct identification of main station system with import;
(6), create derived data: the node, final transformer substation system model field, record, the table data that create derived data are set to the attribute of node, and press hierarchical relationship, press the format organization of CIM XML regulation;
(7) data derive: transformer substation system model database content is exported as the internal storage data of CIM XML form, close memory database, discharge unwanted memory headroom, then generate CIM XML file processing.
And, described step (2) to the remove rubbish concrete steps of equipment of transformer substation system model data is:
Program is opened the transformer substation system model database, and the reading database list file, and ergodic data library facilities table obtains armamentarium information, structural type device id chained list; Open main wiring diagram by information integral platform graphics management object, and read figure to internal memory, initialization graphics primitive object chained list, for each graphics primitive object, obtain the associate device parameter information, if the associated device id of current Drawing Object is in the device id chained list, think that then this device id is effective, this device id is deleted from type equipment ID chained list, after this process finishes, remaining device id is garbage apparatus in the equipment chained list, the model database record deletion that these device ids are corresponding.
And, described step (2) inspection title uniqueness that the transformer substation system model data is carried out and the concrete steps of revising are:
The whole database facility table of traversal transformer substation system model data, for each equipment list, travel through again whole records, structure device type ID chained list if in the process of traversal equipment records, finds that current I D exists in chained list, think that then ID is identical, same structure device type title chained list checks whether there is equipment of the same name, derives operation for continuing execution after the equipment records correction of these identical ID and title.
And, described step (2) inspection incidence relation mistake that the transformer substation system model data is carried out and the concrete steps of revising are:
1., at first open main wiring diagram, check incidence relation, the whole Drawing Objects of traversal transformer substation system model data, device type and related ID according to each Drawing Object, whether the record of searching current type exists, if there is no then carry out bug patch and process, make it to satisfy correctness and the integrality of incidence relation;
2., the whole Drawing Objects of traversal transformer substation system model data, constructing graphic object ID associate device type i D chained list, search the repetition associated record, i.e. two related same equipment records of graphics primitive object, if have this situation then carry out bug patch and process, make it to satisfy correctness and the integrality of incidence relation.
And, described step (5) special processing comprises following contents processing:
1., need special processing transformer field, transformer container, the transformer quoting resource is set;
2., for the Transformer Winding field, arrange that the winding resource type is quoted, the reference voltage grade need to arrange specific label, measure related some table data;
3., when dispatching system is built the storehouse, measure related with point, title and the path of measurement type list.
Advantage of the present invention and good effect are:
The present invention proposes the method that adopts filtration treatment reduced model data, solve reduced model data volume problems of too, have following effect:
The model data CIM XML file of (1) deriving can correctly be identified by main station system, XML File Open that also can be by standard, browses.The main station system authenticating documents passes through, and can correctly import the complete substation data model of structure.And do not have unnecessary redundant information in the model data CIM XML file, making up model for main station system has reduced the burden of filtering and processing, and has improved the accuracy and efficiency of processing, and can guarantee data's integrity and consistency.
(2) owing to need not whole model datas is processed, thus the export needed minimum file that should be main station system, such file including whole transformer station model information.File is in transmission course, and is very obvious for the raising of speed and efficient.
Description of drawings
Fig. 1 is that transformer station model data of the present invention derive processing flow chart;
Fig. 2 is that transformer station of the present invention source is safeguarded reduced model CIM XML document flowchart.
Embodiment
Below in conjunction with specific embodiment this patent is elaborated:
The deriving method that a kind of transformer station model data filtering is processed, as shown in Figure 1, the concrete grammar step is as follows:
1, select the transformer substation system model data:
Select to need to derive transformer substation system model data common information model extend markup language (CIM XML in intelligent substation information integral platform source, Common Information Model Extensible Markup Language) file enters the reduced model data program:
(1), opens the transformer substation system database, initialization internal storage data lab environment, reading model derivation configuration file (dbcimxmlconfig.xml).Tectonic model is derived the allocate memory structure, obtains the transformer substation system database model and derives essential information: data volume, table quantity, table record content.
(2), create to derive CIM XML operand, and document object, root node.The needed Various types of data member variable of definition derivation process, initialization graphical list and graphics management object, starting derives preprocessing process.
2, derive pre-service: comprise the transformer substation system model data equipment that removes rubbish, check title uniqueness and the processing that checks three steps of incidence relation:
(1), the equipment that removes rubbish:
Program is opened the transformer substation system model database, and the reading database list file, and ergodic data library facilities table obtains armamentarium information, structural type device identification (ID) chained list.Open main wiring diagram by information integral platform graphics management object, and read figure to internal memory, initialization graphics primitive object chained list.For each graphics primitive object, obtain the associate device parameter information, if the associated device id of current Drawing Object in the device id chained list, thinks then that this device id is effectively, deletes this device id from type equipment ID chained list.After this process finished, remaining device id just all was invalid, redundant in the equipment chained list, i.e. garbage apparatus, model database record deletion that need to these device ids are corresponding.Then enter and collect the garbage apparatus information processing, in this process, the record of storing in the type equipment ID chained list is garbage apparatus ID, and these ID are collected, put in order in garbage apparatus chained list to be deleted.Then the delete interface in calling data storehouse (remove) is removed these garbage apparatus from database.
(2), check the title uniqueness:
The whole database facility table of traversal transformer substation system model data for each equipment list, travels through whole records again.Structure device type-ID chained list if in the process of traversal equipment records, finds that current I D exists, and thinks that then ID is identical in chained list.Same structure device type-title chained list checks whether there is equipment of the same name.Equipment records for these identical ID and title provides miscue, must could continue to carry out after revising these mistakes to derive to operate.
(3) check incidence relation:
A, at first open main wiring diagram, check incidence relation, the whole Drawing Objects of traversal transformer substation system model data, according to device type and the related ID of each Drawing Object, whether the record of searching current type exists, and if there is no then provides miscue.
B, traversal transformer substation system model data whole Drawing Objects, constructing graphic object ID associate device type i D chained list is searched the repetition associated record, i.e. and two related same equipment records of graphics primitive object are if exist this situation then provide miscue.
For above A, two kinds of miscues of B all must be carried out bug patch and process, and make it to satisfy correctness and the integrality of incidence relation.
3, derive processing:
Derive to process to comprise being new ID and the title of record distribution of identical ID and title automatically again, eliminate repeated mistake.The principle of distributing is that current available Global maximum ID is added 1, realizes by recalls information unified platform ID distribution module, and new name is called the record type title and adds ID.For the mistake of incidence relation, derivation will be processed automatically.The content of processing mainly comprises the associated container of tie point, if the interval then obtains the electric pressure under the interval, and the associated container that tie point is set is the electric pressure of appointment.The reference voltage grade of Lookup protocol electric pressure arranges the associated tie point of end points.
4, filtration treatment:
The filtration here is the needs according to main website, or the in advance setting of agreement, will not need, or the categorical data of unnecessary derivation, device data weeds out from export.
(1), before the traversal transformer substation system tables of data record derived data, needs according to predetermined model logical relation grounding switch, transformer bay to be filtered every record.
(2), according to the adduction relationship of record between the table, the equipment under namely measuring does not exist, and does not then derive principle, if related equipment does not exist, then filters non-existent measurement, terminal table record data recording.
(3), some special intervals that transformer substation side created filter.
5, special processing:
Refer on the basis of "current" model data, data for undesirable, standard, standard and agreement are carried out various types of processing, so that it meets the requirements and can and import by the correct identification of main station system, special processing is mainly used in satisfying the requirement of 61970CIM model specification, the model structure in the current transformer station need to be changed the processing of doing to 61970CIM.
(1), need special processing transformer field, the container of transformer quoting resource, transformer is set.
(2), for the Transformer Winding field, arrange that the winding resource type is quoted, the reference voltage grade need to arrange specific label, measure related some table data and also need special processing.
(3), when dispatching system is built the storehouse, measure related with point, title and the path of measurement type list also need special processing.
6, create derived data:
The node, final mask field, record, the table data that create derived data are set to the attribute of node, and press the format organization that hierarchical relationship is pressed CIM XML regulation.
7, data derive:
Data derive and finish, and are about to the internal storage data that the model database content exports as CIM XML form, close memory database, discharge unwanted memory headroom, then generate CIM XML file processing.
It is emphasized that; embodiment of the present invention is illustrative; rather than determinate; therefore the present invention is not limited to the embodiment described in the embodiment; every other embodiments that drawn by those skilled in the art's technical scheme according to the present invention belong to the scope of protection of the invention equally.