Geological multi-scale data hierarchical retrieval method and electronic device

Abstract

The application discloses a geological multi-scale data hierarchical retrieval method and electronic equipment, and belongs to the technical field of geological data management and retrieval, and comprises the following steps: S1, a multi-scale data system, namely, a three-level data structure system of a digital outcrop model, a rock sample and a rock sample, is constructed; S2, an association mechanism between the three-level data structure system is established, and the association mechanism comprises the following: digital outcrop model-rock sample association and rock sample-rock sample association; and S3, bidirectional association retrieval and feature retrieval are adopted to perform multi-scale data hierarchical retrieval. The efficiency of digital outcrop-rock sample-rock sample association retrieval is improved, the multi-dimensional retrieval capability is possessed, multi-class feature combination query is supported, lithology + era + composition and the like, seamless connection of macroscopic-mesoscopic-microscopic data can be realized, a bidirectional traceable chain is established, and data tracing is complete.

Description

Technical Field

[0001] This invention relates to the field of geological data management and retrieval technology, and in particular to a method and electronic device for hierarchical retrieval of geological multi-scale data. Background Technology

[0002] With the rapid development of digital technology, 3D modeling and virtual simulation technologies have been widely used in geological teaching and research. However, existing systems still have many shortcomings in data management and retrieval methods, making it difficult to meet the growing needs of geological research.

[0003] The most prominent problem with existing systems lies in the fragmented management of multi-scale data. Geological research typically involves three scale levels: macroscopic digital outcrop models (meter-level accuracy), mesoscopic rock specimen data (centimeter-level accuracy), and microscopic rock sample analysis data (micrometer-level accuracy). These different scales of data are stored and managed in isolation within existing systems, lacking effective correlation mechanisms. For example, when researchers need to trace the original outcrop location of a rock sample, they often need to manually consult multiple independent databases or record tables, a process that is not only time-consuming and labor-intensive but also prone to errors. Similarly, locating the microscopic features of a specific rock stratum from a macroscopic outcrop model also faces significant challenges.

[0004] In terms of data retrieval, existing systems suffer from severe hierarchical fragmentation. Traditional systems only support single-level data retrieval and cannot achieve cross-scale hierarchical correlation queries. The lack of pre-defined hierarchical retrieval paths results in: the inability to directly trace the outcrop to which a specimen belongs; the inability to reverse-engineer the parent specimen from the sample; and the need for manual recording of correlation relationships for cross-scale queries. These technical deficiencies force researchers to spend a significant amount of time on data processing, severely hindering the efficiency of geological research.

[0005] More specifically, existing systems suffer from the following technical deficiencies in multi-scale data association: First, there is a lack of systematic association indexes between digital outcrops, rock specimens, and rock samples, resulting in broken hierarchical links; second, retrieval paths are redundant, requiring multiple repeated accesses to different databases for cross-scale queries. Therefore, researching a method that can effectively integrate multi-scale geological data and support intelligent association retrieval has become an urgent technological breakthrough in the field of geological information technology. Summary of the Invention

[0006] The purpose of this invention is to overcome the shortcomings of existing technologies, such as the lack of a systematic association index between digital outcrops, rock specimens, and rock samples, resulting in broken hierarchical links; secondly, redundant retrieval paths and the need for repeated access to different databases for cross-scale queries. This invention provides a geological multi-scale data hierarchical retrieval method and electronic device.

[0007] To achieve the above-mentioned objectives, the present invention provides the following technical solution:

[0008] A method for hierarchical retrieval of geological multi-scale data includes the following steps:

[0009] S1: Construct a multi-scale data system, namely a three-level data structure system of digital outcrop models, rock specimens, and rock samples;

[0010] S2: Establish a correlation mechanism between the three-level data structure system, the correlation mechanism including: digital outcrop model-rock specimen correlation, rock specimen-rock sample correlation;

[0011] S3: Use bidirectional association retrieval and feature retrieval to perform multi-scale data hierarchical retrieval.

[0012] As a preferred embodiment of the present invention, the attribute fields of the data structure system of the digital outcrop model in step S1 include: stratigraphic unit, lithological combination, structural features and acquisition time;

[0013] A unique outcrop identifier is generated using a three-part coding rule consisting of regional code, geological age, and serial number.

[0014] The spatial coordinate range of the outcrop was recorded using the CGCS2000 coordinate system.

[0015] As a preferred embodiment of the present invention, the attribute data field of the data structure system of the rock specimen described in step S1 is the basic attribute, namely the collection location;

[0016] Lithological characteristics include: rock type, color, texture, structure, grain size, and composition;

[0017] The rock specimens are numbered using a preset numbering format.

[0018] As a preferred embodiment of the present invention, the properties of the data structure system of the rock sample in step S1 are obtained through analysis and testing, including: physical property analysis, hyperspectral mineral analysis, XRD whole-rock analysis and laser testing and analysis;

[0019] The attribute data fields of the rock sample include lithological characteristics, which include: rock type, color, structure, texture, grain size, and composition.

[0020] As a preferred embodiment of the present invention, the digital outcrop model-rock specimen association in step S2 includes:

[0021] Spatial location association: A relationship is established by matching the coordinates of rock specimen collection with the spatial range of the digital outcrop model;

[0022] Stratigraphic verification association: Strengthen the association when the stratigraphic code of the rock specimen is consistent with the outcrop stratigraphic attributes.

[0023] As a preferred embodiment of the present invention, the rock specimen-rock sample association in step S2 includes:

[0024] Feature similarity association: Establish a similarity calculation model, set a dynamic threshold, and establish an association when the similarity is greater than or equal to the dynamic threshold.

[0025] As a preferred embodiment of the present invention, the similarity calculation model is as follows:

[0026] Similarity = 0.4 × lithological matching degree + 0.3 × mineral composition similarity + 0.2 × structural feature similarity + 0.1 × color similarity.

[0027] As a preferred embodiment of the present invention, the bidirectional association retrieval method described in step S3 includes:

[0028] Bidirectional retrieval of digital outcrop models and rock specimens: When viewing a digital outcrop model, all associated rock specimens can be retrieved using the outcrop ID field in the rock specimen table; when viewing a rock specimen, the associated digital outcrop model can be located using the digital outcrop information in the rock specimen ID.

[0029] Two-way retrieval of rock specimens: When viewing a rock specimen, all associated rock specimens can be retrieved by using the rock specimen ID prefix in the rock specimen number; when viewing a rock specimen, the rock specimen number in the rock specimen ID can be parsed to trace back to the parent rock specimen.

[0030] As a preferred embodiment of the present invention, the feature retrieval in step S3 includes:

[0031] Digital outcrop model retrieval: Retrieval criteria include stratigraphy, age, coordinate range, and lithological characteristics;

[0032] Rock specimen retrieval: Retrieval criteria include lithology, grain size, and color;

[0033] Rock sample retrieval: The retrieval criteria are mineral composition and structural characteristics.

[0034] On the other hand, an electronic device is disclosed, including at least one processor and a memory communicatively connected to the at least one processor; the memory stores instructions executable by the at least one processor, which, when executed by the at least one processor, enable the at least one processor to perform the geological multi-scale data hierarchical retrieval method described in any of the preceding claims.

[0035] Compared with the prior art, the beneficial effects of this application are:

[0036] It improves the efficiency of digital outcrop-rock specimen-rock sample association retrieval and has multi-dimensional retrieval capabilities, supporting multi-feature combination queries, such as lithology + age + composition, and can achieve seamless connection of macro-, meso-, and micro data; it establishes a two-way traceability chain, ensuring complete data traceability. Attached Figure Description

[0037] Various other advantages and benefits will become apparent to those skilled in the art upon reading the following detailed description of preferred embodiments. The accompanying drawings are for illustrative purposes only and are not intended to limit the invention. Throughout the drawings, the same reference numerals denote the same parts. In the drawings:

[0038] Figure 1 This is a flowchart of a geological multi-scale data hierarchical retrieval method according to Embodiment 1 of the present invention;

[0039] Figure 2 This is a conceptual model diagram of a three-level data association for a geological multi-scale data hierarchical retrieval method as described in Embodiment 1 of the present invention;

[0040] Figure 3 This is a flowchart illustrating the similarity calculation process of a geological multi-scale data hierarchical retrieval method as described in Embodiment 1 of the present invention.

