Journal of East China Normal University(Natural Science) ›› 2022, Vol. 2022 ›› Issue (5): 195-207.doi: 10.3969/j.issn.1000-5641.2022.05.016

• Spatio-temporal Data Analysis and Intelligent Optimization Theory for Logistics • Previous Articles    

Indexing and query technology for steel logistic data

Tao ZOU, Rongtao QIAN, Jiali MAO*()   

  1. School of Data Science and Engineering, East China Normal University, Shanghai 200062, China
  • Received:2022-07-23 Online:2022-09-25 Published:2022-09-26
  • Contact: Jiali MAO E-mail:jlmao@dase.ecnu.edu.cn

Abstract:

With digital transformation and the development of iron and steel logistics, the scale of iron and steel logistic data has rapidly expanded, and traditional relational databases can no longer meet the storage and query needs. Considering that a distributed not only structured query language (NoSQL) database has a simple expansion capability, fast reading and writing speeds, and low cost, in this study, distributed cloud storage and NoSQL technologies are used to store and build indexes for massive steel logistic data, improving the accuracy of the storage capacity and query performance of the logistic data. First, Spark is used to associate and fuse the data from different sources, and then store and manage the historical and real-time data generated by the freight platform in a hierarchical manner. It then builds spatiotemporal and attribute indexes for the three types of queries mainly involved in steel transportation to achieve an efficient query of multi-source logistic data. Finally, the experimental results based on real steel logistic data show that the proposed scheme is superior to traditional relational database methods in terms of data writing, storage, and querying, and can effectively support the storage and querying of massive logistic data.

Key words: steel logistic data, HBase, spatio-temporal index, query

CLC Number: