Oil well data processing method and device, computer equipment and storage medium

Abstract

The invention provides an oil well data processing method and device, a terminal and a storage medium, and belongs to the technical field of computers. According to the method provided by the embodiment of the invention, the tool data in the oil well can be obtained, the tool data are classified based on the on-repair state and the position relative to the pump cylinder to obtain the classification data, and the tool data before and after on-repair and the oil pipe data above and below the pump can be clearly distinguished based on the classification data; the method comprises the following steps: acquiring classified data, further dividing the classified data based on characteristic values to obtain an oil pipe array and an accessory array, combining various different types of oil pipes by the oil pipe array, combining various different types of oil pipe accessories by the accessory array, so that the classified data becomes simple and clear, and finally generating a data classification statistical table based on the oil pipe array and the accessory array. Therefore, the initial oil well data becomes clear in classification and clear in content, so that the query efficiency of the oil well data is improved.

Description

Technical Field

[0001] The present application relates to the field of computer technology, and in particular to an oil well data processing method, device, computer equipment and storage medium. Background Art

[0002] With the development of oilfield technology, oilfield related data has gradually increased, and oilfield related data is an important basis for operating oil wells in oilfields, and this data affects the downhole operation effect. Therefore, how to process oil well data is the focus of research in this field.

[0003] At present, the commonly used method of managing oil well data is independent management, and each system has an independent database to store its own oil well data.

[0004] However, there is duplication of oil well data between different self-built systems. For example, the oil well data shared by various self-built systems uses different oil well data names between the respective built systems, resulting in a large amount of redundancy in the oil well data, which in turn makes the query efficiency of the oil well data low. Summary of the invention

[0005] The embodiment of the present application provides an oil well data processing method, device, terminal and storage medium for improving the efficiency of oil well data query. The technical solution is as follows:

[0006] In one aspect, a method for processing oil well data is provided, the method comprising:

[0007] Acquire oil well data of the oil well, the oil well data including tool data of the oil well, the tool data being data describing the operation conditions of various tools in the oil well;

[0008] Analyze the tool data to obtain classified data, which is used to indicate the repair state and relative pump barrel position corresponding to the tool data, the repair state includes before and after the repair, and the relative pump barrel position includes pump up and pump down;

[0009] Acquire characteristic values ​​of multiple tools based on the classified data, merge the classified data by item based on the characteristic values ​​of the multiple tools, and obtain a tubing array and an accessory array, wherein the characteristic values ​​are used to indicate the type characteristics of the multiple tools, the tubing array includes tubing data belonging to the tubing type in the tool data, and the accessory array includes tubing accessory data belonging to the tubing accessory type in the tool data;

[0010] Based on the oil pipe array and the accessory array, a data classification statistics table of the oil well is generated.

[0011] In some embodiments, the method further comprises:

[0012] In response to the query operation on the oil wells, a data classification statistics table is output.

[0013] In some embodiments, in response to a query operation on an oil well, a data classification statistics table is output, including at least one of the following:

[0014] Based on the well number indicated in the query operation, searching in the database where the oil well data is located, outputting a data classification statistical table corresponding to the well number, the data classification statistical table including the oil pipe data before and after the repair and the oil pipe accessory data;

[0015] Based on the uphaul task identifier indicated in the query operation, a search is performed in the database where the oil well data is located, and target data in the data classification statistical table corresponding to the uphaul task corresponding to the uphaul task identifier is output, the target data including the oil pipe data and oil pipe accessory data after the uphaul task is executed.

[0016] On the other hand, an oil well data processing device is provided, the device comprising:

[0017] A data acquisition module, used to acquire oil well data of an oil well, wherein the oil well data includes tool data of the oil well, and the tool data is data describing the operation conditions of various tools in the oil well;

[0018] An analysis module is used to analyze the tool data to obtain classified data, wherein the classified data is used to indicate the repair state and relative pump barrel position corresponding to the tool data, wherein the repair state includes before and after the repair, and the relative pump barrel position includes pump upper and pump lower;

[0019] A classification module, used for obtaining characteristic values ​​of multiple tools based on the classification data, merging the classification data by item based on the characteristic values ​​of the multiple tools, and obtaining a tubing array and an accessory array, wherein the characteristic values ​​are used to indicate the type characteristics of the multiple tools, the tubing array includes tubing data belonging to the tubing type in the tool data, and the accessory array includes tubing accessory data belonging to the tubing accessory type in the tool data;

[0020] The generation module is used to generate a data classification statistics table of the oil well based on the oil pipe array and the accessory array.

[0021] In some embodiments, the analysis module includes:

[0022] The upward adjustment status acquisition unit is used to sort the operation dates of multiple tools in the tool data to form a date sequence, take the last date in the date sequence as the after-upgrade date, take the date of the previous day closest to the after-upgrade date as the before-upgrade date, and determine the upward adjustment status of the tool based on the before-upgrade date and the after-upgrade date;

[0023] The relative pump barrel position acquisition unit is used to acquire the depth parameter of the tubing data in the tool data and the pump hanging depth of the oil well, and determine the relative pump barrel position of the tubing in the tool based on the pump hanging depth of the oil well.

[0024] In some embodiments, the upward revision status acquisition unit is used to:

[0025] If the tool's operation date in the tool data is a post-update date, the tool's update status is determined to be post-update;

[0026] If the operation date of the tool in the tool data is not a post-upgrade date, the upgrade status of the tool is determined to be before the upgrade.

[0027] In some embodiments, the relative pump cylinder position acquisition unit is used to:

[0028] If the depth parameter of the tubing data in the tool data is less than the pump hanging depth of the oil well, the relative pump barrel position of the tubing in the tool is determined to be on the pump;

[0029] If the depth parameter of the tubing data in the tool data is greater than the pump hanging depth of the oil well, the relative pump barrel position of the tubing in the tool is determined to be pump down.

[0030] In some embodiments, the classification module includes:

[0031] The classification unit is used to determine the affiliation between the multiple tools and the oil pipes and the affiliation between the multiple tools and the accessories based on the characteristic values ​​of the multiple tools, and obtain the oil pipe array and the accessory array based on the affiliation.

[0032] In some embodiments, the classification unit is used to:

[0033] If the characteristic value of the tool indicates that the subordinate relationship between the tool and the oil pipe is that the oil pipe contains the tool, the tool is determined to be the oil pipe array, and the oil pipe data in the tool data of the tool is added to the data of the oil pipe array;

[0034] If the characteristic value of the tool indicates that the affiliation between the tool and the tubing is that the tubing does not contain the tool, the tool is determined as an attachment array, and the tubing attachment data in the tool data of the tool is added to the data of the attachment array.

[0035] In some embodiments, the generation module is used to:

[0036] Based on the tubing data in the tubing array, the total number of tubings with the same specification and the same relative pump barrel position is obtained, and the total number is used as the number of tubing arrays corresponding to the specification and relative pump barrel position in the data classification statistics table;

[0037] Based on the tubing data in the tubing array, the total length of the tubing with the same specification and the same relative pump barrel position relationship is obtained, and the total length is used as the length corresponding to the specification and the relative pump barrel position relationship in the data classification statistical table;

[0038] Based on the oil pipe attachment data in the attachment array, the total number of oil pipe attachments with the same name and the same specification is obtained, and the total number is used as the number corresponding to the name and specification in the data classification statistics table;

[0039] Based on the tubing attachment data in the attachment array, the depth of the tubing attachment with the same name and the same specification is obtained, and the depth is used as the depth corresponding to the name and specification in the data classification statistics table.

[0040] In some embodiments, the apparatus further comprises:

[0041] The output module is used to output a data classification statistics table in response to a query operation on the oil well.

[0042] In some embodiments, the output module is used to:

[0043] Based on the well number indicated in the query operation, searching in the database where the oil well data is located, outputting a data classification statistical table of the oil well corresponding to the well number, the data classification statistical table including the oil pipe data before and after the repair and the oil pipe accessory data;

[0044] Based on the uphaul task identifier indicated in the query operation, a search is performed in the database where the oil well data is located, and target data in the data classification statistical table corresponding to the uphaul task corresponding to the uphaul task identifier is output, the target data including the oil pipe data and oil pipe accessory data after the uphaul task is executed.

[0045] On the other hand, a computer device is provided, which includes a processor and a memory, wherein the memory is used to store at least one computer program, and the at least one computer program is loaded and executed by the processor to implement the operations performed by the oil well data processing method in the embodiment of the present application.

[0046] On the other hand, a computer-readable storage medium is provided, in which at least one computer program is stored. The at least one computer program is loaded and executed by a processor to implement the operations performed by the oil well data processing method in the embodiment of the present application. BRIEF DESCRIPTION OF THE DRAWINGS

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

[0048] Figure 1 is a schematic diagram of an implementation environment of an oil well data processing method provided according to an embodiment of the present application;

[0049] Figure 2 is a flow chart of an oil well data processing method provided according to an embodiment of the present application;

[0050] Figure 3 is a flow chart of an oil well data processing method provided according to an embodiment of the present application;

[0051] Figure 4 It is a tool affiliation diagram provided according to an embodiment of the present application;

[0052] Figure 5 It is a flow chart of an oil well data processing method provided according to an embodiment of the present application;

[0053] Figure 6 It is a flow chart of an oil well data processing method provided according to an embodiment of the present application;

[0054] Figure 7 is a block diagram of an oil well data processing device provided according to an embodiment of the present application;

[0055] Figure 8 is a structural block diagram of a computer device provided according to an embodiment of the present application;

[0056] Fig. 9 It is a structural diagram of a server provided according to an embodiment of the present application. DETAILED DESCRIPTION

[0057] In order to make the objectives, technical solutions and advantages of the present application clearer, the implementation methods of the present application will be further described in detail below with reference to the accompanying drawings.

[0058] In this application, the terms "first", "second", etc. are used to distinguish identical or similar items with basically the same effects and functions. It should be understood that there is no logical or temporal dependency between "first", "second", and "nth", nor is there any limitation on quantity and execution order.

[0059] In the present application, the term "at least one" means one or more, and the term "plurality" means two or more.

[0060] It should be noted that the information (including but not limited to user device information, user personal information, etc.), data (including but not limited to data used for analysis, stored data, displayed data, etc.) and signals involved in this application are all authorized by the user or fully authorized by all parties, and the collection, use and processing of relevant data must comply with relevant laws, regulations and standards of relevant countries and regions.

[0061] For ease of understanding, the terms involved in this application are explained below.

[0062] Oil well pump: Oil well pump refers to an underground device driven by a pumping unit to lift the crude oil in the well to the ground. An ordinary oil well pump is mainly composed of four parts: pump barrel, suction valve, piston and discharge valve.

[0063] Downhole operation: In the process of oilfield development, according to the needs of oilfield adjustment, transformation, improvement and potential tapping, and in accordance with the process design requirements, a set of ground and downhole equipment and tools are used to take various downhole technical measures for oil and water wells to achieve the purpose of increasing injection and production volume, improving oil layer seepage conditions and oil and water well technical conditions, and increasing oil production speed and ultimate recovery rate. This series of downhole construction technology is collectively referred to as downhole operation.

[0064] Figure 1 Schematic diagram of an implementation environment of an oil well data processing method provided according to an embodiment of the present application. Figure 1 , the implementation environment includes a terminal 101 and a server 102.

[0065] The terminal 101 and the server 102 can be connected directly or indirectly via wired or wireless communication, which is not limited in this application.

[0066] In some embodiments, the terminal 101 is a smart phone, a tablet computer, a laptop computer, a desktop computer, etc., but is not limited thereto. The terminal 101 installs and runs an application that supports the oil well data processing function. Schematically, the terminal 101 is a terminal used by a user, and the user can trigger a query operation on the terminal 101. The terminal 101 outputs corresponding data based on the query operation to display the corresponding query result. The corresponding data is the data obtained after data processing in the storage stage.

[0067] In some embodiments, the server 102 is an independent physical server, or a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN (Content Delivery Network), big data and artificial intelligence platforms. The server 102 is used to provide background services for applications that support oil well data processing functions. In some embodiments, the server 102 undertakes the main computing work and the terminal 101 undertakes the secondary computing work; or, the server 102 undertakes the secondary computing work and the terminal 101 undertakes the main computing work; or, the server 102 and the terminal 101 use a distributed computing architecture for collaborative computing.

[0068] Those skilled in the art will appreciate that the number of the above terminals may be more or less. For example, the above terminal may be only one, or the above terminals may be dozens or hundreds, or more. The embodiment of the present application does not limit the number of terminals and device types.

[0069] In some embodiments, the wireless network or wired network described above uses standard communication technology and / or protocols. The network is typically the Internet, but can also be any network, including but not limited to a local area network (LAN), a metropolitan area network (MAN), a wide area network (WAN), a mobile, wired or wireless network, a dedicated network or any combination of a virtual private network. In some embodiments, technologies and / or formats including Hyper Text Mark-up Language (HTML), Extensible Markup Language (XML), etc. are used to represent data exchanged over the network. In addition, conventional encryption technologies such as Secure Socket Layer (SSL), Transport Layer Security (TLS), Virtual Private Network (VPN), Internet Protocol Security (IPsec), etc. can also be used to encrypt all or some links. In other embodiments, customized and / or dedicated data communication technologies can also be used to replace or supplement the above data communication technologies.

[0070] Figure 2 is a flow chart of an oil well data processing method provided according to an embodiment of the present application, such as Figure 2 As shown, in the embodiment of the present application, a server is used as an example for explanation. The method comprises the following steps:

[0071] 201. The server obtains oil well data of the oil well, where the oil well data includes tool data of the oil well, and the tool data is data describing the operation conditions of various tools in the oil well.

[0072] In some embodiments, the oil well data is an important indicator for detecting the operation status of tools in the oilfield system, wherein the oil well data includes tool data of multiple different oil wells, and the tool data includes oil pipe data and oil pipe accessory data.

[0073] Among them, in the oil field process, the oil well data collected in real time is stored in the form of a database, and the oil well data is obtained by obtaining the storage address of the database where the oil well data of the oil well is located. That is, first obtain the storage address of the database where the oil well data of the oil well is located, and based on the storage address, locate the database where the oil well data of the oil well is located, and then obtain the oil well data in the database.

[0074] 202. The server analyzes the tool data to obtain classification data, where the classification data is used to indicate the upkeep state and relative pump barrel position corresponding to the tool data, where the upkeep state includes before upkeep and after upkeep, and the relative pump barrel position includes pump up and pump down.

[0075] Among them, the overhaul status is used to detect the basic conditions of the tool before and after the overhaul task. For example, classifying the tool data before and after the overhaul can more intuitively distinguish the basic conditions of the tools in the two overhaul states.

[0076] Among them, the pump barrel in the relative pump barrel position indicates the oil pump. The oil pump is at a certain depth below the liquid surface of the oil well. It relies on the sucker rod to transmit the power of the pumping unit to pump the liquid out of the ground. This process is realized in the oil pipe. Therefore, the positional relationship between the oil pipe and the oil pump will affect the liquid production. The tool data is classified. For example, the relative pump barrel position of the oil pipe is classified as above the pump and below the pump. This can understand the basic conditions of the oil pipe at different relative pump barrel positions.

[0077] 203. The server obtains characteristic values ​​of multiple tools based on the classification data, and merges the classification data items based on the characteristic values ​​of the multiple tools to obtain a tubing array and an accessory array. The characteristic values ​​are used to indicate the type characteristics of the multiple tools. The tubing array includes tubing data belonging to the tubing type in the tool data, and the accessory array includes tubing accessory data belonging to the tubing accessory type in the tool data.

[0078] In some embodiments, in order to further refine the classified data, tool data of different types of tools in the classified data are listed by enumeration, wherein the classified data is a finite sequence set, and the tool data of different types of tools are all members of the finite sequence set. The types of the different types of tools are determined based on the characteristic values, that is, the tool data of different types of tools are enumerated by the characteristic values, and then the tool data are classified into a tubing array and an accessory array.

[0079] Among them, the oil pipe array and the accessory array still have the up-repair status and relative pump barrel position in the classification data.

[0080] 204. The server generates a data classification statistics table for the oil well based on the oil pipe array and the attachment array.

[0081] In some embodiments, the data classification statistics table may be in the form of a table, wherein the columns of the table are used to represent multiple attributes included in the tubing array and the accessory array, such as the name, specification, quantity, and length of the items in the tubing array, and the name, specification, quantity, and depth of the items in the accessory array. The rows of the table are used to represent the attribute values ​​of the attributes in the above columns corresponding to the items with different names, for example, the names of the tubing array include tubing string combination form, total, pump on, and pump off, and the names of the accessory array include whole barrel pump, oil drain, eye tube, and mother plug.

[0082] Among them, the generated data classification statistical table is stored in the database corresponding to the database storage address of the oil well data. The data classification statistical table can be stored with the well number as an identifier, and different well numbers correspond to different data classification statistical tables. The repair task identifier can also be stored as an identifier. Each repair task performed by an oil well corresponds to an repair task identifier, and the embodiment of the present application does not limit this.

[0083] The method provided in the embodiment of the present application can obtain tool data in the oil well, classify the tool data based on the repair status and the relative pump barrel position to obtain classified data, and based on the classified data, it can clearly distinguish the tool data before and after the repair and the oil pipe data on and under the pump, and then further divide the classified data based on the characteristic values ​​to obtain an oil pipe array and an accessory array. The oil pipe array combines multiple different types of oil pipes, and the accessory array combines multiple different types of oil pipe accessories, so that the classified data becomes concise and clear. Finally, a data classification statistical table is generated based on the oil pipe array and the accessory array, so that the original oil well data becomes clearly classified and clear in content, thereby improving the query efficiency of the oil well data.

[0084] Figure 3 is a flow chart of an oil well data processing method provided according to an embodiment of the present application, such as Figure 3 As shown, in the embodiment of the present application, a server is used as an example for explanation. The method comprises the following steps:

[0085] 301. The server obtains oil well data of the oil well, where the oil well data includes tool data of the oil well, and the tool data is data describing the operation conditions of various tools in the oil well.

[0086] In some embodiments, taking an oil well as an example, the oil well data of the oil well is obtained. For example, taking the "Xing 77-281" well as an example, the tool data in the oil well data corresponding to the oil well includes the well number, operation process name, operation date, pipe serial number, tool name, specification, length and depth, etc. The specific tool data is shown in Table 1 below.

[0087] Table 1

[0088]

[0089]

[0090] 302. The server analyzes the tool data to obtain classification data, where the classification data is used to indicate a repair state corresponding to the tool data, where the repair state includes before the repair and after the repair.

[0091] In some embodiments, the tool data is classified by the repair status, and the problem is found and tracked by comparing the tool data of the tools in the two states. The judgment process of the repair status includes:

[0092] The operation dates of multiple tools in the tool data are sorted to form a date sequence. The last date in the date sequence is taken as the post-update date, and the date of the previous day closest to the post-update date is taken as the pre-update date. The tool's upgrade status is determined based on the pre-update date and the post-update date.

[0093] Since each tool performs multiple up-trim tasks, for the convenience of observation, the last operation date is taken as the post-up-trim date, because no up-trim task has been performed after this date, and there are multiple operation dates before the post-up-trim date. The operation date of the previous day closest to the post-up-trim date is taken as the pre-up-trim date, which can most accurately highlight the difference in tool data before and after the up-trim task is performed. The process of determining the up-trim status of the tool based on the pre-up-trim date and the post-up-trim date includes the following steps 302A and 302B:

[0094] 302A: If the operation date of the tool in the tool data is a post-update date, the upkeep status of the tool is determined to be post-upkeep.

[0095] Among them, the operation dates of multiple different tools in the tool data are compared with the post-upgrade date. If the operation date of the tool is the same as the post-upgrade date, the tool has not performed the upgrade task after completing the upgrade task corresponding to the operation date, and the upgrade status of the tool is determined to be after upgrade.

[0096] 302B: If the operation date of the tool in the tool data is not a post-upgrade date, the upgrade status of the tool is determined to be before upgrade.

[0097] Among them, the operation dates of multiple different tools in the tool data are compared with the post-repair date. If the operation date of the tool is different from the post-repair date, the tool has performed a repair task after completing the repair task corresponding to the operation date, and the repair status of the tool is determined to be before the repair.

[0098] 303. The classification data is also used to indicate the relative pump barrel position corresponding to the tool data, and the relative pump barrel position includes pump top and pump bottom.

[0099] In some embodiments, the relative pump barrel position of the tubing is the position of the tubing relative to the pump hanging depth. The pump hanging depth is an important factor affecting the production potential, pump efficiency level, oil recovery efficiency and the occurrence rate of pump condition problems. Therefore, the relative pump barrel position of the tubing is an important observation indicator. The process of determining the relative pump barrel position includes:

[0100] The depth parameter of the tubing data in the tool data and the pump hanging depth of the oil well are obtained, and the relative pump barrel position of the tubing in the tool is determined based on the pump hanging depth of the oil well.

[0101] The depth parameter of the oil pipe data indicates the depth of the oil pipe relative to the wellhead underground, and the pump hanging depth of the oil well indicates the depth of the oil pump in the oil well relative to the wellhead underground, that is, the position of the oil pump. The determination process includes the following steps 303A and 303B:

[0102] 303A: If the depth parameter of the tubing data in the tool data is less than the pump hanging depth of the oil well, the relative pump barrel position of the tubing in the tool is determined to be on the pump;

[0103] The depth parameter of the oil pipe data is less than the pump hanging depth of the oil well, indicating that the oil pipe is located above the oil pump underground, and the relative position of the oil pipe to the pump barrel is determined to be above the pump.

[0104] 303B: If the depth parameter of the tubing data in the tool data is greater than the pump hanging depth of the oil well, the relative pump barrel position of the tubing in the tool is determined to be pump down.

[0105] The depth parameter of the oil pipe data is greater than the pump hanging depth of the oil well, indicating that the oil pipe is located below the oil pump underground, and the relative position of the oil pipe to the pump barrel is determined to be below the pump.

[0106] According to step 302 and step 303, the classification data is obtained based on the tool data being classified according to the repair status and the relative pump barrel position, so that the tool data is more concise and clear.

[0107] 304. The server obtains characteristic values ​​of multiple tools based on the classification data, and merges the classification data items based on the characteristic values ​​of the multiple tools to obtain a tubing array and an accessory array. The characteristic values ​​are used to indicate type characteristics of the multiple tools. The tubing array includes tubing data belonging to the tubing type in the tool data, and the accessory array includes tubing accessory data belonging to the tubing accessory type in the tool data.

[0108] There are different types of tools in the classified data, each type corresponds to a characteristic value, and the classified data can be further classified based on automatic cluster analysis of the characteristic value, wherein the classification process includes the following steps 304A and 304B:

[0109] 304A: Determine the affiliation between the multiple tools and the oil pipes based on the characteristic values ​​of the multiple tools, and obtain an array of the oil pipes based on the affiliation.

[0110] The judgment process of this step includes: if the characteristic value of the tool indicates that the subordinate relationship between the tool and the tubing is that the tubing contains the tool, the tool is determined as the tubing array, and the tubing data in the tool data of the tool is added to the data of the tubing array.

[0111] For example, the characteristic value of the FRP oil pipe can indicate that the FRP oil pipe belongs to a type of oil pipe. The affiliation between the FRP oil pipe and the oil pipe is that the oil pipe contains the FRP oil pipe. The FRP oil pipe is determined as an oil pipe array, and the oil pipe data of the FRP oil pipe is added to the data of the oil pipe array. Figure 4 (A), Figure 4 (A) shows different tools belonging to the oil pipe, including oil pipe, fiberglass oil pipe, paint oil pipe, ordinary oil pipe, anti-corrosion and wear-resistant oil pipe, lined oil pipe and tail pipe.

[0112] 304B: Determine the affiliation between the multiple tools and the accessories based on the characteristic values ​​of the multiple tools, and obtain an array of accessories based on the affiliation.

[0113] The judgment process of this step includes: if the characteristic value of the tool indicates that the affiliation between the tool and the tubing is that the tubing does not contain the tool, the tool is determined as an attachment array, and the tubing attachment data in the tool data of the tool is added to the data of the attachment array.

[0114] For example, the characteristic value of the whole-barrel pump can indicate that the whole-barrel pump belongs to a tubing accessory. The affiliation between the whole-barrel pump and the tubing is that the tubing does not contain the whole-barrel pump. In this case, the whole-barrel pump is determined as an accessory array, and the tubing accessory data of the whole-barrel pump is added to the data of the accessory array. Figure 4 (B), Figure 4 is a tool affiliation diagram provided according to an embodiment of the present application, Figure 4 (B) shows different tools belonging to the oil pipe accessories, including a full-barrel pump, an oil drain, an eye tube and a female plug.

[0115] According to step 304A and step 304B, the oil pipe array and the accessory array are classified again based on the affiliation relationship on the basis of the classified data, so that the classified data is more refined.

[0116] 305. The server generates a data classification statistics table for the oil well based on the oil pipe array and the attachment array.

[0117] Among them, the data classification statistics table integrates the above-mentioned various detailed data, including useful data in crude oil well data, which is obtained based on conditional judgment, logical analysis and function application. Figure 5 , Figure 5 It is a flow chart of an oil well data processing method provided according to an embodiment of the present application, wherein first, data is searched, that is, the oil well data that needs to be processed is found, and then conditional judgment is performed on the oil well data, and the oil well data is grouped through the conditional judgment, and then logical analysis is performed to further group the oil well data, and finally useful data is obtained through function operation to obtain a data classification statistical table.

[0118] Among them, taking "Xing 77-281 Well" as an example, the data classification statistics table of the oil well is shown in Table 2 below. Referring to Table 2, the oil wells are grouped by specifications, and the total in the oil pipe array indicates the sum of the number of oil pipes in the same group in the oil pipe array and the sum of the length of oil pipes in the same group. The combination of pipe strings in the oil pipe array indicates the specifications of different components in the oil pipe, for example, "φ73mm", which means that the diameter of the oil pipe is 73 mm. In some embodiments, the specifications of other components can also be included, for example, "φ73mm+φ56mm", which means that the diameter of the oil pipe is 73 mm, and the specification of the component below the oil pipe is 56 mm.

[0119] Table 2

[0120]

[0121] The attribute values ​​of the specification, quantity, length and depth attributes in the data classification statistics table are generated based on function operations, wherein the generation process includes the following steps 305A-305D:

[0122] 305A: Based on the oil pipe data in the oil pipe array, the total number of oil pipes with the same specification and the same relative pump barrel position is obtained, and the total number is used as the number of the oil pipe array corresponding to the specification and the relative pump barrel position in the data classification statistics table.

[0123] Among them, referring to Table 2, the specification of the oil pipe is determined based on the pipe column combination form of the oil pipe in the table, and the oil pipe with this specification is divided into a group, and then based on the relative pump barrel position of the oil pipe in the same group, the oil pipe is divided into above the pump and below the pump, and the total number of oil pipes in the same group with the same relative pump barrel position is obtained based on the summation function. For example, the number of oil pipes with a specification of 73 mm and a relative pump barrel position on the pump in Table 2 is 118.

[0124] 305B: Based on the tubing data in the tubing array, the total length of the tubing with the same specification and the same relative pump barrel position is obtained, and the total length is used as the length corresponding to the specification and the relative pump barrel position relationship in the data classification statistics table.

