A packaging testing result data storage method, query method and system

Abstract

The invention discloses a storage method and a query method and system of data of a package test result. The storage method comprises the steps of: step (1), establishing a value table, which is used for storing values of the package test result, in a package test result database, and storing the values of the package test result into the value table; step (2), respectively establishing an attribute table and a state table, which are used for storing attribute information and state information of the package test result, in the package test result database, and respectively storing the attribute information and the state information of the package test result into the attribute table and the state table, wherein the attribute information of the package test result includes a package test method and a package test standard, the state information of the package test result includes a normal state and failure states, and the failure states include an invalid state, an above-standard state and a below-standard state; and step (3), using a time dimension to respectively correlate the value table with the attribute table and the state table.

Description

technical field [0001] The invention relates to a data storage method, a query method and a system for packaging detection results. Background technique [0002] With the continuous progress of social economy and science and technology, people have higher and higher requirements for the quality of commodity packaging and the performance and safety of packaging materials. Therefore, in order to ensure the stability of the actual packaging effect, the packaging material testing industry has emerged as the times require, and plastic packaging material testing is an important field in packaging material testing. [0003] At present, whether it is a laboratory built by an enterprise or an organization, a government testing agency or other third-party testing agencies, there are the following methods when processing packaging test result data: [0004] (1) Generally, a single test result data is recorded manually or by simple information software. The current packaging material t...

AI Technical Summary

Problems solved by technology

[0004] (1) Generally, a single test result data is recorded manually or by simple information software. The current packaging material testing basically maintains a long-term, stable and continuous testing process. This traditional method It is difficult to query the previous test result data of the overall packaging test material, and this traditional method consumes a lot of manpower and material resources, and the storage and later reuse rate of test result data is low, resulting in a large waste;

[0005] (2) Due to the trend of diversification, all data and indicators are also developing in a multi-dimensional direction. Recording a packaging test result data requires many dimensions such as testing methods, testing time, and data validity. Traditional recording methods cannot integrate these multi-dimensional The information is completely stored and associated in the database, and effective queries cannot be performed;

[0006] (3) In the previous method of processing packaging test result data, the data was only stored, and the fault data was not recorded in relation to the cause of the fault data and the fault solution. In this way, when there is a problem with the packaging test result data, It is difficult for inspectors to quickly make reasonable solutions by referring to similar situations that have occurred before, and they can only re-analyze the data to find problems and solutions to problems, resulting in low utilization of historical data of packaging inspection results, resulting in a greater waste

Images