CN113220698A - Test data processing method, device, equipment and computer readable storage medium - Google Patents
Test data processing method, device, equipment and computer readable storage medium Download PDFInfo
- Publication number
- CN113220698A CN113220698A CN202110638660.2A CN202110638660A CN113220698A CN 113220698 A CN113220698 A CN 113220698A CN 202110638660 A CN202110638660 A CN 202110638660A CN 113220698 A CN113220698 A CN 113220698A
- Authority
- CN
- China
- Prior art keywords
- test
- parameter information
- information
- measurement
- value storage
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Debugging And Monitoring (AREA)
Abstract
The application provides a test data processing method and device, electronic equipment and a computer readable storage medium, and relates to the technical field of carrier rockets. The method comprises the following steps: acquiring measurement information of a test, wherein the measurement information comprises parameter information and a measurement value; the measured value is stored in a preset measured value storage table, and the parameter information is stored in a parameter information table. The embodiment of the application stores the measured value that produces in the experiment in to predetermined measured value storage table, the parameter information who corresponds the measured value is stored in to predetermined parameter information table, can guarantee the storage format of measured value for the format of predetermined satisfaction requirement, to the experimental data of different experimental different formats, the measured value also can unify and save, make things convenient for data analysis, data storage, it is all more convenient to analyze and derive, need not the artifical extra data of handling, it is laborsaving to save trouble, and can prevent the phenomenon such as data confusion among the data management that the human factor leads to loses, data management is more high-efficient.
Description
Technical Field
The application relates to the technical field of carrier rockets, in particular to a test data processing method, a device, equipment and a computer readable storage medium.
Background
The measurement values of the carrier rocket mainly comprise individual and professional measurement values of the rocket in the research, development and design processes, system measurement values, simulated flight data and the like in the joint debugging joint test and launching processes. The single machine and professional measured values are generally collected, sorted and analyzed by professional personnel, and mainly comprise engine test run data, rocket body structure measured values, single machine system environment measured values, single machine system performance measured values and the like, and the professional personnel purchase or research and develop various testing environments according to the acquisition requirements of various data, collect the data, and analyze and confirm the various data according to the index requirements of the rocket type.
The system measurement value and the simulated flight data are obtained and collated by collecting and combining the time sequence, attitude, orbit and various sensor data generated in the processes of electrifying, self-checking, simulated flight and the like of each system of the carrier rocket in the integrated state of each system of the rocket in the process of integrating, joint testing and launching each system of the rocket by the general specialty, and then analyzed according to the specific general technical indexes, flight simulation requirements and the like of the carrier rocket.
In the process of developing and launching the carrier rocket, the carrier rocket has more professional involvement, data storage work is generally carried out by each professional, formats of various measured values are not uniform, the generation environments of various data are different, and the rocket system in the model of research needs frequent testing, so that a large number of professionals are required to collect, copy, classify and store each data of the carrier rocket, and the time and the labor are consumed.
Disclosure of Invention
The purpose of the application is to solve at least one of the technical defects, especially, the carrier rocket has more professional involvement in the development and launching process, data storage work is generally carried out by each professional, formats of various measured values are not uniform, the generation environments of various data are different, and the rocket system of the model under study needs frequent testing, so that a large number of professionals are required to collect, copy, classify and store each data of the carrier rocket, and the technical defects of time consumption and labor consumption are overcome.
In a first aspect, a method for processing test data is provided, the method comprising:
acquiring measurement information of a test, wherein the measurement information comprises parameter information of the test and a measured value corresponding to the parameter information, and the parameter information is used for expressing the physical significance of the measured value;
storing the measured values into a preset measured value storage table, and determining the unique identifier of each measured value; wherein one of the measurement value storage tables is used for storing a corresponding set of measurement values;
and storing the parameter information and the table names of the measured value storage tables into preset parameter information tables, and associating the parameter information with the unique identifier of the measured value corresponding to the parameter information, wherein one parameter information table is used for storing a group of corresponding parameter information and the table names of the measured value storage tables.
As a possible implementation manner of the present application, the acquiring measurement information of the test further includes:
creating test record information of the test and a unique index of the test, and storing the test record information and the unique index into a preset test information table; wherein, one test corresponds to one test information table;
the storing the measured value into a preset measured value storage table further comprises:
and storing the table name and the unique index of the measurement value storage table into the test information table.
As a possible embodiment of the present application, the storing the parameter information and the table name of the measurement value storage table into the parameter information table further includes:
and storing the table names and the unique indexes of the measurement value storage table into a preset data table name list, wherein one test corresponds to one data table name list.
As a possible embodiment of the present application, the measurement information further includes a generation time of the measurement value; the acquiring of the measurement information of the test comprises:
receiving a telemetry signal of a test, and converting the telemetry signal into frame format data;
analyzing the frame format data to obtain the measurement information of the test;
the storing the measured value into a preset measured value storage table includes:
searching whether a measurement value storage table corresponding to the measurement information exists or not based on the measurement information;
when there is a measurement value storage table corresponding to the measurement information, the measurement value is inserted into the measurement value storage table at a corresponding generation time.
As a possible embodiment of the present application, when there is no measurement value storage table corresponding to the measurement information, the method further includes:
establishing a test information table, a measurement value storage table and a parameter information table corresponding to the test;
storing the measured value into the measured value storage table according to the generation time;
storing the parameter information and the table name of the measured value storage table into the parameter information table, and associating the parameter information and the code number of the measured value mark corresponding to the parameter information;
and creating test record information of the test and a unique index of the test, and storing the test record information of the test and the unique index of the test into the test information table.
As a possible implementation manner of the present application, the storing the table name and the unique index of the measurement value storage table into a preset data table name list further includes:
receiving a test data analysis request, wherein the test data analysis request at least comprises at least one of test record information of analyzed test data, the unique index and the name of the measured value storage table;
acquiring a parameter information table and a measurement value storage table corresponding to at least one of the test record information, the unique index and the measurement value storage table name;
and extracting the parameter information in the parameter information table and the measured value in the measured value storage table for analysis to obtain an analysis result, and displaying the analysis result according to a preset format.
As a possible implementation manner of the present application, the storing the table name and the unique index of the measurement value storage table into a preset data table name list further includes:
receiving a test data export request, wherein the test data export request at least comprises at least one of test record information of analyzed test data, the unique index and the name of the measured value storage table;
acquiring a parameter information table and a measurement value storage table corresponding to at least one of the test record information, the unique index and the measurement value storage table name;
and deriving the parameter information in the parameter information table and the measured value in the measured value storage table according to a preset format.
In a second aspect, there is provided a test data processing apparatus, the apparatus comprising:
the device comprises a measurement information acquisition module, a measurement information acquisition module and a measurement information acquisition module, wherein the measurement information acquisition module is used for acquiring measurement information of a test, the measurement information comprises parameter information of the test and a measurement value corresponding to the parameter information, and the parameter information is used for expressing the physical significance of the measurement value;
the measured value storage module is used for storing the measured values into a preset measured value storage table and determining the unique identifier of each measured value; wherein one of the measurement value storage tables is used for storing a corresponding set of measurement values;
and the parameter information storage module is used for storing the parameter information and the table name of the measured value storage table into a preset parameter information table and associating the parameter information and the unique identifier of the measured value corresponding to the parameter information.
In a third aspect, an electronic device is provided, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the above test data processing method.
In a fourth aspect, there is provided a computer readable storage medium having stored thereon at least one instruction, at least one program, set of codes, or set of instructions, which is loaded and executed by the processor to implement the above-mentioned experimental data processing method.
The embodiment of the application adopts a data structure capable of flexibly configuring data formats aiming at test data with different formats of various professional tests through unified management of the test data, stores the measured values generated in the tests into a preset measured value storage table, stores parameter information corresponding to the measured values into a preset parameter information table, and stores the measured values and the parameter information separately, so that the storage format of the measured values can be ensured to be a preset format meeting requirements, the measured values can also be stored uniformly aiming at the test data with different formats of the tests, the measured values and the corresponding parameter information are associated through each unique identifier, the physical significance of the measured values can be ensured to be obtained simultaneously when the measured values are read and analyzed, the data analysis is convenient, the data storage, the analysis and the derivation are convenient, and the data processing is not required to be carried out additionally by manpower, the device saves trouble and labor, can prevent phenomena of data confusion, data loss and the like in data management caused by human factors, and has more efficient data management.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings used in the description of the embodiments of the present application will be briefly described below.
Fig. 1 is a schematic flowchart of a data processing method according to an embodiment of the present application;
fig. 2 is a schematic diagram of a measurement value storage table according to an embodiment of the present application;
fig. 3 is a parameter information representation intention provided by an embodiment of the present application;
FIG. 4 is a diagram illustrating experimental information provided in an embodiment of the present application;
fig. 5 is a schematic diagram of a data table name list provided in an embodiment of the present application;
FIG. 6 is a schematic flow chart illustrating a telemetry data acquisition method according to an embodiment of the present disclosure;
FIG. 7 is a schematic flow chart diagram illustrating a telemetry data storage method according to an embodiment of the present disclosure;
FIG. 8 is a schematic flow chart diagram illustrating yet another method for storing telemetry data provided by an embodiment of the present application;
fig. 9 is a flowchart of data processing provided in an embodiment of the present application;
fig. 10 is a schematic structural diagram of a test data processing apparatus according to an embodiment of the present application;
fig. 11 is a schematic structural diagram of an electronic device according to an embodiment of the present application.
The above and other features, advantages and aspects of various embodiments of the present disclosure will become more apparent by referring to the following detailed description when taken in conjunction with the accompanying drawings. Throughout the drawings, the same or similar reference numbers refer to the same or similar elements. It should be understood that the drawings are schematic and that elements and features are not necessarily drawn to scale.
Detailed Description
Reference will now be made in detail to embodiments of the present application, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to the same or similar elements or elements having the same or similar function throughout. The embodiments described below with reference to the drawings are exemplary only for the purpose of explaining the present application and are not to be construed as limiting the present application.
As used herein, the singular forms "a", "an", "the" and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It will be understood that when an element is referred to as being "connected" or "coupled" to another element, it can be directly connected or coupled to the other element or intervening elements may also be present. Further, "connected" or "coupled" as used herein may include wirelessly connected or wirelessly coupled. As used herein, the term "and/or" includes all or any element and all combinations of one or more of the associated listed items.
To make the objects, technical solutions and advantages of the present application more clear, embodiments of the present application will be described in further detail below with reference to the accompanying drawings.
The terms referred to in this application will first be introduced and explained:
(1) the single machine system refers to each independent functional device contained in the carrier rocket and comprises a rocket computer, a servo system, a power supply system and the like;
(2) simulating the flight, namely simulating input parameters of each system in the rocket flight process according to the trajectory of the rocket before formal launching of the rocket so as to realize that each system of the rocket completes the total flight flow;
(3) the main application of persistence is to store objects in memory in a database, or in a disk file, an XML data file, and the like.
The application provides a test data processing method, a test data processing device, an electronic device and a computer readable storage medium, and aims to solve the above technical problems in the prior art.
The following describes the technical solutions of the present application and how to solve the above technical problems with specific embodiments. The following several specific embodiments may be combined with each other, and details of the same or similar concepts or processes may not be repeated in some embodiments. Embodiments of the present application will be described below with reference to the accompanying drawings.
The embodiment of the application provides a test data processing method, as shown in fig. 1, the method includes:
step S101, obtaining measurement information of a test, wherein the measurement information comprises parameter information of the test and a measured value corresponding to the parameter information, and the parameter information is used for representing the physical significance of the measured value.
The test data processing method provided by the embodiment of the application can be used for a test of a carrier rocket, wherein test data of a test of a single machine system in the carrier rocket, such as a rocket computer system, a servo system, a power system and the like, can also be processed, and the data processing includes but is not limited to data storage and analysis, data derivation based on user operation and the like.
In the embodiment of the present application, for convenience of description, a launch vehicle test is taken as an example, the test may be various tests in a launch vehicle system, and measurement information of the test includes parameter information of the test and a measurement value corresponding to the parameter information, where the parameter information of the test is used to identify a physical meaning of the measurement value corresponding to the test, for example, for a hot-test of a solid engine, parameter information to be collected includes vibration information, pressure, voltage, current, and the like, and for each parameter information, there is a corresponding measurement value. The data such as vibration information, pressure and the like can be acquired through a special test platform and stored as a preset format (such as txt) text, the data such as voltage, current and the like can be recorded through equipment such as a writing instrument, and the data in the equipment is exported to the preset format text for storage after the test is completed. Of course, for different tests, the acquired parameter information is different, and the measured values corresponding to the parameter information are also different, and a person skilled in the art can determine the required parameter information and the corresponding measured values according to actual requirements.
Step S102, storing the measured values into a preset measured value storage table, and determining the unique identifier of each measured value; wherein one of the measurement value storage tables is used for storing a corresponding set of measurement values.
In the embodiment of the present application, the measurement value storage table refers to a table preset in a database for storing measurement values, such as an excel table, for a group of measurement values of a test, a corresponding measurement value storage table is preset in the database, and the number of columns of the measurement value storage table is determined according to the number of measurement values in the group of measurement values, wherein for each measurement value, a unique identifier corresponding to the measurement value is set in the measurement value storage table.
In this embodiment of the present application, after a measurement value of a test is obtained, the measurement value is stored in a preset measurement value storage table, optionally, as shown in fig. 2, the measurement value storage table is a schematic diagram of the measurement value storage table in the embodiment of the present application, and is used for storing the measurement value, where the measurement value includes a specific numerical value of the measurement value and a unique identifier of the measurement value, where the specific numerical value of the measurement value may be stored according to a preset format, the type of the logging data may be a numerical type, and the type of the data numerical value may be a floating point number, a shaping number, a double-precision floating point number, or the like; optionally, for each measured value, the corresponding unique identifier may be a preset identifier, such as c1, c2, and the like. In the embodiment of the present application, each of the measurement value storage tables is provided with a unique measurement value storage table name, as shown in fig. 2, which is "engine hot-run _ vibration data" and which is convenient for a user to check the measurement value storage table in the database.
Step S103, storing the parameter information and the table name of the measurement value storage table into a preset parameter information table, and associating the parameter information with a unique identifier of a measurement value corresponding to the parameter information, where one of the parameter information tables is used to store a group of corresponding parameter information and table name of the measurement value storage table.
In the embodiment of the present application, the parameter information table is a data table which is preset in a database and used for storing table names of parameter information and measurement value storage tables, and for one test, one parameter information table is used for storing a group of corresponding parameter information and table names of measurement value storage tables, and in the parameter information table, information such as a physical meaning, a unit of a measurement value, a type of the measurement value and the like corresponding to the measurement value stored in the corresponding measurement value storage table is stored, wherein for each measurement value, the measurement value and the corresponding parameter information are associated through a unique identifier of the measurement value.
In the embodiment of the present application, for convenience of description, taking a specific embodiment as an example, as shown in fig. 3, a schematic diagram of a possible parameter information table in the embodiment of the present application is shown, where the parameter information table stores test information such as a test name (e.g., engine hot car _ vibration data), unique identifiers (e.g., c1, c2) corresponding to each measured value, a physical meaning of the measured value (e.g., axial vibration of a servo motor, radial vibration of the servo motor, etc.), and a data type (e.g., double) of the measured value. In conjunction with the foregoing embodiment, the physical meaning corresponding to the measured value uniquely identified as c1 in the measured value storage table is the servomotor axial vibration, and the physical meaning corresponding to the measured value uniquely identified as c2 is the servomotor radial vibration. Optionally, the parameter information may be different according to different tests, and the user may set the parameter information according to actual conditions.
The embodiment of the application adopts a data structure capable of flexibly configuring data formats aiming at test data with different formats of various professional tests through unified management of the test data, stores the measured values generated in the tests into a preset measured value storage table, stores parameter information corresponding to the measured values into a preset parameter information table, and stores the measured values and the parameter information separately, so that the storage format of the measured values can be ensured to be a preset format meeting requirements, the measured values can also be stored uniformly aiming at the test data with different formats of the tests, the measured values and the corresponding parameter information are associated through each unique identifier, the physical significance of the measured values can be ensured to be obtained simultaneously when the measured values are read and analyzed, the data analysis is convenient, the data storage, the analysis and the derivation are convenient, and the data processing is not required to be carried out additionally by manpower, the device saves trouble and labor, can prevent phenomena of data confusion, data loss and the like in data management caused by human factors, and has more efficient data management.
The embodiment of the present application provides a possible implementation manner, in which the obtaining of the measurement information of the test further includes:
creating test record information of the test and a unique index of the test, and storing the test record information and the unique index into a preset test information table; wherein, a test corresponds to a record of the test information table;
the storing the measured value into a preset measured value storage table further comprises:
and storing the table name of the measurement value storage table into the test information table.
In the embodiment of the application, the test record information is used for recording information related to the test, including but not limited to a test name, test time, an operator, environmental constraints, and the like, for each test, before the test starts, test record information of the test needs to be created, so that a user can conveniently manage the test, wherein each test also corresponds to a unique index, and the test record information and the unique index are stored in a preset test information table, wherein one test corresponds to one record of the test information table.
In the embodiment of the present application, for convenience of description, taking a specific embodiment as an example, as shown in fig. 4, a schematic diagram of a possible test information table provided in the embodiment of the present application is shown, where test record information and a unique index (instance _ id) of the test are stored in the test information table, where the test information includes data such as a test name (instance _ name), a test time (test _ time), an operator (manager), a test location (place), a test object (test _ item), and a test type (test _ phase), where the test record information may be different according to different tests, and a user may set the test record information according to an actual situation.
According to the embodiment of the application, the test record information and the test unique index are created for each test, the test record information and the test unique index are stored in the preset test information table, and the table name of the measurement value storage table corresponding to the test is stored in the test data table name list, as shown in fig. 5, a user can search the measurement value storage table corresponding to the test through the test data table name list, and the user can conveniently search data.
The embodiment of the present application provides a possible implementation manner, in which the table names of the parameter information and the measurement value storage table are stored in a data table name list, where one test corresponds to one data table name list.
In this embodiment of the present application, for each test, a corresponding data table name list is preset in a database, where the data table name list is used to store a table name of a measurement value storage table of the test and a unique index of the test, and for convenience of description, a specific embodiment is taken as an example, as shown in fig. 5, a schematic diagram of a data table name list is provided for implementing the present application, and the data table name list at least stores the unique index (instance _ id) of the test and table names (table _ names) of measurement value storage tables corresponding to all measurement values in the test.
According to the embodiment of the application, a data table name list is created for each test, the unique index of each test and the table names of the measurement value storage tables corresponding to all the measurement values in the test are stored in the data table name list, a user can search the table names of the measurement value storage tables through the data table name list, then the measurement value storage tables are determined, and the user can know the number of the measurement values in the test conveniently.
The embodiment of the present application provides a possible implementation manner, in which the measurement information further includes a generation time of the measurement value.
In the embodiment of the application, each measured value generated in the test corresponds to a generation time, and when the measured value is stored, the measured value can be stored in the measured value storage table according to the time sequence based on the generation time of the measured value.
As a possible embodiment of the present application, when processing test data generated by a telemetry test, the acquiring measurement information of the test includes:
step S601, receiving a tested telemetering signal, and converting the telemetering signal into frame format data;
step S602, analyzing the frame format data to obtain the measurement information of the test.
In the embodiment of the application, when the telemetry data generated by the joint debugging joint test is processed, the received telemetry signal needs to be converted into frame format data, for example, the telemetry signal is converted into a frame format form through processing such as adjustment and passing, and then each frame of data is analyzed based on the data frame to obtain the measurement information.
In the embodiment of the present application, as shown in fig. 7, the storing the measured value into a preset measured value storage table includes:
step S701, searching whether a measurement value storage table corresponding to the measurement information exists or not based on the measurement information;
step S702, when there is a measurement value storage table corresponding to the measurement information, inserts the measurement value into the measurement value storage table according to the corresponding generation time.
In the embodiment of the present application, for the processing of the telemetry data, after the measurement information is obtained by analyzing the telemetry signal, if the measurement information is to be stored in the database, it is necessary to determine whether the database exists in the data table corresponding to the measurement information of the test, for example, for the measurement value and the parameter information, it is necessary to determine whether the measurement value storage table of the test exists in the database, and when the measurement value storage table of the test exists, the measurement value may be inserted into the corresponding measurement value storage table based on the generation time of the measurement value.
According to the embodiment of the application, the telemetering data of the test is inserted into the data table according to the generation time based on the data table corresponding to the test preset in the database, so that the telemetering data can be managed conveniently.
An embodiment of the present application provides a possible implementation manner, in which as shown in fig. 8, when there is no measurement value storage table corresponding to the measurement information, the method further includes:
step S801, establishing a test information table, a measurement value storage table and a parameter information table corresponding to the test;
step S802, storing the measured value into the measured value storage table according to the generation time;
step S803, storing the parameter information and the table name of the measurement value storage table into the parameter information table, and associating the parameter information with the unique identifier of the measurement value corresponding to the parameter information;
step S804, creating the test record information of the test and the unique index of the test, and storing the test record information of the test and the unique index of the test in the test information table.
In this embodiment of the application, when a data table corresponding to the telemetry test does not exist in the database, it is necessary to create each data table corresponding to the test, such as a test information table, a measurement value storage table, and a parameter information table, then store the measurement value in the measurement value storage table based on the generation time of the measurement value, store the parameter information and the table name of the measurement value storage table in the parameter information table, associate the parameter information and the unique identifier of the measurement value corresponding to the parameter information, create the test record information of the test and the unique index of the test, and store the test record information of the test and the unique index of the test in the test information table, where a storage manner of data is consistent with the principle in the foregoing embodiment, and details are not repeated here.
According to the embodiment of the application, aiming at the condition that the data table corresponding to the telemetering test does not exist in the database, the corresponding data table is established in the database, and the telemetering data is inserted into the data table according to the generation time, so that the telemetering data is processed simply and quickly.
An embodiment of the present application provides a possible implementation manner, where in the implementation manner, the storing the table name and the unique index of the measurement value storage table into a preset data table name list, and then further includes:
receiving a test data analysis request, wherein the test data analysis request at least comprises at least one of test record information of analyzed test data, the unique index and the name of the measured value storage table;
acquiring a parameter information table and a measurement value storage table corresponding to at least one of the test record information, the unique index and the measurement value storage table name;
and extracting the parameter information in the parameter information table and the measured value in the measured value storage table for analysis to obtain an analysis result, and displaying the analysis result according to a preset format.
In this embodiment of the present application, when a test data analysis request is received, data may be analyzed based on the request, where the test data analysis request at least includes at least one of test record information, the unique index, and the name of the measurement value storage table of the analyzed test data, and then a parameter information table and a measurement value storage table corresponding to a test are determined based on at least one of the test record information, the unique index, and the name of the measurement value storage table, so as to determine measurement information of the test, and then the measurement information is analyzed, so as to obtain an analysis result, and the analysis result is displayed according to a preset format.
The embodiment of the application provides a data analysis function, and a user can search data for analysis through test record information, the unique index, information such as a measured value storage table name and the like, so that the data analysis is convenient and fast.
An embodiment of the present application provides a possible implementation manner, where in the implementation manner, the storing the table name and the unique index of the measurement value storage table into a preset data table name list, and then further includes:
receiving a test data export request, wherein the test data export request at least comprises at least one of test record information of analyzed test data, the unique index and the name of the measured value storage table;
acquiring a parameter information table and a measurement value storage table corresponding to at least one of the test record information, the unique index and the measurement value storage table name;
and deriving the parameter information in the parameter information table and the measured value in the measured value storage table according to a preset format.
In this embodiment of the application, when a test data derivation request is received, data may be derived based on the request, where the test data derivation request includes at least one of test record information of the derived test data, the unique index, and the name of the measurement value storage table, and then a parameter information table and a measurement value storage table corresponding to the test are determined based on at least one of the test record information, the unique index, and the name of the measurement value storage table, measurement information of the test is determined, and data is derived according to a preset format.
The embodiment of the application provides a data export function, a user can quickly search data through test record information, the unique index, the measured value storage table name and other information and export the data according to a preset format, and data processing is convenient.
As one possible embodiment of the present application, as shown in fig. 9, a flow chart of data processing is provided, wherein, for different test data, the processing flow is different, in the flow chart, steps S911 to S915 are steps for processing the data generated by the local test, steps S921 to S929 are steps for processing the data generated by the remote test, in the embodiment of the application, a data processing system is created, the system comprises a data import module, a database management module and a data analysis module, wherein, the data import module is mainly used for importing data and importing the locally stored data into a preset database, the database management module is used for managing the data in the database, such as creating data tables, storing data in data tables, etc., the data analysis module is used to analyze and export data based on the request. When data generated by local tests are processed, test data of each professional test in the launch vehicle are stored locally, wherein the stored format can be set as required, then the data are imported into a database according to a preset text format, measurement information of the test is created, a corresponding data table is created based on the measurement information, the data table comprises but is not limited to a measurement value storage table, a parameter information table, a data table name list, a test information table and the like, the test information is stored in the corresponding data table, and for each data table, the corresponding format can be set according to the specific situation of the test. For data generated by a telemetering test, analyzing a telemetering signal to obtain test data, inserting the test data into a database, creating test record information in the database, judging whether a data table of the telemetering test exists in the database, if so, storing the data of the telemetering test into a corresponding data table, if not, creating the corresponding data table, and then inserting the data to finish data storage. Analysis and derivation of the data is then effected based on the request.
The embodiment of the application adopts a data structure capable of flexibly configuring data formats aiming at test data with different formats of various professional tests through unified management of the test data, stores the measured values generated in the tests into a preset measured value storage table, stores parameter information corresponding to the measured values into a preset parameter information table, and stores the measured values and the parameter information separately, so that the storage format of the measured values can be ensured to be a preset format meeting requirements, the measured values can also be stored uniformly aiming at the test data with different formats of the tests, the measured values and the corresponding parameter information are associated through each unique identifier, the physical significance of the measured values can be ensured to be obtained simultaneously when the measured values are read and analyzed, the data analysis is convenient, the data storage, the analysis and the derivation are convenient, and the data processing is not required to be carried out additionally by manpower, the device saves trouble and labor, can prevent phenomena of data confusion, data loss and the like in data management caused by human factors, and has more efficient data management.
An embodiment of the present application provides a test data processing apparatus, and as shown in fig. 10, the test data processing apparatus 100 may include: a measurement information acquisition module 1001, a measurement value storage module 1002, and a parameter information storage module 1003, wherein,
a measurement information obtaining module 1001 configured to obtain measurement information of a test, where the measurement information includes parameter information of the test and a measurement value corresponding to the parameter information, and the parameter information is used to indicate a physical meaning of the measurement value;
a measured value storage module 1002, configured to store the measured value in a preset measured value storage table, and determine a unique identifier of each measured value; wherein one of the measurement value storage tables is used for storing a corresponding set of measurement values;
a parameter information storage module 1003, configured to store the parameter information and the table name of the measurement value storage table into a preset parameter information table, and associate the parameter information with a unique identifier of a measurement value corresponding to the parameter information, where one parameter information table is used to store a group of corresponding parameter information and table name of the measurement value storage table.
As a possible implementation manner of the present application, the test data processing apparatus further includes a test information recording module, configured to:
creating test record information of the test and a unique index of the test, and storing the test record information and the unique index into a preset test information table; wherein, one test corresponds to one test information table;
and storing the table name of the measurement value storage table into the test information table.
As a possible implementation manner of the present application, the test data processing apparatus further includes a table name storage module, configured to:
and storing the table names and the unique indexes of the measurement value storage table into a preset data table name list, wherein one test corresponds to one data table name list.
As a possible embodiment of the present application, the measurement information further includes a generation time of the measurement value; the acquiring of the measurement information of the test comprises:
receiving a telemetry signal of a test, and converting the telemetry signal into frame format data;
analyzing the frame format data to obtain the measurement information of the test;
the storing the measured value into a preset measured value storage table includes:
searching whether a measurement value storage table corresponding to the measurement information exists or not based on the measurement information;
when there is a measurement value storage table corresponding to the measurement information, the measurement value is inserted into the measurement value storage table at a corresponding generation time.
As a possible embodiment of the present application, when there is no measurement value storage table corresponding to the measurement information, the method further includes:
establishing a test information table, a measurement value storage table and a parameter information table corresponding to the test;
storing the measured value into the measured value storage table according to the generation time;
storing the parameter information and the table name of the measured value storage table into the parameter information table, and associating the parameter information and the unique identifier of the measured value corresponding to the parameter information;
and creating test record information of the test and a unique index of the test, and storing the test record information of the test and the unique index of the test into the test information table.
As a possible implementation manner of the present application, the storing the table name and the unique index of the measurement value storage table into a preset data table name list further includes:
receiving a test data analysis request, wherein the test data analysis request at least comprises at least one of test record information of analyzed test data, the unique index and the name of the measured value storage table;
acquiring a parameter information table and a measurement value storage table corresponding to at least one of the test record information, the unique index and the measurement value storage table name;
and extracting the parameter information in the parameter information table and the measured value in the measured value storage table for analysis to obtain an analysis result, and displaying the analysis result according to a preset format.
As a possible implementation manner of the present application, the storing the table name and the unique index of the measurement value storage table into a preset data table name list further includes:
receiving a test data export request, wherein the test data export request at least comprises at least one of test record information of analyzed test data, the unique index and the name of the measured value storage table;
acquiring a parameter information table and a measurement value storage table corresponding to at least one of the test record information, the unique index and the measurement value storage table name;
and deriving the parameter information in the parameter information table and the measured value in the measured value storage table according to a preset format.
The test data processing apparatus of the embodiment of the present application can execute the test data processing method shown in the foregoing embodiment of the present application, and the implementation principle is similar, and is not described here again.
The embodiment of the application adopts a data structure capable of flexibly configuring data formats aiming at test data with different formats of various professional tests through unified management of the test data, stores the measured values generated in the tests into a preset measured value storage table, stores parameter information corresponding to the measured values into a preset parameter information table, and stores the measured values and the parameter information separately, so that the storage format of the measured values can be ensured to be a preset format meeting requirements, the measured values can also be stored uniformly aiming at the test data with different formats of the tests, the measured values and the corresponding parameter information are associated through each unique identifier, the physical significance of the measured values can be ensured to be obtained simultaneously when the measured values are read and analyzed, the data analysis is convenient, the data storage, the analysis and the derivation are convenient, and the data processing is not required to be carried out additionally by manpower, the device saves trouble and labor, can prevent phenomena of data confusion, data loss and the like in data management caused by human factors, and has more efficient data management.
An embodiment of the present application provides an electronic device, including: a memory and a processor; at least one program stored in the memory for execution by the processor, which when executed by the processor, implements: by uniformly managing test data, aiming at test data with different formats of various professional tests, a data structure capable of flexibly configuring data formats is adopted, measured values generated in the tests are stored in a preset measured value storage table, parameter information corresponding to the measured values is stored in a preset parameter information table, the measured values and the parameter information are separately stored, the storage format of the measured values can be ensured to be a preset format meeting requirements, the measured values can be uniformly stored aiming at the test data with different formats of the tests, the measured values and the corresponding parameter information are associated through each unique identifier, the physical significance of the measured values can be simultaneously obtained during reading and analyzing of the measured values, the data analysis is convenient, the data storage, the analysis and the derivation are convenient, the data are not required to be additionally processed manually, the labor is saved, and the phenomena of data confusion and loss in data management caused by human factors can be prevented, and the data management is more efficient.
In an alternative embodiment, an electronic device is provided, as shown in fig. 11, the electronic device 4000 shown in fig. 11 comprising: a processor 4001 and a memory 4003. Processor 4001 is coupled to memory 4003, such as via bus 4002. Optionally, the electronic device 4000 may further comprise a transceiver 4004. In addition, the transceiver 4004 is not limited to one in practical applications, and the structure of the electronic device 4000 is not limited to the embodiment of the present application.
The Processor 4001 may be a CPU (Central Processing Unit), a general-purpose Processor, a DSP (Digital Signal Processor), an ASIC (Application Specific Integrated Circuit), an FPGA (Field Programmable Gate Array) or other Programmable logic device, a transistor logic device, a hardware component, or any combination thereof. Which may implement or perform the various illustrative logical blocks, modules, and circuits described in connection with the disclosure. The processor 4001 may also be a combination that performs a computational function, including, for example, a combination of one or more microprocessors, a combination of a DSP and a microprocessor, or the like.
The Memory 4003 may be a ROM (Read Only Memory) or other types of static storage devices that can store static information and instructions, a RAM (Random Access Memory) or other types of dynamic storage devices that can store information and instructions, an EEPROM (Electrically Erasable Programmable Read Only Memory), a CD-ROM (Compact Disc Read Only Memory) or other optical Disc storage, optical Disc storage (including Compact Disc, laser Disc, optical Disc, digital versatile Disc, blu-ray Disc, etc.), a magnetic Disc storage medium or other magnetic storage devices, or any other medium that can be used to carry or store desired program code in the form of instructions or data structures and that can be accessed by a computer, but is not limited to these.
The memory 4003 is used for storing application codes for executing the scheme of the present application, and the execution is controlled by the processor 4001. Processor 4001 is configured to execute application code stored in memory 4003 to implement what is shown in the foregoing method embodiments.
Among them, electronic devices include but are not limited to: computers, tablets, industrial controllers, and the like.
The present application provides a computer-readable storage medium, on which a computer program is stored, which, when running on a computer, enables the computer to execute the corresponding content in the foregoing method embodiments. Compared with the prior art, through the unified management of test data, aiming at test data with different formats of each professional test, a data structure capable of flexibly configuring a data format is adopted, the measured value generated in the test is stored into a preset measured value storage table, the parameter information corresponding to the measured value is stored into a preset parameter information table, the measured value and the parameter information are stored separately, the storage format of the measured value can be ensured to be a preset format meeting the requirements, the measured value can also be stored uniformly aiming at the test data with different formats of the test, the measured value is associated with the corresponding parameter information through each unique identifier, the physical significance of the measured value can be ensured to be obtained simultaneously when the measured value is read and analyzed, the data analysis is convenient, the data storage, the analysis and the derivation are convenient, and the data is not required to be processed additionally by manpower, the device saves trouble and labor, can prevent phenomena of data confusion, data loss and the like in data management caused by human factors, and has more efficient data management.
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and may be performed in other orders unless explicitly stated herein. Moreover, at least a portion of the steps in the flow chart of the figure may include multiple sub-steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed alternately or alternately with other steps or at least a portion of the sub-steps or stages of other steps.
The foregoing is only a partial embodiment of the present application, and it should be noted that, for those skilled in the art, several modifications and decorations can be made without departing from the principle of the present application, and these modifications and decorations should also be regarded as the protection scope of the present application.
Claims (10)
1. A test data processing method is characterized by comprising the following steps:
acquiring measurement information of a test, wherein the measurement information comprises parameter information of the test and a measured value corresponding to the parameter information, and the parameter information is used for expressing the physical significance of the measured value;
storing the measured values into a preset measured value storage table, and determining the unique identifier of each measured value; wherein one of the measurement value storage tables is used for storing a corresponding set of measurement values;
and storing the parameter information and the table names of the measured value storage tables into preset parameter information tables, and associating the parameter information with the unique identifier of the measured value corresponding to the parameter information, wherein one parameter information table is used for storing a group of corresponding parameter information and the table names of the measured value storage tables.
2. The test data processing method according to claim 1, wherein the obtaining of the measurement information of the test further comprises:
creating test record information of the test and a unique index of the test, and storing the test record information and the unique index into a preset test information table; wherein, one test corresponds to one test information table;
the storing the measured value into a preset measured value storage table further comprises:
and storing the table name of the measurement value storage table into the test information table.
3. The test data processing method according to claim 2, wherein the storing of the parameter information and the table name of the measurement value storage table into the parameter information table further comprises:
and storing the table names and the unique indexes of the measurement value storage table into a preset data table name list, wherein one test corresponds to one data table name list.
4. The test data processing method according to claim 1, wherein the measurement information further includes a generation time of the measurement value; the acquiring of the measurement information of the test comprises:
receiving a telemetry signal of a test, and converting the telemetry signal into frame format data;
analyzing the frame format data to obtain the measurement information of the test;
the storing the measured value into a preset measured value storage table includes:
searching whether a measurement value storage table corresponding to the measurement information exists or not based on the measurement information;
when there is a measurement value storage table corresponding to the measurement information, the measurement value is inserted into the measurement value storage table at a corresponding generation time.
5. The test data processing method according to claim 4, wherein when there is no measurement value storage table corresponding to the measurement information, the method further comprises:
establishing a test information table, a measurement value storage table and a parameter information table corresponding to the test;
storing the measured value into the measured value storage table according to the generation time;
storing the parameter information and the table name of the measured value storage table into the parameter information table, and associating the parameter information with the unique identifier of the measured value corresponding to the parameter information;
and creating test record information of the test and a unique index of the test, and storing the test record information of the test and the unique index of the test into the test information table.
6. The test data processing method according to claim 3, wherein the storing of the table name and the unique index of the measurement value storage table into a preset data table name list further comprises:
receiving a test data analysis request, wherein the test data analysis request at least comprises at least one of test record information of analyzed test data, the unique index and the name of the measured value storage table;
acquiring a parameter information table and a measurement value storage table corresponding to at least one of the test record information, the unique index and the measurement value storage table name;
and extracting the parameter information in the parameter information table and the measured value in the measured value storage table for analysis to obtain an analysis result, and displaying the analysis result according to a preset format.
7. The test data processing method according to claim 3, wherein the storing of the table name and the unique index of the measurement value storage table into a preset data table name list further comprises:
receiving a test data export request, wherein the test data export request at least comprises at least one of test record information of analyzed test data, the unique index and the name of the measured value storage table;
acquiring a parameter information table and a measurement value storage table corresponding to at least one of the test record information, the unique index and the measurement value storage table name;
and deriving the parameter information in the parameter information table and the measured value in the measured value storage table according to a preset format.
8. A test data processing apparatus, comprising:
the device comprises a measurement information acquisition module, a measurement information acquisition module and a measurement information acquisition module, wherein the measurement information acquisition module is used for acquiring measurement information of a test, the measurement information comprises parameter information of the test and a measurement value corresponding to the parameter information, and the parameter information is used for expressing the physical significance of the measurement value;
the measured value storage module is used for storing the measured values into a preset measured value storage table and determining the unique identifier of each measured value; wherein one of the measurement value storage tables is used for storing a corresponding set of measurement values;
and the parameter information storage module is used for storing the parameter information and the table names of the measurement value storage tables into preset parameter information tables and associating the parameter information with the unique identifier of the measurement value corresponding to the parameter information, wherein one parameter information table is used for storing a group of corresponding parameter information and table names of the measurement value storage tables.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the test data processing method of any one of claims 1 to 7 when executing the program.
10. A computer readable storage medium storing at least one instruction, at least one program, a set of codes, or a set of instructions, which is loaded and executed by a processor to implement a method of test data processing according to any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110638660.2A CN113220698A (en) | 2021-06-08 | 2021-06-08 | Test data processing method, device, equipment and computer readable storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110638660.2A CN113220698A (en) | 2021-06-08 | 2021-06-08 | Test data processing method, device, equipment and computer readable storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN113220698A true CN113220698A (en) | 2021-08-06 |
Family
ID=77083234
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110638660.2A Pending CN113220698A (en) | 2021-06-08 | 2021-06-08 | Test data processing method, device, equipment and computer readable storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113220698A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114153929A (en) * | 2022-02-08 | 2022-03-08 | 星河动力(北京)空间科技有限公司 | Test data interpretation method and device, electronic equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101532853A (en) * | 2009-04-21 | 2009-09-16 | 北京国科环宇空间技术有限公司 | Automatic interpretation method and device |
| CN102520715A (en) * | 2011-12-28 | 2012-06-27 | 北京航空航天大学 | Universal satellite ground overall control test system |
| CN104331446A (en) * | 2014-10-28 | 2015-02-04 | 北京临近空间飞行器***工程研究所 | Memory map-based mass data preprocessing method |
| WO2016035126A1 (en) * | 2014-09-01 | 2016-03-10 | 富士電機株式会社 | Testing device for testing drive device for performing drive control of electric motor |
| CN108399154A (en) * | 2017-12-28 | 2018-08-14 | 北京金科汇智科技有限公司 | Engineering test data collecting system |
| CN109978499A (en) * | 2019-03-18 | 2019-07-05 | 张东 | A kind of subsequent telemetry immediate processing method of more survey stations |
| CN111078694A (en) * | 2019-11-29 | 2020-04-28 | 航天恒星科技有限公司 | Data storage method and device |
-
2021
- 2021-06-08 CN CN202110638660.2A patent/CN113220698A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101532853A (en) * | 2009-04-21 | 2009-09-16 | 北京国科环宇空间技术有限公司 | Automatic interpretation method and device |
| CN102520715A (en) * | 2011-12-28 | 2012-06-27 | 北京航空航天大学 | Universal satellite ground overall control test system |
| WO2016035126A1 (en) * | 2014-09-01 | 2016-03-10 | 富士電機株式会社 | Testing device for testing drive device for performing drive control of electric motor |
| CN104331446A (en) * | 2014-10-28 | 2015-02-04 | 北京临近空间飞行器***工程研究所 | Memory map-based mass data preprocessing method |
| CN108399154A (en) * | 2017-12-28 | 2018-08-14 | 北京金科汇智科技有限公司 | Engineering test data collecting system |
| CN109978499A (en) * | 2019-03-18 | 2019-07-05 | 张东 | A kind of subsequent telemetry immediate processing method of more survey stations |
| CN111078694A (en) * | 2019-11-29 | 2020-04-28 | 航天恒星科技有限公司 | Data storage method and device |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114153929A (en) * | 2022-02-08 | 2022-03-08 | 星河动力(北京)空间科技有限公司 | Test data interpretation method and device, electronic equipment and storage medium |
| CN114153929B (en) * | 2022-02-08 | 2022-07-22 | 星河动力(北京)空间科技有限公司 | Test data interpretation method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104699613B (en) | A kind of spacecraft-testing demand automatic creation system and its method | |
| CN111813680B (en) | Method and device for generating test script, computer equipment and storage medium | |
| CN112597028A (en) | Method and device for displaying case test result and readable storage medium | |
| CN113221362B (en) | Satellite launching field performance test subject purpose selection method and device and electronic equipment | |
| US8316023B2 (en) | Data management system | |
| CN113220698A (en) | Test data processing method, device, equipment and computer readable storage medium | |
| CN110750434A (en) | Interface testing method and device, electronic equipment and computer readable storage medium | |
| CN114141302A (en) | Test method of solid state disk and electronic equipment | |
| CN117215932A (en) | Display method and device for code increment coverage information and electronic equipment | |
| CN114741358B (en) | Component parameter detection method, device, computer equipment and storage medium | |
| CN113590581B (en) | Data transmission method, device, equipment and storage medium | |
| CN115827636A (en) | Method for storing and reading simulation data of logic system design from waveform database | |
| CN114168456A (en) | Front-end performance automatic testing method based on 3D-GIS | |
| CN113704099A (en) | Test script generation method and equipment for spacecraft power system evaluation | |
| CN106445524B (en) | SystemC code generation method based on model | |
| CN110866492A (en) | Baseline branch identification method and device and computer system | |
| CN113807100B (en) | Protection device calculation model auditing method and device based on source end data | |
| CN114448851B (en) | Automatic data testing method and system | |
| CN111309623B (en) | Coordinate class data classification test method and device | |
| CN113971126A (en) | Test case generation method and system based on automobile instrument test | |
| CN117113720A (en) | Method and device for evaluating durability of vehicle body | |
| CN116010349A (en) | Metadata-based data checking method and device, electronic equipment and storage medium | |
| CN112363925A (en) | Method for acquiring vehicle-mounted machine basic information, electronic equipment and computer storage medium | |
| CN113722302A (en) | Data management method and device | |
| US20110213637A1 (en) | Requirements engineering tool called requirement editor |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: Room 403, Floor 4, Building 2, Yard 15, Ronghua South Road, Daxing District, Beijing Economic-Technological Development Area, 100176 Applicant after: Beijing Xinghe Power Aerospace Technology Co.,Ltd. Applicant after: Beijing Xinghe Power Equipment Technology Co.,Ltd. Applicant after: Sichuan Xinghe Power Space Technology Co.,Ltd. Address before: 100176 room 1301, 13 / F, building 7, yard 15, Ronghua South Road, Beijing Economic and Technological Development Zone, Daxing District, Beijing Applicant before: Xinghe power (Beijing) Space Technology Co.,Ltd. Applicant before: Beijing Xinghe Power Equipment Technology Co.,Ltd. Applicant before: Sichuan Xinghe Power Space Technology Co.,Ltd. |