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 PDFInfo
- 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
- production
- oil well
- measure
- interval
- 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
Links
- 239000003129 oil well Substances 0.000 title claims abstract description 192
- 238000000034 method Methods 0.000 title claims abstract description 61
- 238000004519 manufacturing process Methods 0.000 claims abstract description 227
- 238000007781 pre-processing Methods 0.000 claims abstract description 34
- 239000011159 matrix material Substances 0.000 claims description 70
- 238000010586 diagram Methods 0.000 claims description 49
- 238000012800 visualization Methods 0.000 claims description 41
- 238000004590 computer program Methods 0.000 claims description 20
- 238000005520 cutting process Methods 0.000 claims description 15
- 230000000638 stimulation Effects 0.000 claims description 11
- 238000003860 storage Methods 0.000 claims description 8
- 238000012545 processing Methods 0.000 claims description 7
- 230000005540 biological transmission Effects 0.000 claims description 6
- 238000006243 chemical reaction Methods 0.000 claims description 4
- 239000003086 colorant Substances 0.000 claims description 3
- 238000010276 construction Methods 0.000 claims description 3
- 238000012163 sequencing technique Methods 0.000 claims 6
- 230000000007 visual effect Effects 0.000 claims 5
- 238000002407 reforming Methods 0.000 claims 4
- 230000008707 rearrangement Effects 0.000 claims 1
- 230000000694 effects Effects 0.000 abstract description 8
- 239000013589 supplement Substances 0.000 abstract description 3
- 230000008569 process Effects 0.000 description 14
- 238000005259 measurement Methods 0.000 description 6
- 239000012530 fluid Substances 0.000 description 5
- 239000000243 solution Substances 0.000 description 5
- 230000006870 function Effects 0.000 description 3
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 238000000605 extraction Methods 0.000 description 2
- 230000010365 information processing Effects 0.000 description 2
- 238000010801 machine learning Methods 0.000 description 2
- 230000000704 physical effect Effects 0.000 description 2
- 101001121408 Homo sapiens L-amino-acid oxidase Proteins 0.000 description 1
- 101000827703 Homo sapiens Polyphosphoinositide phosphatase Proteins 0.000 description 1
- 102100026388 L-amino-acid oxidase Human genes 0.000 description 1
- 102100023591 Polyphosphoinositide phosphatase Human genes 0.000 description 1
- 101100012902 Saccharomyces cerevisiae (strain ATCC 204508 / S288c) FIG2 gene Proteins 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001186 cumulative effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000002347 injection Methods 0.000 description 1
- 239000007924 injection Substances 0.000 description 1
- 230000010354 integration Effects 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
- 239000000047 product Substances 0.000 description 1
- 239000011435 rock Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
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)
- Human Resources & Organizations (AREA)
- Life Sciences & Earth Sciences (AREA)
- Economics (AREA)
- Tourism & Hospitality (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Animal Husbandry (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- General Business, Economics & Management (AREA)
- Mining & Mineral Resources (AREA)
- Agronomy & Crop Science (AREA)
- Marine Sciences & Fisheries (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 present invention discloses a method and device for establishing a sample database of oil well production increase measures and a plate map. The method for establishing the sample database of oil well production increase measures includes: generating a layer information table corresponding to each oil well according to the pre-processing information table of each oil well; constructing a text file of historical data according to the layer information table corresponding to each oil well and the multi-source data table; establishing a sample database of oil well production increase measures according to the text file of historical data and the measure data table. The present invention clarifies the layer switching time, divides the layer sections in detail, supplements the production status, realizes the interconnection of multi-source and multi-type data of different types of production increase measures; realizes the real-time update of the sample database of oil well production increase measures; and facilitates a more intuitive and comprehensive understanding of the implementation of production increase measures for the entire life cycle of oil wells in oilfield blocks and the effects of the measures.
Description
技术领域Technical Field
本发明涉及石油工程和大数据领域,特别涉及一种油井增产措施样本数据库、板块地图的建立方法及装置。The present invention relates to the fields of petroleum engineering and big data, and in particular to a method and device for establishing a sample database of oil well production increase measures and a plate map.
背景技术Background technique
在油田生产过程中,为实现稳储增产,通常需要油井采取换泵、补孔、压裂等措施,措施效果准确预测对生产管理具有重要意义,机器学习是准确预测措施效果的重要手段。目前在油田实际数据管理中,存在如下问题:不同区块甚至同一区块不同井关于同一数据信息数据格式不一致;数据更新不及时,主要体现在人工整理整合的数据;油田地质-流体-生产多类型数据来源广泛、格式多样、信息分散、缺少关联,而融合难;缺少集地质、流体、生产信息于一体的区块整体综合信息可视化方案。In the process of oilfield production, in order to achieve stable reserves and increased production, oil wells usually need to take measures such as pump replacement, hole filling, and fracturing. Accurate prediction of the effect of measures is of great significance to production management. Machine learning is an important means to accurately predict the effect of measures. At present, there are the following problems in the actual data management of oilfields: the data format of the same data information in different blocks or even different wells in the same block is inconsistent; data updates are not timely, mainly reflected in manually sorted and integrated data; oilfield geology-fluid-production multi-type data has a wide range of sources, diverse formats, scattered information, lack of association, and difficult integration; there is a lack of overall block comprehensive information visualization solutions that integrate geology, fluid, and production information.
发明内容Summary of the invention
鉴于上述问题,提出了本发明以便提供一种克服上述问题或者至少部分地解决上述问题的一种油井增产措施样本数据库的建立方法、区块油井可视化板块地图的建立方法及相关装置。In view of the above problems, the present invention is proposed to provide a method for establishing a sample database of oil well production increase measures, a method for establishing a block oil well visualization plate map and related devices that overcome the above problems or at least partially solve the above problems.
第一方面,本发明实施例提供一种油井增产措施样本数据库的建立方法,包括:In a first aspect, an embodiment of the present invention provides a method for establishing a sample database of oil well production stimulation measures, comprising:
根据每口油井的预处理信息表,生成每口油井对应的层段信息表;Generate a layer information table corresponding to each oil well according to the pre-processing information table of each oil well;
根据所述每口油井对应的层段信息表以及多源数据表,构建历史数据的文本文件;Constructing a text file of historical data according to the layer information table corresponding to each oil well and the multi-source data table;
根据所述文本文件以及措施数据表,建立油井增产措施样本数据库。A sample database of oil well production increase measures is established based on the text file and the measures data table.
在一个实施例中,根据所述文本文件以及措施数据表,建立油井增产措施样本数据库之后,还包括:In one embodiment, after establishing the oil well production increase measure sample database according to the text file and the measure data table, the method further includes:
在所述油井增产措施样本数据库与油田数据系统之间建立数据传输通道;Establishing a data transmission channel between the oil well production enhancement measure sample database and the oilfield data system;
当油田数据系统中的数据被更新时,实时更新油井增产措施样本数据库。When the data in the oilfield data system is updated, the oil well production increase measure sample database is updated in real time.
在一个实施例中,根据每口油井的预处理信息表,生成每口油井对应的层段信息表,包括:In one embodiment, based on the pre-processing information table of each oil well, a layer section information table corresponding to each oil well is generated, including:
对预处理信息表中的各第一措施时间段进行重整排序处理,获得对应的第二措施时间段;Rearrange and sort each first measure time period in the pre-processing information table to obtain a corresponding second measure time period;
对预处理信息表中的各第一生产层段进行细分切割处理,获得第二生产层段;Subdividing and cutting each first production layer segment in the pre-processing information table to obtain a second production layer segment;
将各所述第二措施时间段与各所述第二生产层段分别进行二维关联,生成时间层段二维矩阵数据图;Two-dimensionally associate each of the second measure time periods with each of the second production layer sections to generate a two-dimensional matrix data diagram of the time layer section;
对所述时间层段二维矩阵数据图中的每个第二生产层段和每个第二措施时间段对应的矩阵块的生产状态进行标记;Marking the production status of the matrix blocks corresponding to each second production layer segment and each second measure time period in the two-dimensional matrix data diagram of the time layer segment;
以第二措施时间段为索引,对所述时间层段二维矩阵数据图中与每个第二措施时间段对应的第二生产层段和生产状态的标记进行检索,根据检索结果生成层段信息表。Using the second measure time period as an index, the second production layer segment and the production status mark corresponding to each second measure time period in the time layer segment two-dimensional matrix data diagram are retrieved, and a layer segment information table is generated according to the retrieval result.
在一个实施例中,对预处理信息表中的各第一措施时间段进行重整排序处理,获得对应的第二措施时间段,包括:In one embodiment, reordering and sorting each first measure time period in the preprocessing information table to obtain the corresponding second measure time period includes:
对所述预处理信息表中的各第一措施时间段的时间节点,按照时间先后顺序进行排序;Sorting the time nodes of each first measure time period in the pre-processing information table in chronological order;
根据排序后的各时间节点,对存在重叠的时间段进行合并处理;According to the sorted time nodes, the overlapping time periods are merged;
删除无效时间节点并对有效时间节点重新排序,获得重新排序后有效时间节点形成的各第二措施时间段。Invalid time nodes are deleted and valid time nodes are reordered to obtain second measure time periods formed by the reordered valid time nodes.
在一个实施例中,将所述第二措施时间段与所述第二生产层段进行二维关联,构成时间层段二维矩阵数据图,包括:In one embodiment, the second measure time period is two-dimensionally associated with the second production layer segment to form a time layer segment two-dimensional matrix data diagram, including:
依次选取层段信息表中的第二措施时间段;Select the second measure time period in the layer section information table in sequence;
根据所述选取的第二措施时间段,遍历所述预处理信息表中的第一措施时间段,确定第二措施时间段与第一措施时间段之间的隶属关系;According to the selected second measure time period, traverse the first measure time period in the pre-processing information table to determine the subordinate relationship between the second measure time period and the first measure time period;
根据所述隶属关系,确定所述第二措施时间段对应的第二生产层段;Determining, according to the affiliation, a second production layer section corresponding to the second measure time period;
将所述第二措施时间段与所述对应的第二生产层段进行二维关联,构成时间层段二维矩阵数据图。The second measure time period is two-dimensionally associated with the corresponding second production layer segment to form a two-dimensional matrix data diagram of the time layer segment.
在一个实施例中,根据所述每口油井对应的层段信息表以及多源数据表,构建历史数据的文本文件,包括:In one embodiment, a text file of historical data is constructed based on the layer information table corresponding to each oil well and the multi-source data table, including:
将所述每口油井对应的层段信息表以及月度生产数据表、小层数据表、测井数据表中的信息进行整合存储,构建出历史数据的文本文件。The information in the layer information table corresponding to each oil well, as well as the monthly production data table, the small layer data table, and the logging data table are integrated and stored to construct a text file of historical data.
在一个实施例中,根据所述文本文件以及措施数据表,建立油井增产措施样本数据库,包括:In one embodiment, a sample database of oil well production increase measures is established based on the text file and the measure data table, including:
以措施数据表中各条记录为索引,提取历史数据的文本文件和月度生产数据表中在措施有效期内对应的参数信息,若涉及到垂深相关参数则调用井斜数据进行测深垂深转换;Using each record in the measure data table as an index, extract the corresponding parameter information in the text file of historical data and the monthly production data table within the validity period of the measure. If vertical depth related parameters are involved, call the well deviation data to convert the sounding vertical depth.
根据措施数据表和月度生产数据表,生成各井全井井史产量曲线、措施样本有效期产量曲线以及对应的措施标签信息,并生成对应的图片信息;According to the measure data table and monthly production data table, generate the production curve of the entire well history of each well, the production curve of the effective period of the measure sample and the corresponding measure label information, and generate the corresponding picture information;
将所述参数信息和所述图片信息添加到所述措施数据表的每条措施记录中,建立油井增产措施样本数据库。The parameter information and the image information are added to each measure record in the measure data table to establish a sample database of oil well production increase measures.
第二方面,本发明实施例提供一种区块油井可视化板块地图的建立方法,包括:In a second aspect, an embodiment of the present invention provides a method for establishing a block oil well visualization plate map, comprising:
根据每口油井对应的层段信息表,生成每口油井可视化的时间层段二维矩阵数据图;According to the layer information table corresponding to each oil well, a visualized two-dimensional matrix data diagram of the time layer of each oil well is generated;
以每口油井对应的可视化的时间层段二维矩阵数据图为基础,建立区块油井可视化框架并关联油井信息,建立区块油井可视化板块地图。Based on the visualized two-dimensional matrix data diagram of time segments corresponding to each oil well, a visualization framework for block oil wells is established and the oil well information is associated to create a visualization plate map for block oil wells.
在一个实施例中,以每口油井对应的可视化的时间层段二维矩阵数据图为基础,建立区块油井可视化框架并关联油井信息,建立区块油井可视化板块地图,包括:In one embodiment, based on the visualized two-dimensional matrix data graph of time segments corresponding to each oil well, a visualization framework for block oil wells is established and the oil well information is associated to establish a visualization plate map for block oil wells, including:
根据每口油井的地理坐标,在预设的地图数据中,将每口油井对应的可视化的时间层段二维矩阵数据图与所述地理坐标进行关联,并通过区块油井可视化板块地图展示。According to the geographic coordinates of each oil well, in the preset map data, the visualized time layer two-dimensional matrix data diagram corresponding to each oil well is associated with the geographic coordinates and displayed through the block oil well visualization plate map.
第三方面,本发明实施例提供一种油井增产措施样本数据库的建立装置,包括:In a third aspect, an embodiment of the present invention provides a device for establishing a sample database of oil well production stimulation measures, comprising:
生成模块,用于根据每口油井的预处理信息表,生成每口油井对应的层段信息表;A generation module, used for generating a layer section information table corresponding to each oil well according to the pre-processing information table of each oil well;
构建模块,用于根据所述每口油井对应的层段信息表以及多源数据表,构建历史数据的文本文件;A construction module, used to construct a text file of historical data according to the layer information table corresponding to each oil well and the multi-source data table;
建立模块,用于根据所述文本文件以及措施数据表,建立油井增产措施样本数据库。A building module is used to build a sample database of oil well production increase measures based on the text file and the measure data table.
第四方面,本发明实施例提供一种区块油井可视化板块地图的建立装置,包括:In a fourth aspect, an embodiment of the present invention provides a device for establishing a block oil well visualization plate map, comprising:
可视化生成模块,用于根据每口油井对应的层段信息表,生成每口油井可视化的时间层段二维矩阵数据图;A visualization generation module is used to generate a visualized time-layer two-dimensional matrix data diagram of each oil well according to the layer information table corresponding to each oil well;
板块地图建立模块,用于以每口油井对应的可视化的时间层段二维矩阵数据图为基础,建立区块油井可视化框架并关联油井信息,建立区块油井可视化板块地图。The plate map establishment module is used to establish a block oil well visualization framework and associate oil well information based on the visualized time layer two-dimensional matrix data diagram corresponding to each oil well, and establish a block oil well visualization plate map.
第五方面,本发明实施例提供一种计算机可读存储介质,所述计算机可读存储介质存储有计算机程序,所述计算机程序被处理器执行时实现如前述的油井增产措施样本数据库的建立方法或者实现如前述的区块油井可视化板块地图的建立方法。In a fifth aspect, an embodiment of the present invention provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the method for establishing a sample database of oil well production increase measures as described above or the method for establishing a visualization plate map of block oil wells as described above is implemented.
第六方面,本发明实施例提供一种计算机程序产品,所述计算机程序产品包括计算机程序,所述计算机程序被处理器执行时实现如前述的油井增产措施样本数据库的建立方法或者实现如前述的区块油井可视化板块地图的建立方法。In a sixth aspect, an embodiment of the present invention provides a computer program product, which includes a computer program. When the computer program is executed by a processor, it implements the method for establishing a sample database of oil well production increase measures as described above, or implements the method for establishing a visualization plate map of block oil wells as described above.
本发明实施例提供的上述技术方案的有益效果至少包括:The beneficial effects of the above technical solution provided by the embodiment of the present invention include at least:
本发明实施例提供的油井增产措施样本数据库的建立方法,根据每口油井的预处理信息表,生成每口油井对应的层段信息表,根据所述每口油井对应的层段信息表以及多源数据表,构建历史数据的文本文件,根据历史数据的文本文件以及措施数据表,建立油井增产措施样本数据库,明确了层位开关时间、细致划分了层段、补充了生产状态,实现了不同类型增产措施多源多类型数据互联;在所述油井增产措施样本数据库与油田数据系统之间建立数据传输通道,实现了油井增产措施样本数据库实时更新;本发明实施例提供的区块油井可视化板块地图的建立方法,建立了油田区块油井措施综合信息展示地图,便于更直观更全面地了解油田区块中油井全井生命周期增产措施实施情况以及措施效果,为采取精准措施提供案例,为后续机器学习等工作综合专家经验奠定基础。The method for establishing a sample database of oil well production increase measures provided in an embodiment of the present invention generates a layer information table corresponding to each oil well according to a preprocessing information table of each oil well, constructs a text file of historical data according to the layer information table corresponding to each oil well and a multi-source data table, and establishes a sample database of oil well production increase measures according to the text file of historical data and the measures data table, clarifies the layer switching time, divides the layers in detail, supplements the production status, and realizes the interconnection of multi-source and multi-type data of different types of production increase measures; establishes a data transmission channel between the sample database of oil well production increase measures and the oilfield data system, and realizes the real-time update of the sample database of oil well production increase measures; the method for establishing a block oil well visualization plate map provided in an embodiment of the present invention establishes a comprehensive information display map of oil well measures in oilfield blocks, which is convenient for more intuitive and comprehensive understanding of the implementation of production increase measures for the entire life cycle of oil wells in the oilfield blocks and the effects of the measures, provides cases for taking precise measures, and lays a foundation for the comprehensive expert experience of subsequent machine learning and other work.
本发明的其它特征和优点将在随后的说明书中阐述,并且,部分地从说明书中变得显而易见,或者通过实施本发明而了解。本发明的目的和其他优点可通过在所写的说明书、权利要求书、以及附图中所特别指出的结构来实现和获得。Other features and advantages of the present invention will be described in the following description, and partly become apparent from the description, or understood by practicing the present invention. The purpose and other advantages of the present invention can be realized and obtained by the structures particularly pointed out in the written description, claims, and drawings.
下面通过附图和实施例,对本发明的技术方案做进一步的详细描述。The technical solution of the present invention is further described in detail below through the accompanying drawings and embodiments.
附图说明BRIEF DESCRIPTION OF THE DRAWINGS
附图用来提供对本发明的进一步理解,并且构成说明书的一部分,与本发明的实施例一起用于解释本发明,并不构成对本发明的限制。在附图中:The accompanying drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation of the present invention. In the accompanying drawings:
图1为本发明实施例中油井增产措施样本数据库的建立方法的流程图;FIG1 is a flow chart of a method for establishing a sample database of oil well production enhancement measures according to an embodiment of the present invention;
图2为本发明实施例中历史数据的文本文件格式的示意图;FIG2 is a schematic diagram of a text file format of historical data in an embodiment of the present invention;
图3为本发明实施例中第一措施时间段重整排序处理的流程图;3 is a flowchart of a first measure time period reordering process according to an embodiment of the present invention;
图4为本发明实施例中时间层段二维矩阵数据图的示意图;FIG4 is a schematic diagram of a two-dimensional matrix data diagram of a time layer segment according to an embodiment of the present invention;
图5为本发明实施例中全井井史产量曲线的示意图;FIG5 is a schematic diagram of a production curve of the entire well history in an embodiment of the present invention;
图6为本发明实施例中措施样本有效期产量曲线的示意图;FIG6 is a schematic diagram of a yield curve of a measure sample during the validity period according to an embodiment of the present invention;
图7为本发明实施例中区块油井可视化板块地图的建立方法的流程图;FIG7 is a flow chart of a method for establishing a visualized plate map of oil wells in a block according to an embodiment of the present invention;
图8为本发明实施例中区块油井可视化板块地图的示意图;FIG8 is a schematic diagram of a visualized plate map of a block oil well in an embodiment of the present invention;
图9为本发明实施例中油井增产措施样本数据库的建立装置结构框图;9 is a structural block diagram of a device for establishing a sample database of oil well production increase measures according to an embodiment of the present invention;
图10为本发明实施例中区块油井可视化板块地图的建立装置结构框图;FIG10 is a structural block diagram of a device for establishing a visualized plate map of oil wells in a block according to an embodiment of the present invention;
图11为本发明实施例中数据信息处理过程的流程图。FIG. 11 is a flow chart of a data information processing process in an embodiment of the present invention.
具体实施方式Detailed ways
下面将参照附图更详细地描述本公开的示例性实施例。虽然附图中显示了本公开的示例性实施例,然而应当理解,可以以各种形式实现本公开而不应被这里阐述的实施例所限制。相反,提供这些实施例是为了能够更透彻地理解本公开,并且能够将本公开的范围完整的传达给本领域的技术人员。The exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although the exemplary embodiments of the present disclosure are shown in the accompanying drawings, it should be understood that the present disclosure can be implemented in various forms and should not be limited by the embodiments set forth herein. On the contrary, these embodiments are provided in order to enable a more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.
为了更好地对增产措施的效果进行预测,确保措施效果预测模型准确可靠,本发明实施例提供了一种油井增产措施样本数据库的建立方法,参照图1所示,该方法包括下述步骤:In order to better predict the effect of the production increase measures and ensure that the measure effect prediction model is accurate and reliable, an embodiment of the present invention provides a method for establishing a sample database of oil well production increase measures. As shown in FIG. 1 , the method includes the following steps:
S11、根据每口油井的预处理信息表,生成每口油井对应的层段信息表;S11, generating a layer section information table corresponding to each oil well according to the pre-processing information table of each oil well;
S12、根据所述每口油井对应的层段信息表以及多源数据表,构建历史数据的文本文件;S12, constructing a text file of historical data according to the layer information table corresponding to each oil well and the multi-source data table;
S13、根据所述文本文件以及措施数据表,建立油井增产措施样本数据库。S13. Establishing a sample database of oil well production increase measures based on the text file and the measures data table.
本发明实施例提供的油井增产措施样本数据库的建立方法,首先针对油田中不同区块或同一区块不同井关于同一数据信息的数据格式不一致的问题,对井斜数据、测井数据、小层数据、月度生产数据、综合数据等数据信息建立统一的数据格式规范标准,以便于数据信息的查询、调取与使用;其次为了明确层位开关、细致划分层段、补充生产状态,从而为多源多类型数据互联搭建时空二维框架,本方案根据每口油井的预处理信息表,生成每口油井对应的层段信息表,层段信息表如表1所示,然后根据每口油井生成的对应的层段信息表,结合存储了多种类型数据的多源数据表,构建出历史数据的文本文件,后文中历史数据的文本文件简称为His(History)文本文件,His文本文件格式如图2所示,实现多源多类型数据之间的互联;然后根据构建出的His文本文件,结合措施数据表中的各条记录以及月度生产数据表中的数据,月度生产数据表包含参数如表2所示,最终建立出油井增产措施样本数据库,油井增产措施样本数据库包含参数如表3所示。在本实施例中,以射孔事件作为增产措施的示例,预处理信息表是以射孔事件为索引而建立的,预处理信息表如表4所示。The method for establishing a sample database of oil well production increase measures provided by an embodiment of the present invention firstly aims at the problem of inconsistent data formats for the same data information in different blocks or different wells in the same block in an oil field, and establishes a unified data format specification standard for data information such as well deviation data, logging data, small layer data, monthly production data, and comprehensive data, so as to facilitate the query, retrieval and use of data information; secondly, in order to clarify the layer switch, divide the layer section in detail, and supplement the production status, thereby building a spatiotemporal two-dimensional framework for the interconnection of multi-source and multi-type data, this solution generates a layer section information table corresponding to each oil well according to the preprocessing information table of each oil well, and the layer section information table is shown in Table 1 As shown, then according to the corresponding layer information table generated by each oil well, combined with the multi-source data table storing multiple types of data, a text file of historical data is constructed. The text file of historical data is referred to as His (History) text file in the following text. The format of His text file is shown in Figure 2, realizing the interconnection between multi-source and multi-type data; then according to the constructed His text file, combined with each record in the measure data table and the data in the monthly production data table, the monthly production data table contains parameters as shown in Table 2, and finally a sample database of oil well production increase measures is established. The sample database of oil well production increase measures contains parameters as shown in Table 3. In this embodiment, the perforation event is taken as an example of the production increase measure, and the preprocessing information table is established with the perforation event as the index, and the preprocessing information table is shown in Table 4.
表1 层段信息表样例Table 1 Example of layer information table
表2 月度生产数据表包含参数Table 2 Monthly production data table contains parameters
表3 油井增产措施样本数据库包含参数Table 3 Parameters included in the sample database of oil well stimulation measures
表4 预处理信息表样例Table 4 Preprocessing information table example
在油井增产措施样本数据库建立之后,本发明可以对油井增产措施样本数据库进行实时更新,具体技术方案如下所述。After the oil well production increase measure sample database is established, the present invention can update the oil well production increase measure sample database in real time. The specific technical scheme is as follows.
进一步地,上述步骤S13之后,通过下述方案实现对油井增产措施样本数据库的实时更新:Furthermore, after the above step S13, the real-time update of the oil well production increase measure sample database is achieved through the following scheme:
在所述油井增产措施样本数据库与油田数据系统之间建立数据传输通道;Establishing a data transmission channel between the oil well production enhancement measure sample database and the oilfield data system;
当油田数据系统中的数据被更新时,实时更新油井增产措施样本数据库。When the data in the oilfield data system is updated, the oil well production increase measure sample database is updated in real time.
首先在所述油井增产措施样本数据库与油田数据系统之间建立数据传输通道,所述的数据传输通道是基于WebSocket协议建立的,WebSocket允许服务端主动向客户端推送数据,在本方案中,油田数据系统作为服务端,油井增产措施样本数据库作为客户端,当在一段时间范围内油田数据系统中的数据发生变化时,可以将变化后的数据主动推送到油井增产措施样本数据库中,实现实时数据的获取、实时更新油井增产措施样本数据库,便于数据的统计和更新。First, a data transmission channel is established between the oil well production increase measures sample database and the oilfield data system. The data transmission channel is established based on the WebSocket protocol. WebSocket allows the server to actively push data to the client. In this solution, the oilfield data system serves as the server and the oil well production increase measures sample database serves as the client. When the data in the oilfield data system changes within a period of time, the changed data can be actively pushed to the oil well production increase measures sample database, thereby realizing real-time data acquisition and real-time updating of the oil well production increase measures sample database, which is convenient for data statistics and updating.
下面对上述步骤S11中的具体步骤进行说明。The specific steps in the above step S11 are described below.
进一步地,上述步骤S11中,通过下述方案实现层段信息表的生成。Furthermore, in the above step S11, the generation of the layer segment information table is achieved through the following scheme.
对预处理信息表中的各第一措施时间段进行重整排序处理,获得对应的第二措施时间段;Rearrange and sort each first measure time period in the pre-processing information table to obtain a corresponding second measure time period;
对预处理信息表中的各第一生产层段进行细分切割处理,获得第二生产层段;Subdividing and cutting each first production layer segment in the pre-processing information table to obtain a second production layer segment;
将各所述第二措施时间段与各所述第二生产层段分别进行二维关联,生成时间层段二维矩阵数据图;Two-dimensionally associate each of the second measure time periods with each of the second production layer sections to generate a two-dimensional matrix data diagram of the time layer section;
对所述时间层段二维矩阵数据图中的每个第二生产层段和每个第二措施时间段对应的矩阵块的生产状态进行标记;Marking the production status of the matrix blocks corresponding to each second production layer segment and each second measure time period in the two-dimensional matrix data diagram of the time layer segment;
以第二措施时间段为索引,对所述时间层段二维矩阵数据图中与每个第二措施时间段对应的第二生产层段和生产状态的标记进行检索,根据检索结果生成层段信息表。Using the second measure time period as an index, the second production layer segment and the production status mark corresponding to each second measure time period in the time layer segment two-dimensional matrix data diagram are retrieved, and a layer segment information table is generated according to the retrieval result.
首先对预处理信息表中的各第一措施时间段进行重整排序处理,获得对应的第二措施时间段,第一措施时间段为预处理信息表中的日期字段对应的时间段,第二措施时间段为层段信息表中的日期字段对应的时间段,各第一措施时间段是按射孔事件划分的,每一个第一措施时间段对应一次射孔事件,以射孔事件进行信息的记录后,各第一措施时间段在时间上存在重叠的时间段,对各第一措施时间段进行重整排序处理后,获得的对应的第二措施时间段在时间上不存在重叠的时间段,解决了层位开关不明确问题。First, each first measure time period in the preprocessing information table is reorganized and sorted to obtain the corresponding second measure time period. The first measure time period is the time period corresponding to the date field in the preprocessing information table, and the second measure time period is the time period corresponding to the date field in the layer information table. Each first measure time period is divided according to the perforation event. Each first measure time period corresponds to a perforation event. After the perforation event is used to record information, there are overlapping time periods in each first measure time period. After the first measure time periods are reorganized and sorted, the corresponding second measure time periods obtained do not have overlapping time periods in time, which solves the problem of unclear layer switches.
然后对预处理信息表中的各第一生产层段进行细分切割处理,获得第二生产层段,第一生产层段为预处理信息表中的射孔井段字段对应的层段范围,第二生产层段为细分切割后的层段范围,如表4所示,在预处理信息表中,第一生产层段分别为M1-M2、M4-M6、M3-M5、M7-M8,分别为四次射孔事件对应的射孔井段,但不同次措施的射孔井段划分存在井段的交错问题,例如M4-M6与M3-M5存在井段的交错;针对上述问题,对预处理信息表中的各第一生产层段进行细分切割处理,细分切割的单位为一个井段。对于M1-M2井段范围,等于一个细分切割的单位,因此不需要再细分切割;对于M4-M6井段范围,大于一个细分切割的单位,因此细分切割为M4-M5、M5-M6;同理,对于M3-M5井段范围,细分切割为M3-M4、M4-M5;同理,对于M7-M8井段范围,也不需要再细分切割。通过上述方式,就完成了对预处理信息表中的各第一生产层段的细分切割处理,获得了对应的第二生产层段,解决了不同次措施的射孔井段划分存在井段的交错问题。Then, each first production layer segment in the preprocessing information table is subdivided and cut to obtain the second production layer segment. The first production layer segment is the layer segment range corresponding to the perforation well segment field in the preprocessing information table, and the second production layer segment is the layer segment range after subdivision and cutting, as shown in Table 4. In the preprocessing information table, the first production layer segments are M1-M2, M4-M6, M3-M5, and M7-M8, which are the perforation well segments corresponding to four perforation events, respectively. However, the perforation well segment division of different measures has the problem of well segment interleaving, for example, there is well segment interleaving between M4-M6 and M3-M5. In view of the above problems, each first production layer segment in the preprocessing information table is subdivided and cut, and the unit of subdivision and cutting is a well segment. For the M1-M2 well section range, it is equal to a subdivided cutting unit, so no further subdividing and cutting is required; for the M4-M6 well section range, it is greater than a subdivided cutting unit, so the subdividing and cutting is M4-M5, M5-M6; similarly, for the M3-M5 well section range, the subdividing and cutting is M3-M4, M4-M5; similarly, for the M7-M8 well section range, no further subdividing and cutting is required. Through the above method, the subdividing and cutting processing of each first production layer section in the pre-processing information table is completed, and the corresponding second production layer section is obtained, which solves the problem of interlacing of well sections in the perforation well section division of different measures.
接下来,将各所述第二措施时间段与各所述第二生产层段分别进行二维关联,生成时间层段二维矩阵数据图,在生成的时间层段二维矩阵数据图中,横轴表示时间,对应第二措施时间段,纵轴表示深度,对应第二生产层段,不同的深度即为不同的层段。Next, each of the second measure time periods is two-dimensionally associated with each of the second production layer segments to generate a two-dimensional matrix data diagram of the time segment. In the generated two-dimensional matrix data diagram of the time segment, the horizontal axis represents time, corresponding to the second measure time period, and the vertical axis represents depth, corresponding to the second production layer segment. Different depths correspond to different layers.
然后,对所述时间层段二维矩阵数据图中的每个第二生产层段和每个第二措施时间段对应的矩阵块的生产状态进行标记,在时间层段二维矩阵数据图中,横轴的各第二措施时间段与纵轴的各第二生产层段横纵交错,在各交错的位置分别形成各矩阵块,每个矩阵块分别对应某一第二措施时间段范围内的某一第二生产层段,对所述矩阵块的生产状态进行标记,比如使用不同的值,来表示不同的生产状态,例如,若生产状态为正常生产,则将生产状态标记为1;若生产状态为停产,则将生产状态标记为0;若生产状态为转注,则将生产状态标记为-1。通过上述方式,补充了各第二措施时间段内各第二生产层段的生产状态,解决了生产状态未体现或不完整的问题。Then, the production status of each second production layer segment and each matrix block corresponding to the second measure time period in the two-dimensional matrix data diagram of the time layer segment is marked. In the two-dimensional matrix data diagram of the time layer segment, each second measure time period on the horizontal axis is staggered with each second production layer segment on the vertical axis, and each matrix block is formed at each staggered position. Each matrix block corresponds to a second production layer segment within a second measure time period. The production status of the matrix block is marked, such as using different values to represent different production statuses. For example, if the production status is normal production, the production status is marked as 1; if the production status is shutdown, the production status is marked as 0; if the production status is transfer, the production status is marked as -1. In the above manner, the production status of each second production layer segment in each second measure time period is supplemented, solving the problem that the production status is not reflected or is incomplete.
最后,将各个第二措施时间段作为层段信息表中日期字段对应的各条记录,并以第二措施时间段为索引,对所述时间层段二维矩阵数据图中与每个第二措施时间段对应的第二生产层段和生产状态的标记进行检索,根据检索结果生成层段信息表。例如作为索引的第二措施时间段为201101-201403,根据这一时间段对所述时间层段二维矩阵数据图进行检索,检索到的对应的第二生产层段分别为M1-M2、M4-M5、M5-M6,所述检索到的三个第二生产层段的生产状态均为正常生产,因此将所述检索到的数据添加到层段信息表对应的字段中,并将添加的第二生产层段M1-M2、M4-M5、M5-M6,在层段信息表中分别记录为生产层段1、生产层段2、生产层段3,并添加对应的井号和所属的阶段,由此完成层段信息表中一条记录的添加,重复上述过程,完成所有记录的添加后生成完整的层段信息表。Finally, each second measure time period is used as each record corresponding to the date field in the layer segment information table, and the second measure time period is used as an index to retrieve the second production layer segment and the production status mark corresponding to each second measure time period in the time layer segment two-dimensional matrix data map, and generate the layer segment information table according to the retrieval result. For example, the second measure time period used as the index is 201101-201403, and the time layer segment two-dimensional matrix data map is retrieved according to this time period. The corresponding second production layer segments retrieved are M1-M2, M4-M5, and M5-M6, and the production status of the three retrieved second production layer segments are all normal production. Therefore, the retrieved data is added to the corresponding field of the layer segment information table, and the added second production layer segments M1-M2, M4-M5, and M5-M6 are recorded as production layer segment 1, production layer segment 2, and production layer segment 3 in the layer segment information table, and the corresponding well number and the stage to which they belong are added, thereby completing the addition of a record in the layer segment information table, repeating the above process, and generating a complete layer segment information table after completing the addition of all records.
进一步地,对预处理信息表中的各第一措施时间段进行重整排序处理,获得对应的第二措施时间段,具体包括如下步骤:Further, each first measure time period in the pre-processing information table is re-arranged and sorted to obtain a corresponding second measure time period, which specifically includes the following steps:
对所述预处理信息表中的各第一措施时间段的时间节点,按照时间先后顺序进行排序;Sorting the time nodes of each first measure time period in the pre-processing information table in chronological order;
根据排序后的各时间节点,对存在重叠的时间段进行合并处理;According to the sorted time nodes, the overlapping time periods are merged;
删除无效时间节点并对有效时间节点重新排序,获得重新排序后有效时间节点形成的各第二措施时间段。Invalid time nodes are deleted and valid time nodes are reordered to obtain second measure time periods formed by the reordered valid time nodes.
如表4所示,预处理信息表的日期字段包含四条第一措施时间段的记录,每条第一措施时间段包含一个开始时间节点和一个结束时间节点,根据每条第一措施时间段的时间节点,按照时间的先后顺序进行排序,对于存在时间范围重叠的各第一措施时间段,由上而下进行排列,每条第一措施时间段对应一次增产措施,排序后的每条第一措施时间段如图3所示;然后,根据排序后的各时间节点,对存在重叠的时间段进行合并处理,对于时间节点①至时间节点②的范围内,存在两段重叠的第一措施时间段,对两段重叠的第一措施时间段进行合并处理,同理,分别对时间节点②至时间节点③、时间节点③至时间节点④、时间节点④至时间节点⑤范围内存在重叠的时间段进行合并处理,合并处理后的各时间段如图3所示;接下来,完成合并处理后,存在有效时间节点和无效时间节点,有效时间节点包括时间节点①至时间节点②、时间节点②至时间节点③和时间节点④至时间节点⑤,无效时间节点包括时间节点③至时间节点④,因此要删除无效时间节点,并对有效时间节点重新进行排序,获得重新排序后有效时间节点形成的各第二措施时间段,第二措施时间段如图3所示包括时间节点①至时间节点②的时间段、时间节点③至时间节点④的时间段、时间节点⑤至时间节点⑥的时间段,每个第二措施时间段包含合并后的至少一个增产措施。通过上述方式,获得的各第二措施时间段在时间上不重叠,且连续的各个第二措施时间段内,分别包含了所采取的至少一个射孔措施。As shown in Table 4, the date field of the preprocessing information table contains four records of the first measure time period, each of which contains a start time node and an end time node. According to the time nodes of each first measure time period, they are sorted in chronological order. For the first measure time periods with overlapping time ranges, they are arranged from top to bottom. Each first measure time period corresponds to a production increase measure. Each first measure time period after sorting is shown in Figure 3. Then, according to the sorted time nodes, the overlapping time periods are merged. For the range from time node ① to time node ②, there are two overlapping first measure time periods. The two overlapping first measure time periods are merged. Similarly, the first measure time periods from time node ② to time node ③, from time node ③ to time node ④, and from time node ④ to time node ⑤ are merged. The overlapping time periods within the range of time node ④ to time node ⑤ are merged, and each time period after the merging process is shown in Figure 3; next, after the merging process is completed, there are valid time nodes and invalid time nodes, and the valid time nodes include time node ① to time node ②, time node ② to time node ③ and time node ④ to time node ⑤, and the invalid time nodes include time node ③ to time node ④, so the invalid time nodes are deleted, and the valid time nodes are re-sorted to obtain each second measure time period formed by the valid time nodes after re-sorting. The second measure time period includes the time period from time node ① to time node ②, the time period from time node ③ to time node ④, and the time period from time node ⑤ to time node ⑥ as shown in Figure 3, and each second measure time period contains at least one production increase measure after the merger. In the above manner, each second measure time period obtained does not overlap in time, and each continuous second measure time period contains at least one perforation measure taken.
进一步地,将所述第二措施时间段与所述第二生产层段进行二维关联,构成时间层段二维矩阵数据图,具体包括如下步骤:Furthermore, the second measure time period is two-dimensionally associated with the second production layer segment to form a two-dimensional matrix data diagram of the time segment, which specifically includes the following steps:
依次选取层段信息表中的第二措施时间段;Select the second measure time period in the layer section information table in sequence;
根据所述选取的第二措施时间段,遍历所述预处理信息表中的第一措施时间段,确定第二措施时间段与第一措施时间段之间的隶属关系;According to the selected second measure time period, traverse the first measure time period in the pre-processing information table to determine the subordinate relationship between the second measure time period and the first measure time period;
根据所述隶属关系,确定所述第二措施时间段对应的第二生产层段;Determining, according to the affiliation, a second production layer section corresponding to the second measure time period;
将所述第二措施时间段与所述对应的第二生产层段进行二维关联,构成时间层段二维矩阵数据图。The second measure time period is two-dimensionally associated with the corresponding second production layer segment to form a two-dimensional matrix data diagram of the time layer segment.
如表1所示,层段信息表的日期字段中包含三段第二措施时间段,依次选取层段信息表中的第二措施时间段,然后根据所选取的第二措施时间段,遍历预处理信息表中的第一措施时间段,确定出所选取的第二措施时间段与第一措施时间段之间的隶属关系,例如先选取层段信息表中的第一个第二措施时间段201101-201403,然后遍历预处理信息表中的第一措施时间段,从而确定出所选取的第二措施时间段201101-201403,隶属于预处理信息表中第一个第一措施时间段201101-201905和第二个第一措施时间段201101-201905,然后根据上述隶属关系,确定所选取的第二措施时间段对应的第二生产层段,因为所选取的第二措施时间段201101-201403隶属于201101-201905、201101-201905两个第一措施时间段,第一个第一措施时间段201101-201905所对应的第一生产层段为M1-M2,第二个第一措施时间段201101-201905所对应的第一生产层段为M4-M6,第一生产层段M1-M2所对应的第二生产层段为M1-M2,第一生产层段M4-M6所对应的第二生产层段为M4-M5和M5-M6,因此,选取的第二措施时间段201101-201403对应的第二生产层段为M1-M2、M4-M5和M5-M6;最后将第二措施时间段与对应的第二生产层段进行二维关联,横轴为时间,对应第二措施时间段,纵轴为深度,对应第二生产层段,最终构成如图4所示的时间层段二维矩阵数据图。As shown in Table 1, the date field of the layer segment information table contains three second measure time periods. The second measure time periods in the layer segment information table are selected in turn, and then the first measure time periods in the preprocessing information table are traversed according to the selected second measure time periods to determine the affiliation between the selected second measure time period and the first measure time period. For example, the first second measure time period 201101-201403 in the layer segment information table is first selected, and then the first measure time period in the preprocessing information table is traversed to determine that the selected second measure time period 201101-201403 is affiliated to the first first measure time period 201101-201905 and the second first measure time period 201101-201905 in the preprocessing information table. Then, according to the above affiliation, the second production layer segment corresponding to the selected second measure time period is determined, because the selected second measure time period 201101-201403 Belonging to the two first measure time periods of 201101-201905 and 201101-201905, the first production layer segment corresponding to the first first measure time period 201101-201905 is M1-M2, the first production layer segment corresponding to the second first measure time period 201101-201905 is M4-M6, the second production layer segment corresponding to the first production layer segment M1-M2 is M1-M2, and the second production layer segment corresponding to the first production layer segment M4-M6 is M4-M5 and M5-M6. Therefore, the second production layer segments corresponding to the selected second measure time period 201101-201403 are M1-M2, M4-M5 and M5-M6; finally, the second measure time period is two-dimensionally associated with the corresponding second production layer segment, the horizontal axis is time, corresponding to the second measure time period, and the vertical axis is depth, corresponding to the second production layer segment, and finally a two-dimensional matrix data diagram of time segment is formed as shown in Figure 4.
在上述方案中,根据所述每口油井对应的层段信息表以及多源数据表,构建His文本文件,通过下述方式实现:In the above scheme, according to the layer information table and multi-source data table corresponding to each oil well, a His text file is constructed, which is implemented in the following way:
将所述每口油井对应的层段信息表以及月度生产数据表、小层数据表、测井数据表中的信息进行整合存储,构建出His文本文件。The information in the layer information table corresponding to each oil well, as well as the monthly production data table, the small layer data table, and the logging data table are integrated and stored to construct a His text file.
首先以每口油井对应的层段信息表中日期为索引,获取月度生产数据表中月产、阶段产量、累积产量等信息;然后以每口油井对应的层段信息表中层段测深为索引,获取层段信息表中各阶段生产状态、生产层段序号;获取小层数据表中解释序号、层位等信息,获取测井数据表中渗透率等地质信息,并将所获取的各井信息存储在His文本文件中,实现多源多类型数据互联。First, the date in the layer information table corresponding to each oil well is used as the index to obtain the monthly production, stage production, cumulative production and other information in the monthly production data table; then, the layer sounding in the layer information table corresponding to each oil well is used as the index to obtain the production status of each stage and the production layer sequence number in the layer information table; the interpretation sequence number, layer position and other information in the small layer data table are obtained, and the geological information such as permeability in the well logging data table is obtained, and the obtained information of each well is stored in the His text file to realize the interconnection of multi-source and multi-type data.
进一步地,根据His文本文件以及措施数据表,建立油井增产措施样本数据库,具体包括如下步骤:Furthermore, according to the His text file and the measure data table, a sample database of oil well production increase measures is established, which specifically includes the following steps:
以措施数据表中各条记录为索引,提取His文本文件和月度生产数据表中在措施有效期内对应的参数信息,若涉及到垂深相关参数则调用井斜数据进行测深垂深转换;Using each record in the measure data table as an index, extract the corresponding parameter information in the His text file and the monthly production data table within the validity period of the measure. If vertical depth related parameters are involved, call the well inclination data to perform depth measurement and vertical depth conversion;
根据措施数据表和月度生产数据表,生成各井全井井史产量曲线、措施样本有效期产量曲线以及对应的措施标签信息,并生成对应的图片信息;According to the measure data table and monthly production data table, generate the production curve of the entire well history of each well, the production curve of the effective period of the measure sample and the corresponding measure label information, and generate the corresponding picture information;
将所述参数信息和所述图片信息添加到所述措施数据表的每条措施记录中,建立油井增产措施样本数据库。The parameter information and the image information are added to each measure record in the measure data table to establish a sample database of oil well production increase measures.
首先以措施数据表各条记录为索引,在各井各措施有效期的范围内,提取His文本文件、月度生产数据表中对应的信息,在数据信息提取的过程中,若涉及到垂深相关参数则调用井斜数据进行测深垂深转换。其中提取His文本文件的主要信息包括:确定完工日期所在生产阶段;获取对应小层序号;查询对应小层地质物性信息;测深转换垂深,计算对应层段及平均物性。提取月度生产数据表中的信息如表2所示。作为索引的措施数据表中的各条记录可包含井号、措施类别、完工日期、失效日期等内容。上述在各井各措施有效期的范围内提取信息,可以解释为只提取在各措施有效期范围内的信息,例如提取产量信息,产量信息包括所有月份的产量数据,若提取所有的产量信息,则无法直观的了解采取措施后带来的效果,因此只提取在各措施有效期范围内月份的产量信息,以直观的了解采取措施后带来的措施效果。First, take each record in the measure data table as an index, and extract the corresponding information in the His text file and the monthly production data table within the validity period of each measure in each well. In the process of data information extraction, if vertical depth related parameters are involved, the well inclination data is called to perform depth measurement and vertical depth conversion. The main information extracted from the His text file includes: determining the production stage where the completion date is located; obtaining the corresponding sub-layer sequence number; querying the corresponding sub-layer geological property information; converting vertical depth from depth measurement, and calculating the corresponding layer section and average physical properties. The information extracted from the monthly production data table is shown in Table 2. Each record in the measure data table as an index may include well number, measure category, completion date, expiration date, etc. The above-mentioned extraction of information within the validity period of each measure in each well can be interpreted as extracting only information within the validity period of each measure, such as extracting production information. The production information includes production data of all months. If all production information is extracted, it is impossible to intuitively understand the effect of taking measures. Therefore, only the production information of the months within the validity period of each measure is extracted to intuitively understand the effect of measures after taking measures.
然后根据措施数据表和月度生产数据表中的数据信息,生成各井全井井史产量曲线如图5所示、措施样本有效期产量曲线如图6所示,并在上述产量曲线中标明对应的措施标签信息,以实现各井全井井史以及措施样本有效期内产量曲线自动可视化、措施自动标签识别,并生成对应的图片信息。Then, according to the data information in the measure data table and the monthly production data table, the production curve of the entire well history of each well is generated as shown in Figure 5, and the production curve of the effective period of the measure sample is generated as shown in Figure 6, and the corresponding measure label information is indicated in the above production curves to realize automatic visualization of the production curve of the entire well history of each well and the effective period of the measure sample, automatic measure label recognition, and generate corresponding image information.
最后将上述提取的参数信息和上述的图片信息添加到所述措施数据表的每条措施记录中,对于图片信息可以以超链接的形式添加,最终完成油井增产措施样本数据库的建立。Finally, the extracted parameter information and the picture information are added to each measure record in the measure data table. The picture information can be added in the form of a hyperlink, and finally the establishment of the oil well production increase measure sample database is completed.
本发明实施例还提供了一种区块油井可视化板块地图的建立方法,参照图7所示,包括下述步骤:The embodiment of the present invention also provides a method for establishing a visualized plate map of a block oil well, as shown in FIG. 7 , comprising the following steps:
S51、根据每口油井对应的层段信息表,生成每口油井可视化的时间层段二维矩阵数据图;S51, generating a visualized time-layer two-dimensional matrix data graph of each oil well according to the layer information table corresponding to each oil well;
S52、以每口油井对应的可视化的时间层段二维矩阵数据图为基础,建立区块油井可视化框架并关联油井信息,建立区块油井可视化板块地图。S52. Based on the visualized two-dimensional matrix data diagram of the time segment corresponding to each oil well, a visualization framework of the block oil wells is established and the oil well information is associated to establish a visualization plate map of the block oil wells.
进一步地,上述步骤S52,具体通过下述方式实现:Furthermore, the above step S52 is specifically implemented in the following manner:
根据每口油井的地理坐标,在预设的地图数据中,将每口油井对应的可视化的时间层段二维矩阵数据图与所述地理坐标进行关联,并通过区块油井可视化板块地图展示。According to the geographic coordinates of each oil well, in the preset map data, the visualized time layer two-dimensional matrix data diagram corresponding to each oil well is associated with the geographic coordinates and displayed through the block oil well visualization plate map.
首先针对每口油井,基于该油井对应的层段信息表,生成每口油井可视化的时间层段二维矩阵数据图,横轴表示时间,纵轴表示层段测深,并对各时间和层段测深对应的各矩阵块使用不同颜色与数值标记油井正常生产、停产、转注生产状态;生成每口油井对应的可视化的时间层段二维矩阵数据图之后,能够以某层段深度整体为索引检索该油井该层段深度范围地质、流体信息;以某时间段整体为索引检索该井该时间段正常油井生产状态下生产层段及其对应地质流体信息、月产数据、采取措施及措施有效期内信息,还包括全井井史及措施样本有效期产量和措施标签可视化;以各矩阵块为索引检索该井该时间段该层段深度范围内的有效信息。Firstly, for each oil well, based on the layer information table corresponding to the oil well, a visualized time layer two-dimensional matrix data diagram is generated for each oil well, in which the horizontal axis represents time and the vertical axis represents layer depth measurement, and different colors and values are used to mark the normal production, shutdown and injection production status of the oil well for each matrix block corresponding to each time and layer depth measurement; after generating the visualized time layer two-dimensional matrix data diagram corresponding to each oil well, the geological and fluid information of the depth range of the layer segment of the oil well can be retrieved by taking the depth of a certain layer segment as an index; the production layer segment and its corresponding geological fluid information, monthly production data, measures taken and information within the effective period of the measures under the normal oil well production state of the well in the time period can be retrieved by taking a certain time period as an index, and also includes the visualization of the production of the whole well history and the effective period of the measure sample and the measure label; the effective information within the depth range of the layer segment of the well in the time period can be retrieved by taking each matrix block as an index.
基于上述生成的每口油井可视化的时间层段二维矩阵数据图,以区块地质模型为基础,先预设出相应的地图数据,构建区块油井可视化框架,然后再根据每口油井的地理坐标,在预设的地图数据中,将上述每口油井对应的地理坐标与每口油井对应的可视化的时间层段二维矩阵数据图相互关联,即可在地图数据中通过每口油井对应的地理坐标查看到关联的可视化的时间层段二维矩阵数据图,最后将上述内容通过区块油井可视化板块地图展示,就实现了集地质、流体与生产信息于一体的区块整体综合信息可视化处理,完成了区块油井综合信息可视化板块地图的建立,实现了全区块不同坐标油井综合信息与措施效果的可视化。所建立的区块油井可视化板块地图示意图如图8所示。Based on the above generated visualized time segment two-dimensional matrix data graph of each oil well, based on the block geological model, the corresponding map data is first preset to construct the visualization framework of the block oil well, 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 associated with the visualized time segment two-dimensional matrix data graph corresponding to each oil well, so that the associated visualized time segment two-dimensional matrix data graph can be viewed through the geographic coordinates corresponding to each oil well in the map data, and finally the above content is displayed through the block oil well visualization plate map, thus realizing the visualization processing of the overall comprehensive information of the block integrating geological, fluid and production information, completing the establishment of the block oil well comprehensive information visualization plate map, and realizing the visualization of the comprehensive information and measures of the oil wells with different coordinates in the whole block. The schematic diagram of the established block oil well visualization plate map is shown in Figure 8.
基于同一发明构思,本发明实施例还提供了一种油井增产措施样本数据库的建立装置、区块油井可视化板块地图的建立装置,由于这些装置所解决问题的原理与前述油井增产措施样本数据库的建立方法、区块油井可视化板块地图的建立方法相似,因此这些装置的实施可以参见前述方法的实施,重复之处不再赘述。Based on the same inventive concept, an embodiment of the present invention also provides a device for establishing a sample database of oil well production increase measures and a device for establishing a visualized plate map of block oil wells. Since the principles of the problems solved by these devices are similar to the aforementioned methods for establishing a sample database of oil well production increase measures and the aforementioned methods for establishing a visualized plate map of block oil wells, the implementation of these devices can refer to the implementation of the aforementioned methods, and the repeated parts will not be repeated.
本发明实施例提供一种油井增产措施样本数据库的建立装置,参照图9所示,包括:An embodiment of the present invention provides a device for establishing a sample database of oil well production stimulation measures, as shown in FIG9 , comprising:
生成模块61,用于根据每口油井的预处理信息表,生成每口油井对应的层段信息表;A generating module 61 is used to generate a layer section information table corresponding to each oil well according to the pre-processing information table of each oil well;
构建模块62,用于根据所述每口油井对应的层段信息表以及多源数据表,构建His文本文件;A construction module 62 is used to construct a His text file according to the layer information table corresponding to each oil well and the multi-source data table;
建立模块63,用于根据His文本文件以及措施数据表,建立油井增产措施样本数据库。The establishment module 63 is used to establish a sample database of oil well production increase measures according to the His text file and the measure data table.
本发明实施例提供一种区块油井可视化板块地图的建立装置,参照图10所示,包括:The embodiment of the present invention provides a device for establishing a visualized plate map of a block oil well, as shown in FIG10 , comprising:
可视化生成模块71,用于根据每口油井对应的层段信息表,生成每口油井可视化的时间层段二维矩阵数据图;A visualization generation module 71 is used to generate a visualized time-layer two-dimensional matrix data diagram of each oil well according to the layer information table corresponding to each oil well;
板块地图建立模块72,用于以每口油井对应的可视化的时间层段二维矩阵数据图为基础,建立区块油井可视化框架并关联油井信息,建立区块油井可视化板块地图。The plate map building module 72 is used to build a block oil well visualization framework and associate oil well information based on the visualized time layer segment two-dimensional matrix data map corresponding to each oil well, and build a block oil well visualization plate map.
如上所述,本发明首先根据每口油井的预处理信息表,生成每口油井对应的层段信息表,然后根据生成的层段信息表结合月度生产数据表、测井数据、小层数据表及岩石流体物性表进行多源多类型数据信息互联,构建His文本文件;再根据His文本文件中的数据信息以及生产数据,对措施数据表中的每条措施记录进行数据扩展,若涉及到垂深相关参数则调用井斜数据进行测深垂深转换,最终建立油井增产措施样本数据库;最后对油井增产措施样本数据库中各井从开始生产到目前为止的所有信息进行可视化处理,建立出区块油井可视化板块地图,整个数据信息处理过程如图11所示。As described above, the present invention first generates a layer information table corresponding to each oil well based on the preprocessing information table of each oil well, and then interconnects multi-source and multi-type data information based on the generated layer information table in combination with the monthly production data table, logging data, sub-layer data table and rock fluid physical property table to construct a His text file; then, based on the data information in the His text file and the production data, each measure record in the measure data table is expanded, and if vertical depth related parameters are involved, the well inclination data is called to perform depth measurement vertical depth conversion, and finally an oil well production increase measure sample database is established; finally, all information of each well in the oil well production increase measure sample database from the start of production to the present is visualized, and a block oil well visualization plate map is established. The entire data information processing process is shown in Figure 11.
本发明实施例提供一种计算机可读存储介质,所述计算机可读存储介质存储有计算机程序,所述计算机程序被处理器执行时实现如前述的油井增产措施样本数据库的建立方法或者实现如前述的区块油井可视化板块地图的建立方法。An embodiment of the present invention provides a computer-readable storage medium, which stores a computer program. When the computer program is executed by a processor, it implements the method for establishing a sample database of oil well production increase measures as described above, or implements the method for establishing a visualized plate map of block oil wells as described above.
本发明实施例提供一种计算机程序产品,所述计算机程序产品包括计算机程序,所述计算机程序被处理器执行时实现如前述的油井增产措施样本数据库的建立方法或者实现如前述的区块油井可视化板块地图的建立方法。An embodiment of the present invention provides a computer program product, which includes a computer program. When the computer program is executed by a processor, it implements the method for establishing a sample database of oil well production increase measures as described above, or implements the method for establishing a visualized plate map of oil wells in a block as described above.
关于上述实施例中的装置,其中各个模块执行操作的具体方式已经在有关该方法的实施例中进行了详细描述,此处将不做详细阐述说明。Regarding the device in the above embodiment, the specific manner in which each module performs operations has been described in detail in the embodiment of the method, and will not be elaborated here.
本领域内的技术人员应明白,本发明的实施例可提供为方法、系统、或计算机程序产品。因此,本发明可采用完全硬件实施例、完全软件实施例、或结合软件和硬件方面的实施例的形式。而且,本发明可采用在一个或多个其中包含有计算机可用程序代码的计算机可用存储介质(包括但不限于磁盘存储器和光学存储器等)上实施的计算机程序产品的形式。Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage and optical storage, etc.) containing computer-usable program code.
本发明是参照根据本发明实施例的方法、设备(系统)、和计算机程序产品的流程图和/或方框图来描述的。应理解可由计算机程序指令实现流程图和/或方框图中的每一流程和/或方框、以及流程图和/或方框图中的流程和/或方框的结合。可提供这些计算机程序指令到通用计算机、专用计算机、嵌入式处理机或其他可编程数据处理设备的处理器以产生一个机器,使得通过计算机或其他可编程数据处理设备的处理器执行的指令产生用于实现在流程图一个流程或多个流程和/或方框图一个方框或多个方框中指定的功能的装置。The present invention is described with reference to the flowchart and/or block diagram of the method, device (system), and computer program product according to the embodiment of the present invention. It should be understood that each process and/or box in the flowchart and/or block diagram, as well as the combination of the process and/or box in the flowchart and/or block diagram can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device produce a device for implementing the functions specified in one or more processes in the flowchart and/or one or more boxes in the block diagram.
这些计算机程序指令也可存储在能引导计算机或其他可编程数据处理设备以特定方式工作的计算机可读存储器中,使得存储在该计算机可读存储器中的指令产生包括指令装置的制造品,该指令装置实现在流程图一个流程或多个流程和/或方框图一个方框或多个方框中指定的功能。These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing device to work in a specific manner, so that the instructions stored in the computer-readable memory produce a manufactured product including an instruction device that implements the functions specified in one or more processes in the flowchart and/or one or more boxes in the block diagram.
这些计算机程序指令也可装载到计算机或其他可编程数据处理设备上,使得在计算机或其他可编程设备上执行一系列操作步骤以产生计算机实现的处理,从而在计算机或其他可编程设备上执行的指令提供用于实现在流程图一个流程或多个流程和/或方框图一个方框或多个方框中指定的功能的步骤。These computer program instructions may also be loaded onto a computer or other programmable data processing device so that a series of operational steps are executed on the computer or other programmable device to produce a computer-implemented process, whereby the instructions executed on the computer or other programmable device provide steps for implementing the functions specified in one or more processes in the flowchart and/or one or more boxes in the block diagram.
显然,本领域的技术人员可以对本发明进行各种改动和变型而不脱离本发明的精神和范围。这样,倘若本发明的这些修改和变型属于本发明权利要求及其等同技术的范围之内,则本发明也意图包含这些改动和变型在内。Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these 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 these modifications and variations.
Claims (12)
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)
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)
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 | 中国石油化工股份有限公司 | A kind of 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 | 中国石油化工股份有限公司 | A kind of 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 |
---|
"基于空间数据库的油藏多信息管理";许晓宏等;《计算机时代》;20140915;第39-42 页 * |
Also Published As
Publication number | Publication date |
---|---|
CN115049515A (en) | 2022-09-13 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105046328B (en) | A kind of three-dimensional visualization bridge defect information acquisition management system and method | |
CN109583762B (en) | A system for production process modeling and product data tracking | |
CN107766428B (en) | A method and system for automatically realizing data visualization | |
US20140157172A1 (en) | Geographic layout of petroleum drilling data and methods for processing data | |
CN109147045A (en) | City section geology three-dimensional method for automatic modeling based on topological subregion | |
CN106611246A (en) | Integrated management system of land and resources | |
CN106484943A (en) | A kind of online generation method of the log sheet based on nonlinear fitting control | |
CN112347752B (en) | Autonomous drawing management method and device for industrial chain | |
CN112084385B (en) | Part-process-equipment association relationship topological view generation method based on digital twinning | |
CN104090960A (en) | Dynamic multi-theme data warehouse building method based on hot continuous rolling production process | |
CN102855332A (en) | Graphic configuration management database based on graphic database | |
CN103955558A (en) | Method for collecting and processing engineering investigation data of different industries | |
CN115049515B (en) | Method and device for establishing oil well yield increase measure sample database and plate map | |
CN108921734A (en) | One real estate information visualization system based on multi-source heterogeneous data | |
CN116821223B (en) | Industrial visual control platform and method based on digital twinning | |
Seemann et al. | Improving resevoir management through big data technologies | |
CN105677625A (en) | Processing method for cooperatively filling multi-tier summarized statistical forms | |
US20130232158A1 (en) | Data subscription | |
CN107341608A (en) | One kind production basic data index analysis method | |
CN113220903B (en) | Power accident visual analysis system and method based on knowledge graph | |
US20110258007A1 (en) | Data subscription | |
Su et al. | Applying Cloud Computing and Internet of Things Technologies to Develop a Hydrological and Subsidence Monitoring Platform. | |
CN118657418A (en) | A multi-source information fusion evaluation system for water conservancy scientific and technological achievements | |
CN107403257A (en) | One kind production basic data index analysing system | |
CN112231301A (en) | Yellow river water sand change 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 |