Stratum data storage and retrieval method and device based on spatial database, electronic equipment and storage medium

Abstract

The application discloses a stratum data storage and retrieval method and device based on a spatial database, electronic equipment and a storage medium. The method comprises the following steps: determining a first coordinate system; the first coordinate system is a rectangular frame obtained by performing two-dimensional coordinate mapping on stratum and basin data of a target region; constructing a spatial index according to the first coordinate system; the spatial index comprises a stratum information table and an exploration rock information table; performing information retrieval according to the spatial index, and displaying the retrieval result. According to the method, the stratum data is mapped in the form of space plus time according to the first coordinate system, data storage and association are performed according to the first coordinate system, the spatial index is obtained, data query is performed according to the spatial index after receiving a query instruction, the efficiency of the retrieval can be improved, and data information with space plus time can be obtained.

Description

Technical Field

[0001] This invention relates to the field of petroleum geological exploration information technology, and in particular to a method, apparatus, electronic device and storage medium for stratigraphic data storage and retrieval based on a spatial database. Background Technology

[0002] Existing stratigraphic data management systems (such as commercial software like Landmark and Petrel, or self-built Oracle / MySQL systems) typically use relational models to store stratigraphic information. These systems suffer from the following drawbacks: Structural defects: Stratigraphic levels (boundary-system-group-segment-layer) are linked via foreign keys, resulting in complex table structures. When calculating the total sample size of all groups within a specific system in a basin, recursive traversal of multiple table levels is required, leading to complex SQL statements and a sharp decline in execution efficiency as the data volume increases. Visualization disconnect: The logical encoding in the database is inconsistent with the "stratigraphic bar chart" or "comparison chart" displayed on the front end. The front end requires additional code to convert the logical tree into a graphical representation, resulting in high development and maintenance costs. Lack of spatial intuition: Mature GIS spatial indexing (R-Tree) technology cannot be utilized to optimize the natural hierarchical containment relationships of stratigraphy. Summary of the Invention

[0003] This invention provides a method, apparatus, electronic device, and storage medium for stratigraphic data storage and retrieval based on a spatial database, in order to solve the problems of data acquisition lacking hierarchical relationships and low acquisition efficiency.

[0004] According to one aspect of the present invention, a method for storing and retrieving stratigraphic data based on a spatial database is provided, comprising: Determine the first coordinate system; the first coordinate system is a rectangular frame obtained after performing two-dimensional coordinate mapping on the stratigraphic and basin data of the target area; A spatial index is constructed based on the first coordinate system; the spatial index represents the hierarchical inclusion relationship between different basins and different stratigraphic units in the first coordinate system in the form of a tree and nodes; the spatial index includes: a stratigraphic information table and an exploration rock information table; the stratigraphic information table is used to record the stratigraphic attribute information of each basin; the exploration rock information table is used to record the attribute information of exploration rock samples; Information is retrieved based on the spatial index, and the retrieval results are displayed; the retrieval uses spatial inclusion relationships for querying.

[0005] According to another aspect of the present invention, a stratigraphic data storage and retrieval device based on a spatial database is provided, comprising: The first coordinate system determination module is used to determine the first coordinate system; the first coordinate system is a rectangular frame obtained after performing two-dimensional coordinate mapping on the stratigraphic and basin data of the target area. A spatial index determination module is used to construct a spatial index based on the first coordinate system. The spatial index represents the hierarchical inclusion relationship between different basins and different stratigraphic units in the first coordinate system in the form of a tree and nodes. The spatial index includes a stratigraphic information table and an exploration rock information table. The stratigraphic information table is used to record the stratigraphic attribute information of each basin. The exploration rock information table is used to record the attribute information of exploration rock samples. The information retrieval module is used to retrieve information based on the spatial index and display the retrieval results; the retrieval is performed using spatial inclusion relationships.

[0006] According to another aspect of the present invention, an electronic device is provided, the electronic device comprising: At least one processor; and A memory communicatively connected to the at least one processor; wherein, The memory stores a computer program that can be executed by the at least one processor, which enables the at least one processor to perform the stratigraphic data storage and retrieval method based on a spatial database as described in any embodiment of the present invention.

[0007] According to another aspect of the present invention, a computer-readable storage medium is provided, the computer-readable storage medium storing computer instructions, the computer instructions being configured to cause a processor to execute and implement the stratigraphic data storage and retrieval method based on a spatial database according to any embodiment of the present invention.

[0008] The technical solution of this invention involves determining a first coordinate system; the first coordinate system is a rectangular frame obtained after mapping the stratigraphic and basin data of the target area to two-dimensional coordinates; a spatial index is constructed based on the first coordinate system; the spatial index represents the hierarchical inclusion relationship between different basins and different stratigraphic units in the first coordinate system in the form of a tree and nodes; the spatial index includes: a stratigraphic information table and an exploration rock information table; the stratigraphic information table is used to record the stratigraphic attribute information of each basin; the exploration rock information table is used to record the attribute information of exploration rock samples; information retrieval is performed based on the spatial index, and the retrieval results are displayed. This method first constructs a first coordinate system based on the stratigraphic data, maps the stratigraphic data in a spatial and temporal form, stores and associates the data according to the first coordinate system to obtain a spatial index, and then performs data retrieval based on the spatial index after receiving a query command. This improves retrieval efficiency while also obtaining data information with both spatial and temporal dimensions.

[0009] It should be understood that the description in this section is not intended to identify key or essential features of the embodiments of the present invention, nor is it intended to limit the scope of the invention. Other features of the invention will become readily apparent from the following description. Attached Figure Description

[0010] To more clearly illustrate the technical solutions in the embodiments of the present invention, the accompanying drawings used in the description of the embodiments will be briefly introduced below. Obviously, the accompanying drawings described below are only some embodiments of the present invention. For those skilled in the art, other drawings can be obtained based on these drawings without creative effort.

[0011] Figure 1 A flowchart illustrating a method for storing and retrieving stratigraphic data based on a spatial database, provided as an embodiment of the present invention; Figure 2 A schematic diagram of a first coordinate system provided in an embodiment of the present invention; Figure 3 A schematic diagram of the structure of a stratigraphic data storage and retrieval device based on a spatial database provided in an embodiment of the present invention; Figure 4 A schematic diagram of the structure of an electronic device for implementing the spatial database-based stratigraphic data storage and retrieval method of this invention. Detailed Implementation

[0012] To enable those skilled in the art to better understand the present invention, the technical solutions of the present invention will be clearly and completely described below with reference to the accompanying drawings of the embodiments of the present invention. Obviously, the described embodiments are only some embodiments of the present invention, and not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by those skilled in the art without creative effort should fall within the scope of protection of the present invention.

[0013] It should be noted that the terms "first," "second," etc., in the specification, claims, and accompanying drawings of this invention are used to distinguish similar objects and are not necessarily used to describe a specific order or sequence. It should be understood that such data can be interchanged where appropriate so that the embodiments of the invention described herein can be implemented in orders other than those illustrated or described herein. Furthermore, the terms "comprising" and "having," and any variations thereof, are intended to cover a non-exclusive inclusion; for example, a process, method, system, product, or apparatus that comprises a series of steps or units is not necessarily limited to those steps or units explicitly listed, but may include other steps or units not explicitly listed or inherent to such processes, methods, products, or apparatus.

[0014] Figure 1 This is a flowchart illustrating a method for storing and retrieving stratigraphic data based on a spatial database, provided in an embodiment of the present invention. This embodiment is applicable to situations requiring efficient storage and retrieval of stratigraphic data. The method can be executed by a stratigraphic data storage and retrieval device based on a spatial database, which can be implemented in hardware and / or software. This device can be configured in any electronic device with network communication capabilities. Figure 1 As shown, the method includes: S110. Determine the first coordinate system; the first coordinate system is the rectangular frame obtained after performing two-dimensional coordinate mapping on the stratigraphic and basin data of the target area.

[0015] Specifically, a two-dimensional Cartesian coordinate system is generated as the first coordinate system. Basins are divided into regions on the first coordinate system according to their numbering order, with each region being the same size and non-overlapping, resulting in the second coordinate system. Boundary, system, and series stratigraphic units are mapped into horizontal rectangles spanning all basins using a preset segmentation strategy. Based on the geological information of different basins, basins containing group, segment, and sub-layer stratigraphic units are selected and retained, and their corresponding rectangles in the second coordinate system are located. Mapping is then performed within these rectangles according to the preset segmentation strategy. After mapping, the collected exploration rock sample information and stratigraphic unit information are added to the corresponding rectangles, resulting in the first coordinate system.

[0016] Furthermore, when a new basin or newly discovered strata are found, only a new rectangular record needs to be inserted in the first coordinate system. There is no need to modify the structure of the first coordinate system or migrate historical data, thus achieving convenient data updates.

[0017] Furthermore, users can freely select or click any stratigraphic frame on the first coordinate system, and the data storage and retrieval system will automatically identify all the sub-strata and samples contained therein, achieving seamless "drill-down" analysis.

[0018] Furthermore, the above steps are implemented through a coordinate encoding generation module. The coordinate encoding generation module converts the input standard stratigraphic table (including hierarchical relationships) and basin list into rectangular frames, and then adds the exploration rock sample information and stratigraphic unit information to the corresponding rectangles to obtain the first coordinate system.

[0019] For example, stratigraphic data from 10 basins, including XX, YY, and ZZ, are imported into the coordinate encoding generation module. The module automatically generates horizontal rectangular strips representing the Cretaceous strata in each basin, as well as local rectangles representing its subordinate MM and NN groups, and then generates vertical rectangles for each basin. Core sample test data from 10,000 wells are converted into point coordinates and stored in this module to obtain the first coordinate system.

[0020] The above steps ensure that the geometric shape stored in the first coordinate system is the displayed graphic, thus eliminating the conversion error between the data model and the visualization model.

[0021] S120. Construct a spatial index based on the first coordinate system; the spatial index represents the hierarchical inclusion relationship between different basins and different stratigraphic units in the first coordinate system in the form of a tree and nodes; the spatial index includes: a stratigraphic information table and an exploration rock information table; the stratigraphic information table is used to record the stratigraphic attribute information of each basin; the exploration rock information table is used to record the attribute information of exploration rock samples.

[0022] The spatial index can completely cover all strata, basins, and explored rock samples. The spatial index is a tree structure of third node - second node - first node - spatial object.

[0023] The first node is rectangular data generated based on data from a single stratum or basin.

[0024] The second node is a rectangular data structure obtained by aggregating adjacent first nodes.

