CN107025279B - SCD file online parallel configuration system and method based on database interface layer operation flow - Google Patents
SCD file online parallel configuration system and method based on database interface layer operation flow Download PDFInfo
- Publication number
- CN107025279B CN107025279B CN201710190995.6A CN201710190995A CN107025279B CN 107025279 B CN107025279 B CN 107025279B CN 201710190995 A CN201710190995 A CN 201710190995A CN 107025279 B CN107025279 B CN 107025279B
- Authority
- CN
- China
- Prior art keywords
- configuration
- database
- ied
- scd file
- data
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 18
- 238000004891 communication Methods 0.000 claims abstract description 94
- 230000006870 function Effects 0.000 claims description 101
- 238000012163 sequencing technique Methods 0.000 claims description 2
- 238000012986 modification Methods 0.000 abstract description 12
- 230000004048 modification Effects 0.000 abstract description 12
- 238000013507 mapping Methods 0.000 abstract description 9
- 238000007726 management method Methods 0.000 description 30
- 238000010586 diagram Methods 0.000 description 5
- 241000272814 Anser sp. Species 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 238000010420 art technique Methods 0.000 description 2
- 230000008859 change Effects 0.000 description 2
- 238000013479 data entry Methods 0.000 description 2
- 230000008569 process Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 238000012800 visualization Methods 0.000 description 2
- 238000013499 data model Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 230000007246 mechanism Effects 0.000 description 1
- 230000002265 prevention Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
Images
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/84—Mapping; Conversion
- G06F16/88—Mark-up to mark-up conversion
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/06—Energy or water supply
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- Health & Medical Sciences (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Water Supply & Treatment (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- Human Resources & Organizations (AREA)
- General Business, Economics & Management (AREA)
- General Health & Medical Sciences (AREA)
- Public Health (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Small-Scale Networks (AREA)
Abstract
The invention discloses an SCD file online parallel configuration system and a configuration method based on database interface layer operation flow, when in application, a total station SCD file is firstly analyzed, an IED device model and a communication subnet in the SCD file are mapped into an IED device database and a communication subnet database, an interface layer is established on the database layer, an interface function is set, a configuration operation interface is set on the application layer, so that a user can input a configuration command and configuration parameters through the configuration operation interface, further, the access and modification of the database are realized through the interface function provided by the database interface layer, and then the configuration of the SCD file is realized through the mapping relation between the database and the SCD file. During parallel configuration, modification of IED files by a user is sequentially processed in an operation flow mode, data in the database are modified one by one, and a modification result is returned to the configuration slave machine through an interface function. The invention can realize multi-person cooperative configuration of the SCD file, avoid configuration conflict, improve configuration efficiency and reduce configuration errors.
Description
Technical Field
The invention relates to the technical field of intelligent substation data processing, in particular to an SCD (substation configuration description) file online parallel configuration system and method based on database interface layer operation flow.
Background
In an intelligent substation, information interaction of various types of Intelligent Electronic Devices (IEDs) depends on a substation configuration description file (SCD). The SCD file is unique for all stations, contains all information within the station, describes the instance configuration and communication parameters of all IEDs and the communication configuration between the IEDs. The SCD file is large in size, which can reach hundreds of MB, the speed of loading the file completely is low, and the defects that the visualization degree is low during configuration, the configuration speed is low, parallel configuration cannot be realized and the like exist. The current SCD configuration software adopts single-person single-machine manual configuration, so that the problem of low visualization degree is solved to a certain extent, but the problem that multiple persons cannot be simultaneously configured still exists.
Disclosure of Invention
The technical problem to be solved by the invention is as follows: based on the characteristics of the IED model, mapping IED objects in the SCD file to a database by using a database technology to form IED database entries, and mapping each virtual terminal information model to a communication sub-network database; and creating an interface layer, modifying the database through the interface layer, further modifying the SCD file, and avoiding operation conflict by using the interface layer operation flow, so that the modification result can be coordinately updated, and parallel configuration is realized.
Currently, an object-oriented model is established on intelligent equipment in an intelligent substation based on the IEC61850 standard, and most configuration tools have the functions of analyzing an SCD file and extracting an Intelligent Equipment (IED) object of the substation, and are the basis for establishing a data platform by combining an object database technology. The configuration of the SCD file is abstracted into the configuration of the connection of the virtual terminal connecting lines and the communication sub-network, so that the decoupling between the devices is realized, and the configuration is the basis of parallel configuration. Through a conflict prevention mechanism of the database, the following problems of the SCD file parallel configuration technology can be solved: firstly, synchronously loading SCD files by multiple machines; secondly, the problem of modification conflict when multiple online persons simultaneously configure and modify the SCD file is solved; and thirdly, merging the SCD files after independent configuration.
The technical scheme adopted by the invention is as follows: an SCD file online parallel configuration system based on database interface layer operation flow, an online configuration group comprises a host server and a plurality of configuration slave computers which are connected through a local area network;
the host server is provided with a file layer and a database layer, wherein the file layer stores SCD files to be configured, and the host server analyzes the SCD files to be configured, acquires IED equipment data and communication subnet data corresponding to an IED model and stores the IED equipment data and the communication subnet data in the database layer;
each configuration slave machine is provided with an application layer, a configuration interface for SCD file configuration is provided for a user, the user sends a configuration command through the configuration interface, and the user configuration command comprises an operation type and configuration parameters;
the host server is communicated with each configuration slave machine through an interface layer, the interface layer comprises configuration interfaces corresponding to different operation types, and each configuration interface is provided with a corresponding configuration function; the interface layer receives user configuration commands sent by users through all the configuration slave machines, calls configuration functions of corresponding configuration interfaces according to the operation types and the configuration parameters of the user configuration commands respectively and sequentially, adds the configuration functions containing the configuration parameters into an operation queue, and sequentially executes all the configuration functions in the operation queue under the condition of no configuration conflict so as to configure the IED equipment data or the communication subnet data stored in the database layer;
and the host server maps the configured IED equipment data and the configured communication subnet data into the SCD file of the file layer at set intervals, namely, the configuration of the SCD file is completed.
When the method is applied, for user configuration commands sent by slave machines with different configurations, the interface layer sequentially and respectively executes each configuration function in an operation flow mode according to the calling sequence of the configuration functions of the interface layer, and carries out read-write operation on IED data of the database layer, so that operation conflict is avoided. If two users almost simultaneously send configuration commands to the same IED, due to the influence of system refreshing frequency and the like, the calling time of the configuration commands to the interface functions can be distinguished, and operation conflicts can be avoided by sequentially executing the configuration commands according to the calling sequence of the interface functions by utilizing the idea of operation flow.
The invention is characterized in that under the condition of no configuration conflict: modifying the IED based on different SCD versions in the former configuration and the latter configuration; or when the former configuration and the latter configuration are based on the same SCD version, the former configuration and the latter configuration respectively modify different IEDs; or the interface function called by the configuration operation corresponds to the read-only operation, so that the configuration conflict cannot be caused to the subsequent configuration operation. If the previous configuration operation and the subsequent configuration operation modify the same IED based on the same SCD version, and the previous configuration operation changes the parameters related to the subsequent configuration operation, there is a configuration conflict between the two configuration operations, and at this time, the subsequent operation is rejected. When configuration conflict is caused, the host server does not execute the configuration operation corresponding to the post-configuration function, and simultaneously, the host server returns configuration conflict information to the corresponding configuration slave machine.
Because the read-only operation can not cause configuration conflict, in order to improve the utilization efficiency of the system, the invention adds the configuration function corresponding to the user configuration command into the operation queue only when the configuration function corresponding to the user configuration command is read-write operation for the user configuration command sent by each configuration slave.
In the invention, the interface layer configuration function comprises an interval management function, an engineering management function, a volume management function, an IED type selection function, a physical loop function, a communication configuration function, a virtual loop configuration function and a report management function. Correspondingly, a configuration interface provided by each configuration slave machine is provided with a selection and input inlet of a user configuration command and parameters corresponding to each configuration function. The method comprises the steps that a project management function, an interval management function and a volume management function are used for setting description information of a transformer substation, and modification of the project management function, the interval management function and the volume management function only affects a transformer substation description part in an SCD file. The IED typing function modifies the IED model manually. The physical loop function and the virtual loop configuration function are used for configuring different types of virtual terminal connecting lines. The communication configuration function is used to manually modify entries in the communication subnet. The report management function is the output SCD file information.
Preferably, the initial IED device data and communication subnet data stored by the database layer are obtained by traversing the SCL language tags in the initial SCD file to be configured. Specifically, traverse data corresponding to the elements < Header >, < status >, < Communication >, < IED > and < DataTypeTemplates > in SCL language. In the Communication subnet part of the SCD file, the < Communication > element includes 6 < subnet > sub-elements, corresponding to 6 subnets inside the intelligent substation: MMS sub-network, GOOSE sub-network, SV sub-network two each. Other prior art techniques may also be employed for the parsing of the SCD file.
Preferably, in the host server, the SCD file to be configured is stored on the hard disk, and the IED device data and the communication subnet data are stored in the memory; and the host server updates the SCD file in the hard disk once every set time according to the IED equipment data and the communication subnet data in the memory. The interval of the set time can be set according to the needs of the user to ensure that the SCD file can be synchronized with the IED device in time as a reference, for example, the set time interval is slightly longer than the loading time of a complete SCD file, which is 100 ms.
In order to ensure the real-time validity of the SCD file, the working personnel of a plurality of configuration slave machines can timely know the current IED configuration condition, and further adjust the configuration to be carried out according to the requirement. According to the invention, after each SCD file is updated, the database temporary files in the internal memory, namely the IED equipment data and the communication subnet data stored by the database layer, are deleted, then the current updated SCD file is analyzed again in the subsequent configuration to obtain new IED equipment data and communication subnet data, and at the moment, all configuration operations before the updating of the SCD file will not cause configuration conflict influence on the subsequent configuration operations.
Preferably, the IED device data form an IED data table, the IED data table includes an IED duplex name, a logical device first address and a subnet address, and the IED duplex name serves as a primary key; the communication subnet data forms a communication subnet data table, which includes: the virtual terminal model is used as a main key and comprises IED equipment, logic nodes and data objects to which the virtual terminals belong.
The invention also discloses an SCD file online parallel configuration method based on the database interface layer operation flow, which comprises the following steps:
s1, loading and analyzing the SCD file to be configured, acquiring data related to each IED object model, and generating an IED equipment database and a communication sub-network database;
s2, obtaining the configuration command sent by the user, and calling the corresponding configuration function according to the operation type and the configuration parameter of the configuration command;
s3, sorting the operation queues according to the calling sequence of the configuration functions corresponding to the configuration commands, and then configuring the data in the IED database and the communication sub-network database according to the operation types and the configuration parameters corresponding to the configuration functions in the operation queues;
and S4, updating the SCD file to be configured according to the real-time data in the IED equipment database and the communication sub-network database at set time intervals.
In step S1, the loading manner of the SCD file may be any prior art, and the formed IED object model hierarchy sequentially includes, from top to bottom: logical devices, logical nodes, data objects, data attributes. The virtual terminal model in the communication sub-network comprises: the physical device (IED), the logical device, the logical node and the data object.
In step S3, if the configuration command sent by the user is to perform read-only operation on data in the IED device database or the communication subnet database, the corresponding operation is not listed in the operation queue. Because the read-only operation does not change the data in the database, the conflict in the parallel configuration can not be brought, and the working efficiency of the configuration system can be improved by not adding the read-only operation into the operation queue.
In order to ensure the real-time validity of the SCD file, the working personnel of a plurality of configuration slave machines can timely know the current IED configuration condition, and further adjust the configuration to be carried out according to the requirement. In step S4, the method deletes the IED device database and the communication subnet database after each SCD file is updated, then parses the currently updated SCD file to obtain a new IED device database and a new communication subnet database, and executes the configuration function in the subsequent operation queue based on the new IED device database and the new communication subnet database. At this time, all configuration operations before the update of the SCD file will not cause configuration conflict influence on the subsequent configuration operations.
Advantageous effects
According to the invention, the mapping is formed between the IED object model in the SCD file and the database, and then the configuration operation of the database during multi-person configuration is coordinated by using the operation flow (namely the operation queue), so that the parallel configuration of the SCD file is realized, the operation conflict is avoided, the multi-person cooperative configuration of the SCD file is realized, the configuration efficiency is improved, and the configuration errors are reduced.
Drawings
FIG. 1 is a software hierarchy diagram of a parallel configuration system according to the present invention;
FIG. 2 is a schematic diagram illustrating a SCD file configuration process;
FIG. 3 is a schematic diagram of a hierarchy of IED devices after parsing;
FIG. 4 is an expanded view of IED device data entries;
FIG. 5 is a schematic diagram of a communication subnet database;
FIG. 6 is a flow chart illustrating an embodiment of the present invention.
Detailed Description
The following further description is made in conjunction with the accompanying drawings and the specific embodiments.
Example 1
Referring to fig. 1, the SCD file online parallel configuration system based on database interface layer operation flow of the present invention includes an online configuration group including a host server and a plurality of configuration slaves connected through a local area network;
the method comprises the steps that a file layer and a database layer are arranged on a host server, SCD files to be configured are stored in the file layer, the host server analyzes the SCD files with configuration, IED equipment data and communication subnet data corresponding to an IED model are obtained, and the IED equipment data and the communication subnet data are stored in the database layer;
each configuration slave machine is provided with an application layer, a configuration interface for SCD file configuration is provided for a user, the user sends a configuration command through the configuration interface, and the user configuration command comprises an operation type and configuration parameters;
the host server is communicated with the configuration slave machine through an interface layer, the interface layer comprises configuration interfaces corresponding to different operation types, and each configuration interface is respectively provided with a corresponding configuration function; the interface layer receives user configuration commands sent by all the configuration slave machines, calls configuration functions of corresponding configuration interfaces according to the operation types and the configuration parameters of the user configuration commands respectively and sequentially, adds the configuration functions containing the configuration parameters into an operation queue, and sequentially executes all the configuration functions in the operation queue under the condition of no conflict so as to configure the IED equipment data or the communication subnet data stored in the database layer;
and the host server maps the configured IED equipment data and the configured communication subnet data into the SCD file of the file layer at set intervals, namely, the configuration of the SCD file is completed.
When the method is applied, for user configuration commands sent by slave machines with different configurations, the interface layer sequentially and respectively executes each configuration function in an operation flow mode according to the calling sequence of the configuration functions of the interface layer, and the read-write operation is carried out on the IED data of the database layer. If the interface function executed at a certain time corresponds to read-only operation, the interface function does not cause conflict to subsequent configuration operation; if the executed interface function corresponds to read-write operation, a conflict may be caused to the configuration operation of the next interface function in the operation flow, and when the conflict is caused, the configuration operation of the next configuration function is not executed, and the host server returns operation conflict information to the corresponding configuration slave.
Because the read-only operation can not cause configuration conflict, in order to improve the utilization efficiency of the system, the invention adds the configuration function corresponding to the user configuration command into the operation queue only when the configuration function corresponding to the user configuration command is read-write operation for the user configuration command sent by each configuration slave.
As shown in fig. 1, the interface layer configuration functions include an interval management function, an engineering management function, a volume management function, an IED type selection function, a physical loop function, a communication configuration function, a virtual loop configuration function, and a report management function. Correspondingly, a configuration interface provided by each configuration slave machine is provided with a selection and input inlet of a user configuration command and parameters corresponding to each configuration function. The method comprises the steps that a project management function, an interval management function and a volume management function are used for setting description information of a transformer substation, and modification of the project management function, the interval management function and the volume management function only affects a transformer substation description part in an SCD file. The IED typing function modifies the IED model manually. The physical loop function and the virtual loop configuration function are used for configuring different types of virtual terminal connecting lines. The communication configuration function is used to manually modify entries in the communication subnet. The report management function is the output SCD file information.
Preferably, the initial IED device data and communication subnet data stored by the database layer are obtained by traversing the SCL language tags in the initial SCD file to be configured. For an SCD file, only five elements of the SCD file are loaded by traversing the SCL language tags, including: < Header >, < status >, < Communication >, < IED >, < DataTypeTemplates >, not all SCD files. In the Communication subnet part of the SCD file, the < Communication > element includes 6 < subnet > sub-elements, corresponding to 6 subnets inside the intelligent substation: MMS sub-network, GOOSE sub-network, SV sub-network two each. Since the SCL language is a subset of the XML language, the look-up SCL language tag and the XML language tag are identical. Other prior art techniques may also be employed for the parsing of the SCD file.
Preferably, in the host server, the SCD file to be configured is stored on the hard disk, and the IED device data and the communication subnet data are stored in the memory; and the host server updates the SCD file in the hard disk once every set time according to the IED equipment data and the communication subnet data in the memory. The interval of the set time can be set according to the needs of the user, so as to ensure that the SCD file can be synchronized with the IED equipment in time as a reference.
Preferably, the IED device data form an IED data table, the IED data table includes an IED duplex name, a logical device first address and a subnet address, and the IED duplex name serves as a primary key; the communication subnet data forms a communication subnet data table, which includes: the virtual terminal module comprises a virtual terminal number, a virtual terminal model, a virtual terminal number connected with the virtual terminal model and input and output attributes, wherein the virtual terminal model is used as a main key.
Example 2
Referring to fig. 6, an on-line parallel configuration method for SCD files based on database interface layer operation flow includes the steps of:
s1, loading and storing the SCD file to be configured;
s2, analyzing the SCD file, acquiring data related to each IED object model, and generating an IED equipment database and a communication sub-network database;
s3, acquiring configuration commands sent by users, sequencing operation queues according to the sequence sent by the user configuration commands, and then configuring and operating data in an IED database according to the operation types and configuration parameters of the user configuration commands in the operation queues in sequence;
and S4, updating the SCD file to be configured according to the real-time data in the IED equipment database and the communication sub-network database at set time intervals.
In step S1, the loading manner of the SCD file may be any prior art, and the formed IED object model hierarchy is shown in fig. 3, and sequentially from top to bottom: logical devices, logical nodes, data objects, data attributes. The virtual terminal model in the communication subnet is shown with reference to fig. 5, and includes: the physical device (IED), the logical device, the logical node and the data object.
In step S3, if the configuration command sent by the user is to perform read-only operation on data in the IED device database or the communication subnet database, the corresponding operation is not listed in the operation queue. Because the read-only operation does not change the data in the database, the conflict in the parallel configuration can not be brought, and the working efficiency of the configuration system can be improved by not adding the read-only operation into the operation queue.
Example 3
Referring to the schematic diagram of the SCD file configuration flow shown in fig. 2, after the SCD file stored in the file layer is opened, the SCD file is parsed to obtain an IED device model and a communication subnet, and then the IED device model and the communication subnet are mapped with database entries stored in the database layer to obtain a substation secondary IED device database and a communication subnet database. The communication sub-network database comprises SV, GOOSE and MMS sub-networks, and six communication sub-network databases are formed after doubling. Before configuration, entry information of each database is incomplete, and what is missing is configuration information. In the configuration process, configuration information is written in through an interface layer function, the items are modified, and a complete IED equipment database and a communication sub-network database are formed, namely a complete substation IED object model and a communication sub-network are formed, and a configured SCD file is obtained through reverse mapping.
Currently, there are many methods for parsing the SCD file, and finally, the IED model and the communication subnet attributes can be obtained, that is, the mapping relationship among the IED model, the communication subnet, and the SCD can be realized. But a mapping between IED model, communication sub-network and the database is to be established. The IED model hierarchy obtained by analyzing the current SCD file is shown in fig. 3, and sequentially: IED-logical device LD-logical node LN-data object DO-data model DA. Namely: the number of logical devices LD included in the IED is uncertain, and the number of logical nodes LN included in the logical devices LD is also uncertain, so that a unified form of IED database entry cannot be obtained. Therefore, the present invention adopts the linked list storage, as shown in fig. 4, only the first address LD Header of the logical device LD is reserved in the data entry of the IED device database, thereby implementing the mapping of the IED model to the database.
Referring to fig. 5, the communication subnet database entry includes: the virtual terminal number, the virtual terminal model (the primary key, including the IED device, the logic node, and the data object) to which it belongs, the virtual terminal number connected, and the input/output attribute of the virtual terminal. When SCD is loaded, a virtual terminal model can be formed through the IED model and the communication subnet model, and when the worker performs configuration again, the virtual terminal number connected with the virtual terminal number and the input/output attribute are filled.
In order to solve the conflict problem during multi-user configuration, the invention adopts a layered software architecture which comprises a file layer, a database layer, an interface layer and a high-level application layer, as shown in fig. 4, the related configuration software comprises a file layer, a database layer, an interface layer and an application layer, wherein the interface layer is opened, and the high-level application of the application layer is written. In the file layer, the SCD files to be configured are stored on the hard disk. And in a database layer, a database and a communication sub-network database based on the secondary IED equipment of the transformer substation are established by traversing the marks in the SCD file, and are resident in a memory and are stored on a hard disk at regular time. The interface layer provides a communication interface for configuring the slave and the host server, the interface layer software comprises a part running on the slave and a part running on the host, and the configuration function is arranged on the server host. The slave part software is used for sending command data containing configuration types and parameters to the host according to the configuration types and parameters selected by a user through the application interface; the host part software is used for calling a host configuration function according to the received slave command data, performing configuration operation and writing configuration parameters into a database.
In order to ensure the real-time validity of the SCD file, the working personnel of a plurality of configuration slave machines can timely know the current IED configuration condition, and further adjust the configuration to be carried out according to the requirement. According to the invention, after each SCD file is updated, the IED device database and the communication sub-network database stored in the memory are deleted, then the current updated SCD file is analyzed, a new IED device database and a new communication sub-network database are obtained, and the configuration function in the subsequent operation queue is executed based on the new IED device database and the new communication sub-network database. At this time, all configuration operations before the update of the SCD file will not cause configuration conflict influence on the subsequent configuration operations.
The core interface function of the interface layer of the invention comprises: the system comprises an engineering management interface, an interval management interface, a volume management interface, an IED type selection interface, a physical loop interface, a communication configuration interface, a virtual loop configuration interface and a report management interface. The engineering management interface, the interval management interface and the volume management interface are used for setting description information of the transformer substation, and modification of the description information only affects the description part of the transformer substation in the SCD file. The IED model is manually modified by the IED type selection interface. The physical loop interface and the virtual loop configuration interface are used for configuring different types of virtual terminal connecting lines. The communication configuration interface is used to manually modify entries in the communication subnet. The report management interface is used for outputting SCD file information.
When configuring, the user operates on the interface provided by the high-level application, inputs configuration parameters, the high-level application calls the interface layer function to access the database object, and when calling the interface layer function, the function parameters comprise: IED device, communication subnet, virtual terminal wiring that the operation relates to, virtual terminal wiring includes: the virtual terminal numbers connected with the IED equipment, the virtual terminal numbers connected with the IED equipment and the input and output attributes are used for establishing virtual terminal connection between the IED equipment and the communication sub-network. Because the IED device comprises the virtual terminal model in the IED database, and the virtual terminal connecting line parameters comprise the numbers of the input virtual terminal and the output virtual terminal, the modification of the related data of the two entries in the communication sub-network can be realized.
When the method is applied, if one user initiates a configuration operation request, the previous user finishes the operation and updates the database layer, and no configuration conflict occurs. Taking fig. 6 as an example, when two users almost simultaneously initiate configuration operation requests, the simultaneity is good enough, and when the second user initiates an operation, the operation of the first user is not finished yet, which may cause configuration conflicts.
Fig. 6 illustrates the case of a configuration conflict. After SCD updating is completed on the server host, configuration operations of two users with better simultaneity enter an operation queue, and the operations of the two users are stored in the operation queue. The configuration request of the first user is firstly executed through an interface function, and IED equipment, a GOOSE network, an SV network and an MMS network in a database are modified. After the execution is finished, the execution result is sent to each slave computer, SCD data visible on the slave computer is refreshed and displayed, the host server searches and executes the next interface function in the operation flow, the configuration operation of the two users is based on the same IED equipment database and the communication sub-network database version, if the previous operation does not relate to the IED related to the subsequent operation, no conflict exists, the interface function can be normally executed, and the operation is continued after the successful execution; if the IED related to the subsequent operation is modified by the previous operation, a configuration conflict occurs, the IED with the modification visible on the slave is refreshed, and the server host returns conflict information to the configuration slave and discards the subsequent operation. Until all operations in the operation queue are completed.
The function parameters related to each configuration and the operation package are sent to the database by the interface layer to be executed, and an operation flow, namely an operation queue, is formed. Since the sending and execution of the operation flow is instantaneous relative to manually configured operations, i.e., the present invention can avoid operation conflicts through the operation flow of the interface.
According to the invention, the mapping is formed between the IED object model in the SCD file and the database, and then the configuration operation of the database during multi-person configuration is coordinated by using the operation queue, so that the parallel configuration of the SCD file is realized, the operation conflict is avoided, the multi-person cooperative configuration of the SCD file is realized, the configuration efficiency is improved, and the configuration errors can be reduced.
The above description is only a preferred embodiment of the present invention, and it should be noted that, for those skilled in the art, several modifications and variations can be made without departing from the technical principle of the present invention, and these modifications and variations should also be regarded as the protection scope of the present invention.
Claims (7)
1. An SCD file online parallel configuration system based on database interface layer operation flow is characterized in that an online configuration group comprises a host server and a plurality of configuration slave computers which are connected through a local area network;
the host server is provided with a file layer and a database layer, wherein the file layer stores SCD files to be configured, and the host server analyzes the SCD files to be configured, acquires IED equipment data and communication subnet data corresponding to an IED model and stores the IED equipment data and the communication subnet data in the database layer;
each configuration slave machine is provided with an application layer, a configuration interface for SCD file configuration is provided for a user, the user sends a configuration command through the configuration interface, and the user configuration command comprises an operation type and configuration parameters;
the host server is communicated with the configuration slave machine through an interface layer, the interface layer comprises configuration interfaces corresponding to different operation types, and each configuration interface is respectively provided with a corresponding configuration function; the interface layer configuration functions comprise an interval management function, an engineering management function, a volume management function, an IED type selection function, a physical loop function, a communication configuration function, a virtual loop configuration function and a report management function;
the interface layer receives user configuration commands sent by all the configuration slave machines, calls configuration functions of corresponding configuration interfaces according to the operation types and the configuration parameters of the user configuration commands respectively and sequentially, adds the configuration functions containing the configuration parameters into an operation queue, and sequentially executes all the configuration functions in the operation queue under the condition of no configuration conflict so as to configure the IED equipment data or the communication subnet data stored in the database layer;
the case of no configuration conflict is: modifying the IED based on different SCD versions in the former configuration and the latter configuration; or when the former configuration and the latter configuration are based on the same SCD version, the former configuration and the latter configuration respectively modify different IEDs;
the host server maps the configured IED equipment data and the configured communication subnet data into the SCD file of the file layer at set intervals, namely the SCD file is configured;
after each SCD file is updated, deleting an IED equipment database and a communication sub-network database, then analyzing the currently updated SCD file, and acquiring a new IED equipment database and a new communication sub-network database; and executing the configuration function in the subsequent operation queue based on the new IED equipment database and the communication sub-network database.
2. The system for on-line parallel configuration of SCD files based on database interface layer operation flow according to claim 1, wherein, in the interface layer, for the user configuration command sent from each configuration slave, the configuration function corresponding to the user configuration command is added to the operation queue only when the configuration function corresponding to the user configuration command is a read-write operation.
3. The SCD file online parallel configuration system based on database interface layer operation flow according to claim 1, wherein the database layer stores the initial IED device data and communication subnet data obtained by traversing SCL language tags in the SCD file to be initially configured.
4. The system according to claim 1, wherein the SCD file to be configured is stored on a hard disk in the host server, and the IED device data and the communication subnet data are stored in the memory.
5. The SCD file online parallel configuration system based on database interface layer operation flow according to claim 1, characterized in that the IED device data constitutes an IED data table, the IED data table comprises IED duplex names, logical device head addresses and subnet addresses, wherein the IED device duplex names are used as primary keys; the communication subnet data forms a communication subnet data table, which includes: the virtual terminal model is used as a main key and comprises IED equipment, logic nodes and data objects to which the virtual terminals belong.
6. An SCD file online parallel configuration method of the SCD file online parallel configuration system based on the database interface layer operation flow according to any one of claims 1 to 5, characterized by comprising the steps of:
s1, loading and storing the SCD file to be configured;
s2, analyzing the SCD file, acquiring data related to each IED object model, and generating an IED equipment database and a communication sub-network database;
s3, acquiring configuration commands sent by users, sequencing operation queues according to the sequence sent by the user configuration commands, and then configuring and operating data in an IED database or a communication sub-network database according to the operation types and the configuration parameters of the user configuration commands in the operation queues in sequence;
s4, updating SCD files to be configured according to the real-time data in the IED equipment database and the communication sub-network database at set time intervals; after each SCD file is updated, deleting an IED equipment database and a communication sub-network database, then analyzing the currently updated SCD file, and acquiring a new IED equipment database and a new communication sub-network database; and executing the configuration function in the subsequent operation queue based on the new IED equipment database and the communication sub-network database.
7. The method according to claim 6, wherein in step S3, if the configuration command issued by the user is a read-only operation on data in the IED device database or the communication subnet database, the corresponding operation is not queued.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710190995.6A CN107025279B (en) | 2017-03-28 | 2017-03-28 | SCD file online parallel configuration system and method based on database interface layer operation flow |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710190995.6A CN107025279B (en) | 2017-03-28 | 2017-03-28 | SCD file online parallel configuration system and method based on database interface layer operation flow |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107025279A CN107025279A (en) | 2017-08-08 |
| CN107025279B true CN107025279B (en) | 2020-03-10 |
Family
ID=59526050
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710190995.6A Active CN107025279B (en) | 2017-03-28 | 2017-03-28 | SCD file online parallel configuration system and method based on database interface layer operation flow |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107025279B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109754131B (en) * | 2017-11-01 | 2022-05-20 | 国家电网公司 | SCD file configuration method and device based on NXD |
| CN107958345A (en) * | 2017-12-13 | 2018-04-24 | 许继集团有限公司 | A kind of SCD file collocation method and device based on database and file fragment |
| CN109800209B (en) * | 2019-02-18 | 2021-04-16 | 重庆邮电大学 | Intelligent substation SCD file parallel analysis method |
| CN110765083B (en) * | 2019-09-30 | 2022-07-12 | 许昌许继软件技术有限公司 | Data forwarding equipment of intelligent substation and memory optimization method thereof |
| CN112287648A (en) * | 2020-10-27 | 2021-01-29 | 国电南瑞科技股份有限公司 | SCD-based substation monitoring system data point table generation and synchronization method |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
| CN102867274A (en) * | 2012-07-27 | 2013-01-09 | 江苏省电力公司电力科学研究院 | Management and graphical display system for intelligent substation SCL (substation configuration description language) configuration files |
| CN103425467A (en) * | 2012-05-18 | 2013-12-04 | 汪巨森 | Method for generating programs on basis of IEC (international electrotechnical commission) 61850 |
| CN103605705A (en) * | 2013-11-11 | 2014-02-26 | 国家电网公司 | SCD (substation configuration description) file management system |
| CN105429027A (en) * | 2015-11-12 | 2016-03-23 | 国网宁夏电力公司 | Secondary safety measure support system in operation and maintenance of intelligent substation and construction method |
| CN106021396A (en) * | 2016-05-13 | 2016-10-12 | 国网辽宁省电力有限公司电力科学研究院 | B/S framework-based SCD configuration file graphic display method |
-
2017
- 2017-03-28 CN CN201710190995.6A patent/CN107025279B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
| CN103425467A (en) * | 2012-05-18 | 2013-12-04 | 汪巨森 | Method for generating programs on basis of IEC (international electrotechnical commission) 61850 |
| CN102867274A (en) * | 2012-07-27 | 2013-01-09 | 江苏省电力公司电力科学研究院 | Management and graphical display system for intelligent substation SCL (substation configuration description language) configuration files |
| CN103605705A (en) * | 2013-11-11 | 2014-02-26 | 国家电网公司 | SCD (substation configuration description) file management system |
| CN105429027A (en) * | 2015-11-12 | 2016-03-23 | 国网宁夏电力公司 | Secondary safety measure support system in operation and maintenance of intelligent substation and construction method |
| CN106021396A (en) * | 2016-05-13 | 2016-10-12 | 国网辽宁省电力有限公司电力科学研究院 | B/S framework-based SCD configuration file graphic display method |
Non-Patent Citations (1)
| Title |
|---|
| 对象互操作的层次模型;李贵等;《计算机科学》;20081125;第2-3页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107025279A (en) | 2017-08-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107025279B (en) | SCD file online parallel configuration system and method based on database interface layer operation flow | |
| CN112688865B (en) | Design method of OPC UA gateway for graphical online modeling | |
| CN110324169A (en) | A kind of method and apparatus of interface management | |
| CN101022366A (en) | Trouble correlation analytic system and method | |
| CN106021370A (en) | Memory database instance management method and device | |
| CN112367211B (en) | Method, device and storage medium for generating configuration template by device command line | |
| CN104423982B (en) | The processing method and processing equipment of request | |
| CN102891768A (en) | Method and network element for network management | |
| CN102355499B (en) | Cloud computing system | |
| CN101291253A (en) | Man-machine command interaction method for network management terminal based on graphical interface | |
| CN110138876A (en) | Task deployment method, apparatus, equipment and platform | |
| CN108446327A (en) | Operation system dynamic creation method, device, computer equipment and storage medium | |
| CN110489812A (en) | Multilayer level netlist processing method, device, computer equipment and storage medium | |
| CN113672240A (en) | Container-based multi-machine-room batch automatic deployment application method and system | |
| CN113094355A (en) | Model instantiation method, device, equipment and medium based on domestic communication protocol | |
| CN116708266A (en) | Cloud service topological graph real-time updating method, device, equipment and medium | |
| CN109445384B (en) | Multi-device control system | |
| CN103399776A (en) | Creation method and system for reusable MOCK | |
| CN106990974A (en) | A kind of APP applications update method, device and electronic equipment | |
| CN101968747B (en) | Cluster application management system and application management method thereof | |
| CN111045928A (en) | Interface data testing method, device, terminal and storage medium | |
| WO1995008794A1 (en) | A management agent system for the support of multiple network managers, and a method for operating such a system | |
| CN115688495A (en) | Distributed LVC simulation system collaborative planning method, server and storage medium | |
| CN101145959A (en) | A method and system for automatic realization of network management function | |
| CN115293365A (en) | Management method, device, management platform and storage medium of machine learning model |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |