Indexing storage and playback of telemetry and operational records

Abstract

The application relates to an index storage and playback device, method and equipment for telemetry and operation records, and belongs to the technical field of data management. The device comprises a test instrument, a satellite communication device, a satellite service control and test terminal, an index storage and playback management system and a MySQL database. The device can realize hierarchical progressive retrieval of one-stage range rough screening and two-stage accurate retrieval through a double-index mechanism formed by a composite index in an auxiliary index table, a telemetry table and an operation record table, and can significantly improve the query response speed of massive telemetry data; through independent or combined use of multiple playback modes, different business analysis scenarios can be flexibly adapted, and telemetry and operation records are synchronously associated and presented in the time dimension, the trigger cause of abnormal changes of telemetry can be quickly located, and the working efficiency of satellite fault diagnosis, task backtracking and test analysis is effectively improved.

Description

Technical Field

[0001] This application relates to the field of data management technology, and in particular to an index storage and playback device, method and apparatus for telemetry and operation records. Background Technology

[0002] With the development of commercial aerospace and satellite telemetry and control technology, the demand for equipment status monitoring during satellite on-orbit operation and ground testing is continuously increasing. Telemetry, as the core means of acquiring voltage, current, temperature, and payload equipment operating parameters of the onboard power system, directly determines the efficiency and accuracy of fault diagnosis and mission retrospective analysis through its data storage and playback capabilities. Currently, the industry generally adopts a traditional logistic storage model, storing received telemetry data in a structured format of "timestamp + parameter + data" in a database or CSV (comma-separated value file format) or binary dump file in chronological order. During data playback, the original data is directly parsed to generate corresponding data tables or single curve graphs, thereby enabling the retrospective viewing of historical operating status.

[0003] However, this traditional method of telemetry data storage and playback has significant performance and functional limitations. At the storage and retrieval level, existing solutions lack independent index structures for query conditions. Retrieving data by time range requires a full table scan, and when retrieving data based on a combination of time periods and specific parameters, the computational cost increases linearly with the data volume. When the original data volume reaches tens or even hundreds of GB, the playback process requires frequent readings of random sectors on the disk, causing severe I / O (input / output) waits and delays, failing to meet the application requirements for high-fidelity real-time playback. At the playback display level, existing solutions can only generate single-function telemetry curves or tables, unable to intuitively locate the command triggers or operational behaviors corresponding to telemetry jumps, making it difficult to support efficient and intuitive status backtracking and fault analysis. Summary of the Invention

[0004] Therefore, it is necessary to provide a device, method, and apparatus for indexing, storing, and playing back telemetry and operation records to address the aforementioned technical problems.

[0005] An index storage and playback device for telemetry and operation records, the device comprising testing instruments, satellite communication equipment, satellite service control and testing terminal, index storage and playback management system, and MySQL database; The satellite mission control and testing terminal is used to control the testing instruments to send specified test signals to the satellite communication equipment via commands and to record instrument operations; it is also used to control the satellite communication equipment to respond to test signals and complete the test via commands and to record the command operations and telemetry of the satellite communication equipment; and it is also used to forward telemetry, command operations and instrument operations to the index storage and playback management system. The index storage and playback management system is configured to build an auxiliary index table for storing query conditions, a telemetry table for storing telemetry and query conditions, and an operation record table for storing command / instrument operation and query conditions. The three types of data tables are stored in a MySQL database. The telemetry table and the operation record table both build composite indexes based on the internally stored query conditions, and together with the auxiliary index table, they form a dual index mechanism. When performing data queries, the index storage and playback management system is also used to first retrieve the auxiliary index table to complete the index information query, and then combine the index information query results with the composite index to complete the telemetry and operation record query. When performing data playback, the index storage and playback management system is also used to select one or combine to realize telemetry / operation list playback, multi-telemetry single satellite list playback, multi-telemetry single satellite plot playback, single telemetry multi-satellite plot playback, and multi-telemetry multi-satellite plot playback, and synchronously associate and present the telemetry and operation records in the time dimension during playback.

[0006] In one embodiment, the satellite service control and testing terminal includes a test control module, a service control module, and a communication protocol parsing and command sending module; The test control module is used to send instrument control commands to the test instrument to control the test instrument to send specified test signals to the satellite communication equipment and record the instrument operation; The satellite control module is used to send terminal control commands to the satellite communication equipment to control the satellite communication equipment to respond to test signals and complete the test, and to record the command operations and telemetry of the satellite communication equipment. The communication protocol parsing and command sending module is used to parse the data and send commands between the satellite communication equipment and the satellite control module.

[0007] In one embodiment, the query conditions include storage number, telemetry type, interface type, product type, and test environment. All query conditions are combined into a unique identifier. The unique identifier corresponds to multiple telemetry measurements in the telemetry table associated with a satellite communication device and multiple operation records in the operation record table. The operation record includes operation type and operation content.

[0008] In one embodiment, the index storage and playback management system also includes a built-in database read / write driver module. This module first uses a database filter to perform multi-condition filtering and matching on the auxiliary index table based on at least one of the following filtering conditions: storage number, telemetry type, interface type, product type, and test environment. This results in a set of matching target storage conditions, completing the first-level coarse-grained data range positioning. The target storage condition set includes storage number, telemetry type, interface type, product type, and test environment. Then, based on each storage condition in the target storage condition set, the module performs a second-level precise retrieval by matching the composite indexes in the telemetry table and the operation record table to obtain the queried telemetry and operation records.

[0009] In one embodiment, the index storage and playback management system also includes a built-in telemetry protocol parsing module and a telemetry and operation record playback module. The telemetry and operation record playback module includes: The remote measurement raw data list playback unit is used to play back the remote measurement raw data and remote measurement storage time queried under specified storage conditions for a single satellite in list form; The operation list playback unit is used to play back the operation records and operation times queried under specified storage conditions for a single satellite in list form; The multi-telemetry single-satellite list playback unit is used to load a list of telemetry measurements to be played back under specified storage conditions for a single satellite. It uses the telemetry protocol parsing module to parse and read multiple telemetry measurements under specified storage conditions for a single satellite from the queried telemetry measurements and play them back in list form. The multi-telemetry single-satellite plotting playback unit is used to load a list of telemetry measurements to be played back under specified storage conditions for a single satellite. It uses the telemetry protocol parsing module to parse and read multiple telemetry measurements under specified storage conditions for a single satellite from the queried telemetry measurements and play them back in plotting form. It also synchronously records multiple operation records under specified storage conditions for a single satellite on the plotting timeline. The single telemetry multi-satellite plotting playback unit is used to load a list of telemetry measurements to be played back under specified storage conditions of multiple satellites. It uses the telemetry protocol parsing module to parse and read the same telemetry measurement under specified storage conditions of multiple satellites from the queried telemetry measurements and play it back in plotting form. It also synchronously records multiple operation records under specified storage conditions of multiple satellites on the plotting timeline. The multi-telemetry, multi-satellite plotting playback unit contains a list of telemetry measurements to be played back under specified storage conditions for multiple satellites. It uses a telemetry protocol parsing module to parse and read multiple telemetry measurements under specified storage conditions from the queried telemetry measurements and play them back in plotting form. It also synchronously records multiple operation records under specified storage conditions for multiple satellites on the plotting timeline.

[0010] In one embodiment, the single telemetry multi-satellite plotting playback unit and the multi-telemetry multi-satellite plotting playback unit are further used to align telemetry data from different timelines by time fusion when the telemetry sets corresponding to different storage conditions are not on the same timeline. The alignment steps include: Extract the storage sequence number corresponding to each telemetry measurement under each storage condition. The storage sequence number is generated by sequentially incrementing the value starting from 0, and each storage sequence number uniquely corresponds to the storage time of the telemetry measurement. The storage sequence number of each telemetry measurement under each storage condition is set as the time alignment anchor point. The same storage sequence number of each telemetry measurement under different storage conditions is matched and the fusion alignment of multiple independent time lines is completed. When the time retrieval command of the telemetry measurement curve in the playback plot is responded to, the storage time of the corresponding telemetry measurement is retrieved based on the storage sequence number corresponding to the sampling point in the telemetry measurement curve and the one-to-one mapping relationship between the storage sequence number and the storage time of the corresponding telemetry measurement.

[0011] In one embodiment, the composite index is indexed using a BTREE method.

[0012] A method for indexing, storing, and playing back telemetry and operation records, the method being implemented based on the aforementioned indexing, storing, and playing back telemetry and operation records, includes the following steps: The system invokes the satellite mission control and testing terminal to instruct the testing instruments to send specified test signals to the satellite communication equipment and records the instrument operations; it also instructs the satellite communication equipment to respond to the test signals to complete the test and records the instructions and telemetry data of the satellite communication equipment; and it forwards the telemetry data, instructions, and instrument operations to the index storage and playback management system. The index storage and playback management system is invoked to construct an auxiliary index table for storing query conditions, a telemetry table for storing telemetry measurements and query conditions, and an operation record table for storing command / instrument operation and query conditions. The three types of data tables are stored in the MySQL database. The telemetry table and the operation record table are both built with composite indexes based on the internally stored query conditions, and together with the auxiliary index table, they form a dual index mechanism. When performing a data query, the index storage and playback management system first retrieves the auxiliary index table to complete the index information query, and then combines the index information query results with the composite index to complete the telemetry and operation record query. When performing data playback, the index storage and playback management system can select one or a combination of telemetry / operation list playback, multi-telemetry single satellite list playback, multi-telemetry single satellite plot playback, single telemetry multi-satellite plot playback, and multi-telemetry multi-satellite plot playback, and synchronously associate and present the telemetry and operation records in the time dimension during playback.

[0013] A computer device includes a memory and a processor, the memory storing a computer program, and the processor executing the computer program performing the following steps: The system invokes the satellite mission control and testing terminal to instruct the testing instruments to send specified test signals to the satellite communication equipment and records the instrument operations; it also instructs the satellite communication equipment to respond to the test signals to complete the test and records the instructions and telemetry data of the satellite communication equipment; and it forwards the telemetry data, instructions, and instrument operations to the index storage and playback management system. The index storage and playback management system is invoked to construct an auxiliary index table for storing query conditions, a telemetry table for storing telemetry measurements and query conditions, and an operation record table for storing command / instrument operation and query conditions. The three types of data tables are stored in the MySQL database. The telemetry table and the operation record table are both built with composite indexes based on the internally stored query conditions, and together with the auxiliary index table, they form a dual index mechanism. When performing a data query, the index storage and playback management system first retrieves the auxiliary index table to complete the index information query, and then combines the index information query results with the composite index to complete the telemetry and operation record query. When performing data playback, the index storage and playback management system can select one or a combination of telemetry / operation list playback, multi-telemetry single satellite list playback, multi-telemetry single satellite plot playback, single telemetry multi-satellite plot playback, and multi-telemetry multi-satellite plot playback, and synchronously associate and present the telemetry and operation records in the time dimension during playback.

[0014] The aforementioned index storage and playback device, method, and equipment for telemetry and operation records utilize a dual-index mechanism—comprising an auxiliary index table and composite indexes in the telemetry and operation record tables—to achieve hierarchical progressive retrieval, from primary coarse screening to secondary precise searching. This effectively avoids full table scans, significantly reduces disk I / O overhead, and dramatically improves the query response speed for massive amounts of telemetry data. It addresses the shortcomings of existing technologies, such as playback stuttering and excessive latency under large data volumes, and supports the performance requirements of high-fidelity, real-time data playback. For playback of telemetry and operation records, the device supports the independent or combined use of multiple playback modes, flexibly adapting to different business analysis scenarios. It enables both horizontal comparisons of multiple telemetry measurements from a single device and multi-dimensional benchmarking analysis of multiple telemetry measurements from multiple devices. Simultaneously, the device synchronously correlates and presents telemetry and operation records over time, intuitively establishing a temporal correspondence between operational behavior and changes in telemetry values. This facilitates rapid identification of the triggering causes of abnormal telemetry changes, effectively improving the efficiency of satellite fault diagnosis, mission backtracking, and test analysis. Attached Figure Description

[0015] Figure 1This is a schematic diagram of the structure of an index storage and playback device for telemetry and operation records in one embodiment; Figure 2 This is a schematic diagram of the structure of an index storage and playback management system in one embodiment; Figure 3 This is a schematic diagram showing the playback of a single-satellite plot from a multi-telemetry measurement in one embodiment; Figure 4 This is a schematic diagram showing the playback of multi-satellite plotting from a single telemetry measurement in one embodiment; Figure 5 This is a schematic diagram showing the playback of multi-telemetry multi-satellite plotting in one embodiment; Figure 6 This is an internal structural diagram of a computer device in one embodiment. Detailed Implementation

[0016] To make the objectives, technical solutions, and advantages of this application clearer, the following detailed description is provided in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative and not intended to limit the scope of this application.

[0017] In one embodiment, such as Figure 1 As shown, a telemetry and operation record index storage and playback device is provided, including a test instrument, satellite communication equipment, a satellite service control and test terminal, an index storage and playback management system, and a MySQL database. The satellite service control and test terminal is used to control the test instrument to send specified test signals to the satellite communication equipment via commands and record instrument operations; it is also used to control the satellite communication equipment to respond to test signals to complete tests via commands and record the commands and telemetry of the satellite communication equipment; and it forwards telemetry, command operations, and instrument operations to the index storage and playback management system. The index storage and playback management system is configured to construct an auxiliary index table for storing query conditions, a telemetry table for storing telemetry and query conditions, and a table for storing command / instrument operations. The system stores operation records based on query conditions in three types of tables in a MySQL database. Both the telemetry table and the operation record table have composite indexes built using internally stored query conditions, forming a dual-index mechanism together with the auxiliary index table. When performing data queries, the index storage and playback management system first retrieves the auxiliary index table to complete the index information query, and then combines the index information query results with the composite index to complete the telemetry and operation record queries. When performing data playback, the index storage and playback management system also selects one or a combination to implement telemetry / operation list playback, multi-telemetry single-satellite list playback, multi-telemetry single-satellite plot playback, single-telemetry multi-satellite plot playback, and multi-telemetry multi-satellite plot playback, and synchronously displays the telemetry and operation records in a time-series context during playback.