[0125] Among them, referring to Table 2, the specification of the oil pipe is determined based on the pipe column combination form of the oil pipe in the table, and the oil pipe with this specification is divided into a group, and then based on the relative pump barrel position of the oil pipe in the same group, the oil pipe is divided into above the pump and below the pump, and the total length of the oil pipe at the same relative pump barrel position in the same group is obtained based on the summation function. For example, the length of the oil pipe with a specification of 73 mm and a relative pump barrel position on the pump in Table 2 is 1165.01 meters.

[0126] 305C: Based on the oil pipe attachment data in the attachment array, the total number of oil pipe attachments with the same name and the same specification is obtained, and the total number is used as the number corresponding to the name and specification in the data classification statistics table.

[0127] Among them, the names of the items in the attachment array are grouped. Referring to Table 2, the tubing accessories with the same name are grouped into one group, and then the tubing accessories in the same group are grouped based on the specifications. The total number of tubing accessories with the same specification in the same group is obtained based on the summation function. For example, the number of tubing accessories with the name of eye tube and the specification of 73 mm in Table 2 is 1.

[0128] 305D: Based on the tubing attachment data in the attachment array, the depth of the tubing attachment with the same name and the same specification is obtained, and the depth is used as the depth corresponding to the name and specification in the data classification statistics table.

[0129] Among them, the depth of the tubing accessories is an important indicator that affects downhole operations. They are grouped by name. Referring to Table 2, the depths of the tubing accessories in different groups are arranged in ascending order. For example, the depths of the tubing accessories in Table 2 are arranged in descending order of 1172.89, 1173.09, 1194.49 and 1224.18.

[0130] Among them, it can also be seen from Table 2 that the repair status of the tubing and tubing accessories is grouped in the form of rows in the table, which is more intuitive. At the same time, since this method realizes classification by group, the tool data with the same specification or name are grouped together, and the data with errors will be grouped separately and will not be used as a reference, eliminating data errors caused by human factors and preventing the occurrence of underground safety accidents caused by distorted data.

[0131] 306. In response to the query operation of the terminal on the oil well, the server outputs a data classification statistics table to the terminal.

[0132] The above steps 301-305 are a data processing process, which organizes the redundant oil well data into a clearly classified data classification statistical table. When the user triggers a query operation for the above oil well, the server will respond to the query operation and control the terminal to output the corresponding data classification statistical table. The output process includes at least one of the following steps 306A and 306B:

[0133] 306A: Based on the well number indicated in the query operation, search in the database where the oil well data is located, and output the data classification statistics table corresponding to the well number, the data classification statistics table including the oil pipe data before and after the repair and the oil pipe accessory data.

[0134] In some embodiments, the user triggers a query operation by inputting a well sign, and then a data classification statistics table corresponding to the well sign is retrieved from the database where the oil well data is located, and is output through a terminal for the user to view.

[0135] 306B: Based on the uphaul task identifier indicated in the query operation, search is performed in the database where the oil well data is located, and the target data in the data classification statistical table corresponding to the uphaul task corresponding to the uphaul task identifier is output, and the target data includes the oil pipe data and oil pipe accessory data after the uphaul task is executed.

[0136] In some embodiments, the user triggers a query operation by inputting a repair task identifier, and based on the repair task identifier, retrieves the target data of the repair task corresponding to the repair task identifier in the data classification statistics table, that is, after the repair task is executed, the repair status is changed to the data corresponding to the oil pipeline and oil pipeline accessories after the repair, and the target data is output through the terminal for the user to view.

[0137] Among them, this query operation makes the query results more accurate and clear, and improves the query speed.

[0138] In some embodiments, the above steps 301-306 implement the process from processing oil well data to implementing user query. Figure 6 , Figure 6 It is a flow chart of an oil well data processing method provided according to an embodiment of the present application, wherein the oil well data is first acquired, then the oil well data is analyzed and calculated to obtain a final data classification statistical table, and then the query is converted and the data classification statistical table is provided to the user as a query result, thereby improving the query efficiency of the oil well data.

[0139] The method provided in the embodiment of the present application can obtain tool data in the oil well, classify the tool data based on the repair status and the relative pump barrel position to obtain classified data, and based on the classified data, it is possible to clearly distinguish the tool data before and after the repair and the tubing data on and under the pump, and then further divide the classified data based on the automatic clustering analysis of the eigenvalues ​​to obtain an oil pipe array and an accessory array, the oil pipe array and the accessory array include the insertion depth of the downhole tools of the oil well, the oil pipe array combines multiple different types of oil pipes, and the accessory array combines multiple different types of oil pipe accessories, so that the classified data becomes concise and clear, and finally a data classification statistical table is generated based on the oil pipe array and the accessory array and stored for users to query the oil well data. When the user triggers the query operation, the data classification statistical table with clear classification is output, which effectively improves the query efficiency, eliminates data errors caused by human factors, and prevents the occurrence of downhole safety accidents caused by distorted data.

[0140] Figure 7 is a block diagram of an oil well data processing device provided according to an embodiment of the present application. The device is used to execute the steps of the above-mentioned oil well data processing method. Figure 7 , the device comprises:

[0141] The data acquisition module 701 is used to acquire oil well data of the oil well, where the oil well data includes tool data of the oil well, and the tool data is data describing the operation conditions of various tools in the oil well;

[0142] An analysis module 702 is used to analyze the tool data to obtain classification data, where the classification data is used to indicate the up-trim state and relative pump barrel position corresponding to the tool data, where the up-trim state includes before up-trim and after up-trim, and the relative pump barrel position includes pump up and pump down;

[0143] The classification module 703 is used to obtain characteristic values ​​of multiple tools based on the classification data, and to merge the classification data by item based on the characteristic values ​​of the multiple tools to obtain a tubing array and an accessory array, wherein the characteristic values ​​are used to indicate the type characteristics of the multiple tools, the tubing array includes tubing data belonging to the tubing type in the tool data, and the accessory array includes tubing accessory data belonging to the tubing accessory type in the tool data;

[0144] The generation module 704 is used to generate a data classification statistics table of the oil well based on the oil pipe array and the accessory array.

[0145] In some embodiments, the analysis module 702 includes:

[0146] The upward adjustment status acquisition unit is used to sort the operation dates of multiple tools in the tool data to form a date sequence, take the last date in the date sequence as the after-upgrade date, take the date of the previous day closest to the after-upgrade date as the before-upgrade date, and determine the upward adjustment status of the tool based on the before-upgrade date and the after-upgrade date;

[0147] The relative pump barrel position acquisition unit is used to acquire the depth parameter of the tubing data in the tool data and the pump hanging depth of the oil well, and determine the relative pump barrel position of the tubing in the tool based on the pump hanging depth of the oil well.

[0148] In some embodiments, the upward revision status acquisition unit is used to:

[0149] If the tool's operation date in the tool data is a post-update date, the tool's update status is determined to be post-update;

[0150] If the operation date of the tool in the tool data is not a post-upgrade date, the upgrade status of the tool is determined to be before the upgrade.

[0151] In some embodiments, the relative pump cylinder position acquisition unit is used to:

[0152] If the depth parameter of the tubing data in the tool data is less than the pump hanging depth of the oil well, the relative pump barrel position of the tubing in the tool is determined to be on the pump;

[0153] If the depth parameter of the tubing data in the tool data is greater than the pump hanging depth of the oil well, the relative pump barrel position of the tubing in the tool is determined to be pump down.

[0154] In some embodiments, the classification module 703 includes:

[0155] The classification unit is used to determine the affiliation between the multiple tools and the oil pipes and the affiliation between the multiple tools and the accessories based on the characteristic values ​​of the multiple tools, and obtain the oil pipe array and the accessory array based on the affiliation.

[0156] In some embodiments, the classification unit is used to:

[0157] If the characteristic value of the tool indicates that the subordinate relationship between the tool and the oil pipe is that the oil pipe contains the tool, the tool is determined to be the oil pipe array, and the oil pipe data in the tool data of the tool is added to the data of the oil pipe array;

[0158] If the characteristic value of the tool indicates that the affiliation between the tool and the tubing is that the tubing does not contain the tool, the tool is determined as an attachment array, and the tubing attachment data in the tool data of the tool is added to the data of the attachment array.

[0159] In some embodiments, the generation module 704 is used to:

[0160] Based on the tubing data in the tubing array, the total number of tubings with the same specification and the same relative pump barrel position is obtained, and the total number is used as the number of tubing arrays corresponding to the specification and relative pump barrel position in the data classification statistics table;

[0161] Based on the tubing data in the tubing array, the total length of the tubing with the same specification and the same relative pump barrel position is obtained, and the total length is used as the length corresponding to the specification and the relative pump barrel position relationship in the data classification statistical table;

[0162] Based on the oil pipe attachment data in the attachment array, the total number of oil pipe attachments with the same name and the same specification is obtained, and the total number is used as the number corresponding to the name and specification in the data classification statistics table;

[0163] Based on the tubing attachment data in the attachment array, the depth of the tubing attachment with the same name and the same specification is obtained, and the depth is used as the depth corresponding to the name and specification in the data classification statistics table.

[0164] In some embodiments, the apparatus further comprises:

[0165] The output module is used to output a data classification statistics table in response to a query operation on the oil well.

[0166] In some embodiments, the output module is used to:

[0167] Based on the well number indicated in the query operation, searching in the database where the oil well data is located, outputting a data classification statistical table of the oil well corresponding to the well number, the data classification statistical table including the oil pipe data before and after the repair and the oil pipe accessory data;

[0168] Based on the uphaul task identifier indicated in the query operation, a search is performed in the database where the oil well data is located, and target data in the data classification statistical table corresponding to the uphaul task corresponding to the uphaul task identifier is output, the target data including the oil pipe data and oil pipe accessory data after the uphaul task is executed.

[0169] It should be noted that: the oil well data processing device provided in the above embodiment only uses the division of the above functional modules as an example to illustrate when processing oil well data. In actual applications, the above functions can be assigned to different functional modules as needed, that is, the internal structure of the device is divided into different functional modules to complete all or part of the functions described above. In addition, the oil well data processing device provided in the above embodiment and the oil well data processing method embodiment belong to the same concept, and the specific implementation process is detailed in the method embodiment, which will not be repeated here.

[0170] In the embodiments of the present application, the computer device can be configured as a terminal or a server. When the computer device is configured as a terminal, the terminal can be used as the execution subject to implement the technical solution provided in the embodiments of the present application. When the computer device is configured as a server, the server can be used as the execution subject to implement the technical solution provided in the embodiments of the present application. The technical solution provided in the present application can also be implemented through interaction between the terminal and the server. The embodiments of the present application are not limited to this.

[0171] Figure 8 8 is a block diagram of a computer device 800 provided according to an embodiment of the present application. The electronic device 800 may be a portable mobile terminal, such as a smart phone, a tablet computer, an MP3 player (Moving Picture Experts Group Audio Layer III), an MP4 player (Moving Picture Experts Group Audio Layer IV), a laptop computer or a desktop computer. The electronic device 800 may also be referred to as a user device, a portable terminal, a laptop terminal, a desktop terminal or other names.

[0172] Typically, the electronic device 800 includes a processor 801 and a memory 802 .

[0173] The processor 801 may include one or more processing cores, such as a 4-core processor, an 8-core processor, etc. The processor 801 may be implemented in at least one hardware form of DSP (Digital Signal Processing), FPGA (Field-Programmable Gate Array), and PLA (Programmable Logic Array). The processor 801 may also include a main processor and a coprocessor. The main processor is a processor for processing data in the awake state, also known as a CPU (Central Processing Unit); the coprocessor is a low-power processor for processing data in the standby state. In some embodiments, the processor 801 may be integrated with a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content to be displayed on the display screen. In some embodiments, the processor 801 may also include an AI (Artificial Intelligence) processor, which is used to process computing operations related to machine learning.

[0174] The memory 802 may include one or more computer-readable storage media, which may be non-transitory. The memory 802 may also include a high-speed random access memory and a non-volatile memory, such as one or more disk storage devices, flash memory storage devices. In some embodiments, the non-transitory computer-readable storage medium in the memory 802 is used to store at least one computer program, which is used to be executed by the processor 801 to implement the oil well data processing method provided in the method embodiment of the present application.

[0175] In some embodiments, the electronic device 800 may further optionally include: a peripheral device interface 803 and at least one peripheral device. The processor 801, the memory 802 and the peripheral device interface 803 may be connected via a bus or a signal line. Each peripheral device may be connected to the peripheral device interface 803 via a bus, a signal line or a circuit board. Specifically, the peripheral device includes: at least one of a radio frequency circuit 804, a display screen 805, a camera assembly 806, an audio circuit 807 and a power supply 808.

[0176] The peripheral device interface 803 may be used to connect at least one peripheral device related to I / O (Input / Output) to the processor 801 and the memory 802. In some embodiments, the processor 801, the memory 802, and the peripheral device interface 803 are integrated on the same chip or circuit board; in some other embodiments, any one or two of the processor 801, the memory 802, and the peripheral device interface 803 may be implemented on a separate chip or circuit board, which is not limited in this embodiment.

[0177] The radio frequency circuit 804 is used to receive and transmit RF (Radio Frequency) signals, also known as electromagnetic signals. The radio frequency circuit 804 communicates with the communication network and other communication devices through electromagnetic signals. The radio frequency circuit 804 converts electrical signals into electromagnetic signals for transmission, or converts received electromagnetic signals into electrical signals. In some embodiments, the radio frequency circuit 804 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a user identity module card, and the like. The radio frequency circuit 804 can communicate with other terminals through at least one wireless communication protocol. The wireless communication protocol includes, but is not limited to: the World Wide Web, a metropolitan area network, an intranet, various generations of mobile communication networks (2G, 3G, 4G and 5G), a wireless local area network and / or a WiFi (Wireless Fidelity) network. In some embodiments, the radio frequency circuit 804 may also include circuits related to NFC (Near Field Communication), which is not limited in this application.

[0178] The display screen 805 is used to display the UI (User Interface). The UI may include graphics, text, icons, videos, and any combination thereof. When the display screen 805 is a touch display screen, the display screen 805 also has the ability to collect touch signals on the surface or above the surface of the display screen 805. The touch signal can be input to the processor 801 as a control signal for processing. At this time, the display screen 805 can also be used to provide virtual buttons and / or virtual keyboards, also known as soft buttons and / or soft keyboards. In some embodiments, the display screen 805 can be one, set on the front panel of the electronic device 800; in other embodiments, the display screen 805 can be at least two, respectively set on different surfaces of the electronic device 800 or in a folding design; in other embodiments, the display screen 805 can be a flexible display screen, set on the curved surface or folding surface of the electronic device 800. Even, the display screen 805 can also be set to a non-rectangular irregular shape, that is, a special-shaped screen. The display screen 805 can be made of materials such as LCD (Liquid Crystal Display), OLED (Organic Light-Emitting Diode, organic light-emitting diode).

[0179] The camera assembly 806 is used to capture images or videos. In some embodiments, the camera assembly 806 includes a front camera and a rear camera. Typically, the front camera is disposed on the front panel of the terminal, and the rear camera is disposed on the back of the terminal. In some embodiments, there are at least two rear cameras, which are any one of a main camera, a depth of field camera, a wide-angle camera, and a telephoto camera, so as to realize the fusion of the main camera and the depth of field camera to realize the background blur function, the fusion of the main camera and the wide-angle camera to realize panoramic shooting and VR (Virtual Reality) shooting function or other fusion shooting functions. In some embodiments, the camera assembly 806 may also include a flash. The flash may be a monochrome temperature flash or a dual-color temperature flash. A dual-color temperature flash refers to a combination of a warm light flash and a cold light flash, which can be used for light compensation at different color temperatures.

[0180] The audio circuit 807 may include a microphone and a speaker. The microphone is used to collect sound waves from the user and the environment, and convert the sound waves into electrical signals and input them into the processor 801 for processing, or input them into the radio frequency circuit 804 to achieve voice communication. For the purpose of stereo acquisition or noise reduction, there may be multiple microphones, which are respectively arranged at different parts of the electronic device 800. The microphone may also be an array microphone or an omnidirectional acquisition microphone. The speaker is used to convert the electrical signal from the processor 801 or the radio frequency circuit 804 into sound waves. The speaker may be a traditional film speaker or a piezoelectric ceramic speaker. When the speaker is a piezoelectric ceramic speaker, it can not only convert the electrical signal into sound waves audible to humans, but also convert the electrical signal into sound waves inaudible to humans for purposes such as ranging. In some embodiments, the audio circuit 807 may also include a headphone jack.

[0181] The power supply 808 is used to power various components in the electronic device 800. The power supply 808 can be an alternating current, a direct current, a disposable battery, or a rechargeable battery. When the power supply 808 includes a rechargeable battery, the rechargeable battery can be a wired rechargeable battery or a wireless rechargeable battery. A wired rechargeable battery is a battery charged through a wired line, and a wireless rechargeable battery is a battery charged through a wireless coil. The rechargeable battery can also be used to support fast charging technology.

[0182] In some embodiments, the electronic device 800 further includes one or more sensors 809 , including but not limited to: an acceleration sensor 810 , a gyroscope sensor 811 , a pressure sensor 812 , an optical sensor 813 , and a proximity sensor 814 .

[0183] The acceleration sensor 810 can detect the magnitude of acceleration on the three coordinate axes of the coordinate system established by the electronic device 800. For example, the acceleration sensor 810 can be used to detect the components of gravity acceleration on the three coordinate axes. The processor 801 can control the display screen 805 to display the user interface in a horizontal view or a vertical view according to the gravity acceleration signal collected by the acceleration sensor 810. The acceleration sensor 810 can also be used for collecting game or user motion data.

[0184] The gyro sensor 811 can detect the body direction and rotation angle of the electronic device 800, and the gyro sensor 811 can cooperate with the acceleration sensor 810 to collect the user's 3D actions on the electronic device 800. The processor 801 can implement the following functions based on the data collected by the gyro sensor 811: motion sensing (such as changing the UI according to the user's tilt operation), image stabilization during shooting, game control, and inertial navigation.

[0185] The pressure sensor 812 can be set on the side frame of the electronic device 800 and / or the lower layer of the display screen 805. When the pressure sensor 812 is set on the side frame of the electronic device 800, it can detect the user's holding signal of the electronic device 800, and the processor 801 performs left and right hand recognition or shortcut operations according to the holding signal collected by the pressure sensor 812. When the pressure sensor 812 is set on the lower layer of the display screen 805, the processor 801 controls the operability controls on the UI interface according to the user's pressure operation on the display screen 805. The operability controls include at least one of a button control, a scroll bar control, an icon control, and a menu control.

[0186] The optical sensor 813 is used to collect the ambient light intensity. In one embodiment, the processor 801 can control the display brightness of the display screen 805 according to the ambient light intensity collected by the optical sensor 813. Specifically, when the ambient light intensity is high, the display brightness of the display screen 805 is increased; when the ambient light intensity is low, the display brightness of the display screen 805 is reduced. In another embodiment, the processor 801 can also dynamically adjust the shooting parameters of the camera component 806 according to the ambient light intensity collected by the optical sensor 813.

[0187] The proximity sensor 814, also called a distance sensor, is usually disposed on the front panel of the electronic device 800. The proximity sensor 814 is used to collect the distance between the user and the front of the electronic device 800. In one embodiment, when the proximity sensor 814 detects that the distance between the user and the front of the electronic device 800 is gradually decreasing, the processor 801 controls the display screen 805 to switch from the screen-on state to the screen-off state; when the proximity sensor 814 detects that the distance between the user and the front of the electronic device 800 is gradually increasing, the processor 801 controls the display screen 805 to switch from the screen-off state to the screen-on state.

[0188] Those skilled in the art will understand that Figure 8 The structure shown in the figure does not constitute a limitation on the electronic device 800, and may include more or less components than those shown in the figure, or combine some components, or adopt a different component arrangement.

[0189] Fig. 9This is a schematic diagram of the structure of a server provided according to an embodiment of the present application. The server 900 may have relatively large differences due to different configurations or performances, and may include one or more processors (Central Processing Units, CPU) 901 and one or more memories 902, wherein the memory 902 stores at least one computer program, and the at least one computer program is loaded and executed by the processor 901 to implement the oil well data processing method provided by the above-mentioned various method embodiments. Of course, the server may also have components such as a wired or wireless network interface, a keyboard, and an input and output interface for input and output, and the server may also include other components for implementing device functions, which will not be described in detail here.

[0190] The embodiment of the present application also provides a computer-readable storage medium, in which at least one computer program is stored, and the at least one computer program is loaded and executed by the processor of the terminal to implement the operation performed by the terminal in the oil well data processing method of the above embodiment. For example, the computer-readable storage medium can be a read-only memory (ROM), a random access memory (RAM), a compact disc read-only memory (CD-ROM), a magnetic tape, a floppy disk, an optical data storage device, etc.

