CN112765285A - Investigation system for carrying out various computational analysis on data and implementation method - Google Patents

Abstract

The invention belongs to the technical field of in-situ test, and particularly relates to a survey system for carrying out various computational analyses on data and an implementation method; the survey system comprises a form configuration unit and a liquefaction judgment unit, wherein the liquefaction judgment unit is configured to supplement corresponding data in a data supplement column of a liquefaction judgment form, and the calculation column calls a corresponding liquefaction judgment formula from a web server to calculate liquefaction judgment data to obtain the liquefiable degree of a soil layer and records the liquefiable degree in the corresponding calculation column; and a water and soil corrosion judging unit. The invention provides a novel survey system and an implementation method for carrying out various computational analysis on data, and the survey system and the implementation method for carrying out various computational analysis on the data can carry out liquefaction judgment calculation in multiple industries, so that comparative analysis in multiple industries can be carried out.

Description

Investigation system for carrying out various computational analysis on data and implementation method

Technical Field

The invention belongs to the technical field of seismic action analysis and corrosion analysis and application of underground water and soil, and particularly relates to a survey system for carrying out various computational analysis on data and an implementation method.

Background

The existing survey software has a single function of liquidation judgment calculation, is usually analyzed for a certain industry, and cannot perform comparative analysis of multiple industries.

The existing survey software basically has no water and soil corrosion related analysis and calculation functions, the calculation process is complex, and the manual calculation efficiency is low. Therefore, developing a set of software for water and soil erosion analysis is a technical problem that needs to be solved urgently by those skilled in the art.

Disclosure of Invention

In order to solve the problems in the prior art, the invention provides a novel survey system for carrying out various computational analysis on data and an implementation method thereof.

The specific technical scheme of the invention is as follows:

the invention provides a survey system for carrying out various computational analysis on data, which comprises the following parts:

the table configuration unit is configured to acquire liquefaction judgment data, water corrosion data and soil corrosion data, respectively call a liquefaction judgment form, a water corrosion form and a soil corrosion form according to the acquired data, and respectively import the liquefaction judgment data, the water corrosion data and the soil corrosion data into data acquisition columns of the liquefaction judgment form, the water corrosion form and the soil corrosion form to generate a liquefaction judgment table, a water corrosion table and a soil corrosion table;

the liquefaction judging unit is configured to supplement corresponding data in a data supplement column of the liquefaction judging table, and the calculation column calls a corresponding liquefaction judging formula in the web server to calculate the liquefaction judging data to obtain the liquefiable degree of the soil layer and records the liquefiable degree in the corresponding calculation column;

and the water and soil corrosion judging unit is configured to respectively supplement data in the data supplement columns of the water corrosion table and the soil corrosion table, call a water corrosion calculation formula and a soil corrosion calculation formula in the web server respectively, obtain a corrosion result on the building respectively and record the corrosion result in the corresponding calculation columns.

An implementation method for performing multiple kinds of computational analysis on data, comprising the following steps:

s1: acquiring liquefaction judgment data, water corrosion data and soil corrosion data, respectively calling a liquefaction judgment form, a water corrosion form and a soil corrosion form according to the acquired data, and respectively importing the liquefaction judgment data, the water corrosion data and the soil corrosion data into data acquisition columns of the liquefaction judgment form, the water corrosion form and the soil corrosion form to generate a liquefaction judgment table, a water corrosion table and a soil corrosion table;

s2: complementing corresponding data in a data complementing column of the liquefaction judgment table, calling a corresponding liquefaction judgment formula in a web server by a calculation column to calculate liquefaction judgment data to obtain the liquefiable degree of the soil layer, and recording the liquefiable degree in the corresponding calculation column;

s3: and respectively supplementing data in data supplementation columns of the water corrosion table and the soil corrosion table, calling a water corrosion calculation formula and a soil corrosion calculation formula in the web server, respectively obtaining a corrosivity result to the building, and recording the corrosivity result in the corresponding calculation columns.

The invention has the following beneficial effects:

the invention provides a novel survey system and an implementation method for carrying out various computational analysis on data, and the survey system and the implementation method for carrying out various computational analysis on the data can carry out liquefaction judgment calculation in multiple industries, so that comparative analysis in multiple industries can be carried out.

Drawings

FIG. 1 is a block diagram of an investigation system for performing various computational analyses on data according to the present invention;

FIG. 2 is a block diagram of a data modification unit according to the present invention;

FIG. 3 is a schematic diagram of a rail transit liquefaction decision table according to the present invention;

FIG. 4 is a schematic illustration of a water corrosivity analysis chart according to the present invention;

FIG. 5 is a schematic illustration of a soil corrosivity analysis chart according to the present invention;

FIG. 6 is a flow chart of a survey method of the present invention for performing a plurality of computational analyses on data;

FIG. 7 is a flowchart illustrating steps S6-S8 according to the present invention.

Detailed Description

The invention is further described with reference to the following figures and examples, which are provided for the purpose of illustrating the general inventive concept and are not intended to limit the scope of the invention.

The steps illustrated in the flow charts of the figures may be performed in a computer system such as a set of computer-executable instructions. Although a logical order is shown in the flow diagrams, in some cases, the steps described may be performed in an order different than here.

Example 1

In some embodiments, the present invention provides a survey system for performing a plurality of computational analyses on data, as shown in FIG. 1, the survey system comprising:

the table configuration unit 1 is configured to acquire liquefaction discrimination data, water corrosion data and soil corrosion data, respectively call a liquefaction discrimination form, a water corrosion form and a soil corrosion form according to the acquired data, and respectively import the liquefaction discrimination data, the water corrosion data and the soil corrosion data into data acquisition fields of the liquefaction discrimination form, the water corrosion form and the soil corrosion form to generate a liquefaction discrimination table, a water corrosion table and a soil corrosion table;

the liquefaction judging unit 2 is configured to supplement corresponding data in a data supplement column of the liquefaction judging table, and the calculation column calls a corresponding liquefaction judging formula in the web server to calculate the liquefaction judging data to obtain the liquefiable degree of the soil layer and records the liquefiable degree in the corresponding calculation column;

and the water and soil corrosion judging unit 3 is configured to respectively supplement data in the data supplement columns of the water corrosion table and the soil corrosion table, call a water corrosion calculation formula and a soil corrosion calculation formula in the web server, respectively obtain a corrosion result on the building, and record the corrosion result in the corresponding calculation columns.

The invention provides a novel survey system for carrying out various computational analysis on data, which can carry out liquefaction judgment calculation in multiple industries so as to carry out comparative analysis in multiple industries.

In this embodiment, the liquefaction determination data in the table configuration unit includes, but is not limited to, liquefaction determination data in the highway industry, liquefaction determination data in the rail transit industry, and liquefaction determination data in the building industry, and a liquefaction determination table is established based on the liquefaction determination data in each industry, and includes a highway liquefaction determination table, a rail transit liquefaction determination table, and a building liquefaction determination table.

In this embodiment, the liquefaction decision table, that is, the liquefaction decision calculation sheet is used to calculate the liquefiable degree of the soil layer of the current project, and corresponding data is supplemented, that is, automatic calculation can be performed, different liquefaction decision tables need to be established for liquefaction decision of different industries, as shown in fig. 3, in this embodiment, the liquefaction decision table of the rail transit industry is taken as an example; wherein, the hole number, the layer number, the lithology name, the address year, the water level burial depth, the viscosity content, the standard penetration depth, the measured value and the like are basic data, the rest is calculated according to the basic data, and the comparison analysis of the measured value and the critical value can judge whether to liquefy.

After water corrosion data is imported into a water corrosion table, namely the water corrosion analysis table shown in fig. 4, an environment type, a dry-wet alternation and an aquifer property are filled into a current interface, and then a result can be automatically calculated;

after soil corrosion data is imported into a soil corrosion table, namely the soil corrosion analysis table shown in fig. 5, an environment type, a dry-wet alternation, a soil type and soil permeability are filled into a current interface, and then a result can be automatically calculated; no matter the calculation of liquefaction judgment or the calculation of water and soil corrosion, the calculation formula is stored in the web server in advance, and only the calculation formula needs to be called in the web server.

The survey system in this embodiment further includes the following components:

the association establishing unit 4 is configured to set a correction data table in a database of the web server, respectively establish corresponding parameter tables for each parameter in the liquefaction discrimination table, the water corrosion table and the soil corrosion table, and establish association between each parameter table and the corresponding correction data table;

and the data correction unit 5 is configured to call a correction data table before calculation of the data in the liquefaction judgment table, the water corrosion table and the soil corrosion table, match the correction data table with the corresponding parameter data, start calculation if no error exists, and correct and calculate error data if the error exists.

In this embodiment, no matter the liquefaction decision data, the water corrosion data, and the soil corrosion data obtained from the liquefaction decision table, the water corrosion table, or the soil corrosion table have errors, at this time, the data needs to be corrected according to the industry standard, and the correction mode is: the method comprises the steps that a correction data table is arranged in a database of a web server, before formula calling calculation, the correction data table is matched with corresponding parameter data, calculation can be carried out only if matching is successful, synchronous correction of multiple specifications can be achieved, and the corresponding speed is high; because the algorithms of different industry specifications are different, the specifications can give out measurement indexes, and the standard of judging whether to liquefy or not is judged according to the measurement indexes, and the indexes have different judging methods in different specifications.

As shown in fig. 2, the data correction unit 5 in this embodiment includes a server-side calculation module 51, and the server-side calculation module 51 is configured to transmit the liquefaction decision table, the water corrosion table, and the soil corrosion table to the web server side, retrieve the correction data table, calculate the liquefiable degree or the corrosion result of the building after the parameter data is corrected, and send the liquefaction decision table, the water corrosion table, and the soil corrosion table, which record the calculation results, to the client side.

In this embodiment, the data correction unit 5 further includes a client calculation module 52, and the client calculation module 52 is configured to retrieve the correction data table of the web server at the client, directly calculate the liquefiable degree or the corrosiveness result to the building after the parameter data is corrected, and respectively display the liquefiable determination table, the water corrosion table, and the soil corrosion table after the calculation result is recorded.

In this embodiment, when the specification is actually corrected, there are two options, one is to perform direct calculation at the server side, and the other is to download the corrected data and the original data to the client side for calculation.

The survey system in this embodiment further includes the following components:

a user number identification unit 6 configured to automatically identify the number of users who calculate the liquefiable degree or the corrosiveness result to the building, and to send an instruction to the data acquisition unit 7 when the number of users reaches a threshold value;

the data acquisition unit 7 is configured to acquire the completion data in the liquefaction judgment table, the water corrosion table or the soil corrosion table of the client of each user and send the completion data to the web server;

the data matching unit 8 is configured to match the received completion data of each client by the web server, send an instruction for calculating a liquefiable degree or a corrosive result to a building to one of the clients that are mostly the same if the completion data of each client is at least partially the same, send the calculation result to the rest of the clients that are mostly the same, send an instruction for self-calculation to the clients that are not the same, and send an instruction for self-calculation to each client if the completion data of each client is different.

In the embodiment, the system automatically identifies the number of users, completes the area of the data form, and can send the acquired data to the server, the server performs automatic matching according to the acquired completion data, and determines whether to automatically judge and complete the completion of the rest (or not completely processing) liquefaction according to the matching result, so that the problem of low efficiency when a large number of users and a large number of data exist simultaneously is solved.

In other embodiments, the present invention provides an implementation method for performing multiple kinds of computational analysis on data, as shown in fig. 6, the implementation method includes the following steps:

s1: acquiring liquefaction judgment data, water corrosion data and soil corrosion data, respectively calling a liquefaction judgment form, a water corrosion form and a soil corrosion form according to the acquired data, and respectively importing the liquefaction judgment data, the water corrosion data and the soil corrosion data into data acquisition columns of the liquefaction judgment form, the water corrosion form and the soil corrosion form to generate a liquefaction judgment table, a water corrosion table and a soil corrosion table;

s2: complementing corresponding data in a data complementing column of the liquefaction judgment table, calling a corresponding liquefaction judgment formula in a web server by a calculation column to calculate liquefaction judgment data to obtain the liquefiable degree of the soil layer, and recording the liquefiable degree in the corresponding calculation column;

s3: and respectively supplementing data in data supplementation columns of the water corrosion table and the soil corrosion table, calling a water corrosion calculation formula and a soil corrosion calculation formula in the web server, respectively obtaining a corrosivity result to the building, and recording the corrosivity result in the corresponding calculation columns.

The invention provides a method for realizing various computational analysis of new data, which can carry out liquefaction judgment calculation in multiple industries, thereby carrying out comparative analysis in multiple industries.

In this embodiment, the liquefaction decision table, that is, the liquefaction decision calculation sheet is used to calculate the liquefiable degree of the soil layer of the current project, and corresponding data is supplemented, that is, automatic calculation can be performed, different liquefaction decision tables need to be established for liquefaction decision of different industries, as shown in fig. 3, in this embodiment, the liquefaction decision table of the rail transit industry is taken as an example; wherein, the hole number, the layer number, the lithology name, the address year, the water level burial depth, the viscosity content, the standard penetration depth, the measured value and the like are basic data, the rest is calculated according to the basic data, and the comparison analysis of the measured value and the critical value can judge whether to liquefy.

After water corrosion data is imported into a water corrosion table, namely the water corrosion analysis table shown in fig. 4, an environment type, a dry-wet alternation and an aquifer property are filled into a current interface, and then a result can be automatically calculated;

after soil corrosion data is imported into a soil corrosion table, namely the soil corrosion analysis table shown in fig. 5, an environment type, a dry-wet alternation, a soil type and soil permeability are filled into a current interface, and then a result can be automatically calculated; no matter the calculation of liquefaction judgment or the calculation of water and soil corrosion, the calculation formula is stored in the web server in advance, and only the calculation formula needs to be called in the web server.

The implementation method in this embodiment further includes the following steps:

s4: setting a correction data table in a database of a web server, respectively establishing corresponding parameter forms for each parameter in a liquefaction judgment table, a water corrosion table and a soil corrosion table, and establishing association between each parameter form and the corresponding correction data table;

s5: and (3) calling a correction data table before calculating the data in the liquefaction judgment table, the water corrosion table and the soil corrosion table, matching the correction data table with the corresponding parameter data, starting calculation if no error exists, and correcting the error data and then calculating if the error exists.

In this embodiment, when the specification is actually corrected, there are two options, one is to perform direct calculation at the server side, and the other is to download the corrected data and the original data to the client side for calculation.

Step S5 in this embodiment includes the following steps:

s51: and respectively transmitting the liquefaction judgment table, the water corrosion table and the soil corrosion table to a web server side, calling a correction data table, calculating the liquefiable degree or the corrosivity result to the building after the parameter data are corrected, and respectively transmitting the liquefaction judgment table, the water corrosion table and the soil corrosion table which record the calculation result to a client.

Preferably, step S5 includes the steps of:

s52: and calling a correction data table of the web server side at the client side, directly calculating the liquefiable degree or the corrosivity result to the building after the parameter data are corrected, and respectively displaying a liquefying judgment table, a water corrosion table and a soil corrosion table after the calculation result is recorded.

As shown in fig. 7, the implementation method in this embodiment further includes the following steps:

s6: the number of users for calculating the liquefiable degree or the corrosiveness result of the building is automatically identified, and an instruction is sent to the data acquisition unit 7 when the number of users reaches a threshold value;

s7: collecting supplement data in a liquefaction judgment table, a water corrosion table or a soil corrosion table of each user client, and sending the supplement data to a web server;

s8: the web server side matches the received completion data of the clients, if the completion data of the clients are at least partially the same, an instruction for calculating the liquefiable degree or the corrosiveness result of the building is sent to one of the clients which are most of the same clients, the calculation result is sent to the rest clients which are most of the same clients, if the completion data of the clients are different, a self-calculation instruction is sent to the clients, and if the completion data of the clients are different, a self-calculation instruction is sent to the clients.

In the embodiment, the system automatically identifies the number of users, completes the area of the data form, and can send the acquired data to the server, the server performs automatic matching according to the acquired completion data, and determines whether to automatically judge and complete the completion of the rest (or not completely processing) liquefaction according to the matching result, so that the problem of low efficiency when a large number of users and a large number of data exist simultaneously is solved.

Since the method description of the invention is implemented in a computer system. The computer system may be provided in a processor of a server or a client, for example. For example, the methods described herein may be implemented as software executable with control logic that is executed by a CPU in a server. The functionality described herein may be implemented as a set of program instructions stored in a non-transitory tangible computer readable medium. When implemented in this manner, the computer program comprises a set of instructions which, when executed by a computer, cause the computer to perform a method capable of carrying out the functions described above. Programmable logic may be temporarily or permanently installed in a non-transitory tangible computer-readable medium, such as a read-only memory chip, computer memory, disk, or other storage medium. In addition to being implemented in software, the logic described herein may be embodied using a discrete component, an integrated circuit, programmable logic used in conjunction with a programmable logic device such as a Field Programmable Gate Array (FPGA) or microprocessor, or any other device including any combination thereof. All such implementations are intended to fall within the scope of the present invention.

The above-mentioned embodiments are merely illustrative of the preferred embodiments of the present invention, and do not limit the scope of the present invention, and various modifications and improvements of the technical solution of the present invention by those skilled in the art should fall within the protection scope defined by the claims of the present invention without departing from the spirit of the present invention.

Claims (10)

1. A survey system for performing a plurality of computational analyses on data, the survey system comprising:

the table configuration unit (1) is configured to acquire liquefaction judgment data, water corrosion data and soil corrosion data, respectively call a liquefaction judgment form, a water corrosion form and a soil corrosion form according to the acquired data, and respectively import the liquefaction judgment data, the water corrosion data and the soil corrosion data into data acquisition columns of the liquefaction judgment form, the water corrosion form and the soil corrosion form to generate a liquefaction judgment table, a water corrosion table and a soil corrosion table;

the liquefaction judging unit (2) is configured to supplement corresponding data in a data supplement column of the liquefaction judging table, and the calculation column calls a corresponding liquefaction judging formula in the web server to calculate the liquefaction judging data to obtain the liquefiable degree of the soil layer and records the liquefiable degree in the corresponding calculation column;

and the water and soil corrosion judging unit (3) is configured to respectively supplement data in the data supplement columns of the water corrosion table and the soil corrosion table, call a water corrosion calculation formula and a soil corrosion calculation formula in the web server respectively, obtain the corrosivity result of the building respectively and record the corrosivity result in the corresponding calculation columns.

2. The investigation system for multiple computational analysis of data according to claim 1, wherein the liquefaction discrimination data in the table configuration unit (1) includes, but is not limited to, liquefaction discrimination data of road industry, rail transit industry and construction industry, and a liquefaction discrimination table is established based on the liquefaction discrimination data of each industry, including road liquefaction discrimination table, rail transit liquefaction discrimination table and construction liquefaction discrimination table.

3. A survey system for performing a plurality of computational analyses on data according to claim 1, the survey system further comprising:

the association establishing unit (4) is configured to set a correction data table in a database of the web server side, liquefy each parameter in the discriminant table, the water corrosion table and the soil corrosion table to respectively establish a corresponding parameter form, and establish association between each parameter form and the corresponding correction data table;

and the data correction unit (5) is configured to call the correction data table before the data in the liquefaction judgment table, the water corrosion table and the soil corrosion table are calculated, match the correction data table with the corresponding parameter data, start calculation if no error exists, and correct the error data and then calculate if the error exists.

4. The investigation system according to claim 3, wherein the data modification unit (5) comprises a server-side calculation module (51), and the server-side calculation module (51) is configured to transmit the liquefaction decision table, the water corrosion table and the soil corrosion table to the web server side respectively, retrieve the modified data table, calculate the liquefiable degree or the corrosion result of the building after the parameter data is modified, and send the liquefaction decision table, the water corrosion table and the soil corrosion table after the calculation result is recorded to the client side respectively.

5. A survey system for multiple computational analysis of data according to claim 3, wherein said data modification unit (5) further comprises a client computing module (52), said client computing module (52) is configured to retrieve a web server-side modification data sheet at the client, directly calculate the liquefiable degree or the result of corrosiveness to the building after parameter data modification, and display a liquefaction decision sheet, a water corrosion sheet and a soil corrosion sheet after recording the calculated results, respectively.

