Drilling data processing method and device, electronic equipment and storage medium

Abstract

The invention discloses a drilling data processing method and device, electronic equipment and a storage medium. The method comprises the following steps: acquiring first drilling data when target drilling operation is performed on a drilling operation site, wherein the drilling data at least comprises drilling and logging parameters used for describing riser pressure, turntable torque, hook load and turntable rotating speed in the drilling and completion process on the drilling operation site; performing optimization processing on null values and abnormal values in the first drilling data to obtain second drilling data; and determining a target drilling working condition classification when the target drilling operation is carried out on the drilling operation site, and carrying out data treatment on the second drilling data according to the target drilling working condition classification to obtain third drilling data. According to the scheme, the drilling data during target drilling operation on the drilling operation site is obtained in real time, the influence of wrong data in the drilling data is avoided, the accuracy of the drilling data is guaranteed, and the drilling data management efficiency is improved.

Description

Technical Field

[0001] The embodiments of the present invention relate to the technical field of intelligent drilling and completion, and in particular to a drilling data processing method, device, electronic device and storage medium. Background Art

[0002] With the rapid development of digital technology, it has become a trend to deploy sensors at the drilling site. These sensors can collect multi-source data on oil and gas drilling and transmit it to the rear monitoring center in real time through the network. Based on these real-time data, advanced technologies such as data analysis and machine learning can be used to effectively analyze the on-site situation, thereby strengthening the safety control and early warning capabilities of drilling operations, optimizing drilling parameters to improve drilling efficiency, and preventing the occurrence of complex situations such as well leakage.

[0003] However, there are many problems in practical applications. Since the sensors themselves may have faults or accuracy problems, and may be affected by factors such as network interference during data transmission, these real-time data often have some abnormalities, resulting in poor data quality. Low-quality data is difficult to tap into its potential value, which seriously affects the safety management and efficiency improvement of drilling operations. Summary of the invention

[0004] The present invention provides a drilling data processing method, device, electronic device and storage medium to automatically identify and remove invalid data, noise and outliers obtained at the drilling operation site, thereby ensuring the accuracy and consistency of the drilling data and the rationality of the oil and gas business logic.

[0005] According to one aspect of the present invention, a drilling data processing method is provided, the method comprising:

[0006] Acquire first drilling data when a target drilling operation is performed at a drilling operation site, the drilling data at least including drilling and logging parameters used to describe standpipe pressure, rotary table torque, hook load, and rotary table speed during drilling and completion at the drilling operation site;

[0007] Optimizing the null values ​​and abnormal values ​​in the first drilling data to obtain the second drilling data;

[0008] A target drilling condition classification when a target drilling operation is performed at a drilling operation site is determined, and data management is performed on the second drilling data according to the target drilling condition classification to obtain third drilling data.

[0009] According to another aspect of the present invention, there is provided a drilling data processing device, the device comprising:

[0010] A data acquisition module, used to acquire first drilling data when a target drilling operation is performed at a drilling operation site, wherein the drilling data at least includes drilling and logging parameters used to describe the riser pressure, rotary table torque, hook load, and rotary table speed during the drilling and completion process at the drilling operation site;

[0011] A data optimization module, used for optimizing the null values ​​and abnormal values ​​in the first drilling data to obtain the second drilling data;

[0012] The data management module is used to determine the target drilling condition classification when the target drilling operation is performed at the drilling operation site, and perform data management on the second drilling data according to the target drilling condition classification to obtain the third drilling data.

[0013] According to another aspect of the present invention, there is provided an electronic device, the electronic device comprising:

[0014] one or more processors;

[0015] a storage device for storing one or more programs,

[0016] When one or more programs are executed by one or more processors, the one or more processors implement the drilling data processing method of any embodiment of the present invention.

[0017] According to another aspect of the present invention, a storage medium containing computer executable instructions is provided. When the computer executable instructions are executed by a computer processor, they are used to execute the drilling data processing method of any embodiment of the present invention.

[0018] The technical solution of the embodiment of the present invention, by acquiring the first drilling data when the target drilling operation is performed at the drilling operation site, the drilling data at least includes the drilling and logging parameters used to describe the riser pressure, turntable torque, hook load and turntable speed in the process of drilling and completion at the drilling operation site, so as to realize real-time acquisition of the drilling data when the target drilling operation is performed at the drilling operation site, so as to timely discover and solve the problems arising from the drilling data; the null values ​​and abnormal values ​​in the first drilling data are optimized to obtain the second drilling data, so as to avoid the influence of the erroneous data existing in the drilling data when the data is processed, and ensure the accuracy of the drilling data; determine the target drilling condition classification when the target drilling operation is performed at the drilling operation site, and perform data management on the second drilling data according to the target drilling condition classification to obtain the third drilling data, so as to improve the efficiency of drilling data management, reduce the need for manual inspection and correction of data errors, reduce the risk of human errors, and reduce labor costs, so as to quickly complete the review, classification and marking of drilling data in the future.

[0019] It should be understood that the contents described in this section are not intended to identify the key or important features of the embodiments of the present invention, nor are they intended to limit the scope of the present invention. Other features of the present invention will become easily understood through the following description. BRIEF DESCRIPTION OF THE DRAWINGS

[0020] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the following briefly introduces the drawings required for use in the description of the embodiments. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without creative work.

[0021] Figure 1 A flowchart of a drilling data processing method provided in Embodiment 1 of the present invention;

[0022] Figure 2 A flow chart of target drilling condition classification and identification provided in the first embodiment of the present invention;

[0023] Figure 3 A schematic diagram of the structure of a drilling data processing device provided in Embodiment 2 of the present invention;

[0024] Figure 4 A schematic diagram of the structure of an electronic device for implementing a drilling data processing method provided in Embodiment 3 of the present invention. DETAILED DESCRIPTION

[0025] Embodiments of the present invention will be described in more detail below with reference to the accompanying drawings. Although certain embodiments of the present invention are shown in the accompanying drawings, it should be understood that the present invention can be implemented in various forms and should not be construed as being limited to the embodiments described herein, which are instead provided for a more thorough and complete understanding of the present invention. It should be understood that the drawings and embodiments of the present invention are only for exemplary purposes and are not intended to limit the scope of protection of the present invention.

[0026] It should be understood that the various steps described in the method embodiments of the present invention may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present invention is not limited in this respect.

[0027] The term "including" and its variations used herein are open inclusions, i.e., "including but not limited to". The term "based on" means "based at least in part on". The term "one embodiment" means "at least one embodiment"; the term "another embodiment" means "at least one additional embodiment"; the term "some embodiments" means "at least some embodiments". The relevant definitions of other terms will be given in the following description.

[0028] It should be noted that the concepts such as "first" and "second" mentioned in the present invention are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.

[0029] It should be noted that the modifications of "one" and "plurality" mentioned in the present invention are illustrative rather than restrictive, and those skilled in the art should understand that, unless otherwise clearly indicated in the context, it should be understood as "one or more".

[0030] The names of the messages or information exchanged between multiple devices in the embodiments of the present invention are only used for illustrative purposes, and are not used to limit the scope of these messages or information.

[0031] It is understandable that before using the technical solutions disclosed in the embodiments of the present invention, the type, scope of use, usage scenarios, etc. of the personal information involved in the present invention should be informed to the user and the user's authorization should be obtained in an appropriate manner in accordance with relevant laws and regulations.

[0032] For example, in response to receiving an active request from a user, a prompt message is sent to the user to clearly prompt the user that the operation requested to be performed will require obtaining and using the user's personal information. Thus, the user can autonomously choose whether to provide personal information to software or hardware such as an electronic device, application, server, or storage medium that performs the operation of the technical solution of the present invention according to the prompt message.

[0033] As an optional but non-limiting implementation, in response to receiving an active request from the user, the prompt information may be sent to the user in the form of a pop-up window, in which the prompt information may be presented in text form. In addition, the pop-up window may also carry a selection control for the user to choose "agree" or "disagree" to provide personal information to the electronic device.

[0034] It is understandable that the above notification and user authorization process is only illustrative and does not constitute a limitation on the implementation of the present invention. Other methods that meet relevant laws and regulations may also be applied to the implementation of the present invention.

[0035] Embodiment 1

[0036] Figure 1 This is a flowchart of a drilling data processing method provided in the first embodiment of the present invention. The embodiment of the present invention can be applied to the case where drilling data acquired during drilling operations at a drilling operation site are automatically managed. The method can be executed by a drilling data processing device, which can be implemented in the form of hardware and / or software and can be configured in an electronic device that implements the drilling data processing method. Figure 1 As shown, the method includes:

[0037] S101. Acquire first drilling data when a target drilling operation is performed at a drilling operation site, wherein the drilling data at least includes drilling and logging parameters used to describe riser pressure, rotary table torque, hook load, and rotary table speed during drilling and completion at the drilling operation site.

[0038] In the embodiment of the present invention, drilling operation refers to the technical activities for the exploration and development of oil and natural gas, including a series of processes such as coring, logging, logging and testing. The drilling operation site refers to the working environment in which the drilling operation is performed. The first drilling data refers to the real-time data collected when the target drilling operation is performed at the drilling operation site, including drilling pressure, pump displacement, mud density, total hydrocarbon content and other real-time drilling and logging data, as well as drilling and logging parameters during the drilling and completion process, wherein the drilling and logging parameters include depth measurement, drill bit depth, drilling pressure, drilling speed, pump displacement, drilling time, rotary table speed and standpipe pressure.

[0039] Specifically, when the target drilling operation is carried out at the drilling operation site, the sensors deployed at the drilling operation site are used to collect the drilling and logging real-time data, such as drilling pressure, pump displacement, mud density and total hydrocarbon content, during the drilling operation, and the drilling and logging parameters during the drilling and completion process are recorded. Then, the real-time drilling and logging data and the drilling and logging parameters are used as the first drilling data when the target drilling operation is carried out at the drilling operation site.

[0040] As an optional method, obtaining first drilling data when a target drilling operation is performed at a drilling operation site includes the following steps A1-A2:

[0041] Step A1: Through the data access function of the OpenLookeng open source component, the drilling data collected by various sensors deployed at the drilling operation site when the target drilling operation is performed at the drilling operation site is received.

[0042] Step A2: parsing the received drilling data collected by various sensors at the drilling operation site through the OpenLookeng open source component to obtain the first drilling data collected for the target drilling operation at the drilling operation site.

