CN116682499A - Auxiliary method for drilling fluid formula design based on stratum information and well information - Google Patents

Auxiliary method for drilling fluid formula design based on stratum information and well information Download PDF

Info

Publication number
CN116682499A
CN116682499A CN202310442293.8A CN202310442293A CN116682499A CN 116682499 A CN116682499 A CN 116682499A CN 202310442293 A CN202310442293 A CN 202310442293A CN 116682499 A CN116682499 A CN 116682499A
Authority
CN
China
Prior art keywords
drilling fluid
information
well
similarity
case
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN202310442293.8A
Other languages
Chinese (zh)
Inventor
王江帅
霍炳钊
邓嵩
彭明国
闫霄鹏
左延婷
程庆峰
李朝玮
郝宏达
张怡昕
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Changzhou University
Original Assignee
Changzhou University
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Changzhou University filed Critical Changzhou University
Priority to CN202310442293.8A priority Critical patent/CN116682499A/en
Publication of CN116682499A publication Critical patent/CN116682499A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G16INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
    • G16CCOMPUTATIONAL CHEMISTRY; CHEMOINFORMATICS; COMPUTATIONAL MATERIALS SCIENCE
    • G16C20/00Chemoinformatics, i.e. ICT specially adapted for the handling of physicochemical or structural data of chemical particles, elements, compounds or mixtures
    • G16C20/10Analysis or design of chemical reactions, syntheses or processes
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F18/00Pattern recognition
    • G06F18/20Analysing
    • G06F18/22Matching criteria, e.g. proximity measures
    • GPHYSICS
    • G16INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR SPECIFIC APPLICATION FIELDS
    • G16CCOMPUTATIONAL CHEMISTRY; CHEMOINFORMATICS; COMPUTATIONAL MATERIALS SCIENCE
    • G16C20/00Chemoinformatics, i.e. ICT specially adapted for the handling of physicochemical or structural data of chemical particles, elements, compounds or mixtures
    • G16C20/70Machine learning, data mining or chemometrics
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Abstract

The application discloses an auxiliary method for drilling fluid formula design based on stratum information and well information, which comprises the following steps: collecting drilling fluid case data; constructing a database for storing drilling fluid case data and constructing a model; preprocessing case characteristic data; different weights are given to different features; defining a similarity calculation function; calculating the similarity of the features of the new case and outputting a recommendation result; modification and utilization of the recommendation results. The application has the beneficial effects that: 1. through standard arrangement of historical information, a database is constructed to store drilling fluid case data and a model is constructed, so that the efficient management of the data improves the design efficiency of the drilling fluid formula. 2. The system builds a similarity calculation function, calculates the similarity degree of the new case and the historical case, intelligently selects the optimal scheme, and outputs the recommended result, thereby greatly saving time and reducing cost.

Description

