Design And Implementation Of Landslide Data Server

In recent years,frequent landslide disasters have caused serious threats to people's lives and property safety.In view of this situation,it is of practical significance to establish a landslide early warning mechanism.At present,the communication mechanism of landslide monitoring and warning system is simple and the traditional database is used to store the landslide monitoring data.With the increase of monitoring time and monitoring sites,the traditional centralized database can no longer support the processing requests with such a large amount of data.As a result,the database performance has become one of the main bottlenecks of the landslide monitoring system performance.Therefore,this thesis designs and implements a landslide data server.The data server implements the function of forwarding data interaction commands between the client and the concentrator,receiving and parsing the mountain data uploaded by the concentrator,and storing the mountain data to the back-end distributed database cluster,which effectively ensures the security of data communication and the efficient processing ability of the system for data.The thesis uses Netty,Jsql Parser framework,consistency hash and other technologies to design the landslide data server.The landslide data server is divided into three parts:communication service layer,front-end service layer and back-end connection layer.The communication service layer is responsible for forwarding the configuration commands between the client and the concentrator,receiving the mountain data uploaded by the concentrator,and storing the data in the back-end database cluster.At the same time,this layer also performs heartbeat detection on the concentrator by polling.The front-end server layer is responsible for validating permissions on the data requesting side,parsing,refactoring and routing SQL commands,encapsulating the query result set as My Sql packets for return,and maintaining the back-end connection object pool.The back-end connection layer is responsible for establishing a connection with the back-end database cluster,receiving and parsing My Sql packets returned by My Sql,detecting the heartbeat by polling the back-end database cluster,and restoring the connection through the offline reconnection mechanism to ensure stable communication.The landslide data server designed in this thesis can directly replace the server of the original system,making only a few code changes to the upper and lower machines in the original system,and it has the advantages of efficient query and storage.In the laboratory environment,the server completed the client's forwarding of the concentrator configuration commands and the receiving and parsing functions of the concentrator's data packets.In addition,it also stores the mountain data to the back-end distributed cluster through repository and table-breaking middleware.The experimental results show that the landslides data server basically meets the design requirements,and achieves the design expectations in terms of data transmission security,data storage and query functions and performance.Compared with the traditional centralized database landslide data server,the efficiency of mountain data management is obvious.