[0041] Figure 4 This is a schematic diagram of the hierarchical retrieval method for geological multi-scale data as described in Embodiment 1 of the present invention.

[0042] Figure 5 This is a schematic diagram of a volcanic rock outcrop in Tongshan, Xianning City, as described in Embodiment 2 of the present invention, which is a geological multi-scale data hierarchical retrieval method.

[0043] Figure 6 This is a schematic diagram of a rock specimen retrieved by the geological multi-scale data hierarchical retrieval method described in Embodiment 3 of the present invention, where the strata are Jurassic and the lithology is sandstone.

[0044] Figure 7 This is a schematic diagram of the structure of an electronic device according to Embodiment 4 of the present invention. Detailed Implementation

[0045] The technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. The components of the embodiments of the present invention described and shown in the accompanying drawings can generally be arranged and designed in various different configurations. Therefore, the following detailed description of the embodiments of the present invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention, but merely to illustrate selected embodiments of the invention. All other embodiments obtained by those skilled in the art based on the embodiments of the present invention without inventive effort are within the scope of protection of the present invention.

[0046] It should be noted that similar reference numerals and letters in the following figures indicate similar items; therefore, once an item is defined in one figure, it does not need to be further defined and explained in subsequent figures. Furthermore, in the description of this invention, the terms "first," "second," etc., are used only for distinguishing descriptions and should not be construed as indicating or implying relative importance, or suggesting any such actual relationship or order between these entities or operations. Additionally, the terms "connected," "linked," etc., can refer to a direct connection between components or an indirect connection via other components.

[0047] Example 1

[0048] A hierarchical retrieval method for geological multi-scale data, such as Figure 1 As shown, it includes the following steps:

[0049] S1: Construct a multi-scale data system, namely, establish a three-level data structure system of digital outcrop models, rock specimens, and rock samples. First, assign a unique outcrop identifier to each digital outcrop, including a geological age code and spatial location code, and record its various attributes; second, record the attributes and spatial location of each rock specimen, and generate a unique specimen number; in addition, label each rock sample with its source stratigraphy, location, and various attributes, and also record its unique number.

[0050] Specifically, the data structure system of the digital outcrop model described in step S1 includes: attribute data fields including: stratigraphic unit, lithological assemblage, structural features, and acquisition time; a unique identifier for the outcrop is generated using a three-segment coding rule of "regional code + geological age + serial number", such as OC_HB_E3_008 representing the 8th Eocene outcrop in the Hubei Basin; the spatial data recording standard is to record the spatial coordinate range of the outcrop using the CGCS2000 coordinate system;

[0051] The data structure system of the rock specimens mentioned in step S1 includes: attribute data fields including: basic attributes: collection location; lithological characteristics: rock type, color, structure, texture, grain size, composition; the rock specimen number format is SP serial number, such as SP_01.

[0052] The data structure system of the rock sample mentioned in step S1 includes: recording the attributes obtained from the analysis and testing of the rock sample, including physical property analysis, hyperspectral mineral analysis, XRD whole-rock analysis and laser testing and analysis, to obtain multiple corresponding analysis reports. The rock sample attribute data fields include: lithological characteristics: rock type, color, structure, texture, grain size, composition, etc.

[0053] S2: Establish the association mechanism between the three-level data structure system, such as... Figure 2 As shown, this refers to the correlation between digital outcrop model and rock specimen, and the correlation between rock specimen and rock sample.

[0054] Specifically, the digital outcrop model-rock specimen association described in step S2 includes: spatial location association: establishing a "taken from" relationship by matching the rock specimen acquisition coordinates with the spatial range of the digital outcrop model; stratigraphic verification association: strengthening the association when the stratigraphic code of the rock specimen is consistent with the stratigraphic attributes of the digital outcrop. For example, rock specimen SP_01 is verified to be located within the range of digital outcrop OC_HB_E3008 by GPS coordinates (X, Y, Z);

[0055] The rock specimen-rock sample association described in step S2 includes: feature similarity association, i.e., establishing a similarity calculation model: similarity = 0.4 × lithological matching degree + 0.3 × mineral composition similarity + 0.2 × structural feature similarity + 0.1 × color similarity. A dynamic threshold is set, with a default value of 0.6. Association is established when the similarity is ≥ the threshold. The similarity calculation process is as follows: Figure 3 As shown.