[0018] It should be understood that in the aforementioned index storage and playback device for telemetry and operation records, the dual-index mechanism, composed of an auxiliary index table and composite indexes in the telemetry and operation record tables, enables hierarchical progressive retrieval of primary range coarse screening and secondary precise retrieval. This effectively avoids full table scan operations, significantly reduces disk I / O overhead, and significantly improves the query response speed of massive telemetry data, supporting the performance requirements of high-fidelity real-time data playback. Furthermore, by supporting the independent or combined use of multiple playback modes, it can flexibly adapt to different business analysis scenarios. It can perform horizontal comparisons of multiple telemetry measurements from a single device, as well as multi-dimensional benchmarking analysis of multiple telemetry measurements from multiple devices. Simultaneously, by synchronously linking telemetry measurements and operation records in the time dimension, it can intuitively establish the temporal correspondence between operational behavior and changes in telemetry values, facilitating the rapid identification of triggering causes for abnormal changes in telemetry measurements and effectively improving the efficiency of satellite fault diagnosis, mission backtracking, and test analysis.

[0019] In one embodiment, such as Figure 1 As shown, the satellite service control and testing terminal includes a test control module, a service control module, and a communication protocol parsing and command sending module. The test control module sends instrument control commands to the test instruments to control them to send specified test signals to the satellite communication equipment and records instrument operations. The service control module sends terminal control commands to the satellite communication equipment to control it to respond to test signals and complete the test, and records the command operations and telemetry data of the satellite communication equipment. The communication protocol parsing and command sending module is used to parse the data transmitted between the satellite communication equipment and the service control module and to send commands. Commands, telemetry data, command operations, and instrument operations between the satellite service control and testing terminal and the test instruments and satellite communication equipment are transmitted through a transmission medium.

[0020] It should be understood that by relying on the satellite control and testing terminal to simultaneously retain three types of time-series related data—instrument operation, command operation, and telemetry—the defect of missing operational traceability evidence in single telemetry data is eliminated. When replaying telemetry changes, the excitation actions of the test instruments and the issued control commands can be accurately matched, clearly locating the external excitation and equipment response behavior corresponding to the telemetry value fluctuations. This fully restores the real time-series test scenario of satellite communication equipment, providing a coherent and complete original basis for fault location, test reproduction, and data verification. It significantly improves the accuracy and traceability efficiency of telemetry data playback analysis, and realizes integrated archiving and management of test process behavior and equipment status data.

[0021] In one embodiment, the query conditions include storage number (which can be repeated), telemetry type, interface type, product type, and test environment. All query conditions are combined into a unique identifier, which corresponds to multiple telemetry measurements in the telemetry table associated with a satellite communication device and multiple operation records in the operation record table. The operation record includes the operation type and operation content. Specifically, the auxiliary index table, telemetry table, and operation record table are shown in Tables 1, 2, and 3, respectively. In the tables, int represents integer type, and varchar represents variable character type.

[0022] Table 1 Auxiliary Index Table

[0023] Table 2 Telemetry Tables

[0024] Table 3 Operation Record Sheet

[0025] The index storage and playback management system stores auxiliary index tables, telemetry tables, and operation record tables in a remote MySQL database. This database is deployed on a dedicated server and employs a multi-replica redundancy and regular snapshot backup strategy, ensuring strong data security and recoverability, and guaranteeing the long-term reliable preservation of historical telemetry data.

[0026] In one embodiment, such as Figure 2 As shown, the index storage and playback management system also has a built-in database read / write driver module. This module first uses a database filter to perform multi-condition filtering and matching on the auxiliary index table based on at least one of the following filtering conditions: storage number, telemetry type, interface type, product type, and test environment. This results in a set of matching target storage conditions, completing the first-level coarse-grained data range positioning. The target storage condition set includes storage number, telemetry type, interface type, product type, and test environment. Then, based on each storage condition in the target storage condition set, the module matches the composite indexes in the telemetry table and the operation record table to perform a second-level precise retrieval, obtaining the queried telemetry and operation records.

