CN116595007B - Geotechnical engineering geological data management system - Google Patents
Geotechnical engineering geological data management system Download PDFInfo
- Publication number
- CN116595007B CN116595007B CN202310582603.6A CN202310582603A CN116595007B CN 116595007 B CN116595007 B CN 116595007B CN 202310582603 A CN202310582603 A CN 202310582603A CN 116595007 B CN116595007 B CN 116595007B
- Authority
- CN
- China
- Prior art keywords
- data
- server
- engineering
- database
- client
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000013523 data management Methods 0.000 title claims abstract description 28
- 238000011835 investigation Methods 0.000 claims abstract description 58
- 238000004458 analytical method Methods 0.000 claims abstract description 15
- 238000004140 cleaning Methods 0.000 claims description 30
- 238000012795 verification Methods 0.000 claims description 23
- 238000007726 management method Methods 0.000 claims description 20
- 238000005553 drilling Methods 0.000 claims description 12
- 238000012217 deletion Methods 0.000 claims description 9
- 230000037430 deletion Effects 0.000 claims description 9
- 238000012360 testing method Methods 0.000 claims description 6
- 238000011065 in-situ storage Methods 0.000 claims description 3
- 230000000717 retained effect Effects 0.000 claims description 3
- 230000000007 visual effect Effects 0.000 claims description 3
- 238000000034 method Methods 0.000 abstract description 2
- 238000005516 engineering process Methods 0.000 abstract 2
- 238000010586 diagram Methods 0.000 description 4
- 238000009825 accumulation Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000013439 planning Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004141 dimensional analysis Methods 0.000 description 1
- 238000005259 measurement Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/30—Authentication, i.e. establishing the identity or authorisation of security principals
- G06F21/31—User authentication
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/602—Providing cryptographic facilities or services
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Physics & Mathematics (AREA)
- Software Systems (AREA)
- Computer Security & Cryptography (AREA)
- Computer Hardware Design (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Health & Medical Sciences (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to the technical field of geological data management, and discloses a geotechnical engineering geological data management system which can avoid increasing the running load of a server side when a plurality of clients are simultaneously connected to the server side, can timely clean some useless data in all engineering investigation data in a database of the server side, can avoid the huge influence on the running speed of the server due to the data stored in the database of the server side, and can intuitively manage and display geological data by establishing an effective engineering geological data management system based on space geographic information and utilizing a database technology and a GIS technology, thereby improving the utilization value and the utilization rate of the geological data. The method is convenient for searching, summarizing, counting, viewing, browsing, digital map, chart and various outputs of engineering geological data at any time, develops professional analysis and three-dimensional geological functions on the basis of an engineering geological database, and makes rapid and scientific consultation and preboring service of engineering geological conditions for engineering.
Description
Technical Field
The invention relates to the technical field of geological data management, in particular to a geotechnical engineering geological data management system.
Background
The geotechnical engineering (digital model) management system combines the survey data with the map by combing and summarizing the data and the information in the modes of an internet platform, a mobile terminal App and the like, so that the comprehensive management of a large amount of engineering survey data is realized.
The existing geotechnical engineering (digital model) management system mostly adopts a C/S (client/server) architecture, so that a server can intensively manage core resources (public information resources and software resources), meanwhile, a client also has sufficient autonomous control capability (local data resources and auxiliary decision-making resources), and the client needs professional geological functions and has sufficient computing capability. Therefore, the software components can be flexibly configured by adopting the client mode, and the computing power of the client and the server can be fully utilized.
However, when a C/S (client/server) architecture is adopted, a new problem is brought, when the client and the server are connected, verification needs to be performed, otherwise, the security of data is not guaranteed, if so, several clients apply for connecting the server, the running load of the server is increased, and therefore, the client cannot be required by the same verification standard.
Meanwhile, a large amount of engineering investigation data are stored in the database at the server side, some data are out of date or some data are not used at all, the data need to be cleaned regularly by the system, and the data are imported when needed, otherwise, the data stored in the database at the server side can be caused to affect the running speed of the server too greatly.
Disclosure of Invention
The invention aims to provide a geotechnical engineering geological data management system which solves the technical problems.
The aim of the invention can be achieved by the following technical scheme:
A geotechnical engineering geological data management system comprising:
The data input module is used for inputting engineering investigation data into the database at the server side;
The data deleting module is used for thoroughly deleting engineering investigation data from the server-side database;
The client management module is used for collecting information of all clients connected with the server and generating a connection strategy between the clients and the server according to the information of the clients;
the data application analysis module is used for analyzing all engineering investigation data in the server-side database, acquiring all engineering investigation data application conditions, and generating an engineering investigation data cleaning strategy according to the engineering investigation data application conditions.
Through the technical scheme, the client management module judges whether key verification is needed when the client is accessed to the server according to the historical connection condition of the client, so that when a plurality of clients are simultaneously accessed to the server, the operation load of the server is increased, meanwhile, the data application analysis module analyzes all engineering investigation data in the database of the server, judges whether the data needs to be cleaned according to the use frequency and the idle period of the data, and when the data does not need to be cleaned, the data to be deleted is sent out to early warn according to the deletion early warning function, and the useless data in all engineering investigation data in the database of the server is timely cleaned, so that the huge influence on the operation speed of the server due to the data stored in the database of the server is avoided.
As a further description of the solution of the present invention, the workflow of the client management module includes:
Step S1, acquiring the IP of a client which is currently requested to be connected with a server, acquiring the total number of times of IP connection n T, the number of times of connection n s of the IP in a specific period and the number of addresses n d displayed by the IP in the specific period according to the IP, and checking the number of data n i of the IP in the specific period;
step S2, substituting the parameters acquired in the step S1 into the following formula to obtain an IP security coefficient K:
S3, comparing the IP safety coefficient K with a safety coefficient allowable threshold K 0;
step S4, if K is greater than or equal to K 0, the server end can be connected only by key verification, and step S5 is carried out, if K is less than K 0, the secret-free authentication is directly connected with the server end;
Step S5, update the value of K 0, let K 0 =k.
According to the technical scheme, the IP security coefficient K is in direct proportion to the number of addresses n d displayed in a specific period, the proportion of the number of times n s connected in the specific period to the total number of times n T connected and the number of times n i of checking data in the specific period, wherein the change of the number of addresses n d displayed in the specific period has a large influence on the IP security coefficient K, then the IP security coefficient K is compared with a security coefficient allowable threshold K 0, if K is greater than or equal to K 0, key verification is needed to be carried out to connect the server, step S5 is carried out, if K is smaller than K 0, the server is directly connected without secret authentication, and meanwhile, the value of K 0 is updated to enable K 0 =K.
As a further description of the solution of the present invention, the workflow of the client management module further includes:
When the IP of the client requesting to connect to the server is connected to the server for the first time in a specific period, key verification is necessary to connect to the server.
As a further description of the solution of the present invention, the workflow of the client management module further includes:
Acquiring the number m of single-day connection times in a specific period before the IP connection date of a client which is currently requested to be connected with a server;
constructing a daily connection frequency change curve m (t) according to the connection frequency m, wherein t is the number of days;
The daily connection times standard number is obtained according to the daily connection times change curve m (t):
acquiring the current request and the current number of times of connection of the client-side IP current day connected with the server-side in real time
Will beComparing with a set threshold value, ifIf the key is greater than or equal to the set threshold, the server can be connected only by key verification, and if the key is greater than or equal to the set threshold, the server can be connected only by key verification if the key is greater than or equal to the set thresholdAnd if the authentication is smaller than the set threshold value, the password-free authentication is directly connected with the server.
According to the technical scheme, the daily connection times standard number is obtained according to the daily connection times change curve m (t), and the current IP current daily connection times of the client side which requests to be connected with the server side are obtained in real timeWill beComparing with a set threshold value, ifIf the key is greater than or equal to the set threshold, the server can be connected only by key verification, and if the key is greater than or equal to the set threshold, the server can be connected only by key verification if the key is greater than or equal to the set thresholdWhen the number of the daily connection times exceeds a certain number, key authentication is needed when a single-day follow-up client accesses the server.
As a further description of the solution of the present invention, the workflow of the data application analysis module includes:
Step S10, obtaining the use frequency f, f j of all engineering investigation data in a server-side database, wherein the use frequency f, f j represents the use frequency of the j-th section data;
Step S20, acquiring the idle time T of all engineering investigation data in a database at a server side, wherein T j represents the idle time of the j-th section of data;
Step S30, obtaining the engineering investigation data cleaning index function
Wherein α and β are weight coefficients representing weights for frequency of use and idle duration, default α=β=1;
Step S40, cleaning index function of engineering investigation data Solving the cleaning index of the j-th segment dataCleaning index of j-th segment dataAnd preset cleaning index thresholdComparing;
Step S50, if Greater than or equal toDelete the segment of data ifLess thanThe piece of data is retained.
As a further description of the solution of the present invention, the workflow of the data application analysis module further includes:
Step S60, the deletion early warning function mu (f, T) is obtained:
according to the deletion early warning function mu (f, T), the m-th segment data early warning index is obtained
And comparing the early warning index mu (f, T) m with an early warning index threshold mu 0, wherein mu 0 is more than 0, and if mu (f, T) m≥μ0, deleting the data for early warning.
By the technical scheme, it can be seen that the engineering investigation data clear index functionInversely proportional to the frequency of use, the engineering survey data cleaning index functionIs proportional to the idle time, and is used for cleaning index function through engineering investigation dataSolving the cleaning index of the j-th segment dataCleaning index of j-th segment dataAnd preset cleaning index thresholdComparing, ifGreater than or equal toDelete the segment of data ifLess thanThe data is reserved, meanwhile, the reserved data is judged through deleting the early warning function mu (f, T), the early warning index mu (f, T) m is compared with an early warning index threshold mu 0, wherein mu 0 is more than 0, and if mu (f, T) m≥μ0 is deleted, early warning is carried out on the data.
As a further description of the scheme of the invention, the server-side database is stored according to the hierarchical relationship of working points, drilling, stratum data, in-situ test data and indoor test data, and engineering investigation data is managed in a tree structure layering manner.
Through the technical scheme, management operations such as browsing, deleting and loading of engineering original investigation data can be conveniently carried out.
As a further description of the solution of the present invention, the system further includes a data query module and a data display module;
The data query module comprises a query statistics unit for exploring engineering information, a query statistics unit for exploring drilling information and a query statistics unit for exploring result graph documents, and is used for setting query statistics conditions according to different purposes and completing efficient searching and multiple statistics functions of existing engineering data;
by the technical scheme, the historical engineering investigation data near a certain engineering can be quickly searched and positioned, and engineering geological investigation consultation is provided for a new engineering.
The data display module is used for visually displaying the relative positions of different investigation projects and the actual distribution of drilling holes in a graphical mode so as to achieve visual data management.
The invention has the beneficial effects that:
The client management module judges whether key verification is needed when the client is connected to the server according to the historical connection condition of the client, when a plurality of clients are simultaneously connected to the server, the operation load of the server is increased, meanwhile, the data application analysis module analyzes all engineering investigation data in a database of the server, judges whether the data need to be cleaned according to the use frequency and the idle period of the data, and when the data do not need to be cleaned, sends early warning according to a deletion early warning function, timely cleans useless data in all engineering investigation data in the database of the server, and avoids the fact that the operation speed of the server is influenced by too huge data stored in the database of the server.
Drawings
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a block diagram of a geotechnical engineering geological data management system provided by the present invention;
FIG. 2 is a bar graph intent of the geotechnical engineering geological data management system provided by the present invention;
FIG. 3 is a schematic block diagram of an engineering cross-section of the geotechnical engineering geological data management system provided by the invention;
FIG. 4 is a schematic diagram of an exploration point of the geotechnical engineering geological data management system provided by the invention;
FIG. 5 is a schematic view of a borehole details view of the geotechnical engineering geological data management system provided by the present invention;
FIG. 6 is a three-dimensional schematic of a geotechnical engineering geological data management system provided by the invention;
FIG. 7 is a schematic representation of a three-dimensional geologic volume of the geotechnical engineering geological data management system provided by the invention;
fig. 8 is a schematic diagram of three-dimensional analysis of a geotechnical engineering geological data management system provided by the invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
Referring to fig. 1, a geotechnical engineering geological data management system is characterized in that a C/S (client/server) architecture is adopted, and the geotechnical engineering geological data management system comprises:
The data input module is used for inputting engineering investigation data into the database at the server side;
the data deleting module is used for thoroughly deleting engineering investigation data from the server-side database; if it is desired to reuse the deleted engineering survey material data, it can be reintroduced
The client management module is used for collecting information of all clients connected with the server and generating a connection strategy between the clients and the server according to the information of the clients;
the data application analysis module is used for analyzing all engineering investigation data in the server-side database, acquiring all engineering investigation data application conditions, and generating an engineering investigation data cleaning strategy according to the engineering investigation data application conditions.
Through the technical scheme, the client management module judges whether key verification is needed when the client is accessed to the server according to the historical connection condition of the client, so that when a plurality of clients are simultaneously accessed to the server, the operation load of the server is increased, meanwhile, the data application analysis module analyzes all engineering investigation data in the database of the server, judges whether the data needs to be cleaned according to the use frequency and the idle period of the data, and when the data does not need to be cleaned, the data to be deleted is sent out to early warn according to the deletion early warning function, and the useless data in all engineering investigation data in the database of the server is timely cleaned, so that the huge influence on the operation speed of the server due to the data stored in the database of the server is avoided.
The workflow of the client management module comprises:
Step S1, acquiring the IP of a client which is currently requested to be connected with a server, acquiring the total number of times of IP connection n T, the number of times of connection n s of the IP in a specific period and the number of addresses n d displayed by the IP in the specific period according to the IP, and checking the number of data n i of the IP in the specific period;
step S2, substituting the parameters acquired in the step S1 into the following formula to obtain an IP security coefficient K:
S3, comparing the IP safety coefficient K with a safety coefficient allowable threshold K 0;
step S4, if K is greater than or equal to K 0, the server end can be connected only by key verification, and step S5 is carried out, if K is less than K 0, the secret-free authentication is directly connected with the server end;
Step S5, update the value of K 0, let K 0 =k.
The workflow of the client management module further comprises:
When the IP of the client requesting to connect to the server is connected to the server for the first time in a specific period, key verification is necessary to connect to the server.
According to the technical scheme, the IP security coefficient K is in direct proportion to the number of addresses n d displayed in a specific period, the proportion of the number of times n s connected in the specific period to the total number of times n T connected and the number of times n i of checking data in the specific period, wherein the change of the number of addresses n d displayed in the specific period has a large influence on the IP security coefficient K, then the IP security coefficient K is compared with a security coefficient allowable threshold K 0, if K is greater than or equal to K 0, key verification is needed to be carried out to connect the server, step S5 is carried out, if K is smaller than K 0, the server is directly connected without secret authentication, and meanwhile, the value of K 0 is updated to enable K 0 =K.
The workflow of the client management module further comprises:
Acquiring the number m of single-day connection times in a specific period before the IP connection date of a client which is currently requested to be connected with a server;
constructing a daily connection frequency change curve m (t) according to the connection frequency m, wherein t is the number of days;
The daily connection times standard number is obtained according to the daily connection times change curve m (t):
acquiring the current request and the current number of times of connection of the client-side IP current day connected with the server-side in real time
Will beComparing with a set threshold value, ifIf the key is greater than or equal to the set threshold, the server can be connected only by key verification, and if the key is greater than or equal to the set threshold, the server can be connected only by key verification if the key is greater than or equal to the set thresholdAnd if the authentication is smaller than the set threshold value, the password-free authentication is directly connected with the server.
According to the technical scheme, the daily connection times standard number is obtained according to the daily connection times change curve m (t), and the current IP current daily connection times of the client side which requests to be connected with the server side are obtained in real timeWill beComparing with a set threshold value, ifIf the key is greater than or equal to the set threshold, the server can be connected only by key verification, and if the key is greater than or equal to the set threshold, the server can be connected only by key verification if the key is greater than or equal to the set thresholdWhen the number of the daily connection times exceeds a certain number, key authentication is needed when a single-day follow-up client accesses the server.
The workflow of the data application analysis module comprises:
Step S10, obtaining the use frequency f, f j of all engineering investigation data in a server-side database, wherein the use frequency f, f j represents the use frequency of the j-th section data;
Step S20, obtaining the idle time T of all engineering investigation data in the server database,
T j represents the idle time of the j-th data;
Step S30, obtaining the engineering investigation data cleaning index function
Wherein α and β are weight coefficients representing weights for frequency of use and idle duration, default α=β=1;
It can be seen that the engineering investigation data cleaning index function Inversely proportional to the frequency of use, the engineering survey data cleaning index functionProportional to the idle time
Step S40, cleaning index function of engineering investigation dataSolving the cleaning index of the j-th segment dataCleaning index of j-th segment dataAnd preset cleaning index thresholdComparing;
Step S50, if Greater than or equal toDelete the segment of data ifLess thanThe piece of data is retained.
The workflow of the data application analysis module further comprises:
Step S60, the deletion early warning function mu (f, T) is obtained:
according to the deletion early warning function mu (f, T), the m-th segment data early warning index is obtained
And comparing the early warning index mu (f, T) m with an early warning index threshold mu 0, wherein mu 0 is more than 0, and if mu (f, T) m≥μ0, deleting the data for early warning.
By the technical scheme, it can be seen that the engineering investigation data clear index functionInversely proportional to the frequency of use, the engineering survey data cleaning index functionIs proportional to the idle time, and is used for cleaning index function through engineering investigation dataSolving the cleaning index of the j-th segment dataCleaning index of j-th segment dataAnd preset cleaning index thresholdComparing, ifGreater than or equal toDelete the segment of data ifLess thanThe data is reserved, meanwhile, the reserved data is judged through deleting the early warning function mu (f, T), the early warning index v (f, T) m is compared with an early warning index threshold mu 0, wherein mu 0 is more than 0, and if mu (f, T) m≥μ0 is deleted, early warning is carried out on the data.
The server-side database is stored according to the hierarchical relationship of the working point, drilling, stratum data, in-situ test data and indoor test data, and adopts a tree structure to hierarchically manage engineering investigation data. So as to facilitate the management operations such as browsing, deleting, loading and the like of the engineering original investigation data
The system also comprises a data query module and a data display module;
The data query module comprises a query statistics unit for exploring engineering information, a query statistics unit for exploring drilling information and a query statistics unit for exploring result graph documents, and is used for setting query statistics conditions according to different purposes and completing the functions of efficient searching and multiple statistics (multiple numbers, digital index accumulation, established attribute classification statistics and the like) of the existing engineering data;
The query statistics conditions can be set according to different purposes, so that the functions of efficient searching and multiple statistics (multiple numbers, digital index accumulation, established attribute classification statistics and the like) of the existing engineering data can be completed, and the search results can be analyzed, browsed, exported, re-queried and the like. For example, inquiring survey projects made by a survey unit, counting the total number of projects, the total number of managed drilling holes, the total footage, the number of drilling holes of various types and the like; the method can quickly find and locate the historical engineering investigation data near a certain engineering, and provide engineering geological investigation consultation for new engineering, and the like.
Through the efficient inquiry and powerful statistical functions, comprehensive engineering geological data and engineering geological consultation are provided for planning, reconnaissance, design and other departments rapidly, and continuous increment of reconnaissance data is realized.
The data display module is used for visually displaying the relative positions of different investigation projects and the actual distribution of drilling holes in a graphical mode so as to achieve visual data management.
Referring to fig. 2-5, the data display mainly includes a borehole histogram, an engineering profile, a result table, and a borehole detail information viewing function. Through the professional analysis functions, the investigation engineering stored and managed in the database at the server side can be analyzed and observed again, and necessary basis is provided for the application of comprehensive engineering geological consultation, decision analysis, scientific research and the like for planning, investigation, design and other departments.
Referring to fig. 6, the system further includes a three-dimensional module, which can generate a three-dimensional topographic map by overlapping the elevation measurement data of the topographic map with the image map.
Referring to fig. 7, the three-dimensional module can also generate a three-dimensional geological body by using geological drilling information, and can perform any subdivision including horizontal subdivision, any inclined plane subdivision and local block subdivision, so that the geological body can be observed and analyzed conveniently.
Referring to fig. 8, the three-dimensional module may further perform attribute query on the generated geological three-dimensional body, and may query specific attributes and distribution conditions of each spatial bottom layer of the geological body, so as to assist in making decisions on geological conditions. An embodiment of the present invention has been described in detail, but the description is only a preferred embodiment of the present invention and should not be construed as limiting the scope of the invention. All equivalent changes and modifications within the scope of the present invention are intended to be covered by the present invention.
Claims (6)
1. A geotechnical engineering geological data management system, comprising:
The data input module is used for inputting engineering investigation data into the database at the server side;
The data deleting module is used for thoroughly deleting engineering investigation data from the server-side database;
The client management module is used for collecting information of all clients connected with the server and generating a connection strategy between the clients and the server according to the information of the clients;
The data application analysis module is used for analyzing all engineering investigation data in the server-side database, acquiring all engineering investigation data application conditions, and generating an engineering investigation data cleaning strategy according to the engineering investigation data application conditions;
The workflow of the client management module comprises:
step S1, acquiring the IP of the client side which is currently requested to be connected with the server side, and acquiring the total number of IP connection according to the IP IP is connected to times in a specific periodAnd the number of addresses that IP displays in a particular periodIP looks at the amount of data in a particular period；
Step S2, substituting the parameters acquired in the step S1 into the following formula to obtain an IP security coefficient K:
；
S3, the IP safety factor K and the safety factor allowable threshold value are processed Comparing;
Step S4, if K is greater than or equal to The server can be connected only by key verification, and step S5 is entered, if K is smaller thanThe password-free authentication is directly connected with the server side;
step S5, updating Value of (1), let；
The workflow of the data application analysis module comprises:
S10, obtaining the frequency of use of all engineering investigation data in the server-side database ，Representing the data use frequency of the j-th section;
step S20, obtaining the idle time of all engineering investigation data in the server database ，
The j-th data idle time is represented;
Step S30, obtaining the engineering investigation data cleaning index function ：
；
Wherein,AndAs weight coefficient, represent bias to frequency of use and idle time length, default；
Step S40, cleaning index function of engineering investigation dataSolving the cleaning index of the j-th segment dataCleaning index of j-th segment dataAnd preset cleaning index thresholdComparing;
Step S50, if Greater than or equal toDelete the segment of data, ifLess thanThe piece of data is retained.
2. The geotechnical engineering geological data management system of claim 1, wherein the workflow of the client management module further comprises:
When the IP of the client requesting to connect to the server is connected to the server for the first time in a specific period, key verification is necessary to connect to the server.
3. The geotechnical engineering geological data management system of claim 2, wherein the workflow of the client management module further comprises:
Acquiring the number m of single-day connection times in a specific period before the IP connection date of a client which is currently requested to be connected with a server;
constructing a daily connection time change curve according to the connection time m T is the number of days;
according to the change curve of the number of times of daily connection Solving the standard number of daily connection times:
；
acquiring the current request and the current number of times of connection of the client-side IP current day connected with the server-side in real time ；
Will beComparing with a set threshold value, ifIf the key is greater than or equal to the set threshold, the server can be connected only by key verification, and if the key is greater than or equal to the set threshold, the server can be connected only by key verification if the key is greater than or equal to the set thresholdAnd if the authentication is smaller than the set threshold value, the password-free authentication is directly connected with the server.
4. The geotechnical engineering geological data management system of claim 1, wherein the workflow of the data application analysis module further comprises:
step S60, obtaining a deletion early warning function ：
；
According to the deletion early warning functionSolving the m-th segment data early warning index；
Will give an early warning to the indexAnd early warning index thresholdComparing the comparison, wherein,If (if)And deleting and early warning the segment of data.
5. The geotechnical engineering geological data management system according to claim 1, wherein the server-side database stores the engineering investigation data in a hierarchical relationship of working points, drilling, stratum data, in-situ test data and indoor test data, and adopts a tree structure to hierarchically manage the engineering investigation data.
6. The geotechnical engineering geological data management system according to claim 1, wherein the system further comprises a data query module and a data display module;
The data query module comprises a query statistics unit for exploring engineering information, a query statistics unit for exploring drilling information and a query statistics unit for exploring result graph documents, and is used for setting query statistics conditions according to different purposes and completing efficient searching and multiple statistics functions of existing engineering data;
The data display module is used for visually displaying the relative positions of different investigation projects and the actual distribution of drilling holes in a graphical mode so as to achieve visual data management.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310582603.6A CN116595007B (en) | 2023-05-23 | 2023-05-23 | Geotechnical engineering geological data management system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310582603.6A CN116595007B (en) | 2023-05-23 | 2023-05-23 | Geotechnical engineering geological data management system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN116595007A CN116595007A (en) | 2023-08-15 |
| CN116595007B true CN116595007B (en) | 2024-07-02 |
Family
ID=87604255
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310582603.6A Active CN116595007B (en) | 2023-05-23 | 2023-05-23 | Geotechnical engineering geological data management system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN116595007B (en) |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102915374A (en) * | 2012-11-07 | 2013-02-06 | 北京搜狐新媒体信息技术有限公司 | Method, device and system for controlling access to database resources |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7403945B2 (en) * | 2004-11-01 | 2008-07-22 | Sybase, Inc. | Distributed database system providing data and space management methodology |
| US10514986B2 (en) * | 2015-09-30 | 2019-12-24 | Commvault Systems, Inc. | Dynamic triggering of block-level backups based on block change thresholds and corresponding file identities in a data storage management system |
| US10176036B2 (en) * | 2015-10-29 | 2019-01-08 | Commvault Systems, Inc. | Monitoring, diagnosing, and repairing a management database in a data storage management system |
| CN108959399B (en) * | 2018-06-04 | 2022-07-15 | 平安科技（深圳）有限公司 | Distributed data deletion flow control method and device, electronic equipment and storage medium |
| CN109379419B (en) * | 2018-10-09 | 2021-12-17 | 上海二三四五网络科技有限公司 | CDN acceleration service control method and control device based on private cloud disk |
| CN114610679A (en) * | 2021-03-19 | 2022-06-10 | 深圳宏芯宇电子股份有限公司 | Storage device, data storage method thereof and cloud storage system |
| CN114611133A (en) * | 2021-03-19 | 2022-06-10 | 深圳宏芯宇电子股份有限公司 | Storage device and data storage management method thereof |
-
2023
- 2023-05-23 CN CN202310582603.6A patent/CN116595007B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102915374A (en) * | 2012-11-07 | 2013-02-06 | 北京搜狐新媒体信息技术有限公司 | Method, device and system for controlling access to database resources |
Also Published As
| Publication number | Publication date |
|---|---|
| CN116595007A (en) | 2023-08-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111831636B (en) | Data processing method, device, computer system and readable storage medium | |
| Liu et al. | Evolutional Data Quality: A Theory-Specific View. | |
| US9064224B2 (en) | Process driven business intelligence | |
| EP2290578A1 (en) | Method and system to configure security rights based on contextual information | |
| CN110807023B (en) | Survey management and data intelligent analysis system and method based on GIS | |
| CN111680153A (en) | Big data authentication method and system based on knowledge graph | |
| US10678797B2 (en) | Ranking of shared documents and users | |
| CN106982251B (en) | It is mobile device-based to reconnoitre project field work data reporting method and system | |
| US7035838B2 (en) | Methods and systems for organizing information stored within a computer network-based system | |
| US20040083422A1 (en) | System and method for automatically generating patent analysis reports | |
| CN116662371A (en) | Cross-domain data fusion method | |
| US20130232158A1 (en) | Data subscription | |
| CN112966162A (en) | Scientific and technological resource integration method and device based on data warehouse and middleware | |
| CN116595007B (en) | Geotechnical engineering geological data management system | |
| Fana et al. | Data Warehouse Design With ETL Method (Extract, Transform, And Load) for Company Information Centre | |
| CN112001539B (en) | High-precision passenger transport prediction method and passenger transport prediction system | |
| US20110258007A1 (en) | Data subscription | |
| Dixit et al. | Automatic recommendation for online users using web usage mining | |
| Zhang et al. | Application of data mining technology based on data center | |
| US20060005121A1 (en) | Discretization of dimension attributes using data mining techniques | |
| KR20000040270A (en) | Apparatus for managing user layer on electronic map | |
| US11507576B2 (en) | Method and system to efficiently analyze and improve database queries | |
| CN115438115A (en) | Oil field comprehensive research big data sample labeling method | |
| CN113486115A (en) | Talent information management system based on big data | |
| Ziouel et al. | SOLAP on-the-fly generalization approach based on spatial hierarchical structures |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant |