CN115422189A

CN115422189A - Data storage management method for aircraft test

Info

Publication number: CN115422189A
Application number: CN202211033698.8A
Authority: CN
Inventors: 胡广; 张硕; 胡凯凡; 蔡万增; 倪明; 周仁杰
Original assignee: Chinese People's Liberation Army 63660
Current assignee: Chinese People's Liberation Army 63660
Priority date: 2022-08-26
Filing date: 2022-08-26
Publication date: 2022-12-02

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. Wherein the database configuration management comprises: login configuration and backup configuration; the database table building management comprises data frame format initialization, modification, query, display, export, table building and table deletion; the database query management comprises query, processing, display and export; the database monitoring information comprises a storing line number rate, a storing total line number and an occupied total space; the invention designs a database table creating method and a data storage rule, improves the table creating efficiency of the database, reduces the table creating quantity and reduces the workload of operation and maintenance personnel. Meanwhile, a data query and data monitoring method is designed, so that data multi-dimensional analysis and use are facilitated, and operation and maintenance personnel can master the data collection condition in real time.

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 aircraft tests.

Background

In the flight test task of the aircraft, all data are collected to a data center through a PDXP protocol. At present, for each test task, operation and maintenance personnel of a data center need to rebuild tables in a database management platform by using SQL statements, and different table building modes of the operation and maintenance personnel can cause confusion of a data storage mode and are not beneficial to subsequent data management and analysis. The operation and maintenance personnel compile different SQL query statements according to different data analysis requirements, and the operation and maintenance personnel are required to have strong professional ability due to the specialty of the SQL language. Meanwhile, the stored data is not monitored in the process of the test task, and the data amount 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 testing task. Therefore, an efficient and convenient data storage management method for aircraft tests is needed.

The aircraft pneumatic test data management system and method (CN 201810332986.0) provides test data management through steps of feature acquisition, template matching, variable name mapping and the like, and the method comprises the step of digging effective data from generated data in a data mining mode and then storing the effective data into a database. 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 is all structured data and does not need to be stored in a database after being mined. A single-vehicle test data management system for a rail vehicle (CN 202020661919.6) provides a single-vehicle test data management system for a rail vehicle, which cancels a paper report, simplifies the delivery and inspection process of a single-vehicle test and improves the operation efficiency. The method does not provide a specific method for storing test data and inquiring data, and is not suitable for data storage management in aircraft tests. A data monitoring and management system and a method (CN 201310703018.3) are monitoring and management systems for field monitoring video image data and laboratory experiment state data, and cannot be applied to PDXP data packet management in aircraft experiments. In summary, there are many patents on data management, but the following problems exist for aircraft testing tasks:

(1) Data in the aircraft test task are not considered to be data packets generated based on the PDXP protocol.

(2) No method for orderly and efficiently storing the test data in each task is provided.

(3) How to simply and effectively monitor the collection condition of the PDXP data and how to inquire the PDXP data are not provided.

Disclosure of Invention

The invention aims to provide a data storage management method for aircraft tests, which is used for efficiently and conveniently storing, monitoring and inquiring all PDXP data packets generated in all aircraft test tasks in a data center.

To achieve the above object and solve the above problems, the present invention provides the following solutions.

A data storage management method for aircraft testing, comprising the steps of:

s1, configuring a database, including database login configuration and backup configuration;

s11, logging in a database to perform the following logging configuration: database IP address, port number, database name, user name, password;

s12, uploading data to a remote FTP server in a mode of combining full backup and incremental backup; wherein the backup configuration comprises: a backup period, FTP server;

s2, database tabulation is carried out

Before the PDXP data packet is stored in the database, firstly establishing a table in the database; 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 formats support csv,. Xls and. Txt, and the fixed format of the data frame template file must be the same as the format of the initialization frame data; one or more initialization templates are generated at one time according to the imported data frame template file; when the data frame template file is not imported or the imported data frame template file is incorrect, the format of the initialization template is the same as that of the initialization frame data;

the initialization template comprises a task name, an MID, an information source name, an SID, an information type, a BID, whether to divide a table or not, a table division period and a PDXP frame header format, wherein a field marked by [ ] is not changeable and the [ ] is used as an identification basis; selecting unsigned and signed data types; whether the sub-table is selected to be filled in yes or no; selecting writing weeks, days and hours in a sub-table period; filling integer numbers in the byte number according to the actual situation; filling the quantization unit according to the actual quantization unit, and if the quantization unit is empty, not processing the quantization unit;

s22, modifying the format of the data frame; providing functions of adding, deleting and modifying fields for the imported or generated data frame format;

s23, inquiring a data frame format; the method supports multi-index query according to MID, SID and BID, index values can be one or more of the MID, SID and BID, index value list display needs to be provided for convenient index query, and the display format adopts: MID (number) _ task name, SID (number) _ information source name, BID (number) _ information category;

s24, exporting a data frame format; exporting a data frame format query result into a file template, exporting formats of csv, xls and txt, and directly setting a certain template as an initialization template;

s25, displaying a data frame format; displaying the name of the data frame table, the meaning of the frame field and the length of the frame field, directly modifying the meaning of the displayed frame field, attaching the meaning of the information category when displaying the table name, and displaying the format: t _ MID (number) _ BID (number) _ information category;

s26, establishing a table of data frame formats; using MID as a mode, wherein data frames with the same MID value are in the same mode, each data frame in the same mode creates a data table, and using BID as a main key; the naming modes of the mode name, the data frame table name and the data frame table field name adopt regular fixed naming modes;

pattern naming rules: m _ MID (number), data frame table naming rule: t _ MID (number) _ BID (number), table field naming convention: n _ initial byte number _ data frame name _ quantization unit occupied by this field;

s27, deleting a table in a data frame format; for the queried data frame format, if the table is already established in the current task, selecting a deletion table;

s3, database query is carried out;

the query management is used for querying the historical data stored in the database, processing the historical data, displaying the processed historical data and exporting the processed historical data;

and (3) inquiring: providing MID, SID, BID, DATE and TIME index value query; the DATE index and the TIME index are selectable, but one or more MID index, SID index and BID index are required, and index value list display is required to be provided for facilitating index query, wherein the display format is MID (number) _ task name, SID (number) _ information source name and BID (number) _ information category;

and (3) treatment: before the query result is displayed and exported, selecting to carry out quantization unit processing on the data, wherein quantization unit processing logic can be obtained from the table field name; meanwhile, the inquired table data can be deleted;

displaying: the query result can be displayed, if the query result does not only display the first result, the number of the displayed pieces, ascending/descending order, sorting basis and whether the frame header can be selected or not is displayed;

and (3) deriving: the query data can be exported, and file format supports csv,. Xls and. Txt can be exported;

s4, monitoring a database;

the data monitoring is used for mastering the data collection state of the data center in real time and taking corresponding measures according to the state; the data monitoring carries out real-time and timed monitoring on the collected data according to tasks; monitoring the object: determining all data tables under a certain task; monitoring information: storing the line number rate, the total line number and the total occupied space; meanwhile, the monitoring information is written into the log file in real time, and can be displayed on a monitoring information chart of a certain data table in a selective mode, so that the monitoring condition of the certain data table is visualized.

Further, the backup period in S12 can be selected to be monthly, weekly, daily, or immediate.

Further, the FTP server in S12 includes an IP address, a user name, and a password.

Further, the S26 field type automatically selects the optimal type according to the number of bytes and the data type.

The effective benefits of the invention over the prior art are as follows:

1. aiming at the test characteristics of the aircraft, a database table creating method and a data storage rule are designed. The method for creating the data table through the template file export and import mode is provided, and the initialized template file format is designed, so that the table creating efficiency of the database is improved, and the workload of operation and maintenance personnel is reduced; the method for storing the data of the same MID in the same mode is provided, and the mode, the table and the field naming rule are designed, so that the table creating quantity is reduced, the data storage process is clearer and more direct, and the subsequent data storage processing and using are facilitated.

2. Aiming at the test characteristics of the aircraft, a data query method is designed. And providing a visual query method for multiple index values of MID, SID, BID, DATE and TIME, and providing a method for processing, displaying and exporting the data after the data is subjected to quantization unit processing, so that the method is favorable for multi-dimensional analysis and use of the data.

3. And designing a data monitoring method aiming at the test characteristics of the aircraft. The method for monitoring the collected data in real time and at fixed time according to tasks is provided, and the designed monitoring information comprises the inserting line number rate of the database, the total line number of the collected data and the total space occupied by the data, so that operation and maintenance personnel can conveniently master the data collection condition in real time.

Drawings

