Geological data management and analysis method based on double dictionary driving

Abstract

The invention relates to the field of geological data management and analysis, in particular to a geological data management and analysis method based on double dictionary driving. The method comprises the following steps: classifying different types of geological databases, and constructing a multi-level structure of a table class; configuring the dictionary rule mapping list according to a plurality of database tables in a geological database, constructing a geological data structure dictionary table, and forming a geological data structure dictionary total set; and for different types of geological databases, constructing a geological service model dictionary table according to a data analysis function, and generating a geological service model dictionary total set. According to the method, the geological data structure dictionary and the geological service model dictionary are associated with each other by using a double-dictionary driving technology, so that a synergistic effect is realized.

Description

Technical Field

[0001] The present invention relates to the field of management and analysis of geological data, and particularly to a method for managing and analyzing geological data driven by a dual dictionary. Background Art

[0002] With the development of technology, research on the management and analysis of geological data can better utilize the value of geological data. Various geological databases, such as basic geological databases, land and resources databases, geological disaster databases, mineral exploration databases, marine exploration databases, etc., are important carriers of geological data. However, different regions will formulate different geological database structures and database standards at different data stages, which is very unfriendly to the sharing and use of geological data. Most existing geological data management models can manage and analyze geological data based on an understanding of geological data, considering the structured and unstructured characteristics of geological data, but it is difficult to uniformly manage various geological databases generated in actual geological projects. In recent years, as a relatively new model for managing geological databases, the management model of geological databases based on a control dictionary abstracts the object-oriented data model, mapping data model, and the relationship with geological data in the geological industry, and initially realizes the dynamic expansion of geological databases. However, there is still a lack of research on the management of different types of geological databases and the unified analysis of geological data in the current control dictionary for managing geological databases.

[0003] Since there are significant differences between geological data management and geological calculation analysis, defining a single geological data dictionary can neither meet the system maintenance requirements after database updates in both multi-source geological data management and calculation analysis simultaneously, nor easily cause redundancy in database design. Therefore, it is urgent to study a new method to solve the above problems. Summary of the Invention

[0004] In order to solve the problem that the existing method of managing geological databases with a single data dictionary can only abstract the object-oriented data model of various geological databases in the geological industry, and it is difficult to simultaneously consider geological business requirements, and it cannot provide both support for the expansion of geological data management and convenience for data analysis and calculation, the present invention provides a method for managing and analyzing geological data driven by a dual dictionary, which mainly includes the following steps:

[0005] S1: Classify different types of geological databases and construct a multi-level structure of table classes;

[0006] S2: Based on the multi-level structure constructed in S1, configure the dictionary rule mapping list according to multiple database tables in the geological database, construct a geological data structure dictionary table, and form a total set of geological data structure dictionaries, where the total set of geological data structure dictionaries includes a control table and a mapping relationship table;

[0007] S3: For different types of geological databases, construct a geological business model dictionary table according to the functions of data analysis;

[0008] S4: Generate a total set of geological business model dictionaries based on the geological business model dictionary table constructed in S3. The total set of geological business model dictionaries includes business data tables and function tables;

[0009] S5: Based on the double dictionaries of the total set of geological data structure dictionaries obtained in S2 and the total set of geological business model dictionaries obtained in S4, establish the mapping relationship between the internal logic tables and logic fields of the data model and the physical tables and physical fields in the database, so as to achieve the response between different databases and different application requirements by configuring the dictionary mapping relationship without modifying the program code.

[0010] A computer device includes a memory, a processor, and a computer program stored on the memory. The processor executes the computer program to implement the steps of the above method.

[0011] A computer-readable storage medium stores a computer program, and when the program is executed by a processor, the steps of the above method are implemented.

[0012] A computer program product includes a computer program or instruction, and when the program or instruction is executed by a processor, the steps of the above method are implemented.

[0013] The beneficial effects brought by the technical solution provided by the present invention are as follows: The present invention uses the double-dictionary drive technology to correlate the geological data structure dictionary and the geological business model dictionary to achieve a synergistic effect. Specifically as follows:

[0014] (1) By establishing a unified geological data structure dictionary, the integration and unified management of different geological data can be realized. The geological data structure dictionary defines and manages the structure and format of geological data, integrates geological data from different data sources and different formats into a unified data structure, solves the problem of multiple complex data warehousing, and realizes standardized management.

[0015] (2) By establishing a geological business model dictionary to define the relationship between different business functions and specific geological data, the semantic information required for realizing the business is provided. Through the rule tables and business tables that map each thematic geological database to the corresponding business function one by one, accurate and rapid search of data can be realized, and the sharing and utilization value of data can be improved.

[0016] (3) By constructing a standardized geological business model dictionary, it can help developers quickly obtain various associated data required for business, provide data service support for software development issues such as comprehensive data analysis, approximate reuse development of business, business permission access control, and isolated development of each business, improve the efficiency of data analysis and processing, and reduce the work of program developers. BRIEF DESCRIPTION OF THE DRAWINGS

[0017] The present invention will be further described below in conjunction with the drawings and embodiments. In the drawings:

[0018] Figure 1 is a framework diagram of a geological data management and analysis method based on a dual dictionary drive in an embodiment of the present invention;

[0019] Figure 2 is a design idea diagram of a geological data management and analysis method based on a dual dictionary drive in an embodiment of the present invention;

[0020] Figure 3 is a schematic diagram of a multi-level table structure in an embodiment of the present invention;

[0021] Figure 4 is a schematic diagram of the table structure of a geological data structure dictionary in an embodiment of the present invention;

[0022] Figure 5 is a schematic diagram of the table structure of a geological business model dictionary in an embodiment of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0023] In order to have a clearer understanding of the technical features, objectives, and effects of the present invention, the specific embodiments of the present invention will now be described in detail with reference to the drawings.

[0024] Embodiment 1

[0025] In the management of multi-source geological data, a geological structure data dictionary is adopted to define the table and field structure information of the geological data model, which is used to automatically generate the data manager tool code of the geological database. In this way, when the database structure changes, it is not necessary to modify the software code of the geological management system. Only through the configuration and mapping relationship of the geological business model dictionary can the geological database extension and updated geological data management, as well as the analysis and calculation of the modified data, be realized. The configuration refers to defining the control table of the dictionary and its field structure in the program. In the geological data analysis and calculation, a geological business data dictionary is adopted to define the structure information of the tables and fields commonly used in analysis and calculation in the geological data model.

[0026] By combining the geological data structure dictionary and the geological business model dictionary, it is possible to realize the multi-source geological data warehousing, management, and analysis and calculation on the premise of the dynamic expansion of the geological database. Please refer to Figure 1 ,Figure 1 This is a framework diagram of a geological data management and analysis method based on dual dictionary drive in an embodiment of the present invention. The design idea is as follows Figure 2 shown. By designing dual dictionary drive, in the data storage phase, a total set of geological data structure dictionaries is generated, and a total set of geological business model dictionaries is obtained through thinning operations to support data analysis. In the data analysis phase, n data service functions are implemented. The present invention provides a standardized underlying data storage management solution, uses geological business model dictionaries to standardize the association and coupling between business development modules and data, and improves the efficiency of software business development. By constructing geological data structure dictionaries and geological business model dictionaries, and combining the two for comprehensive management and computational analysis of geological data, automatic storage of geological data can be achieved, and data service functions can be quickly and automatically generated, making it widely applicable in various geological application development environments. The method specifically includes the following steps:

[0027] S1: Classify different types of geological databases and construct a multi-level structure of table classes; specifically:

[0028] S11: According to different unit and special topic geological databases that appear in the current geological field, such as Figure 1 Database A and Database B in, make table classes (such as Figure 1 Data Table 1, Database Table 2... Database Table n in) to implement the multi-level structure of tables, and classify each type of table. The structure of the multi-level tables obtained is as Figure 3 shown. After classification, a basic information table class, a basic drilling information table class, and a drilling stratification table class are obtained. The basic information table class includes a project registration form and a point position information table. The basic drilling information table class includes a basic drilling information table. The drilling stratification table class includes a standard stratigraphic version table, a standard stratigraphic description table, and a drilling stratification table.

[0029] Save the multi-level structure of the table data of the geological database sorted out in S1. Screen the currently existing table class structure in the database to determine whether there is a table class with this multi-level structure. If so, save this multi-level structure as a subset of this table class. If not, save this multi-level structure as a new parent class.

[0030] S12: For different databases, record the mapping structure of the external schema and the control table according to the multi-level table structure in S11.

[0031] S2: According to the multi-level table structure in S1, configure the dictionary rule mapping list according to the data tables in the geological database to form a control table and a mapping relationship table, construct the table structure of the geological data structure dictionary, and form a total set of geological data structure dictionaries; specifically:

[0032] S21: According to the multi-level table structure in S1, the configuration of the dictionary mapping rule table is completed based on the mapping relationship between the External Schema and the control table, forming the control table and the mapping relationship table; the External Schema is an important part of the three-level schema structure of the database. It mainly faces users and is the interface for users to interact with the database. The mapping relationship refers to the mapping relationship between the control table in the program and the physical table in the database. The control table in the program is the geological data structure dictionary table and the geological business model dictionary table.

[0033] When the user configures, multiple sets of configuration information can be saved locally so that when performing database warehousing of the same type, the historical configuration information can be directly selected. When performing enumeration configuration on the dictionary mapping rule table, addition, deletion, query, and modification of enumerations can be performed, and the enumeration and fields are associated through a one-to-many relationship. During geological data warehousing and query, the conversion of enumeration values can be performed. For the geological database that is imported for the first time or requires reconfiguration of the geological data structure dictionary, the geological data structure dictionary is configured according to the dictionary type, data table, and fields.

[0034] S22: Construct the geological data structure dictionary table to form the total set of the geological data structure dictionary. In view of the main characteristics of geological data such as multi-source, heterogeneous, fuzzy, spatio-temporal, and multi-element, the present invention designs and establishes standard geological data dictionaries by constructing structures such as the database and geological data structure dictionary mapping table, geological business model dictionary information table, table-dictionary relationship table, table-field relationship table, enumeration key value information table, enumeration basic information table, table-index relationship table, index table, table-foreign key relationship table, and data warehousing configuration record table.

[0035] In step S2, the geological data structure dictionary is configured according to the dictionary type, data table, and fields. During configuration, a new geological data structure dictionary type is created, a table is added to the database, and the association relationship between the tables is established. The method for constructing the geological data structure dictionary table is as Figure 4 shown. The geological data structure dictionary information table is associated with the database and geological data structure dictionary mapping table. The dictionary inside can configure the superior dictionary, forming a structure similar to a folder. Both dictionary and table information can be configured inside the dictionary. The database and data dictionary mapping table records the mapping relationship, and at most one database can correspond to one data model.

[0036] The table-dictionary relationship table is associated with the geological data structure dictionary information table. When the dictionary is deleted, the corresponding table information is cascaded and deleted. The table-field relationship table is associated with the table-dictionary relationship table. When the table is deleted, the corresponding field information is cascaded and deleted. The table-index relationship table is associated with the table-field relationship table. One index can configure multiple fields to form an index.

[0037] As Figure 4As shown in the figure, the table-field relationship table is also associated with the data storage configuration details table, the enumeration basic information table, and the table-foreign key relationship table. The data storage configuration details table, the enumeration basic information table, and the table-foreign key relationship table are respectively associated with the data storage configuration record table, the enumeration key value information table, and the foreign key information table. The table-index relationship table is associated with the index information table.

[0038] The index information table mainly records the index information of the table. One record in the data storage configuration record table corresponds to a matching rule and is associated with the user. The data storage configuration details table mainly records the table name of the user field source and the corresponding field name.

