Development of Comprehensive Acquisition Software for Measurement While Drilling Data Based on VUE Coal Mine

: For the current coal mine directional drilling MWD equipment and system are independent of each other, resulting in different forms of MWD data at the bottom of the hole, forming data islands; Based on the B/S system architecture mode, by comparing the measurement while drilling mode and measurement data format, the requirement module of data comprehensive acquisition system is analyzed; the background database of the integrated collection system is set up to develop the development of the integrated collection system of directional drilling while drilling data in coal mine. The verification shows that the data acquisition system can meet the unified collection and processing of various MWD data, the overall analysis and evaluation function, and achieve real-time data upload. It provides data network transmission guarantee for directional drilling data supervision platform in coal mine, and improves the intelligent level of coal mine drilling.


Introduction
In the process of underground drilling in coal mine, the application of measurement-while-drilling technology is constantly breaking through with the development of measurement-while-drilling equipment. The diversified measurement-while-drilling technology provides an effective data reference basis for the safety production of coal mine. However, due to the development of diversified MWD technologies, each MWD system is independent of each other, and each MWD equipment cannot simultaneously carry out MWD. As a result, each MWD data forms a relative data island, which cannot achieve the effect of data summary, overall analysis and evaluation. Data such as borehole trajectory, borehole bottom engineering parameters, and geological parameters are stored in different formats and paths in the corresponding MWD system. Therefore, it is inconvenient to upload subsequent data to the surface. Therefore, it is urgent to develop a comprehensive collection system of directional drilling MWD data in coal mine. Without affecting the normal operation of each MWD system, data collection and summary, display, analysis and processing, system functions and service monitoring can be carried out on the above borehole trajectory parameters, borehole bottom engineering parameters, geological parameters and other data [1][2][3] .
Under the general trend of digital construction in coal mines, a digital platform for directional drilling that meets the actual needs of coal mine drilling is studied, and information such as downhole drilling rig parameters, drilling site environmental parameters and MWD parameters are uniformly managed to realize remote monitoring of downhole equipment, real-time data acquisition and automatic processing, and data analysis and mining in the drilling process. Lay a good foundation for the construction of digital mine.

Overall system architecture design
The comprehensive acquisition system of directional drilling while drilling data designed and developed in coal mine is installed in the explosion-proof computer in the drilling field of coal mine. It acts as a bridge for uploading the measurement while drilling data of directional drilling to the coal mine ground, and the front end is connected to the data measured by the measurement while drilling instrument and system. By using the Internet of Things technology [4][5][6] in the down-well mining area, real-time data uploading can be realized and the back-end of the drilling data monitoring platform on the coal mine ground can be connected to the drilling data monitoring platform on the coal mine ground, which can achieve the real-time monitoring effect of the drilling construction data in the underground drilling field, and also provide early guarantee and data source support for the real-time monitoring and management platform of drilling data in the coal mine.
The comprehensive acquisition of MWD is divided into three parts from the parameter measurement types: drilling track parameter measurement, engineering parameter measurement and geological steering parameter measurement. The track parameter includes inclination, tool orientation Angle and azimuth Angle. Engineering parameters include hole bottom weight, torque, speed, etc. Geological steering parameters include the combination of multiple parameters such as natural gamma and resistivity and trajectory parameters.
(1)The research of drilling trajectory parameters mainly focuses on the data transmission mode, including wire transmission, mud pulse transmission and electromagnetic wave transmission.
Wireline MWD technology refers to the transmission of the hole bottom measurement signal to the hole instrument through the special cable drill pipe. The cable drill pipe has the functions of transmitting the torque of the drill rig, the weight on bit, transporting the washing fluid and supplying power to the measuring probe through the explosion proof computer at the hole. Mud pulse transmission technology uses high pressure washing fluid as power, drives screw motor rotary rock breaking drilling, and circulating water as communication medium.
The electromagnetic wave transmission transmits information through the drill pipe and the coal-bearing formation. The low-frequency electromagnetic wave is used as the signal carrier, and the signal transmission does not depend on the cable drill pipe and drilling fluid, and has the characteristics of short measurement time and stable signal transmission.
(2) During the drilling construction of underground coal mine, the engineering parameters are mainly displayed by the instrument on the hole drilling machine, which is different from the actual engineering parameters at the bottom of the hole, which is easy to lead to the operator's misjudgment and control lag. The YZD-15T developed by CCTEG Xi'an Research Institute mine intrinsic safety multi-parameter measurement pipe is mainly used for real-time monitoring of engineering parameters such as torque, weight on bit, inner and outer annulus pressure, rotational speed, vibration and temperature near the bottom of hole, which can truly grasp the state of bottom hole drilling, provide effective parameter control for intelligent drilling in coal mine, and improve the safety and accuracy of underground coal mine drilling construction.
(3) At present, there are many research and development of natural gamma measurement-while-drilling devices in the domestic coal mining industry. Wang Kaibin [7] et al. developed a drilling while drilling instrument based on natural gamma, and realized multi-azimuth static azimuth gamma measurement and omnidirectional gamma measurement. But this instrument can only be used for sliding drilling measurement, not for rotary drilling, azimuth imaging can not be realized, and the working efficiency is low. To solve this problem, Chen Long [8] developed a dynamic azimuthal gamma instrument for mining. The instrument adopts a shield and window structure design to realize the 8-sector measurement of single gamma crystal. Based on the different frequency characteristics of triaxial MEMS acceleration sensor and triaxial MEMS gyroscope, the accuracy of the instrument was verified through surface and underground tests.
According to the data collection of measurement-whiledrilling data, the requirements analysis of coal mine surface is uploaded to form the architecture diagram of the comprehensive acquisition system of measurement-while-drilling data, as shown in Figure 1. The acquisition end contains the measurement while drilling instrument and the measurement while drilling system to form the data source. All kinds of data are stored in the software of the measurement while drilling system to the explosion-proof computer of the drilling field in the coal mine, and the comprehensive data acquisition system reads the data while drilling stored in the explosion-proof computer, classies the data and stores it in the background database. The Web side of the comprehensive data acquisition system can log in the browser to view the data, and monitor the data and devices in real time. At the same time, the integrated data acquisition system can upload the MWD data stored in the background database to the surface in real time through the explosion-proof computer and through the industrial network in the well.

System function module analysis
The type of measurement data while drilling in underground coal mine is planned systematically, including data generated by wired measurement, mud pulse, wireless electromagnetic wave, geosteering and other measurement while drilling methods. According to the actual demand status and integration degree of MWD instruments for underground drilling in coal mines, MWD data modules in the first phase of the system are classified into three types: inclination track parameters (wireline MWD parameters), engineering parameters and rotary steering parameters；The system based on B/S architecture needs to have user information, login permission, data and service monitoring and other functions, It can be divided into two functional modules: system management and system monitoring. Therefore, the system is divided into five functional modules: system management, system monitoring, inclinometer trajectory, engineering parameters and rotary steering, The first two modules focus on the system management aspect, while the last three modules focus on measurement while drilling data.

Design and development of system
The comprehensive acquisition system of directional drilling while drilling data based on B/S architecture is deployed in the underground explosion-proof computer, The front-end page uses VUE development, and the back-end uses Spring Boot framework to simplify coding, configuration, deployment and monitoring, you can use http requests to view details such as property configuration, thread working status, and environment variables [9] . The measurement data while drilling is read and stored in the database. The Redis high-performance key-value database is used to send the data to the coal mine. It has highspeed and efficient read and write ability and supports master/slave synchronization, which helps improve read and write scalability and data redundancy.
After the framework design of the data comprehensive acquisition system is completed, relevant system function modules are designed according to the framework requirements. The system is based on B/S architecture design, S terminal (server) is mainly the application of database, The B side (browser) uses the browser to access the local database service where the MWD data is stored, Display measurement data while drilling on Web and monitor and manage each system. System function modules are mainly embodied in the browser, specific modules can be divided into the following five parts： (1)System management module ： Play a system administrator role, which is divided into user management, role management, menu management, and log management. System user management is to add, modify, and delete users; system role management is the management of user rights. Different access rights are set for users at different levels. Different access rights display different content. in addition, the permission setting needs to be customized according to the actual employee level in the mining area [10] ;System menu management is to add, delete and modify the system menu. The system has set three kinds of data contents, namely rotary steering, engineering parameters and incline measurement; system log management monitors and manages user operations and logins, operation content monitoring, for example, user operation type, user name, user login IP address, operation status, and operation date; login content monitoring includes the user name, IP address, browser, operating system, user login status, and login date.
(2)System monitoring module： Monitor the background data status of the system, which is subdivided into three parts: data monitoring, service monitoring and cache monitoring. Data monitoring You can monitor data sources, databases, Web applications, and URIs, such as database user names, connection addresses, database types, number of transactions started, maximum concurrency, and number of threads.
(3)Rotary steering module：This paper presents a list of parameters of rotary steerable tools while drilling, Parameters such as push force and tool facing Angle of push hand during drilling of rotary steerable tool were obtained in real time, and the vector sum of the three push hands was calculated in real time, To provide reference for drilling tool deviation, and monitor the real-time speed of drilling tool.
(4)Engineering parameter module：The list of engineering parameters obtained from MWD is presented, Engineering parameters mainly include annular pressure inside and outside hole bottom, rotational speed, hole bottom temperature, torque, weight on bit and axial vibration during drilling, which can be used for comprehensive evaluation of hole bottom drilling during drilling.
(5)Survey data module ： The trajectory parameters of drilling are displayed in a list, which are subdivided into three parameter lists: borehole attributes, the footage of a single borehole, and drilling formation information. The drilling parameters of a single hole include hole depth, dip Angle, azimuth Angle, upper and lower horizontal displacement, left and right displacement and deviation, and mild magnetic field, etc, Through the penetration parameters of a single hole, the trajectory of the drilling process can be understood. The formation information of drilling is mainly used to show the distance, azimuth Angle, dip Angle and other parameters from the top and bottom of the drilling, which plays a timely adjustment role in the drilling process.

System testing
So far, the design of the framework structure of the data comprehensive acquisition system has been completed, and the function of the module has been analyzed and realized. In order to test whether the performance of the system can meet the requirements of borehole data acquisition in underground coal mine, the inclinometer data showing the borehole trajectory is mainly tested.
Enable the services required by the system and integrate the services to a.bat file, enable local services such as Redis, nginx, ActiveMQ, and database with one click. This test was connected to the MWD pipe, and the MWD data was manually saved in the MWD system as an Excel file ( Table 1).The background database on which the service is enabled reads the saved files while drilling. The obtained measurement data while drilling can be viewed on the Web page, as shown in Table 2.

Test conclusion
By comparing the measurement while drilling data with the list of data read by the system in real time, the system can meet the function of reading the measurement while drilling data in real time and displaying the list, However, the order of the list displayed on the Web page is different from that of the list of measurement data, and the accuracy of the data is different [11] . These two differences have little influence on the 3D trajectory display of the subsequent inclination survey trajectory data uploaded to the digital platform, which can be ignored.The test results show that the system has the functions of reading and listing the measurement data of borehole while drilling, which lays the foundation for uploading the subsequent data. The test results show that the accuracy and real-time performance of trajectory parameters, engineering parameters and drilling site environmental parameters meet the requirements of site construction. The whole process of drilling data is recorded and can be queried, analyzed and traced at any time.

Conclusion
In view of the inconvenience of data monitoring caused by the diversity and relative independence of measurement data while drilling in coal mine, the types and file formats of measurement while drilling data are analyzed, Build background database, use VUE to develop front page, and realize data reading, storage, sending, receiving and other functions [12][13][14] , Unified monitoring, management, integration and analysis of different drilling data, Effectively guide the construction of drilling while drilling borehole in coal mine, to speed up and improve the efficiency of coal mine safety production; At the same time, the system reserves interfaces to facilitate subsequent access to new measurement while drilling technologies, further improving system compatibility, With the help of mining area industrial network, 5G/WIFI6 and other network foundations, high-speed data uploading is realized, which provides effective data support for the monitoring and management platform of underground drilling data of coal mine, and further promotes the intelligent development process of coal mine. By the way, Multi-parameter integrated measurement technology of hole bottom. In the process of underground drilling in coal mine, due to the narrow installation space of instruments and the harsh working environment, the drilling track parameter measurement is still the main method. The trajectory parameters, engineering parameters, gamma parameters and resistivity parameters are not integrated, and the information of each parameter still needs different probe tubes. Considering the installation layout of all kinds of sensors, through the optimization design of the measuring probe structure, the integration of all kinds of parameter sensors can ensure the overall strength of the measuring probe. Due to factors such as drilling tool weight, geological conditions, drilling parameters, drilling technology and personnel, the actual drilling track and the design track will have a certain deviation, which will affect the efficiency of gas extraction and water control. According to the borehole bottom drilling parameters obtained by multiple sensors in real time, artificial intelligence algorithm technology is used in the remote control center to analyze the trajectory parameters, geological parameters and engineering parameters while drilling in real time, and realize the dynamic adjustment and optimization of the drilling trajectory