Integrated digital geological management system

Through the automatic identification and structural split storage methods of the integrated digital geological management system, the problem of low storage efficiency of multi-source heterogeneous data is solved, and the storage and query efficiency of geological data is improved.

CN118227624BActive Publication Date: 2024-11-05XINJIANG PROD & CONSTR CORPS SURVEY & DESIGN INS
View PDF 0 Cites 0 Cited by

Patent Information

Application Number
CN202410411688.6
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2024-04-08
Publication Date
2024-11-05
Estimated Expiration
2044-04-08

AI Technical Summary

Technical Problem

The existing multi-source heterogeneous data reconstruction and integration system lacks consideration of data structure characteristics during storage, resulting in low storage and query efficiency of multi-source heterogeneous geological data.

Method used

Adopt an integrated digital geological management system, including multi-source heterogeneous geological data type automatic identification unit, data structure identification unit, data source relational data table establishment unit, geological data structure split storage unit, unstructured data storage unit, and retrieval Query the comprehensive efficiency assessment unit and data storage method selection unit, and automatically identify the data types and structures, establish a relational data table, split storage, and optimize query efficiency.

Benefits of technology

By considering the structural characteristics of multi-source heterogeneous geological data, the data storage and query efficiency are improved, and efficient management of multi-source heterogeneous geological data is achieved.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN118227624B_ABST
    Figure CN118227624B_ABST
Patent Text Reader

Abstract

The present invention discloses an integrated digital geological management system, including a multi-source heterogeneous geological data type automatic identification unit, a multi-source heterogeneous geological data structure identification unit, a multi-source heterogeneous geological data data source relational data table establishment unit, a geological data structure splitting storage unit, a geological unstructured data storage unit, a retrieval query comprehensive efficiency evaluation unit and a multi-source heterogeneous geological data storage method selection unit. The present invention realizes the multi-source heterogeneous geological data structure characteristics based on the multi-source heterogeneous geological data by automatically identifying the multi-source heterogeneous geological data type and the multi-source heterogeneous geological data structure; taking the data features with the same characteristics, splitting the data features with different characteristics into the unstructured data storage table or the cold data table storage area, so as to consider the structural characteristics of the data and improve the partial data storage and query efficiency of the multi-source heterogeneous geological data.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The invention belongs to the technical field of data storage management, and in particular, relates to an integrated digital geological management system. Background Art

[0002] With the development of data storage management technology, the distributed data storage method of multi-source heterogeneous geological data can effectively improve the storage efficiency of geological data and improve the efficiency of subsequent retrieval management and analysis of geological data.

[0003] In the Chinese public invention with application number CN202111475391.9, a highway multi-source heterogeneous data reconstruction and integration system is disclosed, which specifically relates to the field of highway network management technology, and includes: a multi-source data acquisition module: it includes a highway basic management information acquisition module and a real-time information acquisition module; a multi-source data transmission module: it is used to synchronously transmit the collected information to the multi-source data management module; a multi-source data management module: it includes data resource directory management, data resource security management and data resource quality management; and a data management center: the data management center includes a highway data management subsystem, a regional emergency data management subsystem and a data storage module. The highway multi-source heterogeneous data reconstruction and integration system described in the present invention integrates the highway data management subsystem and the regional emergency data management subsystem, and can be combined with the real-time situation to bring great help to the maintenance of the highway network, and has broad application prospects in the field of highway network management technology.

[0004] The defect of the existing patent is that although the above-mentioned highway multi-source heterogeneous data reconstruction and integration system realizes the functions of multi-source data collection, transmission and management, the multi-source heterogeneous geological data lacks consideration of the structural characteristics of the data during the storage process, resulting in poor storage and query efficiency of multi-source heterogeneous geological data. Summary of the invention

[0005] In view of the problem that although the existing multi-source heterogeneous data reconstruction and integration system can realize the multi-source data collection, transmission and management functions, it lacks consideration of the structural characteristics of the data, resulting in poor storage and query efficiency of multi-source heterogeneous geological data, the present invention provides an integrated digital geological management system.

[0006] In order to achieve the above technical objectives, the technical solution adopted by the present invention is as follows:

[0007] An integrated digital geological management system, including a multi-source heterogeneous geological data type automatic identification unit, a multi-source heterogeneous geological data structure identification unit, a multi-source heterogeneous geological data data source relational data table establishment unit, a geological data structure splitting and storage unit, a geological unstructured data storage unit, a retrieval and query comprehensive efficiency evaluation unit, and a multi-source heterogeneous geological data storage method selection unit;

