Database Management Method for Calculating Drilling Depth

Abstract

The present application provides a method for calculating the drilling depth in database management. S1: Retrieve the roadway data and drilling point data in the database for analysis; S2: Use drilling equipment to effectively drill the drilling points; S3: Collect the data information of the drilling points during drilling; S4: And use a water pressure sensor to monitor the change of water pressure in the drill pipe; S5: Realize the real-time transmission of drilling data from the underground drill site to the ground monitoring machine through the underground industrial ring network; S6: Realize remote command of the drilling operation in the mine according to the calculation results. The present invention uploads the trajectory data in real time through the industrial ring network, uses a water pressure sensor and a trajectory instrument to measure and collect drilling data, and uses a drilling trajectory processing software based on the full data processing method to realize the three-dimensional display of the drilling cluster trajectory and coal seam distribution, guide the design and construction of subsequent drills, and reduce or eliminate the blind area covered by gas drainage drills.

Description

Technical Field

[0001] This application relates to the technical field of mines, and more particularly, to a method for calculating borehole depth in database management. Background Art

[0002] The geological conditions in mining areas are complex, and coal and gas outbursts are severe. Coal and gas outbursts are major hidden dangers affecting the safety of each coal mine. To eliminate and reduce the risk of coal and gas outbursts, each coal mine generally uses a roadway drill rig to construct gas drainage boreholes for pre-drainage of gas, and reduces the gas pressure in the coal seam through pre-drainage of gas to effectively prevent the occurrence of coal and gas outburst accidents.

[0003] At present, the borehole construction methods in coal mines include directional drilling and rotary drilling. Due to the adjustable and controllable borehole trajectory, directional drilling technology has achieved good application results in coal mines. However, its price is expensive and the construction process is complex. Most boreholes in each coal mine under Huaibei Mining Group still adopt the rotary drilling construction method.

[0004] In rotary drilling construction, a downhole logging-while-drilling (LWD) tool is usually used to measure the borehole trajectory. The LWD tool performs fixed-point measurement during the drilling stop process, saves the collected attitude data in the measurement probe, and exports the stored data after the drilling is completed and the drill pipe is lifted, and obtains the borehole trajectory through processing. Due to the high measurement efficiency and simple operation of the LWD tool, it has been widely used in coal mines.

[0005] However, the deficiencies in data processing by the LWD tool are also obvious:

[0006] (1) The up-down deviation and left-right deviation diagrams formed by the LWD tool are two-dimensional graphics and cannot intuitively reflect the shape of the borehole trajectory in three-dimensional space.

[0007] (2) The LWD tool can only generate a map of the trajectory of a single borehole and cannot display the trajectories of multiple boreholes at the same time, and cannot determine the positional relationship between multiple boreholes.

[0008] (3) Currently, the data of the inclinometer can only be analyzed manually after being taken to the surface, and the measured data cannot be uploaded to the ground in real time for data processing, analysis and management, and cannot timely guide the subsequent borehole construction.

[0009] (4) The measurement of the borehole depth relies on manually counting the drill pipes through video, which is time-consuming and laborious, and the problem of falsifying the borehole depth cannot be eliminated. Currently, relying solely on the LWD measurement instrument cannot solve the problems of human cheating and false reporting of the borehole depth.

[0010] Field drilling construction practice shows that during the drilling construction process, there are problems such as inaccurate manual recording of hole depth and drilling deviation, resulting in displacement of the drilling trajectory and landing point, making it difficult to achieve the design requirements in terms of accuracy, forming unknown and uncontrollable blind areas, affecting the treatment effects of disasters such as gas prevention and control, and making it difficult to accurately prevent and control major disasters. Summary of the Invention

[0011] To make up for the above deficiencies, the present application provides a database management method for calculating drilling depth, aiming to improve the problems existing in the conventional drilling construction process, such as inaccurate manual recording of hole depth and drilling deviation, resulting in displacement of the drilling trajectory and landing point, making it difficult to achieve the design requirements in terms of accuracy, forming unknown and uncontrollable blind areas, affecting the treatment effects of disasters such as gas prevention and control, and making it difficult to accurately prevent and control major disasters.

[0012] The embodiment of the present application provides a database management method for calculating drilling depth, including the following method steps:

[0013] S1. Retrieve the roadway data and drilling point data in the database for analysis: By retrieving the data information of the roadway and drilling points stored in the database, and then performing analysis and processing to determine the direction and depth of the drilling at the drilling point. Through data analysis, the direction and depth of the drilling point can be clearly and definitely obtained, facilitating drilling processing;

[0014] S2. Effectively drill the drilling point through the drilling equipment: After calculating and processing the direction and depth of the drilling point, use the drilling equipment to drill the drilling point in the roadway, that is, complete the drilling of the drilling point;

[0015] S3. Collect the data information of the drilling point during drilling: During the drilling process, use the YZG7 downhole logging tool or YQG1 logging tool to measure the drilling trajectory data, that is, detect the trajectory during the drilling process and obtain the route of the drilling trajectory;

[0016] S4. And use a water pressure sensor to monitor the change of water pressure in the drill pipe: During the drilling process, additionally use a water pressure sensor to monitor the change of water pressure in the drill pipe during the drilling construction process. By collecting the water pressure situation, and then by setting a choke valve controlled by the measured sensor, when the flowing water column is controlled, a change in pressure pulse will occur. Its information is encoded by the number of pulses, or encoded by pulse amplitude and pulse phase in binary number system, and received by the surface pressure detector. Various sensors are used to measure the hole angle, azimuth angle, and tool face parameters of the drilling;

[0017] S5. Realize the real-time transmission of borehole data from the underground drilling site to the ground monitoring machine through the underground industrial ring network: When drilling a borehole, realize the real-time transmission of borehole data from the underground drilling site to the ground monitoring machine through the underground industrial ring network, and the borehole trajectory data processing software based on the full data analysis method completes the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and borehole cluster trajectory in the drilling site. The borehole trajectory online monitoring technology based on the full data analysis method is used to determine the drilling blind area;

[0018] S6. Realize remote command of borehole operations in the mine according to the calculation results: After the data information collected is calculated and processed through the borehole trajectory online monitoring technology based on the full data analysis method, complete the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and borehole cluster trajectory in the drilling site, and realize remote monitoring and command of the borehole process according to the calculation and processing results.

[0019] In the above implementation process, it is imperative to apply new technologies to accurately determine the borehole trajectory and the final hole landing point, and quickly analyze the control blind area to provide a scientific basis for supplementing disaster control projects in real time. In response to the actual needs of coal mine underground borehole cluster trajectory measurement and analysis, a borehole trajectory online monitoring technology and system based on the full data analysis method are designed and developed. This technology uses a water pressure sensor to monitor the change of water pressure in the drill pipe during the borehole construction process, combines the inclination angle data of the in-the-hole trajectory instrument to accurately determine the borehole depth, eliminates the human error of the borehole depth, and at the same time realizes the real-time transmission of borehole data from the underground drilling site to the ground monitoring machine through the existing underground industrial ring network. Using the self-developed borehole trajectory data processing software based on the full data analysis method, complete the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and borehole cluster trajectory in the drilling site. The borehole trajectory online monitoring technology based on the full data analysis method provides an intuitive and scientific basis for determining the drilling blind area and guiding borehole construction, and has practical value for research and application; Use the YZG7 in-the-hole trajectory instrument or the YQG1 trajectory instrument to measure the borehole trajectory data, borrow the existing industrial ring network to build a borehole data transmission system, realize the real-time upload of the trajectory data after the hole is formed, use a water pressure sensor to continuously monitor the change of water pressure in the borehole, determine the static water pressure in the borehole through the full data analysis method, combine the inclination angle data measured by the trajectory instrument to determine the borehole depth, use the borehole trajectory processing software based on the full data processing method to realize the three-dimensional display of the borehole cluster trajectory and the coal seam distribution, intuitively display the actual trajectories of each borehole in the drilling site, summarize the borehole deviation rules in the drilling site by statistically analyzing the borehole measurement data, and guide the design and construction of subsequent boreholes according to the deviation rules and the borehole coverage blind area, reduce or eliminate the borehole coverage blind area of gas drainage boreholes.

[0020] In a specific implementation, after the data information of the roadway and drilling points in S1 is extracted from the database, calibration data is determined through computer processing. The calibration data includes the difference between the magnetic azimuth and the grid azimuth, and calculates the number of perforations, left-right deviation, up-down deviation, tool azimuth, tool inclination, gamma polygon curve graph, and the measurement results of vibration and shock as a function of depth.

[0021] In the above implementation process, through calculation and processing based on the data information in the database, the information of each parameter can be effectively determined, facilitating the drilling process.

[0022] In a specific implementation, when the drilling equipment in S1 drills a hole, water flow is introduced into the drill pipe, and a number of overflow holes are provided on the side wall of the drill pipe. Water injection into the drill hole is carried out through the overflow holes.

