Broadband measuring device continuous recording data positioning transmission method and system

Abstract

The invention discloses a method and a system for positioning and transmitting continuous recording data of a broadband measuring device. The method comprises the steps that a master station queries measuring point data from a local time sequence database according to a continuous recording data query request of a user client, if the measuring point data is not obtained, a broadband measuring device is determined according to the query request, the broadband measuring device is accessed according to the query request, the broadband measuring device reads a Comtrade configuration file, and the Comtrade configuration file is sent to the user client; acquiring measuring point information, time information and sampling rate information in the query request, wherein the time information takes second as a unit; the broadband measuring device locates the positions of the continuous recording data of a plurality of measuring points in a Comtrade data file according to the measuring point information, and extracts the continuous recording data corresponding to the time information based on the time information and the sampling rate information; the broadband measuring device organizes and compresses extracted continuous recording data, packages the continuous recording data into messages according to a predefined data format, sends the messages to the master station through a reliable transmission protocol, transmits the messages to a user client through the master station, and stores the messages in a local time sequence database of the master station.

Description

Technical Field

[0001] This invention belongs to the field of data query and transmission of broadband measurement devices, and specifically relates to a method and system for locating and transmitting continuous waveform recording data of broadband measurement devices. Background Technology

[0002] With the rapid development of power systems, the demand for real-time monitoring of power grid operation status and rapid retrieval of historical data is increasing. Wideband measurement devices, as key equipment in power systems, can provide high-precision, high-speed synchronously sampled electrical quantity data. This data is continuously recorded and stored in Comtrade format at a sampling rate of no less than 6.4K.

[0003] When high-sampling-rate raw waveform data needs to be extracted from broadband measurement devices for analysis, existing technologies typically require first extracting the continuous waveform files stored minute by minute across the entire station from the device to the main station server via broadband device protocols. Then, tools are used to parse each station and each file individually to obtain data for the required device / measurement point and time range, and resampling is performed according to the data sampling rate requirements of the analysis scenario. This approach suffers from low data acquisition efficiency and slow query response when dealing with large-scale data. Since the continuous waveform data is stored minute by minute, containing raw sampling data from all devices at a sampling rate of at least 6.4K, the files are very large, and some device data is not needed by the main station. Transmitting large amounts of continuous waveform data consumes significant network bandwidth and takes a long time, impacting the system's real-time performance. Furthermore, the transmission of large amounts of data consumes significant network bandwidth, and data transmission failures due to network interruptions or packet loss are common during transmission. The lack of breakpoint resumption and retransmission mechanisms further affects the system's real-time performance and stability. Summary of the Invention

[0004] To address the shortcomings of existing technologies, this invention provides a method and system for locating and transmitting continuous waveform data from a broadband measurement device. This overcomes the deficiencies of low data acquisition efficiency, long transmission time, and lack of anomaly handling mechanisms in existing technologies, enabling rapid querying and efficient, reliable transmission of waveform data from the broadband measurement device, thereby improving system response speed and stability. Furthermore, by supporting simultaneous queries of multiple measurement points, compatibility with various compression algorithms, compatibility with binary and JSON message formats, and a local caching mechanism at the main station, system performance is further optimized.

[0005] To solve the above-mentioned technical problems, the present invention adopts the following technical solution.

[0006] This invention first discloses a method for locating and transmitting continuous waveform recording data from a broadband measurement device, the method comprising the following steps:

[0007] Step 1: The main station first queries the local time series database for measurement point data based on the continuous waveform data query request from the user client. If no measurement point data is obtained, the broadband measurement device is determined according to the query request, and the broadband measurement device is accessed according to the query request. The broadband measurement device reads the Comtrade configuration file and obtains the measurement point information, time information and sampling rate information in the query request. The time information is in seconds.

[0008] Step 2: The broadband measurement device locates the position of the continuous waveform data of multiple measurement points in the Comtrade data file according to the measurement point information, and extracts the continuous waveform data corresponding to the time information based on the sampling rate information;

[0009] Step 3: The broadband measurement device organizes and compresses the extracted continuous waveform data, encapsulates it into a message according to a predefined data format, and sends it to the master station through a reliable transmission protocol. The master station then transmits the message to the user client and stores it in the local time series database of the master station.

[0010] The present invention further includes the following preferred embodiments:

[0011] The step of determining the broadband measurement device based on the continuous waveform data query request from the user client further includes:

[0012] The corresponding broadband measurement device IP address is determined according to the measurement point information. The master station measurement point ID is converted into the source end measurement point name of the broadband measurement device, and a query command frame is formed and sent to the corresponding broadband measurement device.

[0013] The query instruction includes the following fields:

[0014] CommandType: Command type

[0015] MeasurementPoints: An array of measurement point names to be queried;

[0016] StartTime: The start time of the data query.

[0017] EndTime: The end time of the data query.

[0018] SamplingRate: Specifies the sampling density of the data.

[0019] CompressionAlgorithm: Specifies the compression algorithm to use.

[0020] ResponseFormat: The expected response format, including JSON or Binary;

[0021] RequestID: A unique identifier used to identify this request.

[0022] The location of the continuous waveform data from multiple measurement points within the Comtrade data file further includes:

[0023] By utilizing the time-series characteristics of Comtrade data files and the fixed time intervals between each data record in the Comtrade data file, the starting position of the required data in the Comtrade data file is determined through offset calculation.

[0024] The process of organizing the extracted continuous waveform data further includes:

[0025] The extracted data from multiple measurement points are organized according to time sequence and measurement point, including measurement point ID, timestamp, and data value.

[0026] The compression process uses compression algorithms zip, gzip, and zstd.

[0027] The step of sending the data to the master station via a reliable transmission protocol further includes:

[0028] It employs a TCP protocol that supports resuming interrupted transmissions, monitors data integrity during transmission, and triggers retransmission or a resuming interrupted transmission mechanism if an anomaly occurs.

[0029] The query results are split into multiple ordered data packets, with SequenceNumber and TotalSequences information appended; where SequenceNumber represents the sequence number of the current data packet, and TotalSequences represents the total number of data packets;

[0030] If the main station does not receive the data packet within the specified time, or detects that the data packet is corrupted, it will request to resend the data packet with the specific SequenceNumber via feedback.

[0031] Based on feedback from the master station, the broadband measurement device resends unacknowledged or corrupted data packets.

[0032] This invention also discloses a broadband measurement device continuous waveform recording data positioning and transmission system utilizing the aforementioned broadband measurement device continuous waveform recording data positioning and transmission method, comprising:

[0033] A continuous waveform recording query client tool is used to receive continuous waveform recording data query requests from users and send the continuous waveform recording data query requests to the main station;

[0034] The continuous waveform query agent module, located at the main station, is used to determine the broadband measurement device based on the continuous waveform data query request from the user client, access the broadband measurement device according to the query request, transmit the continuous waveform data returned by the broadband measurement device to the user client, and store it in the time series database on the main station's local machine.

[0035] The continuous waveform data query service module, located in the broadband measurement device, is used to read the Comtrade configuration file, obtain the measurement point information, time information, and sampling rate information from the query request, wherein the time information is in seconds; based on the measurement point information, locate the position of the continuous waveform data of multiple measurement points in the Comtrade data file, and extract the continuous waveform data corresponding to the time information based on the sampling rate information; organize and compress the extracted continuous waveform data, encapsulate it into a message according to a predefined data format, and send it to the master station through a reliable transmission protocol.

[0036] Accordingly, this application also discloses a terminal, including a processor and a storage medium;

[0037] The storage medium is used to store instructions;

[0038] The processor is configured to operate according to the instructions to execute the steps of the aforementioned method for locating and transmitting continuous waveform data from a broadband measuring device.

[0039] Accordingly, this application also discloses a computer-readable storage medium storing a computer program thereon, which, when executed by a processor, implements the steps of the aforementioned broadband measurement device continuous waveform data positioning and transmission method.

[0040] The beneficial effects of this invention are as follows: Compared with the prior art, this invention provides a method and system for locating and transmitting continuous waveform data of a broadband measurement device. By directly calculating the location, it acquires data for a specified measurement point, a specified time period accurate to the second, and a specified sampling rate, significantly improving data location and acquisition speed and shortening query response time. Since only the required measurement point, time range, and sampling rate data are transmitted, and data compression and on-demand transmission are used, network bandwidth consumption is reduced, improving transmission efficiency. The use of breakpoint resumption and retransmission mechanisms ensures complete data transmission even under network instability, enhancing system stability. The main station stores historical query data, and subsequent identical queries can be directly retrieved locally, reducing requests to the broadband measurement device and further improving the overall efficiency of the system. Attached Figure Description

