Reverse generation-based oil-gas exploration data transfer method, equipment and medium

Abstract

The invention belongs to the technical field of oil-gas exploration data management, and particularly discloses an oil-gas exploration data unloading method and device based on reverse generation and a medium. The method disclosed by the invention comprises the following steps: firstly, acquiring a physical storage position of data to be transferred out; then, acquiring a data name and a data attribute of the data to be transferred out by utilizing a reverse generation technology; then, establishing a data channel, converting the to-be-transferred data into to-be-transferred data, and storing the to-be-transferred data into a transfer library; then, acquiring corresponding data of the to-be-transferred data by using the method; and finally, establishing a data channel, converting the data format of the to-be-transferred data into the data format of the to-be-transferred data in the oil-gas exploration storage system, and storing the to-be-transferred data in the oil-gas exploration storage system. According to the invention, conversion and sharing between oil and gas data can be realized, and the problems of poor oil and gas data compatibility and difficulty in data sharing are solved. The method can be widely applied to conversion and sharing between oil and gas data.

Description

Technical Field

[0001] The present invention belongs to the technical field of oil and gas exploration data management, and in particular relates to a method, device and medium for transferring oil and gas exploration data based on reverse generation. Background Art

[0002] Data collection in the field of oil and gas exploration will generate a variety of data. Due to the different hardware used for data collection and the different software manufacturers and software versions that match the hardware, oil and gas exploration data will have problems such as poor compatibility, difficulty in data sharing, serious data silos, and difficulty in backing up and migrating data.

[0003] Due to differences in the equipment, methods, and data formats used in the collection and processing of oil and gas exploration data, data from different sources are difficult to be compatible when integrated. This is mainly reflected in the inconsistency of data formats, coding, units, etc., which creates obstacles in data exchange and sharing. Data between different institutions or teams cannot be shared directly, and cumbersome data conversion and format adjustment are required, which not only increases work costs but also reduces the efficiency of data sharing. Since the various data storage systems cannot be effectively connected, data islands are formed, which limits the comprehensive analysis and application of data and affects the accuracy and efficiency of oil and gas exploration. When performing data backup and migration, it is necessary to consider multiple data formats and storage methods. Loss and errors may occur during the migration process, which increases the complexity and cost of backup and affects the integrity and accuracy of the data. Therefore, there is an urgent need to establish a transfer repository between various data storage systems to achieve data interoperability between different data storage systems. Summary of the invention

[0004] The purpose of the present invention is to provide a method for transferring oil and gas exploration data based on reverse generation, which can realize the conversion and sharing of different oil and gas exploration data, and solve the problems of inconsistent data definition, poor data compatibility and difficulty in data sharing in the existing data. The second object of the present invention is to provide a terminal device, which can implement a method for transferring oil and gas exploration data based on reverse generation when executing its own program; The third object of the present invention is to provide a computer-readable storage medium for storing a corresponding computer program for a method for transferring oil and gas exploration data based on reverse generation.

[0005] In order to achieve the above object, the technical solution adopted by the present invention is as follows: A method for transferring oil and gas exploration data based on reverse generation includes the following steps performed in sequence: S1. Obtaining the physical storage location of the first oil and gas exploration storage system where the data to be transferred is located in the device; S2. parse the metadata of the first oil and gas exploration storage system by reverse generation technology to obtain its system name and system number in the device; S3, based on the parsing result of step S2, using the reverse generation technology to obtain the structured meta information of the data to be transferred in the first oil and gas exploration storage system, including the data name and data attributes, wherein the data attributes include the field name and the data type; S4. Building a data channel between the first oil and gas exploration storage system and the transfer repository, converting the data format of the data to be transferred out into an intermediate standardized data format applicable to the transfer repository, generating the data to be transferred in, and storing it in the transfer repository; S5, obtaining the physical storage location of the oil and gas exploration storage system to which the data to be transferred is to be transferred in the device; S6. Reversely analyze the metadata to be transferred to the oil and gas exploration storage system through reverse generation technology to obtain its system name and system number in the device; S7, based on step S6, using reverse generation technology to obtain structured meta information of the data to be transferred in the oil and gas exploration storage system to be transferred, including data name and data attributes, wherein the data attributes include field name and data type; S8. Establish a data channel between the transfer repository and the oil and gas exploration storage system to be transferred, convert the intermediate standardized data format applicable to the transfer repository into the data format of the oil and gas exploration storage system to be transferred, and store it in the oil and gas exploration storage system to be transferred.