[0056] S3: Enables multi-scale hierarchical data retrieval, including bidirectional correlation retrieval and feature retrieval, and finally optimizes the results and displays the retrieval results by scale;

[0057] Specifically, the method for implementing bidirectional association retrieval described in step S3 includes:

[0058] Digital Outcrop Model - Bidirectional Retrieval of Rock Specimens: When viewing a digital outcrop: retrieve all associated rock specimens using the "Outcrop ID" field in the rock specimen table; when viewing a rock specimen: directly locate the associated digital outcrop model using the outcrop information in the rock specimen ID.

[0059] Two-way retrieval of rock specimens: When viewing a rock specimen: retrieve all associated rock specimens by using the rock specimen ID prefix in the rock specimen number; when viewing a rock sample: parse the rock specimen number in the rock sample ID to trace back to the parent rock specimen.

[0060] The feature retrieval method described in step S3 is as follows:

[0061] Digital outcrop model retrieval: Retrieval criteria: stratigraphy, such as "Jurassic", age, such as "Cretaceous", coordinate range, lithological characteristics;

[0062] Rock specimen retrieval: Retrieval criteria: lithology, such as "granite", grain size, such as "medium grain", color, such as "grayish white";

[0063] Rock sample retrieval: Retrieval criteria: mineral composition, such as "feldspar content > 30%", structural characteristics, such as "porphyritic texture";

[0064] The specific hierarchical search process is as follows: Figure 4 As shown.

[0065] Example 2

[0066] This embodiment is a specific implementation of the geological multi-scale data hierarchical retrieval method described in Embodiment 1;

[0067] Taking the volcanic rock outcrop in Tongshan, Xianning as an example:

[0068] Digital outcrop model: Input outcrop OC_XN_TS_J3b_001; Record spatial range, using CGCS2000;

[0069] Coordinate system: X: 452312.35~452318.77, Y: 3456712.48~3456718.92, Z: 120.3~125.6 (relative elevation); Attribute record: Stratigraphic age: Late Jurassic (J3b), Lithological assemblage: alternating layers of grayish-white medium sandstone and purplish-red mudstone, Data collection time: 2023-05-12, as shown Figure 5 As shown.

[0070] Rock specimen association: Collected rock specimen SP_03; Recorded collection location: X(452312), Y(3456712), Z(120); Attribute record: Lithology: "gravelly coarse sandstone", Structure: "platy cross-bedding", Color: "grayish black".

[0071] Rock sample association verification: Rock sample SA_01; Similarity calculation: Lithology matching degree: 1.0, Mineral composition similarity: 0.9, Structural feature similarity: 0.8, Color similarity: 0.7, Total similarity: 0.87 > threshold 0.6, association established.

[0072] Example 3

[0073] This embodiment is a specific implementation of the geological multi-scale data hierarchical retrieval method described in Embodiment 1.

[0074] Taking the query of rock specimens with Jurassic strata and sandstone lithology as an example:

[0075] Search process: Search criteria: Stratigraphy = "Jurassic" AND Lithology = "Sandstone"; Execution: After searching, the model of the Bentongshan outcrop (top three in similarity) was located. Multiple related specimens were found through the lithology index, displaying 7 specimens, such as... Figure 6 As shown.

[0076] Example 4

[0077] like Figure 7 As shown, an electronic device includes at least one processor and a memory communicatively connected to the at least one processor; the memory stores instructions executable by the at least one processor, which, when executed, enable the at least one processor to perform a geological multi-scale data hierarchical retrieval method as described in the foregoing embodiments. The input / output interface may include a display, keyboard, mouse, and USB interface for inputting and outputting data; a power supply provides electrical power to the electronic device.

[0078] Those skilled in the art will understand that all or part of the steps of the above method embodiments can be implemented by hardware related to program instructions. The aforementioned program can be stored in a computer-readable storage medium. When the program is executed, it performs the steps of the above method embodiments. The aforementioned storage medium includes various media that can store program code, such as mobile storage devices, read-only memory (ROM), magnetic disks, or optical disks.

