The Design And Realization Of Real-time Logistics Data Query System Based On Strom

The one integrated intelligent technology in logistics distribution, which is called intelligent logistics based on Internet of things, it provides more abundant management information and makes logistics obtain the ability of thought, perception, analysis of learning and solving the problem automatically, so that the logistics will storage and transport the goods more efficiently, fast, and conveniently. Nowadays, the electronic commerce develop rapidly, intelligent logistics has become an important area of research. Traditional logistics information management system requires location information of goods through cargo note,it can not tracking of the information of goods in real-time, such as detailed location, temperature, humidity and so on, but intelligent logistics can, it transmit the information to the server through the sensor in real-time so that the user can query them, at the same time, the amount of logistics information data also grow explosively, but the performance bottleneck in traditional logistics comes out because of computing in one node, so, it can’t handle huge amounts of data in the management system of logistics. On the other hand, logistics data produce continuously, it has the characteristic such as limitless, real-time, diversity, and people tend to processing them to get result in real-time, personalized query, traditional logistics information management system can’t satisfy the real time data query. In view of the problems above, this paper researches the twitter’s storm, a real-time distributed stream processing platform, and stream, a data flow management system designed by Stanford university, and designs a logistics data real-time logistics data query system based on storm for the real-time logistics data, mainly do the following research work.First of all, this paper designs CSQL(Continue Structured Query Language) for users to interact with the real-time logistics query system, and the lexical grammar parser of CSQL is developed by a open source tool called Antlr. The paper researches the Continues Query Language in stream system, select some CQL support the monitoring query, the simplify the query rules in the CQL based on SQL, it provides prompt information about the wrong key words and error message about the grammar wrong status through the lexical syntax parsing. These features make that the data administrator will be able to use a simple query to achieve capabilities to analyze complex data.Second, this paper finished the design and coding of three modules as follows:(1) the extraction of query semantic;(2) generating logic tree;(3) submitting physical topology. For the right query status that pass lexical and syntactic parsing, the server will extract its semantic, and generate a logic tree combined with the semantic, then, the server will select and combinate the operators in the operators set, finally, the server generate the final physical topology and submit the final topology to the storm-plartform. So, the users who do not know the storm-platform well will submit distributed query tasks easily.Finally, this paper designs and implements a client called JRDT(Java Real-time Develop Tool),which likes the jdbc, to operate the system remotely. JRDT is implemented by java, it provides landing, creating a stream, querying, monitoring and closing the stream function, users can be able to interact with the system by the client friendly. JRDT prepared a visual interface by using of java swing frame, users can be more intuitive to interact with the server by visual interface, so that data administrators can interact with system more visually,query results or get results for further processing with it.