FIG. 1 is a schematic diagram of a database tabulation process of the present invention;

FIG. 2 is a diagram of a configuration management implementation interface of the present invention;

FIG. 3 is a diagram of a table creation management implementation interface of the present invention;

FIG. 4 is a diagram of a query management implementation interface of the present invention;

FIG. 5 is a diagram of an implementation interface for monitoring management according to the present invention.

Detailed Description

The invention is explained and illustrated in detail below with reference to the figures and examples.

The design idea of the invention is explained as follows, and in the flight test task of the aircraft, the real-time data transmission protocol adopts a PDXP protocol based on a UDP protocol. The PDXP protocol consists of a frame header and a data field, wherein the frame header field consists of a version number VER, a task mark MID, a signal source address SID, a signal sink address DID, an information mark BID, a packet sequence number No, an information processing mark FLAG, a reserved word Default, a sending DATE DATE, sending TIME TIME and data length L, the length of the frame header field is fixed, but field filling information is changed along with different test tasks and message generation main bodies; the data field length is not fixed, and the field length and the padding information of the data field length are changed along with different test tasks and message generation bodies. Therefore, a large but diverse set of PDXP packets are generated for each trial task.

All experimental data generated in the task are collected into a data center through a PDXP protocol, and the data center must have the following functions:

(1) And (4) a data storage function. The data storage function may cause all data aggregated into the data center to be stored in the database and permanently saved.

(2) A data query function. The data query function can enable operation and maintenance personnel to query any stored historical data, and data analysis, derivation and the like are facilitated.

(3) And (5) a data monitoring function. The data monitoring function can enable operation and maintenance personnel to master the data collection state of the data center in real time and take corresponding measures according to the state.

Aiming at all PDXP data packets generated in all aircraft test tasks, how to provide an efficient and convenient data storage, data monitoring and data query function in a data center is of great importance to the success of the test tasks.

The invention provides a data storage management method for an aircraft test, which comprises the following steps:

s1, configuring a database, including database login configuration and backup configuration; as shown in fig. 2;

s12, the backup design can improve the reliability of the data, and the data is uploaded to a remote FTP server by adopting a mode of combining full backup and incremental backup; wherein the backup configuration comprises: backup period (optional monthly, weekly, daily, immediate backup), FTP server (IP address, username, password).

S2, performing database tabulation, wherein the tabulation must be performed in the database before the PDXP data packet is stored in the database; as shown in fig. 1;

s21, initializing a data frame format;

in order to facilitate the user to build a table, one or more data frame template files can be imported under any file path, the file formats support csv,. Xls,. Txt, the fixed format of the data frame template file must be the same as the format of the initialization frame data, as shown in table 1; one or more initialization templates are generated at one time according to the imported data frame template file; when the data frame template file is not imported or the imported data frame template file is incorrect, the initialization template is in a format of table 1, namely the format of the initialization template is the same as that of initialization frame data;

table 1 initialization frame format

The initialization template mainly comprises a task name, an MID, an information source name, an SID, an information type, a BID, whether to divide a table or not, a table division period and a PDXP frame header format, wherein fields marked by [ ] cannot be changed and the [ ] is used as an identification basis; the data type can be selected from unsigned and signed; whether the sub-table can be filled in yes or no; the sub-table period can be filled in week, day and hour; filling integer numbers according to the actual situation by the number of bytes; filling the quantization unit according to the actual quantization unit, and if the quantization unit is empty, not processing the quantization unit;

s23, querying a data frame format; the method supports multi-index query according to MID, SID and BID, index values can be one or more of the MID, SID and BID, index value list display needs to be provided for convenient index query, and the display format adopts: MID (number) _ task name, SID (number) _ information source name and BID (number) _ information category;

s24, exporting a data frame format; the method supports exporting the query result of the data frame format into a file template, exports file format supports csv, xls and txt formats, and simultaneously supports directly setting a certain template as an initialization template;

s26, establishing a table of data frame formats; using MID as a mode, wherein data frames with the same MID value are in the same mode, each data frame in the same mode creates a data table, and using BID as a main key; the naming modes of the mode name, the data frame table name and the data frame table field name adopt regular fixed naming modes; so as to facilitate operation and maintenance. When the table is established, the field type automatically selects the optimal type according to the byte number and the data type;

pattern naming rules: m _ MID (number), data frame table naming convention: t _ MID (number) _ BID (number), table field naming convention: n _ starting byte number _ present field occupies byte number _ data frame name _ quantization unit. The naming rule ensures that the database does not need to create other information data tables such as MID, information source, information sink, quantization unit and the like.

S27, deleting a table in a data frame format; for the queried data frame format, if the table is established in the current task, selecting a deletion table;

s3, database query is carried out;

the query management is used for querying the historical data stored in the database, processing the historical data, displaying the processed historical data and exporting the processed historical data; as shown in fig. 4;

and (3) inquiring: providing MID, SID, BID, DATE and TIME index value query; the DATE index and the TIME index are optional, but one or more MID, SID and BID indexes are needed, and in order to facilitate index query, index value list display needs to be provided, wherein the display format is MID (number) _ task name, SID (number) _ information source name and BID (number) _ information category;

and (3) processing: before the query result is displayed and exported, selecting to carry out quantization unit processing on the data, wherein quantization unit processing logic can be obtained from table field naming; meanwhile, the inquired table data can be deleted;

and (3) displaying: the query result can be displayed, if the query result does not only display the first result, the number of the displayed pieces, ascending/descending order, sorting basis and whether the frame header can be selected or not is displayed;

and (3) deriving: query data can be exported, and file format support is exported.

S4, monitoring and managing a database;

and the data monitoring enables operation and maintenance personnel to master the data collection state of the data center in real time and take corresponding measures according to the state. Monitoring management carries out real-time and timed monitoring on the collected data according to tasks; monitoring the object: determining all data tables under a certain task; monitoring information: storing the line number rate, the total line number and the total occupied space; meanwhile, the monitoring information is written into a log file in real time, and can be displayed on a monitoring information chart of a certain data table in a selective manner, so that the monitoring condition of the certain data table is visualized; as shown in fig. 5.

The above description is of the preferred embodiment of the present invention and is not intended to limit the present invention in any way, and any person skilled in the art may make modifications and variations of the present invention using the above description to provide an equivalent embodiment. Any simple modification, equivalent change and modification made according to the technical scheme of the invention still belong to the protection scope of the invention.

Claims

1. A data storage management method for aircraft testing, comprising the steps of:

s12, uploading data to a remote FTP server by adopting a mode of combining full backup and incremental backup; wherein the backup configuration comprises: a backup period, FTP server;

s2, database tabulation is carried out

s21, initializing a data frame format;

the initialization template comprises a task name, an MID, an information source name, an SID, an information category, a BID, whether to divide a table or not, a table dividing period and a PDXP frame header format, wherein a field marked by [ ] is unchangeable and the [ ] is used as an identification basis; selecting unsigned and signed data types; whether the sub-table selection is filled in yes or no; selecting write week, day and hour according to the period of the table; filling integer numbers in the byte number according to the actual situation; filling the quantization unit according to the actual quantization unit, and if the quantization unit is empty, not processing the quantization unit;

s23, inquiring a data frame format; the method supports multi-index query according to MID, SID and BID, index values can be one or more of the MID, SID and BID, index value list display needs to be provided for convenient index query, and the display format adopts: MID (number) _ task name, SID (number) _ information source name and BID (number) _ information category;

s25, displaying a data frame format; the table name, the frame field meaning and the frame field length of the data frame are displayed, the displayed frame field meaning can be directly modified, and the table name is displayed with the information category meaning, and the display format is as follows: t _ MID (number) _ BID (number) _ information category;

s26, establishing a table of data frame formats; taking the MID as a mode, wherein data frames with the same MID value are in the same mode, each data frame in the same mode creates a data table, and the BID is taken as a main key; the naming modes of the mode name, the data frame table name and the data frame table field name adopt regular fixed naming modes;

pattern naming rules: m _ MID (number), data frame table naming convention: t _ MID (number) _ BID (number), table field naming convention: n _ starting byte number _ present field occupies byte number _ data frame name _ quantization unit;

s3, database query is carried out;

and (3) derivation: the query data can be exported, and file format supports csv,. Xls and. Txt can be exported; s4, monitoring a database;

2. The method of claim 1, wherein the backup period in S12 is selected from monthly, weekly, daily, and immediate backup.

3. The data storage management method for the aircraft test as claimed in claim 1, wherein the FTP server in S12 contains an IP address, a user name and a password.

4. The method of claim 1, wherein the field type of S26 is selected automatically according to the number of bytes and the data type.