CN110458712B - Pressure test method, device, equipment and storage medium for repayment capability - Google Patents
Pressure test method, device, equipment and storage medium for repayment capability Download PDFInfo
- Publication number
- CN110458712B CN110458712B CN201910603375.XA CN201910603375A CN110458712B CN 110458712 B CN110458712 B CN 110458712B CN 201910603375 A CN201910603375 A CN 201910603375A CN 110458712 B CN110458712 B CN 110458712B
- Authority
- CN
- China
- Prior art keywords
- formula
- field
- calculation formula
- target calculation
- rule
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/08—Insurance
Landscapes
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Engineering & Computer Science (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention is applicable to the technical field of computers, and provides a pressure test method, a device, equipment and a storage medium for repayment capability, wherein the method comprises the following steps: when a pressure test request of the repayment capability is received, a field identification set corresponding to the pressure test request of the repayment capability is obtained according to a defined field identification rule, a target calculation formula corresponding to each field identification in the field identification set and a calculation priority of the target calculation formula are searched from an established field information table, and the target calculation formula is sequentially analyzed according to a preset formula analysis rule and the calculation priority, so that a pressure test result of the repayment capability is obtained, the maintenance cost in the pressure test process of the repayment capability is reduced, and the test efficiency is improved.
Description
Technical Field
The invention belongs to the technical field of computers, and particularly relates to a pressure test method, device and equipment for repayment capability and a storage medium.
Background
The pressure test of repayment capacity of the insurance company is finished through an Excel table at present, namely, the original data related to the pressure test to be executed are firstly stored in the Excel table, and then the final pressure test target is achieved by carrying out formula configuration corresponding to the pressure test on the Excel table.
In order to meet the requirement of complex and changeable pressure test, a large number of calculation formulas generally exist in Excel, so that maintenance is not easy, complex association relations are established among part of formulas, once the formulas are changed, huge workload is generated, the formulas are difficult to maintain, and the pressure test efficiency is low.
Disclosure of Invention
The invention aims to provide a pressure test method, device, equipment and storage medium for repayment capability, which aim to solve the problems of difficulty in formula maintenance and low calculation efficiency in the pressure test process of repayment capability in the prior art.
In one aspect, the present invention provides a method of testing the pressure of a repayment capability, the method comprising the steps of:
When a pressure test request of repayment capability is received, acquiring a field identification set corresponding to the pressure test request of repayment capability according to a defined field identification rule;
Searching a target calculation formula corresponding to each field identifier in the field identifier set and calculation logic parameters corresponding to the target calculation formula from an established field information table;
and sequentially analyzing the target calculation formula according to a preset formula analysis rule and the calculation logic parameters to obtain a pressure test result of the repayment capability.
Preferably, before the step of obtaining the field identification set corresponding to the pressure test request of repayment capability according to the defined field identification rule, the method includes:
receiving scene data input by a user;
Acquiring the field identification set corresponding to the scene data according to the scene data;
And generating a pressure test request of repayment capacity corresponding to the scene data according to the acquired field identification set.
Preferably, the step of sequentially parsing the target calculation formula according to a preset formula parsing rule and the calculation logic parameter includes:
Judging the formula type of the target calculation formula, wherein the formula type comprises a simple four-rule operation formula and a complex logic operation method;
If the formula type of the target calculation formula is a simple four-rule calculation formula, analyzing the target calculation formula according to a preset four-rule calculation analysis rule;
And if the formula type of the target calculation formula is a complex logic operation method, analyzing the target calculation formula according to a preset complex logic operation analysis rule.
Preferably, the method further comprises:
When a formula backtracking request is received, acquiring a first field identifier and a second field identifier corresponding to the formula backtracking request according to the defined field identifier rule;
Searching a first target calculation formula corresponding to the first field identifier from the established field information table;
Analyzing the first target calculation formula according to a preset backtracking formula analysis rule and a second field identifier to obtain a second target calculation formula;
and updating the first target calculation formula into the second target calculation formula.
Preferably, after the step of updating the first target calculation formula to the second target calculation formula, the method further includes:
when a data backtracking request is received, acquiring a field identifier corresponding to the data backtracking request according to the defined field identifier rule;
Searching the second target calculation formula corresponding to the field identification from the established field information table;
and analyzing the second target calculation formula according to a preset formula analysis rule to obtain a data backtracking result.
In another aspect, the present invention provides a repayment capability pressure test device, comprising:
The test request processing unit is used for acquiring a field identification set corresponding to the pressure test request of the repayment capability according to a defined field identification rule when the pressure test request of the repayment capability is received;
the formula searching unit is used for searching a target calculation formula corresponding to each field identifier in the field identifier set and a calculation logic parameter corresponding to the target calculation formula from the established field information table; and
And the formula analysis unit is used for sequentially analyzing the target calculation formula according to a preset formula analysis rule and the calculation logic parameters so as to obtain a pressure test result of the repayment capability.
Preferably, the apparatus further comprises:
A scene data receiving unit for receiving scene data input by a user;
A scene data processing unit, configured to obtain, according to the scene data, the field identifier set corresponding to the scene data; and
And the test request generation unit is used for generating a pressure test request of repayment capacity corresponding to the scene data according to the acquired field identification set.
Preferably, the apparatus further comprises:
The backtracking request processing unit is used for acquiring a first field identifier and a second field identifier corresponding to the formula backtracking request according to the defined field identifier rule when the formula backtracking request is received;
a first formula searching unit, configured to search a first target calculation formula corresponding to the first field identifier from the established field information table;
the second formula generation unit is used for analyzing the first target calculation formula according to a preset backtracking formula analysis rule and a second field identifier to obtain a second target calculation formula;
and the formula replacing unit is used for updating the first target calculation formula into the second target calculation formula.
In another aspect, the present invention also provides a computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, the processor implementing the steps of the method as described above when executing the computer program.
In another aspect, the invention also provides a computer readable storage medium storing a computer program which, when executed by a processor, implements the steps of the method as described above.
When a pressure test request of the repayment capability is received, a field identification set corresponding to the pressure test request of the repayment capability is obtained according to a defined field identification rule, a target calculation formula corresponding to each field identification in the field identification set and the calculation priority of the target calculation formula are searched from an established field information table, and the target calculation formula is sequentially analyzed according to a preset formula analysis rule and the calculation priority, so that a pressure test result of the repayment capability is obtained, the maintenance cost in the pressure test process of the repayment capability is reduced, and the test efficiency is improved.
Drawings
FIG. 1 is a flow chart of an implementation of a method for testing the pressure of repayment capability provided by an embodiment of the present invention;
FIG. 2 is a flow chart of an implementation of a scenario-based repayment capability pressure test method according to a second embodiment of the present invention;
fig. 3 is a flowchart of an implementation of the formula backtracking method provided in the third embodiment of the present invention;
Fig. 4 is a flowchart of an implementation of a data backtracking method according to a fourth embodiment of the present invention;
FIG. 5 is a schematic diagram of a pressure testing device with repayment capability according to a fifth embodiment of the present invention;
FIG. 6 is a flow chart showing the construction of a scenario-based repayment capability pressure test device according to a sixth embodiment of the present invention;
Fig. 7 is a structural flow chart of a formula backtracking device provided in the seventh embodiment of the present invention;
fig. 8 is a structural flow chart of a data backtracking device according to an eighth embodiment of the present invention; and
Fig. 9 is a schematic structural diagram of a computer device according to a ninth embodiment of the present invention.
Detailed Description
The present invention will be described in further detail with reference to the drawings and examples, in order to make the objects, technical solutions and advantages of the present invention more apparent. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the scope of the invention.
The following describes in detail the implementation of the present invention in connection with specific embodiments:
embodiment one:
Fig. 1 shows a flow chart of implementation of the pressure test method for repayment capability according to the first embodiment of the present invention, and for convenience of explanation, only the relevant parts of the embodiment of the present invention are shown in detail as follows:
in step S101, when a request for a pressure test of a repayment capability is received, a set of field identifications corresponding to the request for a pressure test of a repayment capability is acquired according to a defined field identification rule.
In the embodiment of the invention, the calculation method is suitable for database systems such as Oracle, SQL SERVER, mysql and the like. When a field identification set corresponding to the pressure test request of the repayment capability is acquired according to a defined field identification rule, specifically, when the pressure test request of the repayment capability is received, a request parameter of the pressure test request of the repayment capability is read, the request parameter carries field identification information, a field identification contained in the request parameter is acquired according to the defined field identification rule, and the acquired set of one or more field identification combinations is the field identification set corresponding to the pressure test request of the repayment capability. It should be noted that, the field identifier carried in the request parameter of each repayment capability pressure test request is pre-established by the user according to the actual computing requirement, and the request parameter of each repayment capability pressure test request may carry one field identifier or may carry a plurality of field identifiers, which is not limited herein.
Before the field identification corresponding to the pressure test request of repayment capability is obtained according to the defined field identification rule, the field identification rule needs to be defined, and when the field identification rule is defined, specifically, the field serial number and the parent class of the field can be respectively defined, and the association mode of the field serial number and the field parent class is established, so that the defined field identification can establish a corresponding relation with the target field.
As an example, if the parent sheet1 of the definition table is CA, the field numbers of the definition field net earned premium, earned premium and earned premium revenue are 1,2 and 3, respectively, and the association manner between the two is "_", the field net earned premium, earned premium and earned revenue field identifications are ca_1, ca_2 and ca_3, respectively.
List one
Here, when the field definition is performed, one field identifier may be defined for each field, or one field identifier may be defined for a plurality of fields, for example, two fields of unexpired preparation gold extraction and unexpired preparation gold conversion in table one may be defined as ca—4.
In step S102, a target calculation formula corresponding to each field identifier in the set of field identifiers and a calculation logic parameter corresponding to the target calculation formula are searched from the established field information table.
In the embodiment of the present invention, before searching the target calculation formula corresponding to the field identifier from the established field information table, the field information table needs to be established, where the field information table includes a calculation formula corresponding to each field identifier and a calculation logic parameter corresponding to the calculation formula, where the calculation logic parameter may be one or more, and the logic parameter at least includes a calculation priority of the target calculation formula, and of course, may also include information other than the calculation priority, for example, a dangerous seed number, etc., which is not limited herein. When searching a calculation method corresponding to the field identifier from the established field information table, specifically, splitting the field identifier according to the association relation between the defined field parent class and the field sequence number to obtain the field parent class identifier and the field sequence number, searching a set matched with the field parent class identifier from the field information table, and finally positioning a term matched with the field sequence number in the searched set containing the field parent class identifier according to the field sequence number to obtain a calculation formula corresponding to the term and a calculation priority, such as priority, of the calculation formula, wherein the calculation formula is a target calculation formula, and the priority of the calculation formula is a calculation logic parameter of the target calculation formula.
As an example, the field information table includes a field parent class, a field sequence number and a calculation formula, where the field parent class CA and the field sequence number 1 correspond to formula one, the association relationship between the field parent class and the field sequence number is defined as "_1", if the field identifier is ca_1, the field identifier is split according to the association relationship to obtain the field parent class CA and the field sequence number 1, then a set of the field parent class CA is searched for in the field information table, and finally a term of the field sequence number 1 is searched for in the searched set of the field parent class CA, so that the calculation formula corresponding to the field identifier ca_1 is obtained as formula one, and the calculation priority corresponding to the calculation formula one is 1 level.
| Field sequence number | Parent class | …… | Calculation formula | Calculation order |
| 1 | CA | …… | Equation one | 1 |
| 2 | CA | …… | Equation one | 2 |
| 3 | CA | …… | Equation one | 3 |
| 1 | CB | …… | Formula II | 4 |
Watch II
Of course, the field information table may also include information other than field identifiers and calculation methods, such as field names, field subclasses, dangerous serial numbers, etc., to meet actual calculation requirements, which is not limited herein.
In step S103, the target calculation formula is sequentially parsed according to the preset formula parsing rule and the calculation logic parameters, so as to obtain the pressure test result of the repayment capability.
In the embodiment of the present invention, the types of the target calculation formulas include simple four-rule calculation formulas and complex logic calculation methods, specifically, the simple four-rule calculation formulas may be simple four-rule calculation formulas composed of addition, subtraction, multiplication and division, for example, ca—1 x 0.8, where it is to be noted that in the simple four-rule calculation formulas, no operators (for example, brackets) other than addition, subtraction, multiplication and addition will occur, and the complex logic calculation methods may be complex calculation methods composed of the above simple four-rule calculation and one or more dimension logics and placeholders, for example, complex calculation methods composed of different time logics and simple four-rule calculation.
When the target calculation formula is sequentially analyzed according to a preset formula analysis rule and calculation logic parameters, the preset formula analysis rule is understood to be a formula analysis rule established for a calculation method, for example, a mode of searching a value corresponding to a character identifier, a segmentation mode of a formula, a data storage rule in an analysis process and the like. The preset formula analysis rules may include different analysis rules set for different calculation methods, and the preset formula analysis rules may include simple four-rule operation analysis rules and complex logic method analysis rules. When the calculation formula is analyzed according to a preset formula analysis rule, preferably, the formula type of the target calculation formula is judged, if the formula type of the target calculation formula is a simple four-rule calculation formula, the target calculation formula is analyzed according to the preset four-rule calculation analysis rule, and if the formula type of the target calculation formula is a complex logic operation method, the target calculation formula is analyzed according to the preset complex logic operation analysis rule, so that the analysis efficiency of the calculation method is improved.
In judging the formula type of the calculation formula, specifically, the judgment can be performed by judging whether the calculation formula contains brackets, if yes, the calculation formula is judged to be a complex logic operation method, otherwise, the calculation formula is judged to be a simple four-rule operation formula, and of course, the formula type can also be judged by other methods, for example, by judging whether the calculation formula contains: symbols such as (colon, dot symbol) and the like, or specific characters, and are not limited thereto.
When resolving a calculation formula according to a preset four-rule operation resolving rule, specifically, the calculation formula can be split according to adding, subtracting, multiplying and dividing characters, fields and operators obtained by splitting are put into an array, then the fields are split according to association relation characters (such as '_') of field parent classes and field serial numbers in field identifiers, the field identifiers are decomposed into the field parent classes and the field serial numbers, then the field parent classes and the field serial numbers are used as query conditions to query values corresponding to the field identifiers from a data table and put back into the array, the array is cycled, the values and the four-rule operation symbols are operated, and a final result value is calculated.
As an example, the field corresponding to the field 7 is identified as cb_7, the field corresponding to the field 13 is identified as cb_13, and the calculation formula is: cb_7+cb_13 x 0.8, the equation contains time cycle. The time dimension for field 7 and field 13 includes 201412, 201501, 201502, as shown in Table three. When the calculation formula is analyzed, firstly, the calculation formula is divided into fields and operators according to "+ -/" character division formula, namely, the arrays [ CB_7, +, CB_13, +, 0.8], then the CB_7 is divided into parent CB and field serial number 7 according to "_character division fields, CB_13 is divided into parent CB and field serial number 13, then the parent and field serial numbers are used as query conditions to be transmitted into a data table to query specific values, the parent code CB is searched out from the data table, the field serial number 7, the value of time 201412 is 25, the parent code CB, the field serial number 7, the value of time 201412 is 10, the searched-out values 25 and 10 are put into the arrays [ 25+, 10, +, 0.8], finally, four arithmetic operations are performed, the calculation result of time 201412 is 33, and the calculation results of time 201501 and 201502 are 36 and 34 respectively according to the method and time circulation calculation.
| Subject of science | 201412 | 201501 | 201502 |
| Field 7 | 25 | 20 | 10 |
| … | |||
| Field 13 | 10 | 20 | 30 |
| … |
Watch III
When resolving a calculation formula according to a preset complex logic operation resolving rule, specifically, resolving a placeholder in the calculation formula, replacing the placeholder with a corresponding variable, sequentially entering a corresponding simple four-rule operation method according to a logic priority order in the calculation method, resolving according to the four-rule operation resolving rule, and calculating a final result, wherein different logics (for example, dangerous dimension or time dimension) can correspond to different four-rule operation methods.
As an example, the calculation formula includes time dimension logic, the corresponding calculation formula is method 1 (pressure test ID, time, special time, ca_1×0.8, ca_2×0.8), when the time satisfies the first time threshold (2014), the corresponding calculation formula is ca_1×0.8, when the time satisfies the second time threshold (2015), the corresponding calculation formula is ca_2×0.8, the calculation formula includes pressure test ID placeholder and time placeholder, when the calculation formula is analyzed, the pressure test ID placeholder and time placeholder are analyzed first, the pressure test ID and time generated in the pressure test request are sequentially transmitted into the calculation formula, the transmitted time is judged, if the transmitted time is 2014.2, the formula ca_1×0.8 is entered, the formula is analyzed according to a simple four-operation analysis rule, if the transmitted time is 2015.5, the formula ca_2×0.8 is entered, and then the analysis result is obtained according to the simple operation rule.
When a target calculation formula is sequentially analyzed according to a preset formula analysis rule and a calculation logic parameter, the calculation logic parameter at least comprises a calculation priority, and as an example, if the calculation logic parameter comprises a calculation priority and a risk serial number, the calculation formula comprises a calculation formula II and a calculation formula III, the calculation priority corresponding to the calculation formula II is 2, the risk serial number is 1, the risk serial number corresponds to a risk table, the risk information table comprises risk 1-6, the calculation priority corresponding to the calculation formula III is 3, the risk serial number is not corresponding to the calculation formula II is specifically a method 2 (pressure test ID, time, risk, special risk, CA_1 x 0.8, CA_2 x 0.8), the risk can be understood as a first risk threshold (risk 1-risk 3), the special risk can be understood as a second risk threshold (risk 4-risk 6), when the calculation formula II is analyzed, the calculation formula II is needed to be analyzed, the calculation result corresponding to the pressure test request of the analysis capability is needed to be transmitted to the calculation formula II according to the calculation formula II, and then the analysis result is obtained according to the calculation formula III.
And at the same time of obtaining the pressure test result of the repayment capability, inserting the pressure test result into a field corresponding to the field identifier according to the field identifier corresponding to the calculation formula.
After the results of the stress test of the repayment capability are obtained, a test log of the stress test request of the repayment capability is preferably generated so as to be convenient for a user to view and manage. The test log may include, but is not limited to, a time of requesting the test, a number of field identification information corresponding to the request, a test result corresponding to each field identification, a test request ID, a risk involved in the test, and the like.
It will be appreciated that, in order to ensure the brevity of language, tables one to three only schematically show the information of the partial field information table and the field table, and may also include information other than the above. Tables one through three are only for aiding understanding of the field information table and the field identification, and the actual meaning of the specific meaning in the table may not be considered.
In the embodiment of the invention, when the pressure test request of the repayment capability is received, a field identification set corresponding to the pressure test request of the repayment capability is obtained according to a defined field identification rule, a target calculation formula corresponding to each field identification in the field identification set and the calculation priority of the target calculation formula are searched from an established field information table, and the target calculation formula is sequentially analyzed according to the calculation priority according to a preset formula analysis rule, so that the pressure test result of the repayment capability is obtained, the maintenance cost in the pressure test process of the repayment capability is reduced, and the test efficiency is improved.
Embodiment two:
Based on the first embodiment of the present invention, a pressure test scenario is combined, and fig. 2 shows a flow of implementation of a scenario-based repayment capability pressure test method according to the second embodiment of the present invention, and for convenience of explanation, only the relevant parts of the first embodiment of the present invention are shown, which is described in detail below:
in step S201, scene data is received.
In the embodiment of the invention, before receiving the scene data input by the user, the user needs to establish a test scene in the database in advance, and the test scene comprises a plurality of sub-scenes. Each test scene corresponds to a set of scene data, which may include a scene value and a scene identification (e.g., a scene name or a scene ID), where the scene value may be understood as a variable affecting the result of computation in the scene, and the scene value may be adjusted by the user as needed to meet the computation needs of different scene values in the same scene. For example, the scenario value is an exchange rate. It should be noted that, the scene data input by the user may include one or more sets of scene data of the test scene, and the user may arbitrarily combine the established test scene according to the established test scene and the actual calculation or test requirement, which is not limited herein.
In step S202, a field identification set corresponding to the scene data is acquired from the scene data.
In the embodiment of the invention, before acquiring the field identifier corresponding to the test scene according to the scene data, the association relation between the scene and a plurality of sub-scenes under the scene needs to be established in advance, when the association relation between the test scene and the plurality of sub-scenes under the test scene is established, specifically, when an establishment request of the test scene is received, an established sub-scene set is acquired, the sub-scene set contains all the established sub-scenes, when the association request of the test scene and the plurality of sub-scenes is received, the test scene is associated with the plurality of sub-scenes, wherein each sub-scene corresponds to one field, each field corresponds to one field identifier, when the field identifier set corresponding to the test scene is acquired according to the scene data, a plurality of field identifiers corresponding to the plurality of sub-scenes under the scene are acquired according to the established association relation between the scene and the plurality of sub-scenes, and the set formed by the plurality of field identifiers is the field identifier set.
In step S203, a request for a pressure test of repayment capability corresponding to the scene data is generated according to the acquired set of field identifications corresponding to the scene data.
In an embodiment of the invention, in particular, the set of field identifications is included in the request for pressure testing of the repayment capability.
In step S204, when a request for a pressure test of a repayment capability is received, a set of field identifications corresponding to the request for a pressure test of a repayment capability is acquired according to a defined field identification rule.
In step S205, a target calculation formula corresponding to the field identification and the calculation priority of the target calculation formula are searched from the established field information table.
In the embodiment of the present invention, the implementation of steps S204 to S205 may be referred to correspondingly to the description of steps S101 to S102 in the previous embodiment, and will not be repeated here.
In step S206, the target calculation formula is sequentially parsed according to the preset formula parsing rule and the calculation priority, so as to obtain the pressure test result of the repayment capability.
In the embodiment of the present invention, the implementation of step S206 may correspond to the description of step S103 in the previous embodiment, which is not repeated herein, and it should be noted that the target calculation formula includes a scene value, and the calculation result is also affected by the scene value.
In the embodiment of the invention, the scene data input by the user is received, the field identification set corresponding to the test scene is obtained according to the scene data, and the pressure test request of repayment capacity corresponding to the scene is generated according to the obtained field identification set corresponding to the test scene, so that the combined calculation or test requirement based on a plurality of target fields of the test scene is realized, and the flexibility and the high efficiency of the pressure test are improved.
Embodiment III:
the embodiment of the invention provides a formula backtracking method based on the first embodiment, fig. 3 shows a realization flow of the formula backtracking method provided by the third embodiment of the invention, and for convenience of explanation, only the relevant parts of the embodiment of the invention are shown, and the details are as follows:
in step S301, when a formula backtracking request is received, a first field identifier and a second field identifier corresponding to the formula backtracking request are acquired according to a defined field identifier rule.
In the embodiment of the invention, when a formula backtracking request is received, a request parameter of the formula backtracking request is read, the request parameter of the formula backtracking request carries field identification information, when a first field identification and a second field identification corresponding to the formula backtracking request are acquired according to a defined field identification rule, the first field identification can be understood as a field identification corresponding to a calculation formula to be backtracked, the second field identification can be understood as a field identification corresponding to a coefficient to be solved, for example, if the formula backtracking request carries a field identification CH_3 of the calculation formula to be backtracked and a coefficient CH_53 to be solved, the first field identification corresponding to the backtracking request is acquired according to the defined field identification rule and the second field identification is CH_53.
In step S302, a first target calculation formula corresponding to the first field identification is searched from the established field information table.
In the embodiment of the present invention, the first target calculation formula is a simple four-rule calculation formula, and the step of searching the established field information table for the first target calculation formula corresponding to the first field identifier may refer to the description in step S102 in the first embodiment, and it should be noted that the first target calculation formula is a calculation formula corresponding to a certain field identifier in the field information table, so that the priority of the first target calculation formula is not required to be considered. Based on the embodiment in step S301, the calculation formula corresponding to ch_3 in the established field information table is ch_1-ch_2, and if the first field is identified as ch_3, the first target calculation formula corresponding to ch_3 is found from the established field information table to be ch_1-ch_2.
In step S303, the first target calculation formula is parsed according to a preset backtracking formula parsing rule and a second field identifier, so as to obtain a second target calculation formula.
In the embodiment of the invention, when the first target calculation formula is analyzed according to the preset retrospective formula analysis rule, specifically, (1) the first target calculation formula is divided into individuals needing to be solved, and the individuals are put into an array. (2) And (3) carrying out formula backtracking on each individual, wherein in the backtracking process, the formula corresponding to the individual is a method, the method is directly returned without analysis, the formula corresponding to the individual is not a formula but a four-rule operation symbol, the analysis is not carried out, the formula corresponding to the individual is a simple four-rule operation formula, the individual is replaced by the four-rule operation formula, and the replaced array is obtained. (3) And re-splicing all individuals in the replaced array into a formula, wherein the formula can be a simple four-rule operation formula or a complex logic operation method. (4) Repeating the steps (2) and (3) until each individual analyzed is actual data, and returning a preliminary analysis result, wherein the judgment basis of the actual data is historical data or imported data, and the preliminary analysis result possibly comprises a complex logic operation method. (5) When the analysis result contains a complex logic operation method, receiving a modification request of the user on the preliminary analysis result to obtain a final analysis result, namely a second target calculation formula.
As an example, based on the embodiment in step S302, if the formula corresponding to ch_1 is method 1, method 1 is specifically (pressure test ID, time, special time, ch_53×0.8, ch_53×0.6), and the formula of ch_2 is ch_1×ch_53+ch_50, the following is resolved, (1) the first target calculation formula is divided into ch_1-ch_2, and put into an array to obtain an array [ ch_1, -, ch_2]. (2) And carrying out formula backtracking on three bodies of CH_1, minus sign and CH_2 respectively to obtain a backtracking result, wherein the formula corresponding to the CH_1 is method 1, the minus sign is four arithmetic operations, analysis is not carried out, the method returns directly, the formula corresponding to the CH_2 is CH_1xCH_53+CH_50, namely, the method 1 is used for replacing CH_1, CH_1xCH_53+CH_50 is used for replacing CH_2, and a replaced array [ method 1, -, CH_1xCH_53+CH_50 ] is obtained. (3) Re-stitching all individuals in the values obtained in step (2) into a formula: method 1- (ch_1 x ch_53+ch_50). (4) Repeating the steps (2) and (3), and obtaining the final analysis result as follows: method 1- (method 1 x ch_53+ch_50), wherein ch_53 is the required unknowns and ch_50 is the historical data, i.e. the known number; (5) Receiving analysis of the preliminary analysis result by the user to obtain a final analysis result as method 2 (pressure test ID, time, special time, CH_53×0.8-CH_50, CH_53×0.6-CH_50)
In step S304, the first target calculation formula is updated to the second target calculation formula.
In the embodiment of the invention, when a formula backtracking request is received, a first field identifier and a second field identifier corresponding to the formula backtracking request are acquired according to a defined field identifier rule, a first target calculation formula corresponding to the first field identifier is searched from an established field information table, a first target calculation formula is analyzed according to a preset backtracking formula analysis rule and the second field identifier to obtain a second target calculation formula, and the first target calculation formula is updated to the second target calculation formula, so that formula backtracking in the calculation process is realized, and a user can solve the problem of univariate solution and the sensitivity pressure test requirement in the calculation process through formula backtracking.
Embodiment four:
the embodiment of the invention provides a data backtracking method based on a formula backtracking method based on the third embodiment, and fig. 4 shows a realization flow of the data backtracking method provided by the fourth embodiment of the invention, for convenience of explanation, only parts relevant to the embodiment of the invention are shown, and the details are as follows:
in step S401, when a data backtracking request is received, a field identifier corresponding to the data backtracking request is acquired according to the defined field identifier rule.
In the embodiment of the present invention, the specific implementation of step S401 may refer to the descriptions of steps S101-S102 in the previous embodiment, and will not be repeated here. It should be noted that, the data trace back request may be triggered when the user types a specific numerical value into the target field, or may be triggered by a separate data trace back command input by the user, which is not limited herein, and the field identifier corresponding to the target field may be understood as the field identifier corresponding to the data trace back request, where the field identifier corresponding to the data trace back request is one, and the data trace back request carries the value of the field identifier that is entered by the user.
In step S402, a second target calculation formula corresponding to the field identification is searched from the established field information table.
In the embodiment of the present invention, the specific implementation of steps S401 to S402 may be referred to the description of steps S101 to S102 in the previous embodiment, and will not be repeated here. It should be noted that, the second target calculation formula is a formula, and the problem of formula priority is not involved.
In step S403, the second target calculation formula is parsed according to a preset formula parsing rule, so as to obtain a data backtracking result.
In the embodiment of the present invention, when the second target calculation formula is parsed according to the preset formula parsing rule, the description in step S103 of the embodiment may be referred to first to perform preliminary parsing on the second target calculation formula, and then a value corresponding to the second field identifier is calculated according to the data entered by the user and carried by the data backtracking request. As an example, if the second target calculation formula corresponds to method 2, method 2 is specifically (pressure test ID, time, special time, ch_53 x 0.8-ch_50, ch_53 x 0.6-ch_50); wherein, the corresponding value of CH_50 is 1.6, and the special time is 2015.1; when the user types a value of 0 and the time dimension is 2014.12, and the method 2 is analyzed, the formula ch_53 x 0.8-ch_50=0 is calculated according to the time logic, and the value of ch_53 is obtained by analysis: -2.
In the embodiment of the invention, when the data backtracking request is received, the field identification corresponding to the data backtracking request is acquired according to the defined field identification rule, a second target calculation formula corresponding to the field identification is searched from the established field information table, and the second target calculation formula is analyzed according to the preset formula analysis rule to obtain the data backtracking result, thereby solving the problem of univariate solution in the calculation process and the sensitivity pressure test requirement.
Fifth embodiment:
Fig. 5 shows the structure of the repayment-capability pressure test device provided in the fifth embodiment of the present invention, and for convenience of explanation, only the portions related to the embodiment of the present invention are shown, including:
a test request processing unit 51, configured to, when receiving a pressure test request of a repayment capability, obtain a field identification set corresponding to the pressure test request of the repayment capability according to a defined field identification rule;
A formula searching unit 52, configured to search, from the established field information table, a target calculation formula corresponding to each field identifier in the field identifier set, and a calculation logic parameter corresponding to the target calculation formula; and
The formula analysis unit 53 is configured to sequentially analyze the target calculation formula according to a preset formula analysis rule and a calculation logic parameter, so as to obtain a pressure test result of the repayment capability.
In the embodiment of the present invention, each unit of the pressure testing device with repayment capability may be implemented by a corresponding hardware or software unit, and each unit may be an independent software or hardware unit, or may be integrated into one software or hardware unit, which is not limited to the present invention. The specific implementation of each unit of the pressure testing device for repayment capability may refer to the description of the first embodiment of the method, and will not be repeated herein.
Example six:
Fig. 6 shows the structure of a scenario-based repayment capability pressure test device provided by a sixth embodiment of the present invention, and for convenience of explanation, only the portions relevant to the embodiment of the present invention are shown, including:
a scene data receiving unit 61 for receiving scene data;
A scene data processing unit 62, configured to obtain a field identifier set corresponding to the scene data according to the scene data;
A test request generating unit 63 for generating a pressure test request of repayment capability corresponding to the scene data according to the acquired field identification set;
a test request processing unit 64, configured to, when receiving a pressure test request of a repayment capability, obtain a field identification set corresponding to the pressure test request of the repayment capability according to a defined field identification rule;
A formula searching unit 65, configured to search a target calculation formula corresponding to the field identifier from the established field information table, and a calculation priority of the target calculation formula; and
The formula parsing unit 66 is configured to parse the target calculation formula sequentially according to a preset formula parsing rule and a calculation priority, so as to obtain a pressure test result of the repayment capability.
In the embodiment of the present invention, each unit of the scenario-based pressure testing device may be implemented by a corresponding hardware or software unit, and each unit may be an independent software or hardware unit, or may be integrated into one software or hardware unit, which is not intended to limit the present invention. The specific implementation of each unit of the scenario-based repayment capability pressure test device may refer to the description of the second embodiment of the method, and will not be repeated herein.
Embodiment seven:
Fig. 7 shows the structure of the formula backtracking device provided in the seventh embodiment of the present invention, and for convenience of explanation, only the parts related to the embodiment of the present invention are shown, including:
The formula backtracking processing unit 71 is configured to, when receiving a formula backtracking request, obtain a first field identifier and a second field identifier corresponding to the formula backtracking request according to a defined field identifier rule;
a first formula searching unit 72, configured to search a first target calculation formula corresponding to the first field identifier from the established field information table;
A second formula generating unit 73, configured to parse the first target calculation formula according to a preset retrospective formula parsing rule and a second field identifier, so as to obtain a second target calculation formula; and
A formula replacing unit 74 for updating the first target calculation formula to the second target calculation formula.
In the embodiment of the present invention, each unit of the formula backtracking device may be implemented by a corresponding hardware or software unit, and each unit may be an independent software or hardware unit, or may be integrated into one software or hardware unit, which is not used to limit the present invention. The specific implementation of each unit of the formula backtracking device may refer to the description of the third embodiment of the foregoing method, which is not repeated herein.
Example eight:
Fig. 8 shows a structure of a data trace-back device according to an eighth embodiment of the present invention, and for convenience of explanation, only a portion related to the embodiment of the present invention is shown, including:
the data backtracking processing unit 81 is configured to, when receiving a data backtracking request, obtain a field identifier corresponding to the data backtracking request according to the defined field identifier rule;
A second formula searching unit 82, configured to search a second target calculation formula corresponding to the field identifier from the established field information table; and
The second formula parsing unit 83 is configured to parse the second target calculation formula according to a preset formula parsing rule, so as to obtain a data backtracking result.
In the embodiment of the present invention, each unit of the data trace-back device may be implemented by a corresponding hardware or software unit, and each unit may be an independent software or hardware unit, or may be integrated into one software or hardware unit, which is not used to limit the present invention. The specific implementation of each unit of the data trace-back device may refer to the description of the fourth embodiment of the foregoing method, which is not repeated here.
Example nine:
Fig. 9 shows the structure of a computer device provided in the ninth embodiment of the present invention, and for convenience of explanation, only the portions relevant to the embodiment of the present invention are shown.
The embodiment of the invention provides a computer device 9 comprising a processor 90, a memory 91 and a computer program 92 stored in the memory 91 and executable on the processor 90. The processor 90, when executing the computer program 92, implements the steps of the method embodiments described above, such as steps S101 to S103 shown in fig. 1. Or the processor 90 when executing the computer program 92 performs the functions of the units of the above-described device embodiments, such as the units 31 to 33 shown in fig. 3.
In the embodiment of the invention, when the pressure test request of the repayment capability is received, a field identification set corresponding to the pressure test request of the repayment capability is obtained according to a defined field identification rule, a target calculation formula corresponding to each field identification in the field identification set and the calculation priority of the target calculation formula are searched from an established field information table, and the target calculation formula is sequentially analyzed according to a preset formula analysis rule and the calculation priority to obtain the pressure test result of the repayment capability, so that the maintenance cost in the pressure test process of the repayment capability is reduced, and the test efficiency is improved.
Example ten:
In an embodiment of the present invention, there is provided a computer-readable storage medium storing a computer program which, when executed by a processor, implements the steps in the above-described method embodiment, for example, steps S101 to S103 shown in fig. 1. Or the computer program, when being executed by a processor, performs the functions of the units in the above-described embodiments of the apparatus, such as the functions of the units 51 to 53 shown in fig. 5.
In the embodiment of the invention, when the pressure test request of the repayment capability is received, a field identification set corresponding to the pressure test request of the repayment capability is obtained according to a defined field identification rule, a target calculation formula corresponding to each field identification in the field identification set and the calculation priority of the target calculation formula are searched from an established field information table, and the target calculation formula is sequentially analyzed according to a preset formula analysis rule and the calculation priority to obtain the pressure test result of the repayment capability, so that the maintenance cost in the pressure test process of the repayment capability is reduced, and the test efficiency is improved.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include non-volatile and/or volatile memory. The nonvolatile memory can include Read Only Memory (ROM), programmable ROM (PROM), electrically Programmable ROM (EPROM), electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double Data Rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (SYNCHLINK) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM), among others.
It will be apparent to those skilled in the art that, for convenience and brevity of description, only the above-described division of the functional units and modules is illustrated, and in practical application, the above-described functional distribution may be performed by different functional units and modules according to needs, i.e. the internal structure of the apparatus is divided into different functional units or modules to perform all or part of the above-described functions.
The above embodiments are only for illustrating the technical solution of the present invention, and not for limiting the same; although the invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present invention, and are intended to be included in the scope of the present invention.
Claims (8)
1. A method of testing the pressure of a repayment capability, the method comprising the steps of:
When a pressure test request of repayment capability is received, acquiring a field identification set corresponding to the pressure test request of repayment capability according to a defined field identification rule;
Searching a target calculation formula corresponding to each field identifier in the field identifier set and calculation logic parameters corresponding to the target calculation formula from an established field information table;
Sequentially analyzing the target calculation formula according to a preset formula analysis rule and the calculation logic parameters to obtain a pressure test result of the repayment capability;
When a formula backtracking request is received, acquiring a first field identifier and a second field identifier corresponding to the formula backtracking request according to the defined field identifier rule;
Searching a first target calculation formula corresponding to the first field identifier from the established field information table;
Analyzing the first target calculation formula according to a preset backtracking formula analysis rule and a second field identifier to obtain a second target calculation formula;
and updating the first target calculation formula into the second target calculation formula.
2. The method of claim 1, wherein prior to the step of obtaining a set of field identifications corresponding to the request for pressure testing of repayment capability according to a defined field identification rule, comprising:
receiving scene data;
Acquiring the field identification set corresponding to the scene data according to the scene data;
and generating a pressure test request of the repayment capacity corresponding to the scene data according to the acquired field identification set.
3. The method of claim 1, wherein the step of sequentially parsing the target calculation formula according to a preset formula parsing rule and the calculation logic parameter comprises:
Judging the formula type of the target calculation formula, wherein the formula type comprises a simple four-rule operation formula and a complex logic operation method;
If the formula type of the target calculation formula is a simple four-rule calculation formula, analyzing the target calculation formula according to a preset four-rule calculation analysis rule;
And if the formula type of the target calculation formula is a complex logic operation method, analyzing the target calculation formula according to a preset complex logic operation analysis rule.
4. The method of claim 1, wherein after the step of updating the first target calculation formula to the second target calculation formula, comprising:
when a data backtracking request is received, acquiring a field identifier corresponding to the data backtracking request according to the defined field identifier rule;
Searching the second target calculation formula corresponding to the field identification from the established field information table;
and analyzing the second target calculation formula according to a preset formula analysis rule to obtain a data backtracking result.
5. A repayment capability pressure test device, said device comprising:
The test request processing unit is used for acquiring a field identification set corresponding to the pressure test request of the repayment capability according to a defined field identification rule when the pressure test request of the repayment capability is received;
the formula searching unit is used for searching a target calculation formula corresponding to each field identifier in the field identifier set and a calculation logic parameter corresponding to the target calculation formula from the established field information table; and
The formula analysis unit is used for sequentially analyzing the target calculation formula according to a preset formula analysis rule and the calculation logic parameters so as to obtain a pressure test result of the repayment capability;
the apparatus further comprises:
The formula backtracking processing unit is used for acquiring a first field identifier and a second field identifier corresponding to the formula backtracking request according to the defined field identifier rule when the formula backtracking request is received;
a first formula searching unit, configured to search a first target calculation formula corresponding to the first field identifier from the established field information table;
The second formula generation unit is used for analyzing the first target calculation formula according to a preset backtracking formula analysis rule and a second field identifier to obtain a second target calculation formula; and
And the formula replacing unit is used for updating the first target calculation formula into the second target calculation formula.
6. The apparatus of claim 5, wherein the apparatus further comprises:
A scene data receiving unit for receiving scene data input by a user;
A scene data processing unit, configured to obtain, according to the scene data, the field identifier set corresponding to the scene data; and
And the test request generation unit is used for generating a pressure test request of repayment capacity corresponding to the scene data according to the acquired field identification set.
7. A computer device comprising a memory, a processor and a computer program stored in the memory and executable on the processor, characterized in that the processor implements the steps of the method according to any of claims 1 to 4 when the computer program is executed.
8. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor implements the steps of the method according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910603375.XA CN110458712B (en) | 2019-07-05 | 2019-07-05 | Pressure test method, device, equipment and storage medium for repayment capability |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910603375.XA CN110458712B (en) | 2019-07-05 | 2019-07-05 | Pressure test method, device, equipment and storage medium for repayment capability |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110458712A CN110458712A (en) | 2019-11-15 |
| CN110458712B true CN110458712B (en) | 2024-09-13 |
Family
ID=68482263
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910603375.XA Active CN110458712B (en) | 2019-07-05 | 2019-07-05 | Pressure test method, device, equipment and storage medium for repayment capability |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110458712B (en) |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111045647A (en) * | 2019-11-20 | 2020-04-21 | 深圳市云智融科技有限公司 | Information determination method and related equipment |
| CN111026627A (en) * | 2019-12-10 | 2020-04-17 | 北京奇艺世纪科技有限公司 | Pressure testing method and device and server |
| CN112633894A (en) * | 2020-12-28 | 2021-04-09 | 中国平安财产保险股份有限公司 | Method, device, equipment and computer storage medium for pressure testing of repayment capacity |
| CN112883014A (en) * | 2021-03-25 | 2021-06-01 | 上海众源网络有限公司 | Data backtracking method and device, computer equipment and storage medium |
| CN113256407B (en) * | 2021-06-24 | 2022-06-24 | 中国平安人寿保险股份有限公司 | Risk prediction method, risk prediction device, electronic equipment and storage medium |
| CN115169307A (en) * | 2022-08-04 | 2022-10-11 | 中国平安财产保险股份有限公司 | Table-based data processing method, device, device and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107515819A (en) * | 2016-06-16 | 2017-12-26 | 平安科技（深圳）有限公司 | Medicare system method of testing and device |
| CN109189385A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Algorithm configuration method, apparatus, computer equipment and storage medium |
Family Cites Families (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7526471B2 (en) * | 2004-12-17 | 2009-04-28 | International Business Machines Corporation | Field-to-field join constraints |
| CN107656874B (en) * | 2017-11-07 | 2021-04-20 | 中国银行股份有限公司 | Interface testing method and device, simulation baffle and system |
| CN109933514B (en) * | 2017-12-18 | 2022-07-05 | 北京京东尚科信息技术有限公司 | Data testing method and device |
| CN109062777B (en) * | 2018-08-10 | 2022-02-15 | 湖南中车时代通信信号有限公司 | General automatic test system of track traffic signal equipment |
| CN109117375A (en) * | 2018-08-30 | 2019-01-01 | 上海携程金融信息服务有限公司 | Database interface test method, system, equipment and storage medium |
-
2019
- 2019-07-05 CN CN201910603375.XA patent/CN110458712B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107515819A (en) * | 2016-06-16 | 2017-12-26 | 平安科技（深圳）有限公司 | Medicare system method of testing and device |
| CN109189385A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Algorithm configuration method, apparatus, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110458712A (en) | 2019-11-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110458712B (en) | Pressure test method, device, equipment and storage medium for repayment capability | |
| CN107609217B (en) | Processing method and device for collision check data | |
| CN109614231A (en) | Idle server resource discovery method, device, computer equipment and storage medium | |
| CN110008266A (en) | Data interchange file analysis method and device | |
| EP2862101B1 (en) | Method and a consistency checker for finding data inconsistencies in a data repository | |
| CN112286934A (en) | Database table import method, device, equipment and medium | |
| CN110084634A (en) | Optimization method, device, computer equipment and storage medium are launched in advertisement | |
| CN103235757B (en) | Several apparatus and method that input domain tested object is tested are made based on robotization | |
| CN112269806B (en) | Data query method, device, equipment and computer storage medium | |
| CN104572666A (en) | Method for analyzing and importing Excel into database in batch based on Jxl | |
| CN106599291A (en) | Method and device for grouping data | |
| CN110275703A (en) | Assignment method, device, computer equipment and the storage medium of key-value pair data | |
| CN113283213B (en) | Circuit design system and method based on machine learning | |
| CN112631925B (en) | Method for detecting single-variable atom violation defect | |
| US20250209282A1 (en) | Data adjustment using large language model | |
| CN113448982A (en) | DDL statement analysis method and device, computer equipment and storage medium | |
| CN110688400A (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN118199041A (en) | Bus net load short-term prediction method and system | |
| CN117634424A (en) | Keyword highlight labeling method and device, computer equipment and storage medium | |
| CN113505069B (en) | Test data analysis method and system | |
| CN112287005B (en) | Data processing method, device, server and medium | |
| CN111984671B (en) | Method for generating view script | |
| CN109992630B (en) | Data model matching method and device | |
| CN112528613A (en) | Data table generation method and related equipment thereof | |
| CN117787729B (en) | Intelligent park management method and related device based on identification analysis |
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 | ||
| GR01 | Patent grant |