Forwarding point table generation method and terminal equipment

Abstract

The invention belongs to the technical field of power systems, and provides a forwarding point table generation method and terminal equipment applied to a telecontrol system.The method comprises the steps that all signals of a substation and a signal code corresponding to each signal are sent to a power dispatching master station; the power dispatching master station is used for generating a substation forwarding point table according to all the signals of the substation and the signal code corresponding to each signal; receiving a substation forwarding point table, and detecting a forwarding point table data table in a substation database; if it is detected that data exist in the forwarding point table data table, the substation forwarding point table is compared with the forwarding point table data table; and based on the comparison result, updating the forwarding point table data table to obtain the forwarding point table. According to the method and the device, the forwarding point table of the telecontrol system can be automatically generated, automation of data forwarding configuration of the telecontrol system is realized, the efficiency of forwarding point table configuration is improved, the error rate is reduced, and the operation and maintenance efficiency and the equipment operation reliability are improved.

Description

Technical Field

[0001] The present application belongs to the technical field of power systems, and in particular, relates to a forwarding point table generation method and terminal equipment. Background Art

[0002] In the field of power industry, substation is a key node in the power grid structure, playing a core role in power transmission and distribution. Its stable operation plays an important supporting role in the development of strong smart grid. The stable operation of substation is inseparable from the telecontrol system in the station. Substation (i.e. the telecontrol system of substation) is one of the key technologies in the management of modern power system. It realizes the remote monitoring, control and data collection functions of substation. By integrating computer technology, communication technology and control technology, the system establishes an instant and accurate information exchange bridge between the power grid dispatching center and the widely distributed substations, ensuring the safe and efficient operation of the power system.

[0003] At present, the substation and the power dispatching main station mainly exchange information through the DL / T 634.5104 protocol. The substation sends data to the dispatching center by manually configuring the 104 forwarding signal. Manual configuration requires technicians to select one by one according to the signal point table. For large substations, the number of signals is huge, and this process is extremely time-consuming and labor-intensive, and inefficient. At the same time, manual operation inevitably introduces errors, such as configuration omissions and missetting parameters. These errors may cause data transmission errors, control command failures, and even affect the safe and stable operation of the power grid. Repairing errors requires additional time and labor costs.

[0004] Therefore, using automated means to generate forwarding point tables to replace manual configuration has become an inevitable trend in the development of modern substation telecontrol systems. Summary of the invention

[0005] In view of this, an embodiment of the present application provides a forwarding point table generation method and a terminal device, which can solve the problems of high error rate and low efficiency caused by manually configuring the forwarding point table.

[0006] A first aspect of an embodiment of the present application provides a method for generating a forwarding point table, which is applied to a telecontrol system, and the method includes:

[0007] Sending all signals of the substation and the signal code corresponding to each signal to the power dispatching master station; wherein the power dispatching master station is used to generate a substation forwarding point table according to all signals of the substation and the signal code corresponding to each signal, and send it to the substation;

[0008] receiving the substation forwarding point table, and detecting the forwarding point table data table in the substation database;

[0009] If it is detected that there is data in the forwarding point table data table, the substation forwarding point table is compared with the forwarding point table data table;

[0010] Based on the comparison result, the forwarding point table data table is updated to obtain a forwarding point table.

[0011] The second aspect of an embodiment of the present application provides a terminal device, including a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the steps of the forwarding point table generation method provided in the first aspect of the embodiment of the present application are implemented.

[0012] The first aspect of the embodiment of the present application provides a forwarding point table generation method, which is applied to a telecontrol system, by sending all the signals of the substation and the signal code corresponding to each signal to the power dispatching master station; wherein the power dispatching master station is used to generate a substation forwarding point table according to all the signals of the substation and the signal code corresponding to each signal and send it to the substation; receive the substation forwarding point table, and detect the forwarding point table data table in the substation database; if it is detected that there is data in the forwarding point table data table, compare the substation forwarding point table with the forwarding point table data table; based on the comparison result, update the forwarding point table data table to obtain a forwarding point table. The forwarding point table of the telecontrol system can be automatically generated, and the data forwarding configuration of the telecontrol system can be automated and intelligent, which improves the efficiency of the forwarding point table configuration, reduces the error rate, and improves the operation and maintenance efficiency and equipment operation reliability.

[0013] It can be understood that the beneficial effects of the second to fourth aspects mentioned above can be found in the relevant description of the first aspect mentioned above, and will not be repeated here. BRIEF DESCRIPTION OF THE DRAWINGS

[0014] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative work.

[0015] Figure 1 This is a flow chart of a method for generating a forwarding point table provided in an embodiment of the present application;

[0016] Figure 2 It is a flowchart of a method for generating a forwarding point table provided by another embodiment of the present application;

[0017] Figure 3 This is a schematic diagram of updating a forwarding point table data table provided by an embodiment of the present application;

[0018] Figure 4 It is a flowchart of a method for generating a forwarding point table provided by another embodiment of the present application;

[0019] Figure 5 It is a schematic diagram of updating the forwarding point table data table provided by another embodiment of the present application;

[0020] Figure 6 It is a flowchart of a method for generating a forwarding point table provided by another embodiment of the present application;

[0021] Figure 7 It is a structural diagram of a forwarding point table generating device provided in an embodiment of the present application;

[0022] Figure 8 It is a schematic diagram of the structure of the terminal device provided in an embodiment of the present application. DETAILED DESCRIPTION

[0023] In the following description, specific details such as specific system structures, technologies, etc. are provided for the purpose of illustration rather than limitation, so as to provide a thorough understanding of the embodiments of the present application. However, it should be clear to those skilled in the art that the present application may also be implemented in other embodiments without these specific details. In other cases, detailed descriptions of well-known systems, devices, circuits, and methods are omitted to prevent unnecessary details from obstructing the description of the present application.

[0024] It should be understood that when used in the present specification and the appended claims, the term "comprising" indicates the presence of described features, wholes, steps, operations, elements and / or components, but does not exclude the presence or addition of one or more other features, wholes, steps, operations, elements, components and / or combinations thereof.

[0025] It should also be understood that the term “and / or” used in the specification and appended claims refers to any and all possible combinations of one or more of the associated listed items, and includes these combinations.

[0026] As used in the specification and appended claims of this application, the term "if" can be interpreted as "when" or "uponce" or "in response to determining" or "in response to detecting", depending on the context. Similarly, the phrase "if it is determined" or "if [described condition or event] is detected" can be interpreted as meaning "uponce it is determined" or "in response to determining" or "uponce [described condition or event] is detected" or "in response to detecting [described condition or event]", depending on the context.

[0027] In addition, in the description of the present application specification and the appended claims, the terms "first", "second", "third", etc. are only used to distinguish the descriptions and cannot be understood as indicating or implying relative importance.

[0028] References to "one embodiment" or "some embodiments" etc. described in the specification of this application mean that one or more embodiments of the present application include specific features, structures or characteristics described in conjunction with the embodiment. Therefore, the statements "in one embodiment", "in some embodiments", "in some other embodiments", "in some other embodiments", etc. that appear in different places in this specification do not necessarily refer to the same embodiment, but mean "one or more but not all embodiments", unless otherwise specifically emphasized in other ways. The terms "including", "comprising", "having" and their variations all mean "including but not limited to", unless otherwise specifically emphasized in other ways.

[0029] The forwarding point table generation method of image data provided in the embodiment of the present application is applied to the telecontrol system and can be executed by the processor of the terminal device when running a computer program with corresponding functions, by sending all the signals of the substation and the signal code corresponding to each signal to the power dispatching main station; wherein the power dispatching main station is used to generate the substation forwarding point table and send it to the substation according to all the signals of the substation and the signal code corresponding to each signal; receive the substation forwarding point table and detect the forwarding point table data table in the substation database; if it is detected that there is data in the forwarding point table data table, the substation forwarding point table is compared with the forwarding point table data table; based on the comparison result, the forwarding point table data table is updated to obtain the forwarding point table. The forwarding point table of the telecontrol system can be automatically generated, and the data forwarding configuration of the telecontrol system can be automated and intelligent, which improves the efficiency of the forwarding point table configuration, reduces the error rate, and improves the operation and maintenance efficiency and equipment operation reliability.

[0030] In the application, the terminal device can be any computing device such as a telecontrol terminal unit, a measurement and control device, a communication management machine or a communication controller, a protection device, an electric meter, a data acquisition and monitoring system in a telecontrol system, for example, a personal computer (PC), a server, etc. The embodiments of the present application do not impose any restrictions on the specific type of the terminal device.

[0031] like Figure 1 As shown, the forwarding point table generation method provided in the embodiment of the present application includes the following steps S101 to S104:

[0032] Step S101, sending all signals of the substation and the signal code corresponding to each signal to the power dispatching master station; wherein the power dispatching master station is used to generate a substation forwarding point table according to all signals of the substation and the signal code corresponding to each signal and send it to the substation.

[0033] In the application, the terminal equipment of the telecontrol system can obtain all signals and the signal codes corresponding to each signal from the forwarding point table data table of the substation database through functions such as INTO OUTFILE, and send them to the power dispatching master station in a csv format. Among them, the signals may include but are not limited to switch status, circuit breaker position, relay protection action, telemetry data (such as voltage, current, power, etc.) and other important information. Signal coding is to ensure that each signal has a unique identifier in the system to facilitate subsequent data processing and identification.

[0034] In the application, the signal coding can be obtained based on the "Digital Design Coding Specifications for Substation Secondary Systems", and is composed of at least one of the start code, secondary system identification code, voltage level code, interval name code, connector, device type code, and signal type code. For example, for a virtual interval, its voltage level code can be empty.

[0035] In the application, the power dispatching master station can select the required signals from all the signals and signal codes sent by the substation according to the power system operation requirements, dispatching procedures and standards, power grid topology, accident handling plans, data communication protocols, historical data and experience, system capacity and resource limitations, and recommendations of equipment manufacturers and suppliers, and generate the final substation forwarding point table and send it to the substation. Among them, the power system operation requirements mainly include real-time monitoring of key operating parameters such as the status of circuit breakers, line current, voltage level, transformer load conditions, etc., as well as various data indicators required for safe and stable operation of the power grid. Dispatching procedures and standards mainly include the monitoring signal requirements specified by national and local standards and the monitoring signal list clearly specified in technical regulations such as the "Power System Dispatching Regulations". The power grid topology determines the location and importance of key nodes and equipment, thereby selecting specific signals that need to be monitored. The accident handling plan requires the relevant protection action signals and tripping signals required to quickly locate the problem and take measures. In terms of data communication protocols, different protocols have different requirements for signal encoding and transmission, such as IEC 60870-5-101 / 104, IEC 61850, etc. Historical data and experience show that signals that have had problems or frequently changed in historical operating data can also be included in the monitoring scope. System capacity and resource limitations require the selection of the most important signals for monitoring when data processing capabilities and communication bandwidth are limited. The recommendations of equipment manufacturers and suppliers for the most critical signals for equipment operation can also be used as a reference for screening signals.

[0036] In the application, when the power dispatching master station matches the required signal from all the signals sent by the substation, it generates a substation forwarding point table based on each signal and the signal coding and forwarding point number of the signal and sends it to the substation.

[0037] In the application, when the equipment of the substation changes or is upgraded, the telecontrol system timely updates the signal and signal coding and sends it to the power dispatching master station, which can ensure that the power dispatching master station has the latest equipment status and power grid operation status, which helps to maintain the data consistency between the substation and the dispatching master station, and reduces the time and possibility of errors in manual adjustments. Through accurate management and timely updating of signals, the allocation of power resources can be better optimized to ensure the economic operation of the power system.

[0038] Step S102: Receive the substation forwarding point table, and detect the forwarding point table data table in the substation database.

[0039] In the application, after receiving the substation forwarding point table, the forwarding point table data table in the substation database is checked to confirm whether data has been written into the forwarding point table data table, so that different update strategies can be adopted according to whether data has been written.

[0040] Step S103: If it is detected that there is data in the forwarding point table data table, the substation forwarding point table is compared with the forwarding point table data table.

[0041] In the application, if data is detected in the forwarding point table data table, the substation forwarding point table needs to be compared with the forwarding point table data table to confirm the difference between the substation forwarding point table and the forwarding point table data table, so that different update strategies can be adopted according to different differences.

[0042] Step S104: Based on the comparison result, the forwarding point table data table is updated to obtain a forwarding point table.

[0043] In the application, after comparing the substation forwarding point table with the forwarding point table data table, if they are completely consistent, there is no need to update the forwarding point table data table. If there are differences, the forwarding point table data table is updated according to the difference object using the corresponding update strategy to ensure that the forwarding point table in the substation database is the latest and accurate version.

[0044] The embodiment of the present application ensures the correctness of signal transmission between the power dispatching master station and the substation, avoiding erroneous operation or other problems caused by signal mismatch. The method realizes the automatic generation of the forwarding point table, helps to improve the maintenance efficiency of the system, reduces the frequency of manual intervention, and thus improves the reliability and stability of the entire power dispatching system.

[0045] In one embodiment, the data in the forwarding point table data table and the substation forwarding point table include one or more signal entries, and the signal entry includes a forwarding point number. Step S103 includes the following step S201:

[0046] Step S201: If it is detected that there is data in the forwarding point table data table, the forwarding point numbers in the substation forwarding point table and the forwarding point table data table are compared.

[0047] In the application, when there is data in the forwarding point table data table, the forwarding point numbers in the substation forwarding point table and the forwarding point table data table are compared one by one. When the same forwarding point number exists in both tables, it is considered that the forwarding point numbers are consistent.

[0048] In one embodiment, the data in the device signal table includes one or more signal entries, and the signal entries in the forwarding point table data table, the substation forwarding point table, and the device signal table include signal codes. Figure 2 As shown, step S104 includes the following steps S301 to S305:

[0049] Step S301: If the comparison result of the forwarding point number is that the forwarding point number in the substation forwarding point table exists in the forwarding point table data table, then compare the signal codes corresponding to the forwarding point numbers in the substation forwarding point table and the forwarding point table data table.

[0050] In an application, for example, if both the substation forwarding point table and the forwarding point table data table have forwarding point number 2, the signal codes corresponding to the forwarding point number 2 in the substation forwarding point table and the forwarding point table data table are compared.

[0051] Step S302: If the signal codes are compared and found to be consistent, the signal entry corresponding to the signal code in the forwarding point table data table is not updated.

[0052] Step S303: If the signal codes are not consistent after comparison, the device signal table in the substation database is traversed using the signal codes.

[0053] In applications, such as Figure 3 As shown, the signal code corresponding to forwarding point number 2 in the forwarding point table data table is = KDB01 + PYX002, while the signal code corresponding to forwarding point number 2 in the substation forwarding point table is = KDB01 + PYX004, and the signal codes of the two are inconsistent. Then the signal code = KDB01 + PYX004 is used to traverse the device signal table in the substation database.

[0054] Step S304: If the signal code is matched in the device signal table, the signal entry corresponding to the signal code in the device signal table is used to update the signal entry corresponding to the forwarding point number in the forwarding point table data table.

[0055] In the application, there is a signal entry in the device signal table: 220kVⅠ mother protection device remote signal 4YX004=KDB01+PYX004, so that the signal code=KDB01+PYX004 can be matched in the device signal table, and the signal entry: 220kVⅠ mother protection device remote signal 4YX004=KDB01+PYX004 is used to replace the signal entry corresponding to the forwarding point number 2: 220kVⅠ mother protection device remote signal 2=KDB01+PYX002, so as to realize the update of the signal entry corresponding to the forwarding point number 2 in the forwarding point table data table.

[0056] Step S305: Use the updated forwarding point table data table as the forwarding point table.

[0057] In the application, after comparing one by one using the forwarding point numbers, the latest forwarding point table data table, ie, the forwarding point table, can be obtained by updating through the method of the above steps.

[0058] In one embodiment, the data in the device signal table includes one or more signal entries, and the signal entries in the forwarding point table data table, the substation forwarding point table, and the device signal table include signal codes. Figure 4 As shown, step S104 includes the following steps S401 to S403:

[0059] Step S401: If the comparison result of the forwarding point number is that the forwarding point number in the substation forwarding point table does not exist in the forwarding point table data table, the device signal table in the substation database is traversed using the signal code corresponding to the forwarding point number.

[0060] In applications, such as Figure 5 As shown, the forwarding point number 3 in the substation forwarding point table does not exist in the forwarding point table data table, then the signal code 220kVⅠ mother protection device remote signal 3=KDB01+PYX003 corresponding to the forwarding point number 3 is used to traverse the device signal table in the substation database.

[0061] Step S402: If a signal code is matched in the device signal table, a signal entry corresponding to the signal code in the device signal table is added to the forwarding point table data table.

[0062] In the application, the device signal table includes a signal entry: 220kVⅠ mother protection device remote signal 3YX003=KDB01+PYX003, so that the signal code=KDB01+PYX003 can be matched in the device signal table, and the signal entry corresponding to the signal code in the device signal table, i.e. 220kVⅠ mother protection device remote signal 3YX003=KDB01+PYX003, is added to the forwarding point table data table to form a new entry in the forwarding point table data table.

[0063] Step S403: Use the updated forwarding point table data table as the forwarding point table.

[0064] In the application, after comparing one by one using the forwarding point numbers, the latest forwarding point table data table, ie, the forwarding point table, can be obtained by updating through the method of the above steps.

[0065] In one embodiment, the data in the device signal table includes one or more signal entries, the signal entries in the device signal table include signal codes, and the signal entries in the forwarding point table data table and the substation forwarding point table include forwarding point numbers and signal codes. After step S102, the following steps S501 to S503 are also included:

[0066] Step S501: If it is detected that there is no data in the forwarding point table data table, the data in the substation forwarding point table is imported into a temporary table in the substation database.

[0067] In the application, when it is detected that there is no data in the forwarding point table data table, an empty temporary table is created in the substation database, and the data in the substation forwarding point table is imported into the temporary table in the substation database.

[0068] Step S502: According to the sorting rule of the forwarding point numbers, the forwarding point numbers are sequentially selected in the temporary table, and the device signal table in the substation database is traversed using the signal codes corresponding to the forwarding point numbers.

[0069] In the application, in the substation, the forwarding point number has a certain sorting rule. The forwarding point number is selected from the temporary table in the order specified by the forwarding point number sorting rule, and the signal code corresponding to the forwarding point number is used to traverse the device signal table in the substation database. For example, if the sorting rule is forwarding point number 1, 2, 3..., first select the signal code corresponding to forwarding point number 1 from the temporary table to traverse the device signal table in the substation database, and execute step S503, and then return to step S502; then select the signal code corresponding to forwarding point number 2 to traverse the device signal table in the substation database, and execute step S503, and then return to step S502; then select the signal code corresponding to forwarding point number 3 to traverse the device signal table in the substation database, and execute step S503, and then return to step S502... until all forwarding point numbers are selected.

[0070] Step S503: If the signal code is matched in the device signal table, the signal entry corresponding to the signal code in the device signal table is added to the forwarding point table data table.

