Method and system for storing test data
A test data and storage system technology, applied in the field of data processing, can solve the problems of poor standardization and readability of test data, and achieve stable and universal storage and query, which is conducive to maintenance and high readability
Active Publication Date: 2019-05-17
GOERTEK INC
View PDF5 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0005] In view of the above problems, the purpose of the present invention is to provide a storage method and system for test data, to solve the problem of uploading and checking the test data in the existing storage method, which needs to select the corresponding database table, as well as the standardization and reliability of the test data. poor readability problem
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0020] Specific embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings.
[0021] Aiming at the problems that the aforementioned existing methods for storing test data have complex uploading and viewing operations of test data, and poor standardization and readability of test data, the present invention uses three database tables established in the database to make Users can ignore the relationship between database tables and test items, that is, no matter how many tests a product needs to carry out, and how many test parameters each test has, the invention can store and view test data without having to modify the database tables. The selection judgment is made, so that the storage and query of the test data become more stable and common, the readability of the test data is high, and it is more conducive to the maintenance of the database.
[0022] Wherein, before utilizing the storage method provided by the present ...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention provides a method and system for storing test data, wherein the method comprises the following steps: recording test parameters of a test at this time in a basic information table, and generating a test ID of the test at this time; obtaining test data corresponding to various test parameters of the test at this time, and matching various test parameters of the test at this time in the basic information table with test parameters in a dictionary table one by one; writing a test parameter ID corresponding to the test parameters, which are successfully matched in the dictionary table, the test ID and the corresponding test data in a test data table; and writing the test parameters of the test at this time, which are not successfully matched, in the dictionary table, and distributing the test parameter ID to the written test parameters of the test at this time in the dictionary table, and writing the distributed test parameter ID, the test ID and the corresponding test data in the test data table. By means of the invention, storage and view operations of the test data can be simplified; the readability of the test data is high; and maintenance of a database is facilitated.
Description
technical field [0001] The present invention relates to the technical field of data processing, and more specifically, to a method and system for storing test data. Background technique [0002] In the process of manufacturing products, the manufacturing industry usually needs to conduct various performance tests on products and materials to ensure the quality of products. However, an enterprise often produces multiple products, and each product generally needs to be tested for multiple items, and the performance parameters and numbers of different test items are different. [0003] Therefore, the diversity of the above-mentioned tests will bring many problems to the data collection of the manufacturing execution system of the enterprise and the storage of the data after collection. There are usually two existing data storage methods. One is to create a unique database table for each test item of different products. The column names and numbers of the table are consistent w...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/172
CPCG06F16/2282
Inventor 焦玉乾刘凯凯尚晶文张广平宋永国
Owner GOERTEK INC