[0027] It should be understood that the database read / write driver module, relying on a dual-index mechanism, can achieve hierarchical data filtering. First, it uses multi-dimensional filtering conditions to complete coarse-grained range filtering of the auxiliary index table, quickly eliminating irrelevant storage conditions to reduce the volume of data to be retrieved and reduce the resource consumption caused by full table traversal. Then, it relies on the storage conditions to associate with the composite index to carry out secondary precise retrieval, and simultaneously retrieves the corresponding telemetry and operation records. It takes into account the adaptability of broad multi-condition retrieval and the accuracy of single-device data retrieval. Hierarchical filtering significantly reduces the number of scans of the underlying data table, effectively shortens the query response time, and ensures efficient and stable retrieval in scenarios with massive test data. It can also realize the integrated and rapid retrieval of multi-table related data.

[0028] In one embodiment, such as Figure 2 As shown, the index storage and playback management system also includes a built-in telemetry protocol parsing module and a telemetry and operation record playback module. The telemetry and operation record playback module includes: 1. Remote measurement raw data list playback unit, used to play back the remote measurement raw data and remote measurement storage time queried under specified storage conditions (storage number, remote measurement type, interface type, product type and test environment) of a single satellite in the form of a list.

[0029] 2. Operation list playback unit, used to play back the operation records and operation times queried under specified storage conditions (storage number, telemetry type, interface type, product type and test environment) of a single satellite in list form.

[0030] 3. Multi-telemetry single-satellite list playback unit, used to load a list of telemetry measurements to be played back under specified storage conditions (storage number, telemetry type, interface type, product type and test environment) for a single satellite. The telemetry protocol parsing module is used to parse and read multiple telemetry measurements under specified storage conditions for a single satellite from the queried telemetry measurements and play them back in list form.

[0031] 4. The multi-telemetry single-satellite plotting playback unit is used to load a list of telemetry measurements to be played back under specified storage conditions (storage number, telemetry type, interface type, product type, and test environment) for a single satellite. Using the telemetry protocol parsing module, it parses and reads multiple telemetry measurements under the specified storage conditions from the queried telemetry measurements and plays them back in plotting form. Multiple operation records under the specified storage conditions for a single satellite are simultaneously recorded on the plotting timeline. For example, the multi-telemetry single-satellite plotting playback display is as follows: Figure 3 As shown, Figure 3 The playback compared the AGC (Automatic Gain Control) telemetry, remote control channel SNR (Signal-to-Noise Ratio), measurement channel SNR (Signal-to-Noise Ratio), and FPGA (Field-Programmable Gate Array) core temperature telemetry of a single satellite communication device. Figure 3The purple curve in the middle is the operation record comparison axis. A solid dot on it represents one operation record. The operation record comparison axis can be set with arbitrary Y-axis values ​​to facilitate comparison of telemetry measurements with different value ranges.

[0032] 5. The single telemetry multi-satellite plotting playback unit is used to load a list of telemetry measurements to be played back under specified storage conditions (storage number, telemetry type, interface type, product type, and test environment) for multiple satellites. The added satellite product models must be identical. Using the telemetry protocol parsing module, it parses and reads the same telemetry measurement under the specified storage conditions from the queried telemetry measurements and plays it back in plot form. Multiple operation records under the specified storage conditions for multiple satellites are simultaneously recorded on the plotting timeline. For example, the single telemetry multi-satellite plotting playback display is as follows: Figure 4 As shown, Figure 4 The playback compared the A-channel CAN bus transmission of multiple satellite communication devices and the AGC telemetry under normal temperature test conditions after the equipment was sealed.

[0033] 6. A multi-telemetry, multi-satellite plotting playback unit is used to contain a list of telemetry measurements to be played back under specified storage conditions (storage number, telemetry type, interface type, product type, and test environment) for multiple satellites. Utilizing a telemetry protocol parsing module, it parses and reads multiple telemetry measurements under the specified storage conditions from the queried telemetry measurements and plays them back in plotting form. Multiple operation records under the specified storage conditions for multiple satellites are simultaneously recorded on the plotting timeline. For example, the multi-telemetry, multi-satellite plotting playback display is as follows: Figure 5 As shown, Figure 5 The playback compared the telemetry request command count, reverse service CH1 power detection, and FPGA junction temperature of multiple satellite communication devices.

[0034] It should be understood that the above six types of playback units can be executed independently and in combination, and are diverse in form, covering all user query and playback needs. When plotting and playing back, they synchronously present telemetry and operation records, which can intuitively establish the temporal correspondence between operation behavior and changes in telemetry values, making it easy to quickly locate the triggering cause of abnormal changes in telemetry.

[0035] In one embodiment, the single telemetry multi-satellite plotting playback unit and the multi-telemetry multi-satellite plotting playback unit are also used to align telemetry data from different timelines when the telemetry data sets corresponding to different storage conditions are not on the same timeline. The alignment steps include: extracting the storage sequence number corresponding to each telemetry data under each storage condition, the storage sequence number is generated by sequentially accumulating starting from 0, and each storage sequence number uniquely corresponds to the storage time of the telemetry data to which it belongs; setting the storage sequence number of each telemetry data under each storage condition as the time alignment anchor point, matching the same storage sequence number of each telemetry data under different storage conditions and completing the fusion alignment of multiple independent timelines; when responding to the time retrieval command of the telemetry curve in the playback plot, the storage time of the corresponding telemetry data is retrieved based on the storage sequence number corresponding to the sampling point in the telemetry curve and combined with the one-to-one mapping relationship between the storage sequence number and the storage time of the corresponding telemetry data.

[0036] It should be understood that the storage sequence number generated from zero and accumulated sequentially serves as a unified time-series alignment anchor point to complete the fusion and alignment of multiple independent timelines. Relying on the inherent one-to-one mapping relationship between the storage sequence number and the telemetry storage time, it can avoid the data matching deviation problem caused by the difference in sampling period and time-series offset of different storage condition sets when directly using the original timestamp to align heterogeneous telemetry data. This significantly reduces the computational overhead of time-series alignment of multi-satellite telemetry data. At the same time, when retrieving time information during plot playback, the storage time can be quickly traced by simply matching the corresponding storage sequence number based on the curve sampling point. This takes into account the time-series unified benchmark and query response efficiency of both single telemetry multi-satellite and multi-telemetry multi-satellite plot playback units, and builds a stable and reliable underlying support for the synchronous playback of multiple sets of telemetry data across time periods and across satellites.

[0037] In one embodiment, the composite index uses a BTREE indexing method. The ordered hierarchical tree structure of the BTREE efficiently supports multi-field joint retrieval logic, quickly matching telemetry and operation record data associated with the required storage conditions. This significantly reduces the disk scan range in the hierarchical retrieval process. Simultaneously, the BTREE stably adapts to test data storage scenarios with frequent read / write operations, balancing index retrieval efficiency and data update performance, ensuring response speed and data matching accuracy when jointly retrieving telemetry and operation records from multiple devices.

[0038] In one embodiment, a method for indexing, storing, and playing back telemetry and operation records is provided. The method is implemented based on the aforementioned device for indexing, storing, and playing back telemetry and operation records, and includes the following steps: The system invokes the satellite mission control and testing terminal to instruct the testing instruments to send specified test signals to the satellite communication equipment and records the instrument operations; it also instructs the satellite communication equipment to respond to the test signals to complete the test and records the instructions and telemetry data of the satellite communication equipment; and it forwards the telemetry data, instructions, and instrument operations to the index storage and playback management system. The index storage and playback management system is invoked to construct an auxiliary index table for storing query conditions, a telemetry table for storing telemetry measurements and query conditions, and an operation record table for storing command / instrument operation and query conditions. The three types of data tables are stored in the MySQL database. The telemetry table and the operation record table are both built with composite indexes based on the internally stored query conditions, and together with the auxiliary index table, they form a dual index mechanism. When performing a data query, the index storage and playback management system first retrieves the auxiliary index table to complete the index information query, and then combines the index information query results with the composite index to complete the telemetry and operation record query. When performing data playback, the index storage and playback management system can select one or a combination of telemetry / operation list playback, multi-telemetry single satellite list playback, multi-telemetry single satellite plot playback, single telemetry multi-satellite plot playback, and multi-telemetry multi-satellite plot playback, and synchronously associate and present the telemetry and operation records in the time dimension during playback.

[0039] In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as follows: Figure 6 As shown, the computer device includes a processor, memory, network interface, and database connected via a system bus. The processor provides computing and control capabilities. The memory includes non-volatile storage media and internal memory. The non-volatile storage media stores the operating system, computer programs, and database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database stores data. The network interface communicates with external terminals via a network connection. When executed by the processor, the computer program implements a method for indexing, storing, and replaying telemetry and operation records.

[0040] In one embodiment, a computer device is provided, including a memory and a processor, the memory storing a computer program, the processor executing the computer program to perform the following steps: The system invokes the satellite mission control and testing terminal to instruct the testing instruments to send specified test signals to the satellite communication equipment and records the instrument operations; it also instructs the satellite communication equipment to respond to the test signals to complete the test and records the instructions and telemetry data of the satellite communication equipment; and it forwards the telemetry data, instructions, and instrument operations to the index storage and playback management system. The index storage and playback management system is invoked to construct an auxiliary index table for storing query conditions, a telemetry table for storing telemetry measurements and query conditions, and an operation record table for storing command / instrument operation and query conditions. The three types of data tables are stored in the MySQL database. The telemetry table and the operation record table are both built with composite indexes based on the internally stored query conditions, and together with the auxiliary index table, they form a dual index mechanism. When performing a data query, the index storage and playback management system first retrieves the auxiliary index table to complete the index information query, and then combines the index information query results with the composite index to complete the telemetry and operation record query. When performing data playback, the index storage and playback management system can select one or a combination of telemetry / operation list playback, multi-telemetry single satellite list playback, multi-telemetry single satellite plot playback, single telemetry multi-satellite plot playback, and multi-telemetry multi-satellite plot playback, and synchronously associate and present the telemetry and operation records in the time dimension during playback.

[0041] Those skilled in the art will understand that all or part of the processes in the methods of the above embodiments can be implemented by a computer program instructing related hardware. The computer program can be stored in a non-volatile computer-readable storage medium. When executed, the computer program can include the processes of the embodiments of the above methods. Any references to memory, storage, databases, or other media used in the embodiments provided in this application can include non-volatile and / or volatile memory. Non-volatile memory may include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM), or flash memory. Volatile memory may include random access memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), dual data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link DRAM (SLDRAM), RAMbus direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), etc.

[0042] The technical features of the above embodiments can be combined in any way. For the sake of brevity, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.

[0043] The above embodiments are merely illustrative of several implementation methods of this application, and their descriptions are relatively specific and detailed, but they should not be construed as limiting the scope of this application. It should be noted that those skilled in the art can make several modifications and improvements without departing from the concept of this application, and these all fall within the protection scope of this application.

Claims

1. A device for indexing, storing, and playing back telemetry and operation records, characterized in that, The device includes testing instruments, satellite communication equipment, satellite service control and testing terminal, index storage and playback management system, and MySQL database; The satellite mission control and testing terminal is used to control the testing instruments to send specified test signals to the satellite communication equipment via commands and record instrument operations; it is also used to control the satellite communication equipment to respond to test signals and complete the test via commands and record the command operations and telemetry of the satellite communication equipment; and it is further used to forward telemetry, command operations, and instrument operations to the index storage and playback management system. The index storage and playback management system is configured to construct an auxiliary index table for storing query conditions, a telemetry table for storing telemetry and query conditions, and an operation record table for storing command / instrument operation and query conditions. The three types of data tables are stored in a MySQL database. The telemetry table and the operation record table are both built with internally stored query conditions to create composite indexes, which together with the auxiliary index table form a dual index mechanism. When performing data queries, the index storage and playback management system is also used to first retrieve the auxiliary index table to complete the index information query, and then combine the index information query results with the composite index to complete the telemetry and operation record query; when performing data playback, the index storage and playback management system is also used to select one or combine to realize telemetry / operation list playback, multi-telemetry single satellite list playback, multi-telemetry single satellite plot playback, single telemetry multi-satellite plot playback, and multi-telemetry multi-satellite plot playback, and synchronously associate and present the telemetry and operation records in the time dimension during playback.

2. The telemetry and operation record indexing, storage, and playback device according to claim 1, characterized in that, The satellite service control and testing terminal includes a test control module, a service control module, and a communication protocol parsing and command sending module; The test control module is used to send instrument control commands to the test instrument to control the test instrument to send specified test signals to the satellite communication equipment and record the instrument operation; The satellite control module is used to send terminal control commands to the satellite communication equipment to control the satellite communication equipment to respond to test signals and complete the test, and to record the command operations and telemetry of the satellite communication equipment. The communication protocol parsing and command sending module is used to parse the data transmitted between the satellite communication equipment and the satellite control module and send commands.

3. The telemetry and operation record indexing, storage, and playback device according to claim 1, characterized in that, The query conditions include storage number, telemetry type, interface type, product type, and test environment. All query conditions are combined into a unique identifier. The unique identifier corresponds to multiple telemetry measurements in the telemetry measurement table associated with a satellite communication device and multiple operation records in the operation record table. The operation record includes operation type and operation content.

4. The telemetry and operation record indexing, storage, and playback device according to claim 3, characterized in that, The index storage and playback management system also includes a built-in database read / write driver module. This module first uses a database filter to perform multi-condition filtering and matching on the auxiliary index table based on at least one of the following filtering conditions: storage number, telemetry type, interface type, product type, and test environment. This results in a set of matching target storage conditions, completing the first-level coarse-grained data range positioning. The target storage condition set includes storage number, telemetry type, interface type, product type, and test environment. Then, based on each storage condition in the target storage condition set, a second-level precise retrieval is performed by matching the composite indexes in the telemetry table and the operation record table to obtain the queried telemetry and operation records.

5. The telemetry and operation record indexing, storage, and playback device according to claim 4, characterized in that, The index storage and playback management system also includes a built-in telemetry protocol parsing module and a telemetry and operation record playback module. The telemetry and operation record playback module includes: The remote measurement raw data list playback unit is used to play back the remote measurement raw data and remote measurement storage time queried under specified storage conditions for a single satellite in list form; The operation list playback unit is used to play back the operation records and operation times queried under specified storage conditions for a single satellite in list form; The multi-telemetry single-satellite list playback unit is used to load a list of telemetry measurements to be played back under specified storage conditions for a single satellite, and use the telemetry protocol parsing module to parse and read multiple telemetry measurements under specified storage conditions for a single satellite from the queried telemetry measurements, and play them back in list form. The multi-telemetry single-satellite plotting playback unit is used to load a list of telemetry measurements to be played back under specified storage conditions for a single satellite. The telemetry protocol parsing module is used to parse and read multiple telemetry measurements under specified storage conditions for a single satellite from the queried telemetry measurements and play them back in plotting form. Multiple operation records under specified storage conditions for a single satellite are recorded synchronously on the plotting timeline. The single telemetry multi-satellite plotting playback unit is used to load a list of telemetry measurements to be played back under specified storage conditions of multiple satellites. The telemetry protocol parsing module is used to parse and read the same telemetry measurement under specified storage conditions of multiple satellites from the queried telemetry measurements and play it back in plotting form. Multiple operation records under specified storage conditions of multiple satellites are recorded synchronously on the plotting timeline. The multi-telemetry, multi-satellite plotting playback unit is used to contain a list of telemetry measurements to be played back under specified storage conditions for multiple satellites. The telemetry protocol parsing module parses and reads multiple telemetry measurements under specified storage conditions from the queried telemetry measurements and plays them back in plotting form. Multiple operation records under specified storage conditions for multiple satellites are recorded synchronously on the plotting timeline.

6. The telemetry and operation record indexing, storage, and playback device according to claim 5, characterized in that, The single telemetry multi-satellite plotting playback unit and the multi-telemetry multi-satellite plotting playback unit are also used to align telemetry data from different timelines when the telemetry sets corresponding to different storage conditions are not on the same timeline, through time fusion. The alignment steps include: Extract the storage sequence number corresponding to each telemetry measurement under each storage condition. The storage sequence number is generated by sequentially accumulating the value starting from 0, and each storage sequence number uniquely corresponds to the storage time of the telemetry measurement. The storage sequence number of each telemetry measurement under each storage condition is set as the time alignment anchor point. The same storage sequence number of each telemetry measurement under different storage conditions is matched and the fusion alignment of multiple independent time lines is completed. When the time retrieval command of the telemetry measurement curve in the playback plot is responded to, the storage time of the corresponding telemetry measurement is retrieved based on the storage sequence number corresponding to the sampling point in the telemetry measurement curve and the one-to-one mapping relationship between the storage sequence number and the storage time of the corresponding telemetry measurement.

7. The telemetry and operation record indexing, storage, and playback device according to claim 1, characterized in that, The composite index uses a BTREE indexing method.

8. A method for indexing, storing, and replaying telemetry and operation records, characterized in that, The method is implemented based on the telemetry and operation record index storage and playback device according to any one of claims 1-7, and includes the following steps: The system invokes the satellite mission control and testing terminal to instruct the testing instruments to send specified test signals to the satellite communication equipment and records the instrument operations; it also instructs the satellite communication equipment to respond to the test signals to complete the test and records the instructions and telemetry data of the satellite communication equipment; and it forwards the telemetry data, instructions, and instrument operations to the index storage and playback management system. The index storage and playback management system is invoked to construct an auxiliary index table for storing query conditions, a telemetry table for storing telemetry measurements and query conditions, and an operation record table for storing command / instrument operation and query conditions. The three types of data tables are stored in a MySQL database. The telemetry table and the operation record table are both indexed with internally stored query conditions to form a composite index, which together with the auxiliary index table constitutes a dual index mechanism. When performing a data query, the index storage and playback management system first retrieves the auxiliary index table to complete the index information query, and then completes the telemetry and operation record query based on the index information query results and the composite index. When performing data playback, the index storage and playback management system can select one or combine to implement remote measurement / operation list playback, multi-telemetry single satellite list playback, multi-telemetry single satellite plot playback, single telemetry multi-satellite plot playback, and multi-telemetry multi-satellite plot playback, and synchronously associate and present the telemetry and operation records in the time dimension during playback.

9. A computer device comprising a memory and a processor, wherein the memory stores a computer program, characterized in that, When the processor executes the computer program, it implements the steps of the method of claim 8.

Images