[0071] In the application, since there is no data in the forwarding point table data table, each time a signal code is matched, a signal entry corresponding to the signal code is added to the forwarding point table data table to update the forwarding point table data table.

[0072] In one embodiment, for a newly built substation, a renovated or expanded substation, before step S101, the following steps S601 and S602 are included:

[0073] Step S601: In response to the user's import operation, the device models corresponding to all devices in the telecontrol system that need to communicate are imported.

[0074] In the application, the substation database should contain the fields required to generate the full signal coding format. After the substation imports the full device model in the station, it generates the corresponding codes for all signals. The configuration tool software program can be run on the terminal device of the substation, and the device models corresponding to all devices that need to communicate in the dynamic system can be imported into the configuration tool software program. The device model should include all the telesignaling, telemetering, remote control, and telepulse signals that can be uploaded by the device. After the substation configuration tool imports the device model, it generates the signal table of the configuration tool according to the signal sorting in the model, and automatically generates the corresponding signal type code according to the signal sorting in the model.

[0075] Step S602: In response to the user's configuration operation, construct a substation database or update the substation database.

[0076] Among them, when the substation is a newly built substation, the substation database is constructed; when the substation is a renovated or expanded substation, the substation database is updated;

[0077] Build the subsite database, including:

[0078] Writing coded data into different fields of the table template based on the device model and the substation specification to form a device model table, a device signal table and a forwarding point table data table of the substation;

[0079] Update the substation database, including:

[0080] Based on the device model and substation specifications, the device model table, device signal table and forwarding point table data tables of the substation before transformation or expansion are expanded and / or updated by writing and / or modifying coded data into different fields of the table to obtain the device model table, device signal table and forwarding point table data tables of the substation after transformation or expansion.

[0081] In the application, you can set the voltage level, bay type, device type, etc. of all devices in the configuration tool. The setting rules are set by drop-down options based on the corresponding field rules in the device model table. For a newly built substation, the substation database only contains blank table templates, and there is no data in the table templates. After writing data into different table templates, the device model table, device signal table, and forwarding point table data tables are obtained respectively.

[0082] In the application, the table structure of the table template of the device model table includes the fields of device ID (UnitID), voltage level (VoltageLevel), interval name, and device type (DevType). By assigning values ​​to the corresponding fields (i.e., writing data) through the contents recorded in the coding rule table of different fields in the substation specification, the device model table for storing the voltage level, interval name, and device type of the substation communication device can be obtained. Among them, the substation specification can be the "Digital Design Coding Specification for Substation Secondary System", and the coding rule table of the voltage level field in the substation specification is shown in Table 1, the coding rule table of the interval name field is shown in Table 2, the coding rule table of the virtual interval is shown in Table 3, and the coding rule table of the device type is shown in Table 4.

[0083] Table 1

[0084]

[0085] Table 2

[0086]

[0087]

[0088] Table 3

[0089]

[0090]

[0091] Table 4

[0092] type character Protective devices P Measurement and control device C Integrated protection and testing device PC Data communication gateway D server A Operator / engineer station E Telecontrol workstation Y Protocol Converter H switch S Time synchronization device TI Secondary security system DS Arrester online monitoring device BJ GIS partial discharge online monitoring G Main transformer online monitoring device T SF6 density online monitoring device SF Fiber Optic Temperature Measurement System GT Relay protection online monitoring device R Security System AF Fire alarm device XF Video surveillance system V Environmental Monitoring System U DC Power Supply Z AC Power J Fault recording device F Fault distance measuring device FJ Network message recording and analysis device N Power voltage quality monitoring device PQ Synchronous phasor measurement device W Electricity meter I Communications equipment O

[0093] In the application, the table templates of the device signal table include the telesignal signal (YxSignal) table template, the telemetry signal (YcSignal) table template, the remote control signal (YkSignal) table template, and the remote pulse signal (YmSignal) table template. The table structure of each table template contains at least the device ID, signal name (SingalDes), signal type (SingalType) and signal code (SignalCode) fields, wherein the signal type field is assigned according to the signal type coding rule, and finally the device signal table is obtained. The signal type coding rule table is shown in Table 5.

[0094] Table 5

[0095]

[0096] In the application, the table templates of the forwarding point table data table include the telesignal signal (YxSignal) table template, the telemetry signal (YcSignal) table template, the remote control signal (YkSignal) table template, and the remote pulse signal (YmSignal) table template. The table structure of each table template at least includes the forwarding point number (FPnumber), device ID, signal name, and signal coding field. After writing data to each table template in the forwarding point table data table, the telesignal signal table, telemetry signal table, remote control signal table, and remote pulse signal table can be obtained to store the signals finally forwarded to the master station and the corresponding signal attributes.

[0097] In the application, for the expanded substation, the device model table, device signal table and forwarding point table data table of the substation database have stored the relevant data obtained from the last configuration. During the expansion, the relevant data of the original table is updated or expanded according to the device model of the expanded substation. Among them, updating means that when the content of the record changes, the original content is replaced with the new content. Expansion means that when there is content not recorded in the table, the new content is entered into the corresponding field of the table.

[0098] In one embodiment, before step S101, the following step S701 is also included:

[0099] Step S701: In response to a signal code generation operation of a user, signal codes of all signals of a substation are generated;

[0100] Among them, the signal code includes a start code, a secondary system identification code, a voltage level code, an interval name code, a connector, a device type code and a signal type code arranged in sequence.

[0101] In the application, the user can use the SQL command of the configuration tool to combine the signal coding format related fields in each data table based on the device model table and device signal table in the substation database using functions such as CONCAT to obtain the signal coding of each signal.

[0102] In applications, such as Figure 6 As shown, the start code can be "=", the secondary system identification code can be "K", and the connector can be "+". These three are fixed codes and are the same in the signal coding of each signal. The voltage level code, interval name code, device type code and signal type code have the same or different codes according to different signals. The start code, secondary system identification code, voltage level code, interval name code, connector, device type code and signal type code are arranged in sequence from the starting end.

[0103] The embodiment of the present application standardizes the format of signal encoding based on the specifications of the substation, so as to digitize and standardize the substation signals and facilitate the management of the substation.

[0104] In one embodiment, step S701 includes the following steps S801 to S803:

[0105] Step S801: Obtain the voltage level code, interval name code, and device type code corresponding to the device ID from the device model table.

[0106] Step S802: Obtain the signal type code corresponding to the device ID from the device signal table.

[0107] Step S803: Combine the voltage level code, interval name code, device type code, signal type code, start code, secondary system identification code and connector in a specified order to obtain a signal code of the signal corresponding to the device ID.

[0108] In the application, taking the generation of a full signal code of a telesignaling signal as an example, the substation configuration tool can generate the full signal code through the following SQL command as follows:

[0109] UPDATE tableYxSignal

[0110] SET AllSignalCode=CONCAT('=K',

[0111] (SELECT VoltageLevel FROM tableUnit WHERE tableUnit.UnitID=tableYxSignal.UnitID),

[0112] (SELECT IntervalType FROM tableUnit WHERE tableUnit.UnitID=tableYxSignal.UnitID),

[0113] '+',

[0114] (SELECT DevType FROM tableUnit WHERE tableUnit.UnitID=tableYxSignal.UnitID),

[0115] tableYxSignal.SingalType)

[0116] WHERE EXISTS(SELECT 1FROM tableUnit WHERE tableUnit.UnitID=tableYxSignal.UnitID).

[0117] In one embodiment, after step S104, the following steps S901 and S902 are included:

[0118] Step S901, compare the forwarding point numbers in the forwarding point table data table, the substation forwarding point table, and the signal codes corresponding to the forwarding point numbers;

[0119] Step S902: Generate and output comparison results.

[0120] In the application, the configuration tool can be used to compare the forwarding point table data table, the forwarding point numbers in the substation forwarding point table, and the signal encoding corresponding to the forwarding point numbers to see if they are consistent, and generate csv format comparison results for storage and output, which can be used for manual review to confirm that the forwarding point table of the substation is generated correctly, and can be archived as a credential.

[0121] In one embodiment, a final substation-readable configuration file may also be generated through a configuration tool and downloaded to the substation so that the substation can update corresponding content.

[0122] It should be understood that the size of the serial numbers of the steps in the above embodiments does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of the present application.

[0123] The embodiment of the present application also provides a forwarding point table generation device, which is used to execute the steps in the forwarding point table generation method embodiment. The forwarding point table generation device can be a virtual appliance in the terminal device, which is run by the processor of the terminal device, or it can be the terminal device itself.

[0124] like Figure 7 As shown, the forwarding point table generating device 100 provided in the embodiment of the present application includes:

[0125] The sending module 101 is used to send all the signals of the substation and the signal code corresponding to each signal to the power dispatching master station; wherein the power dispatching master station is used to generate a substation forwarding point table according to all the signals of the substation and the signal code corresponding to each signal, and send it to the substation;

[0126] The receiving module 102 is used to receive the substation forwarding point table and detect the forwarding point table data table in the substation database;

[0127] The comparison module 103 is used to compare the substation forwarding point table with the forwarding point table data table if it is detected that there is data in the forwarding point table data table;

[0128] The forwarding point table generating module 104 updates the forwarding point table data table based on the comparison result to obtain a forwarding point table.

[0129] In application, each module in the forwarding point table generating device may be a software program module, or may be implemented by different logic circuits integrated in a processor, or may be implemented by multiple distributed processors.

[0130] like Figure 8 As shown, the embodiment of the present application further provides a terminal device 200, including: at least one processor 201 ( Figure 8 Only one processor is shown in the figure), a memory 202, and a computer program 203 stored in the memory 202 and executable on at least one processor 201, wherein the processor 201 implements the steps in the above-mentioned various method embodiments when executing the computer program 203.

