A method and device for rapid integration of exploration data based on bidirectional cascade

Abstract

The present invention discloses a method and device for rapid integration of exploration data based on bidirectional cascades. The method comprises the following steps, performed in sequence: S1. Initializing a seismic exploration database to obtain a metamodel of a table model; S2. Dynamically customizing SQL language based on the metamodel to obtain a table data model; S3. Abstracting the topological relationships between the table data models into a directed graph; S4. Calculating the connected components of the directed graph; S5. Bidirectional cascade traversal based on the directed graph; and S6. Merging and storing traversal paths. Through dynamic data control of the metamodel and data access via the directed graph, the present invention achieves rapid integration of historical seismic exploration data and can dynamically adapt to changes in table models, resolving the issues of multi-version data type coupling and data storage disruption.

Description

Technical Field

[0001] The present 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 Corporation has become the world's largest exploration company, but its primary business is seismic data acquisition, while seismic exploration digitization is primarily dominated by foreign oilfield service companies. Domestic oilfield service companies are vigorously developing digital oil and gas field exploration and accelerating the digital transformation deployment of major domestic oil and gas fields. Faced with the accumulation of multiple versions of basin-level seismic exploration data over the years, a data consolidation and merging solution is urgently needed to achieve rapid data integration and standardized storage.

[0003] When data integration operations are required for data migration and upgrades, 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 organized. For example, for a survey line, not only must the downstream shot lines, receiving lines, and seismic data be packaged, but also the upstream work area and grid data. During the data packaging process, objective operations require data integration from the upper level to the lower level, or from the lower level to the upper level, or from some intermediate level to the lower level. Therefore, the integration of massive seismic exploration data at the oilfield basin level requires a bidirectional, cascaded data integration method and device.

[0004] During the migration and upgrade of massive seismic exploration data at the oilfield basin level, the use of migration tools provided by database vendors, such as exp and imp, has significant shortcomings: first, the purely manual approach leads to low efficiency and a very high error rate; second, it cannot provide migration of cascaded data (the connection formed between 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 for data integration and packaging. GEDO relies on the data model and solidifies multidisciplinary data and the relationships between data in the program, resulting in a strong coupling relationship between persistent object classes and persistent storage fields. It only defines the mapping between relationships for some key data, 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] Kunlun Digital Intelligence and Schlumberger's digitalization technology is significantly superior to GeoEast's data management system, but their data integration methods may also cause data type coupling and mutual disruption of 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, so as to solve the problem of coupling of multiple versions of 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:

[0010] A method for rapid integration of exploration data based on bidirectional cascade includes the following steps performed in sequence:

[0011] S1. Initialize the seismic exploration database and obtain the meta-model of the table model;

[0012] S2. Dynamically customize SQL language based on the metamodel to obtain the model of table data;

[0013] S3. Abstract the topological relationship between the models of the table data into a directed graph;

[0014] S4. Calculate the connected components of the directed graph;

[0015] S5. Bidirectional cascade traversal based on directed graph;

[0016] S6. Merge and store traversal paths.

[0017] As a limitation, step S1 specifically includes:

[0018] 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, use the database's SCHEMA as the smallest unit and the table as the expression individual, and obtain the meta-model set of the table model under the database SCHEMA.

[0019] As another limitation, step S2 specifically includes:

[0020] The metamodel of the table model 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.

[0021] As a third limitation, step S3 specifically includes:

[0022] According to the meta-model 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.

[0023] As a fourth limitation, step S4 specifically includes:

[0024] 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.

[0025] As a fifth limitation, step S5 specifically includes:

[0026] Perform breadth traversal on the edges in the forward graph to obtain the node with the largest maximum connected component value on the directed graph node, splice SQL statements according to the metamodel, read data in sequence, and generate an export file in XML format; perform reverse traversal on the reverse graph to obtain the node with the smallest maximum connected component value on the directed graph node, splice SQL statements according to the metamodel, read data in sequence, and generate an export file in XML format.

[0027] As a sixth limitation, step S6 specifically includes:

[0028] Traverse the data path, check the topology rules, determine the topological relationship of the data path, traverse the data type and data storage location based on 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.

[0029] The present invention also discloses a device for rapid integration of exploration data based on bidirectional cascade, comprising:

[0030] The meta-model acquisition module is used to initialize the seismic exploration database and obtain the meta-model of the table model;

[0031] The data reading module is used to dynamically customize the SQL language based on the meta-model and obtain the model of table data;

[0032] The directed graph acquisition module is used to abstract the topological relationship between the models of table data into a directed graph;

[0033] A connected component calculation module, used to calculate the connected components of a directed graph;

[0034] Data traversal module, used for bidirectional cascade traversal based on directed graph;

[0035] Data integration module, used for traversal path merging and storage.

[0036] Due to the adoption of the above technical solution, the present invention has the following technical advancements compared with the prior art:

[0037] ① The present invention provides a method and device for rapid integration of exploration data based on bidirectional cascades. Through dynamic data control of metamodels and data access based on directed graphs, it offers a universal solution for seismic exploration data integration. This method flexibly solves the problems of data reading and bidirectional cascade integration, dynamically adapts to changes in data models, and provides secure and reliable upgrade and migration operations for multiple versions of seismic exploration data, greatly improving the security and robustness of data in large-scale seismic exploration systems.

[0038] ② The present invention provides a method and device for rapid integration of exploration data based on bidirectional cascade. This method 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 fixing SQL scripts in the program based on version numbers, this method and device are more convenient and flexible to use, reducing the workload of data administrators in daily data management and error query, and improving work efficiency and data reliability.

[0039] ③ The method and device for rapid integration of exploration data based on bidirectional cascade provided by the present invention are applicable to all current exploration data types based on GeoEast. When using data, application modules can directly access the data without any optimization or modification, greatly saving development costs.

[0040] ④ The method and device for rapid integration of exploration data based on bidirectional cascade provided by the present invention realize the standardized integration of processing and interpretation data, and thus can realize the upgrade, migration and management of massive data. Therefore, it can quickly and accurately empower the relevant data of the exploration business segment, and provide a possibility for the multidisciplinary data management system to better adapt to overseas markets and expand the application market such as data services and data management. It can strengthen the combination of digital oil and gas fields and exploration and production applications, and form a multidisciplinary seismic exploration digital integration technology with industry competitiveness.

[0041] ⑤ 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, stratum, 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 technological gap, and effectively enhancing the competitiveness of international seismic exploration digitalization business.

[0042] The present invention realizes the rapid integration of historical seismic exploration data through dynamic control of the meta-model 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

[0043] Figure 1 is a flowchart of steps in an embodiment of the present invention;

[0044] Figure 2 is a schematic diagram of the order of obtaining the metamodel of a table model from a database in an embodiment of the present invention;

[0045] Figure 3 Schematic diagram of the storage order and format of the metamodel in an embodiment of the present invention;

[0046] Figure 4 is a schematic diagram of a metamodel storage structure unit in an embodiment of the present invention;

[0047] Figure 5 It is an instantiated SQL script template in the embodiment of the present invention;

[0048] Figure 6 is a schematic diagram of a directed graph in an embodiment of the present invention;

[0049] 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;

[0050] Figure 8 This is the integration order of the seismic data volume header data in the embodiment of the present invention;

[0051] Figure 9 is a forward traversal directed graph in an embodiment of the present invention;

[0052] Figure 10 It is a directed graph traversed in reverse in an embodiment of the present invention. DETAILED DESCRIPTION

[0053] The present invention will be further described in detail below by way of specific examples. It should be understood that the described examples are only used to illustrate the present invention and are not intended to limit the present invention.

[0054] Embodiment A method and device for rapid integration of exploration data based on bidirectional cascade

[0055] 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 meta-model 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:

[0056] S1. Initialize the seismic exploration database and obtain the meta-model of the table model

[0057] 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.

[0058] Connect to the seismic exploration database server and obtain the server's port number, IP address, database name, and user password, such as Figure 2 As shown, the metamodel of the specified database table model obtains the sequential baseline for traversal: schema-tables set–describes set–correlation set;

[0059] The acquired information is stored in a file according to the XML table.

[0060] 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 description information of the data model for the fields in the label.

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

