CN-122019505-A - Multi-dimensional parameter-based construction method and system for semi-cut mountain modeling database

CN122019505ACN 122019505 ACN122019505 ACN 122019505ACN-122019505-A

Abstract

The invention relates to the technical field of database structures, in particular to a method and a system for constructing a semi-cut mountain modeling database based on multidimensional parameters, comprising the following steps: and extracting the slope elevation and cutting angle fields, sorting relevant field sequences, unifying the formats, calculating the text relationship, generating numbers, dividing blocks, writing the blocks into structural texts, and forming a database structure construction map. In the invention, a regularized field cluster is formed by constructing a field value set and a structure sequence, a field jump path is established, the sequence direction is marked, the clear expression of a field combination mode and a continuing logic is realized, the content blocks are divided by combining node information, the pairing relation is adjusted, the unified format is set for enhancing the field normalization, the binding elevation and strength sections are injected through the attribute, the classification receiving and the structure reconstruction of the text record are completed, the field system output is realized by matching with the directory naming and the path registration, the sequence organization and the linkage capability among the fields are enhanced, and the expression efficiency and the expansion adaptability of the structure construction are improved.

Inventors

XU SANXIA
Hu Gaoshuo
HAN DONG
MA JIAN
LI SHIJIE
WANG HAIBIN
HUANG HE
WANG BO
GAO XIANGYU
CHEN ZEBING
YANG ZHENFENG
AI HUA
RUAN NING
LIU FENGXIANG
Qian Linfei
LI YANG
LIU LEI

Assignees

三峡新能源发电(弥勒)有限责任公司
金风科技股份有限公司

Dates

Publication Date: 20260512
Application Date: 20260203

Claims (10)

