CN-115422189-B - Data storage management method for aircraft test

CN115422189BCN 115422189 BCN115422189 BCN 115422189BCN-115422189-B

Abstract

The invention discloses a data storage management method for an aircraft test, which belongs to the technical field of aircraft tests and data storage management. The database configuration management comprises login configuration and backup configuration, database table creation management comprises data frame format initialization, modification, query, display, export, table creation and table deletion, database query management comprises query, processing, display and export, database monitoring information comprises a stored line number rate, a stored total line number and a total occupied space, and the method and the rule for creating the database table are designed. Meanwhile, the data query and data monitoring method is designed, so that the multidimensional analysis and use of the data and the real-time mastering of the data collection condition by operation and maintenance personnel are facilitated.

Inventors

HU GUANG
ZHANG SHUO
HU KAIFAN
CAI WANZENG
NI MING
ZHOU RENJIE

Assignees

中国人民解放军63660部队

Dates

Publication Date: 20260505
Application Date: 20220826

Claims (4)

1. A data storage management method for aircraft testing, comprising the steps of: S1, carrying out database configuration, including database login configuration and backup configuration; s11, logging in a database to perform logging in configuration including a database IP address, a port number, a database name, a user name and a password; s12, adopting a mode of combining full backup and incremental backup and uploading PDXP data packets to a remote FTP server, wherein the backup configuration comprises a backup period and an FTP server; s2, database construction is carried out Before PDXP data packets are stored in a database, a table is built in the database, and the specific table building process is as follows: S21, initializing a data frame format; Importing one or more data frame template files under any file path, wherein the file format supports csv, xls, txt, and the fixed format of the data frame template files is the same as the format of the initialized data frame template; generating one or more initialization templates at one time according to the imported data frame template file, wherein when the imported data frame template file is not imported or is in error, the initialization template is the same as the initialization frame data format; The initialization template comprises a task name, an MID, a source name, an SID, an information category, a BID, whether to divide a table, a division table period and a PDXP frame header format, wherein a field marked by [ ] is not changeable and [ ] is used as an identification basis, the data type is selected to be unsigned and signed, whether to divide the table to be filled in or not is selected, the division table period is selected to write the circumference, the day and the time, the number of bytes is filled in integer numbers according to actual conditions, the quantization unit is filled in according to actual quantization units, and if the quantization unit is empty, the quantization unit is not processed; S22, modifying the data frame format, and providing functions of adding, deleting and modifying fields for the imported or generated data frame format; S23, inquiring in a data frame format, supporting multi-index inquiry according to MID, SID, BID, wherein index values can be one or more of the index values, and index value list display is needed to be provided for facilitating index inquiry, wherein the display format adopts MID_task name, SID_source name and BID_information category; S24, exporting a data frame format, namely supporting exporting a data frame format query result as a file template, exporting file format supports csv, xls and txt formats, and simultaneously supporting that a certain template is directly set as an initialization template; s25, displaying a data frame table name, frame field meanings and frame field lengths, directly modifying the displayed frame field meanings, attaching information category meanings when the table name is displayed, and displaying the information category of the t_MID_BID_information; S26, establishing a data frame format table, wherein the MID is used as a mode, and data frames with the same MID value are in the same mode, each data frame in the same mode is provided with a data table, and BID is used as a main key; A mode naming rule, namely M_MID, a data frame table naming rule, namely t_MID_BID, a table field naming rule, namely n_initial byte number_present byte occupying byte number_data frame name_quantization unit; s27, deleting the table in the data frame format, and selecting the deleted table if the table is built in the current task for the queried data frame format; s3, inquiring a database; the inquiry management of the database is used for inquiring, displaying and exporting the history data stored in the database after being processed; Providing MID, SID, BID, DATE, TIME index value inquiry, wherein the DATE index and the TIME index are optional, but one or more MID, SID, BID indexes are needed, and providing index value list display with MID_task name, SID_source name and BID_information category for facilitating the index inquiry; before the query result is displayed and exported, selecting to carry out quantization unit processing on the data, wherein the quantization unit processing logic can acquire table field naming; the method comprises the steps of displaying a query result, if the query result is not unique, displaying a first result, displaying the number of the first result, ascending/descending order, ordering basis and whether displaying a frame head can be selected; Exporting, namely exporting file format support (csv, & xls, & txt) for the query data; s4, monitoring a database; The data monitoring of the database is used for grasping the data collecting state of the data center in real time and taking corresponding measures according to the state, the data monitoring monitors collected data in real time and at fixed time according to tasks, the monitoring objects of the data monitoring are that a certain task is determined, all data tables under the task are determined, the monitoring information of the data monitoring is that the line number rate is stored, the total line number is stored and the total space is occupied, meanwhile, the data monitoring information is written into a log file in real time, and the monitoring information chart of a certain data table can be selected for displaying, so that the monitoring condition of the certain data table is visualized.
2. A data storage management method for aircraft testing according to claim 1, wherein the backup period in S12 is selectable for monthly, weekly, daily or immediate backup.
3. A data storage management method for aircraft testing according to claim 1, wherein said FTP server in S12 contains an IP address, a user name, a password.
4. A data storage management method for aircraft testing according to claim 1, wherein S26 said field type automatically selects the optimal type based on the number of bytes and the data type.

Description

Data storage management method for aircraft test Technical Field The invention belongs to the technical field of aircraft tests and data storage management, and particularly relates to a data storage management method for an aircraft test. Background In the aircraft flight test mission, all data is collected to a data center through PDXP protocol. At present, for each test task, the data center operation and maintenance personnel need to use SQL sentences to reconstruct the table in the database management platform, and the different operation and maintenance personnel build the table in different modes, so that the data storage modes are disordered, and the follow-up data management and analysis are not facilitated. The operation and maintenance personnel write different SQL query sentences according to different data analysis requirements, and the operation and maintenance personnel are required to have stronger professional ability due to the professional property of SQL language. Meanwhile, monitoring of stored data is lacking in the test task process, and the data quantity and the data collection condition stored in each task cannot be counted. These factors all increase the difficulty and workload of data management during the test task. Therefore, an efficient and convenient data storage management method is required to be provided for the aircraft test. The aerodynamic test data management system and method (CN 201810332986.0) of the aircraft provides the steps of managing test data through characteristic acquisition, template matching, variable name mapping and the like. The method can not use the aircraft test task at all, the aircraft test task data needs to be stored in real time, and the test task data are structured data and do not need to be stored in a database after being mined. A railway vehicle single car test data management system (CN 202020661919.6) provides a railway vehicle single car test data management system which cancels a paper report, simplifies a single car test exchange and inspection process and improves the operation efficiency. The method does not provide a specific method for storing test data and inquiring the data, and is not suitable for data storage management in an aircraft test. A data monitoring management system and method (CN 201310703018.3) is a monitoring management system for on-site monitoring video image data and laboratory experiment state data, and cannot be suitable for PDXP data packet management in an aircraft test. In summary, there are many patents currently available for data management, but the following problems exist for aircraft test tasks: (1) Data not considered for the aircraft test mission is a packet generated based on the PDXP protocol. (2) No method is proposed for orderly and efficient storage of test data in each task. (3) There is no method that is presented how to simply and efficiently monitor PDXP the pooling of data, and how to query PDXP the data. Disclosure of Invention The invention aims to provide a data storage management method for an aircraft test, which is used for solving the problem that all PDXP data packets generated in all aircraft test tasks are efficiently and conveniently stored, monitored and inquired in a data center. In order to achieve the above purpose and solve the above technical problems, the present invention provides the following technical solutions. A data storage management method for aircraft testing, comprising the steps of: S1, carrying out database configuration, including database login configuration and backup configuration; s11, logging in a database to perform logging in configuration including a database IP address, a port number, a database name, a user name and a password; s12, adopting a mode of combining full backup and incremental backup and uploading data to a remote FTP server, wherein the backup configuration comprises a backup period and an FTP server; s2, database construction is carried out Before PDXP data packets are stored in a database, a table is built in the database, and the specific table building process is as follows: S21, initializing a data frame format; Importing one or more data frame template files under any file path, wherein the file format supports csv, xls, txt, and the fixed format of the data frame template files must be the same as the data format of the initialization frame; generating one or more initialization templates at one time according to the imported data frame template file, wherein when the imported data frame template file is not imported or is in error, the initialization template is the same as the initialization frame data format; the initialization template comprises a task name, an MID, a source name, a SID, an information category, a BID, whether to divide a table, divide a table period and PDXP frame header formats, wherein a field marked by [ ] is not changeable and [ ] is used as an identification basis, the data type is selected to be unsi