CN115049515A - Method and device for establishing sample database and plate map of oil well production increase measure - Google Patents
Method and device for establishing sample database and plate map of oil well production increase measure Download PDFInfo
- Publication number
- CN115049515A CN115049515A CN202210469984.2A CN202210469984A CN115049515A CN 115049515 A CN115049515 A CN 115049515A CN 202210469984 A CN202210469984 A CN 202210469984A CN 115049515 A CN115049515 A CN 115049515A
- Authority
- CN
- China
- Prior art keywords
- oil well
- measure
- data
- interval
- production
- 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.)
- Granted
Links
- 239000003129 oil well Substances 0.000 title claims abstract description 184
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 166
- 238000000034 method Methods 0.000 title claims abstract description 54
- 230000000638 stimulation Effects 0.000 claims abstract description 32
- 239000011159 matrix material Substances 0.000 claims description 54
- 238000012800 visualization Methods 0.000 claims description 33
- 238000010586 diagram Methods 0.000 claims description 31
- 230000000007 visual effect Effects 0.000 claims description 31
- 238000007781 pre-processing Methods 0.000 claims description 23
- 238000004590 computer program Methods 0.000 claims description 20
- 238000012545 processing Methods 0.000 claims description 17
- 238000012163 sequencing technique Methods 0.000 claims description 11
- 238000005520 cutting process Methods 0.000 claims description 8
- 238000003860 storage Methods 0.000 claims description 8
- 230000005540 biological transmission Effects 0.000 claims description 6
- 238000002407 reforming Methods 0.000 claims description 6
- 238000006243 chemical reaction Methods 0.000 claims description 5
- 238000005259 measurement Methods 0.000 claims description 4
- 238000010276 construction Methods 0.000 claims description 3
- 230000008707 rearrangement Effects 0.000 claims description 3
- 238000012360 testing method Methods 0.000 claims description 2
- 238000002203 pretreatment Methods 0.000 claims 1
- 230000000694 effects Effects 0.000 abstract description 9
- 239000013589 supplement Substances 0.000 abstract description 2
- 230000000875 corresponding effect Effects 0.000 description 86
- 239000012530 fluid Substances 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000000704 physical effect Effects 0.000 description 3
- 230000002596 correlated effect Effects 0.000 description 2
- 230000010365 information processing Effects 0.000 description 2
- 238000010801 machine learning Methods 0.000 description 2
- 238000012546 transfer Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 239000003086 colorant Substances 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000035699 permeability Effects 0.000 description 1
- 239000003208 petroleum Substances 0.000 description 1
- 239000011435 rock Substances 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/02—Agriculture; Fishing; Forestry; Mining
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/29—Geographical information databases
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing 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 a sample database and a plate map of oil well production increasing measures. The method for establishing the oil well stimulation 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 production increasing measure sample database according to the text file of the historical data and the measure data table. The invention defines the horizon switching time, delicately divides the intervals and supplements the production state, thereby realizing the interconnection of multi-source and multi-type data of different types of yield-increasing measures; the real-time update of the oil well production increasing measure sample database is realized; the implementation situation and the measure effect of the production increasing measure in the life cycle of the whole oil well in the oil field block can be conveniently, visually and comprehensively known.
Description
Technical Field
The invention relates to the field of petroleum engineering and big data, in particular to a method and a device for establishing a sample database and a plate map of oil well production increasing measures.
Background
In the production process of an oil field, measures such as pump replacement, hole filling, fracturing and the like are usually required for realizing stable storage and yield increase of an oil well, the accurate prediction of the measure effect has important significance on production management, and machine learning is an important means for accurately predicting the measure effect. In the actual data management of the oil field at present, the following problems exist: different blocks and even different wells in the same block have different data formats related to the same data information; the data is not updated timely, and the data is mainly integrated by manual arrangement; the oil field geology-fluid-production multi-type data has wide sources, various formats, dispersed information and lack of correlation, and is difficult to fuse; a block integral comprehensive information visualization scheme integrating geological information, fluid information and production information is lacked.
Disclosure of Invention
In view of the above problems, the present invention has been made to provide a method for creating a sample database for oil well stimulation measures, a method for creating a block oil well visualization plate map, and a related apparatus, which overcome or at least partially solve the above problems.
In a first aspect, an embodiment of the present invention provides a method for creating a sample database for oil well stimulation measures, 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 production increasing measure sample database according to the text file and the measure data table.
In one embodiment, after the oil well stimulation treatment sample database is established according to the text file and the treatment data table, the method further comprises the following steps:
establishing a data transmission channel between the oil well stimulation measure sample database and an oil field data system;
and when the data in the oil field data system is updated, updating the oil well stimulation treatment sample database in real time.
In one embodiment, generating an interval information table corresponding to each oil well according to the pretreatment information table of each oil well comprises:
reforming and sequencing each first measure time period in the preprocessing information table to obtain a corresponding second measure time period;
carrying out subdivision cutting processing on each first production layer section in the preprocessing information table to obtain a second production layer section;
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;
marking the production state of each second production interval and the matrix block corresponding to each second measure time period in the time interval two-dimensional matrix data diagram;
and taking the second measure time periods as indexes, retrieving 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 an interval information table according to the retrieval result.
In one embodiment, performing a rearrangement processing on each first measure time period in the pre-processing information table to obtain a corresponding second measure time period includes:
sequencing the time nodes of each first measure time period in the preprocessing information table according to the time sequence;
according to the sorted time nodes, merging the time periods with the overlap;
and deleting the invalid time nodes and reordering the valid time nodes to obtain each second measure time period formed by the reordered valid time nodes.
In one embodiment, the second measure time period is two-dimensionally correlated 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 layer section 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 period according to the membership;
and performing 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, constructing a text file of historical data according to the interval information table and the multi-source data table corresponding to each oil well includes:
and integrating and storing the information in the interval information table corresponding to each oil well and the monthly production data table, the small-layer data table and the logging data table to construct a text file of historical data.
In one embodiment, establishing a sample database of oil well stimulation treatment based on the text file and the treatment 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 monthly production data table within the measure validity period, and calling well deviation data to carry out depth measurement and vertical depth conversion if related parameters of vertical depth are involved;
generating a whole-well history yield curve, a measure sample valid period yield curve and corresponding measure label information of each well according to the measure data table and the monthly 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 production increasing measure sample database.
In a second aspect, an embodiment of the present invention provides a method for establishing a block oil well visualization plate map, including:
generating a visualized time interval two-dimensional matrix data map of each oil well according to the interval information table corresponding to each oil well;
and establishing a block oil well visualization frame and associating oil well information on the basis of the visual time interval two-dimensional matrix data map corresponding to each oil well, and establishing a block oil well visualization plate map.
In one embodiment, the building of a block oil well visualization frame and the correlation of oil well information based on a visualized time interval two-dimensional matrix data map corresponding to each oil well comprises the following steps:
and according to the geographic coordinates of each oil well, in preset map data, associating the visual time interval two-dimensional matrix data map corresponding to each oil well with the geographic coordinates, and displaying through the block oil well visual plate map.
In a third aspect, an embodiment of the present invention provides an apparatus for creating a sample database for oil well stimulation measures, 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 production increasing measure sample database according to the text file and the measure data table.
In a fourth aspect, an embodiment of the present invention provides an apparatus for establishing a block oil well visualization plate map, including:
the visualization generating module is used for generating a visualized time interval two-dimensional matrix data map of each oil well according to the interval information table corresponding to each oil well;
and the plate map building module is used for building a block oil well visual frame and associating oil well information on the basis of the visual time interval two-dimensional matrix data map corresponding to each oil well, and building a block oil well visual plate map.
In a fifth aspect, embodiments of the present invention provide a computer-readable storage medium, which stores a computer program, and when the computer program is executed by a processor, the computer program implements the method for creating a sample database of oil well stimulation measures as described above or implements the method for creating a block oil well visualization plate 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 implements 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 sample database of the oil well production increasing measures, provided by the embodiment of the invention, the section information table corresponding to each oil well is generated according to the pretreatment information table of each oil well, the text file of historical data is constructed according to the section information table and the multi-source data table corresponding to each oil well, the sample database of the oil well production increasing measures is established according to the text file of the historical data and the measure data table, the switching time of a layer position is determined, the sections are finely divided, the production state is supplemented, and the interconnection of multi-source and multi-type data of different types of production increasing measures is realized; a data transmission channel is established between the oil well production increasing measure sample database and an oil field data system, so that the real-time updating of the oil well production increasing measure sample database is realized; the method for establishing the block oil well visual plate map provided by the embodiment of the invention establishes the oil field block oil well measure comprehensive information display map, is convenient for more intuitively and comprehensively knowing the implementation situation and the measure effect of the oil well whole well life cycle production increasing measure in the oil field block, provides a case for taking accurate measures and lays a foundation for the subsequent machine learning and other work comprehensive expert experiences.
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 hereof as well as the appended drawings.
The technical solution of the present invention is further described in detail by the accompanying drawings and embodiments.
Drawings
The accompanying drawings, which are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate embodiments of the invention and together with the description serve to explain the principles of the invention and not to limit the invention. In the drawings:
FIG. 1 is a flow chart of a method for creating a sample database of oil well stimulation measures in an embodiment of the present invention;
FIG. 2 is a diagram illustrating a text file format of historical data in an embodiment of the invention;
FIG. 3 is a flowchart of a first measure period reforming sequencing process in the embodiment of the present invention;
FIG. 4 is a schematic diagram of a two-dimensional matrix data map of a time interval section according to an embodiment of the present invention;
FIG. 5 is a schematic diagram of a whole well history production curve according to an embodiment of the present invention;
FIG. 6 is a graph showing a sample life yield curve of the measures of the example of the present invention;
FIG. 7 is a flow chart of a method for establishing a block oil well visualization plate map according to an embodiment of the invention;
FIG. 8 is a schematic diagram of a block oil well visualization plate map in an embodiment of the invention;
FIG. 9 is a block diagram of the construction apparatus for creating a sample database of oil well stimulation measures in an embodiment of the present invention;
FIG. 10 is a structural block diagram of a device for establishing a block oil well visualization plate map in the embodiment of the 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 measures and ensure that the measure effect prediction model is accurate and reliable, the embodiment of the invention provides a method for establishing an oil well stimulation measure sample database, and the method comprises the following steps as shown in figure 1:
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;
and S13, establishing an oil well stimulation measure sample database according to the text file and the measure data table.
According to the method for establishing the sample database of the oil well production increasing measure, provided by the embodiment of the invention, aiming at the problem that data formats of different blocks or different wells in the same block in an oil field are inconsistent with the same data information, a unified data format standard is established for the data information such as well deviation data, well logging data, small-layer data, monthly production data and comprehensive data, so that the data information can be conveniently inquired, called and used; secondly, in order to clarify a horizon switch, finely divide intervals and supplement production states, so as to build a space-time two-dimensional frame for interconnection of multi-source multi-type data, according to the scheme, an interval information table corresponding to each oil well is generated according to a pretreatment information table of each oil well, the interval information table is shown as table 1, then according to the corresponding interval information table generated by each oil well, a text file of historical data is built by combining the multi-source data table storing the multi-type data, the text file of the historical data in the following text is abbreviated as a His (History) text file, and the format of the His text file is shown as fig. 2, so that interconnection among the multi-source multi-type data is realized; and finally, establishing an oil well production increase measure sample database according to the constructed His text file by combining all records in the measure data table and data in the monthly production data table, wherein the monthly production data table comprises parameters shown in a table 2, and the oil well production increase measure sample database comprises parameters shown in a table 3. In the present embodiment, taking perforation events as an example of stimulation measures, the pre-processing information table is created by using perforation events as indexes, and the pre-processing information table is shown in table 4.
Table 1 layer segment information table sample
| Well number | Phases | Date | Production | Production interval | 1 | Production interval 2 | Production interval 3 | Production interval 4 |
| |
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 sheet contains parameters
TABLE 3 oil well stimulation test sample database contains parameters
Table 4 example of preprocessed information table
| Number of well | Date | Production state | Perforated 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 production increase measure sample database is established, the invention can update the oil well production increase measure sample database in real time, and the specific technical scheme is as follows.
Further, after the step S13, the real-time update of the sample database of the oil well stimulation measure is realized by the following scheme:
establishing a data transmission channel between the oil well stimulation measure sample database and an oil field data system;
and when the data in the oil field data system is updated, updating the oil well stimulation treatment sample database in real time.
Firstly, a data transmission channel is established between the oil well production increasing measure sample database and an oil field data system, the data transmission channel is established based on a WebSocket protocol, a server side is allowed to actively push data to a client side by the WebSocket protocol, in the scheme, the oil field data system serves as the server side, the oil well production increasing measure sample database serves as the client side, when data in the oil field data system changes within a period of time, the changed data can be actively pushed to the oil well production increasing measure sample database, the real-time data acquisition and the real-time updating of the oil well production increasing measure sample database are achieved, and the statistics and the updating of the data are facilitated.
The following describes a specific step in step S11.
Further, in step S11, the generation of the interval information table is realized by the following scheme.
Reforming and sequencing each first measure time period in the preprocessing information table to obtain a corresponding second measure time period;
carrying out subdivision cutting processing on each first production layer section in the preprocessing information table to obtain a second production layer section;
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;
marking the production state of each second production interval and the matrix block corresponding to each second measure time period in the time interval two-dimensional matrix data diagram;
and searching the second production interval and the mark of the production state corresponding to each second measure time period in the time interval two-dimensional matrix data diagram by taking the second measure time period as an index, and generating an interval information table according to the search result.
Firstly, reforming and sequencing each first measure time period in a 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 a date field in an interval information table, each first measure time period is divided according to perforation events, each first measure time period corresponds to one perforation event, after the perforation events are used for recording information, the first measure time periods are overlapped in time, and after the reforming and sequencing processing are carried out on the first measure time periods, the obtained corresponding second measure time periods are not overlapped in time, so that the problem of unclear horizon switch is solved.
Then, carrying out subdivision cutting processing on each first production zone section in the preprocessing information table to obtain a second production zone section, wherein the first production zone section is an interval range corresponding to a perforation well section field in the preprocessing information table, and the second production zone section is an interval range after subdivision cutting, as shown in table 4, in the preprocessing information table, the first production zone sections are respectively M1-M2, M4-M6, M3-M5 and M7-M8, and are respectively perforation well sections corresponding to four perforation events, but the perforation well section division of different measures has the problem of well section staggering, for example, M4-M6 and M3-M5 have well section staggering; aiming at the problems, each first production zone in the preprocessing information table is subjected to subdivision and cutting processing, and the unit of subdivision and cutting is one well section. For the range of M1-M2 intervals, equal to the units of one subdivided cut, so no subdivided cut is needed; for the range of M4-M6 intervals, greater than one unit of subdivision cuts, so the subdivision cuts are M4-M5, M5-M6; similarly, for the range of the M3-M5 well section, the subdivision is divided into M3-M4 and M4-M5; similarly, for the range of M7-M8 intervals, the cuts need not be subdivided. By the method, subdivision and cutting processing of each first production interval in the preprocessing information table are completed, the corresponding second production interval is obtained, and the problem that well sections are staggered in perforation well section division of different measures is solved.
And then, performing two-dimensional association on each second measure time period and each second production interval respectively to generate a time interval two-dimensional matrix data map, wherein in the generated time interval two-dimensional matrix data map, the horizontal axis represents time, the vertical axis represents depth corresponding to the second measure time period, and the vertical axis represents depth corresponding to the second production interval, and different depths are different intervals.
Then, marking the production state of each second production interval in the time interval two-dimensional matrix data diagram and the matrix block corresponding to each second measure time period, in the time interval two-dimensional matrix data diagram, each second measure time period of the horizontal axis is horizontally and vertically staggered with each second production interval of the vertical axis, each matrix block is formed at each staggered position, each matrix block corresponds to a certain second production interval in a certain second measure time period range, and the production state of the matrix block is marked, for example, different values are used to represent 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 halt, 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 embodied or is 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, retrieving the second production interval corresponding to each second measure time period in the time interval two-dimensional matrix data diagram and the mark of the production state, and generating the interval information table according to the retrieval result. For example, the second measure time period used as an index is 201101-201403, the time-interval two-dimensional matrix data graph is retrieved according to the time period, the retrieved corresponding second production intervals are respectively M1-M2, M4-M5 and M5-M6, the production states of the three retrieved second production intervals are all normal production, therefore, the retrieved data are added into the fields corresponding to the interval information table, the added second production intervals M1-M2, M4-M5 and M5-M6 are respectively recorded as production interval 1, production interval 2 and production interval 3 in the interval information table, the corresponding well number and the corresponding stage are added, so that the addition of one record in the interval information table is completed, the process is repeated, and the addition of all records is completed to generate a complete interval information table.
Further, the method for performing rearrangement sequencing processing on each first measure time period in the preprocessing information table to obtain a corresponding second measure time period specifically comprises the following steps:
sequencing the time nodes of each first measure time period in the preprocessing information table according to the time sequence;
according to the sorted time nodes, merging the time periods with the overlap;
and deleting the invalid time nodes 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 preprocessing information table includes four records of the first measure time periods, each of the first measure time periods includes a start time node and an end time node, the time nodes of each of the first measure time periods are sorted according to the time sequence, the first measure time periods with overlapping time ranges are arranged from top to bottom, each of the first measure time periods corresponds to one stimulation measure, and each of the sorted first measure time periods is shown in fig. 3; then, according to each time node after sequencing, merging the time periods with overlap, for the range from the time node I to the time node II, two sections of overlapped first measure time periods exist, merging the two sections of overlapped first measure time periods, and similarly, merging the time periods with overlap in the ranges from the time node II to the time node III, from the time node III to the time node IV and from the time node IV to the time node V, wherein the time periods after merging are shown in FIG. 3; then, after the merging processing is completed, an effective time node and an ineffective time node exist, the effective time node comprises a time node from the first time node to the time node, a time node from the second time node to the time node and a time node from the fourth time node to the time node, the ineffective time node comprises a time node from the third time node to the fourth time node, therefore, the ineffective time node is deleted, the effective time node is reordered, and each second measure time period formed by the reordered effective time node is obtained, the second measure time period comprises a time period from the first time node to the second time node, a time period from the third time node to the fourth time node and a time period from the fifth time node to the sixth time node as shown in fig. 3, and each second measure time period comprises at least one yield increasing measure after merging. In this way, the obtained second measure time periods do not overlap in time, and each successive second measure time period includes at least one perforation measure taken.
Further, two-dimensionally associating the second measure time period with the second production interval to form a time interval two-dimensional matrix data map, specifically comprising the following steps:
sequentially selecting a second measure time period in the layer section 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 period according to the membership;
and performing 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 interval information table includes three second measure time periods, the second measure time periods in the interval information table are sequentially selected, then the first measure time period in the pre-processing information table is traversed according to the selected second measure time period, and the membership relationship between the selected second measure time period and the first measure time period is determined, for example, the first second measure time period 201101-, because the selected second measure time period 201101-201403 belongs to two first measure time periods 201101-201905 and 201101-201905, the first production interval corresponding to the first measure time period 201101-201905 is M1-M2, the first production interval corresponding to the second first measure time period 201101-201905 is M4-M6, the second production interval corresponding to the first production interval M1-M2 is M1-M2, the second production interval corresponding to the first production interval M4-M6 is M4-M5 and M5-M6, the second production intervals corresponding to the selected second measure time period 201101-201403 are M1-M2, M4-M5 and M5-M6; and finally, performing 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 corresponding second measure time period corresponds to the second production interval, and finally, the time interval two-dimensional matrix data diagram shown in fig. 4 is formed.
In the scheme, a 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 in the following way:
and integrating and storing the information in the interval information table corresponding to each oil well and the monthly production data table, the small-layer data table and the logging data table to construct a His text file.
Firstly, taking the date in the interval information table corresponding to each oil well as an index to acquire the information of monthly production, stage production, cumulative production and the like in a monthly production data table; then, the interval sounding in the interval information table corresponding to each oil well is taken as an index, and the production state and the serial number of the production interval of each stage in the interval information table are obtained; and acquiring information such as interpreted serial numbers, horizons and the like in the small-layer data sheet, acquiring geological information such as permeability and the like in the logging data sheet, and storing the acquired well information in a His text file to realize multi-source multi-type data interconnection.
Further, according to the His text file and the measure data table, an oil well production 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 corresponding parameter information in the His text file and the monthly production data table within the measure validity period, and calling well deviation data to perform depth measurement and vertical depth conversion if related vertical depth parameters are involved;
generating a whole-well history yield curve, a measure sample valid period yield curve and corresponding measure label information of each well according to the measure data table and the monthly 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 production increasing measure sample database.
Firstly, taking each record of the measure data table as an index, extracting corresponding information in a His text file and a monthly production data table within the range of the validity period of each measure of each well, and calling well deviation data to carry out depth measurement and vertical depth conversion if vertical depth related parameters are involved in the process of extracting data information. The main information for extracting the His text file comprises the following steps: determining the production stage of the completion date; acquiring the sequence number of the corresponding small layer; inquiring corresponding small-layer geological physical property information; and (5) measuring depth, converting vertical depth, and calculating corresponding intervals and average physical properties. The information extracted from the monthly production data table is shown in table 2. Each record in the indexed measure data table may contain a well number, a measure category, a completion date, an expiration date, and the like. The above-mentioned information extraction in the range of the effective period of each measure of each well can be interpreted as extracting only the information in the range of the effective period of each measure, for example, extracting the yield information, which includes the yield data of all months, if extracting all the yield information, the effect brought by the measure taken cannot be intuitively understood, so that only the yield information of the month in the range of the effective period of each measure is extracted to intuitively understand the measure effect brought by the measure taken.
And then generating a whole well history yield curve of each well as shown in figure 5 and a measure sample validity period yield curve as shown in figure 6 according to the data information in the measure data table and the monthly production data table, and marking corresponding measure label information in the yield curves so as to realize automatic visualization of the whole well history of each well and the yield curves in the measure sample validity periods, automatic label identification of measures and generate corresponding picture information.
And finally, adding the extracted parameter information and the picture information into each measure record of the measure data table, adding the picture information in a hyperlink mode, and finally completing the establishment of an oil well production increasing measure sample database.
The embodiment of the invention also provides a method for establishing the block oil well visual plate map, which is shown in the figure 7 and comprises the following steps:
s51, generating a visualized time interval two-dimensional matrix data map of each oil well according to the interval information table corresponding to each oil well;
s52, establishing a block oil well visualization frame and associating oil well information on the basis of the visual time interval two-dimensional matrix data map corresponding to each oil well, and establishing a block oil well visualization plate map.
Further, the step S52 is specifically implemented by:
and according to the geographic coordinates of each oil well, in preset map data, associating the visual time interval two-dimensional matrix data map corresponding to each oil well with the geographic coordinates, and displaying through the block oil well visual plate map.
Firstly, aiming at each oil well, generating a visual time interval two-dimensional matrix data graph of each oil well based on an interval information table corresponding to the oil well, wherein the horizontal axis represents time, the vertical axis represents interval sounding, and the matrix blocks corresponding to each time and interval sounding are marked with normal production, production stop and production transfer states of the oil well by using different colors and numerical values; after generating a visual time interval two-dimensional matrix data map corresponding to each oil well, retrieving geological and fluid information of the oil well in the interval depth range by taking the depth of a certain interval as an index; searching a production interval and corresponding geological fluid information, monthly production data, and information of taking measures and the effective period of the measures in the normal oil well production state of the well in a certain time period by taking the whole well as an index, and visualizing the history of the whole well, the effective period yield of the measure sample and the measure label; and searching 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, based on the block geological model, corresponding map data is preset, a block oil well visualization frame is constructed, and then according to the geographic coordinates of each oil well, in the preset map data, the geographic coordinates corresponding to each oil well are correlated with the visual time interval two-dimensional matrix data map corresponding to each oil well, the method can be used for looking up a related visual time interval two-dimensional matrix data map through the geographic coordinates corresponding to each oil well in map data, and finally displaying the contents through the block oil well visual plate map, so that the block integrated comprehensive information visual processing integrating geological information, fluid information and production information is realized, the establishment of the block oil well integrated comprehensive information visual plate map is completed, and the visualization of the integrated information and measure effects of the oil wells with different coordinates in the whole block is realized. The block oil well visualization plate map schematic diagram is established as shown in fig. 8.
Based on the same conception, the embodiment of the invention also provides a device for establishing the sample database of the oil well production increasing measure and a device for establishing the block oil well visual plate map.
An embodiment of the present invention provides an apparatus for creating a sample database for oil well stimulation measures, as shown in fig. 9, including:
the generating module 61 is used for generating an interval information table corresponding to each oil well according to the pretreatment information table of each oil well;
the building module 62 is configured to build a His text file according to the interval information table and the multi-source data table corresponding to each oil well;
and the establishing module 63 is used for establishing an oil well production increasing 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 in fig. 10 and comprises:
the visualization generating module 71 is configured to generate a visualized time interval two-dimensional matrix data map of each oil well according to the interval information table corresponding to each oil well;
and the plate map establishing module 72 is used for establishing a block oil well visualization frame and associating oil well information on the basis of the visual time interval two-dimensional matrix data map corresponding to each oil well, and establishing a block oil well visualization plate 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, then multi-source multi-type data information interconnection is carried out according to the generated interval information table by combining a monthly production data table, well logging data, a small-layer data table and a rock fluid physical property table, and a His text file is constructed; then according to data information and production data in the His text file, performing data expansion on each measure record in the measure data table, calling well deviation data to perform depth sounding vertical depth conversion if vertical depth related parameters are involved, and finally establishing an oil well production increasing measure sample database; and finally, performing visual processing on all information of each well from the beginning of production to the present in the oil well production increasing measure sample database, and establishing a block oil well visual plate map, wherein the whole data information processing process is shown in fig. 11.
Embodiments of the present invention provide a computer-readable storage medium, which stores a computer program, and when the computer program is executed by a processor, the computer program implements the method for creating a sample database for oil well stimulation measures as described above or implements the method for creating a block oil well visualization plate map as described above.
Embodiments of the present invention provide a computer program product comprising a computer program which, when executed by a processor, implements a method for creating a well stimulation measure sample database as described above or implements a method for creating a block well visualization plate map as described above.
With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.
As will be appreciated by one skilled in the art, 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, disk storage, optical storage, and the like) having computer-usable program code embodied therein.
The present invention has been 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 flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams 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 changes and modifications may be made in the present invention without departing from the spirit and scope of the invention. Thus, if such modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalents, the present invention is also intended to include such modifications and variations.
Claims (13)
1. A method for establishing a sample database of oil well stimulation measures is characterized by comprising 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 production increasing measure sample database according to the text file and the measure data table.
2. The method of claim 1, wherein after creating a well stimulation treatment sample database based on the text file and the treatment data table, further comprising:
establishing a data transmission channel between the oil well stimulation measure sample database and an oil field data system;
and when the data in the oil field data system is updated, updating the oil well stimulation treatment sample database in real time.
3. The method of claim 1, wherein generating an interval information table for each well based on the pre-treatment information table for each well comprises:
reforming and sequencing each first measure time period in the preprocessing information table to obtain a corresponding second measure time period;
carrying out subdivision cutting processing on each first production layer section in the preprocessing information table to obtain a second production layer section;
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;
marking the production state of each second production interval and the matrix block corresponding to each second measure time period in the time interval two-dimensional matrix data diagram;
and searching the second production interval and the mark of the production state corresponding to each second measure time period in the time interval two-dimensional matrix data diagram by taking the second measure time period as an index, and generating an interval information table according to the search result.
4. The method as claimed in claim 3, wherein the performing a rearrangement processing on each first measure time period in the pre-processing information table to obtain a corresponding second measure time period comprises:
sequencing the time nodes of each first measure time period in the pretreatment information table according to the time sequence;
according to the sorted time nodes, merging the time periods with the overlap;
and deleting the invalid time nodes and reordering the valid time nodes to obtain each second measure time period formed by the reordered valid time nodes.
5. The method of claim 3, wherein two-dimensionally correlating the second measure 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 layer section 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 relation between the second measure time period and the first measure time period;
determining a second production interval corresponding to the second measure time period according to the membership;
and performing 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.
6. The method of claim 1, wherein constructing a text file of historical data from the interval information table and the multi-source data table corresponding to each well comprises:
and integrating and storing the information in the interval information table corresponding to each oil well and the monthly production data table, the small-layer data table and the logging data table to construct a text file of historical data.
7. The method of claim 1, wherein creating a well stimulation treatment sample database based on the text file and the treatment data table comprises:
taking each record in the measure data table as an index, extracting corresponding parameter information in a text file of historical data and a monthly production data table within the measure validity period, and calling well deviation data to perform depth measurement and vertical depth conversion if related vertical depth parameters are involved;
generating a whole-well history yield curve, a measure sample valid period yield curve and corresponding measure label information of each well according to the measure data table and the monthly 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 production increasing measure sample database.
8. A method for establishing a block oil well visualization plate map is characterized by comprising the following steps:
generating a visual time interval two-dimensional matrix data map of each oil well according to an interval information table corresponding to each oil well;
and establishing a block oil well visualization frame and associating oil well information on the basis of the visual time interval two-dimensional matrix data map corresponding to each oil well, and establishing a block oil well visualization plate map.
9. The method of claim 8, wherein building a block well visualization framework and correlating well information based on the two-dimensional matrix data map of the visualized time interval corresponding to each well, building a block well visualization plate map, comprises:
and according to the geographic coordinates of each oil well, in preset map data, associating the visual time interval two-dimensional matrix data map corresponding to each oil well with the geographic coordinates, and displaying through the block oil well visual plate map.
10. An apparatus for creating a sample database of oil well stimulation measures, 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;
and the establishing module is used for establishing an oil well production increasing measure sample database according to the text file and the measure data table.
11. An apparatus for establishing a block oil well visual plate map, comprising:
the visualization generating module is used for generating a visualized time interval two-dimensional matrix data map of each oil well according to the interval information table corresponding to each oil well;
and the plate map building module is used for building a block oil well visual frame and associating oil well information on the basis of the visual time interval two-dimensional matrix data map corresponding to each oil well, and building a block oil well visual plate map.
12. A computer readable storage medium, wherein the computer readable storage medium stores a computer program which, when executed by a processor, implements the method of creating a well stimulation test sample database of any of claims 1 to 7 or implements the method of creating a block well visualization plate map of any of claims 8 to 9.
13. A computer program product comprising a computer program which when executed by a processor implements the method of well stimulation sample database creation of any of claims 1 to 7 or the method of block well visualization plate map creation of any of claims 8 to 9.
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 true CN115049515A (en) | 2022-09-13 |
| CN115049515B 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) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116861800A (en) * | 2023-09-04 | 2023-10-10 | 青岛理工大学 | Oil well yield increasing measure optimization and effect prediction method based on deep learning |
Citations (6)
| 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 |
-
2022
- 2022-04-28 CN CN202210469984.2A patent/CN115049515B/en active Active
Patent Citations (6)
| 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)
| Title |
|---|
| 许晓宏等: ""基于空间数据库的油藏多信息管理"", 《计算机时代》, 15 September 2014 (2014-09-15), pages 39 - 42 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116861800A (en) * | 2023-09-04 | 2023-10-10 | 青岛理工大学 | Oil well yield increasing measure optimization and effect prediction method based on deep learning |
| CN116861800B (en) * | 2023-09-04 | 2023-11-21 | 青岛理工大学 | Oil well yield increasing measure optimization and effect prediction method based on deep learning |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115049515B (en) | 2024-06-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103853820B (en) | Data processing method and data processing system | |
| US7286959B2 (en) | Drill bit performance analysis tool | |
| CN104407589B (en) | Workshop manufacturing process-oriented active sensing and anomaly analysis method of real-time production performance | |
| DE60120433T2 (en) | APPARATUS AND METHOD FOR ASSOCIATING DRILLING DATA TO THREE-DIMENSIONAL NODE MODELS | |
| US9026417B2 (en) | Iterative reservoir surveillance | |
| CN115049515B (en) | Method and device for establishing oil well yield increase measure sample database and plate map | |
| CN112347752B (en) | Autonomous drawing management method and device for industrial chain | |
| CN104424539A (en) | Maintenance information management system and method, and maintenance information display method | |
| CN109933637A (en) | A kind of flood risk Dynamic Display and analysis system | |
| CN116304152A (en) | Intelligent investigation result display system based on GIS and BIM | |
| CN117171223B (en) | Microorganism culture scheme recommendation method and system in microorganism repair process | |
| US20190195050A1 (en) | Well archive | |
| Seemann et al. | Improving resevoir management through big data technologies | |
| CN109615700A (en) | Three-dimension virtual reality tunnel monitoring system and its operating method | |
| CN114781827A (en) | Environment sample investigation cloud management method based on geographic spatial information | |
| CN101975058A (en) | Search method and device of borehole log data | |
| Su et al. | Applying Cloud Computing and Internet of Things Technologies to Develop a Hydrological and Subsidence Monitoring Platform. | |
| CN108052637B (en) | Real-time image-text monitoring method for power grid time scale measurement data access full life cycle | |
| Sukapradja et al. | Sisi nubi dashboard: Implementation of business intelligence in reservoir modelling & synthesis: Managing big data and streamline the decision making process | |
| CN114742526A (en) | Standard design process based exploration full-process informatization method and system | |
| CN110781245A (en) | Method for constructing national culture knowledge data warehouse | |
| Asrani et al. | Designing a Framework to Standardize Data Warehouse Development Process for Effective Data Warehousing Practices | |
| CN112926150B (en) | Continuous drilling layout method applied to geotechnical engineering investigation industry | |
| CN116702902B (en) | Hydrologic data map reasoning and knowledge base construction method | |
| US11352873B2 (en) | System and method to identify water management candidates at asset level |
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 |