A flexible method for converting non-relational text data to relational data for data acquisition of equipment operation
Guanbing Xiang, Xiaoyuan Ji, Jianxin Zhou, Yajun Yin, Xu Shen · Procedia Manufacturing · 2019
Whether in the field of manufacturing, scientific research or other aspects, some structured non-relational data generated by equipment operation is stored in the form of text files, these non-relational text data forms are scattered, data formats are diversified, and the lack of overall storage framework structure makes it difficult to read data, manage and reuse data. To solve this problem, this paper presents a flexible method to convert non-relational text data to relational data for equipment operation data collection. This method establishes a mathematical model of row and column retrieval based on string group, defines flexible conversion template, develops and designs a flexible conversion software of non-relational data to relational data, and realizes the recognition and conversion of TXT file content timing increment. The results show that the relational data obtained by this conversion method has obvious structure and regularity, which can reduce the complexity of the data, so as to achieve better equipment interconnection and monitoring in the future.