[0023] In the above implementation process, the setting of the drill pipe can realize the water injection operation, and can realize the process of detecting the drill hole according to the change of water pressure.

[0024] In a specific implementation, when the S2 drilling point drills a hole, the range of the drilling point is determined by the differences between the left-right deviation, tool azimuth, tool inclination, magnetic azimuth and grid azimuth. When drilling, the drilling equipment is kept stable and fixed, and then drilling is carried out within the range of the left-right deviation, tool azimuth and tool inclination. And in order to maintain safety, the vibration and shock are kept within the predicted range for operation.

[0025] In the above implementation process, according to the calculated parameters, it is convenient to predict and assume the drilling position and the drilling path, improving the drilling efficiency.

[0026] In a specific implementation, the industrial ring network in S5 is communicatively connected to the water pressure sensor, the YZG7 logging-while-drilling (LWD) tool or the YQG1 trajectory instrument, and realizes the transmission of data information through the distributed nodes of the industrial ring network underground in the mine. And in order to improve the transmission accuracy, fiber optic cables are selected for communication transmission.

[0027] In the above implementation process, the industrial ring network is used to transmit the detected data information, and fiber with less interference is used for transmission to improve the transmission efficiency.

[0028] In a specific implementation, before the borehole trajectory online monitoring technology of the full data analysis method in S6 receives the data information underground in the mine, the data information is preprocessed first, that is, the data information is received and filtered through the data processing module.

[0029] In the above implementation process, in order to improve the accuracy of data information, before receiving the data information, the data information is first filtered to improve the accuracy of the data information.

[0030] In a specific implementation, the filtering process includes wavelet transform denoising, maximum likelihood estimation threshold method denoising, and impulse signal smoothing. The wavelet transform denoising breaks through the limitation that the Fourier transform has no resolution in the time domain, analyzes the signal components in a specified frequency band and time period, and there is baseline drift in the collected signal, and the denoised signal needs to be smoothed.

[0031] In the above implementation process, in order to improve the accuracy and precision of data information, and improve the filtering effect, multiple groups of filtering algorithms are used for processing, and the linear smoothing degree can be improved.

[0032] In a specific implementation, the characteristics of the wavelet transform denoising in the frequency domain and time domain make the wavelet transform denoising have good applications in signal denoising. The steps of the threshold denoising method based on wavelet transform are as follows:

[0033] S601. Select an appropriate wavelet, perform wavelet transform on the given signal to obtain wavelet transform coefficients W;

[0034] S602. Calculate the threshold, select an appropriate threshold method to select and discard the wavelet coefficients. The threshold is either the hard threshold or the soft threshold to obtain new wavelet coefficients Wδ;

[0035] S603. Perform inverse transform on the obtained coefficients to obtain the denoised data;

[0036] Among them, the function expression of the hard threshold is η(ω) = ωI(|ω| > T), and the function expression of the soft threshold is η(ω) = (ω - sgn(ω)T)I(|ω| > T).

[0037] In the above implementation process, wavelet transform denoising can effectively calculate the threshold and achieve the denoising effect.

[0038] In a specific implementation, the smaller the entropy value of the maximum likelihood estimation threshold method denoising, the sparser the distribution, and the worse the uniformity; there is no quantitative definition for the sparse distribution, which usually refers to a distribution with a spike at the zero point of the probability density function; the signal collected at the wellhead is an additive mixed signal of a water pressure positive pulse signal and noise, and its probability density function is a typical sparse distribution. For signals conforming to the sparse distribution form, the following threshold criterion is obtained according to the maximum likelihood principle:

[0039]

[0040] Among them, d and σ are the standard deviations of the signal and the noise respectively. When the square root term is less than 0, the square root term is taken as 0.

[0041] In the above implementation process, through the calculation and processing of denoising by the maximum likelihood estimation threshold method, the threshold can be obtained, and effective filtering processing can be realized.

[0042] In a specific implementation, in order to weaken the influence of interference signals and improve the smoothness of the curve for the smoothing of the pulse signal, data smoothing processing is performed on the denoised signal. Common signal smoothing methods include the linear sliding smoothing method. The linear sliding average method is a method of linearly smoothing discrete data using the least squares principle. It mainly corrects the amplitude of a certain point according to the amplitudes of the sampling points adjacent to that point, so as to achieve the purpose of smoothing and denoising the waveform. Generally, the data points of 5 adjacent points are taken for calculation, and its calculation formula is shown as follows:

[0043]

[0044] where i = 3, 4,... m - 2.

[0045] In the above implementation process, through the smoothing of the pulse signal, the influence of interference signals can be weakened, the smoothness of the curve can be improved, and data smoothing processing is performed on the denoised signal. BRIEF DESCRIPTION OF THE DRAWINGS

[0046] In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings required for the embodiments will be briefly introduced below. It should be understood that the following drawings only show some embodiments of the present application, and therefore should not be regarded as limiting the scope. For those of ordinary skill in the art, other related drawings can be obtained based on these drawings without creative efforts.

[0047] Figure 1 is a schematic flowchart of the method steps provided by the embodiments of the present application;

[0048] Figure 2 is a schematic flowchart of the threshold denoising method based on wavelet transform denoising provided by the embodiments of the present application. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0049] The technical solutions in the embodiments of the present application will be described below with reference to the drawings in the embodiments of the present application.

[0050] To make the objectives, technical solutions, and advantages of the embodiments of this application clearer, the technical solutions in the embodiments of this application will be clearly and completely described below in conjunction with the accompanying drawings in the embodiments of this application. Obviously, the described embodiments are some, but not all, of the embodiments of this application. All other embodiments obtained by those of ordinary skill in the art based on the embodiments in this application without creative efforts shall fall within the scope of protection of this application.

[0051] Therefore, the following detailed description of the embodiments of this application provided in the accompanying drawings is not intended to limit the scope of the claimed application, but merely represents selected embodiments of this application. All other embodiments obtained by those of ordinary skill in the art based on the embodiments in this application without creative efforts shall fall within the scope of protection of this application.

[0052] It should be noted that: like reference numerals and letters denote like items in the following figures. Therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures.

[0053] In the description of this application, it should be understood that the terms "center", "longitudinal", "transverse", "length", "width", "thickness", "upper", "lower", "front", "rear", "left", "right", "vertical", "horizontal", "top", "bottom", "inner", "outer", "clockwise", "counterclockwise", etc. indicate the orientation or positional relationship based on the orientation or positional relationship shown in the drawings. This is only for the convenience of describing this application and simplifying the description, rather than indicating or implying that the device or element referred to must have a specific orientation, be constructed and operated in a specific orientation, and thus should not be construed as a limitation of this application.

[0054] In addition, the terms "first" and "second" are only used for descriptive purposes and cannot be construed as indicating or implying relative importance or implicitly specifying the quantity of the indicated technical features. Thus, the features defined with "first" and "second" may explicitly or implicitly include one or more of such features. In the description of this application, "a plurality" means two or more unless otherwise specifically defined.

[0055] In this application, unless otherwise clearly specified and limited, the terms "mounted", "connected", "coupled", "fixed", etc. shall be construed in a broad sense. For example, it may be a fixed connection, a detachable connection, or integrated; it may be directly connected, or indirectly connected through an intermediate medium, and it may be the internal communication of two elements or the interaction relationship between two elements. For those of ordinary skill in the art, the specific meanings of the above terms in this application can be understood according to specific circumstances.

[0056] In this application, unless otherwise clearly specified and defined, the first feature being "on" or "under" the second feature may include the direct contact between the first and second features, or may include the situation where the first and second features are not in direct contact but in contact through additional features therebetween. Moreover, the first feature being "above", "over" and "on top of" the second feature includes that the first feature is directly above and obliquely above the second feature, or merely indicates that the horizontal height of the first feature is higher than that of the second feature. The first feature being "under", "beneath" and "underneath" the second feature includes that the first feature is directly below and obliquely below the second feature, or merely indicates that the horizontal height of the first feature is lower than that of the second feature.

[0057] Please refer to Figure 1-2 , this application provides a method for calculating the drilling depth in database management, including the following method steps:

[0058] S1. Retrieve the roadway data and drilling point data in the database for analysis: By retrieving the data information of the roadway and drilling points stored in the database, and then performing analysis and processing to determine the direction and depth of the drilling at the drilling point. Through data analysis, the direction and depth of the drilling point can be clearly obtained, facilitating the drilling process;

[0059] S2. Effectively drill the drilling point through drilling equipment: After calculating and processing the direction and depth of the drilling point, use the drilling equipment to drill the drilling point in the roadway, that is, complete the drilling of the drilling point;

[0060] S3. Collect the data information of the drilling point during drilling: During the drilling process, use the YZG7 downhole logging tool or YQG1 logging tool to measure the drilling trajectory data, that is, detect the trajectory during the drilling process and obtain the route of the drilling trajectory;