[0008] The multi-source heterogeneous geological data type automatic identification unit decompresses the multi-source heterogeneous geological data package, extracts the input data suffix or multi-source data input plug-in to identify the multi-source heterogeneous geological data type;

[0009] A multi-source heterogeneous geological data structure identification unit, used to identify data recording geological structures or geological coordinates in the multi-source heterogeneous geological data;

[0010] The data source relational data table establishment unit of multi-source heterogeneous geological data performs two-dimensional or three-dimensional data conversion according to the data source of the uploaded multi-source heterogeneous geological data identified by the multi-source heterogeneous geological data structure identification unit, obtains the two-dimensional and three-dimensional description coordinates of the data source of each multi-source heterogeneous geological data, and places the same type of coordinates into the same coordinate system, and analyzes the coordinate points with the same or intersecting relationship between the target objects to establish a relational data table;

[0011] The geological data structure is split into storage units, and the relational data table is vertically split into a core retrieval table (such as geological number, geological name or metadata information of geological data) and a detailed information table (other non-essential data placed in the metadata table based on metadata information), so as to realize metadata segmented storage;

[0012] A geological unstructured data storage unit stores the geological unstructured data in a cold data table storage area;

[0013] The comprehensive efficiency evaluation unit of retrieval query is used to establish a multi-source heterogeneous geological data searcher, input the retrieval query formula according to the searcher retrieval rules, and comprehensively evaluate the retrieval query efficiency of distributed storage and non-distributed storage of the same type of multi-source heterogeneous geological data;

[0014] The multi-source heterogeneous geological data storage method selection unit stores the same type of multi-source heterogeneous geological data in a distributed storage or non-distributed storage space according to the calculation result of the retrieval query comprehensive efficiency evaluation unit.

[0015] Furthermore, the detailed steps for establishing a relational data table are as follows:

[0016] Obtaining pairs of objects that interact with each other in space and are close to the target object;

[0017] A space in which objects are spatially connected one by one; that is, the object coordinate points are connected to form a structural graphic.

[0018] Determine whether there is an intersection, adjacency or inclusion relationship between the object pairs in the two-dimensional or three-dimensional coordinate system. If there is any of the above relationships, proceed to the next step. If there is no such relationship, determine whether all object pairs have been compared. If not, continue to compare the next object pair. If the comparison is completed, the establishment of the entire relational data table is terminated.

[0019] According to the intersection, adjacency or inclusion relationship of the object pair in the two-dimensional or three-dimensional coordinate system, the intersection, adjacency or inclusion relationship graph and coordinate points are extracted as the establishment relationship node of the metadata in the relational data table. The extracted intersection, adjacency or inclusion relationship graph and coordinate points can be used as the index content of the subsequent core search table; in addition to extracting the intersection, adjacency or inclusion relationship graph and coordinate points, the remaining unrelated object pair structure or coordinate data is included in the detailed information table for storage, realizing the segmented storage of metadata.

[0020] Furthermore, the vertical splitting method steps in the relational data table are as follows:

[0021] The metadata of the relationship nodes extracted during the establishment of the relational data table is used as the splitting standard node;

[0022] Write the intersecting, adjacent or containing relationship graphics and coordinate point data of the object pairs in the two-dimensional or three-dimensional coordinate system into the core search table, and write the primary key ID and object name of the above object pairs together;

[0023] The primary key ID and object name of the object pair are copied and written to the detailed information table, and the object pair structure or coordinate data part that has no relationship is written to the detailed information table.

[0024] Furthermore, the geological data structure splitting storage unit also includes horizontal splitting, and the geological data structure horizontal splitting method steps include:

[0025] Split the geological data in the table according to the upper limit of each table's storage space / the upper limit of the space that affects the efficiency of each table's storage or reading; refers to distributing the data of a table with a very high access frequency into multiple tables or multiple databases according to a specific rule.

[0026] Split and copy each row of a table as a whole and store it in another data table;

[0027] The index relationship between the parent table and the child table is established through the primary key ID and the primary key name. When the primary key ID and the primary key name in the parent table are retrieved, the entire data with the same primary key ID and the primary key name in the child table is retrieved and displayed to the user end through the index relationship.

[0028] Furthermore, the query efficiency evaluation method adopts a multi-objective optimization algorithm, and the evaluation objectives include the size of the retrieval storage space, the retrieval speed, and the frequency of data access;

[0029] The query efficiency evaluation steps of the multi-objective optimization algorithm include:

[0030] Pre-store the geological data of the target to be assessed (multi-source heterogeneous geological data) processed according to the above processing method according to distributed storage and non-distributed storage;

[0031] Input the search object in the searcher, and collect the data values ​​of the storage space size, search speed and data access frequency of the distributed storage and non-distributed storage during the search process of the search object;

[0032] The storage space size, retrieval speed and data access frequency are each assigned a certain percentage value; the sum of the three percentage values ​​is 1.

[0033] Assume that the storage space size of the search object in the distributed storage space is M1, the search speed is V1, and the data access frequency is F1, and the corresponding percentages are 30%, 35%, and 35%; the storage space size of the search object in the non-distributed storage space is M2, the search speed is V2, and the data access frequency is F2, and the corresponding percentages are 35%, 30%, and 35%; the calculation formula for the distributed storage query efficiency is:

[0034]

[0035] The calculation formula for non-distributed storage query efficiency is:

[0036] Distributed storage methods focus on storage data retrieval efficiency, while non-distributed storage methods focus on storage space utilization, so the percentage distribution has a certain bias and proportion adjustment according to needs.

[0037] Furthermore, a time series storage optimization unit is included to compress the same target geological data and the same geological data in the same relational data table; the specific time series storage optimization method includes:

[0038] If the two-dimensional and three-dimensional description coordinates of the same target geological data are the same at different times or over a period of time, one two-dimensional and three-dimensional description coordinate is stored, and the time series is stored in a non-distributed storage space or detailed information table; the retrieval efficiency of the core retrieval table is improved when retrieving the two-dimensional and three-dimensional description coordinates.

[0039] For the same geological data in the relational data table (with the same two-dimensional and three-dimensional description coordinates), one target object (the target object with the highest historical popularity, which updates the retrieval or collection writing popularity of the same geological data in the relational data table in real time) is selected and retained in the core retrieval table, and other objects with the same geological data are stored in the detailed information table. Index relationships are established between other objects and the same geological data; this facilitates subsequent retrieval or modification of object data (when the same geological data changes), and other objects are rewritten into the relational data table.

[0040] Furthermore, it also includes a storage optimization unit for the same target object. According to the different acquisition perspectives or positions of the same target geological data (the same target object is judged by matching the primary key ID and the object name, and the same primary key ID and object name are the same target objects), it is converted to the same coordinate system to compare whether its geological data has changed. If there is no change or the change error is within the preset range (geological data errors will be generated during data acquisition or conversion, but the error does not affect its determination as the same target), only one type of target geological data is retained in the core retrieval table in the metadata table (relational data table), and the other type of target geological data is indexed and saved in the detailed information table. For the same target object, one of the different geological data acquisition perspectives or position data is retained in the core retrieval table, and the other geological data acquisition perspective or position data can be saved in the detailed information table; the retrieval efficiency of the core retrieval table is improved, and more storage space is reserved for the metadata in the relational database that needs it.

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

[0042] Through automatic identification of multi-source heterogeneous geological data types and multi-source heterogeneous geological data structures, the structural characteristics of multi-source heterogeneous geological data are realized; the data source of the geological data structure is extracted, a relational data table is established, the structural characteristics of the geological data are analyzed, the data features with the same characteristics are taken, and the data features with different characteristics are split into unstructured data storage tables or cold data table storage areas, so as to consider the structural characteristics of the data and improve the partial data storage and query efficiency of multi-source heterogeneous geological data. At the same time, the search query formula is input according to the search engine search rules to comprehensively evaluate the distributed storage and non-distributed storage retrieval query efficiency of the same type of multi-source heterogeneous geological data. BRIEF DESCRIPTION OF THE DRAWINGS

[0043] Figure 1 It is an overall structural block diagram of the integrated digital geological management system in an embodiment of the present invention;

[0044] Figure 2 A flowchart of the detailed steps for establishing a relational data table in an embodiment of the present invention;

[0045] Figure 3It is a flow chart of a vertical splitting method in a relational data table in an embodiment of the present invention;

[0046] Figure 4 1 is a flow chart of the steps of the method for horizontal splitting of geological data structure in an embodiment of the present invention. DETAILED DESCRIPTION