[0043] In an embodiment of the present invention, the OpenLookeng open source component refers to an open source high-performance data virtualization engine that provides a unified data interface, allows analysis across data sources and data centers, and supports multiple query scenarios such as interactive, batch, and stream queries.

[0044] Specifically, real-time drilling data during drilling operations are collected through sensors deployed at the drilling operation site, and the source and format of the real-time drilling data are determined. According to the source and format of the data, the data source is configured in the OpenLookeng open source component, a data source connection is established, and the real-time drilling data collected by the sensors at the drilling operation site is received through the data access function of the OpenLookeng open source component. The real-time drilling data collected by the sensor is parsed through the OpenLookeng open source component to obtain the first drilling data of the target drilling operation, and a drilling data object is created in the time series database based on the real-time drilling data table of the source database. Exemplarily, a data acquisition server connected to the sensor can be set at the drilling operation site, and the data acquisition server pushes the drilling data collected by the sensor to the message queue in real time through the network, and then the OpenLookeng server reads the drilling data from the message queue and processes it.

[0045] S102: Optimize the null values ​​and abnormal values ​​in the first drilling data to obtain second drilling data.

[0046] In the embodiment of the present invention, the null value in the first drilling data refers to the real-time drilling data with empty data collected when the target drilling operation is performed at the drilling operation site. Part of the data in the null value is replaced by the value -999.25. The abnormal value in the first drilling data refers to part of the real-time drilling data collected that obviously exceeds the preset drilling data range when the target drilling operation is performed at the drilling operation site, wherein the preset drilling data range is the drilling data range pre-set according to the actual drilling data collected by the target drilling operation.

[0047] Specifically, when the target drilling operation is performed at the drilling operation site, the null value represented by the value -999.25 in the acquired first drilling data and the abnormal value that obviously exceeds the preset drilling data range are converted into null values ​​to obtain the second drilling data of the target drilling operation.

[0048] S103: determining a target drilling condition classification when a target drilling operation is performed at the drilling operation site, and performing data management on the second drilling data according to the target drilling condition classification to obtain third drilling data.

[0049] In the embodiment of the present invention, the drilling condition refers to the operating state during the target drilling operation at the drilling operation site. The target drilling condition classification includes drilling, circulation, short start, drilling cement plug, shutdown maintenance, casing running, logging operation, wellhead removal, complex situation and others.

[0050] Specifically, the current operation state of the target drilling operation is determined at the drilling operation site, and then the target drilling condition classification of the target drilling operation is determined. According to the target drilling condition classification, the corresponding data governance logic is selected, and the second drilling data is data governed to obtain the third drilling data of the target drilling operation.

[0051] As an optional method, determining the target drilling condition classification for the target drilling operation at the drilling operation site includes the following steps B1-B3:

[0052] Step B1, determining the first input parameter associated with the target drilling operation at the drilling operation site, the first input parameter including the drilling and logging parameters and drilling design information involved in the first drilling data, the drilling and logging parameters including the depth measurement, drill bit depth, drilling pressure and drilling speed when the drilling operation is performed at the drilling operation site, and the drilling design information including the designed well depth and wellbore structure of the drilling at the drilling operation site.

[0053] Step B2, determining a second input parameter associated with the target drilling operation at the drilling operation site, the second input parameter including the depth measurement, drill bit depth, drilling pressure, pump displacement, drilling time, rotary table speed and riser pressure corresponding to the drilling and logging parameters involved in the first drilling data when drilling at the drilling operation site.

[0054] Step B3: determining a target drilling condition classification for a target drilling operation at a drilling operation site based on the first input parameter and the second input parameter.

[0055] In an embodiment of the present invention, the first input parameter refers to the first drilling data collected when the target drilling operation is carried out at the drilling operation site, which includes drilling and logging parameters such as sounding, drill bit depth, drilling pressure and drilling speed, and drilling design information including designed well depth and wellbore structure, wherein sounding refers to the depth of the wellbore measured during the drilling operation, the drill bit depth refers to the depth of the drill bit underground during the drilling operation, the drilling pressure refers to the pressure applied to the drill bit for breaking rocks during the drilling operation, the drilling speed refers to the depth drilled by the drill bit per unit time during the drilling operation, the designed well depth refers to the depth planned to be reached during the drilling operation, and the wellbore structure refers to a combination of a series of casing and cement rings designed during the drilling operation.

[0056] The second input parameter refers to the first drilling data collected when the target drilling operation is carried out at the drilling operation site, which includes drilling and logging parameters such as depth measurement, drill bit depth, drilling pressure, pump displacement, drilling time, turntable speed and riser pressure, wherein the pump displacement refers to the volume of liquid delivered per unit time during the drilling operation, the drilling time refers to the time required to drill into a certain thickness of rock formation during the drilling operation, the turntable speed refers to the number of rotations of the turntable per minute during the drilling operation, and the riser pressure refers to the loss pressure drop when the drilling fluid flows in the drill string during the drilling operation.

[0057] Specifically, the drilling and logging parameters including sounding, drill bit depth, drilling pressure and drilling speed in the first drilling data collected when the target drilling operation is performed at the drilling operation site are combined with the pre-designed drilling design information including the designed well depth and wellbore structure as the first input parameter associated with the target drilling operation. The drilling and logging parameters including sounding, drill bit depth, drilling pressure, pump displacement, drilling time, rotary table speed and riser pressure in the first drilling data collected when the target drilling operation is performed at the drilling operation site are used as the second input parameter associated with the target drilling operation. Furthermore, the target drilling condition classification of the target drilling operation is determined based on the first input parameter and the second input parameter associated with the acquired target drilling operation.

[0058] As an optional method, based on the first input parameter and the second input parameter, determining the target drilling condition classification when performing the target drilling operation at the drilling operation site includes the following steps C1-C2:

[0059] Step C1, based on the first input parameter, perform drilling operation status analysis according to the preset drilling operation status identification logic used when the target drilling operation is performed at the drilling operation site, and determine the first drilling condition classification when the target drilling operation is performed at the drilling operation site, the first drilling condition classification at least includes at least one of the drilling condition, the lifting condition and the lowering condition.

[0060] Step C2: performing fine classification of the drilling condition classification when the target drilling operation is performed at the drilling operation site under the first drilling condition classification according to the second input parameter, and determining the target drilling condition classification when the target drilling operation is performed at the drilling operation site.

[0061] In an embodiment of the present invention, the preset drilling operation state recognition logic refers to the state recognition logic of the target drilling operation pre-set by the actual drilling operation, which is used to determine the basic drilling condition of the target drilling operation according to the first input parameter. The first drilling condition classification refers to the basic drilling condition classification in the process of performing the target drilling operation at the drilling operation site, including at least one of the drilling condition, the lifting condition and the lowering condition. The drilling condition is the core operation in the drilling process. It is a process of continuously deepening the wellbore by rotating the drill bit to break the formation rock and using the drilling fluid circulation to carry the cuttings to the ground to establish a channel for oil and gas extraction. The lifting condition refers to the operation of lifting the drill string upward from the well, which is used to replace the drill bit, check the condition of the drilling tool, and deal with downhole accidents. The lowering condition refers to the operation of putting the drill string back into the well, which is used when drilling continues after replacing the drill bit or increasing the length of the drilling tool.

[0062] Specifically, since the first input parameter associated with the target drilling operation has a stronger stability than the second input parameter when identifying the drilling condition classification, the first input parameter is used in combination with the preset drilling operation state recognition logic to pre-judge the first drilling condition classification of the drilling operation site when the target drilling operation is performed. Furthermore, under the first drilling condition classification, combined with the second input parameter, the first drilling condition classification is finely divided using a decision tree, so as to determine the actual condition classification of the target drilling operation, and use it as the target drilling condition classification of the target drilling operation.

[0063] For example, Figure 2 As shown, the first input parameter associated with the target drilling operation is represented by the drilling and logging parameters including depth measurement, drill bit depth, drilling pressure and drilling speed, as well as the well information including the designed well depth and wellbore structure, and the basic drilling status is identified based on the preset business rules, including drilling, lifting, lowering and others. Figure 2 In the present invention, the second input parameter associated with the target drilling operation is represented by the drilling and logging parameters including sounding, drill bit depth, drilling pressure, pump displacement, drilling time, rotary table speed and standpipe pressure. The actual drilling conditions can be identified by combining the basic drilling status and using the decision tree.

[0064] As an optional option, the preset drilling operation status identification logic is used to indicate the preset status conditions that need to be met for different drilling condition classifications, wherein the preset status conditions that need to be met for the drilling condition are that the drill bit depth is equal to the sounding, the drill bit depth during the current drilling operation is not less than the drill bit depth during the previous drilling operation, and the drilling pressure is not equal to the preset value; the preset status conditions that need to be met for the lifting condition are that the drill bit depth is less than the sounding, the drill bit depth during the current drilling operation is less than the drill bit depth during the previous drilling operation, and the drilling pressure is not greater than the preset value; the preset status conditions that need to be met for the lowering condition are that the drill bit depth is less than the sounding, the drill bit depth during the current drilling operation is greater than the drill bit depth during the previous drilling operation, and the drilling pressure is not less than the preset value, and the preset value is 0.

[0065] Specifically, if the first input parameter associated with the target drilling operation determines that the drill bit depth is equal to the sounding, the drill bit depth at the current drilling operation is greater than or equal to the drill bit depth at the previous drilling operation, and the drilling pressure is not equal to 0, then the target drilling operation is considered to be in the drilling condition. If the first input parameter associated with the target drilling operation determines that the drill bit depth is less than the sounding, the drill bit depth at the current drilling operation is less than the drill bit depth at the previous drilling operation, and the drilling pressure is less than or equal to 0, then the target drilling operation is considered to be in the lifting condition. If the first input parameter associated with the target drilling operation determines that the drill bit depth is less than the sounding, the drill bit depth at the current drilling operation is greater than the drill bit depth at the previous drilling operation, and the drilling pressure is greater than or equal to 0, then the target drilling operation is considered to be in the lowering condition. If none of the above determinations hold, then the target drilling operation is considered to be in other situations.

[0066] As an option, the drilling condition classification during the target drilling operation at the drilling operation site is refined under the first drilling condition classification according to the second input parameter, including the following steps D1-D2:

[0067] Step D1, determining a drilling condition identification model to be used when performing a target drilling operation at a drilling operation site. The drilling condition identification model is obtained by model training based on pre-labeled reference drilling data. The reference drilling data involves corresponding drilling and logging parameters when drilling at the drilling operation site. The pre-labeled reference drilling data is obtained by labeling historical drilling data based on historical drilling data and drilling logs of verified historical drilling data.

[0068] Step D2: input the second input parameter and the first drilling condition classification into the drilling condition identification model, and refine the drilling condition classification of the target drilling operation at the drilling operation site under the first drilling condition classification through the drilling condition identification model.

[0069] In an embodiment of the present invention, the drilling condition identification model refers to a model obtained by machine training and learning historical drilling data acquired when performing target drilling operations at the drilling operation site using a neural network model, combined with corresponding verified drilling logs, and is used to finely divide the first drilling condition classification to obtain the target drilling condition classification for the target drilling operation.

[0070] Specifically, the historical drilling data are labeled using the actual drilling condition classification contained in the drilling log of the verified historical drilling data, which contains the drilling and logging parameters when the target drilling operation is performed at the drilling operation site. Then, a decision tree algorithm is used to perform machine learning training on the labeled historical drilling data to obtain a drilling condition recognition model. The first drilling condition classification identified by the first input parameter associated with the target drilling operation at the current drilling operation site and the second input parameter associated with the target drilling operation are input into the drilling condition recognition model obtained by training, and the target drilling condition classification after the first drilling condition classification is finely divided can be obtained.

[0071] As an option, data management is performed on the second drilling data according to the target drilling condition classification to obtain the third drilling data, including the following steps E1-E2:

[0072] Step E1, determining the target parameter processing logic associated with the target drilling condition classification, the parameter processing logic is used to indicate the parameter condition information that the drilling and logging parameters need to meet under the target drilling condition classification and the parameter processing logic to be adopted for the drilling and logging parameters when the parameter conditions are not met.

[0073] Step E2: performing data management on the second drilling data through target parameter processing logic associated with the target drilling condition classification to obtain third drilling data.

[0074] In an embodiment of the present invention, the target parameter processing logic refers to the processing logic used when performing data management on the second drilling data according to the target drilling condition classification when the target drilling operation is performed at the drilling operation site, and is used to adjust the drilling and logging parameters that do not meet the parameter condition information so as to meet the parameter condition information. For example, Table 1 shows different target parameter processing logics corresponding to different target drilling condition classifications.

[0075] Table 1 Target parameter processing logic

[0076]

[0077] Among them, ρ t is the drilling fluid density of the target drilling operation at the current moment, ρ t-1 The drilling fluid density of the target drilling operation at the previous moment, TH is the total hydrocarbons of the target drilling operation.

[0078] Specifically, a target parameter processing logic corresponding to the target drilling condition classification is selected, and the target parameter processing logic is used to perform data management on the corresponding drilling data in the second drilling data of the target drilling operation, thereby obtaining the third drilling data of the target drilling operation.

[0079] The technical solution of the embodiment of the present invention, by acquiring the first drilling data when the target drilling operation is performed at the drilling operation site, the drilling data at least includes the drilling and logging parameters used to describe the riser pressure, turntable torque, hook load and turntable speed in the process of drilling and completion at the drilling operation site, so as to realize real-time acquisition of the drilling data when the target drilling operation is performed at the drilling operation site, so as to timely discover and solve the problems arising from the drilling data; the null values ​​and abnormal values ​​in the first drilling data are optimized to obtain the second drilling data, so as to avoid the influence of the erroneous data existing in the drilling data when the data is processed, and ensure the accuracy of the drilling data; determine the target drilling condition classification when the target drilling operation is performed at the drilling operation site, and perform data management on the second drilling data according to the target drilling condition classification to obtain the third drilling data, so as to improve the efficiency of drilling data management, reduce the need for manual inspection and correction of data errors, reduce the risk of human errors, and reduce labor costs, so as to quickly complete the review, classification and marking of drilling data in the future.

[0080] Embodiment 2

[0081] Figure 3 This is a schematic diagram of the structure of a drilling data processing device provided in the second embodiment of the present invention. The embodiment of the present invention can be applied to the automatic management of drilling data obtained during drilling operations at a drilling operation site. The device can be implemented in the form of hardware and / or software, and can be configured in an electronic device that implements a drilling data processing method. Figure 3 As shown, the device comprises:

[0082] The data acquisition module 201 is used to acquire first drilling data when a target drilling operation is performed at a drilling operation site, wherein the drilling data at least includes drilling and logging parameters used to describe the riser pressure, rotary table torque, hook load, and rotary table speed during the drilling and completion process at the drilling operation site;

[0083] A data optimization module 202 is used to optimize the null values ​​and abnormal values ​​in the first drilling data to obtain the second drilling data;

[0084] The data management module 203 is used to determine the target drilling condition classification when the target drilling operation is performed at the drilling operation site, and perform data management on the second drilling data according to the target drilling condition classification to obtain the third drilling data.

[0085] As an optional method, obtaining first drilling data when a target drilling operation is performed at a drilling operation site includes:

[0086] Through the data access function of the OpenLookeng open source component, the drilling data collected by various sensors deployed at the drilling operation site during the target drilling operation is received;

[0087] The drilling data collected by various sensors at the drilling operation site are analyzed through the OpenLookeng open source component to obtain the first drilling data collected for the target drilling operation at the drilling operation site.

[0088] As an option, determining the target drilling condition classification for the target drilling operation at the drilling operation site includes:

[0089] Determining first input parameters associated with a target drilling operation at a drilling operation site, the first input parameters including drilling and logging parameters and drilling design information involved in the first drilling data, the drilling and logging parameters including depth measurement, drill bit depth, drilling pressure, and drilling speed when the drilling operation is performed at the drilling operation site, and the drilling design information including a designed well depth and wellbore structure of the well being drilled at the drilling operation site;

[0090] Determine a second input parameter associated with the target drilling operation at the drilling operation site, the second input parameter including the depth measurement, drill bit depth, drilling pressure, pump displacement, drilling time, rotary table speed and standpipe pressure of the corresponding drilling and logging parameters involved in the first drilling data when drilling at the drilling operation site;

[0091] Based on the first input parameter and the second input parameter, a target drilling condition classification in which a target drilling operation is performed at a drilling operation site is determined.

[0092] As an option, based on the first input parameter and the second input parameter, determining the target drilling condition classification when the target drilling operation is performed at the drilling operation site includes:

[0093] According to the first input parameter, a drilling operation state analysis is performed according to a preset drilling operation state recognition logic used when the target drilling operation is performed at the drilling operation site, and a first drilling condition classification is determined when the target drilling operation is performed at the drilling operation site, wherein the first drilling condition classification includes at least one of a drilling condition, a lifting condition, and a lowering condition;

[0094] The drilling condition classification when the target drilling operation is performed at the drilling operation site is refined according to the second input parameter under the first drilling condition classification to determine the target drilling condition classification when the target drilling operation is performed at the drilling operation site.

[0095] As an optional option, the preset drilling operation status identification logic is used to indicate the preset status conditions that need to be met for different drilling condition classifications, wherein the preset status conditions that need to be met for the drilling condition are that the drill bit depth is equal to the sounding, the drill bit depth during the current drilling operation is not less than the drill bit depth during the previous drilling operation, and the drilling pressure is not equal to the preset value; the preset status conditions that need to be met for the lifting condition are that the drill bit depth is less than the sounding, the drill bit depth during the current drilling operation is less than the drill bit depth during the previous drilling operation, and the drilling pressure is not greater than the preset value; the preset status conditions that need to be met for the lowering condition are that the drill bit depth is less than the sounding, the drill bit depth during the current drilling operation is greater than the drill bit depth during the previous drilling operation, and the drilling pressure is not less than the preset value, and the preset value is 0.

[0096] As an option, the drilling condition classification during the target drilling operation at the drilling operation site is refined under the first drilling condition classification according to the second input parameter, including:

[0097] Determine a drilling condition identification model used when performing a target drilling operation at a drilling operation site. The drilling condition identification model is obtained by training a model based on pre-annotated reference drilling data. The reference drilling data involves corresponding drilling and logging parameters when drilling at the drilling operation site. The pre-annotated reference drilling data is obtained by annotating historical drilling data based on historical drilling data and drilling logs of verified historical drilling data;

[0098] The second input parameter and the first drilling condition classification are input into the drilling condition identification model, and the drilling condition classification during the target drilling operation at the drilling operation site is refined under the first drilling condition classification through the drilling condition identification model.

[0099] As an option, data management is performed on the second drilling data according to the target drilling condition classification to obtain the third drilling data, including:

[0100] Determine the target parameter processing logic associated with the target drilling condition classification, the parameter processing logic is used to indicate the parameter condition information that the drilling and logging parameters need to meet under the target drilling condition classification and the parameter processing logic to be taken for the drilling and logging parameters when the parameter conditions are not met;

[0101] The second drilling data is data-managed by target parameter processing logic associated with the target drilling condition classification to obtain third drilling data.

[0102] The technical solution of the embodiment of the present invention, by acquiring the first drilling data when the target drilling operation is performed at the drilling operation site, the drilling data at least includes the drilling and logging parameters used to describe the riser pressure, turntable torque, hook load and turntable speed in the process of drilling and completion at the drilling operation site, so as to realize real-time acquisition of the drilling data when the target drilling operation is performed at the drilling operation site, so as to timely discover and solve the problems arising from the drilling data; the null values ​​and abnormal values ​​in the first drilling data are optimized to obtain the second drilling data, so as to avoid the influence of the erroneous data existing in the drilling data when the data is processed, and ensure the accuracy of the drilling data; determine the target drilling condition classification when the target drilling operation is performed at the drilling operation site, and perform data management on the second drilling data according to the target drilling condition classification to obtain the third drilling data, so as to improve the efficiency of drilling data management, reduce the need for manual inspection and correction of data errors, reduce the risk of human errors, and reduce labor costs, so as to quickly complete the review, classification and marking of drilling data in the future. The drilling data processing device provided in the embodiment of the present invention can execute the drilling data processing method provided in any embodiment of the present invention, and has the corresponding functional modules and beneficial effects of the execution method.

[0103] Embodiment 3

