An abstracted geological exploration database form generation method and system

Abstract

The application discloses an abstracted geological exploration database form generation method and system, and relates to the technical field of computers.The technical scheme is as follows: a geological object table is established by taking geological objects as indexes;corresponding data source fields are configured in the geological object table, and an exploration object field is configured; data sources, exploration objects and corresponding geological information are associated, and additional independent fields are configured to record geometric and attribute information of the same geological object collected by different exploration means; a data entry subtable is formed by extracting field combinations associated with exploration means from one or more geological object tables; and the geological object table is connected with a data output interface of an exploration database.The application takes results as a guide, takes geological objects as initial indexes, and takes data obtained by exploration means as data sources of each record in the geological object table, so that the data is associated and stored, the repetition of fields and forms is reduced, and the development and operation efficiency of the database is improved.

Description

Technical Field

[0001] This invention relates to the field of computer technology, and more specifically, to an abstract method and system for generating geological exploration database forms. Background Technology

[0002] Large-scale surveying and design projects often have long construction periods, resulting in a wide variety of survey data and a large volume of data. Under traditional two-dimensional paper-based recording methods, the more thorough the surveying work, the larger the amount of data retained. However, due to poor data readability, this often leads to problems with effective transmission and utilization. As projects progress, misinterpretations of geological data increase, necessitating extensive supplementary exploration or simultaneous exploration and construction. Meanwhile, the emergence of database technology has transformed data management across industries from disorder to order, deepening our understanding of data and continuously improving management methods. With the accelerated adoption of digital information technology in geotechnical investigation within surveying and design units, the geological exploration field urgently needs a professional database management system that meets the requirements of geological data integration and analysis, and can be directly used for geological data statistical analysis, geological standard report output, 3D database generation, and 3D modeling—a system that aligns with the long-term development of the industry.

[0003] Database technology has been widely applied in engineering surveying, with the Lizheng Engineering Surveying Database being the most widely used. However, to date, all exploration databases have adopted a form structure design based on exploration methods as the index, meaning that all forms belong to different exploration methods. This leads to the following problems: 1) Surface surveys, boreholes, adits, wells, pits, and trenches all require separate forms to record the five major geological objects. This results in separate designs for forms recording the same geological object under different exploration methods, leading to a large amount of redundancy in forms recording the same geological object, affecting the efficiency of database development and operation; 2) Not using geological conditions as the index results in fragmented geological exploration data, lacking comparative references, making it impossible to remove erroneous data at the source. Subsequent manual screening from a large amount of data is required, which is labor-intensive and inefficient. Moreover, the lack of comparative references may lead to over- or under-exploration, such as conducting adit excavation when existing borehole data is sufficient to reveal the stratigraphic situation; 3) The existing geological logging database's form structure design based on exploration methods cannot directly extract and analyze data. It requires manual extraction of data and organization according to geological object information, increasing unnecessary processes, time and labor costs, and making it prone to errors.

[0004] Therefore, how to research and design an abstract geological exploration database form generation method and system that can overcome the above-mentioned defects is a problem that we urgently need to solve. Summary of the Invention

[0005] To address the shortcomings of existing technologies, the present invention aims to provide an abstract geological exploration database form generation method and system. This method is result-oriented, using geological objects as initial indexes and data obtained through exploration methods as the data source for each record in the geological object table, storing them in association. This reduces the duplication of fields and forms, and improves the efficiency of database development and operation.

[0006] The above-mentioned technical objective of the present invention is achieved through the following technical solution:

[0007] Firstly, an abstract method for generating geological exploration database forms is provided, including the following steps:

[0008] Establish a one-to-one geological object table indexed by geological objects;

[0009] Configure the corresponding data source field in the geological object table according to different exploration methods as data source methods, and configure the exploration object field to record the specific exploration object of the data source;

[0010] Establish a link between the data source, the exploration object and the corresponding geological information, and configure additional independent fields to record the geometric and attribute information of the same geological object collected by different exploration methods;

[0011] Data entry sub-tables are formed by extracting fields associated with exploration methods from one or more geological object tables and using these sub-tables to differentiate data entry for different exploration methods.

[0012] Establish connections between the geological object table stored in the exploration database and the various data output interfaces reserved in the exploration database to achieve content output in different formats.

[0013] Furthermore, the geological objects include one or more of the following: stratigraphy, geological structure, hydrogeology, physical geology, and topography.

[0014] Furthermore, the exploration methods include one or more of the following: surface survey, drilling, adit, exploratory well, exploratory pit, and exploratory trench.

[0015] Furthermore, when configuring the additional independent fields, similar information from different exploration methods is used together.

[0016] Furthermore, the geological object table is stored in the exploration database in the form of a physical table, and the data entry sub-table is retrieved from the exploration database in the form of a virtual table.

[0017] Furthermore, the geological object table uses a primary index, and the data entry sub-table uses a secondary index;

[0018] When only a first-level index is performed, the index result is a table of geological objects;

[0019] When only a secondary index is performed, the index result is a data entry sub-table corresponding to all geological object tables;

[0020] When both primary and secondary indexes are performed simultaneously, the indexing result is the data entry sub-table corresponding to the geological object table of the corresponding primary index.

[0021] Furthermore, the data reading between the geological object table and the data entry sub-table is implemented using function calls.

[0022] Secondly, an abstract geological exploration database form generation system is provided, including:

[0023] The form creation module is used to create a one-to-one geological object table indexed by geological objects.

[0024] The field configuration module is used to configure the corresponding data source field in the geological object table when different exploration methods are used as data sources, and to configure the exploration object field to record the specific exploration object of the data source;

[0025] The information association module is used to establish a connection between data sources, exploration objects and corresponding geological information, and to configure additional independent fields to record the geometric and attribute information of the same geological object collected by different exploration methods;

[0026] The data entry module is used to extract fields associated with exploration methods from one or more geological object tables to form a data entry sub-table. The data entry sub-table is used to distinguish the data entry of different exploration methods.

[0027] The data output module is used to establish connections between the geological object table stored in the exploration database and various data output interfaces reserved in the exploration database, so as to realize the output of content in different formats.

[0028] Thirdly, a computer terminal is provided, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement an abstract geological exploration database form generation method as described in any one of the first aspects.

[0029] Fourthly, a computer-readable medium is provided having a computer program stored thereon, the computer program being executed by a processor to implement an abstract geological exploration database form generation method as described in any one of the first aspects.

[0030] Compared with the prior art, the present invention has the following beneficial effects:

[0031] 1. The present invention provides an abstract geological exploration database form generation method, which is guided by the geological three-dimensional assignment results, uses five major geological objects as primary indexes, and designs five corresponding tables to solve the problem of repetitive and redundant fields and forms caused by the repeated design of forms for different exploration methods in traditional geological exploration databases, thereby improving the efficiency of database development and operation.

[0032] 2. This invention stores all exploration information obtained by all exploration methods in the same geological object form, avoiding the fragmentation of geological exploration data, facilitating the comparison and elimination of erroneous data based on the generated results, and preventing the problem of excessive or insufficient exploration work caused by misinterpretation of geological exploration data.

[0033] 3. In this invention, data entry is done by form according to the exploration method. Information on the same type of geological object entered by different exploration methods is stored in the same table in the database backend.

[0034] 4. This invention provides multiple data output interfaces, providing the required formats for subsequent geological reports, traditional two-dimensional maps, and three-dimensional geological modeling, enabling convenient recording of original exploration information and efficiently serving the needs of subsequent data processing and other procedures. Attached Figure Description

[0035] The accompanying drawings, which are included to provide a further understanding of embodiments of the invention and form part of this application, do not constitute a limitation thereof. In the drawings:

[0036] Figure 1 This is a flowchart from Embodiment 1 of the present invention;

[0037] Figure 2 This is a system block diagram in Embodiment 2 of the present invention. Detailed Implementation

[0038] To make the objectives, technical solutions, and advantages of the present invention clearer, the present invention will be further described in detail below with reference to the embodiments and accompanying drawings. The illustrative embodiments and descriptions of the present invention are only used to explain the present invention and are not intended to limit the present invention.

[0039] Example 1: An abstract method for generating geological exploration database forms, such as... Figure 1 As shown, this is achieved through the following steps.

[0040] Step 1: Create a one-to-one geological object table using geological objects as indexes.