[0047] In order to facilitate the understanding of those skilled in the art, the present invention is further described below in conjunction with embodiments and drawings. The contents mentioned in the implementation modes are not intended to limit the present invention.

[0048] like Figure 1 As shown, this embodiment provides an integrated digital geological management system, including a multi-source heterogeneous geological data type automatic identification unit, a multi-source heterogeneous geological data structure identification unit, a multi-source heterogeneous geological data data source relational data table establishment unit, a geological data structure splitting storage unit, a geological unstructured data storage unit, a retrieval query comprehensive efficiency evaluation unit and a multi-source heterogeneous geological data storage method selection unit;

[0049] The multi-source heterogeneous geological data type automatic identification unit decompresses the multi-source heterogeneous geological data package, extracts the input data suffix or multi-source data input plug-in to identify the multi-source heterogeneous geological data type;

[0050] A multi-source heterogeneous geological data structure identification unit, used to identify data recording geological structures or geological coordinates in the multi-source heterogeneous geological data;

[0051] The data source relational data table establishment unit of multi-source heterogeneous geological data performs two-dimensional or three-dimensional data conversion according to the data source of the uploaded multi-source heterogeneous geological data identified by the multi-source heterogeneous geological data structure identification unit, obtains the two-dimensional and three-dimensional description coordinates of the data source of each multi-source heterogeneous geological data, and places the same type of coordinates into the same coordinate system, and analyzes the coordinate points with the same or intersecting relationship between the target objects to establish a relational data table;

[0052] The geological data structure is split into storage units, and the relational data table is vertically split into a core retrieval table (such as geological number, geological name or metadata information of geological data) and a detailed information table (other non-essential data placed in the metadata table based on metadata information), so as to realize metadata segmented storage;

[0053] A geological unstructured data storage unit stores the geological unstructured data in a cold data table storage area;

[0054] The comprehensive efficiency evaluation unit of retrieval query is used to establish a multi-source heterogeneous geological data searcher, input the retrieval query formula according to the searcher retrieval rules, and comprehensively evaluate the retrieval query efficiency of distributed storage and non-distributed storage of the same type of multi-source heterogeneous geological data;

[0055] The multi-source heterogeneous geological data storage method selection unit stores the same type of multi-source heterogeneous geological data in a distributed storage or non-distributed storage space according to the calculation result of the retrieval query comprehensive efficiency evaluation unit.

[0056] like Figure 2 As shown, the detailed steps for establishing a relational data table by analyzing the coordinate points with the same or intersecting relationship between target objects are as follows:

[0057] S101, obtaining pairs of objects that are close to the target object and interact with it in space;

[0058] S102, the space in which the objects are spatially connected one by one; that is, the object coordinate points are connected into a structural figure.

[0059] S103, determining whether there is an intersection, adjacency or inclusion relationship between the object pairs in the two-dimensional or three-dimensional coordinate system. If there is any such relationship, proceed to the next step. If there is no such relationship, determine whether all object pairs have been compared. If not, proceed to compare the next object pair. If the comparison is completed, the establishment of the entire relational data table is terminated.

[0060] S104. According to the intersection, adjacency or inclusion relationship of the object pair in the two-dimensional or three-dimensional coordinate system, the intersection, adjacency or inclusion relationship graph and coordinate points are extracted as the establishment relationship node of the metadata in the relational data table. The extracted intersection, adjacency or inclusion relationship graph and coordinate points can be used as the index content of the subsequent core search table; in addition to extracting the intersection, adjacency or inclusion relationship graph and coordinate points, the remaining unrelated object pair structure or coordinate data part is included in the detailed information table for storage, realizing the segmented storage of metadata.

[0061] For example, for the object pairs A and B, the data sources of A and C are: the data collected by the target object A in the two-dimensional coordinate system is: A1(1,1), A2(5,1), A3(5,5), A4(1,5); the data collected by the target object B in the two-dimensional coordinate system is: B1(2,2), B2(3,2), B3(3,3), B4(2,3); the data collected by the target object C in the two-dimensional coordinate system is: C1(2,2), C2(4,2), C3(4,4), C4(2,4). The initial data source table 1 stores the following contents:

[0062] Table 1

[0063]

[0064] Relational data table 2 is as follows:

[0065] Table 2

[0066]

[0067]

[0068] like Figure 3 As shown, the steps for vertical splitting in a relational data table are:

[0069] S201, using metadata of established relationship nodes extracted during the establishment of a relational data table as splitting standard nodes;

[0070] S202, writing the graphs and coordinate point data of the object pairs that intersect, are adjacent or contain each other in the two-dimensional or three-dimensional coordinate system into the core search table, and writing the primary key ID and object name of the object pairs together;

[0071] S203. Copy the primary key ID and object name of the object pair into the detailed information table, and write the irrelevant object pair structure or coordinate data into the detailed information table.

[0072] The vertical split method splits and stores data tables such as relational data tables 3 and 4:

[0073] Table 3

[0074]

[0075]

[0076] Table 4

[0077]

[0078] like Figure 4 As shown, the geological data structure splitting storage unit also includes horizontal splitting, and the geological data structure horizontal splitting method steps include:

[0079] S301. Splitting the geological data in the table according to the upper limit of the storage space of each table / the upper limit of the space that affects the efficiency of storing or reading each table; refers to distributing the data of a table with very high access frequency into multiple tables or multiple databases according to a specific rule.

[0080] S302, splitting and copying the data in each row of the table as a whole, and storing the copied data in another data table;

[0081] S303, establish an index relationship between the parent table and the child table through the primary key ID and the primary key name. When the primary key ID and the primary key name in the parent table are retrieved, the entire data with the same primary key ID and the primary key name in the child table is retrieved and displayed to the user terminal through the index relationship.

[0082] After the horizontal split method is split, the relational data tables 4 and 5 are as follows:

[0083] Table 4

[0084]

[0085] Table 5

[0086]

[0087] When the intersection or overlap of the query object pairs A, B and C is selected, Table 4 can be quickly searched and displayed. When the query target object A is further clicked, the detailed data of the target object A in Table 5 can be quickly searched and displayed based on the index relationship between Table 4 and Table 5.

[0088] The query efficiency evaluation method adopts a multi-objective optimization algorithm, and the evaluation objectives include the size of the retrieval storage space, the retrieval speed and the frequency of data access;

[0089] The query efficiency evaluation steps of the multi-objective optimization algorithm include:

[0090] S401, pre-storing the geological data of the target to be assessed (multi-source heterogeneous geological data) processed according to the above processing method according to distributed storage and non-distributed storage;

[0091] S402, inputting a search object into the searcher, and collecting data values ​​of storage space size, search speed, and data access frequency of distributed storage and non-distributed storage during the search process of the search object;

[0092] S403, assigning certain percentage values ​​to storage space size, retrieval speed and data access frequency respectively; the sum of the three percentage values ​​is 1.

[0093] S404, assuming that the storage space size of the search object in the distributed storage space is M1, the search speed is V1, and the data access frequency is F1, and the corresponding percentages are 30%, 35%, and 35%, and the storage space size of the search object in the non-distributed storage space is M2, the search speed is V2, and the data access frequency is F2, and the corresponding percentages are 35%, 30%, and 35%; the distributed storage query efficiency calculation formula is:

[0094]

[0095] The calculation formula for non-distributed storage query efficiency is:

[0096] Distributed storage methods focus on storage data retrieval efficiency, while non-distributed storage methods focus on storage space utilization, so the percentage distribution has a certain bias and proportion adjustment according to needs.

[0097] It also includes a time series storage optimization unit, which compresses the same target geological data and the same geological data in the same relational data table; the specific time series storage optimization methods include:

[0098] S501. If the two-dimensional and three-dimensional description coordinates of the same target geological data are the same at different times or within a period of time, one two-dimensional and three-dimensional description coordinate is stored, and the time series is stored in a non-distributed storage space or detailed information table; the retrieval efficiency of the core retrieval table is improved when retrieving the two-dimensional and three-dimensional description coordinates.

[0099] S502. For the same geological data in the same relational data table (with the same two-dimensional and three-dimensional description coordinates), select one target object (the target object with the highest historical popularity, and update the retrieval or collection writing popularity of the same geological data in the same relational data table in real time) and keep it in the core retrieval table. Other objects with the same geological data are stored in the detailed information table, and index relationships are established between other objects and the same geological data; when subsequent retrieval or object data (changes in the same geological data) are modified, other objects are rewritten into the relational data table.

[0100] It also includes a storage optimization unit for the same target object. According to the different acquisition perspectives or locations of the same target geological data (the same target object is judged by matching the primary key ID and object name for retrieval, and the same primary key ID and object name are the same target objects), it is converted to the same coordinate system to compare whether its geological data has changed. If there is no change or the change error is within the preset range (geological data errors will be generated during data acquisition or conversion, but the error does not affect its determination as the same target), only one type of target geological data is retained in the core retrieval table in the metadata table (relational data table), and the other type of target geological data is indexed and saved in the detailed information table. For the same target object, one of the different geological data acquisition perspectives or location data is retained in the core retrieval table, and the other geological data acquisition perspective or location data can be saved in the detailed information table; the retrieval efficiency of the core retrieval table is improved, and more storage space is reserved for the metadata in the relational database that needs it.

[0101] For example, a 3D laser scanner is used to collect geological point cloud data of geological object W, and point cloud data P and Q based on different coordinate systems O1_x1y1z1 and O2_x2y2z2 are obtained at positions A and B respectively. Point cloud registration is used to take P or Q as the reference and transform the other point cloud to the same coordinate system.

[0102] Registration process: Perform rigid transformation on the two point clouds, including rotation and translation, use point cloud P as a reference, and rotate and translate Q; that is, P = RQ + T.

[0103] For point p i (x i ,y i ,zi ) is translated by T(t x ,t y ,t z ), and we get p′ i (x′ i , y′ i , z′ i ) where p′ i =p i +T means:

[0104]

[0105] Rotate point pi(xi,yi,zi) by R to get p″ i (x″ i , y″ i , z″ i ), expressed as:

[0106]

[0107] Use the point cloud centroid to obtain the rotation and translation matrices R and T, the point cloud P and the centroid p m and the centroid q of the point cloud Q m for

[0108]

[0109] The covariance matrix E is:

[0110]

[0111] in:

[0112] E=UΛV T

[0113] Get the rotation matrix and translation matrix:

[0114] R=VU T ,T=q m -Rp m .

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

[0116] Through automatic identification of multi-source heterogeneous geological data types and multi-source heterogeneous geological data structures, the structural characteristics of multi-source heterogeneous geological data are realized; the data source of the geological data structure is extracted, a relational data table is established, the structural characteristics of the geological data are analyzed, the data features with the same characteristics are taken, and the data features with different characteristics are split into unstructured data storage tables or cold data table storage areas, so as to consider the structural characteristics of the data and improve the partial data storage and query efficiency of multi-source heterogeneous geological data. At the same time, the search query formula is input according to the search engine search rules to comprehensively evaluate the distributed storage and non-distributed storage retrieval query efficiency of the same type of multi-source heterogeneous geological data.

[0117] The above is a detailed introduction to the integrated digital geological management system provided by the present application. The description of the specific embodiments is only used to help understand the method and core ideas of the present application. It should be pointed out that for ordinary technicians in this technical field, without departing from the principles of the present application, several improvements and modifications can be made to the present application, and these improvements and modifications also fall within the scope of protection of the claims of the present application.

Claims

1. Integrated digital geological management system, characterized by: It includes a multi-source heterogeneous geological data type automatic identification unit, a multi-source heterogeneous geological data structure identification unit, a multi-source heterogeneous geological data data source relational data table establishment unit, a geological data structure splitting and storage unit, a geological unstructured data storage unit, a retrieval and query comprehensive efficiency evaluation unit, and a multi-source heterogeneous geological data storage method selection unit; The multi-source heterogeneous geological data type automatic identification unit decompresses the multi-source heterogeneous geological data package, extracts the input data suffix or multi-source data input plug-in to identify the multi-source heterogeneous geological data type; A multi-source heterogeneous geological data structure identification unit, used to identify data recording geological structures or geological coordinates in the multi-source heterogeneous geological data; The data source relational data table establishment unit of multi-source heterogeneous geological data performs two-dimensional or three-dimensional data conversion according to the data source of the uploaded multi-source heterogeneous geological data identified by the multi-source heterogeneous geological data structure identification unit, obtains the two-dimensional and three-dimensional description coordinates of the data source of each multi-source heterogeneous geological data, and places the same type of coordinates into the same coordinate system, and analyzes the coordinate points with the same or intersecting relationship between the target objects to establish a relational data table; The geological data structure splits the storage unit, vertically splits the relational data table into a core retrieval table and a detailed information table, and implements segmented metadata storage; A geological unstructured data storage unit stores the geological unstructured data in a cold data table storage area; The comprehensive efficiency evaluation unit of retrieval query is used to establish a multi-source heterogeneous geological data searcher, input the retrieval query formula according to the searcher retrieval rules, and comprehensively evaluate the retrieval query efficiency of distributed storage and non-distributed storage of the same type of multi-source heterogeneous geological data; The multi-source heterogeneous geological data storage method selection unit stores the same type of multi-source heterogeneous geological data in a distributed storage or non-distributed storage space according to the calculation result of the retrieval query comprehensive efficiency evaluation unit.

2. The integrated digital geological management system according to claim 1, characterized in that: Analyze the coordinate points with the same or intersecting relationship between the target objects and establish a relational data table. Detailed steps: Obtaining pairs of objects that interact with each other in space and are close to the target object; The space where the object pairs perform spatial joins one by one; Determine whether there is an intersection, adjacency or inclusion relationship between the object pairs in the two-dimensional or three-dimensional coordinate system. If there is any of the above relationships, proceed to the next step. If there is no such relationship, determine whether all object pairs have been compared. If not, continue to compare the next object pair. If the comparison is completed, the establishment of the entire relational data table is terminated. According to the intersection, adjacency or inclusion relationship between objects in a two-dimensional or three-dimensional coordinate system, the intersection, adjacency or inclusion relationship graphics and coordinate points are extracted as the establishment relationship nodes of the metadata in the relational data table.

3. The integrated digital geological management system according to claim 2, characterized in that: Steps for vertical splitting in a relational data table: The metadata of the relationship nodes extracted during the establishment of the relational data table is used as the splitting standard node; Write the intersecting, adjacent or containing relationship graphics and coordinate point data of the object pairs in the two-dimensional or three-dimensional coordinate system into the core search table, and write the primary key ID and object name of the above object pairs together; The primary key ID and object name of the object pair are copied and written to the detailed information table, and the object pair structure or coordinate data part that has no relationship is written to the detailed information table.

4. The integrated digital geological management system according to claim 3, characterized in that: The geological data structure splitting storage unit also includes horizontal splitting, and the geological data structure horizontal splitting method steps include: Split the geological data in the table according to the upper limit of storage space of each table / the upper limit of space that affects the efficiency of storage or reading of each table; Split and copy each row of a table as a whole and store it in another data table; The index relationship between the parent table and the child table is established through the primary key ID and primary key name.

5. The integrated digital geological management system according to claim 4, characterized in that: The query efficiency evaluation method adopts a multi-objective optimization algorithm, and the evaluation objectives include the size of the retrieval storage space, the retrieval speed and the frequency of data access; The query efficiency evaluation steps of the multi-objective optimization algorithm include: Pre-store the geological data of the target to be assessed after being processed in the above-mentioned processing method according to distributed storage and non-distributed storage; Input the search object in the searcher, and collect the data values ​​of the storage space size, search speed and data access frequency of the distributed storage and non-distributed storage during the search process of the search object; Assign certain percentage values ​​to storage space size, retrieval speed, and data access frequency; Assume that the storage space size of the search object in the distributed storage space is M1, the search speed is V1, and the data access frequency is F1, and the corresponding percentages are 30%, 35%, and 35%; the storage space size of the search object in the non-distributed storage space is M2, the search speed is V2, and the data access frequency is F2, and the corresponding percentages are 35%, 30%, and 35%; the calculation formula for the distributed storage query efficiency is: The calculation formula for non-distributed storage query efficiency is:

6. The integrated digital geological management system according to claim 5, characterized in that: It also includes a time-series storage optimization unit to compress the same target geological data and the same geological data in the same relational data table; Specific timing storage optimization methods include: If the two-dimensional and three-dimensional description coordinates of the same target geological data are the same at different times or over a period of time, then one two-dimensional and three-dimensional description coordinate is stored, and the time series is stored in a non-distributed storage space or detailed information table; For the same geological data in the relational data table, one target object is selected and retained in the core search table, and other objects with the same geological data are stored in the detailed information table, and index relationships are established between other objects and the same geological data.

7. The integrated digital geological management system according to claim 6, characterized in that: It also includes a same-target object storage optimization unit, which converts the same-target geological data into the same coordinate system according to the different acquisition angles or positions of the same-target geological data, and compares whether the geological data has changed. If there is no change or the change error is within a preset range, only one type of target geological data is retained in the core retrieval table in the metadata table, and the other type of target geological data is indexed and saved in the detailed information table.