Low-code geological result generation method and generation system

Through the low-code geological achievement generation method, preset algorithms and database verification are used to solve the problems of low efficiency of geological achievement table generation and inconsistent data in the existing technology, and efficient and accurate result table generation is achieved.

CN119088854APending Publication Date: 2024-12-06HUNAN PROVINCIAL COMM PLANNING SURVEY & DESIGN INST CO LTD
View PDF 7 Cites 0 Cited by

Patent Information

Application Number
CN202410894782.1
Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
Filing Date
2024-07-04
Publication Date
2024-12-06

AI Technical Summary

Technical Problem

When generating geological results tables, existing engineering survey software cannot achieve a unified template format due to user company specifications, owner needs and review experts' preferences, resulting in high rework rate, low efficiency and inconsistent data, affecting data accuracy.

Method used

The low-code geological result generation method is used to process the basic geological data through a preset geological result generation algorithm, including database verification and low-code statistics, and generate results that conform to the table style, associated data types and paging methods that meet specific formats.

Benefits of technology

The manual operation process of geological technicians has been greatly reduced, the work efficiency has been improved, and the accuracy of geological data and the unity of the results tables have been ensured.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN119088854A_ABST
    Figure CN119088854A_ABST
Patent Text Reader

Abstract

The invention provides a low-code geological achievement generation method and system. The method comprises the steps of obtaining basic geological data used for generating a geological achievement; performing data processing on the basic geological data through a preset geological result generation algorithm to obtain processed geological data, the data processing comprising: verifying logic completeness of the basic geological data through a preset database; and performing classified query and error content discovery on the basic geological data through a preset low-code statistical mode. And generating a geological result according to the processed geological data through preset generation software according to a preset generation format, wherein the generation format comprises a table style, an associated data type, a sorting mode and a paging mode. Through the low-code geological achievement generation process, the manual operation process of geological technicians is reduced, the working efficiency is greatly improved, and the accuracy of geological data is ensured.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present application relates to the field of data processing, and in particular to a low-code method and system for generating geological results. Background Art

[0002] The existing method of outputting the results table of engineering survey software generally uses a fixed template for statistics and output. The existing method is to quickly generate a specific template table by having software engineers establish an output method for a specific style table. The table style output by the existing method is fixed. Although the specific output data in the table can be partially adjusted, in actual work, the content and style of the results table are varied due to factors such as the user company's results specifications, the owner's results requirements, and the preferences of review experts. It cannot be summarized in a unified template format, which also leads to the above-mentioned results generation method being unable to achieve the automatic generation of general results data.

[0003] In the traditional operation mode, for the table templates preset in the software, geological technicians generally generate preliminary results through the software, and then manually adjust the table content and style to meet the requirements of the results delivery; for the results table not preset in the software, geological technicians need to use data processing software such as EXCEL to manually fill in the data and then manually count to meet the requirements of the results delivery. The above process has problems such as high rework rate and low efficiency, and due to the influence of human errors, there are often inconsistencies between the database data and the results table data, which affects the accuracy of the data. Summary of the invention

[0004] The main purpose of the embodiments of the present invention is to provide a low-code geological results generation method and generation system. Through the low-code geological results generation process, the manual operation process of geological technicians is reduced, the work efficiency is greatly improved, and the accuracy of geological data is guaranteed.

[0005] In a first aspect, a method for generating low-code geological results is provided, the method comprising:

[0006] Obtain basic geological data for generating geological results;

[0007] The basic geological data is processed by a preset geological achievement generation algorithm to obtain processed geological data, wherein the data processing includes:

[0008] Verify the logical completeness of the basic geological data through a preset database;

[0009] Furthermore, the basic geological data is categorized and queried and errors are discovered through a preset low-code statistical method.

[0010] The geological results are generated according to the processed geological data by using preset generation software in accordance with a preset generation format, wherein the generation format includes: table style, associated data type, sorting method, and paging method.

[0011] In a possible implementation, verifying the logical completeness of the basic geological data through a preset database includes:

[0012] Analyze basic geological data;

[0013] Construct a relational geological database;

[0014] Record the single-label related data and multi-table related data obtained during the data statistics process.

[0015] In a possible implementation, the classification query of the basic geological data by a preset low-code statistical method includes:

[0016] Establish a cache data key-value pair database based on standard geological data;

[0017] Obtaining data key-value pairs of the basic geological data;

[0018] The data key-value pair is compared with a cached data key-value pair database, and the category of the basic geological data is obtained according to the comparison result.

[0019] In a possible implementation, the generating of geological results according to the processed geological data by using preset generating software in a preset generating format includes:

[0020] Acquire the generation format set by the geological technician;

[0021] parsing the processed geological data into fixed text data and non-fixed text data;

[0022] Associating the non-fixed text data with a preset functional module;

[0023] Acquire first associated data through the functional module, where the first associated data is associated data of the non-fixed text;

[0024] Establish a plurality of virtual memory tables, store the non-fixed text data and the first associated data in the virtual memory tables, store the fixed text data and the second associated data in the virtual memory tables, and obtain the data written into the virtual memory tables, wherein the second associated data is the associated data of the fixed text data;

[0025] The written virtual memory table is output as a geological result.

[0026] In a second aspect, a low-code geological achievement generation system is provided, the generation system comprising:

[0027] A basic geological data acquisition module is used to acquire basic geological data for generating geological results;

[0028] The processed geological data acquisition module is used to process the basic geological data through a preset geological achievement generation algorithm to obtain processed geological data. The data processing includes:

[0029] Verify the logical completeness of the basic geological data through a preset database;

[0030] Furthermore, the basic geological data is categorized and queried and errors are discovered through a preset low-code statistical method.

[0031] The geological result generation module is used to generate geological results according to the processed geological data through preset generation software in accordance with a preset generation format, and the generation format includes: table style, associated data type, sorting method, and paging method.

[0032] In a possible implementation, the processed geological data acquisition module is used to verify the logical completeness of the basic geological data through a preset database, including:

[0033] Analyze basic geological data;

[0034] Construct a relational geological database;

[0035] Record the single-label related data and multi-table related data obtained during the data statistics process.

[0036] In a possible implementation, the processed geological data acquisition module is used to perform classified query on the basic geological data by using a preset low-code statistical method, including:

[0037] Establish a cache data key-value pair database based on standard geological data;

[0038] Obtaining data key-value pairs of the basic geological data;

[0039] The data key-value pair is compared with a cached data key-value pair database, and the category of the basic geological data is obtained according to the comparison result.

[0040] In a possible implementation, the geological achievement generation module includes:

[0041] A generation format setting unit, used for obtaining the generation format set by a geological technician;

[0042] A parsing unit, used for parsing the processed geological data into fixed text data and non-fixed text data;

[0043] An associating unit, used to associate the non-fixed text data with a preset functional module;

[0044] A first associated data acquisition unit, configured to acquire first associated data through the function module, wherein the first associated data is associated data of the non-fixed text;

[0045] A written virtual memory table acquisition unit is used to establish multiple virtual memory tables, store the non-fixed text data and the first associated data in the virtual memory table, store the fixed text data and the second associated data in the virtual memory table, and acquire the written virtual memory table, wherein the second associated data is the associated data of the fixed text data;

[0046] The geological result input unit is used to output the written virtual memory table as geological results.

[0047] In a third aspect, an electronic device is provided, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the program, a low-code method for generating geological results as provided in the first aspect is implemented.

[0048] In a fourth aspect, a non-transitory computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, a low-code method for generating geological results as provided in the first aspect is implemented. BRIEF DESCRIPTION OF THE DRAWINGS

[0049] In order to more clearly illustrate the technical solutions in the embodiments of the present application, the drawings required for use in describing the embodiments of the present application are briefly introduced below.

[0050] Figure 1 A flowchart of a method for generating low-code geological results provided by one embodiment of the present invention;

[0051] Figure 2 A schematic diagram of the correlation between basic data tables in a database provided by an embodiment of the present invention;

[0052] Figure 3 A schematic diagram of a specific data model of a power supply data table provided by an embodiment of the present invention;

[0053] Figure 4 A schematic diagram of a classification query process provided by an embodiment of the present invention;

[0054] Figure 5A schematic diagram showing the difference between using a standard interface and calling a cached data dictionary provided by an embodiment of the present invention;

[0055] Figure 6 A schematic diagram of an interface for displaying error content provided by an embodiment of the present invention;

[0056] Figure 7 A schematic diagram of a process for realizing geological achievements provided by an embodiment of the present invention;

[0057] Figure 8 A schematic diagram of a code parsing rule provided by an embodiment of the present invention;

[0058] Fig. 9 A structural diagram of a low-code geological results generation system provided by an embodiment of the present invention;

[0059] Fig.10 A schematic diagram of the physical structure of an electronic device provided by the present invention. DETAILED DESCRIPTION

[0060] The embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar modules or modules with the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present application, and cannot be interpreted as limiting the present invention.

[0061] It will be understood by those skilled in the art that, unless expressly stated, the singular forms "a", "an", "said" and "the" used herein may also include plural forms. It should be further understood that the term "comprising" used in the specification of the present application refers to the presence of the features, integers, steps, operations, modules and / or components, but does not exclude the presence or addition of one or more other features, integers, steps, operations, modules, components and / or groups thereof. It should be understood that when we refer to a module as being "connected" or "coupled" to another module, it may be directly connected or coupled to the other modules, or there may be intermediate modules. In addition, the "connection" or "coupling" used herein may include wireless connection or wireless coupling. The term "and / or" used herein includes all or any modules and all combinations of one or more associated listed items.

[0062] In order to make the objectives, technical solutions and advantages of the present application clearer, the implementation method of the present application will be further described in detail below in conjunction with the accompanying drawings.

[0063] The technical solution of the present application and how to solve the above-mentioned technical problems are described in detail below with specific embodiments. The following specific embodiments can be combined with each other, and the same or similar concepts or processes may not be repeated in some embodiments. The embodiments of the present application will be described below in conjunction with the accompanying drawings.

[0064] like Figure 1 The figure is a flow chart of a method for generating low-code geological results provided by an embodiment of the present invention, the generating method comprising:

[0065] Step S101, obtaining basic geological data for generating geological results;

[0066] Step S102, processing the basic geological data using a preset geological achievement generation algorithm to obtain processed geological data, wherein the data processing includes:

[0067] Verify the logical completeness of the basic geological data through a preset database;

[0068] Furthermore, the basic geological data is categorized and queried and errors are discovered through a preset low-code statistical method.

[0069] Step S103, generating geological results according to the processed geological data by using preset generating software in accordance with a preset generating format, wherein the generating format includes: table style, associated data type, sorting method, and paging method.

[0070] In the embodiment of the present invention, basic geological data is the basis for generating geological results. The basic geological data is usually obtained by geological prospectors through field exploration. Since geological exploration is usually carried out in places with complex and harsh environments, it is necessary to obtain more precise geological results from the basic geological data in a more accurate manner.

[0071] After obtaining the basic geological data, the basic geological data is processed through the preset geological results generation algorithm to obtain processed geological data. Among them, data processing mainly includes:

[0072] Verify the logical completeness of the basic geological data through a preset database;

[0073] Furthermore, the basic geological data is categorized and queried and errors are discovered through a preset low-code statistical method within the system.

[0074] Specifically, the preset database is mainly responsible for the analysis and management of basic geological data, providing geological technicians with data entry interfaces, data detection methods, and standard data interfaces, which facilitate the technicians to operate the geological database under the premise of ensuring the logical completeness of geological data. The database provides geological technicians with a strong verification data detection method to ensure the logical completeness of the input data. In addition to the basic geological data directly entered by the technicians, there are also some related data (single-table expansion, multi-table expansion) expanded from the basic data in the database to expand the range of optional data when generating geological results.

[0075] The low-code system is used to provide a fast way to count and analyze geological data, which is convenient for geological technicians to query, count and analyze data. Starting from the basic data categories, it performs automated statistical analysis on the data to intuitively display various types of geological data in front of technicians, making it easier for technicians to find content errors (non-logical errors) in the data, thereby ensuring the accuracy of the content during the program's automatic calculation process. The module also provides the function of outputting statistical analysis results as a specific style of EXCEL results table, which is convenient for technicians who cannot use this system to view the database data.

[0076] The low-code outside the system aims to realize the rapid generation of geological results of any style and any data, and send the generated data to the generation software. Its implementation is based on the database and the low-code module in the system. This module provides a free method for generating results tables for geological technicians through the preset EXCEL file reading method, the association method of EXCEL text code with the database, and the association method of EXCEL text with the statistical method of the module in the system. It allows geological technicians to design template files including table style, table data, analysis method, paging method, sorting method, etc. through EXCEL, and then parse the template files through this system to generate the target results table.

[0077] Wherein, the verification of the logical completeness of the basic geological data through a preset database includes:

[0078] Analyze basic geological data;

[0079] Construct a relational geological database;

[0080] Record the single-label related data and multi-table related data obtained during the data statistics process.

[0081] In the embodiment of the present invention, the main function of the database is to analyze and manage geological data and improve the accuracy of geological data. In the low-code geological results generation method, the logical flow of the database is: analyze basic geological data, build a relational geological database, and develop a strong verification data detection method → ​​According to the basic type, add the single-table association and multi-table association data existing in the data statistics process to form an extended database.

[0082] In a possible implementation, the basic data in the geological database includes exploration data and project data. The geological data mainly includes data such as cataloging, water level, in-situ testing, sampling, etc. The project data includes data such as profiles, sections, work sites, and achievement catalogs. Figure 2 Shown is a schematic diagram of the correlation between basic data tables in a database provided by an embodiment of the present invention.

[0083] When conducting completeness verification, a data detection method for all data and all related relationships in the data table is compiled based on the basic database architecture relationship to ensure the logical completeness of geological technicians during data entry. Here, the relationship detection method for the work site data table is used as an example to illustrate the implementation process. Figure 3 The figure shows a specific data model diagram of a power supply data table provided by an embodiment of the present invention.

[0084] In order to ensure the completeness of the relationship between the work site data table and the exploration point table, profile data table, and cross-section data table, the following data verification method is used when geological technicians enter data: 1. Ensure that the data type associated with other data tables and the work site data table is a unique index. For example, two boreholes named ZK13 cannot appear in the exploration point data table; 2. When entering the work point borehole, work point profile, and work point cross-section columns, verify whether the data that does not exist in the corresponding table is filled in. For example, if all the boreholes in the exploration point table are numbered ZK1 to ZK13, the engineer will refuse to enter ZK14; 3. When the associated data changes, the corresponding data in the work point data table is automatically changed. For example, if ZK1 is changed to SZK15 in the exploration point table, the first data in the work point borehole column should also be automatically replaced with SZK15; ZK2; ZK3; ZK4; ZK5; 4. In other data tables, when deleting data rows associated with the work point information table, the geological technician should be prompted to indicate the destructive nature of the operation. For example, when deleting ZK1 in the exploration point table, the technician should be prompted that the operation will cause the associated data to be deleted at the same time, and ask whether to continue the operation. This behavior is mainly to prevent the technician from causing the integrity of the associated data to be destroyed due to misoperation. Based on the above logical process, we have achieved strong verification and detection of work site information data and its relationships.

[0085] In geological results data, there are some output data calculated by basic data. This calculation process is often strange and there is no unified calculation criteria. It is difficult to use a unified function to represent the specific calculation process. The diverse algorithm implementation methods will bring catastrophic difficulties to program design. The reasonable solution should be to set up a unified data call interface. The setting of extended data is to solve this problem. In a possible implementation method, the direct input attributes of the exploration point table include drilling number, exploration point type, east coordinate, north coordinate, mileage, offset, start date, completion date and other data; the result data that needs to be calculated and output may have single-table associated data such as three-dimensional spatial position and mileage position, as well as multi-table associated data such as sampling standard text and water level standard text. During the database import process, single-table associated data can be predefined in the data table, such as adding three-dimensional spatial position => (east coordinate, north coordinate, elevation) to the exploration point table, mileage coordinate => (K + rounded (mileage / 1000) + mileage-rounded value * 1000, left or right + offset) and other single-table associated attributes; establish associated attributes related to multi-table associated data in the database, such as sampling quantity => indexing the data rows related to a certain exploration point in the sampling data table and summing them. By collecting and integrating this type of associated data as extended data, a standard calling interface for all geological data is realized (attribute name → specific data), providing a data foundation for the implementation of low-code methods.

[0086] The method of performing classified query on the basic geological data by using a preset low-code statistical method includes:

[0087] Establish a cache data key-value pair database based on standard geological data;

