Method and device for rapidly integrating exploration data based on bidirectional cascading

By adopting a two-way cascade method in massive seismic exploration data at the oil field basin level, dynamic control of meta-model and directed graph access, the inefficiency and data integrity problems in the existing technology are solved, and efficient and safe data integration and migration are achieved. , improves the data management capabilities of oil field basins.

CN119003557AActive Publication Date: 2024-11-22CHINA NAT PETROLEUM CORP +2

Patent Information

Application Number
CN202310555655.4
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2023-05-17
Publication Date
2024-11-22
Estimated Expiration
2043-05-17

AI Technical Summary

Technical Problem

The prior art is inefficient and has high error rates during the migration and upgrading of massive seismic exploration data at the oil field basin level, and the effective migration of cascading data cannot be achieved, resulting in data integrity and security issues.

Method used

Using a two-way cascade-based method, the meta-model of the table is initialized, the SQL language is dynamically customized, directed graphs are abstracted, connected components are calculated, and bidirectional cascade traversal and path merging are performed to achieve rapid data integration. .

Benefits of technology

It improves the efficiency and security of data integration, reduces the error rate, adapts to changes in multiple versions of data, realizes standardized integration and reliability of data, and enhances the competitiveness of large-scale seismic exploration systems.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119003557A_ABST
    Figure CN119003557A_ABST
Patent Text Reader

Abstract

The invention discloses a method and device for rapidly integrating exploration data based on bidirectional cascading, and the method comprises the following steps: S1, initializing a seismic exploration database, and obtaining a meta-model of a model of a table; s2, dynamically customizing an SQL (Structured Query Language) based on the meta-model, and obtaining a model of S3, abstracting a directed graph from the topological relation between the models of the table data; s4, calculating a connected component of the directed graph; s5, bidirectional cascade traversal based on the directed graph is carried out; and S6, merging and storing traversal paths. Through data dynamic control of the meta-model and data access of the directed graph, rapid integration of historical seismic exploration data is realized, change of the table model can be dynamically adapted, and the problem of mutual disturbance of multi-version data type coupling and data storage is solved.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention belongs to the technical field of seismic exploration data management, and relates to a method for rapid integration of exploration data, in particular to a method and device for rapid integration of exploration data based on bidirectional cascade. Background Art

[0002] Oriental Geophysical Company has become the world's largest exploration company, but its main business is seismic data acquisition, while seismic exploration digitalization business is mainly dominated by foreign oil service companies. Domestic oil service companies are vigorously developing digital oil and gas field exploration business, and are also accelerating the digital transformation deployment of major domestic oil and gas fields. Faced with the basin-level multi-version seismic exploration data accumulated over the years, there is an urgent need for a data sorting and merging solution that can achieve rapid data integration and standardized storage.

[0003] When data integration operations are required for data migration and upgrading, in order to ensure data integrity, the associated data downstream of the specified data must be integrated, and the data upstream of the specified data must also be sorted out. For example, for the survey line, not only the downstream shot lines, receiving lines, seismic data, etc. of the survey line must be packaged, but also the upstream work area, grid data, etc. must be packaged. In the process of data packaging, objective operations require the superior to the subordinate, or it may be necessary to sort from the subordinate to the superior, or to start data sorting from a certain level in the middle to the subordinate. Therefore, in the process of integrating massive seismic exploration data at the oilfield basin level, a two-way, cascaded data integration method and device are required.

[0004] In the process of migrating and upgrading massive seismic exploration data at the oilfield basin level, the migration tools provided by database vendors, such as exp and imp, have great shortcomings: first, the purely manual method leads to low efficiency and a very high error rate; second, it cannot provide cascade data migration (the connection formed by the migrated data and all related data).

[0005] The current mainstream ideas of industry software at home and abroad are: 1. Kunlun Digital Intelligence: a control method based on EPDM model changes; 2. Schlumberger Petrel: a control method based on file versions; 3. GeoEast: a version control method for solidified model foreign keys.

[0006] Among them, the GeoEast system developed the GEDO layer to integrate and package data. GEDO is attached to the data model, solidifying multidisciplinary data and the relationship between data in the program, resulting in a strong coupling relationship between the persistent object class and the persistent storage field, and only defining the mapping between relationships for some key data. It cannot guarantee data completeness, has great limitations on applications after data migration, and is likely to endanger the security and reliability of the overall data.