[0079] When the integrated units of this invention are implemented as software functional units and sold or used as independent products, they can also be stored in a computer-readable storage medium. Based on this understanding, the technical solutions of the embodiments of this invention, or the parts that contribute to the prior art, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) to execute all or part of the methods described in the various embodiments of this invention. The aforementioned storage medium includes various media capable of storing program code, such as mobile storage devices, ROMs, magnetic disks, or optical disks.

[0080] It should also be noted that the various specific technical features described in the above specific embodiments can be combined in any suitable manner without contradiction. In order to avoid unnecessary repetition, this disclosure will not describe the various possible combinations separately.

[0081] Furthermore, various different embodiments of this disclosure can be combined in any way, as long as they do not violate the spirit of this disclosure, they should also be regarded as the content disclosed in this disclosure.

Claims

1. A method for hierarchical retrieval of geological multiscale data, characterized in that, Includes the following steps: S1: Construct a multi-scale data system, namely a three-level data structure system of digital outcrop models, rock specimens, and rock samples; S2: Establish a correlation mechanism between the three-level data structure system, the correlation mechanism including: digital outcrop model-rock specimen correlation, rock specimen-rock sample correlation; The digital outcrop model-rock specimen association described in step S2 includes: Spatial location association: A relationship is established by matching the coordinates of rock specimen collection with the spatial range of the digital outcrop model; Stratigraphic verification association: Strengthen the association when the stratigraphic code of the rock specimen is consistent with the outcrop stratigraphic attributes; Step S2, the rock specimen-rock sample association, includes: Feature similarity association: Establish a similarity calculation model, set a dynamic threshold, and establish an association when the similarity is greater than or equal to the dynamic threshold; S3: Multi-scale hierarchical data retrieval is performed using bidirectional association retrieval and feature retrieval; The bidirectional association retrieval method described in step S3 includes: Bidirectional retrieval of digital outcrop models and rock specimens: When viewing a digital outcrop model, all associated rock specimens can be retrieved using the outcrop ID field in the rock specimen table; when viewing a rock specimen, the associated digital outcrop model can be located using the digital outcrop information in the rock specimen ID. Two-way retrieval of rock specimens: When viewing a rock specimen, all associated rock specimens can be retrieved by using the rock specimen ID prefix in the rock specimen number; when viewing a rock specimen, the rock specimen number in the rock specimen ID can be parsed to trace back to the parent rock specimen.

2. The method of claim 1, wherein, The attribute fields of the data structure system of the digital outcrop model described in step S1 include: stratigraphic unit, lithological assemblage, structural features, and acquisition time; A unique outcrop identifier is generated using a three-part coding rule consisting of regional code, geological age, and serial number. The spatial coordinate range of the outcrop was recorded using the CGCS2000 coordinate system.

3. The method of claim 1, wherein, The attribute data field of the data structure system for the rock specimen described in step S1 is the basic attribute, namely the collection location; Lithological characteristics include: rock type, color, texture, structure, grain size, and composition; The rock specimens are numbered using a preset numbering format.

4. The method of claim 1, wherein, The properties of the data structure system of the rock sample mentioned in step S1 are obtained through analysis and testing, including: physical property analysis, hyperspectral mineral analysis, XRD whole-rock analysis, and laser testing and analysis; The attribute data fields of the rock sample include lithological characteristics, which include: rock type, color, structure, texture, grain size, and composition.

5. The method of claim 1, wherein, The similarity calculation model is as follows: Similarity = 0.4 × lithological matching degree + 0.3 × mineral composition similarity + 0.2 × structural feature similarity + 0.1 × color similarity.

6. The method of claim 1, wherein, The feature retrieval described in step S3 includes: Digital outcrop model retrieval: Retrieval criteria include stratigraphy, age, coordinate range, and lithological characteristics; Rock specimen retrieval: Retrieval criteria include lithology, grain size, and color; Rock sample retrieval: The retrieval criteria are mineral composition and structural characteristics.

7. An electronic device, characterized in that, The device comprises at least one processor and a memory connected to the at least one processor in communication; the memory stores instructions executable by the at least one processor, and the instructions are executed by the at least one processor to enable the at least one processor to perform the multi-scale data hierarchical retrieval method for geology in any one of claims 1 to 5.

Images