[0104] Figure 4 A schematic diagram of the structure of an electronic device for implementing a drilling data processing method provided in Embodiment 3 of the present invention. The electronic device is intended to represent various forms of digital computers, such as laptop computers, desktop computers, workbenches, personal digital assistants, servers, blade servers, mainframe computers, and other suitable computers. The electronic device may also represent various forms of mobile devices, such as personal digital processing, cellular phones, smart phones, wearable devices (such as helmets, glasses, watches, etc.) and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely examples and are not intended to limit the implementation of the present invention described and / or required herein.

[0105] like Figure 4As shown, the electronic device 10 includes at least one processor 11, and a memory connected to the at least one processor 11, such as a read-only memory (ROM) 12, a random access memory (RAM) 13, etc., wherein the memory stores a computer program that can be executed by at least one processor, and the processor 11 can perform various appropriate actions and processes according to the computer program stored in the read-only memory (ROM) 12 or the computer program loaded from the storage unit 18 to the random access memory (RAM) 13. In the RAM 13, various programs and data required for the operation of the electronic device 10 can also be stored. The processor 11, the ROM 12, and the RAM 13 are connected to each other through a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0106] A number of components in the electronic device 10 are connected to the I / O interface 15, including: an input unit 16, such as a keyboard, a mouse, etc.; an output unit 17, such as various types of displays, speakers, etc.; a storage unit 18, such as a disk, an optical disk, etc.; and a communication unit 19, such as a network card, a modem, a wireless communication transceiver, etc. The communication unit 19 allows the electronic device 10 to exchange information / data with other devices through a computer network such as the Internet and / or various telecommunication networks.

[0107] The processor 11 may be a variety of general and / or special processing components with processing and computing capabilities. Some examples of the processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any appropriate processor, controller, microcontroller, etc. The processor 11 executes the various methods and processes described above, such as a drilling data processing method.

[0108] In some embodiments, the drilling data processing method may be implemented as a computer program, which is tangibly contained in a computer-readable storage medium, such as a storage unit 18. In some embodiments, part or all of the computer program may be loaded and / or installed on the electronic device 10 via the ROM 12 and / or the communication unit 19. When the computer program is loaded into the RAM 13 and executed by the processor 11, one or more steps of the drilling data processing method described above may be performed. Alternatively, in other embodiments, the processor 11 may be configured to execute the drilling data processing method in any other appropriate manner (e.g., by means of firmware).

[0109] Various implementations of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field programmable gate arrays (FPGAs), application specific integrated circuits (ASICs), application specific standard products (ASSPs), systems on chips (SOCs), load programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various implementations can include: being implemented in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which can be a special purpose or general purpose programmable processor that can receive data and instructions from a storage system, at least one input device, and at least one output device, and transmit data and instructions to the storage system, the at least one input device, and the at least one output device.

[0110] Computer programs for implementing the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, so that when the computer program is executed by the processor, the functions / operations specified in the flow chart and / or block diagram are implemented. The computer program may be executed entirely on the machine, partially on the machine, partially on the machine and partially on a remote machine as a stand-alone software package, or entirely on a remote machine or server.

[0111] In the context of the present invention, a computer-readable storage medium may be a tangible medium that may contain or store a computer program for use by or in combination with an instruction execution system, device or equipment. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, devices or equipment, or any suitable combination of the foregoing. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. A more specific example of a machine-readable storage medium may include an electrical connection based on one or more lines, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.

[0112] To provide interaction with a user, the systems and techniques described herein may be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and a pointing device (e.g., a mouse or trackball) through which the user can provide input to the electronic device. Other types of devices may also be used to provide interaction with the user; for example, the feedback provided to the user may be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user may be received in any form (including acoustic input, voice input, or tactile input).

[0113] The systems and techniques described herein may be implemented in a computing system that includes backend components (e.g., as a data server), or a computing system that includes middleware components (e.g., an application server), or a computing system that includes frontend components (e.g., a user computer with a graphical user interface or a web browser through which a user can interact with implementations of the systems and techniques described herein), or a computing system that includes any combination of such backend components, middleware components, or frontend components. The components of the system may be interconnected by any form or medium of digital data communication (e.g., a communication network). Examples of communication networks include: a local area network (LAN), a wide area network (WAN), a blockchain network, and the Internet.

[0114] A computing system may include a client and a server. The client and the server are generally remote from each other and usually interact through a communication network. The client and server relationship is generated by computer programs running on the corresponding computers and having a client-server relationship with each other. The server may be a cloud server, also known as a cloud computing server or cloud host, which is a host product in the cloud computing service system to solve the defects of difficult management and weak business scalability in traditional physical hosts and VPS services.

[0115] It should be understood that the various forms of processes shown above can be used to reorder, add or delete steps. For example, the steps described in the present invention can be executed in parallel, sequentially or in different orders, as long as the desired results of the technical solution of the present invention can be achieved, and this document does not limit this.

[0116] The above specific implementations do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions can be made according to design requirements and other factors. Any modification, equivalent substitution and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims

1. A drilling data processing method, characterized in that: The method comprises: Acquire first drilling data when a target drilling operation is performed at a drilling operation site, wherein the drilling data at least includes drilling and logging parameters used to describe standpipe pressure, rotary table torque, hook load, and rotary table speed during drilling and completion at the drilling operation site; Optimizing the null values ​​and abnormal values ​​in the first drilling data to obtain second drilling data; A target drilling condition classification in which a target drilling operation is performed at a drilling operation site is determined, and data management is performed on the second drilling data according to the target drilling condition classification to obtain third drilling data.

2. The method according to claim 1, characterized in that Acquire the first drilling data when performing the target drilling operation at the drilling operation site, including: Through the data access function of the OpenLookeng open source component, the drilling data collected by various sensors deployed at the drilling operation site during the target drilling operation is received; The drilling data collected by various sensors at the drilling operation site are analyzed through the OpenLookeng open source component to obtain the first drilling data collected for the target drilling operation at the drilling operation site.

3. The method according to claim 1, characterized in that: Determine the target drilling conditions classification for the target drilling operation at the drilling operation site, including: Determining first input parameters associated with a target drilling operation at a drilling operation site, wherein the first input parameters include drilling and logging parameters and drilling design information involved in the first drilling data, wherein the drilling and logging parameters include depth measurement, drill bit depth, drilling pressure, and drilling speed when the drilling operation is performed at the drilling operation site, and the drilling design information includes a designed well depth and wellbore structure of the well to be drilled at the drilling operation site; Determine a second input parameter associated with the target drilling operation at the drilling operation site, wherein the second input parameter includes the depth measurement, drill bit depth, drilling pressure, pump displacement, drilling time, rotary table speed, and standpipe pressure of the corresponding drilling and logging parameters involved in the first drilling data when drilling at the drilling operation site; Based on the first input parameter and the second input parameter, a target drilling condition classification in which a target drilling operation is performed at a drilling operation site is determined.

4. The method according to claim 3, characterized in that Determining a target drilling condition classification for a target drilling operation at a drilling operation site based on the first input parameter and the second input parameter includes: According to the first input parameter, a drilling operation state analysis is performed according to a preset drilling operation state recognition logic used when the target drilling operation is performed at the drilling operation site, and a first drilling condition classification is determined when the target drilling operation is performed at the drilling operation site, wherein the first drilling condition classification includes at least one of a drilling condition, a lifting condition, and a lowering condition; The drilling condition classification when the target drilling operation is performed at the drilling operation site is refined according to the second input parameter under the first drilling condition classification to determine the target drilling condition classification when the target drilling operation is performed at the drilling operation site.

5. The method according to claim 4, characterized in that The preset drilling operation state identification logic is used to indicate the preset state conditions that need to be met for different drilling working condition classifications, wherein the preset state conditions that need to be met for the drilling working condition are that the drill bit depth is equal to the sounding, the drill bit depth during the current drilling operation is not less than the drill bit depth during the previous drilling operation, and the drilling pressure is not equal to the preset value; the preset state conditions that need to be met for the lifting working condition are that the drill bit depth is less than the sounding, the drill bit depth during the current drilling operation is less than the drill bit depth during the previous drilling operation, and the drilling pressure is not greater than the preset value; the preset state conditions that need to be met for the lowering working condition are that the drill bit depth is less than the sounding, the drill bit depth during the current drilling operation is greater than the drill bit depth during the previous drilling operation, and the drilling pressure is not less than the preset value, and the preset value is 0.

6. The method according to claim 4, characterized in that The drilling condition classification during the target drilling operation at the drilling operation site is refined according to the second input parameter under the first drilling condition classification, including: Determine a drilling condition identification model used when performing a target drilling operation at a drilling operation site, wherein the drilling condition identification model is obtained by model training based on pre-labeled reference drilling data, wherein the reference drilling data involves corresponding drilling and logging parameters when drilling at the drilling operation site, and wherein the pre-labeled reference drilling data is obtained by labeling historical drilling data based on historical drilling data and drilling logs of verified historical drilling data; The second input parameter and the first drilling condition classification are input into the drilling condition identification model, and the drilling condition classification during the target drilling operation at the drilling operation site is refined under the first drilling condition classification through the drilling condition identification model.

7. The method according to claim 1, characterized in that Performing data management on the second drilling data according to the target drilling condition classification to obtain third drilling data includes: Determine a target parameter processing logic associated with the target drilling condition classification, the parameter processing logic being used to indicate parameter condition information that the drilling and logging parameters need to satisfy under the target drilling condition classification and the parameter processing logic to be adopted for the drilling and logging parameters when the parameter conditions are not satisfied; The target parameter processing logic associated with the target drilling condition classification is used to perform data management on the second drilling data to obtain the third drilling data.

8. A drilling data processing device, characterized in that: The device comprises: A data acquisition module, used to acquire first drilling data when a target drilling operation is performed at a drilling operation site, wherein the drilling data at least includes drilling and logging parameters used to describe standpipe pressure, rotary table torque, hook load, and rotary table speed during drilling and completion at the drilling operation site; A data optimization module, configured to optimize the null values ​​and abnormal values ​​in the first drilling data to obtain second drilling data; The data management module is used to determine the target drilling condition classification when the target drilling operation is performed at the drilling operation site, and perform data management on the second drilling data according to the target drilling condition classification to obtain the third drilling data.

9. An electronic device, characterized in that: The electronic device comprises: one or more processors; a storage device for storing one or more programs, When the one or more programs are executed by the one or more processors, the one or more processors implement the drilling data processing method as described in any one of claims 1-7.

10. A storage medium comprising computer executable instructions, wherein the computer executable instructions are used to execute the drilling data processing method according to any one of claims 1 to 7 when executed by a computer processor.

Images