[0041] Figure 1 This is a schematic diagram of the architecture of the broadband measurement device for continuous waveform recording, positioning, and transmission system in this invention.

[0042] Figure 2 This is a flowchart of the continuous waveform recording data positioning process of the broadband measurement device in this invention.

[0043] Figure 3 This is a flowchart of the continuous waveform data transmission process of the broadband measurement device in this invention. Detailed Implementation

[0044] To make the objectives, technical solutions, and advantages of the present invention clearer, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention.

[0045] The embodiments described in this application are merely some, not all, embodiments of the present invention. Based on the spirit of the present invention, other embodiments obtained by those skilled in the art without inventive effort are all within the protection scope of the present invention.

[0046] To address the shortcomings of existing technologies, this invention proposes a method and system for locating and transmitting continuous waveform data from broadband measurement devices. This method enables rapid location and efficient transmission of continuous waveform data from broadband measurement devices, supports querying multiple measurement points per second, is compatible with various message formats and compression algorithms, and, combined with a local caching mechanism at the master station, solves the problems of low data location efficiency and long transmission time in existing technologies. This improves the efficiency of power system data query and analysis and is of great significance to the safe and stable operation of the power grid.

[0047] The broadband measurement device continuous waveform recording data positioning and transmission method disclosed in this invention includes the following steps:

[0048] Step 1: The main station first queries the local time series database for measurement point data based on the continuous waveform data query request from the user client. If no measurement point data is obtained, the broadband measurement device is determined according to the query request, and the broadband measurement device is accessed according to the query request. The broadband measurement device reads the Comtrade configuration file and obtains the measurement point information, time information and sampling rate information in the query request. The time information is in seconds.

[0049] Figure 1 The communication architecture between the master station and the broadband measurement device is demonstrated, including the issuance of query requests and the data transmission process, as well as the storage of the master station's local database. The technical architecture of this invention adopts a request / response design pattern and includes three parts: a continuous waveform query client tool, a continuous waveform query agent module (master station), and a continuous waveform data query service module (broadband measurement device).

[0050] The continuous waveform query client tool is deployed on the user's workstation. It generates query requests based on user needs, including information such as the measurement point name, measurement point ID, query start and end times, and sampling density of the query data defined by the main station. The continuous waveform query agent module is deployed on the main station system server. It receives the continuous waveform data query request from the client, first retrieving data directly from the local time-series database. If the data is not found, it determines the corresponding broadband measurement device IP address based on the measurement point, converts the main station measurement point ID to the source measurement point name of the broadband measurement device, assembles a query command frame, and sends it to the broadband measurement device. It also receives and parses the measurement point data returned by the broadband measurement device, transmits it to the client, and simultaneously writes it to the main station's local time-series database for storage, so that subsequent queries can directly retrieve data from the local database. The continuous waveform data query service module is deployed on the broadband measurement device and is responsible for storing sampled data, calculating data location, quickly extracting data, and generating and transmitting messages.

[0051] The master station generates a query request, including a list of measurement point names, time range, sampling rate, and other parameters, and sends it to the broadband measurement device. The broadband measurement device receives the query command from the master station. On the broadband measurement device side, it parses the Comtrade configuration file to obtain information such as measurement point names, sampling rates, and data formats. Based on the master station's requirements, it retrieves data from specified measurement points, within a specified time range, and at a specified sampling rate, avoiding sending data from unnecessary measurement points, to unnecessary time periods, or with excessively high sampling rates to the master station.

[0052] The configuration file contains the overall configuration of the continuous waveform data, including all measurement points of the substation, the start and end times of the waveform files, and the sampling frequency. The range of measurement points and sampling rates requested by the main station is a subset of the configuration file, and the time can span multiple waveform files.

[0053] Step 2: The broadband measurement device locates the position of the continuous waveform data of multiple measurement points in the Comtrade data file according to the measurement point information, and extracts the continuous waveform data corresponding to the time information based on the sampling rate information.