[0062] For example, a standard data table set is called catalog, which contains well curves and well tracks. A standard data table set also has primary keys (pk), indexes (index), and foreign keys (fk). The structure of a standard data table set is: set O (s:catalog; t:cruve,track; d:pk,index; c:fk).

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

[0064] S2. Dynamically customize SQL language based on the metamodel to obtain the model of table data

[0065] Use the metamodel set in step S1 for mapping and maintain the topological relationship of the metamodel, including tables, columns, primary keys, external keys and unique keys; 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 to obtain the values ​​corresponding to s, t, d, and c of the O structure. 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 addition, deletion, modification, and query are created. The 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 curve and well track. Then, scripts for addition, deletion, modification, and query of well, curve, and track can be generated.

[0066] 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 persistence class through the metamodel.

[0067] S3. Abstract the topological relationship between table data models into a directed graph

[0068] 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.

[0069] First, two directed graphs are constructed based on the meta-model, one is a forward graph representing the forward reference relationship, and the other is a reverse graph representing the reverse referenced relationship. The data model of the directed graph table 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 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.

[0070] S4. Calculate the connected components of the directed graph and set the response value

[0071] 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, with the forward direction being "+" and the reverse direction being "-"; 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.

[0072] S5. Bidirectional cascade traversal based on directed graph

[0073] Bidirectional cascade traversal: that is, forward and reverse traversal of a 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.

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

[0075] First, according to Figure 9 Perform breadth traversal on the edges in the forward graph shown, obtain the node with the largest maximum connected component value on the directed graph node, splice SQL statements according to the metamodel, read data in sequence, and generate an export file in XML format;

[0076] Then, according to Figure 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, and SQL statements are spliced ​​according to the metamodel to read the data in sequence to generate an export file in XML format.

[0077] S6. Traversal path merging and storage

[0078] Traverse the data path, check the topology rules, determine the topological relationship of the data path, traverse the data type and data storage location based on 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, 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 the 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; The step S4 specifically includes: In a directed graph, if a spatial point 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; The step S5 specifically includes: Perform breadth traversal on the edges in the forward graph to obtain the node with the largest maximum connected component value on the directed graph node, splice SQL statements according to the metamodel, read data in sequence, and generate an export file in XML format; perform reverse traversal on the reverse graph to obtain the node with the smallest maximum connected component value on the directed graph node, splice SQL statements according to the metamodel, read data in sequence, and generate an export file in XML format.

2. The method for rapid integration of exploration data based on bidirectional cascade according to claim 1, 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, use the database's SCHEMA as the smallest unit and the table as the expression individual, and obtain the meta-model set of the table model under the database SCHEMA.

3. The method for rapid integration of exploration data based on bidirectional cascade according to claim 1, characterized in that: The step S2 specifically includes: Use the metamodel for mapping and maintain the topological relationship of the metamodel, including tables, columns, primary keys, foreign keys, and unique keys; perform SQL instantiation based on the unique key value defined by the table name, create a set of SQL statement scripts, and dynamically customize SQL statements 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, 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 table model and spatial objects of the directed graphs 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, 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 based on 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.

6. A device for rapid integration of exploration data based on bidirectional cascade, characterized in that: include: The meta-model acquisition module is used to initialize the seismic exploration database and obtain the meta-model of the table model; The data reading module is used to dynamically customize the SQL language based on the meta-model 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 a directed graph; Data traversal module, used for bidirectional cascade traversal based on directed graph; Data integration module, used for merging and storing traversal paths; The specific operation of calculating the connected components of the directed graph is: if a spatial point in the directed graph has a relationship with other spatial objects, the connected components of the spatial point are increased by 1; If the traversal process is directional, set the direction value in the connected component; select the vertex of the directed graph as the root node, and calculate the maximum connected component and the maximum connected component in-degree and out-degree of this root node; The bidirectional cascade traversal based on the directed graph specifically operates as follows: performing breadth traversal according to the edges in the forward graph, obtaining the node with the largest maximum connected component value on the directed graph node, splicing SQL statements according to the metamodel, reading data in sequence, and generating an export file in XML format; performing reverse traversal according to the reverse graph, obtaining the node with the smallest maximum connected component value on the directed graph node, splicing SQL statements according to the metamodel, reading data in sequence, and generating an export file in XML format.

Images