Distributed storage of manufacturing process measurement data based on database tag-aware sharding
In order to solve the problem of data association and aggregation query between multiple measuring instruments during the online measurement process for parts,the distributed storage and sharing methods of measuring were studied.Firstly,non-relational database was used in multiple measuring instrument cluster,which realized distributed storage of measuring data and simplified parts data storage model.Then,tag aware sharding model was used to classify and store the measurement data of different processes.Finally,multiple Raspberry Pi 3 Model B+development boards with embedded Linux were used as the system platforms for the measurement instruments,and MongoDB database was used as online measurement distributed data storage to verify the uniformity and stability of distributed data storage on each node using a large amount of test data.The cluster had been integrated with manufacturing execution system(MES),which could monitor and analyze the measuring data of parts in real time,and quickly summarize the working procedure data in all measuring nodes to generate the report forms.The research results show that the single-node query response speed is stable in the range of 125 ms to 208 ms when the data volume reaches 7.2 x 105 in the cluster,which is 88.15％higher than that of the hashed sharding model,at the same time,the response speed of multi-node cooperative query is 1 308 ms,which is 61.64％faster than the scheme of"ascending key+searching key".Aggregating and summarizing 1 x 105 parts data within multiple measurement nodes takes approximately 5 s.This storage cluster can monitor the production status of parts and plays an important role in improving manufacturing efficiency and quality.
online measurement of partsdistributed data storagetag-aware shardingMongoDBembedded measuring instrumentmanufacturing execution system(MES)
万方数据
维普