[0054] The broadband measurement device calculates the location of the measurement point data in the data file according to the Comtrade configuration file, and directly locates and extracts data from multiple measurement points within a specified time range and at a specified sampling rate.

[0055] Figure 2 The data location flowchart details how the broadband measurement device, upon receiving a query request, directly locates the data position of the measurement point using calculations and extracts the data. The continuous waveform data query request sent by the master station includes a list of target measurement point names, the required start and end times (in seconds), and the required sampling rate.

[0056] Specifically, the broadband measurement device parses the configuration information of the Comtrade file. Based on the measurement point name requested by the master station, it looks up the number of analog channels, the number of status channels, the measurement point type, and the channel number in the Comtrade configuration file to obtain the column position of the measurement point in the Comtrade data file. It then obtains the resampling step size based on the data sampling frequency requested by the master station and the sampling frequency in the Comtrade configuration file. Utilizing the time-series characteristics of the Comtrade data file and the fixed time interval relationship of each data record in the Comtrade data file, it directly calculates the starting row position of the required data in the data file through offset calculation, without needing to search the index file. Data from multiple measurement points within a specified time range is quickly extracted according to the resampling step size and the measurement point column position.

[0057] The calculation process for the column containing the measurement point is as follows (taking an ASCII format Comtrade data file as an example):

[0058] col ana =2+idx ana

[0059] col dig =2+cnt ana +idx dig

[0060] Among them: idx ana This refers to the channel number of the analog measurement point in the Comtrade configuration file;

[0061] col ana The simulated measurement points are in the Comtrade data file;

[0062] idx dig This refers to the channel number of the state measurement point in the Comtrade configuration file;

[0063] cnt ana The number of analog channels in the Comtrade configuration file

[0064] col dig The state measurement points are in the Comtrade data file;

[0065] The calculation process for the resampling step size is as follows:

[0066] n step =f C ÷f req

[0067] Where: n step f is the resampling step size; C f is the Comtrade sampling frequency; reqThe data sampling frequency requested by the main site;

[0068] The calculation process for the starting row position of the data is as follows:

[0069] row start =(t req -t C1 )*f C

[0070] Where: row start t represents the starting row number of the required data in the Comtrade data file. req The start time of the data requested by the main site; t C1 f is the time of the first data point in the Comtrade configuration file; C This is the sampling frequency for Comtrade.

[0071] After directly calculating the file location of the target data, the data can be resampled, organized, compressed, and uploaded to the main station according to the required sampling rate. This positioning method not only effectively avoids the full acquisition and scanning of data files in traditional methods, improving data extraction efficiency, but also significantly reduces query response time and bandwidth usage of the main and substations, making it particularly suitable for large-scale data query needs from multiple measurement points. This direct positioning method greatly improves data query performance, making the system more efficient when processing high-frequency, large-volume data.

[0072] Step 3: The broadband measurement device organizes and compresses the extracted continuous waveform data, encapsulates it into a message according to a predefined data format, and sends it to the master station through a reliable transmission protocol. The master station then transmits the message to the user client and stores it in the local time series database of the master station.

[0073] The broadband measurement device organizes and compresses the extracted data, encapsulates it into a message according to a specified format (JSON or binary), and then sends it to the main station through a reliable transmission protocol. Figure 3 The data transmission flowchart illustrates the entire process of the broadband measurement device compressing and encapsulating the extracted data, sending the data through the transmission protocol, and handling anomalies.

[0074] First, the extracted data from multiple measurement points is organized chronologically and by measurement point, including measurement point IDs, timestamps, and data values. Then, the data is compressed according to the compression algorithm specified in the request. Common compression algorithms such as zip, gzip, and zstd are supported, and can be expanded as needed to reduce network bandwidth consumption. Next, the data is encapsulated according to the specified message format (JSON or binary), adding necessary metadata information. In other words, depending on the data size, the data is encapsulated into single or multiple small messages, improving transmission stability and efficiency.

[0075] Preferably, during transmission, data integrity is monitored, and if an anomaly occurs, a retransmission or breakpoint resumption mechanism is triggered.

