CN115049515B - Method and device for establishing oil well yield increase measure sample database and plate map - Google Patents

Method and device for establishing oil well yield increase measure sample database and plate map Download PDF

Info

Publication number
CN115049515B
CN115049515B CN202210469984.2A CN202210469984A CN115049515B CN 115049515 B CN115049515 B CN 115049515B CN 202210469984 A CN202210469984 A CN 202210469984A CN 115049515 B CN115049515 B CN 115049515B
Authority
CN
China
Prior art keywords
interval
measure
oil well
production
data
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.)
Active
Application number
CN202210469984.2A
Other languages
Chinese (zh)
Other versions
CN115049515A (en
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.)
China University of Petroleum East China
Original Assignee
China University of Petroleum East China
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 China University of Petroleum East China filed Critical China University of Petroleum East China
Priority to CN202210469984.2A priority Critical patent/CN115049515B/en
Publication of CN115049515A publication Critical patent/CN115049515A/en
Application granted granted Critical
Publication of CN115049515B publication Critical patent/CN115049515B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/02Agriculture; Fishing; Forestry; Mining
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/29Geographical information databases
    • 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Physics & Mathematics (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Agronomy & Crop Science (AREA)
  • Life Sciences & Earth Sciences (AREA)
  • Economics (AREA)
  • General Health & Medical Sciences (AREA)
  • Human Resources & Organizations (AREA)
  • Tourism & Hospitality (AREA)
  • Marine Sciences & Fisheries (AREA)
  • Strategic Management (AREA)
  • Marketing (AREA)
  • Health & Medical Sciences (AREA)
  • General Business, Economics & Management (AREA)
  • Mining & Mineral Resources (AREA)
  • Animal Husbandry (AREA)
  • Primary Health Care (AREA)
  • Remote Sensing (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • Sampling And Sample Adjustment (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention discloses a method and a device for establishing an oil well yield increase measure sample database and a plate map. The method for establishing the oil well yield increase measure sample database comprises the following steps: generating an interval information table corresponding to each oil well according to the pretreatment information table of each oil well; constructing a text file of historical data according to the interval information table and the multi-source data table corresponding to each oil well; and establishing an oil well yield increase measure sample database according to the text file of the historical data and the measure data table. The method has the advantages that the time for switching the horizon is clear, the intervals are finely divided, the production state is supplemented, and the multi-source and multi-type data interconnection of different types of yield increasing measures is realized; realizing the real-time updating of the oil well yield increase measure sample database; the implementation condition and the effect of the whole-well life cycle yield increasing measure of the oil well in the oil field block are more intuitively and comprehensively known.

Description

Method and device for establishing oil well yield increase measure sample database and plate map
Technical Field
The invention relates to the field of petroleum engineering and big data, in particular to a method and a device for establishing an oil well yield increase measure sample database and a plate map.
Background
In the oilfield production process, in order to realize stable storage and yield increase, measures such as pump replacement, hole repair, fracturing and the like are generally needed to be adopted by an oil well, the accurate prediction of the measure effect has important significance for production management, and machine learning is an important means for accurately predicting the measure effect. At present, in the field actual data management, the following problems exist: different blocks and even different wells of the same block are inconsistent with respect to the same data format of the data information; the data is not updated timely, and the method is mainly characterized in that the integrated data are manually arranged; oilfield geology-fluid-production multi-type data has wide sources, various formats, scattered information and lack of association, and is difficult to fuse; the block integral comprehensive information visualization scheme integrating geological, fluid and production information is lacking.
Disclosure of Invention
In view of the foregoing, the present invention has been developed to provide a method for creating a database of well stimulation samples, a method for creating a block well visualization plate map, and related apparatus that overcome or at least partially solve the foregoing problems.
In a first aspect, an embodiment of the present invention provides a method for establishing a sample database of oil well stimulation measurements, including:
Generating an interval information table corresponding to each oil well according to the pretreatment information table of each oil well;
Constructing a text file of historical data according to the interval information table and the multi-source data table corresponding to each oil well;
And establishing an oil well yield increase measure sample database according to the text file and the measure data table.
In one embodiment, after establishing the oil well stimulation sample database according to the text file and the measure data table, the method further comprises:
Establishing a data transmission channel between the oil well yield increase measure sample database and an oil field data system;
The well stimulation tool sample database is updated in real-time as data in the oilfield data system is updated.
In one embodiment, generating an interval information table corresponding to each well according to the pretreatment information table of each well comprises:
Carrying out reforming sequencing treatment on each first measure time period in the pretreatment information table to obtain a corresponding second measure time period;
carrying out subdivision cutting treatment on each first production interval in the pretreatment information table to obtain a second production interval;
respectively carrying out two-dimensional association on each second measure time period and each second production layer period to generate a time layer period two-dimensional matrix data diagram;
Marking the production state of each second production interval and the matrix block corresponding to each second measure time interval in the time interval two-dimensional matrix data diagram;
And searching marks of a second production interval and a production state corresponding to each second measure time period in the time interval two-dimensional matrix data graph by taking the second measure time period as an index, and generating an interval information table according to a search result.
In one embodiment, the re-sequencing process is performed on each first measure period in the pretreatment information table to obtain a corresponding second measure period, including:
sequencing time nodes of each first measure time period in the pretreatment information table according to time sequence;
combining the time periods with overlapping time according to the time nodes after sequencing;
and deleting the invalid time node and reordering the valid time nodes to obtain each second measure time period formed by the reordered valid time nodes.
In one embodiment, the two-dimensionally associating the second measure time period with the second production interval forms a time interval two-dimensional matrix data map, comprising:
sequentially selecting a second measure time period in the interval information table;
traversing the first measure time period in the preprocessing information table according to the selected second measure time period, and determining the membership between the second measure time period and the first measure time period;
determining a second production interval corresponding to the second measure time interval according to the membership;
And carrying out two-dimensional association on the second measure time period and the corresponding second production interval to form a time interval two-dimensional matrix data diagram.
In one embodiment, the construction of the text file of the historical data according to the interval information table and the multi-source data table corresponding to each oil well comprises the following steps:
And integrating and storing the information in the interval information table, the monthly production data table, the small layer data table and the logging data table corresponding to each oil well to construct a text file of historical data.
In one embodiment, creating a well stimulation tool sample database from the text file and tool data table, comprising:
Taking each record in the measure data table as an index, extracting a text file of historical data and corresponding parameter information in the month production data table in the measure effective period, and calling well deviation data to perform depth sounding and vertical depth conversion if related parameters of vertical depth are involved;
generating a well Quan Jingjing Shi Chanliang curve, a measure sample validity period yield curve and corresponding measure label information according to the measure data table and the month production data table, and generating corresponding picture information;
And adding the parameter information and the picture information into each measure record of the measure data table, and establishing an oil well yield increase measure sample database.
In a second aspect, an embodiment of the present invention provides a method for building a block oil well visualization plate map, including:
generating a time interval two-dimensional matrix data graph of each oil well visualization according to the interval information table corresponding to each oil well;
Based on the two-dimensional matrix data map of the visual time interval corresponding to each oil well, a block oil well visual frame is established, oil well information is associated, and a block oil well visual plate map is established.
In one embodiment, based on the corresponding visualized time interval two-dimensional matrix data map of each well, a block well visualization frame is established and well information is associated, and a block well visualization plate map is established, comprising:
And according to the geographic coordinates of each oil well, correlating a visual time interval two-dimensional matrix data graph corresponding to each oil well with the geographic coordinates in preset map data, and displaying the visual plate map of each oil well through a block oil well.
In a third aspect, an embodiment of the present invention provides an apparatus for creating a database of oil well stimulation samples, including:
the generating module is used for generating an interval information table corresponding to each oil well according to the pretreatment information table of each oil well;
The construction module is used for constructing a text file of historical data according to the interval information table and the multi-source data table corresponding to each oil well;
and the establishing module is used for establishing an oil well yield increase measure sample database according to the text file and the measure data table.
In a fourth aspect, an embodiment of the present invention provides a device for building a block oil well visualization plate map, including:
The visualization generation module is used for generating a time interval two-dimensional matrix data graph of each oil well visualization according to the interval information table corresponding to each oil well;
the block map building module is used for building a block oil well visualization frame and correlating oil well information based on the visualized time interval two-dimensional matrix data map corresponding to each oil well, and building a block oil well visualization block map.
In a fifth aspect, embodiments of the present invention provide a computer readable storage medium storing a computer program which, when executed by a processor, implements a method of creating a well stimulation sample database as described above or a method of creating a block well visualization tile map as described above.
In a sixth aspect, embodiments of the present invention provide a computer program product comprising a computer program which, when executed by a processor, implements a method of creating a well stimulation sample database as described above or a method of creating a block well visualization plate map as described above.
The technical scheme provided by the embodiment of the invention has the beneficial effects that at least:
According to the method for establishing the oil well yield increase measure sample database, which is provided by the embodiment of the invention, according to the pretreatment information table of each oil well, the layer segment information table corresponding to each oil well is generated, according to the layer segment information table corresponding to each oil well and the multi-source data table, the text file of historical data is established, according to the text file of the historical data and the measure data table, the oil well yield increase measure sample database is established, the layer switching time is defined, the layer segments are finely divided, the production state is supplemented, and the multi-source multi-type data interconnection of different types of yield increase measures is realized; a data transmission channel is established between the oil well yield increase measure sample database and the oil field data system, so that the oil well yield increase measure sample database is updated in real time; the method for establishing the block oil well visualization plate map establishes an oil field block oil well measure comprehensive information display map, is convenient for more intuitively and comprehensively knowing the implementation condition and measure effect of the oil well whole well life cycle yield increase measure in the oil field block, provides a case for taking accurate measures, and lays a foundation for the comprehensive expert experience of subsequent machine learning and other works.
Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and claims thereof as well as the appended drawings.
The technical scheme of the invention is further described in detail through the drawings and the embodiments.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
FIG. 1 is a flow chart of a method of creating a database of oil well stimulation samples in an embodiment of the present invention;
FIG. 2 is a schematic diagram of a text file format of historical data according to an embodiment of the invention;
FIG. 3 is a flowchart of a first measure period reforming sequencing process according to an embodiment of the present invention;
FIG. 4 is a schematic diagram of a two-dimensional matrix data diagram of a time slice according to an embodiment of the present invention;
FIG. 5 is a schematic illustration of a full well Shi Chanliang curve in accordance with an embodiment of the present invention;
FIG. 6 is a schematic diagram of a measure sample life yield curve according to an embodiment of the present invention;
FIG. 7 is a flow chart of a method of creating a block well visualization plate map in an embodiment of the invention;
FIG. 8 is a schematic diagram of a block well visualization plate map in an embodiment of the invention;
FIG. 9 is a block diagram of a setup mechanism for a database of oil well stimulation samples in accordance with an embodiment of the present invention;
FIG. 10 is a block diagram of a device for creating a visual block map for a block well in an embodiment of the present invention;
Fig. 11 is a flowchart of a data information processing procedure in the embodiment of the present invention.
Detailed Description
Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
In order to better predict the effect of the stimulation measure and ensure that a measure effect prediction model is accurate and reliable, an embodiment of the present invention provides a method for establishing a database of oil well stimulation measure samples, as shown in fig. 1, the method includes the following steps:
S11, generating an interval information table corresponding to each oil well according to the pretreatment information table of each oil well;
s12, constructing a text file of historical data according to the interval information table and the multi-source data table corresponding to each oil well;
S13, establishing an oil well yield increase measure sample database according to the text file and the measure data table.
According to the method for establishing the oil well yield increase measure sample database, firstly, unified data format standard is established for data information such as well deviation data, logging data, small-layer data, month production data and comprehensive data aiming at the problem that data formats of different blocks or different wells of the same block in an oil field are inconsistent with respect to the same data information, so that the data information can be conveniently inquired, called and used; secondly, in order to define a horizon switch, finely divide intervals and supplement production states, a space-time two-dimensional framework is built for multi-source multi-type data interconnection, according to the scheme, an interval information table corresponding to each oil well is generated according to a preprocessing information table of each oil well, the interval information table is shown in table 1, then a multi-source data table storing multi-type data is combined according to the corresponding interval information table generated by each oil well, a text file of historical data is built, the text file of the historical data is hereinafter abbreviated as His (His) text file, his text file format is shown in fig. 2, and interconnection among the multi-source multi-type data is realized; and then according to the constructed His text file, combining each record in the measure data table and data in the monthly production data table, wherein the monthly production data table contains parameters as shown in table 2, and finally, an oil well yield increase measure sample database is established, and the oil well yield increase measure sample database contains parameters as shown in table 3. In this embodiment, taking perforation events as an example of stimulation, a pretreatment information table is created with perforation events as an index, and the pretreatment information table is shown in table 4.
Table 1 layer segment information table sample
Well number Stage(s) Date of day Production state Production interval 1 Production interval 2 Production interval 3 Production interval 4
G1 1 201101-201403 Oil well production M1-M2 M4-M5 M5-M6
G1 2 201404-201905 Oil well production M1-M2 M3-M4 M4-M5 M5-M6
G1 3 201906-202109 Oil well production M7-M8
Table 2 monthly production data table contains parameters
Table 3 oil well stimulation sample database contains parameters
Table 4 pretreatment information table sample
Well number Date of day Production state Hole-shooting well section
G1 201101-201905 Oil well production M1-M2
G1 201101-201905 Oil well production M4-M6
G1 201404-201905 Oil well production M3-M5
G1 201906-202109 Oil well production M7-M8
After the oil well yield increasing measure sample database is established, the invention can update the oil well yield increasing measure sample database in real time, and the specific technical scheme is as follows.
Further, after the step S13, the oil well stimulation measure sample database is updated in real time according to the following scheme:
Establishing a data transmission channel between the oil well yield increase measure sample database and an oil field data system;
The well stimulation tool sample database is updated in real-time as data in the oilfield data system is updated.
Firstly, a data transmission channel is established between the oil well yield increase measure sample database and the oil field data system, the data transmission channel is established based on a WebSocket protocol, and the WebSocket allows a server to actively push data to a client.
Specific steps in the above step S11 are explained below.
Further, in the step S11, the layer segment information table is generated according to the following scheme.
Carrying out reforming sequencing treatment on each first measure time period in the pretreatment information table to obtain a corresponding second measure time period;
carrying out subdivision cutting treatment on each first production interval in the pretreatment information table to obtain a second production interval;
respectively carrying out two-dimensional association on each second measure time period and each second production layer period to generate a time layer period two-dimensional matrix data diagram;
Marking the production state of each second production interval and the matrix block corresponding to each second measure time interval in the time interval two-dimensional matrix data diagram;
And searching marks of a second production interval and a production state corresponding to each second measure time period in the time interval two-dimensional matrix data graph by taking the second measure time period as an index, and generating an interval information table according to a search result.
Firstly, carrying out rearrangement sequencing processing on each first measure time period in the pretreatment information table to obtain a corresponding second measure time period, wherein the first measure time period is a time period corresponding to a date field in the pretreatment information table, the second measure time period is a time period corresponding to the date field in the layer section information table, each first measure time period is divided according to perforation events, each first measure time period corresponds to a perforation event, after information recording is carried out by the perforation events, each first measure time period has an overlapped time period, and after the rearrangement sequencing processing is carried out on each first measure time period, the obtained corresponding second measure time period has no overlapped time period in time, so that the problem of unclear position switch is solved.
Then, carrying out subdivision cutting treatment on each first production interval in the pretreatment information table to obtain a second production interval, wherein the first production interval is an interval range corresponding to a perforation interval field in the pretreatment information table, the second production interval is an interval range after subdivision cutting, as shown in table 4, in the pretreatment information table, the first production interval is M1-M2, M4-M6, M3-M5 and M7-M8 respectively and is a perforation interval corresponding to four perforation events, but the perforation interval division of different measures has the problem of interleaving of the intervals, for example, the interleaving of the perforation intervals exists between M4-M6 and M3-M5; aiming at the problems, the subdivision cutting processing is carried out on each first production layer section in the pretreatment information table, and the subdivision cutting unit is a well section. For the M1-M2 interval range, it is equal to one subdivision cut unit, so that no subdivision cut is required; for the range of the M4-M6 well section, the unit of subdivision cutting is larger than that of the unit of subdivision cutting, so that subdivision cutting is divided into M4-M5 and M5-M6; similarly, for the range of the well section of M3-M5, the well section is subdivided and cut into M3-M4 and M4-M5; similarly, for the M7-M8 interval range, no subdivision of cuts is required. By the method, subdivision cutting processing of each first production interval in the pretreatment information table is completed, corresponding second production intervals are obtained, and the problem that well sections are staggered in perforation well section division of different measures is solved.
And then, respectively carrying out two-dimensional association on each second measure time period and each second production interval to generate a time interval two-dimensional matrix data diagram, wherein in the generated time interval two-dimensional matrix data diagram, the horizontal axis represents time, the vertical axis represents depth, the second measure time period corresponds, and different depths are different intervals.
Then, marking the production state of each second production layer segment and the corresponding matrix block of each second measure time segment in the time layer segment two-dimensional matrix data diagram, wherein in the time layer segment two-dimensional matrix data diagram, each second measure time segment of the horizontal axis is staggered with each second production layer segment of the vertical axis in a transverse and longitudinal direction, each matrix block is formed at each staggered position, each matrix block corresponds to a certain second production layer segment in a certain second measure time segment range, and the production state of the matrix block is marked, for example, different values are used for representing different production states, for example, if the production state is normal production, the production state is marked as 1; if the production state is production stopping, marking the production state as 0; if the production status is a transfer, the production status is marked as-1. By the mode, the production state of each second production interval in each second measure time period is supplemented, and the problem that the production state is not reflected or incomplete is solved.
And finally, taking each second measure time period as each record corresponding to the date field in the interval information table, taking the second measure time period as an index, searching the marks of the second production interval and the production state corresponding to each second measure time period in the time interval two-dimensional matrix data diagram, and generating the interval information table according to the search result. For example, the second measure time period used as an index is 201101-201403, the two-dimensional matrix data graph of the time period is searched according to the time period, the searched corresponding second production time periods are M1-M2, M4-M5 and M5-M6 respectively, the production states of the three searched second production time periods are all normal production, therefore, the searched data are added into the fields corresponding to the time period information table, the added second production time periods M1-M2, M4-M5 and M5-M6 are recorded in the time period information table as a production time period 1, a production time period 2 and a production time period 3 respectively, and the corresponding well marks and the belonging phases are added, so that the addition of one record in the time period information table is completed, the process is repeated, and a complete time period information table is generated after the addition of all records is completed.
Further, the rearrangement ordering processing is performed on each first measure time period in the pretreatment information table to obtain a corresponding second measure time period, which specifically comprises the following steps:
sequencing time nodes of each first measure time period in the pretreatment information table according to time sequence;
combining the time periods with overlapping time according to the time nodes after sequencing;
and deleting the invalid time node and reordering the valid time nodes to obtain each second measure time period formed by the reordered valid time nodes.
As shown in table 4, the date field of the pretreatment information table includes four records of first measure time periods, each first measure time period includes a start time node and an end time node, the first measure time periods are ordered according to time nodes of each first measure time period and the time sequence, for each first measure time period with overlapping time ranges, the first measure time periods are arranged from top to bottom, each first measure time period corresponds to one yield increase measure, and each ordered first measure time period is shown in fig. 3; then, according to the time nodes after sorting, the time periods with overlapping are combined, for the range from the time node ① to the time node ②, two overlapped first measure time periods are present, the two overlapped first measure time periods are combined, and similarly, the time periods with overlapping are respectively present in the ranges from the time node ② to the time node ③, the time node ③ to the time node ④ and the time node ④ to the time node ⑤, the time periods after the combination treatment are shown in fig. 3; next, after the merging process is completed, there are valid time nodes including time node ① to time node ②, time node ② to time node ③, and time node ④ to time node ⑤, and invalid time nodes including time node ③ to time node ④, so that the invalid time nodes are deleted and reordered to obtain each second measure time period formed by the reordered valid time nodes, the second measure periods include, as shown in fig. 3, a period of time node ① to time node ②, a period of time node ③ to time node ④, and a period of time node ⑤ to time node ⑥, each of which contains at least one stimulation measure after consolidation. In the above manner, the obtained second measure periods do not overlap in time, and each successive second measure period includes at least one perforation measure taken.
Further, the second measure time period and the second production interval are subjected to two-dimensional association to form a time interval two-dimensional matrix data graph, and the method specifically comprises the following steps of:
sequentially selecting a second measure time period in the interval information table;
traversing the first measure time period in the preprocessing information table according to the selected second measure time period, and determining the membership between the second measure time period and the first measure time period;
determining a second production interval corresponding to the second measure time interval according to the membership;
And carrying out two-dimensional association on the second measure time period and the corresponding second production interval to form a time interval two-dimensional matrix data diagram.
As shown in table 1, the date field of the layer section information table includes three second measure time periods, the second measure time periods in the layer section information table are sequentially selected, then according to the selected second measure time periods, the first measure time periods in the pretreatment information table are traversed, and the membership between the selected second measure time periods and the first measure time periods is determined, for example, the first second measure time periods 201101-201403 in the layer section information table are firstly selected, then the first measure time periods in the pretreatment information table are traversed, and accordingly the selected second measure time periods 201101-201403 are determined, the first measure time periods 201101-201905 and the second first measure time periods 201101-201905 in the pretreatment information table are selected, and then according to the membership, the second production layer period corresponding to the selected second measure time periods is determined, because the selected second measure time periods 201101-201403 are in the membership of 201101-201905, the first measure time periods 201101-20113 are in the first production layer M1-20113, and the first measure M1-2015M 1-20113 are in the first production layer M1-2015M 2-M1-20113, and the first measure M1-20111-M2M 1-M2 are correspondingly selected; and finally, carrying out two-dimensional association on the second measure time period and the corresponding second production interval, wherein the horizontal axis is time, the vertical axis is depth and the second measure time period corresponds to the second production interval, and finally forming the two-dimensional matrix data diagram of the time interval shown in fig. 4.
In the above scheme, the His text file is constructed according to the interval information table and the multi-source data table corresponding to each oil well, and the method is realized by the following steps:
and integrating and storing the information in the interval information table, the monthly production data table, the small layer data table and the logging data table corresponding to each oil well to construct a His text file.
Firstly, taking the date in an interval information table corresponding to each oil well as an index, and acquiring the information such as month yield, stage yield, accumulated yield and the like in a month production data table; then taking the layer section sounding of the layer section information table corresponding to each oil well as an index to obtain the production state and the production layer section serial number of each stage in the layer section information table; and acquiring information such as an interpretation sequence number and a horizon in a small layer data table, acquiring geological information such as permeability in a logging data table, and storing the acquired well information in a His text file to realize multi-source and multi-type data interconnection.
Further, according to the His text file and the measure data table, an oil well yield increase measure sample database is established, and the method specifically comprises the following steps:
Taking each record in the measure data table as an index, extracting a His text file and corresponding parameter information in the month production data table in the measure effective period, and calling well deviation data to perform depth sounding and vertical depth conversion if related parameters of vertical depth are involved;
generating a well Quan Jingjing Shi Chanliang curve, a measure sample validity period yield curve and corresponding measure label information according to the measure data table and the month production data table, and generating corresponding picture information;
And adding the parameter information and the picture information into each measure record of the measure data table, and establishing an oil well yield increase measure sample database.
Firstly, each record of a measure data table is used as an index, corresponding information in a His text file and a monthly production data table is extracted within the range of the effective period of each measure of each well, and in the process of extracting data information, if related parameters of the vertical depth are involved, the well deviation data is called to carry out depth measurement vertical depth conversion. The main information of the His text file is extracted by the following steps: determining the production stage of the completion date; acquiring a corresponding small layer sequence number; inquiring geological property information of the corresponding small layer; and (6) measuring the depth, converting the vertical depth, and calculating the corresponding layer section and the average physical property. The information in the extracted month production data table is shown in table 2. Each record in the action data table as an index may contain the contents of the well number, action category, completion date, expiration date, and the like. The above-mentioned extraction of information within the range of each measure validity period of each well may be interpreted as extracting only information within the range of each measure validity period, for example, extracting yield information, where the yield information includes yield data of all months, and if all the yield information is extracted, the effect brought about by taking measures cannot be intuitively understood, so that only yield information of months within the range of each measure validity period is extracted, so that the effect of measures brought about by taking measures can be intuitively understood.
And then generating a curve of each well Quan Jingjing Shi Chanliang as shown in fig. 5 and a measure sample valid period yield curve as shown in fig. 6 according to the data information in the measure data table and the month production data table, marking corresponding measure label information in the yield curve so as to realize automatic visualization of each well Quan Jingjing Shi Yi and the yield curve in the measure sample valid period, automatic label identification of the measure, and generating corresponding picture information.
And finally, adding the extracted parameter information and the picture information into each measure record of the measure data table, wherein the picture information can be added in a hyperlink form, and finally, the establishment of an oil well yield increase measure sample database is completed.
The embodiment of the invention also provides a method for establishing the block oil well visualized plate map, which is shown by referring to FIG. 7 and comprises the following steps:
S51, generating a time interval two-dimensional matrix data graph of each oil well visualization according to an interval information table corresponding to each oil well;
s52, based on the visualized time interval two-dimensional matrix data diagram corresponding to each oil well, establishing a block oil well visualization frame and associating oil well information, and establishing a block oil well visualization plate map.
Further, the step S52 is specifically implemented by the following manner:
And according to the geographic coordinates of each oil well, correlating a visual time interval two-dimensional matrix data graph corresponding to each oil well with the geographic coordinates in preset map data, and displaying the visual plate map of each oil well through a block oil well.
Firstly, generating a time interval two-dimensional matrix data graph of each oil well visualization based on an interval information table corresponding to each oil well, wherein the horizontal axis represents time, the vertical axis represents interval sounding, and marking normal production, production stopping and production transferring states of the oil well by using different colors and values for matrix blocks corresponding to each time and interval sounding; after a visual time interval two-dimensional matrix data map corresponding to each oil well is generated, geological and fluid information of the depth range of the interval of the oil well can be searched by taking the whole depth of the interval as an index; searching production intervals and corresponding geological fluid information, month data, measures taken and information in the effective period of the measures in the normal oil well production state of the well by taking the whole time period as an index, and visualizing Quan Jingjing history, the effective period yield of the measure sample and the measure label; and retrieving effective information in the interval depth range of the time period of the well by taking each matrix block as an index.
Based on the generated time interval two-dimensional matrix data map of each oil well visualization, corresponding map data are preset firstly on the basis of a block geological model, a block oil well visualization frame is built, then the geographic coordinates corresponding to each oil well are correlated with the time interval two-dimensional matrix data map of the visualization corresponding to each oil well in the preset map data according to the geographic coordinates of each oil well, the correlated time interval two-dimensional matrix data map can be checked in the map data through the geographic coordinates corresponding to each oil well, finally the content is displayed through a block oil well visualization plate map, so that block overall comprehensive information visualization processing integrating geology, fluid and production information is realized, the building of a block oil well comprehensive information visualization plate map is completed, and the visualization of oil well comprehensive information and measure effects of different coordinates of a whole block is realized. The map diagram of the established block oil well visualization plate is shown in fig. 8.
Based on the same inventive concept, the embodiments of the present invention also provide a device for establishing a sample database of oil well stimulation and a device for establishing a visual block map of a block oil well, and because the principles of the problems solved by these devices are similar to the aforementioned method for establishing a sample database of oil well stimulation and the aforementioned method for establishing a visual block map of a block oil well, the implementation of these devices can refer to the implementation of the aforementioned method, and the repetition is omitted.
An embodiment of the present invention provides an apparatus for creating a database of oil well stimulation samples, as shown in fig. 9, including:
A generating module 61, configured to generate an interval information table corresponding to each oil well according to the pretreatment information table of each oil well;
The construction module 62 is configured to construct a His text file according to the interval information table and the multi-source data table corresponding to each oil well;
the establishing module 63 is used for establishing an oil well yield increase measure sample database according to the His text file and the measure data table.
The embodiment of the invention provides a device for establishing a block oil well visual plate map, which is shown by referring to fig. 10 and comprises the following steps:
The visualization generating module 71 is configured to generate a time interval two-dimensional matrix data map visualized by each oil well according to the interval information table corresponding to each oil well;
The block map building module 72 is configured to build a block oil well visualization frame and correlate oil well information based on the visualized time interval two-dimensional matrix data map corresponding to each oil well, and build a block oil well visualization block map.
According to the method, firstly, an interval information table corresponding to each oil well is generated according to the pretreatment information table of each oil well, and then multi-source multi-type data information interconnection is carried out according to the generated interval information table in combination with a month production data table, logging data, a small layer data table and a rock fluid physical property table, so that a His text file is constructed; according to the data information and the production data in the His text file, carrying out data expansion on each measure record in the measure data table, calling well deviation data to carry out depth sounding and depth hanging conversion if related parameters of the depth hanging are involved, and finally establishing an oil well yield increasing measure sample database; finally, all the information of each well in the oil well yield increasing measure sample database from the beginning of production to the present is visualized, a block oil well visualized plate map is established, and the whole data information processing process is shown in fig. 11.
The embodiment of the invention provides a computer readable storage medium, wherein the computer readable storage medium stores a computer program, and the computer program realizes the method for establishing the oil well yield increase measure sample database or the method for establishing the block oil well visualized plate map when being executed by a processor.
Embodiments of the present invention provide a computer program product comprising a computer program which when executed by a processor implements a method of building a well stimulation sample database as described above or a method of building a block well visualization plate map as described above.
The specific manner in which the various modules perform the operations in the apparatus of the above embodiments have been described in detail in connection with the embodiments of the method, and will not be described in detail herein.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, magnetic disk storage, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
It will be apparent to those skilled in the art that various modifications and variations can be made to the present invention without departing from the spirit or scope of the invention. Thus, it is intended that the present invention also include such modifications and alterations insofar as they come within the scope of the appended claims or the equivalents thereof.

Claims (12)

1. A method of creating a database of well stimulation samples, comprising:
Generating an interval information table corresponding to each oil well according to the pretreatment information table of each oil well;
Constructing a text file of historical data according to the interval information table and the multi-source data table corresponding to each oil well;
according to the text file and the measure data table, an oil well yield increase measure sample database is established;
the interval information table corresponding to each oil well is generated by the following modes:
Carrying out reforming sequencing treatment on each first measure time period in the pretreatment information table to obtain a corresponding second measure time period;
carrying out subdivision cutting treatment on each first production interval in the pretreatment information table to obtain a second production interval;
respectively carrying out two-dimensional association on each second measure time period and each second production layer period to generate a time layer period two-dimensional matrix data diagram;
Marking the production state of each second production interval and the matrix block corresponding to each second measure time interval in the time interval two-dimensional matrix data diagram;
And searching marks of a second production interval and a production state corresponding to each second measure time period in the time interval two-dimensional matrix data graph by taking the second measure time period as an index, and generating an interval information table according to a search result.
2. The method of claim 1, wherein after creating the well stimulation tool sample database based on the text file and the tool data table, further comprising:
Establishing a data transmission channel between the oil well yield increase measure sample database and an oil field data system;
The well stimulation tool sample database is updated in real-time as data in the oilfield data system is updated.
3. The method of claim 1, wherein the performing the rearrangement ordering processing on each first measure period in the pretreatment information table to obtain a corresponding second measure period comprises:
sequencing time nodes of each first measure time period in the pretreatment information table according to time sequence;
combining the time periods with overlapping time according to the time nodes after sequencing;
and deleting the invalid time node and reordering the valid time nodes to obtain each second measure time period formed by the reordered valid time nodes.
4. The method of claim 1, wherein two-dimensionally associating the second measure time period with the second production interval to form a time interval two-dimensional matrix data map, comprising:
sequentially selecting a second measure time period in the interval information table;
traversing the first measure time period in the preprocessing information table according to the selected second measure time period, and determining the membership between the second measure time period and the first measure time period;
determining a second production interval corresponding to the second measure time interval according to the membership;
And carrying out two-dimensional association on the second measure time period and the corresponding second production interval to form a time interval two-dimensional matrix data diagram.
5. The method of claim 1, wherein constructing a text file of historical data from the corresponding interval information table and the multi-source data table for each well comprises:
And integrating and storing the information in the interval information table, the monthly production data table, the small layer data table and the logging data table corresponding to each oil well to construct a text file of historical data.
6. The method of claim 1, wherein creating a well stimulation tool sample database from the text file and tool data table comprises:
Taking each record in the measure data table as an index, extracting a text file of historical data and corresponding parameter information in the month production data table in the measure effective period, and calling well deviation data to perform depth sounding and vertical depth conversion if related parameters of vertical depth are involved;
generating a well Quan Jingjing Shi Chanliang curve, a measure sample validity period yield curve and corresponding measure label information according to the measure data table and the month production data table, and generating corresponding picture information;
And adding the parameter information and the picture information into each measure record of the measure data table, and establishing an oil well yield increase measure sample database.
7. The method for establishing the block oil well visualization plate map is characterized by comprising the following steps of:
Generating a time interval two-dimensional matrix data graph of each oil well visualization according to the interval information table corresponding to each oil well; the horizontal axis of the visualized time interval two-dimensional matrix data graph represents time, the vertical axis represents interval sounding, and each matrix block corresponding to each time and interval sounding marks the normal production, production stopping and production transferring states of the oil well by using different colors and values;
Based on the two-dimensional matrix data map of the visual time interval corresponding to each oil well, establishing a block oil well visual frame and associating oil well information, and establishing a block oil well visual plate map;
the layer segment information table is generated by the following method:
Carrying out reforming sequencing treatment on each first measure time period in the pretreatment information table to obtain a corresponding second measure time period;
carrying out subdivision cutting treatment on each first production interval in the pretreatment information table to obtain a second production interval;
respectively carrying out two-dimensional association on each second measure time period and each second production layer period to generate a time layer period two-dimensional matrix data diagram;
Marking the production state of each second production interval and the matrix block corresponding to each second measure time interval in the time interval two-dimensional matrix data diagram;
And searching marks of a second production interval and a production state corresponding to each second measure time period in the time interval two-dimensional matrix data graph by taking the second measure time period as an index, and generating an interval information table according to a search result.
8. The method of claim 7, wherein creating a block well visualization framework and correlating well information based on the corresponding visualized time interval two-dimensional matrix data map for each well, creating a block well visualization plate map comprises:
And according to the geographic coordinates of each oil well, correlating a visual time interval two-dimensional matrix data graph corresponding to each oil well with the geographic coordinates in preset map data, and displaying the visual plate map of each oil well through a block oil well.
9. An apparatus for creating a database of well stimulation samples, comprising:
the generating module is used for generating an interval information table corresponding to each oil well according to the pretreatment information table of each oil well;
The construction module is used for constructing a text file of historical data according to the interval information table and the multi-source data table corresponding to each oil well;
the establishing module is used for establishing an oil well yield increase measure sample database according to the text file and the measure data table;
the interval information table corresponding to each oil well is generated by the following modes:
Carrying out reforming sequencing treatment on each first measure time period in the pretreatment information table to obtain a corresponding second measure time period;
carrying out subdivision cutting treatment on each first production interval in the pretreatment information table to obtain a second production interval;
respectively carrying out two-dimensional association on each second measure time period and each second production layer period to generate a time layer period two-dimensional matrix data diagram;
Marking the production state of each second production interval and the matrix block corresponding to each second measure time interval in the time interval two-dimensional matrix data diagram;
And searching marks of a second production interval and a production state corresponding to each second measure time period in the time interval two-dimensional matrix data graph by taking the second measure time period as an index, and generating an interval information table according to a search result.
10. The device for establishing the block oil well visualization plate map is characterized by comprising the following components:
The visualization generation module is used for generating a time interval two-dimensional matrix data graph of each oil well visualization according to the interval information table corresponding to each oil well; the horizontal axis of the visualized time interval two-dimensional matrix data graph represents time, the vertical axis represents interval sounding, and each matrix block corresponding to each time and interval sounding marks the normal production, production stopping and production transferring states of the oil well by using different colors and values;
The block map building module is used for building a block oil well visualization frame and correlating oil well information based on the visualized time interval two-dimensional matrix data map corresponding to each oil well, and building a block oil well visualization block map;
the layer segment information table is generated by the following method:
Carrying out reforming sequencing treatment on each first measure time period in the pretreatment information table to obtain a corresponding second measure time period;
carrying out subdivision cutting treatment on each first production interval in the pretreatment information table to obtain a second production interval;
respectively carrying out two-dimensional association on each second measure time period and each second production layer period to generate a time layer period two-dimensional matrix data diagram;
Marking the production state of each second production interval and the matrix block corresponding to each second measure time interval in the time interval two-dimensional matrix data diagram;
And searching marks of a second production interval and a production state corresponding to each second measure time period in the time interval two-dimensional matrix data graph by taking the second measure time period as an index, and generating an interval information table according to a search result.
11. A computer readable storage medium, characterized in that the computer readable storage medium stores a computer program which, when executed by a processor, implements a method for creating a well stimulation sample database according to any one of claims 1 to 6 or a method for creating a block well visualization tile map according to any one of claims 7 to 8.
12. A computer program product, characterized in that it comprises a computer program which, when executed by a processor, implements a method for building a database of well stimulation samples according to any one of claims 1 to 6 or a method for building a block well visualization plate map according to any one of claims 7 to 8.
CN202210469984.2A 2022-04-28 2022-04-28 Method and device for establishing oil well yield increase measure sample database and plate map Active CN115049515B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202210469984.2A CN115049515B (en) 2022-04-28 2022-04-28 Method and device for establishing oil well yield increase measure sample database and plate map

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202210469984.2A CN115049515B (en) 2022-04-28 2022-04-28 Method and device for establishing oil well yield increase measure sample database and plate map

Publications (2)

Publication Number Publication Date
CN115049515A CN115049515A (en) 2022-09-13
CN115049515B true CN115049515B (en) 2024-06-11

Family

ID=83157521

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202210469984.2A Active CN115049515B (en) 2022-04-28 2022-04-28 Method and device for establishing oil well yield increase measure sample database and plate map

Country Status (1)

Country Link
CN (1) CN115049515B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116861800B (en) * 2023-09-04 2023-11-21 青岛理工大学 Oil well yield increasing measure optimization and effect prediction method based on deep learning

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110968640A (en) * 2018-09-28 2020-04-07 北京国双科技有限公司 Oil well data processing method and device and oil well control system
CN111810118A (en) * 2020-07-06 2020-10-23 中国海洋石油集团有限公司 Method for rapidly and quantitatively evaluating improved development effect of oil well extract
CN111914014A (en) * 2020-08-17 2020-11-10 深圳市联恒星科技有限公司 Big data platform and application thereof
CN113137211A (en) * 2021-04-02 2021-07-20 常州大学 Oil well production parameter self-adaptive control method based on fuzzy comprehensive decision
CN113537585A (en) * 2021-07-09 2021-10-22 中海石油(中国)有限公司天津分公司 Oil field production increasing measure recommendation method based on random forest and gradient lifting decision tree
CN114117881A (en) * 2020-08-31 2022-03-01 中国石油化工股份有限公司 Sand production risk prediction method and system

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110968640A (en) * 2018-09-28 2020-04-07 北京国双科技有限公司 Oil well data processing method and device and oil well control system
CN111810118A (en) * 2020-07-06 2020-10-23 中国海洋石油集团有限公司 Method for rapidly and quantitatively evaluating improved development effect of oil well extract
CN111914014A (en) * 2020-08-17 2020-11-10 深圳市联恒星科技有限公司 Big data platform and application thereof
CN114117881A (en) * 2020-08-31 2022-03-01 中国石油化工股份有限公司 Sand production risk prediction method and system
CN113137211A (en) * 2021-04-02 2021-07-20 常州大学 Oil well production parameter self-adaptive control method based on fuzzy comprehensive decision
CN113537585A (en) * 2021-07-09 2021-10-22 中海石油(中国)有限公司天津分公司 Oil field production increasing measure recommendation method based on random forest and gradient lifting decision tree

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
"基于空间数据库的油藏多信息管理";许晓宏等;《计算机时代》;20140915;第39-42 页 *

Also Published As

Publication number Publication date
CN115049515A (en) 2022-09-13

Similar Documents

Publication Publication Date Title
Gong et al. Effectiveness of craft time utilization in construction projects
CN115049515B (en) Method and device for establishing oil well yield increase measure sample database and plate map
CN104424539A (en) Maintenance information management system and method, and maintenance information display method
CN109615700B (en) Three-dimensional virtual reality tunnel monitoring system and operation method thereof
CN109933637A (en) A kind of flood risk Dynamic Display and analysis system
CN116304152A (en) Intelligent investigation result display system based on GIS and BIM
CN113807685A (en) BIM-based hydraulic tunnel construction progress informatization management method
CN114781827A (en) Environment sample investigation cloud management method based on geographic spatial information
CN115774963A (en) Real-time factory environment influence assessment method and system
CN117521231A (en) Intelligent piling monitoring management method and system based on BIM and IOT
Al-Jasmi et al. Enabling Numerical Simulation and Real-Time Production Data to Monitor Waterflooding Indicators
CN111160809B (en) Pipeline survey system
Su et al. Applying Cloud Computing and Internet of Things Technologies to Develop a Hydrological and Subsidence Monitoring Platform.
CN117056284A (en) Management system for drilling achievements of water transport engineering
CN103500167B (en) A kind of graphic display system of oil field data
CN110610541A (en) BIM geological model modeling method based on database and GIS technology
Zhang et al. Monitoring and Maintenance of Highway Super‐Large Bridge Based on BIM Technology
CN107341608A (en) One kind production basic data index analysis method
CN109781130A (en) The method and apparatus that bus route is planned automatically
CN112926150B (en) Continuous drilling layout method applied to geotechnical engineering investigation industry
JP2005165988A (en) Method and system for displaying table to manage state of performance evaluation index item, and display program
CN116522877A (en) Report form making method and device for data center infrastructure
Suresh et al. Implementation of building information modelling in the UK infrastructure sector–a case study
CN117520439A (en) Urban space structure visualization method based on provincial domain traffic big data
CN117149920A (en) Multi-dimensional data physical model building method of dam operation and maintenance system and data warehouse

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
GR01 Patent grant
GR01 Patent grant