Development of Boreholes Construction Deviation Tracking Software System: BCDTracking

摘要

Thousands of boreholes must be constructed for coal gas pre-drainage in China underground collieries. The hostile working environment made them so easy to deviate from design and facilitated coal gas outburst accidents. By combining statistical process control chart and automatic drawing technique based on office web components, a comprehensive software system for boreholes construction deviation tracking, named as BCDTracking, was developed. Taking the coal mining working face as a whole, the database of boreholes was built. Using three-tier architecture, the software system was divided into data access layer, business logic layer and user show layer. As the system kernel, business logic layer was implemented through a complex class and its functions involved two parts. One part was a successive workflow, including reading original data, computing inspective data series, computing statistics and drawing control charts. Another part was used for assistant data operations such as data inserting, updating, deleting and exporting. Results showed that BCDTracking was fully considering user experiences and could automatically track boreholes construction deviation effectively.