[0088] Obtaining data key-value pairs of the basic geological data;

[0089] The data key-value pair is compared with a cached data key-value pair database, and the category of the basic geological data is obtained according to the comparison result.

[0090] In the embodiment of the present invention, to realize the low-code statistical function in the system, it is necessary to establish three main sections: standardized input data acquisition (underlying data), statistical analysis (data operation), and output data acquisition (display data), and it is also necessary to establish a data display window as a secondary section. Figure 4 The figure is a schematic diagram of a classification query process provided by an embodiment of the present invention.

[0091] Input data acquisition is a further extension of the standard calling method. Its implementation process is to select the data table type → the computer automatically obtains the associated attributes → creates a standard key-value pair dictionary cache. In the database, we have implemented the standard calling interface of attribute name → specific data. Figure 5The figure shows the difference between the standard interface usage and the cache data dictionary call provided by one embodiment of the present invention.

[0092] In the process of data statistical analysis, directly calling the target data through the standard interface will lead to multiple calculations of the algorithm process in the extended data, affecting the calculation efficiency; while the method of calling the target data by establishing a cache data key-value pair only involves a single call to the extended data calculation process, and subsequent calculations directly apply the cached data, thereby effectively improving the calculation efficiency.

[0093] The statistical analysis method section is divided into two major types of algorithms. One is the general analysis method for a column of data, such as maximum, minimum, average, standard value and other analysis methods; the other is the method of transforming the displayed data, such as control attribute grouping method, sorting method, etc.

[0094] The output data block provides geological technicians with the ability to interact with the input data, allowing them to freely select the data attributes, the entire project or a specific work site they want to count, and extract relevant data from the input data.

[0095] By combining the output data with the display data conversion method, the results data can be displayed to technicians in the display window. The display window provides a standard style EXCEL results export method, mainly to provide a window for viewing statistical data for technicians who are unable to use this system for some reason.

[0096] Through the above logical process, we can realize the low-code statistical function in the system. As long as the logically complete data entered through the database module can be automatically counted into a specific style of achievement data. It is worth noting that the emphasis here is on logically complete data, not accurate data (content complete data). This is because in the process of geological technicians entering data, there are many errors in which the logic is correct but the content is incorrect. An important role of the low-code statistical function in the system is to help technicians reduce such errors. Figure 6 Shown is a schematic diagram of an interface for displaying error content provided by an embodiment of the present invention.

[0097] The geological technicians filled in the wrong sampling type of geological samples. For example, the fill soil should be a disturbed sample, but it was filled in as a soil sample and a rock sample during the input process. This kind of content error caused by the technician's carelessness cannot be automatically recognized by the computer software. Traditional geological software, because it only considers statistical methods based on achievement templates (not based on specific data), cannot help technicians find such errors. The technicians can only verify the accuracy of the filled-in data one by one. The system's fast statistical function for various types of data can intuitively display the specific input results of various data tables and data types, which can help technicians quickly find content errors and improve data accuracy.

[0098] The step of generating geological results according to the processed geological data by using preset generating software in a preset generating format includes:

[0099] Acquire the generation format set by the geological technician;

[0100] parsing the processed geological data into fixed text data and non-fixed text data;

[0101] Associating the non-fixed text data with a preset functional module;

[0102] Acquire first associated data through the functional module, where the first associated data is associated data of the non-fixed text;

[0103] Establish a plurality of virtual memory tables, store the non-fixed text data and the first associated data in the virtual memory tables, store the fixed text data and the second associated data in the virtual memory tables, and obtain the data written into the virtual memory tables, wherein the second associated data is the associated data of the fixed text data;

[0104] The written virtual memory table is output as a geological result.

[0105] In the embodiment of the present invention, for general geological results tables, we can divide their internal data into fixed data and non-fixed data. Fixed data is the data attribute shared by each results table, such as the style of the template file and the fixed text content of the template file; non-fixed data is the private data attribute of each data table, and generally certain data is to be filled into the data table according to certain specific rules. To realize the automatic output of general geological results tables, the basic implementation idea is: EXCEL basic data design → EXCEL data analysis → acquisition of fixed data and non-fixed data → non-fixed data analysis and identification → related data, calling of related methods → entry of non-fixed data → generation of geological results. Figure 7 The figure is a flow chart of a method for realizing geological results provided by an embodiment of the present invention.

[0106] In the process of implementing the above method, three parts are mainly involved: EXCEL software, external modules, and existing modules (database modules and low-code modules in the system). The EXCEL section is responsible for the interaction with geological technicians. It includes all the interaction processes of the module, such as: table style design, general analysis method design, system data code design, etc. The external module is the logical center of the method processing, and its main functions are as follows:

[0107] 1. Realize general data analysis of EXCEL and parse EXCEL data into style data and text data;

[0108] 2. Parse the original text data of EXCEL into fixed text data and non-fixed text data;

[0109] 3. Associate non-fixed text data with specific data and methods of existing modules in the system to implement the call of corresponding data and methods;

[0110] 4. Establish multiple virtual memory tables, fill in fixed data and associated data into the tables, and generate virtual memory tables that meet the results requirements through the processing of the association method;

[0111] 5. Export the virtual memory table as an EXCEL file.

[0112] In the actual production process, geological technicians first need to design the specific style of the table (the paper size of the table, the position of fixed text, the position of non-fixed text, the position of the table border, the line shape of the border, etc.), and then design the fixed text content in the table, and then fill in the corresponding data code according to the expected results file. Finally, fill in the method code to complete a standardized template table that can be read and generated by modules outside the system.

[0113] The styles and fixed text contents in the template table will be automatically read by the system as constants in the cache data table (without any changes). The non-fixed text contents will be parsed into pointers to corresponding data or contents, which are used to call the data and methods in the database module and the low-code module in the system. In order to meet the design requirements of general geological templates, the external modules of the system provide parsing codes for a variety of data and methods. Figure 8 Shown is a schematic diagram of a code parsing rule provided by an embodiment of the present invention.

[0114] At the data level, geological technicians can use low-code to select databases, data tables, attribute types, and attribute filling quantity (single or all). Thanks to the standardized interface for extended data (attribute name → extended data) we established in the database module, the data retrieval method of [attribute name] or {attribute name} can not only import the basic data in the database, but also import the extended data automatically calculated based on the basic data (function operations on basic data), which greatly expands the effective data range of the system.

[0115] At the method level, geological technicians can use low-code to call the data display method of the low-code section in the system, including using control attributes to group data (#Type#), fill in the entire column of data by page (#row#), and sort the data when filling in (#sort#), so as to fill the geological data into the data table according to the required style of the results table. Based on the two-level operation, we can realize the automatic generation of geological results outside the system.

[0116] It is worth noting that the above process does not implement the call of the general analysis method in the low-code module in the system (only the display method is called), but this is not a design loophole in the system. In fact, considering that EXCEL itself is a powerful data analysis software, this system specifically provides a method for calling EXCEL embedded functions during the design process. As long as the specific function operation of the cell is filled in the template file, the system can automatically analyze and fill the analysis results into the results table.

[0117] like Fig. 9 The figure shows a structural diagram of a low-code geological achievement generation system provided by an embodiment of the present invention, wherein the generation system comprises:

[0118] A basic geological data acquisition module 901 is used to acquire basic geological data for generating geological results;

[0119] The processed geological data acquisition module 902 is used to process the basic geological data using a preset geological achievement generation algorithm to obtain processed geological data. The data processing includes:

[0120] Verify the logical completeness of the basic geological data through a preset database;

[0121] Furthermore, the basic geological data is categorized and queried and errors are discovered through a preset low-code statistical method.

[0122] The geological result generation module 903 is used to generate geological results according to the processed geological data through preset generation software in accordance with a preset generation format, and the generation format includes: table style, associated data type, sorting method, and paging method.

[0123] In the embodiment of the present invention, basic geological data is the basis for generating geological results. The basic geological data is usually obtained by geological prospectors through field exploration. Since geological exploration is usually carried out in places with complex and harsh environments, it is necessary to obtain more precise geological results from the basic geological data in a more accurate manner.

[0124] After obtaining the basic geological data, the basic geological data is processed through the preset geological results generation algorithm to obtain processed geological data. Among them, data processing mainly includes:

[0125] Verify the logical completeness of the basic geological data through a preset database;

[0126] Furthermore, the basic geological data is categorized and queried and errors are discovered through a preset low-code statistical method within the system.

[0127] Specifically, the preset database is mainly responsible for the analysis and management of basic geological data, providing geological technicians with data entry interfaces, data detection methods, and standard data interfaces, which facilitate the technicians to operate the geological database under the premise of ensuring the logical completeness of geological data. The database provides geological technicians with a strong verification data detection method to ensure the logical completeness of the input data. In addition to the basic geological data directly entered by the technicians, there are also some related data (single-table expansion, multi-table expansion) expanded from the basic data in the database to expand the range of optional data when generating geological results.

[0128] The low-code system is used to provide a fast way to count and analyze geological data, which is convenient for geological technicians to query, count and analyze data. Starting from the basic data categories, it performs automated statistical analysis on the data to intuitively display various types of geological data in front of technicians, making it easier for technicians to find content errors (non-logical errors) in the data, thereby ensuring the accuracy of the content during the program's automatic calculation process. The module also provides the function of outputting statistical analysis results as a specific style of EXCEL results table, which is convenient for technicians who cannot use this system to view the database data.

[0129] The low-code outside the system aims to realize the rapid generation of geological results of any style and any data, and send the generated data to the generation software. Its implementation is based on the database and the low-code module in the system. This module provides a free method for generating results tables for geological technicians through the preset EXCEL file reading method, the association method of EXCEL text code with the database, and the association method of EXCEL text with the statistical method of the module in the system. It allows geological technicians to design template files including table style, table data, analysis method, paging method, sorting method, etc. through EXCEL, and then parse the template files through this system to generate the target results table.

[0130] The processed geological data acquisition module 902 is used to verify the logical completeness of the basic geological data through a preset database, including:

[0131] Analyze basic geological data;

[0132] Construct a relational geological database;

[0133] Record the single-label related data and multi-table related data obtained during the data statistics process.

[0134] In the embodiment of the present invention, the main function of the database is to analyze and manage geological data and improve the accuracy of geological data. In the low-code geological results generation method, the logical flow of the database is: analyze basic geological data, build a relational geological database, and develop a strong verification data detection method → ​​According to the basic type, add the single-table association and multi-table association data existing in the data statistics process to form an extended database.

[0135] In one possible implementation, the basic data in the geological database includes exploration data and project data. The geological data mainly includes cataloging, water level, in-situ testing, sampling and other data. The project data includes profiles, sections, work sites, and results catalogs.

[0136] When conducting completeness verification, a data detection method for all data and all related relationships in the data table is compiled based on the basic database architecture relationship to ensure the logical completeness of geological technicians during the data entry process. Here, the relationship detection method for the work site data table is used as an example to illustrate the implementation process.

[0137] In order to ensure the completeness of the relationship between the work site data table and the exploration point table, profile data table, and cross-section data table, the following data verification method is used when geological technicians enter data: 1. Ensure that the data type associated with other data tables and the work site data table is a unique index. For example, two boreholes named ZK13 cannot appear in the exploration point data table; 2. When entering the work point borehole, work point profile, and work point cross-section columns, verify whether the data that does not exist in the corresponding table is filled in. For example, if all the boreholes in the exploration point table are numbered ZK1 to ZK13, the engineer will refuse to enter ZK14; 3. When the associated data changes, the corresponding data in the work point data table is automatically changed. For example, if ZK1 is changed to SZK15 in the exploration point table, the first data in the work point borehole column should also be automatically replaced with SZK15; ZK2; ZK3; ZK4; ZK5; 4. In other data tables, when deleting data rows associated with the work point information table, the geological technician should be prompted to indicate the destructive nature of the operation. For example, when deleting ZK1 in the exploration point table, the technician should be prompted that the operation will cause the associated data to be deleted at the same time, and ask whether to continue the operation. This behavior is mainly to prevent the technician from causing the integrity of the associated data to be destroyed due to misoperation. Based on the above logical process, we have achieved strong verification and detection of work site information data and its relationships.

[0138] In geological results data, there are some output data calculated by basic data. This calculation process is often strange and there is no unified calculation criteria. It is difficult to use a unified function to represent the specific calculation process. The diverse algorithm implementation methods will bring catastrophic difficulties to program design. The reasonable solution should be to set up a unified data call interface. The setting of extended data is to solve this problem. In a possible implementation method, the direct input attributes of the exploration point table include drilling number, exploration point type, east coordinate, north coordinate, mileage, offset, start date, completion date and other data; the result data that needs to be calculated and output may have single-table associated data such as three-dimensional spatial position and mileage position, as well as multi-table associated data such as sampling standard text and water level standard text. During the database import process, single-table associated data can be predefined in the data table, such as adding three-dimensional spatial position => (east coordinate, north coordinate, elevation) to the exploration point table, mileage coordinate => (K + rounded (mileage / 1000) + mileage-rounded value * 1000, left or right + offset) and other single-table associated attributes; establish associated attributes related to multi-table associated data in the database, such as sampling quantity => indexing the data rows related to a certain exploration point in the sampling data table and summing them. By collecting and integrating this type of associated data as extended data, a standard calling interface for all geological data is realized (attribute name → specific data), providing a data foundation for the implementation of low-code methods.

[0139] The processed geological data acquisition module 902 is used to perform classified query on the basic geological data through a preset low-code statistical method, including:

[0140] Establish a cache data key-value pair database based on standard geological data;

[0141] Obtaining data key-value pairs of the basic geological data;

[0142] The data key-value pair is compared with a cached data key-value pair database, and the category of the basic geological data is obtained according to the comparison result.

[0143] In an embodiment of the present invention, to realize the low-code statistical function within the system, it is necessary to establish three major sections: standardized input data acquisition (underlying data), statistical analysis (data operation), and output data acquisition (display data), and it is also necessary to establish a secondary section as a data display window.

[0144] Input data acquisition is a further extension of the standard calling method. Its implementation process is to select the data table type → the computer automatically obtains the associated attributes → creates a standard key-value dictionary cache. In the database, we have implemented the standard calling interface of attribute name → specific data.

[0145] In the process of data statistical analysis, directly calling the target data through the standard interface will lead to multiple calculations of the algorithm process in the extended data, affecting the calculation efficiency; while the method of calling the target data by establishing a cache data key-value pair only involves a single call to the extended data calculation process, and subsequent calculations directly apply the cached data, thereby effectively improving the calculation efficiency.

[0146] The statistical analysis method section is divided into two major types of algorithms. One is the general analysis method for a column of data, such as maximum, minimum, average, standard value and other analysis methods; the other is the method of transforming the displayed data, such as control attribute grouping method, sorting method, etc.

[0147] The output data block provides geological technicians with the ability to interact with the input data, allowing them to freely select the data attributes, the entire project or a specific work site they want to count, and extract relevant data from the input data.

[0148] By combining the output data with the display data conversion method, the results data can be displayed to technicians in the display window. The display window provides a standard style EXCEL results export method, mainly to provide a window for viewing statistical data for technicians who are unable to use this system for some reason.

[0149] Through the above logical process, we can realize the low-code statistical function in the system. As long as the logically complete data entered through the database module can be automatically counted into a specific style of achievement data. It is worth noting that the emphasis here is on logically complete data, not accurate data (content complete data). This is because in the process of geological technicians entering data, there are many errors that are logically correct but incorrect in content, and an important role of the low-code statistical function in the system is to help technicians reduce such errors.

[0150] The geological technicians filled in the wrong sampling type of geological samples. For example, the fill soil should be a disturbed sample, but it was filled in as a soil sample and a rock sample during the input process. This kind of content error caused by the technician's carelessness cannot be automatically recognized by the computer software. Traditional geological software, because it only considers statistical methods based on achievement templates (not based on specific data), cannot help technicians find such errors. The technicians can only verify the accuracy of the filled-in data one by one. The system's fast statistical function for various types of data can intuitively display the specific input results of various data tables and data types, which can help technicians quickly find content errors and improve data accuracy.

[0151] Among them, the geological results generation module 903 includes:

[0152] A generation format setting unit, used for obtaining the generation format set by a geological technician;

[0153] A parsing unit, used for parsing the processed geological data into fixed text data and non-fixed text data;

[0154] An associating unit, used to associate the non-fixed text data with a preset functional module;

[0155] A first associated data acquisition unit, configured to acquire first associated data through the function module, wherein the first associated data is associated data of the non-fixed text;

[0156] A written virtual memory table acquisition unit is used to establish multiple virtual memory tables, store the non-fixed text data and the first associated data in the virtual memory table, store the fixed text data and the second associated data in the virtual memory table, and acquire the written virtual memory table, wherein the second associated data is the associated data of the fixed text data;

[0157] The geological result input unit is used to output the written virtual memory table as geological results.

[0158] In the embodiment of the present invention, for general geological results tables, we can divide their internal data into fixed data and non-fixed data. Fixed data is the data attribute common to each results table, such as the style of the template file and the fixed text content of the template file; non-fixed data is the private data attribute of each data table, which generally requires certain data to be filled into the data table according to certain specific rules. To realize the automatic output of general geological results tables, the basic implementation idea is: EXCEL basic data design → EXCEL data analysis → acquisition of fixed data and non-fixed data → non-fixed data analysis and identification → call of associated data and associated methods → input of non-fixed data → generation of geological results.

[0159] In the process of implementing the above method, three parts are mainly involved: EXCEL software, external modules, and existing modules (database modules and low-code modules in the system). The EXCEL section is responsible for the interaction with geological technicians. It includes all the interaction processes of the module, such as: table style design, general analysis method design, system data code design, etc. The external module is the logical center of the method processing, and its main functions are as follows:

[0160] 1. Realize general data analysis of EXCEL and parse EXCEL data into style data and text data;

[0161] 2. Parse the original text data of EXCEL into fixed text data and non-fixed text data;

[0162] 3. Associate non-fixed text data with specific data and methods of existing modules in the system to implement the call of corresponding data and methods;

[0163] 4. Establish multiple virtual memory tables, fill in fixed data and associated data into the tables, and generate virtual memory tables that meet the results requirements through the processing of the association method;

[0164] 5. Export the virtual memory table as an EXCEL file.

[0165] In the actual production process, geological technicians first need to design the specific style of the table (the paper size of the table, the position of fixed text, the position of non-fixed text, the position of the table border, the line shape of the border, etc.), and then design the fixed text content in the table, and then fill in the corresponding data code according to the expected results file. Finally, fill in the method code to complete a standardized template table that can be read and generated by modules outside the system.

[0166] The styles and fixed text contents in the template table will be automatically read by the system as constants in the cache data table (without any changes), and the non-fixed text contents will be parsed into pointers to the corresponding data or contents, which are used to retrieve the data and methods in the database module and the low-code module in the system. In order to meet the design requirements of general geological templates, the external module of the system provides parsing codes for a variety of data and methods.

[0167] At the data level, geological technicians can use low-code to select databases, data tables, attribute types, and attribute filling quantity (single or all). Thanks to the standardized interface for extended data (attribute name → extended data) we established in the database module, the data retrieval method of [attribute name] or {attribute name} can not only import the basic data in the database, but also import the extended data automatically calculated based on the basic data (function operations on basic data), which greatly expands the effective data range of the system.

[0168] At the method level, geological technicians can use low-code to call the data display method of the low-code section in the system, including using control attributes to group data (#Type#), fill in the entire column of data by page (#row#), and sort the data when filling in (#sort#), so as to fill the geological data into the data table according to the required style of the results table. Based on the two-level operation, we can realize the automatic generation of geological results outside the system.

[0169] It is worth noting that the above process does not implement the call of the general analysis method in the low-code module in the system (only the display method is called), but this is not a design flaw in the system. In fact, considering that EXCEL itself is a powerful data analysis software, this system specifically provides a method for calling EXCEL embedded functions during the design process. As long as the specific function operation of the cell is filled in the template file, the system can automatically analyze and fill the analysis results into the results table.

[0170] Fig.10 An example of a physical structure diagram of an electronic device is shown in FIG. Figure 1As shown, the electronic device may include: a processor 1001, a communication interface 1002, a memory 1003 and a communication bus 1004, wherein the processor, the communication interface and the memory communicate with each other through the communication bus. The processor may call the logic instructions in the memory to execute a low-code method for generating geological results, the method comprising: obtaining basic geological data for generating geological results; performing data processing on the basic geological data by a preset geological result generation algorithm to obtain processed geological data, the data processing comprising: verifying the logical completeness of the basic geological data by a preset database; and performing classification query and error content discovery on the basic geological data by a preset low-code statistical method. The geological results are generated according to the processed geological data by the preset generation software according to the preset generation format, the generation format comprising: table style, associated data type, sorting method, and paging method.

[0171] In addition, the logic instructions in the above-mentioned memory can be implemented in the form of software functional units and can be stored in a computer-readable storage medium when sold or used as an independent product. Based on such an understanding, the technical solution of the present invention, in essence, or the part that contributes to the prior art or the part of the technical solution, can be embodied in the form of a software product, which is stored in a storage medium and includes several instructions for a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage medium includes: various media that can store program codes, such as a USB flash drive, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk.

[0172] On the other hand, an embodiment of the present invention further provides a computer program product, the computer program product includes a computer program stored on a non-transitory computer-readable storage medium, the computer program includes program instructions, when the program instructions are executed by a computer, the computer can execute the low-code geological achievement generation method provided by the above-mentioned method embodiments, the generation method includes: obtaining basic geological data for generating geological achievements; performing data processing on the basic geological data through a preset geological achievement generation algorithm to obtain processed geological data, the data processing includes: verifying the logical completeness of the basic geological data through a preset database; and, performing classification query and error content discovery on the basic geological data through a preset low-code statistical method. Generate geological achievements according to the processed geological data according to a preset generation format through preset generation software, the generation format includes: table style, associated data type, sorting method, and paging method.

[0173] On the other hand, an embodiment of the present invention further provides a non-transitory computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, is implemented to execute the low-code geological achievement generation method provided in the above-mentioned embodiments, the generation method comprising: obtaining basic geological data for generating geological achievements; performing data processing on the basic geological data through a preset geological achievement generation algorithm to obtain processed geological data, the data processing comprising: verifying the logical completeness of the basic geological data through a preset database; and, performing classification query and error content discovery on the basic geological data through a preset low-code statistical method. The geological achievements are generated according to the processed geological data according to the preset generation software in a preset generation format, the generation format comprising: table style, associated data type, sorting method, and paging method.

[0174] It should be understood that, although the steps in the flowchart of the accompanying drawings are displayed in sequence as indicated by the arrows, these steps are not necessarily executed in sequence in the order indicated by the arrows. Unless otherwise specified herein, there is no strict order restriction on the execution of these steps, and they can be executed in other orders. Moreover, at least a part of the steps in the flowchart of the accompanying drawings may include multiple sub-steps or multiple stages, and these sub-steps or stages are not necessarily executed at the same time, but can be executed at different times, and their execution order is not necessarily sequential, but can be executed in turn or alternately with other steps or at least a part of the sub-steps or stages of other steps.

[0175] The above is only a partial implementation of the present invention. It should be pointed out that for ordinary technicians in this technical field, several improvements and modifications can be made without departing from the principles of the present invention. These improvements and modifications should also be regarded as the scope of protection of the present invention.

Claims

1. A low-code method for generating geological results, characterized in that: The generation method comprises: Obtain basic geological data for generating geological results; The basic geological data is processed by a preset geological achievement generation algorithm to obtain processed geological data, wherein the data processing includes: Verify the logical completeness of the basic geological data through a preset database; And, classify and query the basic geological data and discover errors through a preset low-code statistical method; The geological results are generated according to the processed geological data by using preset generation software in accordance with a preset generation format, wherein the generation format includes: table style, associated data type, sorting method, and paging method.

2. The generation method according to claim 1, characterized in that: The verification of the logical completeness of the basic geological data through a preset database includes: Analyze basic geological data; Construct a relational geological database; Record the single-label related data and multi-table related data obtained during the data statistics process.

3. The generation method according to claim 2, characterized in that: The classified query of the basic geological data by a preset low-code statistical method includes: Establish a cache data key-value pair database based on standard geological data; Obtaining data key-value pairs of the basic geological data; The data key-value pair is compared with a cached data key-value pair database, and the category of the basic geological data is obtained according to the comparison result.

4. The generation method according to claim 2, characterized in that: The generating of geological results according to the processed geological data by using the preset generating software in a preset generating format includes: Acquire the generation format set by the geological technician; parsing the processed geological data into fixed text data and non-fixed text data; Associating the non-fixed text data with a preset functional module; Acquire first associated data through the functional module, where the first associated data is associated data of the non-fixed text; Establish a plurality of virtual memory tables, store the non-fixed text data and the first associated data in the virtual memory tables, store the fixed text data and the second associated data in the virtual memory tables, and obtain the data written into the virtual memory tables, wherein the second associated data is the associated data of the fixed text data; The written virtual memory table is output as a geological result.

5. A low-code geological results generation system, characterized in that: The generation system comprises: A basic geological data acquisition module is used to acquire basic geological data for generating geological results; The processed geological data acquisition module is used to process the basic geological data through a preset geological achievement generation algorithm to obtain processed geological data. The data processing includes: Verify the logical completeness of the basic geological data through a preset database; And, classify and query the basic geological data and discover errors through a preset low-code statistical method; The geological result generation module is used to generate geological results according to the processed geological data through preset generation software in accordance with a preset generation format, and the generation format includes: table style, associated data type, sorting method, and paging method.

6. The generation system according to claim 5, characterized in that The processed geological data acquisition module is used to verify the logical completeness of the basic geological data through a preset database, including: Analyze basic geological data; Construct a relational geological database; Record the single-label related data and multi-table related data obtained during the data statistics process.

7. The generation system according to claim 5, characterized in that The processed geological data acquisition module is used to perform classified query on the basic geological data through a preset low-code statistical method, including: Establish a cache data key-value pair database based on standard geological data; Obtaining data key-value pairs of the basic geological data; The data key-value pair is compared with a cached data key-value pair database, and the category of the basic geological data is obtained according to the comparison result.

8. The generation system according to claim 5, characterized in that The geological achievement generation module includes: A generation format setting unit, used for obtaining the generation format set by a geological technician; A parsing unit, used for parsing the processed geological data into fixed text data and non-fixed text data; An associating unit, used to associate the non-fixed text data with a preset functional module; A first associated data acquisition unit, configured to acquire first associated data through the function module, wherein the first associated data is associated data of the non-fixed text; A written virtual memory table acquisition unit is used to establish multiple virtual memory tables, store the non-fixed text data and the first associated data in the virtual memory table, store the fixed text data and the second associated data in the virtual memory table, and acquire the written virtual memory table, wherein the second associated data is the associated data of the fixed text data; The geological result input unit is used to output the written virtual memory table as geological results.

9. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, it implements a low-code method for generating geological results as described in any one of claims 1-4.

10. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, it implements a low-code method for generating geological results as described in any one of claims 1-4.

Citation Information

Patent Citations

  • Method for quickly extracting geological effective information

    CN106407223A

  • Knowledge graph construction method and device, terminal and storage medium

    CN112199516A

  • JSON-to-SQL method and device, terminal and storage medium

    CN115577032A

  • Table code automatic generation method and device, electronic equipment and storage medium

    CN116360787A

  • Hydrogeological exploration information generation system

    CN116562246A