[0061] S4. Also use a water pressure sensor to monitor the change of the water pressure inside the drill pipe: During the drilling process, additionally use a water pressure sensor to monitor the change of the water pressure inside the drill pipe during the drilling construction. By collecting the water pressure situation, and then by setting a choke valve controlled by the measuring sensor, when the flowing water column is controlled, a change in pressure pulse will occur. Its information is encoded by the number of pulses, or encoded by the pulse amplitude and pulse phase in binary number system, and received by the surface pressure detector. Various sensors are used to measure the drilling angle, azimuth angle, and tool face parameters respectively;

[0062] S5. Realize the real-time transmission of drilling data from the underground drill site to the ground monitoring machine through the underground industrial ring network: When drilling, realize the real-time transmission of drilling data from the underground drill site to the ground monitoring machine through the underground industrial ring network, and the full-data analysis method drilling trajectory data processing software to complete the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and drilling cluster trajectory in the drill site. The drilling trajectory online monitoring technology based on the full-data analysis method is used to determine the drilling blind area;

[0063] S6. Realize the remote command of the drilling operation in the mine according to the calculation results: After the data information collected is calculated and processed through the drilling trajectory online monitoring technology based on the full-data analysis method, complete the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and drilling cluster trajectory in the drill site, and realize the remote monitoring and command of the drilling process according to the calculation and processing results.

[0064] In the above implementation process, it is imperative to apply new technologies to accurately determine the drilling trajectory and the final hole landing point, and quickly analyze and control the blind area to provide a scientific basis for supplementing disaster control projects in real time. In response to the actual needs of the measurement and analysis of the drilling cluster trajectory in coal mines, the drilling trajectory online monitoring technology and system based on the full-data analysis method are designed and developed. This technology uses a water pressure sensor to monitor the change of the water pressure in the drill pipe during the drilling construction process, combines the inclination angle data of the downhole trajectory instrument to accurately determine the drilling depth, eliminates the human error of the drilling depth, and at the same time realizes the real-time transmission of drilling data from the underground drill site to the ground monitoring machine through the existing underground industrial ring network. Using the self-developed full-data analysis method drilling trajectory data processing software, complete the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and drilling cluster trajectory in the drill site. The drilling trajectory online monitoring technology based on the full-data analysis method provides an intuitive and scientific basis for determining the drilling blind area and guiding the drilling construction, and has the practical value of research and application; Use the YZG7 downhole trajectory instrument or the YQG1 trajectory instrument to measure the drilling trajectory data, borrow the existing industrial ring network to build a drilling data transmission system, realize the real-time upload of the trajectory data after the hole is formed, use a water pressure sensor to continuously monitor the change of the water pressure in the drill hole, determine the static water pressure in the drill hole through the full-data analysis method, combine the inclination angle data measured by the trajectory instrument to determine the drilling depth, use the drilling trajectory processing software based on the full-data processing method to realize the three-dimensional display of the drilling cluster trajectory and the coal seam distribution, intuitively display the actual trajectories of each drilling hole in the drill site, summarize the drilling deviation rules of the drill site by statistically analyzing the drilling measurement data, and guide the design and construction of subsequent drilling holes according to the deviation rules and the drilling coverage blind area, reducing or eliminating the drilling coverage blind area of gas drainage holes.

[0065] In a specific solution, after the data information of the roadway and borehole points in S1 is extracted from the database, calibration data is determined through computer processing. The calibration data includes the difference between the magnetic azimuth and the grid azimuth, and calculates the number of perforations, left-right deviation, up-down deviation, tool azimuth, tool inclination, gamma polygon curve graph, and the measurement results of vibration and shock as a function of depth. Calculation and processing based on the data information in the database can effectively determine the information of various parameters, facilitating borehole processing. When drilling at the borehole point in S2, the range of the borehole point is determined by the left-right deviation, tool azimuth, tool inclination, and the difference between the magnetic azimuth and the grid azimuth. During drilling, the drilling equipment is kept stable and fixed, and then drilling is carried out within the range of the left-right deviation, tool azimuth, and tool inclination. In order to ensure safety, the vibration and shock are kept within the predicted range during operation. Based on the calculated parameters, it is convenient to predict and assume the borehole position and the drilling path, improving the drilling efficiency.

[0066] In a specific implementation scheme, when the drilling equipment in S1 is drilling, water flow is introduced into the drill pipe, and a number of overflow holes are provided on the side wall of the drill pipe. Water injection into the borehole is carried out through the overflow holes. The setting of the drill pipe can realize the water injection operation and can detect the borehole process according to the change of water pressure.

[0067] During the implementation process, the industrial ring network in S5 is communicatively connected to the water pressure sensor, YZG7 logging-while-drilling (LWD) tool or YQG1 LWD tool, and is communicatively connected through the distributed nodes of the industrial ring network underground in the mine to realize the transmission of data information. In order to improve the transmission accuracy, fiber optic cables are selected for communication transmission. The industrial ring network is used to transmit the detected data information, and fibers with small interference are used for transmission to improve the transmission efficiency.

[0068] In a specific embodiment, before the borehole trajectory online monitoring technology of the full data analysis method in S6 receives data information underground in a mine, the data information is preprocessed, that is, the data information is received and filtered through a data processing module. In order to improve the accuracy of the data information, before receiving the data information, the data information is filtered to improve the accuracy of the data information. The filtering process includes wavelet transform denoising, maximum likelihood estimation threshold method denoising, and pulse signal smoothing. The wavelet transform denoising breaks through the limitation that the Fourier transform has no resolution in the time domain, analyzes the signal components within a specified frequency band and time period, and there is a baseline drift in the collected signal, and the denoised signal needs to be smoothed. In order to improve the accuracy and precision of the data information and improve the filtering effect, multiple groups of filtering algorithms are used for processing, and the linear smoothing degree can be improved. The characteristics of wavelet transform denoising in the frequency domain and time domain make wavelet transform denoising have good applications in signal denoising. The steps of the threshold denoising method based on wavelet transform denoising are as follows:

[0069] S601. Select a suitable wavelet, perform wavelet transform on the given signal, and obtain wavelet transform coefficients W;

[0070] S602. Calculate the threshold, select a suitable threshold method to select and discard the wavelet coefficients, and the threshold is the hard threshold or soft threshold, and obtain new wavelet coefficients Wδ;

[0071] S603. Perform inverse transform on the obtained coefficients to obtain the denoised data;

[0072] Among them, the function expression of the hard threshold is η(ω) = ωI(|ω|>T), and the function expression of the soft threshold is η(ω) = (ω - sgn(ω)T)I(|ω|>T). Through wavelet transform denoising, the threshold can be effectively calculated and processed, and the denoising effect can be achieved. The smaller the entropy value of the maximum likelihood estimation threshold method denoising, the sparser the distribution and the worse the uniformity; there is no quantitative definition for the sparse distribution, which usually refers to a distribution with a peak at the zero point of the probability density function; the signal collected at the wellhead is an additive mixed signal of a water pressure positive pulse signal and noise, and its probability density function is a typical sparse distribution. For signals conforming to the sparse distribution form, the following threshold criterion is obtained according to the maximum likelihood principle:

[0073]

[0074] Among them, d and σ are the standard deviations of the signal and noise respectively. When the square root term is less than 0, the square root term is taken as 0. Through the calculation and processing of the maximum likelihood estimation threshold method for denoising, the threshold can be obtained, and effective filtering processing can be realized. The pulse signal smoothing is to weaken the influence of interference signals and improve the smoothness of the curve. Data smoothing processing is performed on the denoised signal. Commonly used signal smoothing methods include the linear sliding smoothing method. The linear sliding average method is a method of linearly smoothing discrete data using the least squares principle. It mainly corrects the amplitude of a certain point according to the amplitudes of the sampling points adjacent to that point, so as to achieve the purpose of smoothing and denoising the waveform. Generally, the data points of 5 adjacent points are taken for calculation, and its calculation formula is shown as follows:

[0075]

[0076] where i = 3, 4,..., m - 2. Through pulse signal smoothing, the influence of interference signals can be weakened and the smoothness of the curve can be improved. Data smoothing processing is performed on the denoised signal.

[0077] Specifically, the working principle of this vision testing device for ophthalmic examination:

[0078] The first step: Retrieve the roadway data and borehole point data in the database for analysis. By retrieving the data information of roadways and borehole points stored in the database and then performing analysis and processing, determine the direction and depth of the boreholes at the borehole points. Through data analysis, the direction and depth of the borehole points can be clearly and definitely obtained, which is convenient for borehole processing;

[0079] The second step: Effectively drill the borehole points through drilling equipment. After calculating and processing the direction and depth of the borehole points, use drilling equipment to drill the borehole points in the roadway, that is, complete the drilling of the borehole points;

[0080] The third step: Collect the data information of the borehole points during drilling. During the drilling process, use the YZG7 downhole logging tool or the YQG1 logging tool to measure the drilling trajectory data, that is, detect the trajectory during the drilling process and obtain the route of the drilling trajectory;

[0081] The fourth step: And use a water pressure sensor to monitor the change of the water pressure in the drill pipe. During the drilling process, additionally use a water pressure sensor to monitor the change of the water pressure in the drill pipe during the drilling construction. By collecting the water pressure situation, and then by setting a choke valve controlled by the measuring sensor, when the flowing water column is controlled, a change in pressure pulse will occur. Its information is encoded by the number of pulses, or encoded in binary system with pulse amplitude and pulse phase. It is received by the surface pressure detector, and various sensors are used to measure the borehole apex angle, azimuth angle, and tool face parameters respectively;

[0082] Step 5: Achieve real-time transmission of drilling data from the underground drill site to the ground monitoring machine through the underground industrial ring network: During drilling, achieve real-time transmission of drilling data from the underground drill site to the ground monitoring machine through the underground industrial ring network, and the full-data analysis method drilling trajectory data processing software to complete the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and drilling cluster trajectory at the drill site. The drilling trajectory online monitoring technology based on the full-data analysis method is used to determine the drilling blind area;

[0083] Step 6: Achieve remote command of the drilling operation in the mine according to the calculation results: After the drilling trajectory online monitoring technology based on the full-data analysis method is used to calculate and process the collected data information, complete the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and drilling cluster trajectory at the drill site, and achieve remote monitoring and command of the drilling process according to the calculation and processing results.

[0084] The above are only the embodiments of the present application and are not used to limit the protection scope of the present application. For those skilled in the art, various changes and modifications can be made to the present application. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application shall be included in the protection scope of the present application. It should be noted that similar reference numerals and letters represent similar items in the following drawings. Therefore, once an item is defined in one drawing, it does not need to be further defined and explained in subsequent drawings.

[0085] The above is only the specific implementation manner of the present application, but the protection scope of the present application is not limited thereto. Any person skilled in the art can easily think of changes or replacements within the technical scope disclosed in the present application, and all should be covered by the protection scope of the present application. Therefore, the protection scope of the present application should be subject to the protection scope of the claims.

Claims

1. A method for calculating drilling depth in database management, characterized in that It includes the following method steps: S1. Retrieve the roadway data and borehole data in the database for analysis: By retrieving the data information of the roadway and borehole stored in the database, and then performing analysis and processing to determine the direction and depth of the borehole of the borehole point. Through data analysis, the direction and depth of the borehole point can be clearly obtained, facilitating borehole processing; S2. Effectively perform borehole processing on the borehole point through a borehole device: After calculating and processing the direction and depth of the borehole point, use a borehole device to perform borehole processing on the borehole point in the roadway, that is, complete the borehole of the borehole point; S3. Collect the data information of the borehole point during borehole drilling: During the borehole drilling process, use a YZG7 downhole logging-while-drilling tool or a YQG1 logging-while-drilling tool to measure the borehole trajectory data, that is, detect the trajectory during the borehole drilling process and obtain the route of the borehole trajectory; S4. And use a water pressure sensor to monitor the change of the water pressure in the drill pipe: During the borehole drilling process, additionally use a water pressure sensor to monitor the change of the water pressure in the drill pipe during the borehole construction. By collecting the water pressure situation, and then by setting a choke valve controlled by the measured sensor, when the flowing water column is controlled, a change in pressure pulse will occur. Its information is encoded by the number of pulses, or encoded in binary system by the pulse amplitude and pulse phase, and received by the surface pressure detector. Use various sensors to measure the borehole apex angle, azimuth angle, and tool face parameters respectively; S5. Realize the real-time transmission of borehole data from the underground drill site to the ground monitoring machine through the underground industrial ring network: During borehole drilling, realize the real-time transmission of borehole data from the underground drill site to the ground monitoring machine through the underground industrial ring network, and a borehole trajectory data processing software based on the full data analysis method to complete the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and borehole group trajectory in the drill site. The borehole trajectory online monitoring technology based on the full data analysis method is used to determine the drilling blind area; S6. Realize remote command of the borehole operation in the mine according to the calculation result: After performing calculation and processing on the collected data information through the borehole trajectory online monitoring technology based on the full data analysis method, complete the three-dimensional display of the coal-rock interface, coal seam thickness and strike, and borehole group trajectory in the drill site, and realize remote monitoring and command of the borehole process according to the calculation and processing result.

2. The method for calculating the drilling depth in database management according to claim 1, characterized in that After the data information of the roadway and borehole point in S1 is extracted from the database, calibration data is determined through computer processing. The calibration data includes the difference between the magnetic azimuth angle and the grid azimuth angle, and calculates the number of perforations, left and right deviation amounts, up and down deviation amounts, tool azimuth angle, tool inclination, gamma polygon curve graph, and the measurement results of vibration and impact as a function of depth.

3. The method for calculating the drilling depth in database management according to claim 1, characterized in that When the borehole device in S1 performs borehole drilling, water is introduced into the drill pipe, and a number of overflow holes are provided on the side wall of the drill pipe, and water is injected into the borehole through the overflow holes.

4. The method for calculating the drilling depth in database management according to claim 2, characterized in that When drilling at the S2 drilling point, the range of the drilling point is determined by the differences among the left-right deviation amount, the tool azimuth angle, the tool inclination, the magnetic azimuth angle, and the grid azimuth angle. During drilling, the drilling equipment is kept stable and fixed, and then drilling is carried out within the ranges of the left-right deviation amount, the tool azimuth angle, and the tool inclination. In order to ensure safety, the vibration and impact are kept within the predicted range for operation.

5. The method for calculating the drilling depth in database management according to claim 1, wherein The industrial ring network in S5 is communicatively connected to the water pressure sensor, the YZG7 while-drilling trajectory instrument, or the YQG1 trajectory instrument, and the communication connection is realized through the distributed nodes of the industrial ring network underground in the mine, so as to transmit the data information. In order to improve the transmission accuracy, fiber optic cables are selected for communication transmission.

6. The method for calculating the drilling depth in database management according to claim 5, wherein Before receiving the data information underground in the mine by the drilling trajectory online monitoring technology of the full data analysis method in step S6, the data information is preprocessed first, that is, the data information is received and filtered through the data processing module.

7. The method for calculating the drilling depth in database management according to claim 6, wherein, The filtering process includes wavelet transform denoising, maximum likelihood estimation threshold method denoising, and pulse signal smoothing. The wavelet transform denoising breaks through the limitation that the Fourier transform has no resolution in the time domain, analyzes the signal components within a specified frequency band and time period, and there is baseline drift in the collected signal, and the denoised signal needs to be smoothed.

8. The method for calculating the drilling depth in database management according to claim 7, wherein, The characteristics of the wavelet transform denoising in the frequency domain and the time domain make the wavelet transform denoising have good applications in signal denoising. The threshold denoising method based on wavelet transform denoising is as follows: S601. Select a suitable wavelet, perform wavelet transform on the given signal, and obtain the wavelet transform coefficient W; S602. Calculate the threshold, select a suitable threshold method to select and discard the wavelet coefficients. The threshold is the hard threshold or the soft threshold, and a new wavelet coefficient Wδ is obtained; S603. Perform inverse transform on the obtained coefficients to obtain the denoised data; Among them, the function expression of the hard threshold is η(ω) = ωI(|ω| > T), and the function expression of the soft threshold is η(ω) = (ω - sgn(ω)T)I(|ω| > T).

9. The method for calculating the drilling depth in database management according to claim 7, wherein The smaller the entropy value of the maximum likelihood estimation threshold method denoising, the sparser the distribution and the worse the uniformity; there is no quantitative definition for the sparse distribution, which usually refers to a distribution where the probability density function has a spike at zero; the signal collected at the wellhead is an additive mixed signal of a water pressure positive pulse signal and noise, and its probability density function is a typical sparse distribution. For signals conforming to the sparse distribution form, the following threshold criterion is obtained according to the maximum likelihood principle: where, d and σ are the standard deviations of the signal and the noise respectively, and when the square root term is less than 0, the square root term is taken as 0.

10. The method for calculating the drilling depth in database management according to claim 7, characterized in that, In order to weaken the influence of the interference signal and improve the smoothness of the curve, the pulse signal smoothing performs data smoothing on the denoised signal. The commonly used signal smoothing methods include the linear sliding smoothing method. The linear sliding average method is a method of linearly smoothing discrete data using the least squares principle. It mainly corrects the amplitude of a certain point according to the amplitudes of the sampling points adjacent to this point, so as to achieve the purpose of smoothing and denoising the waveform. Generally, the data points of 5 adjacent points are taken for calculation, and its calculation formula is shown as follows: Among them, i = 3, 4,... m - 2.

Images