[0041] For example, stratigraphy, lithology, geological structure, hydrogeology, physical geology, and topography are used as primary indexes. Five tables corresponding to these five geological objects are used in the database design to store geological data. An active dictionary is set up, allowing users to add new geological objects or modify existing object names, replacing the existing database table design that uses exploration methods as indexes, thus reducing form duplication.

[0042] Step 2: Configure the corresponding data source field in the geological object table according to different exploration methods as data source methods, and configure the exploration object field to record the specific exploration object of the data source.

[0043] For example, names such as surface surveys, boreholes, adits, exploration wells, pits, and trenches can be used as data source methods. A "Data Source" field can be designed in the lower-level fields of the geological object form to record the source method. A "Exploration Object" field can be designed to record the specific exploration object from which the data is sourced, such as the number of the borehole or adit.

[0044] Step 3: Establish a connection between the data source, the exploration object and the corresponding geological information, and configure additional independent fields to record the geometric and attribute information of the same geological object collected by different exploration methods.

[0045] For specific geological object tables, the data source, exploration object, and specific geological information are linked. Other corresponding fields are designed to record the geometric and attribute information of geological objects collected by different exploration methods, such as stratigraphic number, rock and soil name, dip direction, and dip angle. When designing fields, similar information from different exploration methods is combined, such as borehole depth, adit station number, and depth of exploratory wells, pits, and trenches are combined into a depth field to reduce field duplication. Geological object-specific information is recorded in separate fields, such as borehole core recovery rate, RQD, and core yield rate.

[0046] Step 4: Extract fields associated with exploration methods from one or more geological object tables to form a data entry sub-table. The data entry sub-table is used to distinguish the data entry of different exploration methods.

[0047] Data entry is done through separate forms based on the exploration method. For each specific exploration method, fields corresponding to that method are extracted from the geological object table to form separate data entry tables, accommodating different data entry methods for each method. Information on the same type of geological object entered using different exploration methods is stored in the same table in the database backend.

[0048] Step 5: Establish connections between the geological object table stored in the exploration database and the various data output interfaces reserved by the exploration database to achieve the output of content in different formats, such as connecting with data interfaces related to the required format files for geological reports, geological profiles, and 3D modeling.

[0049] Furthermore, the geological object table in this invention is stored in the exploration database in the form of a physical table, and the data entry sub-table is called from the exploration database in the form of a virtual table, which can effectively reduce the amount of collected data occupied in the exploration database and save storage resources.

[0050] The geological object table uses a primary index, and the data entry sub-table uses a secondary index. When only a primary index is used, the index result is the geological object table. When only a secondary index is used, the index result is the data entry sub-table corresponding to all geological object tables. When both primary and secondary indexes are used, the index result is the data entry sub-table corresponding to the geological object table of the corresponding primary index.

[0051] In addition, data reading between the geological object table and the data entry sub-table is achieved through function calls.

[0052] Example 2: An abstract geological exploration database form generation system, such as Figure 2 As shown, the system is used to implement an abstract geological exploration database form generation method described in Example 1, including a form creation module, a field configuration module, an information association module, a table entry module, and a data output module.

[0053] The system comprises the following modules: a form creation module for creating a one-to-one geological object table indexed by geological objects; a field configuration module for configuring corresponding data source fields in the geological object table based on different exploration methods as data sources, and configuring exploration object fields to record the specific exploration objects from which the data originates; an information association module for establishing associations between data sources, exploration objects, and corresponding geological information, and configuring additional independent fields to record the geometric and attribute information of the same geological object collected by different exploration methods; a sub-table entry module for extracting fields associated with exploration methods from one or more geological object tables to form sub-tables for data entry, thereby distinguishing data entry for different exploration methods; and a data output module for connecting the geological object tables stored in the exploration database with various data output interfaces reserved in the exploration database to achieve content output in different formats.

[0054] Working Principle: This invention is guided by the results of three-dimensional geological mapping and uses five major geological objects as primary indexes, designing five corresponding tables. This solves the problem of repetitive and redundant fields and forms caused by the repetitive design of forms for different exploration methods in traditional geological exploration databases, thus improving the efficiency of database development and operation. In addition, this invention stores exploration information obtained by all exploration methods in the same geological object form, avoiding fragmented geological exploration data and facilitating the comparison and elimination of erroneous data based on the generated results, thus avoiding the problem of excessive or insufficient exploration work caused by misinterpretation of geological exploration data. Furthermore, this invention allows data entry to be done in separate forms according to exploration methods, and information on the same type of geological object entered by different exploration methods is stored in the same table in the database backend.