6. A survey system for performing a plurality of computational analyses on data according to claim 1, the survey system further comprising:

a user number identification unit (6) configured to automatically identify the number of users who calculate the liquefiable degree or the corrosiveness result to the building, and to send an instruction to the data acquisition unit (7) when the number of users reaches a threshold value;

the data acquisition unit (7) is configured to acquire the completion data in the liquefaction judgment table, the water corrosion table or the soil corrosion table of the client of each user and send the completion data to the web server;

and the data matching unit (8) is configured to match the received completion data of each client by the web server, send an instruction for calculating the liquefiable degree or the corrosiveness result of the building to one of the clients with respect to most of the same clients if the completion data of each client is at least partially the same, send the calculation result to the rest clients with respect to most of the same clients, send a self-calculation instruction to the clients with respect to different clients, and send a self-calculation instruction to each client if the completion data of each client is different.

7. An implementation method for performing multiple kinds of computational analysis on data is characterized by comprising the following steps:

s1: acquiring liquefaction judgment data, water corrosion data and soil corrosion data, respectively calling a liquefaction judgment form, a water corrosion form and a soil corrosion form according to the acquired data, and respectively importing the liquefaction judgment data, the water corrosion data and the soil corrosion data into data acquisition columns of the liquefaction judgment form, the water corrosion form and the soil corrosion form to generate a liquefaction judgment table, a water corrosion table and a soil corrosion table;

s2: complementing corresponding data in a data complementing column of the liquefaction judgment table, calling a corresponding liquefaction judgment formula in a web server by a calculation column to calculate liquefaction judgment data to obtain the liquefiable degree of the soil layer, and recording the liquefiable degree in the corresponding calculation column;

s3: and respectively supplementing data in data supplementation columns of the water corrosion table and the soil corrosion table, calling a water corrosion calculation formula and a soil corrosion calculation formula in the web server, respectively obtaining a corrosivity result to the building, and recording the corrosivity result in the corresponding calculation columns.

8. The method of claim 7, further comprising the steps of:

s4: setting a correction data table in a database of a web server, respectively establishing corresponding parameter forms for each parameter in a liquefaction judgment table, a water corrosion table and a soil corrosion table, and establishing association between each parameter form and the corresponding correction data table;

s5: and (3) calling a correction data table before calculating the data in the liquefaction judgment table, the water corrosion table and the soil corrosion table, matching the correction data table with the corresponding parameter data, starting calculation if no error exists, and correcting the error data and then calculating if the error exists.

9. The method for implementing multiple kinds of computational analysis on data according to claim 8, wherein the step S5 includes the steps of:

s51: respectively transmitting the liquefaction judgment table, the water corrosion table and the soil corrosion table to a web server side, calling a correction data table, calculating the liquefiable degree or the corrosion result to the building after the parameter data is corrected, and respectively transmitting the liquefaction judgment table, the water corrosion table and the soil corrosion table after recording the calculation result to a client;

preferably, step S5 includes the steps of:

s52: and calling a correction data table of the web server side at the client side, directly calculating the liquefiable degree or the corrosivity result to the building after the parameter data are corrected, and respectively displaying a liquefying judgment table, a water corrosion table and a soil corrosion table after the calculation result is recorded.

10. The method of claim 1, further comprising the steps of:

s6: the number of users for calculating the liquefiable degree or the corrosivity result of the building is automatically identified, and an instruction is sent to the data acquisition unit (7) when the number of users reaches a threshold value;

s7: collecting supplement data in a liquefaction judgment table, a water corrosion table or a soil corrosion table of each user client, and sending the supplement data to a web server;

s8: the web server side matches the received completion data of the clients, if the completion data of the clients are at least partially the same, an instruction for calculating the liquefiable degree or the corrosiveness result of the building is sent to one of the clients which are most of the same clients, the calculation result is sent to the rest clients which are most of the same clients, if the completion data of the clients are different, a self-calculation instruction is sent to the clients, and if the completion data of the clients are different, a self-calculation instruction is sent to the clients.

Images