Development Of The Application System Of Database For Tunneling Blasting Design

With the development of the foundation establishment in our highway and railway, the number of various kinds of tunnel and underground engineering projects increases greatly. The blasting technique has been widely used in a majority of tunnel construction because of its characteristics such as the agility, convenience, celerity. The quality and velocity of tunneling blasting design directly affect the safety, quality cost and time period of the tunnel construction. How to put an end to the backward phase of manual calculating and plotting in design as well as manual working-out the construction schedule and carrying through the construction quality management, which has become one of the problems to be urgently solved in blasting engineering and tunnel engineering.Through the investigation into the actuality of tunneling blasting design and construction management as well as the database technique for computer, the feasibility that the computer method replaces the manual management for the data of the tunneling blasting design was discussed in this thesis. The systematization, standardization and automatization of the tunneling blasting design and construction management may be realized.Proceeding from the principle and method of tunneling blasting design, the parameters and data related to the blasting design were selected, which included the geological data in the blasting region, the design data before blasting and the relative data of primary and detail design in blasting. Combining the database technique with the parameters and data type related to blasting design, the database structure and its datasheet structure suited to the tunneling blasting design were determined by adopting relation data model and optimizing data mode according to 3NF.The database bps of tunneling blasting design was established by using the database system (Microsoft Access) suited to blasting design. Based upon the datasheet structure, all of the datasheets and their main keys, indexes, relations were also established, which makes the data in the blasting database meet the needs of security, consistency and integrality in operation and management.Taking Visual C++ as the tool of the application system programming of tunneling blasting database and selecting MFC ODBC as the developing technique of the database system, the application system of tunneling blasting database wasobtained. This system consists of five parts which are system manage, blasting data, primary design, detail design and construction information manage. The system menus and their dialog box interfaces were also given in the application system, which makes it possible to manage and operate the database bps of tunneling blasting in the dialog box interface. Therefore, it was realized that users may manage and operate the data in the process of the tunneling blasting design through the application system of the tunneling blasting database.