[0025] The first node is the rectangular data obtained by aggregating all the second nodes.

[0026] Among them, rectangular data refers to rectangular blocks that can cover the strata or basin being represented.

[0027] The spatial objects include all strata, basins, and exploration rock samples.

[0028] Specifically, at least one first matrix is ​​filtered and aggregated according to a first aggregation rule to obtain at least one first node. A predetermined number of adjacent nodes from the at least one first node are aggregated to obtain at least one second node. The at least one second node is aggregated together to obtain a third node, and the third node as a whole is used as a spatial index.

[0029] The first aggregation rule is to aggregate the first rectangular objects that are spatially adjacent and have the lowest overlap between the first matrices into leaf nodes, i.e., the first nodes.

[0030] Furthermore, the above steps are implemented by the spatial database storage module. The spatial database storage module is used to construct stratigraphic information tables and exploration rock information tables based on the first coordinate system, and to establish R-Tree spatial indexes on the geometric fields of the stratigraphic information tables and exploration rock information tables.

[0031] The above steps, including the generation of the spatial index, enable hierarchical summary queries with hundreds of millions of data points to be executed within seconds, which is 10-100 times faster than traditional relational queries.

[0032] S130. Retrieve information based on the spatial index and display the retrieval results; the retrieval uses spatial inclusion relationships for querying.

[0033] Specifically, the process involves obtaining a search request, invoking the spatial engine based on the request, and calculating the number or sum of attributes of all points within the cell rectangle recorded in the request information, without needing to associate child tables. After obtaining the search results, these results are displayed in the first coordinate system.

[0034] Furthermore, the display highlights the portion of the content represented by the search results and statistically displays all sample points within the box containing the search results.

[0035] The search request is a query command entered in the visual interaction module, which can be a text command or a mouse click operation on a preset command.

[0036] Among them, the preset instructions are pre-built instructions generated based on actual retrieval experience and configured in the data storage and operating system.

[0037] Furthermore, the above information retrieval can be achieved through the following commands: SELECT COUNT(*) AS sample_count FROM Samples JOIN GEO_UNITS ON ST_Contains(GEO_UNITS.geometry, Samples.geometry) WHERE GEO_UNITS.UNIT_NAME = 'XXXX segment 1'.

[0038] Furthermore, the above steps are implemented through a spatial retrieval engine. The spatial retrieval engine is configured with the ST_Contains(Polygon, Point) operation. When a user requests to statistically analyze data of a certain stratigraphic unit, the data storage and retrieval system directly calls the spatial engine to calculate the number or sum of attributes of all points falling within the unit's rectangle, without needing to associate child tables.

[0039] Furthermore, the data storage and retrieval system, in addition to including a coordinate encoding generation module, a spatial database storage module, and a spatial retrieval engine, also includes a visualization and interaction module. This module directly reads the geometric data from the spatial index to draw nested block diagrams and displays data points from the exploration rock information table within these diagrams. Clicking on any block (such as "Cretaceous" or "Songliao Basin") automatically highlights all its internal sub-blocks and sample points, and displays the statistical results.

[0040] Furthermore, the connection relationship between the coordinate encoding generation module, the spatial database storage module, the spatial retrieval engine, and the visualization interaction module is as follows: the output end of the coordinate encoding generation module is connected to the input end of the spatial database storage module; the spatial retrieval engine reads data from the spatial database storage module; and the visualization interaction module interacts bidirectionally with the spatial retrieval engine.

[0041] For example, a user clicks the "Cretaceous" tab on the interface. The system executes: The retrieval engine extracts the geometric object P_K of the "Cretaceous" rectangle. The SQL is executed: SELECT AVG(porosity) FROM Samples WHERE ST_Contains(P_K, geom); Spatial indexing quickly locates all points falling within this Y-axis interval, regardless of their basin or group. The average porosity of all Cretaceous samples is returned within 0.5 seconds, and further drilling can be performed to display detailed data for "XX Basin Cretaceous" or "YY Basin Cretaceous".

[0042] Furthermore, when uncertain strata exist, the retrieval method is as follows: Assuming the strata in a well are vaguely named, only identified as "Paleogene" without specifying a group, the Y-coordinate of the sample point is set within the "reserved area" or buffer zone of the "Paleogene" rectangle, avoiding the specific "group" rectangle. This point is included when querying the total "Paleogene" volume. When querying a specific "group" (such as the TT group), this point is not included. The system automatically marks this point as "to be refined" and displays it in a special color in the gaps between groups on the visualization interface.

[0043] Optionally, determine the first coordinate system, including steps A1-A3: Step A1: Construct a two-dimensional rectangular coordinate system.

[0044] Specifically, a virtual two-dimensional rectangular coordinate system is generated.

[0045] Step A2: Assign basins to the horizontal axis of the two-dimensional rectangular coordinate system. According to the order of basin numbers in the target area, assign non-overlapping continuous intervals in sequence, retain the preset size general area, and obtain the second coordinate system.

[0046] Specifically, in a two-dimensional rectangular coordinate system, each target basin is assigned an independent and continuous interval according to the basin numbering order. The intervals of each target basin do not overlap. Within the divided intervals, a general area under a preset zone is delineated to obtain the second coordinate system.

[0047] Step A3: Recursively segment and encode the vertical axis of the second coordinate system to obtain the first coordinate system.

