Design And Implementation Of The Blasting Design Software For Tunneling

Blasting method is easy to use, low cost and high efficiency compared with mechanical excavation, which is widely used and has achieved good results. However, the process of tunnel blasting design and construction currently still relies on manual power to complete the arrangements. This method has become a tunneling construction bottleneck. It is not only time-consuming but also prone to make mistakes. The most important is that it relies heavily on the experience of construction workers and can’t make use of historical blasting scheme and experience to guide blasting design in the future. Therefore, it is necessary to develop the tunnel blasting design software for accelerating tunnel blasting design and improve efficiency of tunneling construction.This thesis studied on the mathematical model of tunnel blasting deeply and add the pre-design process to optimize the blasting mathematical model based on original model, designed and implemented the basic blasting design module based on the blasting mathematical model. Meanwhile, in order to take advantage of the historical blasting case and enhance the intelligence of the system, introduced the case-based reasoning related technology into the tunnel blasting design, designed and implemented the intelligent blasting design module based on case-based reasoning. In the case retrieval part, improved the traditional KNN algorithm in normalization, feature weight, parallelization and other aspects for the features of tunnel blasting design. In the aspect of case database optimization, in order to speed up the case retrieval and enhance concurrency partitioned the case database logically by creating cluster index on height and width of tunnel so that the cases which have the same size will cluster together on the physical disk and proposed a delay and batch case refining algorithm based on DBSCAN to remove the redundant case.This thesis also analyzed the data stream of tunnel blasting design, designed and implemented composition and structure of the database of tunnel blasting design software. The tables is divided into five categories altogether fifteen database table, and there are fangan, zbwd, zbwdinfo, hgpwd, hgpwdinfo in the blast category. Appropriate views has been created in order to enhance the data independence and simplify the complexity of the application layer.Focusing on blasting design module and increasing four auxiliary modules including the basic data management module, project management module, construction management module, user authentication module. Using C# language and C/S structure to complete the blasting design software for tunneling. The practical application demonstrated the availability and easy of use of the system, and verified the reasonability and correctness of the improvements made to the blasting design as well.