Founded in 1971 >
Chinese Sci-tech Core Periodicals >
British Science Abstracts (SA, INSPEC) Indexed Journals >
United States, Cambridge Scientific Abstract: Technology (CSA: T) Indexed Journals >
United States, Ulrich's Periodicals Directory(UPD)Indexed Journals >
United States, Cambridge Scientific Abstract: Natural Science (CSA: NS) Indexed Journals >
Poland ,Index of Copernicus(IC) Indexed Journals >
International Standard Serial Number:
ISSN 1001-4551
Sponsor:
Zhejiang University;
Zhejiang Machinery and Electrical Group
Edited by:
Editorial of Journal of Mechanical & Electrical Engineering
Chief Editor:
ZHAO Qun
Vice Chief Editor:
TANG ren-zhong,
LUO Xiang-yang
Tel:
86-571-87041360,87239525
Fax:
86-571-87239571
Add:
No.9 Gaoguannong,Daxue Road,Hangzhou,China
P.C:
310009
E-mail:
meem_contribute@163.com
Abstract: 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 125ms to 208ms when the data volume reaches 7.2×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 1308ms, which is 61.64% faster than the scheme of “ascending key + searching key”. Aggregating and summarizing 1×105 parts data within multiple measurement nodes takes approximately 5s. This storage cluster can monitor the production status of parts and plays an important role in improving manufacturing efficiency and quality.
Key words: online measurement of parts; distributed data storage; tag-aware sharding; MongoDB; embedded measuring instrument; manufacturing execution system(MES)
-
- Chinese Core Periodicals
-
- Chinese Sci-tech Core Periodicals
-
- SA, INSPEC Indexed
-
- CSA: T Indexed
-
- UPD:Indexed
-
2010 Zhejiang Information Institute of Mechinery Industry
Technical Support：Hangzhou Bory science and technology
