A method of organizing data for storing the results of tests run on electrical products

详细

When testing electrical products, a large number of different parameters are analyzed, processed, and stored. To ensure long-term storage and fast processing of the data, the way in which time series are stored needs to be optimized. Existing solutions do not allow simultaneously collecting a large amount of parameters with different structure and high accuracy. A data storage method based on isolation and storage of the approximating function and errors is suggested. An expression that determines the efficiency of the approximation by computing the Shannon information entropy is obtained. This article considers the effect produced by the accuracy of source data storage upon the value of entropy and hence the final volume of the data. Permissible errors of the change in many parameters of electrical products are within the range of 0.5–1.0%, which enables one use to storage of approximating functions instead of the numerical source data. To approximate the parameter values, an intermediate storage—or a buffer—is required, for which time series’ databases could be used. The suggested method can be easily integrated in databases of document-oriented type. The flexible structure of representation of testing parameter values, along with schemaless representation of document- oriented databases, allow construction and integration of information systems of varying complexity.