[0039] The enumeration basic information table is used to record the name and remarks of the enumeration. The enumeration key value information record table is associated with the enumeration basic information table by the auto-incrementing ID. One auto-incrementing ID can correspond to multiple enumeration records. The foreign key information table records the foreign key information. The table-foreign key relationship table is associated with the table-field relationship table. One record represents the correspondence between one field and another field.

[0040] When Figure 4 After the various geological data structure dictionary tables and the corresponding association relationships shown in the figure are built, the total set of the geological data structure dictionary is established.

[0041] S3: For different types of geological databases, construct the geological business model dictionary table according to the functions of data analysis; in view of the requirements of data sharing, data protection, business reuse, business isolation, etc. faced in software business development, the present invention designs and establishes a business model table, a business-user mapping table, a business-field mapping table, a business data structure table, a function information table, a function information details table, etc., to realize the deep mapping of business and data and the binding of function modules, and provide underlying data service support for the standardized design and modular design of business; realize one-time standardized design and multiple development reuses, and greatly reduce the software business development time and process.

[0042] As Figure 5 shown in the figure, according to the development business requirements, establish various dictionary table structures such as a business model table, a business-user mapping table, a business-field mapping table, a business data structure table, a business data structure details table, a function information details table, and a function basic information table. Among them, the business data structure table is associated with the business model table, the business-user mapping table, the business structure details table, and the function information details table. The business-field mapping table is associated with the business-user mapping table and the business data structure details table. The function information details table is associated with the function basic information table.

[0043] The business model table is mainly used to classify the data structure of the business model and isolate the business according to tags. There is no direct association relationship between the data structures of business models with different tags. The business data structure table is used to define the names of the data structures used in the actual business. The business data structure details table is mainly used to record the attribute names and types of the data structures used in the actual business, and is associated with the business data structure table through the foreign key of the business table name.

[0044] The business-user mapping table mainly records the mapping relationship between the business table and the user table, including the names of the business table, user table, and data model. A corresponding relationship is generated between the actual database and the business model through the data model name.

[0045] The business-field mapping table is mainly used to record the mapping relationship between the fields in the business table and the fields in the user table. The actual data table obtains it in real time when reading the database dictionary to ensure consistency. The function basic information table mainly records the custom interface name and description. The function information details table is mainly used to record the associations between fields and the corresponding relationships between tables, such as one-to-one and one-to-many.

[0046] S4: According to the geological business model dictionary table constructed in S3, construct the total set of the geological business model dictionary to form the business data table and the function table; specifically:

[0047] Define the data structure of the data to be queried according to the relevant business functions, and select a part of the tables and fields from the geological data structure dictionary to form the geological business model dictionary, or establish a mapping relationship between the existing geological business model dictionary and the actual database. This ensures that no matter how the actual geological database changes, the geological data can be queried through the mapping relationship of the dictionary.

[0048] S5: According to the double dictionary of the total set of the geological data structure dictionary obtained in S2 and the total set of the geological business model dictionary obtained in S4, establish the mapping relationship between the internal logic table and logic fields of the data model and the physical tables and physical fields in the database, so as to realize the response to different database and different application requirements by configuring the dictionary mapping relationship without modifying the program code. Generally, the field content of the total set of the geological business model dictionary is less than that of the total set of the geological data structure dictionary and is a subset of the total set of the geological data structure dictionary.

[0049] Embodiment 2

[0050] A computer device includes a memory, a processor, and a computer program stored on the memory. The processor executes the computer program to implement the steps of the above method.

[0051] Embodiment 3

[0052] A computer-readable storage medium stores a computer program which, when executed by a processor, implements the steps of the above method.

[0053] Embodiment 4

[0054] A computer program product includes a computer program or instruction which, when executed by a processor, implements the steps of the above method.

[0055] The foregoing are only preferred embodiments of the present invention and are not intended to limit the present invention. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principle of the present invention shall be included within the protection scope of the present invention.

Claims

1. A geological data management and analysis method based on dual dictionary drive, characterized in that It includes the following steps: S1: Classify geological databases of different types and construct a multi-level structure of table classes; S2: Based on the multi-level structure constructed in S1, configure the dictionary rule mapping list according to multiple database tables in the geological database, construct a geological data structure dictionary table, and form a total set of geological data structure dictionaries. The total set of geological data structure dictionaries includes a control table and a mapping relationship table; S3: For different types of geological databases, construct a geological business model dictionary table according to the functions of data analysis; S4: Generate a total set of geological business model dictionaries according to the geological business model dictionary table constructed in S3. The total set of geological business model dictionaries includes business data tables and function tables; S5: According to the double dictionaries of the total set of geological data structure dictionaries obtained in S2 and the total set of geological business model dictionaries obtained in S4, establish the mapping relationship between the internal logic tables and logical fields of the data model and the physical tables and physical fields in the database, so as to realize the response between different databases and different application requirements by configuring the dictionary mapping relationship without modifying the program code.

2. The geological data management and analysis method based on double dictionary drive according to claim 1, characterized in that The specific implementation process of S1 is as follows: S11: Make table classes according to geological databases of different units and different topics in the current geological field, classify each type of table, and realize the multi-level structure of the table; S12: For different databases, record the mapping structure between the external schema of the database and the control table according to the multi-level table structure in S11.

3. The geological data management and analysis method based on double dictionary drive according to claim 1, characterized in that The specific implementation process of S2 is as follows: S21: According to the multi-level structure in S1, complete the configuration of the dictionary mapping rule table by the mapping relationship between the external schema and the control table, and form a control table and a mapping relationship table; S22: Construct a geological data structure dictionary table to form a total set of geological data structure dictionaries.

4. The geological data management and analysis method based on dual dictionary driving according to claim 1, characterized in that In S2, the geological data structure dictionary is configured according to dictionary type, data table, and field. When configuring, a new geological data structure dictionary type is created, tables are added to the database, and the association relationships between the tables are established at the same time.

5. The geological data management and analysis method based on dual dictionary driving according to claim 1, characterized in that In S3, the geological business model dictionary table includes a business model table, a business-user mapping table, a business-field mapping table, a business data structure table, a business data structure details table, a function information details table, and a function basic information table. The business data structure table is associated with the business model table, the business-user mapping table, the business structure details table, and the function information details table. The business-field mapping table is associated with the business-user mapping table and the business data structure details table. The function information details table is associated with the function basic information table; The business model table is used to classify the data structure of the business model and perform business isolation according to labels. There is no direct association relationship between the data structures of business models with different labels; The business-user mapping table is used to record the mapping relationship between the business table and the user table, including the names of the business table, the user table, and the data model. The data model name makes the corresponding relationship between the actual database and the business model; The business-field mapping table is used to record the mapping relationship between the fields in the business table and the fields in the user table; The business data structure table is used to define the names of the data structures used in the actual business; The functional information details table is used to record the associations between fields and the corresponding relationships between tables. The basic functional information table is used to record the custom interface names and descriptions.

6. The method for geological data management and analysis based on double-dictionary drive according to claim 1, characterized in that, In S4, according to the relevant business functions, define the data structure of the data to be queried, and select a part of the tables and fields from the geological data structure dictionary to form the geological business model dictionary, or establish a mapping relationship between the existing geological business model dictionary and the actual database.

7. A computer device, comprising a memory, a processor, and a computer program stored on the memory, characterized in that, The processor executes the computer program to implement the steps of the geological data management and analysis method based on dual dictionary driving according to any one of claims 1-6.

8. A computer-readable storage medium, characterized in that, There is a computer program stored, and when the program is executed by the processor, the steps of the geological data management and analysis method based on dual dictionary driving according to any one of claims 1-6 are implemented.

9. A computer program product, characterized in that, It includes a computer program or instruction, and when the program or instruction is executed by the processor, the steps of the geological data management and analysis method based on dual dictionary driving according to any one of claims 1-6 are implemented.

Images