Auxiliary method for drilling fluid formula design based on stratum information and well information
Technical Field
The application relates to the technical field of drilling fluid proportioning, in particular to an auxiliary method for drilling fluid formula design based on stratum information and well information.
Background
The drilling fluid formula design is one of the most important steps of the drilling fluid engineering design, and one successful drilling fluid formula design can effectively reduce underground complex conditions and ensure efficient and safe drilling. In designing a drilling fluid formulation for a well, the following factors are typically considered: drilling into stratum and lithology, ground stress, stratum temperature, well depth, well type, well structure, etc. Drilling fluid design generally includes the following steps: (1) analyzing the geological condition. (2) selecting a drilling fluid type. (3) determining the density of the drilling fluid. (4) determining drilling fluid properties. Before drilling fluid is designed, in order to improve the design efficiency, the formula and performance index of the drilling fluid used by the drilled adjacent well are generally referred to according to information such as stratum, well design and the like, and if similar and satisfactory cases are available, the drilling fluid can be directly adopted. The data of the drilling fluid well Shi Baogao, the drilling well history report and the like summarize a great deal of complete drilling fluid information of the drilled well, wherein the information comprises stratum information, basic information data of the well (such as information of well depth, well deviation, stratum and lithology, stratum pressure coefficient and the like) and the data comprises the formula of the drilling fluid, the performance of the drilling fluid and the like. This information can be an important basis for the design of the undrilled drilling fluid. However, the lack of canonical arrangement of drilling fluid history information in a well is currently such that related case information cannot be quickly found and referenced in drilling fluid formulation. In addition, the time cost is greatly increased by artificially searching the historical cases and designing new cases. Therefore, the application collates and summarizes the historical data of the drilling fluid according to the data such as the drilling fluid well Shi Baogao, the drilling fluid report and the like, and stores the data in a database. Meanwhile, based on drilling fluid historical data, an auxiliary method for drilling fluid formula design based on stratum information and well information is provided. The method has important significance for efficiently managing historical data of the drilling fluid and improving the design efficiency of the drilling fluid.
Disclosure of Invention
This section is intended to outline some aspects of embodiments of the application and to briefly introduce some preferred embodiments. Some simplifications or omissions may be made in this section as well as in the description of the application and in the title of the application, which may not be used to limit the scope of the application.
The present application has been developed in view of the above-described and/or existing problems in drilling fluid formulation.
Therefore, the problem to be solved by the application is how to solve the problems that the lack of standard arrangement of the history information of the drilling fluid which is drilled and the manual proportioning of the drilling fluid greatly increase the time cost.
In order to solve the technical problems, the application provides the following technical scheme: an auxiliary method for drilling fluid formulation design based on stratum information and well information comprises,
collecting drilling fluid case data;
constructing a database for storing drilling fluid case data and constructing a model;
preprocessing case characteristic data;
different weights are given to different features;
defining a similarity calculation function;
calculating the similarity of the features of the new case and outputting a recommendation result;
modification and utilization of the recommendation results.
As a preferred embodiment of the method for assisting in the formulation of a drilling fluid based on formation information and well information according to the present application, the method comprises: the collecting drilling fluid case data includes,
drilling fluid well Shi Baogao, drilling engineering report;
well information: oilfield, block, well depth, wellbore size, well type;
geological information: lithology, formation pressure coefficient, formation temperature;
drilling fluid information: drilling fluid type, drilling fluid formula and main performance indexes;
the main performance indexes comprise: density, viscosity, YP value, API value, PH value, PV value;
the construction database comprises three sub-tables respectively built on the basis of MYSQL construction drilling fluid case base, wherein the three sub-tables are used for storing drilling fluid historical data.
As a preferred embodiment of the method for assisting in the formulation of a drilling fluid based on formation information and well information according to the present application, the method comprises: the storing drilling fluid case data and modeling includes,
input characteristics, specifically including formation lithology, formation pressure coefficient, formation temperature, oilfield name, block name, well type, well depth, well bore size;
the output parameters comprise a drilling fluid system, a drilling fluid formula and drilling fluid property information;
the drilling fluid information includes drilling fluid density, viscosity, YP value, API value, PH value, PV value.
As a preferred embodiment of the method for assisting in the formulation of a drilling fluid based on formation information and well information according to the present application, the method comprises: the preprocessing of case characterization data includes,
for carrying out 0-1 coding on the single-value text type characteristic, carrying out multi-value coding on the multi-value text characteristic; and carrying out data normalization processing on the numerical type features.
As a preferred embodiment of the method for assisting in the formulation of a drilling fluid based on formation information and well information according to the present application, the method comprises: said assigning different weights to different features includes,
different weights are given to text-type attributes, and the text-type attribute features comprise oil field W oilfeild Block W block Well type W type Well grade W cat Lithology W rock Satisfy W oilfeild +W block +W rock +W type +W cat =1;
The numerical attribute is given different weights, and the numerical attribute characteristics comprise formation pressure coefficient W pre Formation temperature W temp Well depth W depth Wellbore size W size Satisfy W depth +W pre +W temp +W size =1。
As a preferred embodiment of the method for assisting in the formulation of a drilling fluid based on formation information and well information according to the present application, the method comprises: the defined similarity calculation function includes,
text type similarity: when the retrieved text attribute is the same as the text attribute corresponding to the case library, the similarity is set to 1, otherwise, the similarity is set to 0, and the text type similarity calculation formula is as follows:
wherein W is i Weights representing the ith text attribute, C i And D i The text attributes of the new case and the existing case are respectively represented, and k represents the value of the text attribute;
numerical attribute similarity: and calculating the similarity degree by using Euclidean distance, wherein the numerical attribute similarity calculation formula is as follows:
wherein A and B represent new case and existing case respectivelyAttribute, n represents the number of numerical attributes, W i The weight of the ith attribute is represented, and the attribute weight sum is 1;
case total similarity = text attribute similarity + numerical attribute similarity, the formula is:
TotalSim=Sim(C i ,D i )+Sim(A,B)。
as a preferred embodiment of the method for assisting in the formulation of a drilling fluid based on formation information and well information according to the present application, the method comprises: calculating the similarity of new case features and outputting a recommendation result, wherein the calculating the similarity comprises calculating the overall similarity by utilizing the similarity calculation function according to the newly input retrieval features, matching the recommendation result with 3 cases with the highest similarity, recommending the drilling fluid type and the drilling fluid formula by taking the drilling fluid type and the drilling fluid formula of the case with the highest similarity as recommendation results, and calculating the average number of each drilling fluid performance in the 3 cases as recommendation results by taking the recommendation results of the drilling fluid performance parameters.
As a preferred embodiment of the method for assisting in the formulation of a drilling fluid based on formation information and well information according to the present application, the method comprises: modifications and uses of the recommendation result include,
when the recommendation result meets the user requirement, the recommendation result can be directly utilized, if the recommendation result does not meet the requirement, the case similarity can be referred, and the recommendation result is modified according to the actual situation.
A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method as described above when executing the computer program.
A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method as described above.
The application has the beneficial effects that:
1. through standard arrangement of historical information, a database is constructed to store drilling fluid case data and a model is constructed, so that the efficient management of the data improves the design efficiency of the drilling fluid formula.
2. The system builds a similarity calculation function, calculates the similarity degree of the new case and the historical case, intelligently selects the optimal scheme, and outputs the recommended result, thereby greatly saving time and reducing cost.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the description of the embodiments will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art. Wherein:
FIG. 1 is a flow chart of an auxiliary method for drilling fluid formulation design based on formation information and well information in example 1.
FIG. 2 is a flow chart of modeling of an auxiliary method for drilling fluid formulation design based on formation information and well information in example 1.
Detailed Description
In order that the above-recited objects, features and advantages of the present application will become more readily apparent, a more particular description of the application will be rendered by reference to specific embodiments thereof which are illustrated in the appended drawings.
In the following description, numerous specific details are set forth in order to provide a thorough understanding of the present application, but the present application may be practiced in other ways other than those described herein, and persons skilled in the art will readily appreciate that the present application is not limited to the specific embodiments disclosed below.
Further, reference herein to "one embodiment" or "an embodiment" means that a particular feature, structure, or characteristic can be included in at least one implementation of the application. The appearances of the phrase "in one embodiment" in various places in the specification are not necessarily all referring to the same embodiment, nor are separate or alternative embodiments mutually exclusive of other embodiments.
Example 1
Referring to fig. 1 and 2, a first embodiment of the present application provides an auxiliary method for drilling fluid formulation design based on formation information and well information, which comprises the following specific operation steps:
step one: and (5) data collection. Collecting basic data from drilling fluid well summary reports, drilling engineering reports, etc. to construct a drilling fluid formulation case base, one complete drilling fluid case specifically including the following information, (1) geological information: oilfield, block, lithology, formation pressure coefficient, formation temperature; (2) well information: oilfield, block, well depth, wellbore size, well type; (3) drilling fluid information: drilling fluid type, drilling fluid formulation, main performance index (drilling fluid density, viscosity, YP value, API value, PH value, PV value). The collected partial case data are shown in table (1), table (2) and table (3):
table (1) well information table
Table (2) stratum information table
Table (3) drilling fluid information table
Step two: and (5) data storage. And constructing a drilling fluid Case base based on MYSQL, and creating a database DrilingFuill_Case_DB database. In order to facilitate data management and ensure data integrity and uniformity, three forms are created respectively: 1) Well information table named well_case; adding a main key ID for the form, and setting the form as a self-increasing and long integer type; and then sequentially adding other fields, wherein the fields are as follows: oilfield, block, well depth, wellbore size, well type; 2) The stratum information table is named as formation_case; adding a main key ID for the form, and setting the form as a self-increasing and long integer type; and then sequentially adding other fields, wherein the fields are as follows: lithology, formation pressure coefficient, formation temperature; 3) The drilling fluid information table is named DralingFuild_Case; adding a main key ID for the form, and setting the form as a self-increasing and long integer type; and then sequentially adding other fields, wherein the fields are as follows: drilling fluid type, drilling fluid formulation, density, viscosity, YP value, API value, PH value, PV value. Specific setting types of each table and corresponding fields are as table (4), table (5) and table (6):
table (4): well information table
Table (5): stratum information table
Field code Field name Field type Whether or not it is a primary key Whether or not it can be empty
ID Main key ID Long integer (self-increasing) Is that Whether or not
formation_lithology Lithology of rock Text type Whether or not Whether or not
pressure_coff Formation pressure coefficient Double precision type Whether or not Whether or not
formation_temp Formation temperature Single precision type Whether or not Is that
Table (6): drilling fluid information table
Field code Field name Field type Whether or not it is a primary key Whether or not it can be empty
ID Main key ID Long integer (self-increasing) Is that Whether or not
Mud_type Drilling fluid type Text type Whether or not Is that
Mud_formulation Drilling fluid formula Text type Whether or not Whether or not
Density Density of Double precision type Whether or not Is that
Viscosity Viscosity of the mixture Single precision type Whether or not Is that
YP YP value Single precision type Whether or not Is that
API API value Single precision type Whether or not Is that
PH PH value Single precision type Whether or not Is that
Step three: and (5) constructing a model. Based on the case data of the database, a data export interface is established by using a pymysql module pymysql.connect method, and data is obtained from the database to construct a drilling fluid formula recommendation model. The input characteristics of the drilling fluid formula recommendation system disclosed by the application comprise 9 characteristics of well information and stratum information, wherein the 9 characteristics are as follows: formation lithology, formation pressure coefficient, formation temperature, oilfield name, block name, well type, well depth, well bore size. The output parameters include drilling fluid system, drilling fluid formulation, and drilling fluid property information. Model building flow chart referring to fig. 2.
Firstly, preprocessing characteristic parameters of original data, which specifically comprises:
1) And extracting the characteristics of the text type attribute. The text type attribute includes: oilfield, block, well, lithology. The "oilfield", "block", "well" and "well" are all single-valued text features, which are 0-1 coded. "lithology" is a multi-valued feature encoded as follows: if the characteristic value is one or more of the value ranges, the corresponding position is encoded as 1, and the rest bits are 0. If the "lithology" feature is "sandstone", the code is 000001, if the "sandstone, mudstone" is given, the code is 000011, if the "sandstone, mudstone, and carbonic acid rock" is given, the code is "000111", and the mapping relation of each text type feature code is as follows in table (7):
table (7) coding mapping table
Well type Encoding Well fastener Encoding Lithology of rock Encoding
Vertical well 0001 Exploratory well 01 Sandstone 000001
Horizontal well 0010 Development well 10 Mudstone 000010
Directional well 0100 Carbonate rock 000100
Large displacement well 1000 Sandstone and mudstone 000011
2) The numerical type attribute is preprocessed. The numerical features entered include: formation pressure coefficient, formation temperature, well depth, and wellbore size. To prevent some attributes from having an excessive impact on the similarity calculation, normalization processing (normalization formula is shown in (1)) is performed uniformly to map feature data of different range sizes to the same interval [0,1], and the normalization processing is implemented by using a MinMaxScale function.
X=(X-X_min)/(X_max-X_min) (1)
Wherein: x_max represents the maximum value in the feature and X_min represents the minimum value in the feature.
Step four: weights are assigned to different attributes. Different characteristics have different degrees of influence on the drilling fluid formula design, so that higher weight is given to characteristic parameters with larger influence on the drilling fluid formula design. So as to take into account the importance of the similarity calculation (each attribute weight can be customized by a user according to different geological information and well information). For the design of drilling fluid formulations, the well depth, formation pressure coefficient and formation temperature may be more important for recommendations of drilling fluid types, so they may be given higher weights,
A. the text attribute weights defined in this experiment are shown in table (8) and satisfy: w (W) oilfeild +W block +W rock +W type +W cat =1;
Table (8) text Attribute weight Table
Text attributes Oilfield oil Block block Formation lithology Well type Well fastener
Weight code W oilfeild W block W rock W type W cat
Weight value 0.1 0.1 0.5 0.1 0.1
B. The numerical attribute weights defined in this experiment are shown in table (9) and satisfy the following relationship: w (W) depth +W pre +W temp +W size =1;
Table (9) numerical attribute weight table
Numerical attributes Well depth Formation pressure coefficient Formation temperature Wellbore size
Weight code W depth W pre W temp W size
Weight value 0.25 0.5 0.1 0.15
Step five: a similarity calculation function is defined. And calculating the similarity of the attributes of different types by adopting different methods. Case total similarity = text type feature similarity + numerical type feature similarity. The method comprises the following steps:
and calculating the similarity of the text attributes. For text features such as lithology, well type, oilfield name, block name and the like, the feature similarity is valued by the following method: i.e. the similarity is set to 1 when the text properties of the new cases and the properties of the case base are the same, and to 0 when they are not the same. The overall similarity of text attributes is as in equation (2).
Wherein W is i The weight of the ith text attribute is represented, ci and Di respectively represent the text attributes of the new case and the existing case, and k represents the value of the text attribute.
And calculating the similarity of the numerical attribute. For numerical properties such as formation pressure coefficient, formation temperature, well depth, borehole size, etc., euclidean distance is used to calculate the degree of similarity. The calculation formula is shown in (3).
Wherein A and B respectively represent the attributes of the new case and the existing case, n represents the number of numerical attributes, W i The weight of the i-th attribute is represented, and the attribute weight sum is 1 is satisfied. Thus, the overall similarity of cases is as in equation (4).
TotalSim=Sim(C i ,D i )+Sim(A,B); (4)
Step six: similarity calculation and result output. And (3) calculating the similarity between each case and the retrieval condition by using the similarity function defined in the step (V) according to all the characteristic parameters of the input new cases, and matching the 3 cases with the highest similarity. And recommending the drilling fluid type and the most drilling fluid formula, wherein the drilling fluid type and the drilling fluid formula of the case with the highest similarity are used as recommended results. For recommendations of drilling fluid performance, the average drilling performance parameters for these 3 cases were calculated as recommended results. For further details, a specific test case is given below.
The method comprises the following steps: the test case is recommended drilling fluid type, formula and drilling fluid requirement for 3000m well depth of Dibei A well.
From the dibei a well formation information and well information: the Dibei A well is a pre-exploratory well on the depression of a Tarim basin reservoir vehicle, the well type is a straight well, according to the drilling engineering design, the Dibei A well is provided with two open holes at 3000m, the size of the holes is 333.4mm, the ground temperature gradient of the block is 0.027 ℃/m, and the stratum pressure coefficient of a 2584-3020m well section is predicted to be 1.09-1.13; from lithology descriptions: the sandstone section is 2550-2850 m, the estimated drilling thickness is 300m, and the lithology is mainly brown gray thick-medium thick lamellar siltstone. Based on the above information, characteristic information for designing a 3000m drilling formulation is extracted, specifically as in table (10):
table (10) test case information table
According to the weights of different attributes defined in the fourth step, calculating the total similarity between the new case and the existing case by using the similarity calculation function defined in the fifth step, and matching the 3 cases with the highest similarity. And recommending the drilling fluid type and the most drilling fluid formula, wherein the drilling fluid type and the drilling fluid formula of the case with the highest similarity are used as recommended results. For the recommendation of drilling fluid performance, the average drilling fluid density and viscosity of the 3 cases are calculated as recommendation results, and the overall similarity of the cases is output. Recommendations for recommended drilling fluid formulation designs and requirements at 3000m for dibei a well are shown in table (11).
Table (11) recommendation results Table
The actual drilling fluid formulation, performance parameters and recommended results are compared, and the comparison results are shown in table (12):
table (12) comparison of recommended results and actual conditions
Step eight: and reusing or modifying the recommended result, wherein when the recommended result is the same as the performance of the input drilling fluid or meets the requirement, the recommended result can be directly utilized, and if the recommended result does not meet the requirement, the recommended result can be modified.
Example 2
A second embodiment of the present application, which is different from the first embodiment, is: the method also comprises the step of comparing the traditional technical scheme with the method of the application to verify the actual effect of the method by comparing the test result with a scientific demonstration means.
To illustrate the advantages and auxiliary effects of the present application, specific comparative cases are given below: suppose that in designing the above-described dibei a well, drilling fluid type, formulation, performance data used in the case most closely related thereto are referenced and employed. For convenience of comparison, the performance data obtained by the conventional design method and the performance data and actual use data obtained by the method are compared as shown in table (13) (it should be noted that the method of the application refers to the most similar cases, and the average value of the first three most similar cases is taken for the performance data).
Table (13) comparison Table of traditional methods and My application methods
The table shows that the application brings unexpected technical effects, the application not only improves the design efficiency of the drilling fluid and reduces the time cost, but also ensures that the accuracy of the proportioned drilling fluid is far higher than that of the traditional method.
Example 3
One embodiment of the present application, which is different from the first two embodiments, is: the functions, if implemented in the form of software functional units and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-only memory (ROM), a random access memory (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
Logic and/or steps represented in the flowcharts or otherwise described herein, e.g., a ordered listing of executable instructions for implementing logical functions, can be embodied in any computer-readable medium for use by or in connection with an instruction execution system, apparatus, or device, such as a computer-based system, processor-containing system, or other system that can fetch the instructions from the instruction execution system, apparatus, or device and execute the instructions. For the purposes of this description, a "computer-readable medium" can be any means that can contain, store, communicate, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device.
More specific examples (a non-exhaustive list) of the computer-readable medium would include the following: an electrical connection (electronic device) having one or more wires, a portable computer diskette (magnetic device), a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber device, and a portable compact disc read-only memory (CDROM). In addition, the computer readable medium may even be paper or other suitable medium on which the program is printed, as the program may be electronically captured, via, for instance, optical scanning of the paper or other medium, then compiled, interpreted or otherwise processed in a suitable manner, if necessary, and then stored in a computer memory.
It is to be understood that portions of the present application may be implemented in hardware, software, firmware, or a combination thereof. In the above-described embodiments, the various steps or methods may be implemented in software or firmware stored in a memory and executed by a suitable instruction execution system. For example, if implemented in hardware, as in another embodiment, may be implemented using any one or combination of the following techniques, as is well known in the art: discrete logic circuits having logic gates for implementing logic functions on data signals, application specific integrated circuits having suitable combinational logic gates, programmable Gate Arrays (PGAs), field Programmable Gate Arrays (FPGAs), and the like.
It should be noted that the above embodiments are only for illustrating the technical solution of the present application and not for limiting the same, and although the present application has been described in detail with reference to the preferred embodiments, it should be understood by those skilled in the art that the technical solution of the present application may be modified or substituted without departing from the spirit and scope of the technical solution of the present application, which is intended to be covered in the scope of the claims of the present application.

Claims (10)

1. An auxiliary method for drilling fluid formula design based on stratum information and well information is characterized in that: comprising the steps of (a) a step of,
collecting drilling fluid case data;
constructing a database for storing drilling fluid case data and constructing a model;
preprocessing case characteristic data;
different weights are given to different features;
defining a similarity calculation function;
calculating the similarity of the features of the new case and outputting a recommendation result;
modification and utilization of the recommendation results.
2. The method of assisting in drilling fluid formulation design based on formation information and well information of claim 1, wherein collecting drilling fluid case data comprises,
drilling fluid well Shi Baogao, drilling engineering report;
well information: oilfield, block, well depth, wellbore size, well type;
geological information: lithology, formation pressure coefficient, formation temperature;
drilling fluid information: drilling fluid type, drilling fluid formula and main performance indexes;
the main performance indexes comprise: density, viscosity, YP value, API value, PH value, PV value;
the construction database comprises three sub-tables respectively built on the basis of MYSQL construction drilling fluid case base, wherein the three sub-tables are used for storing drilling fluid historical data.
3. The method of assisting in drilling fluid formulation design based on formation information and well information according to claim 1, wherein storing drilling fluid case data and modeling comprises,
input characteristics, specifically including formation lithology, formation pressure coefficient, formation temperature, oilfield name, block name, well type, well depth, well bore size;
the output parameters comprise a drilling fluid system, a drilling fluid formula and drilling fluid property information;
the drilling fluid information includes drilling fluid density, viscosity, YP value, API value, PH value, PV value.
4. The method of assisting in the formulation of a drilling fluid based on formation information and well information of claim 1, wherein the preprocessing of case characterization data comprises,
for carrying out 0-1 coding on the single-value text type characteristic, carrying out multi-value coding on the multi-value text characteristic; and carrying out data normalization processing on the numerical type features.
5. The method of assisting in the formulation of a drilling fluid based on formation information and well information of claim 1, wherein assigning different weights to different features comprises,
different weights are given to text-type attributes, and the text-type attribute features comprise oil field W oilfeild Block W block Well type W type Well grade W cat Lithology W rock Satisfy W oilfeild +W block +W rock +W type +W cat =1;
The numerical attribute is given different weights, and the numerical attribute characteristics comprise formation pressure coefficient W pre Formation temperature W temp Well depth W depth Wellbore size W size Satisfy W depth +W pre +W temp +W size =1。
6. The method of assisting in the formulation of a drilling fluid based on formation information and well information of claim 1, wherein the defining a similarity calculation function comprises,
text type similarity: when the retrieved text attribute is the same as the text attribute corresponding to the case library, the similarity is set to 1, otherwise, the similarity is set to 0, and the text type similarity calculation formula is as follows:
wherein W is i Weights representing the ith text attribute, C i And D i The text attributes of the new case and the existing case are respectively represented, and k represents the value of the text attribute;
numerical attribute similarity: and calculating the similarity degree by using Euclidean distance, wherein the numerical attribute similarity calculation formula is as follows:
wherein A and B respectively represent the attributes of the new case and the existing case, n represents the number of numerical attributes, W i The weight of the ith attribute is represented, and the attribute weight sum is 1;
case total similarity = text attribute similarity + numerical attribute similarity, the formula is:
TotalSim=Sim(C i ,D i )+Sim(A,B)。
7. the method of claim 1, wherein calculating the similarity of the new case features and outputting a recommendation result comprises calculating the overall similarity according to the newly input search features using the similarity calculation function, wherein the recommendation result matches the 3 cases with the highest similarity, and the recommendation of the drilling fluid type and the drilling fluid formulation uses the drilling fluid type and the drilling fluid formulation of the case with the highest similarity as the recommendation result, and the recommendation result of the drilling fluid performance parameter calculates the average of the drilling fluid performance of each of the 3 cases as the recommendation result.
8. The method of assisting in the formulation of drilling fluid based on formation and well information according to claim 1, wherein the modification and utilization of the recommended results comprises,
when the recommendation result meets the user requirement, the recommendation result can be directly utilized, if the recommendation result does not meet the requirement, the case similarity can be referred, and the recommendation result is modified according to the actual situation.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any one of claims 1 to 8 when the computer program is executed.
10. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the steps of the method of any of claims 1 to 8.
CN202310442293.8A 2023-04-23 2023-04-23 Auxiliary method for drilling fluid formula design based on stratum information and well information Pending CN116682499A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202310442293.8A CN116682499A (en) 2023-04-23 2023-04-23 Auxiliary method for drilling fluid formula design based on stratum information and well information

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202310442293.8A CN116682499A (en) 2023-04-23 2023-04-23 Auxiliary method for drilling fluid formula design based on stratum information and well information

Publications (1)

Publication Number Publication Date
CN116682499A true CN116682499A (en) 2023-09-01

Family

ID=87787977

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202310442293.8A Pending CN116682499A (en) 2023-04-23 2023-04-23 Auxiliary method for drilling fluid formula design based on stratum information and well information

Country Status (1)

Country Link
CN (1) CN116682499A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117471922A (en) * 2023-12-26 2024-01-30 合力(天津)能源科技股份有限公司 Intelligent control method and system for oil casing electric punching equipment

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN117471922A (en) * 2023-12-26 2024-01-30 合力(天津)能源科技股份有限公司 Intelligent control method and system for oil casing electric punching equipment
CN117471922B (en) * 2023-12-26 2024-03-22 合力(天津)能源科技股份有限公司 Intelligent control method and system for oil casing electric punching equipment

Similar Documents

Publication Publication Date Title
US11748644B2 (en) System and method for oil and gas predictive analytics
CN104281617A (en) Domain knowledge-based multilayer association rules mining method and system
CN111749686A (en) Drill bit rapid optimization method based on stratum drilling resistance parameters
US20210224669A1 (en) System and method for predicting hydrocarbon well production
CN116682499A (en) Auxiliary method for drilling fluid formula design based on stratum information and well information
Litvak et al. Field development optimization with subsurface uncertainties
CN107895092A (en) A kind of interwell communication quantitative evaluation method that modeling is adopted based on complex nonlinear note
Khan et al. Predictive Regression Model for Fracturing Fluid Efficiency–Design and Validation Workflow Based on Machine Learning
CN113608265A (en) Reservoir prediction method based on deep hybrid neural network
Duplyakov et al. Practical aspects of hydraulic fracturing design optimization using machine learning on field data: digital database, algorithms and planning the field tests
Lu et al. Simulation and optimization of hydraulic fracturing in shale reservoirs: A case study in the Permian Lucaogou formation, China
Huang et al. Analysis of drilling difficulty of extended-reach wells based on drilling limit theory
Kristjansson et al. Use of historic data to improve drilling efficiency: A pattern recognition method and trial results
CN112800590B (en) Grid coarsening method for machine learning-assisted two-phase flow oil reservoir random modeling
CN112282742B (en) Prediction method for shale oil high-quality reservoir
Lam Tran et al. Machine learning workflow to identify brittle, fracable and producible rock in horizontal wells using surface drilling data
CN115270959A (en) Shale lithology recognition method and device based on recursive feature elimination and fusion of random forest
Arslan et al. Practical automated detection of remaining oil in mature fields using production and geology data
Lolon et al. Augmenting Hybrid Physics-Based Multivariate Analysis with the Alternating Conditional Expectations Approach to Optimize Permian Basin Well Performance
Sharma et al. Machine Learning Based Integrated Approach to Estimate Total Organic Carbon in Shale Reservoirs–A Case Study from Duvernay Formation, Alberta Canada
Jamali et al. Positive correlation between historical oil production and well stimulation response
Wu et al. Infill Drilling Recovery Models for Carbonate Reservoirs-A Multiple Statistical, Non-Parametric Regression, and Neural Network Approach
CN116070767B (en) Drilling fluid leakage horizon prediction method based on capsule neural network
CN114046145B (en) Reservoir fluid identification and saturation determination method and device
WO2023178553A1 (en) Method for obtaining geological heterogeneity trends of a geological formation

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination