With the continuous and rapid development of China's national economy and increasing urbanization, freight motor vehicles have increased substantially every year in recent years, and the illegal transportation phenomenon of vehicle overload and overrun is prominent, which not only damages highway infrastructure and causes a large number of road traffic accidents, but also directly leads to vicious competition in the road transport market and chaos in vehicle production and use order; to solve these problems, various highway checkpoints currently apply various monitoring instruments to collect and report truck load data. Since the number of loaded vehicles passing through highway checkpoints is huge, the reported data has exceeded the analysis and processing capability of traditional databases. How to timely store and analyze massive data, and how to quickly provide analysis results to overload control relevant management departments for the next step of work, is an urgent problem for the current customer.