[0006] As a limitation, the fields involved in the data to be transferred in step S3 include: field collection, data processing, geological interpretation and well logging.

[0007] As a second limitation, the data format of the first oil and gas exploration storage system, the intermediate standardized data format, and the data format to be transferred to the oil and gas exploration storage system are all different.

[0008] As a third limitation, the number of oil and gas exploration storage systems to be transferred is at least one.

[0009] As a fourth limitation, before building the data channel in step S4 and step S8, it is necessary to conduct keyword search and analysis to establish a mapping relationship between data.

[0010] As a further limitation, the mapping relationship includes a mapping relationship between a data name in an oil and gas exploration storage system and a data name in an intermediate standard data format, and a data attribute mapping relationship.

[0011] As a further limitation, the data attribute mapping relationship includes a field name mapping relationship and a data type mapping relationship.

[0012] A terminal device includes a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the above-mentioned method for transferring oil and gas exploration data based on reverse generation is implemented.

[0013] A computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, it is used to implement the above-mentioned oil and gas exploration data transfer method based on reverse generation.

[0014] Due to the adoption of the above technical solution, the present invention has the following technical advances compared with the prior art: (1) The method of the present invention obtains the data type of oil and gas exploration data through reverse generation technology, and realizes the conversion and transmission of oil and gas exploration data between different storage systems through the transfer library, which is conducive to the compatibility and data sharing of oil and gas exploration data; (2) In the method of the present invention, the transfer repository can correspond to multiple different oil and gas exploration data storage systems, and can store data from different oil and gas exploration data storage systems, and can also transfer the stored data to the corresponding oil and gas exploration data storage systems, thereby improving the flexibility of data transfer.

[0015] The invention belongs to the technical field of oil and gas exploration data management, can realize the conversion and sharing between different oil and gas exploration data, and solve the problems of inconsistent existing data definition, poor data compatibility, and difficulty in data sharing. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] The accompanying drawings are used to provide further understanding of the present invention and constitute a part of the specification. They are used to explain the present invention together with the embodiments of the present invention and do not constitute a limitation of the present invention.

[0017] In the attached picture: Figure 1 This is a flow chart of a method for transferring oil and gas exploration data based on reverse generation according to Example 1 of the present invention. DETAILED DESCRIPTION

[0018] The preferred embodiments of the present invention are described below in conjunction with the accompanying drawings. It should be understood that the preferred embodiments described herein are only used to illustrate and explain the present invention, and are not used to limit the present invention.

[0019] Example 1 This embodiment is a method for transferring oil and gas exploration data based on reverse generation, which is used to realize data transfer between two different oil and gas exploration storage systems. The method takes work area data as an example. Figure 1 As shown, the following steps are performed in sequence: S1. Obtain the physical storage location of the first oil and gas exploration storage system where the data to be transferred is located in the device.

[0020] The data to be transferred include: field collection, data processing, geological interpretation and well logging. In this embodiment, the data to be transferred are the coordinates of the four points A, B, C and D in the work area data, and the storage location of the work area data is determined to be in the GM_SURVEY table of the first oil and gas exploration storage system.

[0021] S2. parse the metadata of the first oil and gas exploration storage system through reverse generation technology to obtain its system name and system number in the device.

[0022] After obtaining the system name and system number, the results need to be stored in the system information data structure.

[0023] S3. Based on the parsing result of step S2, the structured meta-information of the data to be transferred out in the first oil and gas exploration storage system is obtained by using the reverse generation technology, including the data name and data attributes, wherein the data attributes include the field name and the data type.

[0024] When processing data from an oil and gas exploration storage system, the reverse generation technology needs to parse the metadata, configuration information, or database structure of the storage system to extract the required information. The extracted information also needs to be stored in the system information data structure. When using the reverse generation technology, you need to first create an xml file, configure the database connection information, the target package name, and the table name for the code to be generated, and then use the plug-in to run the reverse generation process. In this embodiment, the first oil and gas exploration storage system is a Soft system with a version of 1.0.0.

[0025] S4. Build a data channel between the first oil and gas exploration storage system and the transfer repository, convert the data format of the data to be transferred out into an intermediate standardized data format suitable for the transfer repository, generate the data to be transferred in and store it in the transfer repository.

[0026] The data channel is built by keyword retrieval and analysis to establish mapping relationships between data. The mapping relationships include the mapping relationship between data names in the oil and gas exploration storage system and data names in the intermediate standard data format, as well as data attribute mapping relationships. The data attribute mapping relationship includes field name mapping relationships and data type mapping relationships.

[0027] The basis for establishing the mapping relationship is the standard model keyword correspondence table, and each word in the standard model corresponds to one and not limited to one search keyword.

[0028] The program searches for words with the same semantics in the search keywords through the names in the oil and gas exploration storage system. If there are matching keywords, the mapping relationship between the names in the standard model and the names in the oil and gas exploration storage system is established through the standard model keyword correspondence table.

[0029] If there is no matching keyword, the program will tell the user the name in the oil and gas exploration storage system in the form of output. If the name has a corresponding word in the standard model, a relationship is established in the keyword correspondence table. If the name does not exist in the standard model, the data or attributes corresponding to the name are added to the standard model, and a corresponding relationship is established in the keyword correspondence table.

[0030] The mapping relationship in building the data channel is as follows: SURVEY Soft , 1.0.0 , GM_SURVEY NAME, STRING SURVEY_NAME, STRING, Soft, 1.0.0 X1,DOUBLE AX,DOUBLE,Soft,1.0.0 Y1, DOUBLE AY,DOUBLE,Soft,1.0.0 X2,DOUBLE BX,DOUBLE,Soft,1.0.0 Y2, DOUBLE BY,DOUBLE,Soft,1.0.0 X3,DOUBLE CX,DOUBLE,Soft,1.0.0 Y3, DOUBLE CY,DOUBLE,Soft,1.0.0 X4,DOUBLE DX,DOUBLE,Soft,1.0.0 Y4, DOUBLE DX,DOUBLE,Soft,1.0.0.

[0031] S5. Obtain the physical storage location of the oil and gas exploration storage system to which the data to be transferred is to be transferred in the device.

[0032] S6. Reversely analyze the metadata to be transferred to the oil and gas exploration storage system through reverse generation technology to obtain its system name and system number in the device.

[0033] S7. Based on step S6, use reverse generation technology to obtain structured meta-information of the data to be transferred in the oil and gas exploration storage system to be transferred, including data name and data attributes, wherein the data attributes include field name and data type.

[0034] S8. Establish a data channel between the transfer repository and the oil and gas exploration storage system to be transferred, convert the intermediate standardized data format of the data to be transferred in the transfer repository into the data format of the oil and gas exploration storage system to be transferred, and store it in the oil and gas exploration storage system to be transferred.

[0035] The data channel is built by keyword retrieval and analysis to establish the mapping relationship between data. The mapping relationship includes the mapping relationship between the data name in the oil and gas exploration storage system and the data name in the intermediate standard data format, as well as the data attribute mapping relationship. The data attribute mapping relationship includes the field name mapping relationship and the data type mapping relationship.

[0036] The data format of the transfer repository is different from the data format of the first oil and gas exploration storage system and the data format of the oil and gas exploration storage system to be transferred in. The transfer repository can correspond to multiple oil and gas exploration storage systems to be transferred in.

[0037] In summary, this embodiment obtains the data type of oil and gas exploration data through the reverse generation technology, and realizes the conversion and transmission of oil and gas exploration data between different storage systems through the transfer library, which is conducive to the compatibility and data sharing of oil and gas exploration data.

[0038] Example 2 This embodiment is a terminal device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, it is used to implement a method for transferring oil and gas exploration data based on reverse generation in Embodiment 1.

[0039] Example 3 This embodiment is a computer-readable storage medium. The computer-readable storage medium in this embodiment stores a computer program. When the computer program is executed by a processor, it is used to implement a reverse-generated oil and gas exploration data transfer method in embodiment 1.

[0040] Among them, the computer-readable storage medium can be a computer storage medium or a communication medium. The communication medium includes any medium that facilitates the transmission of a computer program from one place to another. The computer storage medium can be any available medium that can be accessed by a general-purpose or special-purpose computer. For example, a computer-readable storage medium is coupled to a processor so that the processor can read information from the computer-readable storage medium and write information to the computer-readable storage medium. Of course, the computer-readable storage medium can also be a component of the processor. The processor and the computer-readable storage medium can be located in an application-specific integrated circuit (ASIC). In addition, the ASIC can be located in a user device. Of course, the processor and the computer-readable storage medium can also exist in a communication device as discrete components. Specifically, the computer-readable storage medium can be implemented by any type of volatile or non-volatile storage device or a combination thereof, such as a static random access memory (SRAM), an electrically erasable programmable read-only memory (EEPROM), an erasable programmable read-only memory (EPROM), a programmable read-only memory (PROM), a read-only memory (ROM), a magnetic memory, a flash memory, a magnetic disk or an optical disk, etc. The storage medium can be any available medium that can be accessed by a general-purpose or special-purpose computer.

Claims

1. A method for transferring oil and gas exploration data based on reverse generation, characterized in that: The process includes the following steps: S1. Obtaining the physical storage location of the first oil and gas exploration storage system where the data to be transferred is located in the device; S2. parse the metadata of the first oil and gas exploration storage system by reverse generation technology to obtain its system name and system number in the device; S3, based on the parsing result of step S2, using the reverse generation technology to obtain the structured meta information of the data to be transferred in the first oil and gas exploration storage system, including the data name and data attributes, wherein the data attributes include the field name and the data type; S4. Building a data channel between the first oil and gas exploration storage system and the transfer repository, converting the data format of the data to be transferred out into an intermediate standardized data format applicable to the transfer repository, generating the data to be transferred in, and storing it in the transfer repository; S5, obtaining the physical storage location of the oil and gas exploration storage system to which the data to be transferred is to be transferred in the device; S6. Reversely analyze the metadata to be transferred to the oil and gas exploration storage system through reverse generation technology to obtain its system name and system number in the device; S7, based on step S6, using reverse generation technology to obtain structured meta information of the data to be transferred in the oil and gas exploration storage system to be transferred, including data name and data attributes, wherein the data attributes include field name and data type; S8. Establish a data channel between the transfer repository and the oil and gas exploration storage system to be transferred, convert the intermediate standardized data format applicable to the transfer repository into the data format of the oil and gas exploration storage system to be transferred, and store it in the oil and gas exploration storage system to be transferred.

2. The method for transferring oil and gas exploration data based on reverse generation according to claim 1, characterized in that: The fields involved in the data to be transferred in step S3 include: field collection, data processing, geological interpretation and well logging.

3. The method for transferring oil and gas exploration data based on reverse generation according to claim 1 is characterized in that: The data format of the first oil and gas exploration storage system, the intermediate standardized data format, and the data format to be transferred to the oil and gas exploration storage system are all different.

4. A method for transferring oil and gas exploration data based on reverse generation according to any one of claims 1 to 3, characterized in that: The number of the oil and gas exploration storage systems to be transferred is at least one.

5. The method for transferring oil and gas exploration data based on reverse generation according to claim 1 is characterized in that: Before building the data channel in step S4 and step S8, it is necessary to perform keyword search and analysis to establish a mapping relationship between data.

6. The method for transferring oil and gas exploration data based on reverse generation according to claim 5 is characterized in that: The mapping relationship includes a mapping relationship between a data name in an oil and gas exploration storage system and a data name in an intermediate standard data format, and a data attribute mapping relationship.

7. The method for transferring oil and gas exploration data based on reverse generation according to claim 6 is characterized in that: The data attribute mapping relationship includes a field name mapping relationship and a data type mapping relationship.

8. A terminal device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the method for transferring oil and gas exploration data based on reverse generation as described in any one of claims 1 to 7 is implemented.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, it is used to implement the oil and gas exploration data transfer method based on reverse generation as described in any one of claims 1 to 7.

Images