[0048] Stratigraphic units include: boundary, system, series, group, section, and sub-layer.

[0049] Specifically, the division method is determined based on the stratigraphic unit to which the basin belongs, as marked in the first coordinate system. If it is the first stratigraphic unit, a recursive division strategy of reserved areas and sub-regions is used to divide all basin areas into intervals, resulting in a global coordinate interval spanning all basins. If it is the second stratigraphic unit, the basin to which the second stratigraphic unit belongs is first determined, and the interval to which the corresponding basin belongs is located in the second coordinate system. Within the interval, a recursive division strategy of reserved areas and sub-regions is used to divide all basin areas into intervals, resulting in a local coordinate interval valid within the basin area, thus obtaining the first coordinate system.

[0050] Furthermore, the processing logic of the recursive partitioning strategy of reserved areas and sub-regions is as follows: if the stratigraphic unit is the first stratigraphic unit, then the recursive partitioning strategy of reserved areas and sub-regions is used to divide the intervals between all basins and obtain a global coordinate interval spanning all basins; if the stratigraphic unit is the second stratigraphic unit, then the basin to which the second stratigraphic unit belongs is first determined, and the interval to which the corresponding basin belongs is located in the first coordinate system. Within the interval, the recursive partitioning strategy of reserved areas and sub-regions is used to divide the intervals between all basins and obtain a local coordinate interval valid within the interval of the basin to which it belongs.

[0051] Further, the processing steps of the recursive segmentation strategy for reserved areas and sub-regions are as follows: First, determine the first interval based on the range of the vertical axis occupied by the first stratigraphic unit in the first coordinate system. Second, determine the first length based on the range of the Y-axis occupied by the first interval. Third, extract a numerical range of the first length representing a first preset percentage from the top or bottom of the first interval, and use this range as the second interval. Fourth, subtract the range of the second interval from the range of the first interval, and then cut the remaining range according to a first preset number of segments to obtain at least one third interval. Fifth, determine the stratigraphic interface corresponding to the first interval, and match the processing method for the at least one third interval according to the type of the stratigraphic interface. Sixth, classify the obtained at least one third interval according to the matched processing method.

[0052] The processing methods include: a first processing method and a second processing method.

[0053] The first processing method corresponds to boundaries, systems, and networks. The processing involves recording at least one third interval as a sub-region of the next stratigraphic unit.

[0054] The second processing method corresponds to groups, segments, and layers. The processing content involves dividing the acquired at least one third interval into a second preset number of next stratigraphic unit sub-regions and a first preset number minus a second preset number of buffer spaces.

[0055] The size of the first preset number is selected according to the stratigraphic unit to which the first interval belongs. For example, if the stratigraphic unit corresponding to the first interval is a boundary or system, then the corresponding first preset number is the first sub-number; if the stratigraphic unit corresponding to the first interval is a system, group, or segment, then the corresponding first preset number is the second sub-number.

[0056] For example, the first coordinate system is as follows Figure 2 As shown, clicking on a basin displays statistical results such as the number of samples contained in the basin and the average value; clicking on a stratum displays statistical results such as the number of samples contained in the stratum and the average value.

[0057] Optionally, a spatial index is constructed based on the first coordinate system, including steps B1-B3: Step B1: Generate a stratigraphic information table and an exploration rock information table based on the first coordinate system.

[0058] Specifically, the coordinate encoding generation module combines standard stratigraphic tables and basin lists to classify and integrate data, resulting in a coordinate set. Based on this coordinate set, corresponding coordinate data is retrieved from the second framework and saved in separate tables for stratigraphic units and basin units, and for exploration rock samples, resulting in stratigraphic information tables and exploration rock information tables.

[0059] The exploration rock information table (Geo_Units) includes at least the following: primary key (ID), rectangle name (UNIT_NAME), unit type (UNIT_TYPE), geometric object (GEOPETRY), and record creation time (CREATED_DATE).

[0060] The exploration rock information table includes at least the following: the identification (ID) of the exploration rock sample, the number of the exploration rock sample (SAMPLE_CODE), the physical property data (PROPERTIES) of the exploration rock sample, the geometric object of the exploration rock sample (COORDINATE_POINT), and the creation time of the exploration rock sample (CREATED_DATE).

[0061] Step B2: Traverse and bind the stratigraphic information table and the exploration rock information table to obtain at least one first rectangle and at least one first point.

[0062] Specifically, the process iterates through all stratigraphic and basin rectangles in the stratigraphic information table, calculating the rectangle corresponding to each stratigraphic and basin to obtain at least one first rectangle. This first rectangle is then bound to the primary key of the corresponding stratigraphic or basin. Next, the process iterates through all exploration sample point data in the exploration rock information table to obtain at least one first point. This first point is then bound to the identifier of the corresponding exploration rock sample. Finally, the bound first rectangle and the bound first point are combined to obtain at least one first rectangle and at least one first point, which constitute the MBR (Master BR).

[0063] Furthermore, the first matrix is ​​determined by: traversing the rectangular geometric objects (Geom field) of each stratum and basin, extracting the coordinates (latitude and longitude / projected coordinates) of all vertices of the rectangle, locking the maximum and minimum values ​​of the horizontal coordinate (X-axis) and the maximum and minimum values ​​of the vertical coordinate (Y-axis), and constructing a rectangle using these four extreme coordinates as vertices.

[0064] Furthermore, the method for determining the first point is as follows: since the exploration rock sample is point data, the point element has no actual area and outline, and its corresponding rectangle is a zero-area rectangle, that is, the coordinates of the four vertices of the rectangle completely coincide with the coordinates of the point geometric object of the sample point, without any length or width extension.

[0065] Furthermore, before traversing the stratigraphic information table and the exploration rock information table, the overall coordinate range is determined based on the first coordinate system, the maximum and minimum coordinates of all stratigraphic basin rectangles and exploration rock sample points are calculated, and the spatial boundary of the index coverage is determined to avoid index overflow and spatial object loss.

[0066] Furthermore, before traversing the stratigraphic information table and the exploration rock information table, it is also necessary to: limit the maximum number of spatial objects that a single node can accommodate, the minimum filling threshold, and the index level depth, in order to adapt to the scenario of massive geological data.

[0067] Step B3: Generate a spatial index based on at least one first rectangle and at least one first point.

[0068] Specifically, at least one first matrix and at least one first point are filtered and aggregated according to a first aggregation rule to obtain at least one first node. A predetermined number of adjacent nodes in the at least one first node are aggregated to obtain at least one second node. The at least one second node is aggregated together to obtain a third node, and the third node as a whole is used as a spatial index.

[0069] Optionally, a spatial index is generated based on at least one first rectangle and at least one first point, including steps C1-C3: Step C1: Filter at least one first rectangle and at least one first point to obtain at least one first node.

[0070] Specifically, at least one first matrix and at least one first point are filtered and aggregated according to the first aggregation rule to obtain at least one first node.

[0071] The first aggregation rule is to aggregate the first rectangular objects or the first point objects that are spatially adjacent and have the lowest overlap between the first matrix or the first point into leaf nodes.

[0072] In this context, spatial proximity refers to the first matrix corresponding to strata and basin rectangles, and exploration rock sample points, being spatially close. For example, different strata rectangles within the same basin, or exploration rock sample points within the same area. This is used to reduce branch traversal during index queries after aggregation, thus improving efficiency.

[0073] The lowest overlap between the first matrix or the first point refers to the minimum overlap area among all the first matrices aggregated to the same leaf node (whether it is the first matrix of a stratum or basin, or the first point of an exploration rock sample). This is used to avoid a large overlap of MBRs within the same leaf node, which would otherwise lead to confusion when multiple objects correspond to the same index branch during queries. It ensures that the MBR of each leaf node can be clearly distinguished, reducing query redundancy.

[0074] Step C2: Aggregate at least one first node to obtain at least one second node.

[0075] Specifically, at least one first node is aggregated with a predetermined number of adjacent nodes to obtain at least one second node.

[0076] The above steps enable the generation of a second node to continuously reduce the number of nodes and expand the spatial coverage.

[0077] Step C3: Aggregate at least one second node to obtain a spatial index.

[0078] Specifically, at least one second node is aggregated together to obtain a third node, and the third node as a whole is used as a spatial index.

[0079] Furthermore, after obtaining the spatial index, verification is required. The verification includes integrity checks and overlap optimization.

[0080] Among them, integrity verification: traverse the entire data and verify that the first rectangle of the geometric objects of all strata, basins and exploration rock samples has been included in the spatial index, with no omissions and no duplicate bindings.

[0081] Among them, the overlap optimization is achieved by adjusting the node aggregation rules to minimize the MBR overlap area between sibling nodes, reducing the number of branch traversals during queries, and significantly improving retrieval efficiency.

[0082] Optional, the stratigraphic information table may include at least: rectangle name, cell type, and geometric object.

[0083] In this context, the rectangle name refers to the name corresponding to a stratigraphic unit or basin unit. It is the uniquely defined geological name for the rectangle to which the stratigraphic unit or basin unit is assigned. Stratigraphic units are typically named using the geological names of the strata, such as: upper-level: Mesozoic, Paleozoic, Jurassic, Cretaceous; stratigraphic level: XXX Group, YYY Group, a specific segment, a specific layer. Basin units are named according to the basin's geological structure. Examples include: XXX Basin, YY Basin, ZZ Depression, a specific tectonic block.

[0084] The unit type identifies the category and level of geological unit to which the rectangle belongs to the basin unit or stratigraphic unit. The stratigraphic units, from highest to lowest level, are: boundary, system, series, formation, section, and sub-bedding. Boundaries, systems, and series represent high-grade chronostratigraphy, and the rectangle can span multiple basins. Formations, sections, and sub-bedding represent low-grade lithostratigraphy, and the rectangle is confined to a single basin. The basin units, from highest to lowest level, are: basin, depression, depression, sub-depression, and tectonic block.

[0085] Among them, the geometric unit is a spatial geometric field that stores the boundary contour of a spatial rectangle, describing the planar boundary, extent, and shape of a stratigraphic unit or basin unit using a standard spatial data format.

[0086] Specifically, as shown in Table 1, the stratigraphic information table (Geo_Units) contains the following information: primary key (ID), rectangle name (UNIT_NAME), unit type (UNIT_TYPE), geometric object (GEOPETRY), and record creation time (CREATED_DATE).

[0087] Table 1. Stratigraphic Information (Partial Content) Optionally, the exploration rock information table may include at least: the identifier of the exploration rock sample, the number of the exploration rock sample, the physical property data of the exploration rock sample, the geometric object of the exploration rock sample, and the creation time of the exploration rock sample.

[0088] Among them, the identification (ID) of the exploration rock sample is used to uniquely identify the exploration rock sample collected.

[0089] The exploration rock sample number (SAMPLE_CODE) is used to assign a preset number to the obtained exploration rock sample.

[0090] Among them, the physical properties data (PROPERTIES) of the exploration rock samples are used to characterize the physical characteristics of the exploration rock samples. The physical properties data of the exploration rock samples include at least: porosity and permeability.

[0091] Among them, the geometric object (COORDINATE_POINT) of the exploration rock sample is used to record the coordinate information of the exploration rock sample in the first coordinate system.

[0092] The creation time (CREATED_DATE) of the exploration rock sample is the time when the information of the exploration rock sample is used to generate the exploration rock information table (Samples).

[0093] Specifically, the exploration rock information table is shown in Table 2.

[0094] Table 2: Partial Contents of Exploration Rock Information Table The technical solution of this embodiment involves determining a first coordinate system; the first coordinate system is a rectangular frame obtained after mapping the stratigraphic and basin data of the target area to two-dimensional coordinates; a spatial index is constructed based on the first coordinate system; the spatial index represents the hierarchical inclusion relationship between different basins and different stratigraphic units in the first coordinate system in the form of a tree and nodes; the spatial index includes: a stratigraphic information table and an exploration rock information table; the stratigraphic information table is used to record the stratigraphic attribute information of each basin; the exploration rock information table is used to record the attribute information of exploration rock samples; information retrieval is performed based on the spatial index, and the retrieval results are displayed. This method first constructs a first coordinate system based on the stratigraphic data, maps the stratigraphic data in a spatial and temporal form, stores and associates the data according to the first coordinate system to obtain a spatial index, and then performs data retrieval based on the spatial index after receiving a query command. This improves retrieval efficiency while also obtaining data information with both spatial and temporal dimensions.

[0095] Figure 3 This is a schematic diagram of a stratigraphic data storage and retrieval device based on a spatial database, provided as an embodiment of the present invention. This embodiment is applicable to situations requiring efficient storage and retrieval of stratigraphic data. The spatial database-based stratigraphic data storage and retrieval device can be implemented in hardware and / or software, and can be configured in any electronic device with network communication capabilities. Figure 3 As shown, the device includes: a first coordinate system determination module 210, a spatial index determination module 220, and an information retrieval module 230, wherein: First coordinate system determination module 210: used to determine the first coordinate system; the first coordinate system is a rectangular frame obtained after performing two-dimensional coordinate mapping on the stratigraphic and basin data of the target area; Spatial index determination module 220: used to construct a spatial index based on a first coordinate system; the spatial index represents the hierarchical inclusion relationship between different basins and different stratigraphic units in the first coordinate system in the form of a tree and nodes; the spatial index includes: a stratigraphic information table and an exploration rock information table; the stratigraphic information table is used to record the stratigraphic attribute information of each basin; the exploration rock information table is used to record the attribute information of exploration rock samples; Information retrieval module 230: used to retrieve information based on spatial index and display the retrieval results; the retrieval is performed using spatial inclusion relationships.

[0096] Optionally, the first coordinate system determination module 210 includes: First coordinate system defining unit: used to construct a two-dimensional rectangular coordinate system; Second coordinate system determination unit: used to allocate basins on the horizontal axis of the two-dimensional rectangular coordinate system. According to the order of basin numbering in the target area, non-overlapping continuous intervals are allocated in sequence, and a preset size general area is retained to obtain the second coordinate system. First coordinate system determination unit: used to recursively segment and encode the vertical axis of the second coordinate system to obtain the first coordinate system.

[0097] Optionally, the spatial index determination module 220 includes: Table Determination Unit: Used to generate stratigraphic information tables and exploration rock information tables based on the first coordinate system; First rectangle determination unit: used to traverse and bind the stratigraphic information table and the exploration rock information table to obtain at least one first rectangle and at least one first point; Spatial index determination unit: used to generate a spatial index based on at least one first rectangle and at least one first point.

[0098] Optionally, the spatial index determination unit includes: The first node determines the sub-unit: it is used to filter at least one first rectangle and at least one first point to obtain at least one first node; The second node determines the sub-unit: it is used to aggregate at least one first node to obtain at least one second node; Spatial index determines sub-units: used to aggregate at least one second node to obtain a spatial index.

[0099] Optional, the stratigraphic information table may include at least: rectangle name, cell type, and geometric object.

[0100] Optionally, the exploration rock information table may include at least: the identifier of the exploration rock sample, the number of the exploration rock sample, the physical property data of the exploration rock sample, the geometric object of the exploration rock sample, and the creation time of the exploration rock sample.

[0101] The stratigraphic data storage and retrieval device based on a spatial database provided in this embodiment of the invention can execute the stratigraphic data storage and retrieval method based on a spatial database provided in any of the above embodiments of the invention. It has the corresponding functions and beneficial effects of executing the stratigraphic data storage and retrieval method based on a spatial database. For detailed process, please refer to the relevant operations of the stratigraphic data storage and retrieval method based on a spatial database in the foregoing embodiments.