[0191] In some embodiments, the computer program involved in the embodiments of the present application may be deployed and executed on a computer device, or on multiple computer devices located at one location, or on multiple computer devices distributed at multiple locations and interconnected by a communication network. Multiple computer devices distributed at multiple locations and interconnected by a communication network may constitute a blockchain system.

[0192] The embodiment of the present application also provides a computer program product or a computer program, which includes a computer program code, and the computer program code is stored in a computer-readable storage medium. The processor of the terminal reads the computer program code from the computer-readable storage medium, and the processor executes the computer program code, so that the terminal executes the oil well data processing method provided in the above various optional implementations.

[0193] A person skilled in the art will understand that all or part of the steps to implement the above embodiments may be accomplished by hardware or by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a disk or an optical disk, etc.

[0194] The above description is only an optional embodiment of the present application and is not intended to limit the present application. Any modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the present application shall be included in the protection scope of the present application.

Claims

1. A method for processing oil well data, characterized in that: The method comprises: Acquire oil well data of the oil well, wherein the oil well data includes tool data of the oil well, and the tool data is data describing the operation conditions of various tools in the oil well; Analyze the tool data to obtain classification data, wherein the classification data is used to indicate the up-repair state and relative pump barrel position corresponding to the tool data, wherein the up-repair state includes before up-repair and after up-repair, and the relative pump barrel position includes pump up and pump down; Acquire characteristic values ​​of the multiple tools based on the classification data, merge the classification data by item based on the characteristic values ​​of the multiple tools to obtain a tubing array and an accessory array, wherein the characteristic values ​​are used to indicate the type characteristics of the multiple tools, the tubing array includes tubing data belonging to the tubing type in the tool data, and the accessory array includes tubing accessory data belonging to the tubing accessory type in the tool data; Based on the oil pipe array and the accessory array, a data classification statistics table of the oil well is generated.

2. The method according to claim 1, characterized in that The analyzing the tool data to obtain classified data includes: sorting the operation dates of the plurality of tools in the tool data to form a date sequence, taking the last date in the date sequence as the post-update date, taking the date of the previous day closest to the post-update date as the pre-update date, and determining the up-update status of the tool based on the pre-update date and the post-update date; The depth parameter of the tubing data in the tool data and the pump hanging depth of the oil well are obtained, and the relative pump barrel position of the tubing in the tool is determined based on the pump hanging depth of the oil well.

3. The method according to claim 2, characterized in that The determining the upward revision status of the tool based on the pre-upgrade date and the post-upgrade date includes: If the operation date of the tool in the tool data is the post-upgrade date, determining the upgrade status of the tool as post-upgrade; If the operation date of the tool in the tool data is not the post-upgrade date, the upgrade status of the tool is determined to be before upgrade.

4. The method according to claim 2, characterized in that: The step of obtaining the depth parameter of the tubing data in the tool data and the pumping depth of the oil well, and determining the relative pump barrel position of the tubing in the tool based on the pumping depth of the oil well, comprises: If the depth parameter of the tubing data in the tool data is less than the pump hanging depth of the oil well, the relative pump barrel position of the tubing in the tool is determined to be on the pump; If the depth parameter of the tubing data in the tool data is greater than the pump hanging depth of the oil well, the relative pump barrel position of the tubing in the tool is determined to be pump down.

5. The method according to claim 1, characterized in that The step of acquiring characteristic values ​​of the plurality of tools based on the classification data and merging the classification data by item based on the characteristic values ​​of the plurality of tools to obtain a tubing array and an accessory array includes: Based on the characteristic values ​​of the multiple tools, the affiliation between the multiple tools and the oil pipes and the affiliation between the multiple tools and the accessories are determined, and based on the affiliation, an array of oil pipes and an array of accessories are obtained.

6. The method according to claim 5, characterized in that The determining of the affiliation between the multiple tools and the oil pipes and the affiliation between the multiple tools and the accessories based on the characteristic values ​​of the multiple tools, and obtaining the oil pipe array and the accessory array based on the affiliation, includes: If the characteristic value of the tool indicates that the subordinate relationship between the tool and the oil pipe is that the oil pipe contains the tool, the tool is determined as an oil pipe array, and the oil pipe data in the tool data of the tool is added to the data of the oil pipe array; If the characteristic value of the tool indicates that the affiliation between the tool and the oil pipe is that the oil pipe does not contain the tool, the tool is determined as an accessory array, and the oil pipe accessory data in the tool data of the tool is added to the data of the accessory array.

7. The method according to claim 1, characterized in that The step of generating a data classification statistical table of the oil well based on the oil pipe array and the accessory array includes: Based on the oil pipe data in the oil pipe array, the total number of oil pipes with the same specification and the same relative pump barrel position is obtained, and the total number is used as the number of the oil pipe array corresponding to the specification and the relative pump barrel position in the data classification statistical table; Based on the oil pipe data in the oil pipe array, the total length of the oil pipes with the same specification and the same relative pump barrel position is obtained, and the total length is used as the length corresponding to the specification and the relative pump barrel position relationship in the data classification statistical table; Based on the oil pipe accessory data in the accessory array, the total number of oil pipe accessories with the same name and the same specification is obtained, and the total number is used as the number corresponding to the name and the specification in the data classification statistical table; Based on the oil pipe attachment data in the attachment array, the depth of the oil pipe attachment with the same name and the same specification is obtained, and the depth is used as the depth corresponding to the name and the specification in the data classification statistical table.

8. An oil well data processing device, characterized in that: The device comprises: A data acquisition module, used for acquiring oil well data of an oil well, wherein the oil well data includes tool data of the oil well, and the tool data is data describing the operation conditions of various tools in the oil well; An analysis module, used for analyzing the tool data to obtain classification data, wherein the classification data is used for indicating the up-repair state and relative pump barrel position corresponding to the tool data, wherein the up-repair state includes before up-repair and after up-repair, and the relative pump barrel position includes pump up and pump down; a classification module, used for acquiring characteristic values ​​of the multiple tools based on the classification data, merging the classification data by item based on the characteristic values ​​of the multiple tools to obtain a tubing array and an accessory array, wherein the characteristic values ​​are used to indicate the type characteristics of the multiple tools, the tubing array includes tubing data belonging to the tubing type in the tool data, and the accessory array includes tubing accessory data belonging to the tubing accessory type in the tool data; A generation module is used to generate a data classification statistics table of the oil well based on the oil pipe array and the accessory array.

9. A computer device, characterized in that: The computer device includes a processor and a memory, wherein the memory is used to store at least one computer program, and the at least one computer program is loaded by the processor and executes the oil well data processing method according to any one of claims 1 to 7.

10. A computer-readable storage medium, characterized in that: The computer-readable storage medium is used to store at least one computer program, and the at least one computer program is used to execute the oil well data processing method according to any one of claims 1 to 7.

Images