[0131] In the application, the terminal device may include, but is not limited to, a processor and a memory. Those skilled in the art will understand that Figure 7 It is only an example of a terminal device and does not constitute a limitation on the terminal device. The terminal device may include more or fewer components than shown in the figure, or a combination of certain components, or different components.

[0132] In applications, the processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. A general-purpose processor may be a microprocessor or the processor may be any conventional processor, etc.

[0133] In applications, the memory may be an internal storage unit of a terminal device in some embodiments, such as a hard disk or memory of the terminal device. In other embodiments, the memory may also be an external storage device of the terminal device, such as a plug-in hard disk, a smart memory card (Smart Media Card, SMC), a secure digital (SecureDigital, SD) card, a flash card (Flash Card), etc. equipped on the terminal device. Further, the memory may also include both an internal storage unit of the terminal device and an external storage device. The memory is used to store an operating system, an application program, a boot loader (BootLoader), data, and other programs, such as program codes of a computer program. The memory may also be used to temporarily store data that has been output or is to be output.

[0134] It should be noted that the information interaction, execution process, etc. between the above-mentioned devices / units are based on the same concept as the method embodiment of the present application. Their specific functions and technical effects can be found in the method embodiment part and will not be repeated here.

[0135] The technicians in the relevant field can clearly understand that for the convenience and simplicity of description, only the division of the above-mentioned functional units and modules is used as an example for illustration. In practical applications, the above-mentioned function allocation can be completed by different functional units and modules as needed, that is, the internal structure of the device can be divided into different functional units or modules to complete all or part of the functions described above. The functional units and modules in the embodiment can be integrated in a processing unit, or each unit can exist physically separately, or two or more units can be integrated in one unit. The above-mentioned integrated unit can be implemented in the form of hardware or in the form of software functional units. In addition, the specific names of the functional units and modules are only for the convenience of distinguishing each other, and are not used to limit the scope of protection of this application. The specific working process of the units and modules in the above-mentioned system can refer to the corresponding process in the aforementioned method embodiment, which will not be repeated here.

[0136] The embodiment of the present application further provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments can be implemented.

[0137] An embodiment of the present application provides a computer program product. When the computer program product runs on a terminal device, the terminal device can implement the steps in the above-mentioned method embodiments when executing the computer program product.

[0138] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present application implements all or part of the processes in the above-mentioned embodiment method, which can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a computer-readable storage medium. When the computer program is executed by the processor, the steps of the above-mentioned various method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may at least include: any entity or device that can carry the computer program code to the device / terminal device, a recording medium, a computer memory, a read-only memory (ROM, Read-Only Memory), a random access memory (RAM, Random Access Memory), an electric carrier signal, a telecommunication signal, and a software distribution medium. For example, a USB flash drive, a mobile hard disk, a magnetic disk or an optical disk. In some jurisdictions, according to legislation and patent practice, computer-readable media cannot be electric carrier signals and telecommunication signals.

[0139] In the above embodiments, the description of each embodiment has its own emphasis. For parts that are not described or recorded in detail in a certain embodiment, reference can be made to the relevant descriptions of other embodiments.

[0140] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, or a combination of computer software and electronic hardware. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this application.

[0141] In the embodiments provided in the present application, it should be understood that the disclosed devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of modules or units is only a logical function division, and there may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.

[0142] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

[0143] The above embodiments are only used to illustrate the technical solutions of the present application, rather than to limit them. Although the present application has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or make equivalent replacements for some of the technical features therein. These modifications or replacements do not deviate the essence of the corresponding technical solutions from the spirit and scope of the technical solutions of the embodiments of the present application, and should all be included in the protection scope of the present application.

Claims

1. A method for generating a forwarding point table, characterized in that: Applied to a telecontrol system, the method comprises: Sending all signals of the substation and the signal code corresponding to each signal to the power dispatching master station; wherein the power dispatching master station is used to generate a substation forwarding point table according to all signals of the substation and the signal code corresponding to each signal, and send it to the substation; receiving the substation forwarding point table, and detecting the forwarding point table data table in the substation database; If it is detected that there is data in the forwarding point table data table, the substation forwarding point table is compared with the forwarding point table data table; Based on the comparison result, the forwarding point table data table is updated to obtain a forwarding point table.

2. The method for generating a forwarding point table according to claim 1, wherein: The data in the forwarding point table data table and the substation forwarding point table include one or more signal entries, and the signal entry includes a forwarding point number; If it is detected that there is data in the forwarding point table data table, then comparing the substation forwarding point table with the forwarding point table data table includes: If it is detected that there is data in the forwarding point table data table, the forwarding point numbers in the substation forwarding point table and the forwarding point table data table are compared.

3. The method for generating a forwarding point table according to claim 2, wherein: The signal entries of the forwarding point table data table and the substation forwarding point table also include signal coding; The updating of the forwarding point table data table based on the comparison result to obtain the forwarding point table includes: If the comparison result of the forwarding point number is that the forwarding point number in the substation forwarding point table exists in the forwarding point table data table, then the signal coding corresponding to the forwarding point number in the substation forwarding point table and the forwarding point table data table is compared; If the signal codes are compared to be consistent, then the signal entry corresponding to the signal code in the forwarding point table data table is not updated; If the signal codes are not consistent, the device signal table in the substation database is traversed using the signal codes; If the signal code is matched in the device signal table, the signal entry corresponding to the signal code in the device signal table is used to update the signal entry corresponding to the forwarding point number in the forwarding point table data table; The updated forwarding point table data table is used as the forwarding point table.

4. The method for generating a forwarding point table according to claim 2, wherein: The updating of the forwarding point table data table based on the comparison result to obtain the forwarding point table includes: If the comparison result of the forwarding point number is that the forwarding point number in the substation forwarding point table does not exist in the forwarding point table data table, traversing the device signal table in the substation database using the signal code corresponding to the forwarding point number; If the signal code is matched in the device signal table, adding the signal entry corresponding to the signal code in the device signal table to the forwarding point table data table; Using the updated forwarding point table data table as the forwarding point table; The data in the device signal table includes one or more signal entries, and the signal entries in the forwarding point table data table, the substation forwarding point table and the device signal table include signal codes.

5. The method for generating a forwarding point table according to claim 1, wherein: After receiving the substation forwarding point table sent by the electric power dispatching master station and detecting the forwarding point table data table in the substation database, the method further includes: If it is detected that there is no data in the forwarding point table data table, the data in the substation forwarding point table is imported into a temporary table in the substation database; According to the sorting rule of the forwarding point numbers, the forwarding point numbers are sequentially selected in the temporary table, and the device signal table in the substation database is traversed using the signal codes corresponding to the forwarding point numbers; If the signal code is matched in the device signal table, adding the signal entry corresponding to the signal code in the device signal table to the forwarding point table data table; The data in the device signal table includes one or more signal entries, the signal entries in the device signal table include signal codes, and the signal entries in the forwarding point table data table and the substation forwarding point table include forwarding point numbers and signal codes.

6. The method for generating a forwarding point table according to claim 1, wherein: Before sending all signals of the substation and the signal code corresponding to each signal to the electric power dispatching master station so that the electric power dispatching master station generates a substation forwarding point table, the method includes: In response to the user's import operation, the device models corresponding to all devices that need to communicate in the telecontrol system are imported; In response to a configuration operation by a user, building a substation database or updating the substation database; Wherein, when the substation is a newly built substation, a substation database is constructed; when the substation is a renovated or expanded substation, the substation database is updated; The constructing of the substation database includes: Writing coded data into different fields of the table template based on the device model and the specification of the substation to form a device model table, a device signal table and a forwarding point table data table of the substation; The updating of the substation database includes: Based on the device model and the specifications of the substation, the device model table, device signal table and forwarding point table data table of the substation before the transformation or expansion are expanded and / or updated by writing and / or modifying the coded data into different fields of the table to obtain the device model table, device signal table and forwarding point table data table of the substation after the transformation or expansion.

7. The method for generating a forwarding point table according to claim 6, wherein: Before sending all signals of the substation and the signal code corresponding to each signal to the electric power dispatching master station so that the electric power dispatching master station generates a substation forwarding point table, the method further includes: In response to a signal code generation operation of a user, generating signal codes of all signals of the substation; The signal code includes a start code, a secondary system identification code, a voltage level code, an interval name code, a connector, a device type code and a signal type code arranged in sequence.

8. The method for generating a forwarding point table according to claim 7, wherein: The device model table records the device ID, voltage level code, interval name code, and device type code, and the device signal table records the device ID, signal name, signal type code, and signal code; The step of generating signal codes of all signals of the substation in response to the signal code generating operation of the user comprises: Obtaining the voltage level code, interval name code, and device type code corresponding to the device ID from the device model table; Obtaining a signal type code corresponding to the device ID from the device signal table; The voltage level code, the interval name code, the device type code, the signal type code, the start code, the secondary system identification code and the connector are combined in a specified order to obtain a signal code of the signal corresponding to the device ID.

9. The method for generating a forwarding point table according to claim 1, wherein: The data in the forwarding point table data table and the substation forwarding point table include one or more signal entries, and the signal entry includes a forwarding point number and a signal code; The method of updating the forwarding point table data table based on the comparison result to obtain the forwarding point table includes: Compare the forwarding point table data table, the forwarding point numbers in the substation forwarding point table, and the signal codes corresponding to the forwarding point numbers; Generate and output the comparison result.

10. A terminal device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 9 are implemented.

Images