Design And Implementation Of Historical Data Analysis System For Hazardous Chemicals Transportation Based On CASSANDRA Database

This paper based on the characteristics of the Cassandra database,designs a property data storage model for a large number of historical sensor data which produced by the transportation of dangerous chemical tank trucks,and combines the analysis of historical data,analyses the scalability and reliability of historical data storage,designs and implements a historical data analysis system.According to the characteristics of the historical sensing data of the dangerous chemicals transportation vehicles,fully use the A and P features of the Cassandra database,design and practice of the data storage structure.Using two different data bases--the relational database system MYSQL and the NOSQL database Cassandra as the supports system to design data module and stores the same amount of historical data,then do the same function query for verification under the same environmental conditions.After comparison,analysis and testing,it shows that the selection of Cassandra database and design a reasonable modeling scheme in storing historical data have obvious advantages in reducing the time of query,maintaining the balance of data load,and realizing the dynamic expansion of the data nodes.Transportartion of dangerous chemicals is a transportation of dangerous sources.At the same time,these dangerous chemicals are kinds of strictly restricted sales commodities,but theft of dangerous chemicals occurs frequently.Therefore,monitoring and tracking the number of import and export of materials and restricting the behavior of the those who in the dangerous chemicals transportation vehicles are two of the main things that the public security transport management department concerns about.Through the analysis of historical data,the scientific means to verify the authenticity of the volume of import and export,the audit of the driving route and the driver's illegal driving are the necessary means to eliminate the accidents of dangerous chemicals.In this paper put forward a put-in or put-out state recognition algorithm which based on sliding window can be used to calculate the volume of put-in or put-out through the analysis of historical sensor data.The GPS data can be used to verify and analyze the vehicle trajectory,tracking and analyzing the drivers' behavior.The system has provided advanced technical support for audit tracking of dangerous chemicals transportation.In addition,this paper also gives the reference points for the design of data storage model for different requirements under the Cassandra database platform,based on the principle of anti normalization of data model design ideas and query requirements as the driving principle.According to the actual demand,put forward the system framework and the overall design reference of Cassandra database in practical application.