1. The construction method of the semi-cut mountain modeling database based on the multidimensional parameter is characterized by comprising the following steps of: S1, extracting a slope elevation and cutting angle field text, comparing all recorded formats with a preset standard database field format, sequentially sorting terrain curvature and rock mass strength fields, unifying text length and separation marks of a surface roughness field, and generating an initial field regulation table; S2, based on the initial field regulation table, extracting the numerical value of the cutting angle and the topography curvature, carrying out weighted coupling operation, adjusting the sequence from the surface roughness grid node field to the rock mass intensity field, and judging the recording sequence to form a field jump relation path table; S3, reading the field jump relation path table, setting a number by taking the first effective record of the slope elevation field as a starting point, generating the number according to the connection sequence of the cutting angle field, and recording a connection mode and a sequence node to obtain a sequence connection linked list; s4, referring to the sequential connection linked list, dividing blocks according to the relation between cutting angles and rock strength fields, setting the lengths and formats of the block fields, establishing the binding of slope elevation fields and rock strength grade partition fields, and generating a binding attribute distribution map; s5, calling the binding attribute distribution diagram, creating a field catalog and a record name, writing cutting angles, topography curvature and rock mass strength fields into a structure text, and generating a structure construction map of the semi-cutting mountain modeling database.
2. The multi-dimensional parameter-based half-cut mountain modeling database construction method according to claim 1, wherein the initial field regulation table comprises a slope elevation field value set, a cut angle field value set, a topography curvature and rock strength field arrangement sequence, a surface roughness field text length and a separator, the field jump relation path table comprises a field jump direction identifier, a field pairing corresponding sequence, a continuous jump text identifier and an inter-field sequential logic relation, the sequential connection linked list comprises a field number sequence, a field connection node identifier, a field sequential index and field connection labeling information, the binding attribute distribution map comprises a rock strength grade partition, a surface attribute binding relation, a block field length identifier and a block field format type, and the half-cut mountain modeling database construction map comprises a field directory naming rule, a main association record name, a structured field text content and a field information storage path.
3. The method for constructing a multi-dimensional parameter-based semi-truncated mountain modeling database according to claim 1, wherein the comparison of all recorded formats with a preset standard database field format means that unified processing is performed on field text value extraction and arrangement specifications, and consistency and comparability of field contents are verified.
4. The method for constructing the multi-dimensional parameter-based half-cut mountain modeling database according to claim 1, wherein the weighted coupling operation of the extracted cut angle and the value of the topographic curvature is to perform linear and nonlinear combination of the cut angle and the value of the topographic curvature according to preset weights, so as to characterize the comprehensive influence of the slope morphology change on the stability of the rock mass.
5. The method for constructing a semi-truncated mountain modeling database based on multidimensional parameters according to claim 1, wherein the specific steps of S1 are as follows: S101, extracting numerical content and classifying according to units or intervals based on original texts of mountain modeling slope elevation fields and cutting angle fields, comparing all recorded formats with a preset standard database field format, screening out abnormal terms of precision, symbols and length, and generating a field value specification set; S102, calling the field value specification set, sequentially positioning the topographic curvature and rock strength fields according to field names, judging the difference of field value types, rearranging, and aggregating into a unified index sequence to obtain a field arrangement structure matrix; S103, calling the field arrangement structure matrix, detecting the text length and the separation identifier of the surface roughness field, storing a standard format unified abnormal format according to a preset database, replacing the original field, and aggregating all field texts to obtain an initial field regular table.
6. The method for constructing a semi-truncated mountain modeling database based on multidimensional parameters according to claim 1, wherein the specific steps of S2 are as follows: S201, based on the initial field regulation table, extracting text records of a cutting angle field and a topography curvature field, performing coupling index calculation on numerical values of corresponding positions in the two fields, constructing a composite field value by combining actual model parameters, sequentially recording all calculation results as new text contents, and generating a field coupling characteristic sequence; s202, calling the field coupling characteristic sequence, searching the surface roughness grid node field, and adjusting the corresponding position of the roughness field in the product sequence according to the arrangement sequence of the rock mass strength field in the initial field regulation table to obtain a field reconfiguration sequence group; S203, identifying the front-back relation between the adjacent field records according to the arrangement sequence of the records in the field reconfiguration sequence group, judging the index difference value of each pair of adjacent field texts, accumulating the marks and registering if the jump directions are consistent, and aggregating all the registered contents to obtain a field jump relation path table.
7. The method for constructing a semi-truncated mountain modeling database based on multidimensional parameters according to claim 1, wherein the specific steps of S3 are as follows: S301, calling the field jump relation path table, reading the field jump direction, positioning the jump starting point position, setting a number starting value according to the first record index of the slope elevation field, and carrying out number increment processing on all jump direction records according to the jump link sequence to generate a field jump number sequence; S302, traversing the cut angle field records according to the field jump number sequence, extracting the front-back connection relation of fields corresponding to jump numbers, combining according to the number sequence to form a continuous number text, marking the connection mode among the numbers, and obtaining a number continuous record set; S303, calling the serial number continuing record set, retrieving field connection node information in serial number texts, recording the front and back sequences of each group of connection fields, marking the connection positions of the fields according to the serial number sequence, and aggregating all sequence marking results to obtain a sequence connection linked list.
8. The method for constructing a semi-truncated mountain modeling database based on multidimensional parameters according to claim 1, wherein the specific steps of S4 are as follows: s401, referring to the sequence connection linked list, reading the node content of each group of fields, carrying out block division processing on adjacent fields according to the record position relation between the cutting angle field and the rock mass strength field, carrying out pairing combination on each field group, marking the block number, and generating a field pairing block group; s402, calling the field pairing block group, identifying the text content type in the block, setting a field length identifier according to a character set structure of a field value, extracting a common separator and a data arrangement mode of the field content as format identifiers, and obtaining a field format attribute set; S403, establishing a binding relation between each paired slope elevation field and rock strength grade field according to the field format attribute set, injecting field corresponding attribute text into the binding record, aggregating all binding data structures and mapping to a graphic space to obtain a binding attribute distribution diagram.
9. The method for constructing a semi-truncated mountain modeling database based on multidimensional parameters according to claim 1, wherein the specific steps of S5 are as follows: s501, calling the binding attribute distribution map, reading field names included in each binding record, constructing a unique directory name for each record according to the original index position of the field, setting associated field names corresponding to the fields of the main record according to the arrangement sequence of the fields in the record, and generating a field directory configuration table; S502, writing the cutting angle field, the topography curvature field and the rock mass strength field into corresponding structure texts according to the field catalog configuration table, and setting unified field labels and index sequences at positions of identification fields in a text structure to obtain a structure text registration set; S503, calling the structure text registration set, carrying out path coding processing on each group of structure texts, registering the path index value according to the hierarchical relation in the field catalog, and establishing a mapping structure between the field path and the structure texts to obtain a structure construction map of the semi-cut mountain modeling database.
10. A system for constructing a multi-dimensional parameter-based semi-truncated mountain modeling database, wherein the system is configured to implement the multi-dimensional parameter-based semi-truncated mountain modeling database construction method according to any one of claims 1 to 9, the system comprising: The field preprocessing module is used for realizing S1, namely extracting the text of the slope elevation and cutting angle field, comparing all recorded formats with the preset standard database field format, orderly arranging the terrain curvature and rock strength fields, unifying the text length and separation identification of the surface roughness field, and generating an initial field regulation table; The field jump relation construction module is used for realizing S2, based on the initial field regulation table, extracting the numerical value of the cutting angle and the topography curvature, carrying out weighted coupling operation, adjusting the sequence from the surface roughness grid node field to the rock mass intensity field, and judging the recording sequence to form a field jump relation path table; the sequence link chain generation module is used for realizing S3, reading the field jump relation path table, setting a number by taking the first effective record of the slope elevation field as a starting point, generating the number according to the sequence of cutting angle field link, and recording a connection mode and sequence nodes to obtain a sequence link chain table; the attribute partition binding module is used for realizing S4, referring to the sequence linking linked list, dividing the blocks according to the relation between the cutting angle and the rock mass intensity field, setting the length and format of the block field, establishing the binding of the slope elevation field and the rock mass intensity level partition field, and generating a binding attribute distribution map; and S5, calling the binding attribute distribution diagram, creating a field catalog and a record name, writing cutting angles, topographic curvature and rock mass strength fields into a structural text, and generating a structure construction map of the semi-cut mountain modeling database.

Description

Multi-dimensional parameter-based construction method and system for semi-cut mountain modeling database Technical Field The invention relates to the technical field of database structures, in particular to a method and a system for constructing a semi-cut mountain modeling database based on multidimensional parameters. Background The technical field of database structures relates to a systematic method for organizing, storing and retrieving data, which mainly comprises data model design, data table structure definition, index optimization, data relation logic mapping, data query mechanism construction, metadata management and integrated management of a multidimensional information system. The field aims at improving the data access efficiency and the storage rationality through a structural modeling mode, is widely applied to a plurality of fields such as an information system, engineering simulation, scientific calculation and the like, and particularly in a large data scene facing to parameter complexity and high dimension characteristics, the database structure technology needs to support unified collection and analysis query of heterogeneous data so as to realize accurate data support and continuous updating capability. The traditional construction method of the semi-cut mountain modeling database is to collect the topographic variation parameters and wind resource data before and after construction, combine meteorological factors such as wind speed, wind direction, turbulence intensity and the like, use basic grid dispersion and limited number of sample data for modeling, adopt a static form mode to gather various wind condition parameters, usually use a two-dimensional or three-dimensional topographic model as a reference, and construct a query model through manual classification or manual integration of basic simulation results so as to record wind resource parameter performances under the combination of different cutting heights, cutting distances and wind directions, and generally rely on a fixed template and a separate recording strategy to finish database construction. The prior art lacks structural hierarchy and unified standard in field organization mode, field text content is not normalized, and has the problems of disordered arrangement sequence, inconsistent format and the like, so that the fields lack of clear mapping relation, field combination logic relies on manual judgment, automatic processing and accurate pairing are difficult to realize, the connection mode between data records is not clear, the field jump path is lost, the expression capability of linkage logic between parameters is limited, the node identification of the text records in the transmission process is not clear, the attributes between the fields cannot be effectively bound, the field content blocks are difficult to reasonably divide according to the feature types, the data structure expressive force is insufficient, the retrieval range is limited, and the system has obvious short plates in the aspects of multi-field collaborative modeling and combination recognition, so that the actual requirements of structure reorganization and query efficiency improvement are difficult to adapt. Disclosure of Invention In order to achieve the above purpose, the invention adopts the following technical scheme that the method for constructing the semi-truncated mountain modeling database based on multidimensional parameters comprises the following steps: S1, extracting a slope elevation and cutting angle field text, comparing all recorded formats with a preset standard database field format, sequentially sorting terrain curvature and rock mass strength fields, unifying text length and separation marks of a surface roughness field, and generating an initial field regulation table; S2, based on the initial field regulation table, extracting the numerical value of the cutting angle and the topography curvature, carrying out weighted coupling operation, adjusting the sequence from the surface roughness grid node field to the rock mass intensity field, and judging the recording sequence to form a field jump relation path table; S3, reading the field jump relation path table, setting a number by taking the first effective record of the slope elevation field as a starting point, generating the number according to the connection sequence of the cutting angle field, and recording a connection mode and a sequence node to obtain a sequence connection linked list; s4, referring to the sequential connection linked list, dividing blocks according to the relation between cutting angles and rock strength fields, setting the lengths and formats of the block fields, establishing the binding of slope elevation fields and rock strength grade partition fields, and generating a binding attribute distribution map; s5, calling the binding attribute distribution diagram, creating a field catalog and a record name, writing cutting angles, topography curvature