[0055] Those skilled in the art will understand that embodiments of this application can be provided as methods, systems, or computer program products. Therefore, this application can take the form of a completely hardware embodiment, a completely software embodiment, or an embodiment combining software and hardware aspects. Furthermore, this application can take the form of a computer program product embodied on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0056] This application is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of this application. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart... Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0057] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0058] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0059] The above specific embodiments further illustrate the purpose, technical solution, and beneficial effects of the present invention. It should be understood that the above are merely specific embodiments of the present invention and are not intended to limit the scope of protection of the present invention. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. An abstract method for generating forms in a geological exploration database, characterized in that, Includes the following steps: Establish a one-to-one geological object table indexed by geological objects; Configure the corresponding data source field in the geological object table according to different exploration methods as data source methods, and configure the exploration object field to record the specific exploration object of the data source; Establish a link between the data source, the exploration object and the corresponding geological information, and configure additional independent fields to record the geometric and attribute information of the same geological object collected by different exploration methods; When configuring the additional independent fields, similar information from different exploration methods is used together; Data entry sub-tables are formed by extracting fields associated with exploration methods from one or more geological object tables and using these sub-tables to differentiate data entry for different exploration methods. Establish connections between the geological object table stored in the exploration database and the various data output interfaces reserved in the exploration database to achieve content output in different formats; The geological object table is stored in the exploration database in the form of a physical table, and the data entry sub-table is retrieved from the exploration database in the form of a virtual table. The geological object table uses a primary index, and the data entry sub-table uses a secondary index. When only a first-level index is performed, the index result is a table of geological objects; When only a secondary index is performed, the index result is a data entry sub-table corresponding to all geological object tables; When both primary and secondary indexes are performed simultaneously, the indexing result is the data entry sub-table corresponding to the geological object table of the corresponding primary index.

2. The method for generating an abstract geological exploration database form according to claim 1, characterized in that, The geological objects include one or more of the following: stratigraphy, geological structure, hydrogeology, physical geology, and topography.

3. The method for generating an abstract geological exploration database form according to claim 1, characterized in that, The exploration methods include one or more of the following: surface survey, drilling, adit, exploratory well, exploratory pit, and exploratory trench.

4. The method for generating an abstract geological exploration database form according to claim 1, characterized in that, Data reading between the geological object table and the data entry sub-table is achieved through function calls.

5. An abstract geological exploration database form generation system, characterized in that it includes: The form creation module is used to create a one-to-one geological object table indexed by geological objects. The field configuration module is used to configure the corresponding data source field in the geological object table when different exploration methods are used as data sources, and to configure the exploration object field to record the specific exploration object of the data source; The information association module is used to establish a connection between data sources, exploration objects and corresponding geological information, and to configure additional independent fields to record the geometric and attribute information of the same geological object collected by different exploration methods; When configuring the additional independent fields, similar information from different exploration methods is used together; The data entry module is used to extract fields associated with exploration methods from one or more geological object tables to form a data entry sub-table. The data entry sub-table is used to distinguish the data entry of different exploration methods. The data output module is used to establish a connection between the geological object table stored in the exploration database and various data output interfaces reserved in the exploration database, so as to realize the output of content in different formats; The geological object table is stored in the exploration database in the form of a physical table, and the data entry sub-table is retrieved from the exploration database in the form of a virtual table. The geological object table uses a primary index, and the data entry sub-table uses a secondary index. When only a first-level index is performed, the index result is a table of geological objects; When only a secondary index is performed, the index result is a data entry sub-table corresponding to all geological object tables; When both primary and secondary indexes are performed simultaneously, the indexing result is the data entry sub-table corresponding to the geological object table of the corresponding primary index.

6. A computer terminal 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 program, it implements an abstract geological exploration database form generation method as described in any one of claims 1-4.

7. A computer-readable medium having a computer program stored thereon, characterized in that, The computer program, when executed by a processor, can implement an abstract geological exploration database form generation method as described in any one of claims 1-4.

Images