[0102] Figure 4 This is a schematic diagram of an electronic device for implementing the stratigraphic data storage and retrieval method based on a spatial database, as described in this embodiment of the invention. The electronic device is intended to represent various forms of digital computers, such as laptops, desktop computers, workbenches, personal digital assistants, servers, blade servers, mainframes, and other suitable computers. The electronic device can also represent various forms of mobile devices, such as personal digital processors, cellular phones, smartphones, wearable devices (e.g., helmets, glasses, watches), and other similar computing devices. The components shown herein, their connections and relationships, and their functions are merely illustrative and are not intended to limit the implementation of the invention described and / or claimed herein.

[0103] like Figure 4 As shown, the electronic device 10 includes at least one processor 11 and a memory, such as a read-only memory (ROM) 12 or a random access memory (RAM) 13, communicatively connected to the at least one processor 11. The memory stores computer programs executable by the at least one processor. The processor 11 can perform various appropriate actions and processes based on the computer program stored in the ROM 12 or loaded from storage unit 18 into the RAM 13. The RAM 13 can also store various programs and data required for the operation of the electronic device 10. The processor 11, ROM 12, and RAM 13 are interconnected via a bus 14. An input / output (I / O) interface 15 is also connected to the bus 14.

[0104] Multiple components in electronic device 10 are connected to I / O interface 15, including: input unit 16, such as keyboard, mouse, etc.; output unit 17, such as various types of displays, speakers, etc.; storage unit 18, such as disk, optical disk, etc.; and communication unit 19, such as network card, modem, wireless transceiver, etc. Communication unit 19 allows electronic device 10 to exchange information / data with other devices through computer networks such as the Internet and / or various telecommunications networks.

[0105] Processor 11 can be a variety of general-purpose and / or special-purpose processing components with processing and computing capabilities. Some examples of processor 11 include, but are not limited to, a central processing unit (CPU), a graphics processing unit (GPU), various special-purpose artificial intelligence (AI) computing chips, various processors running machine learning model algorithms, a digital signal processor (DSP), and any suitable processor, controller, microcontroller, etc. Processor 11 performs the various methods and processes described above, such as a method for storing and retrieving stratigraphic data based on a spatial database.

[0106] In some embodiments, the spatial database-based stratigraphic data storage and retrieval method can be implemented as a computer program tangibly contained in a computer-readable storage medium, such as storage unit 18. In some embodiments, part or all of the computer program can be loaded and / or installed on electronic device 10 via ROM 12 and / or communication unit 19. When the computer program is loaded into RAM 13 and executed by processor 11, one or more steps of the spatial database-based stratigraphic data storage and retrieval method described above can be performed. Alternatively, in other embodiments, processor 11 can be configured to perform the spatial database-based stratigraphic data storage and retrieval method by any other suitable means (e.g., by means of firmware).

[0107] Various embodiments of the systems and techniques described above herein can be implemented in digital electronic circuit systems, integrated circuit systems, field-programmable gate arrays (FPGAs), application-specific integrated circuits (ASICs), application-specific standard products (ASSPs), systems-on-a-chip (SoCs), payload-programmable logic devices (CPLDs), computer hardware, firmware, software, and / or combinations thereof. These various embodiments may include implementations in one or more computer programs that can be executed and / or interpreted on a programmable system including at least one programmable processor, which may be a dedicated or general-purpose programmable processor, capable of receiving data and instructions from a storage system, at least one input device, and at least one output device, and transmitting data and instructions to the storage system, the at least one input device, and the at least one output device.

[0108] Computer programs used to implement the methods of the present invention may be written in any combination of one or more programming languages. These computer programs may be provided to a processor of a general-purpose computer, a special-purpose computer, or other programmable data processing device, such that when executed by the processor, the computer programs cause the functions / operations specified in the flowcharts and / or block diagrams to be performed. The computer programs may be executed entirely on a machine, partially on a machine, or as a standalone software package, partially on a machine and partially on a remote machine, or entirely on a remote machine or server.

[0109] In the context of this invention, a computer-readable storage medium can be a tangible medium that may contain or store a computer program for use by or in conjunction with an instruction execution system, apparatus, or device. A computer-readable storage medium may include, but is not limited to, electronic, magnetic, optical, electromagnetic, infrared, or semiconductor systems, apparatus, or devices, or any suitable combination thereof. Alternatively, a computer-readable storage medium may be a machine-readable signal medium. More specific examples of machine-readable storage media include electrical connections based on one or more wires, portable computer disks, hard disks, random access memory (RAM), read-only memory (ROM), erasable programmable read-only memory (EPROM or flash memory), optical fibers, portable compact disk read-only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination thereof.

[0110] To provide interaction with a user, the systems and techniques described herein can be implemented on an electronic device having: a display device (e.g., a CRT (cathode ray tube) or LCD (liquid crystal display) monitor) for displaying information to the user; and a keyboard and pointing device (e.g., a mouse or trackball) through which the user provides input to the electronic device. Other types of devices can also be used to provide interaction with the user; for example, feedback provided to the user can be any form of sensory feedback (e.g., visual feedback, auditory feedback, or tactile feedback); and input from the user can be received in any form (including sound input, voice input, or tactile input).

[0111] The systems and technologies described herein can be implemented in computing systems that include backend components (e.g., as data servers), or middleware components (e.g., application servers), or frontend components (e.g., user computers with graphical user interfaces or web browsers through which users can interact with implementations of the systems and technologies described herein), or any combination of such backend, middleware, or frontend components. The components of the system can be interconnected via digital data communication of any form or medium (e.g., communication networks). Examples of communication networks include local area networks (LANs), wide area networks (WANs), blockchain networks, and the Internet.

[0112] A computing system can include clients and servers. Clients and servers are generally located far apart and typically interact through communication networks. The client-server relationship is created by computer programs running on the respective computers and having a client-server relationship with each other. The server can be a cloud server, also known as a cloud computing server or cloud host, which is a hosting product within the cloud computing service system to address the shortcomings of traditional physical hosts and VPS services, such as high management difficulty and weak business scalability.

[0113] It should be understood that the various forms of processes shown above can be used, with steps reordered, added, or deleted. For example, the steps described in this invention can be executed in parallel, sequentially, or in different orders, as long as the desired result of the technical solution of this invention can be achieved, and this is not limited herein.

[0114] The specific embodiments described above do not constitute a limitation on the scope of protection of this invention. Those skilled in the art should understand that various modifications, combinations, sub-combinations, and substitutions can be made according to design requirements and other factors. Any modifications, equivalent substitutions, and improvements made within the spirit and principles of this invention should be included within the scope of protection of this invention.

Claims

1. A method for storing and retrieving stratigraphic data based on a spatial database, characterized in that, include: Determine the first coordinate system; the first coordinate system is a rectangular frame obtained after performing two-dimensional coordinate mapping on the stratigraphic and basin data of the target area; Construct a spatial index based on the first coordinate system; The spatial index represents the hierarchical inclusion relationship between different basins and different stratigraphic units in the first coordinate system in the form of a tree and nodes; the spatial index includes: a stratigraphic information table and an exploration rock information table; the stratigraphic information table is used to record the stratigraphic attribute information of each basin; the exploration rock information table is used to record the attribute information of exploration rock samples; Information is retrieved based on the spatial index, and the retrieval results are displayed; the retrieval uses spatial inclusion relationships for querying.

2. The method according to claim 1, characterized in that, Determining the first coordinate system includes: Construct a two-dimensional rectangular coordinate system; Basins are allocated on the horizontal axis of the two-dimensional rectangular coordinate system. According to the order of basin numbers in the target area, non-overlapping continuous intervals are allocated sequentially, and a preset size general area is retained to obtain the second coordinate system. The first coordinate system is obtained by recursively segmenting and encoding the vertical axis of the second coordinate system.

3. The method according to claim 1, characterized in that, The step of constructing a spatial index based on the first coordinate system includes: Generate a stratigraphic information table and an exploration rock information table based on the first coordinate system; The stratigraphic information table and the exploration rock information table are traversed and bound to obtain at least one first rectangle, at least one first point, and at least one first point; A spatial index is generated based on the at least one first rectangle and the at least one first point.

4. The method according to claim 3, characterized in that, The step of generating a spatial index based on the at least one first rectangle and at least one first point includes: By filtering the at least one first rectangle and the at least one first point, at least one first node is obtained; Aggregate the at least one first node to obtain at least one second node; Aggregate the at least one second node to obtain a spatial index.

5. The method according to claim 1, characterized in that, The stratigraphic information table shall include at least: rectangle name, unit type, and geometric object.

6. The method according to claim 1, characterized in that, The exploration rock information table includes at least: the identifier of the exploration rock sample, the number of the exploration rock sample, the physical property data of the exploration rock sample, the geometric object of the exploration rock sample, and the creation time of the exploration rock sample.

7. A stratigraphic data storage and retrieval device based on a spatial database, characterized in that, include: The first coordinate system determination module is used to determine the first coordinate system; the first coordinate system is a rectangular frame obtained after performing two-dimensional coordinate mapping on the stratigraphic and basin data of the target area. A spatial index determination module is used to construct a spatial index based on the first coordinate system; The spatial index represents the hierarchical inclusion relationship between different basins and different stratigraphic units in the first coordinate system in the form of a tree and nodes; the spatial index includes: a stratigraphic information table and an exploration rock information table; the stratigraphic information table is used to record the stratigraphic attribute information of each basin; the exploration rock information table is used to record the attribute information of exploration rock samples; The information retrieval module is used to retrieve information based on the spatial index and display the retrieval results; the retrieval is performed using spatial inclusion relationships.

8. The apparatus according to claim 7, characterized in that, The spatial index determination module includes: The table determination unit is used to generate a stratigraphic information table and an exploration rock information table based on the first coordinate system. The first rectangle determination unit is used to traverse and bind the stratigraphic information table and the exploration rock information table to obtain at least one first rectangle, at least one first point, and at least one first point. A spatial index determination unit is used to generate a spatial index based on the at least one first rectangle and the at least one first point.

9. An electronic device, characterized in that, The electronic device includes: At least one processor; and A memory communicatively connected to the at least one processor; wherein, The memory stores a computer program that can be executed by the at least one processor, the computer program being executed by the at least one processor to enable the at least one processor to perform the stratigraphic data storage and retrieval method based on a spatial database as described in any one of claims 1-6.

10. A computer-readable storage medium, characterized in that, The computer-readable storage medium stores computer instructions that cause a processor to execute the stratigraphic data storage and retrieval method based on a spatial database as described in any one of claims 1-6.

Images