Open AccessResearch on Multi-dimensional Data Collaborative Virtual Inventory Based on Markov
Author(s) -
Shunkai Sun,
Jie Li,
Haihua Lu,
Qi Xu,
Haobo Cui,
Weilin Cao,
Yingxiao Chi,
Jun Zhou
Publication year - 2021
Publication title -
journal of physics. conference series
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.21
H-Index - 85
eISSN - 1742-6596
pISSN - 1742-6588
DOI - 10.1088/1742-6596/2083/3/032040
Subject(s) - table (database) , computer science , pallet , markov chain , operations research , inventory management , data mining , database , operations management , engineering , machine learning , mechanical engineering
The three-dimensional elevated warehouse is a production equipment, and it is inevitable that it will malfunction during the operation. If it is not handled properly, there will be inconsistencies between information and practice, resulting in inconsistency between inventory information and the actual product. In order to solve the above problems, this project team carried out functional research on various SQL tables of multi-dimensional data collaboration, and constructed a virtual inventory method based on Markov multi-dimensional data collaboration. The behavioral characteristics of the cargo location information in the cargo location table TWMS_LOC and the pallet status table TWMS_PLT are extracted, and the two are compared. If the deviation between the two exceeds the threshold, the status is judged to be no cargo information. Experiments are conducted to test the feasibility and effectiveness of the sentences of the proposed virtual inventory. The results show that the inventory method can better describe the status of the cargo location and information, and effectively realize the virtual inventory at the database level. The research results of this method will completely replace the complicated manual inventory business. It can provide accurate and efficient virtual inventory solutions for similar logistics elevated warehouses.