[0076] The transmission protocol uses the TCP protocol that supports resuming interrupted transmissions to ensure complete transmission of message data.

[0077] According to a specific implementation, the query command message format is as follows (supports querying multiple measurement points, JSON example):

[0078]

[0079] The fields are described below:

[0080] CommandType: Command type, here it is a data query request.

[0081] MeasurementPoints: An array of measurement point names to be queried.

[0082] StartTime: The start time of the data query, in the format YYYY-MM-DD HH:MM:SS.

[0083] EndTime: The end time of the data query, in the same format as above.

[0084] SamplingRate: Specifies the sampling density of the data. Optional parameter.

[0085] CompressionAlgorithm: Specifies the compression algorithm to use, such as zip, gzip, zstd, etc.

[0086] ResponseFormat: The expected response format, either JSON or Binary.

[0087] RequestID: A unique identifier used to identify this request, facilitating response matching and resuming interrupted downloads.

[0088] According to a specific implementation, the query result message format is shown in the following example (JSON example):

[0089]

[0090]

[0091] Field description:

[0092] ResponseType: Response type, which is the data result in this case.

[0093] RequestID: The request identifier that corresponds to the query request.

[0094] Data: Contains data from multiple measurement points, with each measurement point's data consisting of an array of timestamps and data values.

[0095] SequenceNumber: The sequence number of the current data packet, used for resuming interrupted downloads and data reassembly.

[0096] TotalSequences: The total number of data packets.

[0097] CompressionAlgorithm: The actual compression algorithm used.

[0098] Checksum: A checksum (such as CRC) used for data verification.

[0099] In an optional embodiment, the query result message format is as follows (binary example):

[0100] The message header contains fixed-length metadata fields, such as ResponseType, RequestID, SequenceNumber, TotalSequences, CompressionAlgorithm, and Checksum, encoded according to a predefined binary format. The data portion is compressed binary data containing data records from multiple measurement points.

[0101] In a further embodiment, the present invention employs a breakpoint resumption mechanism. If an interruption occurs during transmission, the broadband measurement device retransmits the incomplete data segment based on the reception status feedback from the master station, avoiding the duplication of successfully transmitted data. The transmission protocol and breakpoint resumption mechanism, based on the breakpoint resumption function of the transport layer and a customized breakpoint resumption scheme of the application layer, ensure the reliability and integrity of data transmission, effectively guaranteeing the continuity of the transmission process even in unstable network environments. Specifically, the implementation includes the following two layers:

[0102] (1) TCP's built-in breakpoint resumption mechanism: By identifying the order of each data packet through sequence numbers, the TCP protocol ensures that lost data packets can be identified and retransmitted. When network fluctuations or brief interruptions occur, TCP can automatically retransmit lost data packets based on the sequence number mechanism and retransmit data after the connection is restored, thereby avoiding the repeated sending and receiving of data packets. This breakpoint resumption function of the transport layer ensures the orderliness and integrity of data transmission, providing reliable basic support for the application layer.

[0103] (2) Application Layer Breakpoint Resumption Mechanism: When the network is congested, TCP connections may time out and disconnect. To further enhance transmission stability, this invention designs a customized breakpoint resumption mechanism at the application layer to meet the continuous waveform data transmission requirements of broadband measurement devices. The application layer breakpoint resumption mechanism additionally includes the application layer's SequenceNumber and TotalSequences fields in the data packet to clearly mark the position of the current data segment and the total number of packets. After receiving each data packet, the master station returns an acknowledgment message, marking the sequence number list of received packets. If an interruption occurs, the master station will feed back the sequence number of the missing data packets to the broadband measurement device, which will only retransmit the incomplete data packets and will not repeat the acknowledged parts.

[0104] Specifically, such as Figure 3 As shown, in the application layer breakpoint resume, when the broadband measurement device receives a query command sent by the master station with a request identifier of RID, a measurement point name of DataA, and a start and end time range of [T1,T2], the broadband measurement device queries the data according to the data parameters in the query command, packages the queried measurement point data, divides the large amount of query results into multiple ordered data packets, such as dividing them into N frames, and attaches SequenceNumber and TotalSequences information, and returns the query results to the master station using the request identifier RID. During the process of sending N frames of messages to the master station, each message sent by the broadband measurement device is detected by the master station. When the master station detects that a message has not been received within a specified time or that a message is corrupted (e.g., failure to receive the k-th frame data, or the transmission link is closed), the broadband measurement device will receive feedback from the master station on a resume query request (e.g., resume query [k,N]@RID), requesting the broadband measurement device to retransmit the message with a specific SequenceNumber (e.g., the k-th frame and subsequent frames, i.e., N-k+1 frames). Based on the feedback from the master station, the broadband measurement device retransmits the specific message (e.g., the k-th frame and subsequent frames, i.e., N-k+1 frames) to the master station using the request identifier RID.

[0105] According to a specific implementation, the format of the resume request message is as follows (JSON example):

[0106]

[0107]

[0108] Field description:

[0109] ResponseType: Response type, here it is an acknowledgment message.

[0110] RequestID: The request identifier that corresponds to the query request.

[0111] ReceivedSequences: A list of sequence numbers of data packets that the main station has successfully received.

[0112] MissingSequences: A list of missing or corrupted data packet sequence numbers detected by the master station, requiring the broadband measurement device to resend them.

[0113] A retransmission mechanism is triggered when a data transmission interruption or incomplete data packet is detected to ensure data integrity. A checksum is added to each data packet to verify the integrity and correctness of the data.

[0114] This application-layer breakpoint resumption design ensures that even after a prolonged interruption, reconnection can be precisely resumed under the control of the upper-layer protocol. Furthermore, the application-layer mechanism provides fine-grained retransmission control and error detection capabilities, improving network bandwidth utilization efficiency and reducing latency and computational resource consumption during data transmission. Through dual safeguards at the transport and application layers, this invention achieves a highly efficient and stable data transmission system for broadband measurement devices, ensuring the continuity and integrity of data transmission.

[0115] After receiving the complete data, the main station decompresses and parses it, transmits it to the client, and stores it in the local time series database so that subsequent queries can retrieve it directly from the local database, reducing the number of requests to the broadband measurement device.

[0116] The advantages of this mechanism are twofold: firstly, for subsequent identical queries, the main station can directly retrieve the required data from the local database without needing to send another request to the broadband measurement device, thus reducing the query pressure on the backend equipment; secondly, the caching mechanism reduces the frequency of data transmission over the network, optimizes bandwidth usage, and improves the utilization rate of network resources. Furthermore, through partitioned management and time-period archiving of the local database, cached data can be efficiently managed, ensuring a good balance between storage space and query speed, further improving the overall operating efficiency of the system.

[0117] The beneficial effects of this invention are as follows: Compared with the prior art, this invention provides a method and system for locating and transmitting continuous waveform data of a broadband measurement device. By directly calculating the location, it acquires data for a specified measurement point, a specified time period accurate to the second, and a specified sampling rate, significantly improving data location and acquisition speed and shortening query response time. Since only the required measurement point, time range, and sampling rate data are transmitted, and data compression and on-demand transmission are used, network bandwidth consumption is reduced, improving transmission efficiency. The use of breakpoint resumption and retransmission mechanisms ensures complete data transmission even under network instability, enhancing system stability. The main station stores historical query data, and subsequent identical queries can be directly retrieved locally, reducing requests to the broadband measurement device and further improving the overall efficiency of the system.

[0118] This invention can be a system, method, and / or computer program product. This invention also discloses a broadband measurement device continuous waveform recording data positioning and transmission system based on the aforementioned broadband measurement device continuous waveform recording data positioning and transmission method, comprising:

[0119] A continuous waveform recording query client tool is used to receive continuous waveform recording data query requests from users and send the continuous waveform recording data query requests to the main station;

[0120] The continuous waveform query agent module, located at the main station, is used to determine the broadband measurement device based on the continuous waveform data query request from the user client, access the broadband measurement device according to the query request, transmit the continuous waveform data returned by the broadband measurement device to the user client, and store it in the time series database on the main station's local machine.

[0121] The continuous waveform data query service module, located in the broadband measurement device, is used to read the Comtrade configuration file, obtain the measurement point information, time information, and sampling rate information from the query request, wherein the time information is in seconds; based on the measurement point information, locate the position of the continuous waveform data of multiple measurement points in the Comtrade data file, and extract the continuous waveform data corresponding to the time information based on the sampling rate information; organize and compress the extracted continuous waveform data, encapsulate it into a message according to a predefined data format, and send it to the master station through a reliable transmission protocol.

[0122] Based on the spirit of this invention, those skilled in the art will readily conceive of a computer program product that can be obtained based on the aforementioned method for locating and transmitting continuous waveform data using a broadband measuring device. The computer program product may include a computer-readable storage medium on which computer-readable program instructions are loaded to enable a processor to implement various aspects of this disclosure. That is, this application also includes a terminal comprising a processor and a storage medium; the storage medium is used to store instructions; the processor is used to operate according to the instructions to execute the steps of the aforementioned method for locating and transmitting continuous waveform data using a broadband measuring device.

[0123] Computer-readable storage media can be tangible devices capable of holding and storing instructions for use by an instruction execution device. Computer-readable storage media can be, for example, but not limited to, electrical storage devices, magnetic storage devices, optical storage devices, electromagnetic storage devices, semiconductor storage devices, or any suitable combination of the foregoing. More specific examples (a non-exhaustive list) of computer-readable storage media include: portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), static random access memory (SRAM), portable compact disc read-only memory (CD-ROM), digital multifunction disc (DVD), memory sticks, floppy disks, mechanical encoding devices, such as punch cards or recessed protrusions storing instructions thereon, and any suitable combination of the foregoing. The computer-readable storage media used herein are not to be construed as transient signals themselves, such as radio waves or other freely propagating electromagnetic waves, electromagnetic waves propagating through waveguides or other transmission media (e.g., light pulses through fiber optic cables), or electrical signals transmitted through wires.

[0124] The computer-readable program instructions described herein can be downloaded from computer-readable storage media to various computing / processing devices, or downloaded via a network, such as the Internet, local area network, wide area network, and / or wireless network, to an external computer or external storage device. The network may include copper transmission cables, fiber optic transmission, wireless transmission, routers, firewalls, switches, gateway computers, and / or edge servers. A network adapter card or network interface in each computing / processing device receives the computer-readable program instructions from the network and forwards them to the computer-readable storage media in the respective computing / processing device.

[0125] Computer program instructions used to perform the operations of this disclosure may be assembly instructions, instruction set architecture (ISA) instructions, machine instructions, machine-dependent instructions, microcode, firmware instructions, status setting data, or source code or object code written in any combination of one or more programming languages, including object-oriented programming languages ​​such as Smalltalk, C++, etc., and conventional procedural programming languages ​​such as the "C" language or similar programming languages. The computer-readable program instructions may execute entirely on the user's computer, partially on the user's computer, as a standalone software package, partially on the user's computer and partially on a remote computer, or entirely on a remote computer or server. In cases involving a remote computer, the remote computer may be connected to the user's computer via any type of network—including a local area network (LAN) or a wide area network (WAN)—or may be connected to an external computer (e.g., via the Internet using an Internet service provider). In some embodiments, electronic circuitry, such as programmable logic circuitry, field-programmable gate arrays (FPGAs), or programmable logic arrays (PLAs), is personalized by utilizing the status information of the computer-readable program instructions to implement various aspects of this disclosure.

[0126] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention and not to limit it. Although the present invention has been described in detail with reference to the above embodiments, those skilled in the art should understand that modifications or equivalent substitutions can still be made to the specific implementation of the present invention. Any modifications or equivalent substitutions that do not depart from the spirit and scope of the present invention should be covered within the protection scope of the claims of the present invention.

Claims

1. A method for locating and transmitting continuous waveform recording data from a broadband measuring device, characterized in that, Includes the following steps: Step 1: The main station first queries the local time series database for measurement point data based on the continuous waveform data query request from the user client. If no measurement point data is obtained, the broadband measurement device is determined according to the query request, and the broadband measurement device is accessed according to the query request. The broadband measurement device reads the Comtrade configuration file and obtains the measurement point information, time information and sampling rate information in the query request. The time information is in seconds. Step 2: The broadband measurement device locates the position of the continuous waveform data of multiple measurement points in the Comtrade data file according to the measurement point information, and extracts the continuous waveform data corresponding to the time information based on the sampling rate information; Step 3: The broadband measurement device organizes and compresses the extracted continuous waveform data, encapsulates it into a message according to a predefined data format, and sends it to the master station through a reliable transmission protocol. The master station then transmits the message to the user client and stores it in the local time series database of the master station.

2. The method for positioning and transmitting continuous waveform recording data of a broadband measurement device according to claim 1, characterized in that, The step of determining the broadband measurement device based on the continuous waveform data query request from the user client further includes: The corresponding broadband measurement device IP address is determined according to the measurement point information. The master station measurement point ID is converted into the source end measurement point name of the broadband measurement device, and a query command frame is formed and sent to the corresponding broadband measurement device.

3. The method for continuous waveform recording data positioning and transmission of a broadband measurement device according to claim 2, characterized in that, The query instruction includes the following fields: CommandType: Command type MeasurementPoints: An array of measurement point names to be queried; StartTime: The start time of the data query. EndTime: The end time of the data query. SamplingRate: Specifies the sampling density of the data. CompressionAlgorithm: Specifies the compression algorithm to use. ResponseFormat: The expected response format, including JSON or Binary; RequestID: A unique identifier used to identify this request.

4. The method for positioning and transmitting continuous waveform recording data of a broadband measuring device according to claim 3, characterized in that, The location of the continuous waveform data from multiple measurement points within the Comtrade data file further includes: By utilizing the time-series characteristics of Comtrade data files and the fixed time intervals between each data record in the Comtrade data file, the starting position of the required data in the Comtrade data file is determined through offset calculation.

5. The method for positioning and transmitting continuous waveform recording data of a broadband measuring device according to claim 4, characterized in that, The process of organizing the extracted continuous waveform data further includes: The extracted data from multiple measurement points are organized according to time sequence and measurement point, including measurement point ID, timestamp, and data value.

6. The method for continuous waveform recording data positioning and transmission of a broadband measurement device according to claim 5, characterized in that, The compression process uses compression algorithms zip, gzip, and zstd.

7. The method for positioning and transmitting continuous waveform recording data of a broadband measuring device according to claim 6, characterized in that, The step of sending the data to the master station via a reliable transmission protocol further includes: It employs a TCP protocol that supports resuming interrupted transmissions, monitors data integrity during transmission, and triggers retransmission or a resuming interrupted transmission mechanism if an anomaly occurs. The query results are split into multiple ordered data packets, with SequenceNumber and TotalSequences information appended; where SequenceNumber represents the sequence number of the current data packet. TotalSequences represents the total number of data packets; If the main station does not receive the data packet within the specified time, or detects that the data packet is corrupted, it will request to resend the data packet with the specific SequenceNumber via feedback. Based on feedback from the master station, the broadband measurement device resends unacknowledged or corrupted data packets.

8. A continuous waveform recording data positioning and transmission system for a broadband measurement device, characterized in that, include: A continuous waveform recording query client tool is used to receive continuous waveform recording data query requests from users and send the continuous waveform recording data query requests to the main station; The continuous waveform query agent module, located at the main station, is used to determine the broadband measurement device based on the continuous waveform data query request from the user client, access the broadband measurement device according to the query request, transmit the continuous waveform data returned by the broadband measurement device to the user client, and store it in the time series database on the main station's local machine. The continuous waveform data query service module, located in the broadband measurement device, is used to read the Comtrade configuration file and obtain the measurement point information, time information and sampling rate information in the query request, wherein the time information is in seconds. Based on the measurement point information, the location of the continuous waveform data of multiple measurement points in the Comtrade data file is determined, and the continuous waveform data corresponding to the time information is extracted based on the sampling rate information; the extracted continuous waveform data is organized and compressed, encapsulated into a message according to a predefined data format, and sent to the master station through a reliable transmission protocol.

9. A terminal, comprising a processor and a storage medium; characterized in that: The storage medium is used to store instructions; The processor is configured to operate according to the instructions to execute the steps of the continuous waveform recording data positioning and transmission method of the broadband measurement device according to any one of claims 1-7.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that, When executed by a processor, the program implements the steps of the continuous waveform recording data positioning and transmission method of the broadband measuring device as described in any one of claims 1-7.

Images