[0007] The digitalization technologies of Kunlun Digital Intelligence and Schlumberger are obviously superior to GeoEast's data management system, but their data integration methods may also lead to data type coupling and mutual interference with data storage when managing multi-version data and integrating multi-disciplinary data. Summary of the invention

[0008] The purpose of the present invention is to provide a method and device for rapid integration of exploration data based on bidirectional cascade to solve the problem of coupling of multi-version data types and mutual interference of data storage.

[0009] In order to achieve the above object, the technical solution adopted by the present invention is: A method for rapid integration of exploration data based on bidirectional cascade includes the following steps performed in sequence: S1. Initialize the seismic exploration database and obtain the meta-model of the table model; S2. Dynamically customize SQL language based on the metamodel to obtain the model of table data; S3. Abstract the topological relationship between the models of table data into a directed graph; S4. Calculate the connected components of the directed graph; S5. Bidirectional cascade traversal based on directed graph; S6. Merge and store traversal paths.

[0010] As a limitation, the step S1 specifically includes: Connect to the seismic exploration database server, obtain the server's port number, IP address, database name and user password, traverse the database's data dictionary, take the database's SCHEMA as the smallest unit and the table as the individual expression, and obtain the meta-model set of the table model under the database SCHEMA.

[0011] As another limitation, step S2 specifically includes: The metamodel of the table model is used for mapping, and the topological relationship of the metamodel is maintained, including tables, columns, primary keys, foreign keys, and unique keys. SQL is instantiated according to the unique key value defined by the table name, a set of SQL statement scripts is created, and SQL statements are dynamically customized through the metamodel to read associated data. The results returned by the SQL statements are dynamically loaded into the persistence class through the metamodel.

[0012] As a third limitation, the step S3 specifically includes: According to the metamodel of the table model, two directed graphs are constructed, a forward graph representing the forward reference relationship and a reverse graph representing the reverse referenced relationship. The table model and spatial objects of the directed graphs are defined, actual data types are associated with the spatial objects, and topological relationships with practical significance are defined.

[0013] As a fourth limitation, the step S4 specifically includes: If a spatial point in a directed graph has a relationship with other spatial objects, the connected component of the spatial point is increased by 1; if the traversal process is directional, the direction value is set in the connected component; the vertex of the directed graph is selected as the root node, and the maximum connected component and the maximum connected component in-degree and out-degree of this root node are calculated.

[0014] As a fifth limitation, the step S5 specifically includes: Perform breadth traversal according to the edges in the forward graph, obtain the node with the largest maximum connected component value on the directed graph node, splice SQL statements according to the metamodel, read the data in sequence, and generate an export file in xml format; perform reverse traversal according to the reverse graph, obtain the node with the smallest maximum connected component value on the directed graph node, splice SQL statements according to the metamodel, read the data in sequence, and generate an export file in xml format.

[0015] As a sixth limitation, the step S6 specifically includes: Traverse the data path, check the topology rules, determine the topological relationship of the data path, traverse the data type and data storage location according to the topological relationship, merge all traversal paths to generate an export path, package and integrate the data according to the export path to form a data packet / stream.

[0016] The present invention also discloses a device for rapid integration of exploration data based on bidirectional cascade, comprising: A meta-model acquisition module is used to initialize the seismic exploration database and acquire the meta-model of the table model; The data reading module is used to dynamically customize the SQL language based on the metamodel and obtain the model of table data; The directed graph acquisition module is used to abstract the topological relationship between the models of table data into a directed graph; A connected component calculation module, used to calculate the connected components of the directed graph; Data traversal module, used for bidirectional cascade traversal based on directed graph; Data integration module, used for traversal path merging and storage.

[0017] Due to the adoption of the above technical solution, the present invention has the following technical advances compared with the prior art: ① The present invention provides a method and device for rapid integration of exploration data based on bidirectional cascade, which provides a universal seismic exploration data integration solution through dynamic data control of metamodel and data access of directed graph, flexibly solves the problems of data reading and bidirectional cascade integration, and can dynamically adapt to the change of data model, providing safe and reliable upgrade and migration operations for multiple versions of seismic exploration data, greatly improving the security and robustness of data in large seismic exploration systems; ② The present invention provides a method and device for rapid integration of exploration data based on bidirectional cascade, which controls multiple versions of historical seismic exploration data through a metamodel, and assembles SQL scripts for read and write access through SQL customization. Compared with the method of solidifying SQL scripts in the program based on version numbers, this method and device are more convenient and flexible to use, can reduce the workload of data administrators in daily data management and error query, and improve work efficiency and data reliability; ③ The method and device for rapid integration of exploration data based on bidirectional cascade provided by the present invention are applicable to all types of exploration data currently based on GeoEast. When using data, the application module can directly access the data without any optimization and modification, which greatly saves development costs; ④ The method and device for rapid integration of exploration data based on bidirectional cascade provided by the present invention realizes the standardized integration of processing and interpretation data, and further can realize the upgrade, migration and management of massive data, so that the relevant data of the exploration business segment can be quickly and accurately empowered, which provides a possibility for the multidisciplinary data management system to better adapt to the overseas market and expand the application market such as data service and data management, and can strengthen the combination of digital oil and gas fields and exploration and production applications, forming a multidisciplinary seismic exploration digital integration technology with industry competitiveness; ⑤ The present invention provides a method and device for rapid integration of exploration data based on bidirectional cascade, which integrates multiple versions of bidirectional cascade data, solves the problem of maintaining consistency and integrity during the transmission and migration of multiple types of data such as seismic, stratigraphic, and well data, and provides reliable basic data for subsequent basin-level data management and production, breaking the technology monopoly of foreign companies, filling the technology gap, and effectively enhancing the competitiveness of international seismic exploration digital services.

[0018] The present invention realizes the rapid integration of historical seismic exploration data through dynamic control of the metamodel of the table model and data access of the directed graph, and can dynamically adapt to the changes of the table model, solving the problem of mutual interference between multi-version data type coupling and data storage. BRIEF DESCRIPTION OF THE DRAWINGS

[0019] Figure 1 is a flowchart of steps in an embodiment of the present invention; Figure 2is a schematic diagram of a metamodel sequence for obtaining a table model from a database in an embodiment of the present invention; Figure 3 It is a schematic diagram of the storage order and format of the metamodel in an embodiment of the present invention; Figure 4 is a schematic diagram of a metamodel storage structure unit in an embodiment of the present invention; Figure 5 It is an instantiated SQL script template in the embodiment of the present invention; Figure 6 is a schematic diagram of a directed graph in an embodiment of the present invention; Figure 7 is a schematic diagram of cascade management and integration of seismic data in an embodiment of the present invention, wherein Figure 7 a is the description of the association of seismic data in a directed graph, Figure 7 b is the description of the correlation of seismic data in the model; Figure 8 is the integration order of the seismic data volume header data in the embodiment of the present invention; Fig. 9 is a forward traversal directed graph in an embodiment of the present invention; Fig.10 It is a directed graph traversed in reverse in an embodiment of the present invention. DETAILED DESCRIPTION

[0020] The present invention is further described in detail below by specific examples. It should be understood that the described examples are only used to explain the present invention, and are not intended to limit the present invention.

[0021] Embodiment A method and device for rapid integration of exploration data based on bidirectional cascade This embodiment discloses a method and device for rapid integration of exploration data based on bidirectional cascade, starting from the data type and storage of multidisciplinary seismic exploration data, and realizing rapid integration of seismic exploration data based on metamodel and directed graph. The simplified process of data integration at runtime is as follows: Figure 1 As shown, it specifically includes the following steps performed in sequence: S1. Initialize the seismic exploration database and obtain the meta-model of the table model Metamodel: A model that describes the table model. Extended to the field of seismic exploration database, the so-called metamodel is the definition of database objects, including tables, columns, primary keys, foreign keys, unique keys, etc.

[0022] Connect to the seismic exploration database server and obtain the server's port number, IP address, database name, and user password, such as Figure 2As shown, the metamodel of the specified database table model obtains the sequential baseline for traversal: schema-tables set–describes set–correlation set; The acquired information is stored in a file according to the XML table.

[0023] like Figure 3 As shown, create the root node of xml and create <tables>Label; <tables>Create in tag Tags; in <describes>Tags; in <describes>Create in tag <correlation>Label: Fill in the fields in the label with description information of the data model.

[0024] Based on XML, a four-tuple data model is created to describe the general structure O={s,t,d,c}, which includes four elements: mode (s), table set (t), description set (d) and correlation (c). O is used to describe various types of table models of seismic exploration databases.

[0025] For example, the standard data table set is catalog, and in the set there are well curves, well tracks, and primary keys (pk), indexes (index), and foreign keys (fk). The description structure of the standard data table set is: set O (s: catalog; t: cruve, track; d: pk, index; c: fk).

[0026] Traverse the database data dictionary, take the database SCHEMA as the smallest unit, take the table as the individual, and obtain the storage structure unit such as Figure 4 As shown, the metamodel collection of the table model under the database SCHEMA.

[0027] S2. Dynamically customize SQL language based on metamodel to obtain the model of table data Use the metamodel set in step S1 for mapping, maintain the topological relationship of the metamodel, including table, column, primary key, external key and unique key; read each node of the xml in step S1, and generate the corresponding four-tuple data model to describe the general structure set. Figure 5 As shown, a template for SQL statements is created, the values ​​corresponding to s, t, d, and c of the O structure are obtained, the values ​​are traversed in the order of s, t, d, and c, SQL is instantiated according to the unique key value defined by the table name, a set of SQL statement scripts for adding, deleting, modifying, and querying are created, and SQL statements are dynamically customized through the relevance description character value of the metamodel to perform related data reading operations. For example, the parent table of the exploration well data type is well, and the child tables are well curves and well tracks. Then, scripts for adding, deleting, modifying, and querying wells, curves, and tracks that are interrelated can be generated.

[0028] The SQL statement script can be handed over to the database connection handle, and the query script can be executed through the exec() function. The results returned by the SQL statement are dynamically loaded into the persistent class through the metamodel.

[0029] S3. Abstract the topological relationship between the models of table data into a directed graph Directed graph: Figure 6 As shown, a method of describing the topological relationship between entity objects is abstracted between the models of tables in the database.

[0030] First, two directed graphs are constructed according to the metamodel, a forward graph representing the forward reference relationship and a reverse graph representing the reverse referenced relationship. The data model of the table of the directed graph is defined, and the point, line, and surface structures and the number of node connections are defined. The spatial objects of the directed graph are defined as three basic objects: point object, line object, and surface object. The actual data types are associated with the spatial objects, and the topological relationships with practical significance are defined: point-to-point co-location, adjacency, and inclusion; point-to-line adjacency, intersection, and inclusion; point-to-area adjacency and inclusion; line-to-line adjacency, intersection, and co-location; line-to-area adjacency, intersection, and inclusion; and area-to-area adjacency, intersection, and inclusion.

[0031] S4. Calculate the connected components of the directed graph and set the response value like Figure 7 As shown in the figure, if a spatial point in a directed graph has a relationship with other spatial objects, the connected component of the spatial point is increased by 1; if the traversal process is directional, the direction value is set in the connected component, the positive direction is "+" and the reverse direction is "-"; the vertex of the directed graph is selected as the root node, and the maximum connected component and the maximum connected component in-degree and out-degree of this root node are calculated.

[0032] S5. Bidirectional cascade traversal based on directed graph Bidirectional cascade traversal: that is, forward and reverse traversal of the directed graph, determines the SQL statement for data access based on the point-line-surface relationship and connected components, and merges the export path based on the path of the data type.

[0033] Based on the O standard data table set in step S1, its data connection path is obtained, such as Figure 8 As shown, a certain volume header data of seismic data of Keshen Well in the Tarim Exploration Oil and Gas Basin database under the PG data source is quickly integrated.

[0034] First, according to Fig. 9 The edges in the forward graph shown are traversed in breadth, the node with the largest maximum connected component value on the directed graph node is obtained, SQL statements are spliced ​​according to the metamodel, data is read in sequence, and an export file in xml format is generated; Then, according to Fig.10 The reverse graph shown is traversed in reverse to obtain the node with the smallest maximum connected component value on the directed graph node, SQL statements are spliced ​​according to the metamodel, data is read in sequence, and an export file in XML format is generated.

[0035] S6. Traversal path merging and storage Traverse the data path, check the topology rules, determine the topological relationship of the data path, traverse the data type and data storage location according to the topological relationship, merge all traversal paths to generate an export path, package and integrate the data according to the export path to form a data packet / stream.< / correlation> < / describes> < / describes> Create in tag < / tables> < / tables>

Claims

1. A method for rapid integration of exploration data based on bidirectional cascade, It is characterized in that The process includes the following steps: S1. Initialize the seismic exploration database and obtain the meta-model of the table model; S2. Dynamically customize SQL language based on the metamodel to obtain the model of table data; S3. Abstract the topological relationship between the models of table data into a directed graph; S4. Calculate the connected components of the directed graph; S5. Bidirectional cascade traversal based on directed graph; S6. Merge and store traversal paths.

2. A method for rapid integration of exploration data based on bidirectional cascade according to claim 1, It is characterized in that The step S1 specifically includes: Connect to the seismic exploration database server, obtain the server's port number, IP address, database name and user password, traverse the database's data dictionary, take the database's SCHEMA as the smallest unit and the table as the individual expression, and obtain the meta-model set of the table model under the database SCHEMA.

3. A method for rapid integration of exploration data based on bidirectional cascade according to claim 1, It is characterized in that The step S2 specifically includes: The metamodel is used for mapping to maintain the topological relationship of the metamodel, including tables, columns, primary keys, foreign keys, and unique keys; SQL is instantiated according to the unique key value defined by the table name, a set of SQL statement scripts is created, and SQL statements are dynamically customized through the metamodel to read associated data. The results returned by the SQL statements are dynamically loaded into the persistence class through the metamodel.

4. A method for rapid integration of exploration data based on bidirectional cascade according to any one of claims 1 to 3, It is characterized in that The step S3 specifically includes: According to the meta-model, two directed graphs are constructed, a forward graph representing the forward reference relationship and a reverse graph representing the reverse referenced relationship. The model and spatial objects of the directed graph table are defined, the actual data types are associated with the spatial objects, and the topological relationships with practical significance are defined.

5. A method for rapid integration of exploration data based on bidirectional cascade according to any one of claims 1 to 3, It is characterized in that The step S4 specifically includes: If a spatial point in a directed graph has a relationship with other spatial objects, the connected component of the spatial point is increased by 1; if the traversal process is directional, the direction value is set in the connected component; the vertex of the directed graph is selected as the root node, and the maximum connected component and the maximum connected component in-degree and out-degree of this root node are calculated.

6. A method for rapid integration of exploration data based on bidirectional cascade according to any one of claims 1 to 3, It is characterized in that The step S5 specifically includes: Perform breadth traversal according to the edges in the forward graph, obtain the node with the largest maximum connected component value on the directed graph node, splice SQL statements according to the metamodel, read the data in sequence, and generate an export file in xml format; perform reverse traversal according to the reverse graph, obtain the node with the smallest maximum connected component value on the directed graph node, splice SQL statements according to the metamodel, read the data in sequence, and generate an export file in xml format.

7. A method for rapid integration of exploration data based on bidirectional cascade according to any one of claims 1 to 3, It is characterized in that The step S6 specifically includes: Traverse the data path, check the topology rules, determine the topological relationship of the data path, traverse the data type and data storage location according to the topological relationship, merge all traversal paths to generate an export path, package and integrate the data according to the export path to form a data packet / stream.

8. A device for rapid integration of exploration data based on bidirectional cascade, It is characterized in that include: A meta-model acquisition module is used to initialize the seismic exploration database and acquire the meta-model of the table model; The data reading module is used to dynamically customize the SQL language based on the metamodel and obtain the model of table data; The directed graph acquisition module is used to abstract the topological relationship between the models of table data into a directed graph; A connected component calculation module, used to calculate the connected components of the directed graph; Data traversal module, used for bidirectional cascade traversal based on directed graph; Data integration module, used for traversal path merging and storage.

Citation Information

Patent Citations

  • Data query method and device

    CN108334563A

  • System cascading method, data processing method and device

    CN113987089A

  • Associated data exporting and importing method and device, equipment and storage medium

    CN115905353A

Cited By

  • Bidirectional cascade-based oil-gas exploration data rapid integration method and system

    CN121980206A

  • Method and system for rapid integration of oil and gas exploration data based on bidirectional cascading

    CN121980206B

  • Multi-source data acquisition and storage method, device and equipment based on task encapsulation and storage medium

    CN122652636A