A method and system for retrieving data from a substation

Abstract

The present invention discloses a substation data service-based access method and system based on DL / T 860 file service, wherein the main station sends an offline data access command to a service gateway in the form of a write file; the service gateway forwards the offline data access command to a comprehensive application host in the form of a write file; the comprehensive application host queries data according to the offline data access command, and forms the query result into a fixed format file; after forming the query result into a fixed format file, the comprehensive application host sends a trigger readiness report to the service gateway; after receiving a read file command, the comprehensive application host accesses the file and sends the accessed file to the service gateway; after receiving the accessed file, the service gateway sends the accessed file to the host. In order to meet the needs of the remote operation and maintenance business of the substation equipment for accessing various types of substation data, the method and system realize the on-demand access of various types of substation data by various services of the main station.

Description

Technical Field

[0001] The invention relates to the technical field of substation management, and in particular to a substation data access method and system. Background Art

[0002] With the full promotion and application of the unmanned substation model, there is an urgent need for remote operation and maintenance services such as remote monitoring, remote equipment status diagnosis, and remote model control of substations. At present, the data interaction between the dispatching and centralized control master station and the substation data communication gateway usually adopts the 104 protocol. The 104 protocol is a process-oriented interaction protocol with poor scalability. The "four remote" data is transmitted in the form of a telecontrol transfer table. Operation and maintenance services such as remote monitoring of substation equipment status and remote equipment diagnosis require the access to substation model files, project backup files, offline historical data, etc. Therefore, the current master-substation data interaction method based on the telecontrol transfer table cannot meet the needs of remote operation and maintenance services of substations. Summary of the invention

[0003] The object of the present invention is to provide a substation data access method and system, which can overcome the defects of the prior art.

[0004] To achieve the above object, the present invention provides a substation data access method, characterized in that the method is executed by a master station and comprises the following steps:

[0005] Send an offline data retrieval command to the service gateway in the form of writing a file;

[0006] Receiving a trigger readiness report sent by a serving gateway;

[0007] After receiving the trigger readiness report, sending a read file command to the serving gateway machine;

[0008] Receive fixed format files sent by the service gateway machine.

[0009] In a preferred embodiment, after sending the offline data access command to the serving gateway machine and before receiving the trigger readiness report sent by the serving gateway machine, the method further includes the following steps:

[0010] Receive the write file response sent by the service gateway machine.

[0011] The present invention provides a substation data access method, characterized in that the method is executed by a service gateway machine, and the method comprises the following steps:

[0012] Receive the offline data access command sent by the master station;

[0013] Forwarding the offline data access command to the integrated application host in the form of writing a file;

[0014] receiving a trigger readiness report sent by the integrated application host;

[0015] After receiving the trigger readiness report, sending the trigger readiness report to the master station;

[0016] Receive a file read command sent by the master station;

[0017] After receiving the read file command, forwarding the read file command to the integrated application host;

[0018] Receive fixed format files sent by the integrated application host.

[0019] In a preferred embodiment, after forwarding the offline data access command to the integrated application host in the form of writing a file, and before receiving a trigger readiness report sent by the integrated application host, the method includes the following steps:

[0020] receiving a file write response sent by the integrated application host;

[0021] After receiving the write file response, forwarding the write file response to the primary station.

[0022] In a preferred embodiment, the main station and the service gateway machine, and the service gateway machine and the comprehensive application host communicate using the DL / T 860 protocol, wherein the service gateway machine adopts the gateway mode to realize the forwarding of data between the main station and the comprehensive application host.

[0023] The present invention provides a substation data access method, characterized in that the method is executed by a comprehensive application host, and the method comprises the following steps:

[0024] Receive an offline data access command sent by a service gateway;

[0025] Query data according to the offline data retrieval command, and compose the query results into a fixed format file;

[0026] After the query results are organized into a fixed format file, a trigger readiness report is sent to the serving gateway machine;

[0027] Receive a file read command sent by the service gateway;

[0028] After receiving the file read command, the fixed format file is retrieved and the retrieved fixed format file is sent to the service gateway machine.

[0029] In a preferred embodiment, after receiving an offline data access command sent by a service gateway machine and before querying data according to the offline data access command, the method includes the following steps:

[0030] Parsing the offline data retrieval command, wherein parsing the offline data retrieval command comprises: checking the offline data retrieval command by acquiring the retrieval condition, time and device in the offline data retrieval command;

[0031] If the offline data retrieval command is parsed successfully, a write file response is sent to the service gateway machine.

[0032] The present invention provides a substation data retrieval system, characterized in that the system comprises:

[0033] Comprehensive application host, the comprehensive application host includes: real-time data acquisition and storage module, file data centralized management tool, substation data retrieval service module, DL / T860 server module and host;

[0034] The real-time data acquisition and storage module is used to collect real-time alarm and sampling value data of primary equipment, secondary equipment and auxiliary equipment, and store them in the history library;

[0035] The file data centralized management tool is used to browse, modify and store model configuration files, wherein the model configuration files include the whole station SCD file, CID file and monitoring system engineering configuration file, and the file data centralized management tool is also used to actively notify the substation data retrieval service module when the file changes;

[0036] The DL / T 860 server module is used to receive the master station data access command file from the service gateway through the DL / T860 protocol, and forward the master station data access file to the substation data access service module;

[0037] The substation data access service module is used to parse the master station access command file, collect the master station access data by reading the model configuration file, the project configuration file and the history library, and organize it into a access result file that meets the requirements; the substation data access service module is also used to send the organized access result file to the DL / T 860 server module,

[0038] The DL / T 860 server module is also used to send to the service gateway machine through the multi-DL / T860 protocol;

[0039] A service gateway machine, the service gateway machine comprising: a DL / T 860 server module, a DL / T 860 client module, a data model module, a data forwarding module and a host;

[0040] The DL / T 860 server module is used to receive the data access command file sent by the master station through the DL / T 860 protocol, parse the DL / T 860 file write message, obtain the file directory, and forward the file directory and data access file to the data forwarding module;

[0041] The data forwarding module is used to identify the comprehensive application host file directory that actually needs to be accessed according to the gateway machine SCD model file, and forward the actual access directory and data access command file to the DL / T 860 client module;

[0042] The DL / T 860 client module is used to generate a DL / T 860 file write message according to the actual integrated application host file access directory, and send the DL / T 860 file write message to the integrated application host.

[0043] In a preferred embodiment, the real-time data acquisition and storage module is further configured to: receive the operating data of the interval layer equipment through the DL / T860 protocol, and the operating data includes: online monitoring information of secondary equipment, wherein the secondary equipment includes: protection, security control and measurement and control equipment; online monitoring information of primary equipment, wherein the primary equipment includes: transformers, circuit breakers, switch cabinets, capacitive equipment and lightning arrester equipment; monitoring data of auxiliary equipment, wherein the auxiliary equipment includes: fire protection, security, dynamic environment and intelligent lock control equipment; online monitoring data and filtering files of intelligent fault filtering devices; wherein the interval layer equipment includes protection, measurement and control and security control devices, online monitoring devices of primary equipment, settlement and metering devices, security, fire protection, and environmental monitoring devices;

[0044] Process data according to business needs and store the processed data in the database;

[0045] The file data centralized management tool is further configured to: automatically collect SCD model files, CID files, monitoring system engineering backup files and device software version files in the station; automatically classify storage and management according to different directories; provide a manual operation interface; and send notifications to the DL / T860 server module when files change.

[0046] In a preferred embodiment, the substation data access service module is further configured to: access model files, and the model file access includes: actively notifying the master station when the station-side SCD file and CID file send changes; when the master station calls the SCD file and CID file, the model file is sent as required; wherein the master station calling the SCD file and CID file is a command initiated by the master station to access the SCD file and CID file;

[0047] The engineering configuration file is retrieved, and the engineering configuration file is retrieved including: actively notifying the master station when the station-side monitoring system engineering backup file and IED software version file send changes; when the master station calls the station-side monitoring system engineering backup file and IED software version file, they are sent up according to the requirements; wherein the master station calling the station-side monitoring system engineering backup file and IED software version file is a command initiated by the master station to retrieve the system engineering backup file and IED software version file;

[0048] Offline historical data retrieval, including: supporting the master station to retrieve the substation primary equipment sampling value, secondary equipment sampling value and alarm history data according to parameters such as substation, equipment, data point time, etc.;

[0049] The DL / T860 server module is further configured to: receive an offline data access command from a service gateway machine via the DL / T 860 protocol, and send a data access result to the service gateway machine via the DL / T 860 protocol;

[0050] The DL / T 860 server module of the service gateway is further configured to: receive connection requests from all master stations through the DL / T 860 protocol and establish associations with the master station, provide a substation data offline data access service interface, and support the master station to access the substation primary equipment sampling values, secondary equipment sampling values ​​and alarm history data according to the substation, equipment, data point and time;

[0051] The DL / T 860 client module is further configured to: establish association with the integrated application host through the DL / T 860 protocol, read and write, control, enable reporting, and receive reports or files on the integrated application host;

[0052] The data forwarding module is further configured to: transmit data between the DL / T 860 server module and the DL / T 860 client module, complete model mapping, file directory parsing and data storage.

[0053] Compared with the prior art, the present invention has the following advantages: in order to meet the needs of remote operation and maintenance of substation equipment for accessing various types of substation data, the present invention provides a substation offline data service access method and system, which enables the on-demand access of various types of substation data by various services of the master station. BRIEF DESCRIPTION OF THE DRAWINGS

[0054] Figure 1 is a schematic diagram of a system architecture according to an embodiment of the present invention.

[0055] Figure 2 is an information transmission flow chart according to an embodiment of the present invention. DETAILED DESCRIPTION

[0056] The specific implementation modes of the present invention are described in detail below in conjunction with the accompanying drawings, but it should be understood that the protection scope of the present invention is not limited by the specific implementation modes.

[0057] Unless explicitly stated otherwise, throughout the specification and claims, the term “comprise” or variations such as “include” or “comprising”, etc., will be understood to include the stated elements or components but not to exclude other elements or components.

[0058] Figure 1 It is a schematic diagram of the system architecture according to an embodiment of the present invention. As shown in the figure, the system of the present invention includes a service gateway machine and a comprehensive application host. The service gateway machine and the comprehensive application host are deployed in the safety II zone of the substation and are connected through the station control layer bus. The comprehensive application host includes: real-time data acquisition, storage module, file data centralized management tool, substation data retrieval service module and DL / T860 server module; the service gateway machine includes: DL / T 860 server module, DL / T 860 client module, data model module and data forwarding module.

[0059] The real-time data acquisition and storage module is further configured to: receive the operation data of the bay layer equipment through the DL / T860 protocol, and the operation data includes: online monitoring information of secondary equipment, wherein the secondary equipment includes: protection, security control and measurement and control equipment; online monitoring information of primary equipment, wherein the primary equipment includes: transformers, circuit breakers, switch cabinets, capacitive equipment and lightning arrester equipment; monitoring data of auxiliary equipment, wherein the auxiliary equipment includes: fire protection, security, dynamic environment and intelligent lock control equipment; online monitoring data and filter files of intelligent fault filtering device;

[0060] Process data according to business needs and store the processed data in the database;

[0061] The centralized file data management tool is further configured to: collect SCD model files, CID files, monitoring system engineering backup files, and device software version files within the station; store and manage them according to different directory categories; provide a manual operation interface; and send notifications to the DL / T860 server module when files change.

[0062] The substation data retrieval service module is further configured as: model file retrieval, model file retrieval includes: actively notifying the main station when the station-side SCD file and CID file send changes; when the main station calls for the SCD file and CID file, the model file is sent as required; the service gateway machine is configured to perform the following operations: receiving a file change notification report sent by the integrated application host; after receiving the file change notification report, sending a file change notification to the main station; after sending the file change notification to the host, receiving a file read command sent by the host.

[0063] Engineering configuration file review, including: actively notifying the master station when the station-side monitoring system engineering backup file and IED software version file are changed; when the master station calls for the station-side monitoring system engineering backup file and IED software version file, they are sent up as required;

[0064] Offline historical data retrieval, including: support the master station to retrieve the substation primary equipment sampling value, secondary equipment sampling value and alarm history data according to substation, equipment, data point, time and other parameters;

[0065] The DL / T860 server module is further configured to: receive an offline data retrieval command from the service gateway machine via the DL / T 860 protocol, and send a data retrieval result to the service gateway machine via the DL / T 860 protocol.

[0066] The DL / T 860 server module of the service gateway is further configured to: receive all connection requests from the master station through the DL / T 860 protocol and establish an association with the master station, provide an offline data retrieval service interface for substation data, and support the master station to retrieve the substation primary equipment sampling values, secondary equipment sampling values ​​and alarm history data according to substation, equipment, data point and time.

[0067] The DL / T 860 client module is further configured to: establish an association with the integrated application host through the DL / T 860 protocol, read and write, control, enable reporting, and receive reports or files on the integrated application host.

[0068] The data forwarding module is further configured to: transmit data between the DL / T 860 server module and the DL / T 860 client module, complete model mapping, file directory parsing and data storage.

[0069] Figure 2 1 is a flow chart of information transmission according to an embodiment of the present invention. As shown in the figure, the method of the present invention comprises the following steps:

[0070] The master station sends an offline data retrieval command to the service gateway in the form of a write file; wherein, in a specific embodiment, the naming rule of the substation offline data retrieval command file is:

[0071] The file name for retrieving historical sampling values ​​is: analog_query_sequence.cmd;

[0072] The file name for retrieving historical alarm values ​​is: event_query_sequence.cmd.

[0073] The sequence field is a numerical value, and the master station can determine the return result based on the command sequence number.

[0074] The sampling value historical data retrieval command file is an E-format file, and its content format is as follows:

[0075]

[0076]

[0077] Among them, Cmdtype specifies the data type to be summoned. The value of Cmdtype is "analog" or "event". If it is analog, the sampling value history data is summoned. If it is event, the alarm history record data is summoned.

[0078] The master station can access the historical data of sampling values ​​and alarms within a certain period of time at three levels: station level, IED level, and data point level. The Objtype is used to specify the level at which to access. The Objtype value is:

[0079] One of POINT, IED, and STATION. If the Objtype value is POINT, the historical data of the data point specified by reference is retrieved; if the Objtype value is IED, the historical data of all data points under the IED specified by referrence is retrieved; if the Objtype value is STATION, the historical data of all data points in the entire station is retrieved. Starttime and endtime specify the retrieval time period.

[0080] Next, the method of the present invention further comprises the steps of:

[0081] The service gateway forwards the offline data access command to the integrated application host in the form of writing a file;

[0082] The integrated application host queries the data according to the offline data retrieval command, and organizes the query results into a fixed format file; wherein, in a specific embodiment, the fixed format file (also called the offline data retrieval result file) is a sampling value historical data retrieval result file or an alarm record historical data retrieval file. In order to reduce bandwidth, the integrated application service host compresses the offline data retrieval result file, and the file naming rules are as follows: the sampling value historical data retrieval result file naming rule is: analog_result_sequence_reason.res; the alarm record historical data retrieval file naming rule is: event_result_sequence_reason.res. In the name of the historical data retrieval result file: the sequence field is a numerical value, which is consistent with the master station retrieval order sequence number. Result, operation result: success ok, failure fail. Reason, failure reason, is only valid when the operation fails, and is a string describing the failure reason for the master station to identify. The sampling value historical data retrieval result file is an E-format file. The file content contains two parts. One part is the data point definition part, which indicates which data points are included in the query result and how many data points each point has in the query result. The other part is the query result, which describes the sampling value and sampling time of each data point in the data definition part. The alarm record historical data retrieval result file is an E-format file. The file content contains the alarm time, alarm type and alarm content description of each historical alarm record. Its content is shown in Table 1:

[0083] Table 1

[0084]

[0085] After the query results are organized into a fixed format file, the integrated application host sends a trigger readiness report to the service gateway machine;

[0086] After receiving the trigger readiness report, the serving gateway sends the trigger readiness report to the master station;

[0087] After receiving the trigger readiness report, the master station sends a file read command to the service gateway;

[0088] After receiving the file read command, the service gateway machine forwards the file read command to the integrated application host;

[0089] After receiving the file read command, the integrated application host retrieves the file and sends the retrieved file to the service gateway machine;

[0090] After receiving the retrieved file, the service gateway sends the retrieved file to the host.

[0091] After the offline data access command is issued and before the trigger readiness report is sent to the service gateway, the method further includes the following steps:

[0092] The offline data retrieval command is parsed by the integrated application host, wherein the parsing of the offline data retrieval command includes: checking the offline data retrieval command by obtaining the retrieval condition, time and device in the offline data retrieval command;

[0093] If the offline data retrieval command is parsed successfully, the integrated application host sends a file write response to the service gateway machine;

[0094] After receiving the write file response, the service gateway forwards the write file response to the master station.

[0095] In summary, the present invention discloses a substation data service-based access method and system based on DL / T 860 file service, wherein the main station sends an offline data access command to the service gateway in the form of a write file; the service gateway forwards the offline data access command to the comprehensive application host in the form of a write file; the comprehensive application host queries data according to the offline data access command, and composes the query results into a fixed format file; after composing the query results into a fixed format file, the comprehensive application host sends a trigger readiness report to the service gateway; after receiving the read file command, the comprehensive application host accesses the file and sends the accessed file to the service gateway; after receiving the accessed file, the service gateway sends the accessed file to the host. In order to meet the needs of the remote operation and maintenance business of the substation equipment for accessing various types of substation data, the method and system of the present invention realize the on-demand access of various types of substation data by various services of the main station.

[0096] It should be understood that, in various embodiments of the present invention, the order in which the above-mentioned processes are written does not mean the order of execution, and 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 invention.

[0097] It should be understood that the above specific embodiments of the present invention are only used to illustrate or explain the principles of the present invention, and do not constitute a limitation of the present invention. Therefore, any modifications, equivalent substitutions, improvements, etc. made without departing from the spirit and scope of the present invention should be included in the protection scope of the present invention. In addition, the appended claims of the present invention are intended to cover all changes and modifications that fall within the scope and boundaries of the appended claims, or the equivalent forms of such scope and boundaries.

Claims

1. A method for retrieving substation data. It is characterized in that The method is executed by a comprehensive application host, and the method comprises the following steps: Receive an offline data access command sent by a service gateway; Query data according to the offline data retrieval command, and compose the query results into a fixed format file; After the query results are organized into a fixed format file, a trigger readiness report is sent to the serving gateway machine; After receiving the trigger readiness report, the service gateway sends the trigger readiness report to the master station; After receiving the trigger readiness report, the master station sends a read file command to the serving gateway machine; After receiving the file read command, the service gateway machine forwards the file read command to the integrated application host; The integrated application host receives a file read command sent by the service gateway machine; After receiving the file read command, accessing the fixed format file, and sending the accessed fixed format file to the service gateway machine; Further, the service gateway machine is configured to perform the following operations: Receive file change notification reports sent by the integrated application host; After receiving the file change notification report, sending a file change notification to the master station; After sending the file change notification to the master station, a file read command sent by the master station is received.

2. The substation data access method according to claim 1, It is characterized in that After receiving the offline data access command sent by the service gateway machine and before querying data according to the offline data access command, the method includes the following steps: Parsing the offline data retrieval command, wherein parsing the offline data retrieval command includes: Checking the offline data retrieval command by acquiring the retrieval conditions, time and device in the offline data retrieval command; If the offline data retrieval command is parsed successfully, a write file response is sent to the service gateway machine.

Images