CN109324800A - It is a kind of avoid endless loop calculate optimization method and optimization device - Google Patents
It is a kind of avoid endless loop calculate optimization method and optimization device Download PDFInfo
- Publication number
- CN109324800A CN109324800A CN201811253209.3A CN201811253209A CN109324800A CN 109324800 A CN109324800 A CN 109324800A CN 201811253209 A CN201811253209 A CN 201811253209A CN 109324800 A CN109324800 A CN 109324800A
- Authority
- CN
- China
- Prior art keywords
- calculation formula
- formula
- independent variable
- variable
- value
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/40—Transformation of program code
- G06F8/41—Compilation
- G06F8/43—Checking; Contextual analysis
- G06F8/433—Dependency analysis; Data or control flow analysis
Landscapes
- Engineering & Computer Science (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the present application disclose it is a kind of avoid endless loop calculate optimization method and optimization device, for by defining relationship of the field in calculation formula, and it is associated with it, avoid the linkage hidden between field, and specify all relationships, so as to avoid endless loop is generated in calculating process, the Stability and dependability of calculating process is improved.The embodiment of the present application method includes: to determine at least two calculation formula according to preset formula library, at least two calculation formula includes the first calculation formula and the second calculation formula, first calculation formula includes the first independent variable, which includes target variable；The first calculated result for being associated with first calculation formula is the second independent variable of second calculation formula；Obtain the value of first independent variable；It is calculated according to the value and at least two calculation formula, obtains the value of target variable.
Description
Technical field
This application involves computer programming fields, and in particular to it is a kind of avoid endless loop calculate optimization method and optimization dress
It sets.
Background technique
It in programming procedure, needs to convert programming language to the artificial readable factor, is especially calculated in formula
In, it generally requires to use letter even text to represent the calculating factor.
In the prior art, so that each field is defined the calculation formula that it to be executed respectively, be carried out as long as value changes
Calculating process；Different fields executes identical calculation formula if necessary, then needs respectively to the same public affairs of each field definition
Formula is multiple.
But the calculation formula between multiple fields has an inclusion relation, the value of a field change calculate it is another
The value of a field, and therefore the value of another field changes and also calculates the value of that original field, so as to cause extremely following
Ring influences the progress of calculating process.
Summary of the invention
The embodiment of the present application provides a kind of optimization method for avoiding endless loop from calculating, for being calculated by defining field
Relationship in formula, and be associated with it, the linkage hidden between field is avoided, and specify all relationships, thus
It avoids and generates endless loop in calculating process, improve the Stability and dependability of calculating process.
In order to achieve the above objectives, the embodiment of the present application provides the following technical solutions:
The application first aspect provides a kind of optimization method for avoiding endless loop from calculating, and this method can be applied to terminal device
In programmed logic, the optimization device which is related in the process of implementation is in terminal device
Corresponding corresponding functional entity.This method may include: to determine at least two calculation formula according to preset formula library, this is at least
Two calculation formula include the first calculation formula and the second calculation formula, which includes the first independent variable, this
Two calculation formula include target variable；The first calculated result for being associated with first calculation formula is the second of second calculation formula
Independent variable；Obtain the value of first independent variable；It is calculated according to the value and at least two calculation formula, obtains target
Variable result.
Optionally, in some embodiments of the present application, this method can also include: to determine three according to preset formula library
A calculation formula, three calculation formula include the first calculation formula, the second calculation formula and third calculation formula, first meter
Calculating formula and the second calculation formula includes the first independent variable, which includes target variable；The association first meter
The first calculated result for calculating formula is the second independent variable of second calculation formula, may include: to be associated with first calculation formula
The first calculated result be second calculation formula the second independent variable；The second calculated result for being associated with second calculation formula is
The third independent variable of second calculation formula.
Optionally, in some embodiments of the present application, the first calculated result of the association first calculation formula is should
After second independent variable of the second calculation formula, this method can also include: to be tied according to second independent variable and first calculating
Fruit merges first calculation formula with first calculation formula, generates and merges formula, and the merging formula is for being associated with first certainly
Variable and target variable.
Optionally, in some embodiments of the present application, which is characterized in that this determines at least two according to preset formula library
After a calculation formula, this method can also include: to show at least two calculation formula.
Optionally, in some embodiments of the present application, which may include: to obtain to be somebody's turn to do
First independent variable；According to first independent variable and preset calculation formula set, at least two calculation formula is determined.
The application second aspect provides a kind of optimization device, which, which has, realizes above-mentioned first aspect or first party
The function of the method for any one possible implementation of face.The function can also be executed by hardware realization by hardware
Corresponding software realization.The hardware or software include one or more modules corresponding with above-mentioned function.
The third aspect, the embodiment of the present application provide a kind of optimization device, the optimization device may include terminal device or
The entities such as chip, the optimization device include: input/output (I/O) interface, processor and memory；The memory is used for
Store instruction；The processor is used to execute the described instruction in the memory, so that the optimization device is executed as aforementioned
Method described in any one of first aspect.
Fourth aspect, the embodiment of the present application provides a kind of computer readable storage medium, including instruction, when it is in computer
When upper operation, so that computer executes the method as described in aforementioned first aspect and any optional implementation.
The computer storage medium include: USB flash disk, mobile hard disk, read-only memory (read-only memory, ROM), with
Machine accesses various Jie that can store program code such as memory (random access memory, RAM), magnetic or disk
Matter.
5th aspect, the embodiment of the present application provide a kind of computer program product, when run on a computer, so that
Computer executes the method as described in aforementioned first aspect and any optional implementation.
6th aspect, this application provides a kind of chip system, which includes processor, for supporting optimization to set
It is standby to realize function involved in above-mentioned aspect, for example, sending or handling data and/or information involved in the above method.
In a kind of possible design, the chip system further includes memory, the memory, necessary for saving optimization equipment
Program instruction and data.The chip system is also possible to apply and executes corresponding function in optimization device either optimization device
The System on Chip/SoC of energy.
As can be seen from the above technical solutions, the embodiment of the present application has the advantage that
The embodiment of the present application determines at least two by defining relationship of the field in calculation formula, according to preset formula library
A calculation formula, at least two calculation formula include the first calculation formula and the second calculation formula, the first calculation formula packet
The first independent variable is included, which includes target variable；The first calculated result for being associated with first calculation formula is to be somebody's turn to do
Second independent variable of the second calculation formula；Obtain the value of first independent variable；It is public according to the value and at least two calculating
Formula is calculated, and the value of target variable is obtained.This avoid the linkages hidden between field, and specify all passes
System, so as to avoid endless loop is generated in calculating process, improves the Stability and dependability of calculating process.
Detailed description of the invention
Fig. 1 is that formula calculates the schematic diagram that endless loop occurs；
Fig. 2 is a kind of optimization method schematic diagram for avoiding endless loop from calculating provided by the embodiments of the present application；
Fig. 3 is a kind of application scenario diagram provided by the embodiments of the present application；
Fig. 4 is another application scenario diagram provided by the embodiments of the present application；
Fig. 5 is another application scenario diagram provided by the embodiments of the present application；
Fig. 6 is a kind of structural schematic diagram for optimizing device provided by the embodiments of the present application；
Fig. 7 is the structural schematic diagram of another optimization device provided by the embodiments of the present application.
Specific embodiment
With reference to the accompanying drawing, embodiments herein is described, it is clear that described embodiment is only the application
The embodiment of a part, instead of all the embodiments.Those of ordinary skill in the art are it is found that with the development of technology and new field
The appearance of scape, technical solution provided by the embodiments of the present application are equally applicable for similar technical problem.
The embodiment of the present application provides a kind of optimization method for avoiding endless loop from calculating, for being calculated by defining field
Relationship in formula, and be associated with it, the linkage hidden between field is avoided, and specify all relationships, thus
It avoids and generates endless loop in calculating process, improve the Stability and dependability of calculating process.
It in programming procedure, needs to convert programming language to the artificial readable factor, is especially calculated in formula
In, it generally requires to use letter even text to represent the calculating factor.
In the prior art, so that each field is defined the calculation formula that it to be executed respectively, be carried out as long as value changes
Calculating process；Different fields executes identical calculation formula if necessary, then needs respectively to the same public affairs of each field definition
Formula is multiple.But the calculation formula between multiple fields has inclusion relation, the value of a field, which changes, calculates another
The value of field, and the therefore value of another field changes and also calculates the value of that original field, so as to cause endless loop,
Such as: as shown in Figure 1, being that formula calculates the schematic diagram that endless loop occurs, specially " amount of money=quantity * unit price ", " unit price=gold
Volume quantity " the two formula, input " unit price " executes formula " amount of money=quantity * monovalent " and calculates " amount of money ", at this moment " amount of money "
Changed, and execute formula " unit price=amount of money quantity ", is at this moment returned to initial " unit price " and change and need to be implemented public affairs
Formula " amount of money=quantity * unit price ", so as to cause endless loop.
By the above method, identical formula needs re-define, and the relationship between field is lain in formula, and user is not
It can clearly see which formula is each field can trigger, and be easy to happen endless loop when two fields are needed and mutually calculated.
The method that the present embodiment proposes is to solve the problems, such as this, for ease of understanding, below to the specific stream in the present embodiment
Journey is described, as shown in Fig. 2, be a kind of optimization method schematic diagram for avoiding endless loop from calculating provided by the embodiments of the present application,
This method includes but is not limited to following steps:
201, at least two calculation formula are determined according to preset formula library,
In the embodiment of the present application, at least two calculation formula may include that the first calculation formula and second calculate public affairs
Formula, first calculation formula include the first independent variable, and second calculation formula includes target variable, below with reference to table number
According to being illustrated, table 1 is a kind of field scene of independent variable and the target variable rule of response, wherein independent variable can trigger
Formula calculates, and target variable will not trigger formula calculating；Table 2 is the relevant calculation formula of field.Such as: the first independent variable be containing
Duty receipt valence, target variable are total for valence tax, it is determined that formula is that " amount of tax to be paid=quantity * * of valence containing duty receipt (tax rate/100) " " valence tax closes
Meter=the amount of money+amount of tax to be paid."
| Field serial number | Field name | Triggering formula whether is needed to calculate |
| 1 | Quantity | It is |
| 2 | Unit price | It is |
| 3 | The tax rate | It is |
| 4 | Valence containing duty receipt | It is |
| 5 | The amount of money | It is no |
| 6 | The amount of tax to be paid | It is no |
| 7 | Valence tax is total | It is no |
Table 1
| Formula serial number | Calculation formula |
| 1 | Valence containing duty receipt=unit price * (tax rate/100 1+) |
| 2 | The amount of money=quantity * unit price |
| 3 | The amount of tax to be paid=quantity * the * of valence containing duty receipt (tax rate/100) |
| 4 | Valence tax adds up to the=amount of money+amount of tax to be paid |
Table 2
It should be noted that this table scene is to illustrate used in logical relation, wherein the expression of text can be other tables
It states, depending on concrete scene answers actual conditions, herein without limitation.
202, the determining calculation formula of association；
In the embodiment of the present application, the first calculated result of first calculation formula can be second calculation formula
Second independent variable, it is noted that be converted into the association process that the second independent variable is field from the first calculated result, be not meter
The update for the value that counts, that is, do not need first to calculate the first calculation formula just can be carried out and calculate in next step.
In conjunction with the scene in step 201, providing that the first independent variable is valence containing duty receipt, target variable is total for valence tax, really
After determining formula for " amount of tax to be paid=quantity * * of valence containing duty receipt (tax rate/100) " " valence tax adds up to the=amount of money+amount of tax to be paid ", two formula are associated with,
That is " valence tax adds up to the=amount of money+quantity * * of valence containing duty receipt (tax rate/100) ", it can explicitly show the first independent variable and mesh in this way
Mark the relationship of variable.It should be noted that the merging in the only logic reference of the formula, the not generation of new formula.
203, the value of first independent variable is obtained；
In the embodiment of the present application, the value of the first independent variable can be artificial input, be also possible to program calculated value
Write-in, depending on concrete scene is because of actual conditions, herein without limitation.
In conjunction with the scene in step 202, that is, the value of first independent variable valence containing duty receipt is obtained, passes through incidence formula " valence tax
Total=the amount of money+quantity * * of valence containing duty receipt (tax rate/100) " can connect to obtain target variable valence tax certainly to be added up to.
204, it is calculated according to the value and at least two calculation formula, obtains the value of target variable.
In the embodiment of the present application, is calculated according to the value and at least two calculation formula, can be basis
First calculation formula and the second calculation formula are calculated, it should be appreciated that the calculating process is after two formula are associated with
The direct correlation of first independent variable and target variable calculates, that is, obtains the value of first independent variable valence containing duty receipt, public by association
Formula " valence tax total=amount of money+quantity * * of valence containing duty receipt (tax rate/100) " can connect to obtain target variable valence tax certainly to be added up to.
Above-described embodiment is associated with it by defining the relationship of field and field in calculation formula, avoids word
The linkage hidden between section, and specify all relationships, so as to avoid endless loop is generated in calculating process, improve meter
The Stability and dependability of calculation process.
It should be understood that above-described embodiment can be a kind of embodiment of program in terminal device, said below with reference to diagram
It is bright, as shown in figure 3, being a kind of application scenario diagram provided by the embodiments of the present application.
First, it is specified that the first independent variable is valence containing duty receipt, target variable is total for valence tax, by finding the meter in formula library
Formula is calculated, determines that incidence formula is " amount of tax to be paid=quantity * * of valence containing duty receipt (tax rate/100) " " valence tax adds up to the=amount of money+amount of tax to be paid ", so
Afterwards, incidence formula is shown in incidence formula column, inputs the value of the valence containing duty receipt, the value added up to containing tax can be obtained, and
And valence containing duty receipt and containing tax it is total between relationship be illustrated, and will not there is a situation where endless loops.
It should be noted that the embodiment of the present application application scenarios can be personal computer, or other are for holding
The terminal device of row this method, depending on concrete scene is because of actual conditions, herein without limitation.
Above-mentioned application embodiment illustrates a kind of the case where 2 formula association, wherein the first of the first calculation formula calculates
As a result it can be directly associated with the second formula, in some 3 or the association process of above formula, the second formula may not include
First calculated result of the first calculation formula, is below illustrated the scene.
The method that the present embodiment proposes is to illustrate the scene, for ease of understanding, below to the specific field in the present embodiment
Scene describing, as shown in figure 4, being another application scenario diagram provided by the embodiments of the present application, this method is including but not limited to as follows
Step:
First, it is specified that the first independent variable is quantity, target variable is total for valence tax, public by finding the calculating in formula library
Formula, determine incidence formula be " amount of money=quantity * unit price " " amount of tax to be paid=quantity * * of valence containing duty receipt (tax rate/100) " " valence tax adds up to=
The amount of money+the amount of tax to be paid " then shows incidence formula in incidence formula column, inputs the value of quantity, can be obtained total containing tax
Value, and valence containing duty receipt and containing tax it is total between relationship be illustrated, and will not there is a situation where endless loops.
In the embodiment of the present application, the first calculation formula and the second calculation formula have no associated variable, but pass through third meter
Calculating formula can be associated, i.e. third calculation formula the first calculated result and the second calculation formula that include the first calculation formula
The second calculated result, in above-mentioned scene, can be expressed as " valence tax is total=quantity * unit price+quantity * * (tax of valence containing duty receipt
Rate/100) ", it is noted that the merging in the only logic reference of the formula, the not generation of new formula.
It in a kind of 4 associated scenes of formula, can also be illustrated by this method, the method that the present embodiment proposes
To illustrate the scene, for ease of understanding, the concrete scene in the present embodiment is described below, as shown in figure 5, being the application reality
Another application scenario diagram of example offer is applied, this method includes but is not limited to following steps:
First, it is specified that the first independent variable is unit price, target variable is total for valence tax, public by finding the calculating in formula library
Formula determines that incidence formula is that " valence containing duty receipt=unit price * (tax rate/100 1+) " " amount of money=quantity * unit price " " amount of tax to be paid=quantity * contains
Duty receipt valence * (tax rate/100) " " valence tax adds up to the=amount of money+amount of tax to be paid ", then, incidence formula is shown in incidence formula column, defeated
The value for entering quantity, can be obtained the value added up to containing tax, and valence containing duty receipt and containing tax it is total between relationship be illustrated, and not
It can there is a situation where endless loops.
In the embodiment of the present application, the relationship of the first independent variable and target variable can be expressed as " valence tax is total=quantity * is mono-
Valence+quantity * unit price * (tax rate/100 1+) * (tax rate/100) ", it is noted that the conjunction in the only logic reference of the formula
And the not generation of new formula.
The embodiment of the present application can be applied in optimization device according to the above method, and carry out functional module to optimization device
Division two or more functions can also be integrated for example, each functional module of each function division can be corresponded to
In a processing module.Above-mentioned integrated module both can take the form of hardware realization, can also use software function mould
The form of block is realized.It should be noted that being schematical, only a kind of logic to the division of module in the embodiment of the present application
Function division, there may be another division manner in actual implementation.
For example, in the case where to use the integrated each functional unit of model split, as shown in fig. 6, being that the application is implemented
A kind of structural schematic diagram for optimization device that example provides.
If Fig. 6 shows, optimization device 600 provided by the embodiments of the present application includes determination unit 601, associative cell 602, obtains
Unit 603 and computing unit 604.
Determination unit 601, for determining at least two calculation formula according to preset formula library, at least two calculating is public
Formula includes the first calculation formula and the second calculation formula, which includes the first independent variable, second calculation formula
Including target variable；
Associative cell 602, the first calculated result for being associated with first calculation formula are the of second calculation formula
Two independents variable；
Acquiring unit 603, for obtaining the value of first independent variable；
Computing unit 604 obtains target variable for being calculated according to the value and at least two calculation formula
Value.
Optionally, determination unit 601 are also used to determine three calculation formula according to preset formula library, this three calculating
Formula includes the first calculation formula, the second calculation formula and third calculation formula, first calculation formula and the second calculation formula
Including the first independent variable, which includes target variable；It is public to be also used to be associated with first calculating for associative cell 602
First calculated result of formula is the second independent variable of second calculation formula；Associative cell 602 is also used to be associated with second calculating
Second calculated result of formula is the third independent variable of second calculation formula.
Optionally, associative cell 602, are also used to according to second independent variable and first calculated result, this first is counted
It calculates formula to merge with first calculation formula, generates and merge formula, which becomes for being associated with the first independent variable and target
Amount.
Optionally, determination unit 601 are also used to show at least two calculation formula.
Optionally, determination unit 601 are specifically used for obtaining first independent variable；Determination unit 601 is specifically used for basis
First independent variable and preset calculation formula set, determine at least two calculation formula.
Wherein, all related contents for each step that above method embodiment is related to can quote corresponding function unit
Function description, details are not described herein.
In the present embodiment, optimization device 600 can be in the form of the integrated each functional module of model split
It is existing.Here " module " can refer to application-specific integrated circuit (application-specific integrated
Circuit, ASIC), circuit, the processor and memory of the one or more softwares of execution or firmware program, integrated logic circuit,
And/or other can provide the device of above-mentioned function.In a simple embodiment, those skilled in the art is contemplated that
Optimization device 600 can use form shown in Fig. 7.
As shown in fig. 7, being the structural schematic diagram of another optimization device provided by the embodiments of the present application, optimize device 700
It include: input/output (I/O) interface 701, processor 702, memory 703.Specifically, the processor 702 in Fig. 7 can lead to
The computer executed instructions called and stored in memory 703 are crossed, so that optimization device 700 executes the reality in above method embodiment
Now avoid the method for endless loop calculation optimization.
Specifically, the function of determination unit 601, associative cell 602, acquiring unit 603 and computing unit 604 in Fig. 6/
Realization process can call the computer executed instructions stored in memory 703 to realize by the processor 702 in Fig. 7.Or
Person, function/realization process of determination unit 601, associative cell 602, acquiring unit 603 and computing unit 604 in Fig. 6 can be with
It is realized by input/output (I/O) interface 701 in Fig. 7.
Since optimization device 700 provided by the embodiments of the present application can be used for executing the method for avoiding endless loop calculation optimization,
Therefore it, which can be obtained technical effect, can refer to above method embodiment, and details are not described herein.
Optionally, the embodiment of the present application provides a kind of chip system, which includes processor, excellent for supporting
Makeup, which is set, realizes the above-mentioned optimization method for avoiding endless loop from calculating.In a kind of possible design, which further includes depositing
Reservoir.The memory, for saving the necessary program instruction of optimization device and data.The chip system can be made of chip,
Also chip and other discrete devices be may include, the embodiment of the present application is not especially limited this.
In the above-described embodiments, can come wholly or partly by software, hardware, firmware or any combination thereof real
It is existing.When implemented in software, it can entirely or partly realize in the form of a computer program product.
The computer program product includes one or more computer instructions.Load and execute on computers the meter
When calculation machine program instruction, entirely or partly generate according to process or function described in the embodiment of the present application.The computer can
To be general purpose computer, special purpose computer, computer network or other programmable devices.The computer instruction can be deposited
Storage in a computer-readable storage medium, or from a computer readable storage medium to another computer readable storage medium
Transmission, for example, the computer instruction can pass through wired (example from a web-site, computer, server or data center
Such as coaxial cable, optical fiber, Digital Subscriber Line (DSL)) or wireless (such as infrared, wireless, microwave) mode to another website
Website, computer, server or data center are transmitted.The computer readable storage medium can be computer and can deposit
Any usable medium of storage either includes that the data storages such as one or more usable mediums integrated server, data center are set
It is standby.The usable medium can be magnetic medium, (for example, floppy disk, hard disk, tape), optical medium (for example, DVD) or partly lead
Body medium (such as solid state hard disk solid state disk (SSD)) etc..
The description and claims of this application and term " first " in above-mentioned attached drawing, " second " etc. are for distinguishing
Similar object, without being used to describe a particular order or precedence order.It should be understood that the data used in this way are in appropriate feelings
It can be interchanged under condition, so that the embodiments described herein can be real with the sequence other than the content for illustrating or describing herein
It applies.In addition, term " includes " and " having " and their any deformation, it is intended that cover it is non-exclusive include, for example, packet
The process, method, system, product or equipment for having contained series of steps or module those of be not necessarily limited to be clearly listed step or
Module, but may include other steps being not clearly listed or intrinsic for these process, methods, product or equipment or
Module.Occur in this application to step carry out name perhaps number be not meant to must according to name or number
Indicated time/logic sequencing executes the step in method flow, and named or number process step can be with
Execution order is changed according to the technical purpose to be realized, as long as identical or similar technical effect can be reached.This Shen
Please appeared in module division, be a kind of division in logic, can have other division side when realizing in practical application
Formula, such as multiple modules can be combined into or are integrated in another system, or some features can be ignored or not executed, separately
Outside, shown or discussion mutual coupling, direct-coupling or communication connection can be through some interfaces, module
Between indirect coupling or communication connection can be electrical or other similar form, be not construed as limiting in the application.Also, make
It can be the separation that may not be physically for the module or submodule of separate part description, can be and may not be physics
Module, or can be distributed in multiple circuit modules, some or all of modules can be selected according to the actual needs
To realize the purpose of application scheme.
Those of ordinary skill in the art will appreciate that all or part of the steps in the various methods of above-described embodiment is can
It is completed with instructing relevant hardware by program, which can be stored in a computer readable storage medium, storage
Medium may include: ROM, RAM, disk or CD etc..
Above to avoided provided by the embodiment of the present application endless loop calculate optimization method, optimization device and system into
It has gone and has been discussed in detail, specific examples are used herein to illustrate the principle and implementation manner of the present application, the above implementation
The explanation of example is merely used to help understand the present processes and its core concept；Meanwhile for the general technology people of this field
Member, according to the thought of the application, there will be changes in the specific implementation manner and application range, in conclusion this explanation
Book content should not be construed as the limitation to the application.
Claims (10)
1. a kind of optimization method for avoiding endless loop from calculating characterized by comprising
Determine that at least two calculation formula, at least two calculation formula include the first calculation formula according to preset formula library
With the second calculation formula, first calculation formula includes the first independent variable, and second calculation formula includes target variable；
The first calculated result for being associated with first calculation formula is the second independent variable of second calculation formula；
Obtain the value of first independent variable；
It is calculated according to the value and at least two calculation formula, obtains the value of target variable.
2. the method according to claim 1, wherein the method also includes:
Determine that three calculation formula, three calculation formula include the first calculation formula, the second meter according to preset formula library
Formula and third calculation formula are calculated, first calculation formula and the second calculation formula include the first independent variable, second meter
Calculating formula includes target variable；
First calculated result of association first calculation formula is the second independent variable of second calculation formula, packet
It includes:
The first calculated result for being associated with first calculation formula is the second independent variable of second calculation formula；
The second calculated result for being associated with second calculation formula is the third independent variable of second calculation formula.
3. the method according to claim 1, wherein the first of association first calculation formula calculates knot
After fruit is the second independent variable of second calculation formula, the method also includes:
According to second independent variable and first calculated result, by first calculation formula and first calculation formula
Merge, generates and merge formula, the merging formula is for being associated with the first independent variable and target variable.
4. method according to claim 1 to 3, which is characterized in that described to determine at least two according to preset formula library
After a calculation formula, the method also includes:
Show at least two calculation formula.
5. method according to claim 1 to 3, which is characterized in that at least two calculation formula of determination, comprising:
Obtain first independent variable；
According to first independent variable and preset calculation formula set, at least two calculation formula is determined.
6. a kind of optimization device characterized by comprising
Determination unit, for determining at least two calculation formula, at least two calculation formula packet according to preset formula library
The first calculation formula and the second calculation formula are included, first calculation formula includes the first independent variable, second calculation formula
Including target variable；
Associative cell, for be associated with first calculation formula the first calculated result be second calculation formula second from
Variable；
Acquiring unit, for obtaining the value of first independent variable；
Computing unit obtains taking for target variable for being calculated according to the value and at least two calculation formula
Value.
7. optimization device according to claim 6, which is characterized in that
The determination unit is also used to determine that three calculation formula, three calculation formula include according to preset formula library
First calculation formula, the second calculation formula and third calculation formula, first calculation formula and the second calculation formula include the
One independent variable, second calculation formula includes target variable；
The associative cell, the first calculated result for being also used to be associated with first calculation formula is second calculation formula
Second independent variable；
The associative cell, the second calculated result for being also used to be associated with second calculation formula is second calculation formula
Third independent variable.
8. optimization device according to claim 6, which is characterized in that
The associative cell is also used to be calculated described first public according to second independent variable and first calculated result
Formula merges with first calculation formula, generates and merges formula, and the merging formula becomes for being associated with the first independent variable and target
Amount.
9. a kind of optimization device, which is characterized in that the optimization device includes: input/output (I/O) interface, processor and deposits
Reservoir is stored with program instruction in the memory；
The processor executes side as described in any one in claim 1-5 for executing the program instruction stored in memory
Method.
10. a kind of computer readable storage medium, including instruction, which is characterized in that when described instruction is transported on a computing device
When row, so that the computer equipment executes method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811253209.3A CN109324800A (en) | 2018-10-25 | 2018-10-25 | It is a kind of avoid endless loop calculate optimization method and optimization device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811253209.3A CN109324800A (en) | 2018-10-25 | 2018-10-25 | It is a kind of avoid endless loop calculate optimization method and optimization device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109324800A true CN109324800A (en) | 2019-02-12 |
Family
ID=65262452
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811253209.3A Pending CN109324800A (en) | 2018-10-25 | 2018-10-25 | It is a kind of avoid endless loop calculate optimization method and optimization device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109324800A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101093493A (en) * | 2006-06-23 | 2007-12-26 | 国际商业机器公司 | Speech conversion method for database inquiry, converter, and database inquiry system |
| CN101609531A (en) * | 2009-07-29 | 2009-12-23 | 金蝶软件（中国）有限公司 | Data processing method in a kind of enterprise resource planning and device |
| CN103699377A (en) * | 2013-12-04 | 2014-04-02 | 国家电网公司 | Reconstruction combination method for program codes |
| CN104899209A (en) * | 2014-03-05 | 2015-09-09 | 阿里巴巴集团控股有限公司 | Optimization method and device for open type data processing service |
| CN105045576A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Management method and apparatus for calculation formulae in business document |
-
2018
- 2018-10-25 CN CN201811253209.3A patent/CN109324800A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101093493A (en) * | 2006-06-23 | 2007-12-26 | 国际商业机器公司 | Speech conversion method for database inquiry, converter, and database inquiry system |
| CN101609531A (en) * | 2009-07-29 | 2009-12-23 | 金蝶软件（中国）有限公司 | Data processing method in a kind of enterprise resource planning and device |
| CN103699377A (en) * | 2013-12-04 | 2014-04-02 | 国家电网公司 | Reconstruction combination method for program codes |
| CN104899209A (en) * | 2014-03-05 | 2015-09-09 | 阿里巴巴集团控股有限公司 | Optimization method and device for open type data processing service |
| CN105045576A (en) * | 2015-06-29 | 2015-11-11 | 用友优普信息技术有限公司 | Management method and apparatus for calculation formulae in business document |
Non-Patent Citations (1)
| Title |
|---|
| 孙金武等: "《国家税收》", 30 September 1993 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110209807A (en) | A kind of method of event recognition, the method for model training, equipment and storage medium | |
| CN107424069A (en) | A kind of generation method of air control feature, risk monitoring and control method and apparatus | |
| CN107395665A (en) | A kind of block chain service handling and business common recognition method and device | |
| WO2022083093A1 (en) | Probability calculation method and apparatus in graph, computer device and storage medium | |
| CN106469413B (en) | Data processing method and device for virtual resources | |
| TWI682335B (en) | Data object display method and device | |
| CN108566420A (en) | Data processing method, equipment and computer readable storage medium for block chain | |
| WO2019085601A1 (en) | Task execution method and apparatus | |
| CN108777698A (en) | Webpage storage method, system and block chain node device | |
| CN109754359A (en) | A kind of method and system that the pondization applied to convolutional neural networks is handled | |
| CN110457577A (en) | Data processing method, device, equipment and computer storage medium | |
| CN109313642A (en) | Bill information caching method, bill information querying method and terminal device | |
| CN109191287A (en) | A kind of sharding method, device and the electronic equipment of block chain intelligence contract | |
| CN110276618A (en) | The method and system for generating money laundering ancestor prediction model, predicting money laundering ancestor | |
| CN108520471A (en) | It is overlapped community discovery method, device, equipment and storage medium | |
| CN106326062A (en) | Method and device for controlling running state of application program | |
| CN113516246A (en) | Parameter optimization method, quantum chip control method and device | |
| CN109600724A (en) | A kind of method and apparatus that short message is sent | |
| CN110349013A (en) | Risk control method and device | |
| CN108875048A (en) | Report form generation method, device, electronic equipment and readable storage medium storing program for executing | |
| US20230139364A1 (en) | Generating user interfaces comprising dynamic base limit value user interface elements determined from a base limit value model | |
| CN111522840A (en) | Label configuration method, device, equipment and computer readable storage medium | |
| WO2020155083A1 (en) | Neural network distributed training method and device | |
| CN110209744A (en) | Relevant database and its operating method and device based on alliance's chain | |
| US11120513B2 (en) | Capital chain information traceability method, system, server and readable storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190212 |