CN108268437A - The method and device of formula manipulation - Google Patents
The method and device of formula manipulation Download PDFInfo
- Publication number
- CN108268437A CN108268437A CN201611261774.5A CN201611261774A CN108268437A CN 108268437 A CN108268437 A CN 108268437A CN 201611261774 A CN201611261774 A CN 201611261774A CN 108268437 A CN108268437 A CN 108268437A
- Authority
- CN
- China
- Prior art keywords
- subformula
- formula
- result data
- parameter
- data
- 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
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/10—Complex mathematical operations
- G06F17/18—Complex mathematical operations for evaluating statistical data, e.g. average values, frequency distributions, probability functions, regression analysis
Landscapes
- Engineering & Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Computational Mathematics (AREA)
- Mathematical Physics (AREA)
- Pure & Applied Mathematics (AREA)
- Mathematical Optimization (AREA)
- Mathematical Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Bioinformatics & Computational Biology (AREA)
- Operations Research (AREA)
- Bioinformatics & Cheminformatics (AREA)
- Life Sciences & Earth Sciences (AREA)
- Evolutionary Biology (AREA)
- General Health & Medical Sciences (AREA)
- Computational Linguistics (AREA)
- Health & Medical Sciences (AREA)
- Probability & Statistics with Applications (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Algebra (AREA)
- Artificial Intelligence (AREA)
- Databases & Information Systems (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present application provides a kind of method and device of Formula Parsing.The embodiment of the present application parses formula, obtains the corresponding subformula of the formula, and inquiry whether there is the corresponding result data of the subformula in the buffer；If so, the corresponding result data of the subformula is then obtained from caching, to calculate the corresponding result data of the formula；Otherwise, obtain the operation relation of the subformula and the parameter of the subformula, the result data of the subformula is determined according to the operation relation and the parameter, the corresponding result data of formula can be obtained from caching to calculate the corresponding result data the embodiment of the present application of the formula, on the basis of data accuracy is ensured, the efficiency that batch processing is carried out to formula is improved.
Description
Technical field
The invention relates to field of computer technology more particularly to a kind of method and devices of formula manipulation.
Background technology
Report is the carrier for recording data.The forms such as table, chart can be used to come dynamic, intuitively display data for report.
Formula is usually provided in report, formula can obtain result data according to the direct operation of related data, can ensure accuracy
While, give offering convenience property of operating personnel.Therefore, report and its formula have been obtained for being widely applied.
In the financial system of enterprise-level application, financial staff is frequently necessary to do various financial statements.In a particular application,
Financial system needs to obtain the corresponding data of variable in formula from data base querying when carrying out calculation process to formula.But by
In practical application, the formula of report is usually relatively complex, and the type of formula, quantity are more, especially in enterprise-level
Merge in class report, need to recalculate the formula calculated, therefore financial system can frequently grasp data
Make, the access times of database often reach thousands of times or even tens thousand of times.Formula progress calculation process efficiency is very low, takes few
Then tens seconds, at most several minutes, dozens of minutes caused user experience very poor.
Therefore, on the basis of data accuracy is ensured, operation efficiency when batch processing is carried out to formula is improved, is become
In the prior art the technical issues of urgent need to resolve.
Invention content
In view of the above problems, the application provides a kind of method and device of formula manipulation, overcomes the above problem or at least
Partly solve the above problems.
The embodiment of the present application provides a kind of method of formula manipulation, including：
Formula is parsed, obtains the corresponding subformula of the formula, and inquiry whether there is the son in the buffer
The corresponding result data of formula；
If so, the corresponding result data of the subformula is then obtained from caching, to calculate the corresponding result of the formula
Data；
Otherwise, the operation relation of the subformula and the parameter of the subformula are obtained, according to the operation relation and institute
The result data that parameter determines the subformula is stated, to calculate the corresponding result data of the formula.
Optionally, in the embodiment of the present application, it is described that formula is parsed, the corresponding subformula of the formula is obtained,
And inquiry includes with the presence or absence of the corresponding result data of the subformula in the buffer：
Formula is parsed, obtains the priority of the corresponding subformula of the formula and the subformula；
The sequence of the subformula is determined according to the corresponding priority of the subformula, with the sequence according to the subformula
Inquiry is with the presence or absence of the corresponding result data of the subformula in the buffer.
Optionally, in the embodiment of the present application, the ginseng of the operation relation and the subformula for obtaining the subformula
Number, determines that the result data of the subformula includes according to the operation relation and the parameter：
The subformula, which is parsed, using regular expression obtains the operation relation of the subformula and the ginseng of the subformula
Number；
The corresponding concrete numerical value of the parameter is inquired in the database, it will be described in the corresponding concrete numerical value substitution of the parameter
Operation relation carries out arithmetic operation, obtains the result data of the subformula.
Optionally, in the embodiment of the present application, it is described that the subformula is determined according to the operation relation and the parameter
Result data include：
The data base manipulation statement of operation can be carried out according to the operation relation and parameter generation；
The data base manipulation statement of operation can be carried out described in execution, to obtain the result data of the subformula.
Optionally, in the embodiment of the present application, the ginseng of the operation relation and the subformula for obtaining the subformula
Number determines the result data of the subformula according to the operation relation and the parameter, to calculate the corresponding knot of the formula
It is further included after fruit data：
It will be in the corresponding result data storage to the caching of the subformula and the subformula.
Optionally, in the embodiment of the present application, the corresponding result data of the formula that calculates further includes later：
According to the formula and the corresponding result data generation statement form data of the formula.
A kind of device of formula manipulation, which is characterized in that including：
Enquiry module is configured to parse formula, obtains the corresponding subformula of the formula, and inquire in the buffer
With the presence or absence of the corresponding result data of the subformula；
Cache module is configured to obtain the corresponding result data of the subformula from caching, to calculate the formula pair
The result data answered；
Computing module is configured to obtain the operation relation of the subformula and the parameter of the subformula, according to the fortune
Calculation relationship and the parameter determine the result data of the subformula, to calculate the corresponding result data of the formula.
Optionally, in the embodiment of the present application, the enquiry module includes：
Priority obtaining unit is configured to parse formula, obtains the corresponding subformula of the formula and the son
The priority of formula；
Order determination unit is configured to determine the sequence of the subformula according to the corresponding priority of the subformula, with
Result data corresponding with the presence or absence of the subformula is inquired according to the sequence of the subformula in the buffer.
Optionally, in the embodiment of the present application, the computing module includes：
Resolution unit, be configured so that regular expression parse the subformula obtain the subformula operation relation and
The parameter of the subformula；
Computing unit is configured to inquire the corresponding concrete numerical value of the parameter in the database, and the parameter is corresponding
Concrete numerical value substitutes into the operation relation and carries out arithmetic operation, obtains the result data of the subformula.
Optionally, in the embodiment of the present application, the computing module is further configured to：
The data base manipulation statement of operation can be carried out according to the operation relation and parameter generation；
The data base manipulation statement of operation can be carried out described in execution, to obtain the result data of the subformula.
Optionally, in the embodiment of the present application, the cache module is further configured to：
It will be in the corresponding result data storage to the caching of the subformula and the subformula.
Optionally, in the embodiment of the present application, described device further includes：
Report generation module is configured to according to the formula and the corresponding result data generation statement form number of the formula
According to.
By above technical scheme as it can be seen that the embodiment of the present application can be by Formula Parsing into subformula, inquiry is public in the buffer
The corresponding result data of formula, when the result data is not present in such as caching, to obtaining the operation relation and ginseng of the subformula
Number, and carry out calculation process and obtain the corresponding result data of subformula, with the corresponding result data of calculation formula.The application is implemented
Example can obtain the corresponding result data of formula from caching, on the basis of data accuracy is ensured, improve and formula is carried out
The efficiency of batch processing.
Description of the drawings
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or it will show below
There is attached drawing needed in technology description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
Apply for some embodiments described in embodiment, for those of ordinary skill in the art, can also be obtained according to these attached drawings
Obtain other attached drawings.
Fig. 1 is a kind of flow chart of an embodiment of the method for formula manipulation of the application；
Fig. 2 is a kind of flow chart of another embodiment of the method for formula manipulation of the application；
Fig. 3 is a kind of flow chart of another embodiment of the method for formula manipulation of the application；
Fig. 4 is a kind of flow chart of another embodiment of the method for formula manipulation of the application；
Fig. 5 is a kind of flow chart of another embodiment of the method for formula manipulation of the application；
Fig. 6 is a kind of structure chart of an embodiment of formula manipulation device of the application；
Fig. 7 is a kind of structure chart of another embodiment of formula manipulation device of the application；
Fig. 8 is a kind of structure chart of another embodiment of formula manipulation device of the application；
Fig. 9 is a kind of structure chart of another embodiment of formula manipulation device of the application；
Figure 10 is the hardware architecture diagram for the electronic equipment that the application one performs formula processing method.
Specific embodiment
The embodiment of the present application can inquire the corresponding result data of subformula in the buffer, such as by Formula Parsing into subformula
When the result data being not present in caching, to obtaining the operation relation and parameter of the subformula, and carry out calculation process and obtain
The corresponding result data of subformula is obtained, with the corresponding result data of calculation formula.The embodiment of the present application can obtain public affairs from caching
The corresponding result data of formula on the basis of data accuracy is ensured, improves the efficiency that batch processing is carried out to formula.
Certainly, implement any technical solution of the embodiment of the present application do not need necessarily to reach simultaneously more than it is all excellent
Point.
In order to which those skilled in the art is made to more fully understand the technical solution in the embodiment of the present application, below in conjunction with the application
The technical solution in the embodiment of the present application is clearly and completely described in attached drawing in embodiment, it is clear that described reality
It is only the embodiment of the present application part of the embodiment to apply example, instead of all the embodiments.Based on the implementation in the embodiment of the present application
Example, those of ordinary skill in the art's all other embodiments obtained should all belong to the range that the embodiment of the present application is protected.
Further illustrate that the embodiment of the present application implements with reference to the embodiment of the present application attached drawing.
Referring to Fig. 1, in the application one in the specific implementation, the method for the formula manipulation includes：
S101, formula is parsed, obtains the corresponding subformula of the formula, and inquiry whether there is institute in the buffer
State the corresponding result data of subformula.
Specifically, in the present embodiment, the formula can be made of at least one subformula.For example, formula 01：Company
The gross sales amount of the gross sales amount+B products of gross sales amount=A products.It is public that formula 01 can be parsed at least one son by this step
Formula：Subformula 02 (gross sales amount of A products) and subformula 03 (gross sales amount of B products).
In the present embodiment, the formula can only include a subformula.
In the present embodiment, the subformula can be made of several subformulas, this step can further parse subformula, directly
To the minimum unit for obtaining subformula.
Specifically, in the present embodiment, the structure of storage data can be in the caching：The corresponding knot of formula-formula
Fruit.The caching can be created by carrying out inquiry operation to inquiry in database, also can be after completing to calculate a certain formula, will
It is built in formula and the storage to the caching of corresponding result.
If step S101, judgement result is yes, following step S102 is performed.
S102, the corresponding result data of the subformula is obtained from caching, to calculate the corresponding number of results of the formula
According to；
For example, there are the corresponding result datas of subformula 02 (gross sales amount of A products) for inquiry such as in the caching
1000, it is calculated with the result data answered according to subformula 02, obtains the result data of formula 01.
If step S101 judgement results are no, following step S103 is performed.
The parameter of S103, the operation relation for obtaining the subformula and the subformula, according to the operation relation and institute
The result data that parameter determines the subformula is stated, to calculate the corresponding result data of the formula.
Specifically, in the present embodiment, the operation relation may include：Add, subtract, multiplication and division, summation, averaging, seeking system
Evaluation etc..
Specifically, in the present embodiment, the corresponding concrete numerical value of the parameter can be obtained, and by the corresponding specific number of parameter
Value is updated in the operation relation of subformula, obtains the result data of subformula.
For example, there is no subformulas 03 (gross sales amount of B products) for inquiry such as in the caching, then subformula is obtained
Operation relation and parameter.Subformula 03：The price of the sales volume of the gross sales amount of B products=B products × B products；Then the son is public
The parameter of formula includes：The sales volume of B products, the price of B products.The concrete numerical value of parameter can be obtained, such as the sales volume of B products：100；B
The price of product：20.The concrete numerical value of parameter is updated in the operation relation of subformula 03, gross sales amount=100 of B products
× 20, the result data 2000 of subformula 03 is obtained by calculating, to be calculated according to the result data of subformula 03, is obtained
The result data of formula 01.
The present embodiment is further described with reference to concrete application scene.In the financial system of enterprise-level application, finance
Personnel are frequently necessary to handle various financial statements, and tens or even hundreds of cells, each cell are included in every report
A complicated formulas may be included, and complicated formulas can forming by a variety of and/or multiple subformulas.In processing report
When, batch processing can be carried out to the formula in report.The present embodiment splits into sub- public affairs in batch processing formula, by complicated formulas
Formula carries out subformula calculation process, and will be in the subformula's deposit caching that obtain operation result.Therefore, the processing of report
Rate will not in report formula type grow into geometry grade increase or exponential growth；Opposite, processed formula is got over
More, sample subformula present in caching is more, and arithmetic speed is relatively faster.
During the application is realized, in the prior art, when handling each formula, it usually needs determine formula in advance
Type, and formula manipulation object is created according to the type of formula in memory, by taking Java language as an example, keyword can be used
New creates a formula manipulation object, when using keyword new, needs the type of specified formula manipulation object.This mode
Usual autgmentability is poor, for example, during report form processing, other than conventional general formula, it is often necessary to using making by oneself
Adopted formula, and the type of custom formula is uncertain and dynamic change.It solves the above problems the present embodiment provides a kind of
Technical solution, i.e., using the factory mode (Factory Pattern) in design pattern, factory mode can not need to determine public affairs
The type of formula process object, only need to externally provide an interface.By taking Java language as an example, keyword can be used
Interface creates the interface of a formula manipulation object.Specifically, when creating formula manipulation object, it is only necessary to factory
The interface that pattern provides is passed to parameter.Using factory mode, the factor that can change can be encapsulated, so as to improve this implementation
The cohesion of module, reduces the degree of coupling between module in example.
Optionally, in the present embodiment, usable regular expression determines the type of factory mode processing formula.For example,
The regular expression that can be parsed is preset in formula factory：
The regular expression of intrabranch formula：NBWL\(".*",".*",".+",".+",-1\)
Throw time regular expression of ratio formula：(i)TZBL\("(.*)","(.*)"\)
When carrying out batch parsing to specific formula, specific formula is matched one by one with above-mentioned regular expression,
With one group of intrabranch formula, one group of throwing time ratio formula and one group of other type formula, formula work after the completion, can be respectively obtained
Factory creates Formula Parsing example according to the formula after grouping, is parsed respectively using Formula Parsing example, understands so as to improve
Analyse efficiency.
The embodiment of the present application can inquire the corresponding result data of subformula in the buffer, such as by Formula Parsing into subformula
When the result data being not present in caching, to obtaining the operation relation and parameter of the subformula, and carry out calculation process and obtain
The corresponding result data of subformula is obtained, with the corresponding result data of calculation formula.The embodiment of the present application can obtain public affairs from caching
The corresponding result data of formula on the basis of data accuracy is ensured, improves the efficiency that batch processing is carried out to formula.
It is another in the application in the specific implementation, the method for the formula manipulation includes referring to Fig. 2：
S201, formula is parsed, obtains the priority of the corresponding subformula of the formula and the subformula；
Specifically, in the present embodiment, the formula can parse several subformulas, then the priority of subformula be more than etc.
In the formula, that is, when carrying out calculation process, preferentially carry out calculation process to subformula.
For example, formula 01：The gross sales amount of the gross sales amount+B products of the gross sales amount of company=A products.Formula 01 solves
At least one subformula is precipitated：Subformula 02 (gross sales amount of A products) and subformula 03 (gross sales amount of B products).It is sub public
Formula 02 (gross sales amount of A products) and the priority of subformula 03 (gross sales amount of B products) are higher than the priority of formula 01.
Specifically, in the present embodiment, can multiple formula be carried out with batch processing, and the subformula Yi Ji obtained will be parsed
The form storage of conjunction avoids repeatedly carrying out calculation process to same a subformula.
S202, the sequence that the subformula is determined according to the corresponding priority of the subformula, with according to the subformula
Sequence inquire result data corresponding with the presence or absence of the subformula in the buffer；
Specifically, in the present embodiment, can classify according to priority to the subformula, the high subformula of priority
It is preferential to carry out calculation process.
S203, the corresponding result data of the subformula is obtained from caching, to calculate the corresponding number of results of the formula
According to；
The parameter of S204, the operation relation for obtaining the subformula and the subformula, according to the operation relation and institute
The result data that parameter determines the subformula is stated, to calculate the corresponding result data of the formula.
In the present embodiment, step S203, S204 is respectively similar to step S102, S103 in above-mentioned Fig. 1 embodiments, in detail not
It repeats again.
The present embodiment can be stored the subformula that Formula Solution is precipitated, and according to son in batches to formula manipulation with aggregate form
The priority of formula is ranked up, the high priority processing of priority.The present embodiment can avoid repeatedly transporting same a subformula
Calculation is handled, and reduces the operand of processor, improves the efficiency of formula manipulation.
It is another in the application in the specific implementation, the step S3 includes referring to Fig. 3：
S303, the operation relation of subformula's acquisition subformula and the subformula are parsed using regular expression
Parameter.
In this step, the subformula is the subformula that Formula Solution is precipitated to minimum unit, i.e., can not further parse
Formula, alternatively referred to as simple formula.
In the present embodiment, formula can exist in the form of character string in a computer.Character string can be parsed, obtains institute
State the corresponding parameter of formula.Specifically, the formula can be solved by regular expression (Regular Expression)
Analysis.
The regular expression is a kind of logical formula to string operation, available some specific words predefined
The combination of symbol and these specific characters, forms one " regular character string ", this " regular character string " is for expressing to character string
A kind of filter logic.For example, use regular expression：Regex.Split (strFormula, "+") can obtain operator+
The parameter of both sides.
S304, the corresponding concrete numerical value of the parameter is inquired in the database, by the parameter corresponding concrete numerical value generation
Enter the operation relation and carry out arithmetic operation, obtain the result data of the subformula.
In the present embodiment, the parameter of the subformula can be stored in database, by being obtained to the inquiry of database
The corresponding concrete numerical value of parameter.Specifically, SQL (Structured Query Language, structured query language) can be used
Inquiry operation is carried out to database, obtains the corresponding concrete numerical value of variable.
Specifically, in this step, can also batch processing be carried out to the subformula, for example, obtaining in whole subformulas
All correlated variables perform once-through operation to database.
The present embodiment is handled in Formula Parsing using regular expression, is improved the processing speed of processor, is carried
The high efficiency of formula manipulation.
It is another in the application in the specific implementation, the step S3 includes referring to Fig. 4：
S401, the operation relation of subformula's acquisition subformula and the subformula are parsed using regular expression
Parameter.
S402, the data base manipulation statement that operation can be carried out according to the operation relation and parameter generation, perform institute
The data base manipulation statement of operation can be carried out by stating, to obtain the result data of the subformula.
In the present embodiment, the subformula is the subformula that Formula Solution is precipitated to minimum unit, i.e., can not further solve
Analyse formula, alternatively referred to as simple formula.
In the present embodiment, SQL statement is generated according to the operation relation and the parameter, in the database into performing acquisition
SQL statement, you can obtain the result data of the subformula.
For example, subformula 03：The price of the sales volume of the gross sales amount of B products=B products × B products；SQL languages can be used
Sentence：Select (B product sales volume * B product prices) obtains the gross sales amount of B products." B products " is number in the SQL statement
According to the table name in library, " sales volume " " price " is respectively the field name in table.
In the present embodiment, step S401 is repeated no more in detail similar to the step S301 in above-mentioned Fig. 3 embodiments.
The present embodiment generates data base manipulation statement, and pass through execution number according to the operation relation of formula and the parameter of formula
The result data of subformula is obtained according to library action statement, the present embodiment is given the arithmetic operation of formula to database processing, can be dropped
The operand of the server of low formula manipulation, so as to improve the efficiency of formula manipulation.
Referring to Fig. 5, it is another in the application in the specific implementation, the method includes：
S501, formula is parsed, obtains the corresponding subformula of the formula, and inquiry whether there is institute in the buffer
State the corresponding result data of subformula；
S502, the corresponding result data of the subformula is obtained from caching, to calculate the corresponding number of results of the formula
According to；
The parameter of S503, the operation relation for obtaining the subformula and the subformula, according to the operation relation and institute
The result data that parameter determines the subformula is stated, to calculate the corresponding result data of the formula.
S504, the corresponding result data of the subformula and the subformula is stored into the caching.
Specifically, in the present embodiment, this step can store the result data for having obtained subformula to the caching
In, so that it is guaranteed that each subformula only carries out once-through operation, when reusing the subformula, it need to only inquire and obtain from caching
.
S505, statement form data are generated according to the formula and the corresponding result data of the formula.
Specifically, in the present embodiment, the statement form can be Excel forms.This step can be by formula and formula
Corresponding result data is written in a certain cell specified of Excel tables, so as to reduce the operation bidirectional of user, is improved
The convenience of the embodiment of the present application.
In the present embodiment, step S501, S502, S503 respectively similar in above-mentioned Fig. 1 embodiments step S101, S102,
S103 is repeated no more in detail.
Referring to Fig. 6, in the application one in the specific implementation, the device of the formula manipulation includes：
Enquiry module 601 is configured to parse formula, obtains the corresponding subformula of the formula, and in the buffer
Inquiry is with the presence or absence of the corresponding result data of the subformula.
Specifically, in the present embodiment, the formula can be made of at least one subformula.For example, formula 01：Company
The gross sales amount of the gross sales amount+B products of gross sales amount=A products.It is public that formula 01 can be parsed at least one son by this module
Formula：Subformula 02 (gross sales amount of A products) and subformula 03 (gross sales amount of B products).
In the present embodiment, the formula can only include a subformula.
In the present embodiment, the subformula can be made of several subformulas, this module can further parse subformula, directly
To the minimum unit for obtaining subformula.
Specifically, in the present embodiment, the structure of storage data can be in the caching：The corresponding knot of formula-formula
Fruit.The caching can be created by carrying out inquiry operation to inquiry in database, also can be after completing to calculate a certain formula, will
It is built in formula and the storage to the caching of corresponding result.
Cache module 602 is configured to obtain the corresponding result data of the subformula from caching, to calculate the formula
Corresponding result data；
For example, there are the corresponding result datas of subformula 02 (gross sales amount of A products) for inquiry such as in the caching
1000, it is calculated with the result data answered according to subformula 02, obtains the result data of formula 01.
Computing module 603 is configured to obtain the operation relation of the subformula and the parameter of the subformula, according to described
Operation relation and the parameter determine the result data of the subformula, to calculate the corresponding result data of the formula.
Specifically, in the present embodiment, the operation relation may include：Add, subtract, multiplication and division, summation, averaging, seeking system
Evaluation etc..
Specifically, in the present embodiment, the corresponding concrete numerical value of the parameter can be obtained, and by the corresponding specific number of parameter
Value is updated in the operation relation of subformula, obtains the result data of subformula.
For example, there is no subformulas 03 (gross sales amount of B products) for inquiry such as in the caching, then subformula is obtained
Operation relation and parameter.Subformula 03：The price of the sales volume of the gross sales amount of B products=B products × B products；Then the son is public
The parameter of formula includes：The sales volume of B products, the price of B products.The concrete numerical value of parameter can be obtained, such as the sales volume of B products：100；B
The price of product：20.The concrete numerical value of parameter is updated in the operation relation of subformula 03, gross sales amount=100 of B products
× 20, the result data 2000 of subformula 03 is obtained by calculating, to be calculated according to the result data of subformula 03, is obtained
The result data of formula 01.
The present embodiment is further described with reference to concrete application scene.In the financial system of enterprise-level application, finance
Personnel are frequently necessary to handle various financial statements, and tens or even hundreds of cells, each cell are included in every report
A complicated formulas may be included, and complicated formulas can forming by a variety of subformulas.It, can be to report when handling report
In formula carry out batch processing.Complicated formulas is split into subformula, to subformula by the present embodiment in batch processing formula
Calculation process is carried out, and will be in subformula's deposit caching that operation result obtained.Therefore, the processing speed of report will not be with report
Formula type grows into the growth of geometry grade or exponential growth in table；Opposite, processed formula is more, exists in caching
Sample subformula it is more, arithmetic speed is relatively faster.
During the application is realized, in the prior art, when handling each formula, it usually needs determine formula in advance
Type, and formula manipulation object is created according to the type of formula in memory, by taking Java language as an example, keyword can be used
New creates a formula manipulation object, when using keyword new, needs the type of specified formula manipulation object.This mode
Usual autgmentability is poor, for example, during report form processing, other than conventional general formula, it is often necessary to using making by oneself
Adopted formula, and the type of custom formula is uncertain and dynamic change.It solves the above problems the present embodiment provides a kind of
Technical solution, i.e., using the factory mode (Factory Pattern) in design pattern, factory mode can not need to determine public affairs
The type of formula process object, only need to externally provide an interface.By taking Java language as an example, keyword can be used
Interface creates the interface of a formula manipulation object.Specifically, when creating formula manipulation object, it is only necessary to factory
The interface that pattern provides is passed to parameter.Using factory mode, the factor that can change can be encapsulated, so as to improve this implementation
The cohesion of module, reduces the degree of coupling between module in example.
Optionally, in the present embodiment, usable regular expression determines the type of factory mode processing formula.For example,
The regular expression that can be parsed is preset in formula factory：
The regular expression of intrabranch formula：NBWL\(".*",".*",".+",".+",-1\)
Throw time regular expression of ratio formula：(i)TZBL\("(.*)","(.*)"\)
When carrying out batch parsing to specific formula, specific formula is matched one by one with above-mentioned regular expression,
With one group of intrabranch formula, one group of throwing time ratio formula and one group of other type formula, formula work after the completion, can be respectively obtained
Factory creates Formula Parsing example according to the formula after grouping, is parsed respectively using Formula Parsing example, understands so as to improve
Analyse efficiency.
The embodiment of the present application can inquire the corresponding result data of subformula in the buffer, such as by Formula Parsing into subformula
When the result data being not present in caching, to obtaining the operation relation and parameter of the subformula, and carry out calculation process and obtain
The corresponding result data of subformula is obtained, with the corresponding result data of calculation formula.The embodiment of the present application can obtain public affairs from caching
The corresponding result data of formula on the basis of data accuracy is ensured, improves the execution efficiency of the present embodiment.
It is another in the application in the specific implementation, the device of the formula manipulation includes referring to Fig. 7：
Priority obtaining unit 711 is configured to parse formula, obtains the corresponding subformula of the formula and described
The priority of subformula；
Specifically, in the present embodiment, the formula can parse several subformulas, then the priority of subformula be more than etc.
In the formula, that is, when carrying out calculation process, preferentially carry out calculation process to subformula.
For example, formula 01：The gross sales amount of the gross sales amount+B products of the gross sales amount of company=A products.Formula 01 solves
At least one subformula is precipitated：Subformula 02 (gross sales amount of A products) and subformula 03 (gross sales amount of B products).It is sub public
Formula 02 (gross sales amount of A products) and the priority of subformula 03 (gross sales amount of B products) are higher than the priority of formula 01.
Specifically, in the present embodiment, can multiple formula be carried out with batch processing, and the subformula Yi Ji obtained will be parsed
The form storage of conjunction avoids repeatedly carrying out calculation process to same a subformula.
Order determination unit 721 is configured to determine the sequence of the subformula according to the corresponding priority of the subformula,
To inquire result data corresponding with the presence or absence of the subformula in the buffer according to the sequence of the subformula；
Specifically, in the present embodiment, can classify according to priority to the subformula, the high subformula of priority
It is preferential to carry out calculation process.
Cache module 702 is configured to obtain the corresponding result data of the subformula from caching, to calculate the formula
Corresponding result data；
Computing module 703 is configured to obtain the operation relation of the subformula and the parameter of the subformula, according to described
Operation relation and the parameter determine the result data of the subformula, to calculate the corresponding result data of the formula.
In the present embodiment, cache module 702, computing module 703 cache mould similar to the step in above-mentioned Fig. 6 embodiments respectively
Block 602, computing module 603, repeat no more in detail.
The present embodiment can be stored the subformula that Formula Solution is precipitated, and according to son in batches to formula manipulation with aggregate form
The priority of formula is ranked up, the high priority processing of priority.The present embodiment can avoid repeatedly transporting same a subformula
Calculation is handled, and reduces the operand of processor, improves the efficiency of formula manipulation.
It is another in the application in the specific implementation, on the basis of Fig. 6 corresponding embodiments referring to Fig. 8, the computing module packet
It includes：
Resolution unit 813 is configured so that regular expression parses the operation pass that the subformula obtains the subformula
System and the parameter of the subformula.
In the present embodiment, the subformula is the subformula that Formula Solution is precipitated to minimum unit, i.e., can not further solve
Analyse formula, alternatively referred to as simple formula.
In the present embodiment, formula can exist in the form of character string in a computer.Character string can be parsed, obtains institute
State the corresponding parameter of formula.Specifically, the formula can be solved by regular expression (Regular Expression)
Analysis.
The regular expression is a kind of logical formula to string operation, available some specific words predefined
The combination of symbol and these specific characters, forms one " regular character string ", this " regular character string " is for expressing to character string
A kind of filter logic.For example, use regular expression：Regex.Split (strFormula, "+") can obtain operator+
The parameter of both sides.
Computing unit 823 is configured to inquire the corresponding concrete numerical value of the parameter in the database, and the parameter is corresponded to
Concrete numerical value substitute into the operation relation and carry out arithmetic operation, obtain the result data of the subformula.
In the present embodiment, the parameter of the subformula can be stored in database, by being obtained to the inquiry of database
The corresponding concrete numerical value of parameter.Specifically, SQL (Structured Query Language, structured query language) can be used
Inquiry operation is carried out to database, obtains the corresponding concrete numerical value of variable.
Specifically, in this module, can also batch processing be carried out to the subformula, for example, obtaining in whole subformulas
All correlated variables perform once-through operation to database.
The present embodiment is handled in Formula Parsing using regular expression, is improved the processing speed of processor, is carried
The high efficiency of formula manipulation.
It is another in the application in the specific implementation, on the basis of Fig. 6 corresponding embodiments, the computing module 603 is further
It is configured to：
The subformula, which is parsed, using regular expression obtains the operation relation of the subformula and the ginseng of the subformula
Number.
The data base manipulation statement of operation can be carried out according to the operation relation and parameter generation, it can be into described in execution
The data base manipulation statement of row operation, to obtain the result data of the subformula.
In the present embodiment, the subformula is the subformula that Formula Solution is precipitated to minimum unit, i.e., can not further solve
Analyse formula, alternatively referred to as simple formula.
In the present embodiment, SQL statement is generated according to the operation relation and the parameter, in the database into performing acquisition
SQL statement, you can obtain the result data of the subformula.
For example, subformula 03：The price of the sales volume of the gross sales amount of B products=B products × B products；SQL languages can be used
Sentence：Select (B product sales volume * B product prices) obtains the gross sales amount of B products." B products " is number in the SQL statement
According to the table name in library, " sales volume " " price " is respectively the field name in table.
The present embodiment generates data base manipulation statement, and pass through execution number according to the operation relation of formula and the parameter of formula
The result data of subformula is obtained according to library action statement, the present embodiment is given the arithmetic operation of formula to database processing, can be dropped
The operand of the server of low formula manipulation, so as to improve the efficiency of formula manipulation.
It is another in the application in the specific implementation, described device includes referring to Fig. 9：
Enquiry module 901 is configured to parse formula, obtains the corresponding subformula of the formula, and in the buffer
Inquiry is with the presence or absence of the corresponding result data of the subformula；
Cache module 902 is configured to obtain the corresponding result data of the subformula from caching, to calculate the formula
Corresponding result data；
Computing module 903 is configured to obtain the operation relation of the subformula and the parameter of the subformula, according to described
Operation relation and the parameter determine the result data of the subformula, to calculate the corresponding result data of the formula.
In the present embodiment, cache module 902 is further configured to the corresponding knot of the subformula and the subformula
In the storage to the caching of fruit data.
In the present embodiment, this module is obtained in the result data storage to the caching of subformula, so that it is guaranteed that per height
Formula only carries out once-through operation, when reusing the subformula, need to only inquire and obtain from caching.
Report generation module 904 is configured to according to the formula and the corresponding result data generation statement form of the formula
Data.
Specifically, in the present embodiment, the statement form can be Excel forms.This module can be by formula and formula
Corresponding result data is written in a certain cell specified of Excel tables, so as to reduce the operation bidirectional of user, is improved
The convenience of the embodiment of the present application.
In the implementation of the present invention, inventor also found, the data in report generally can be divided into current-period data and go through
History data, for example, current-period data can be of that month data, historical data then refers to the data in month before this month.It is wherein current
Data are usually meeting real-time change, and historical data will not then change.Also, the data volume of historical data is bigger,
More time can be consumed in the inquiry of database.Based on this phenomenon, embodiments herein is done at following optimization
Reason.
It is another in the application in the specific implementation, on the basis of above-described embodiment, can make the application real by following methods
It is more stable, more efficient to apply example.
Two kinds of tables are created according to the time of business datum in the database, a kind of table is current-period data table, is set as depositing
Current-period data is stored up, another table is historical data table, is set as store historical data.
In the present embodiment, timed task can be set in the database, current-period data is deposited into historical data table.Example
Such as, sometime node is set, of that month or the same day data are deposited into historical data table.In the present embodiment, timed task
It can also carry out and the data in historical data table are read into caching.It, can be directly from caching when formula carries out calculation process
Obtain the corresponding result data of the formula.
The present embodiment common inquiry also in data creates a variety of indexes, such as to tissue, report, year, period etc.
Field establishes index, so as to improve the efficiency of database manipulation.
The present embodiment pre-processes the data in database, caching, before formula carries out calculation process so as to carry
High formula carries out efficiency during calculation process, reduces the time that formula carries out calculation process, enhances user experience.
Figure 10 is the hardware architecture diagram of some electronic equipments of the method that the application performs formula manipulation.According to Figure 10
Shown, which includes：
One or more processors 1001 and memory 1002, in Figure 10 by taking a processor 1001 as an example.
The equipment for performing the method for formula manipulation can also include：Input unit 1003 and output device 1003.
Processor 1001, memory 1002, input unit 1003 and output device 1004 can by bus or other
Mode connects, in Figure 10 for being connected by bus.
Memory 1002 is used as a kind of non-volatile computer readable storage medium storing program for executing, available for storing non-volatile software journey
Sequence, non-volatile computer executable program and module, such as the corresponding journey of the method for the formula manipulation in the embodiment of the present application
Sequence instruction/module.Processor 1001 is stored in non-volatile software program, instruction and mould in memory 1002 by operation
Block, various function application and data processing so as to execute server realize formula manipulation in above method embodiment
Method.
Memory 1002 can include storing program area and storage data field, wherein, storing program area can store operation system
System, the required application program of at least one function；Storage data field can be stored to be created according to using for formula manipulation device
Data etc..In addition, memory 1002 can include high-speed random access memory 1002, non-volatile memories can also be included
Device 1002, for example, at least a magnetic disk storage 1002, flush memory device or other non-volatile solid state memories 1002.
In some embodiments, memory 1002 is optional including relative to the remotely located memory 1002 of processor 1001, these are remote
Journey memory 1002 can pass through the device of network connection to formula manipulation.The example of above-mentioned network includes but not limited to interconnect
Net, intranet, LAN, mobile radio communication and combinations thereof.
Input unit 1003 can receive the number of input or the user of character information and the device of generation and formula manipulation
Setting and function control it is related key signals input.Input unit 1003 may include pressing the equipment such as module.
One or more of modules are stored in the memory 1002, when by one or more of processors
1001 when performing, the method that performs the formula manipulation in above-mentioned any means embodiment.
The said goods can perform the method that the embodiment of the present application is provided, and has the corresponding function module of execution method and has
Beneficial effect.The not technical detail of detailed description in the present embodiment, reference can be made to the method that the embodiment of the present application is provided.
The electronic equipment of the embodiment of the present application exists in a variety of forms, including but not limited to:
(1) mobile communication equipment:The characteristics of this kind equipment is that have mobile communication function, and to provide speech, data
It communicates as main target.This Terminal Type includes:Smart mobile phone (such as iPhone), multimedia handset, functional mobile phone and low
Hold mobile phone etc..
(2) super mobile personal computer equipment:This kind equipment belongs to the scope of personal computer, there is calculating and processing work(
Can, generally also have mobile Internet access characteristic.This Terminal Type includes:PDA, MID and UMPC equipment etc., such as iPad.
(3) portable entertainment device:This kind equipment can show and play multimedia content.The kind equipment includes:Audio,
Video player (such as iPod), handheld device, e-book and intelligent toy and portable car-mounted navigation equipment.
(4) server:The equipment for providing the service of calculating, the composition of server include processor 1001, hard disk, memory, are
Bus of uniting etc., server is similar with general computer architecture, but due to needing to provide highly reliable service, is handling
Ability, stability, reliability, safety, scalability, manageability etc. are more demanding.
(5) other have the function of the electronic device of data interaction.
The apparatus embodiments described above are merely exemplary, wherein the module illustrated as separating component can
To be or may not be physically separate, the component shown as module may or may not be physics mould
Block, you can be located at a place or can also be distributed on multiple network modules.It can be selected according to the actual needs
In some or all of module realize the purpose of this embodiment scheme.Those of ordinary skill in the art are not paying creativeness
Labour in the case of, you can to understand and implement.
Through the above description of the embodiments, those skilled in the art can be understood that each embodiment can
It is realized by the mode of software plus required general hardware platform, naturally it is also possible to pass through hardware.Based on such understanding, on
Technical solution is stated substantially in other words to embody the part that the prior art contributes in the form of software product, it should
Computer software product can store in a computer-readable storage medium, the computer readable recording medium storing program for performing include for
The readable form storage of computer (such as computer) or any mechanism of transmission information.For example, machine readable media is included only
Read memory (ROM), random access memory (RAM), magnetic disk storage medium, optical storage media, flash medium, electricity, light,
Sound or the transmitting signal of other forms (for example, carrier wave, infrared signal, digital signal etc.) etc., which includes
Some instructions are used so that computer equipment (can be personal computer, server or the network equipment etc.) perform it is each
Method described in certain parts of a embodiment or embodiment.
Finally it should be noted that：Above example is only to illustrate the technical solution of the embodiment of the present application rather than it is limited
System；Although the application is described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that：Its
Still it can modify to the technical solution recorded in foregoing embodiments or which part technical characteristic is equal
It replaces；And these modifications or replacement, each embodiment technical solution of the application that it does not separate the essence of the corresponding technical solution
Spirit and scope.
Claims (12)
- A kind of 1. method of formula manipulation, which is characterized in that including：Formula is parsed, obtains the corresponding subformula of the formula, and inquiry whether there is the subformula in the buffer Corresponding result data；If so, the corresponding result data of the subformula is then obtained from caching, to calculate the corresponding result data of the formula；Otherwise, the operation relation of the subformula and the parameter of the subformula are obtained, according to the operation relation and the ginseng Number determines the result data of the subformula, to calculate the corresponding result data of the formula.
- 2. according to the method described in claim 1, it is characterized in that, described parse formula, obtain the formula and correspond to Subformula, and in the buffer inquiry include with the presence or absence of the corresponding result data of the subformula：Formula is parsed, obtains the priority of the corresponding subformula of the formula and the subformula；The sequence of the subformula is determined according to the corresponding priority of the subformula, with the sequence according to the subformula slow Middle inquiry is deposited with the presence or absence of the corresponding result data of the subformula.
- 3. according to the method described in claim 1, it is characterized in that, the operation relation for obtaining the subformula and the son The parameter of formula determines that the result data of the subformula includes according to the operation relation and the parameter：The subformula, which is parsed, using regular expression obtains the operation relation of the subformula and the parameter of the subformula；The corresponding concrete numerical value of the parameter is inquired in the database, and the corresponding concrete numerical value of the parameter is substituted into the operation Relationship carries out arithmetic operation, obtains the result data of the subformula.
- 4. according to the method described in claim 1, it is characterized in that, described determine institute according to the operation relation and the parameter The result data for stating subformula includes：The data base manipulation statement of operation can be carried out according to the operation relation and parameter generation；The data base manipulation statement of operation can be carried out described in execution, to obtain the result data of the subformula.
- 5. according to the method described in claim 1, it is characterized in that, the operation relation for obtaining the subformula and the son The parameter of formula determines the result data of the subformula according to the operation relation and the parameter, to calculate the formula It is further included after corresponding result data：It will be in the corresponding result data storage to the caching of the subformula and the subformula.
- 6. according to the method described in claim 1, it is characterized in that, described calculate the corresponding result data of the formula later also Including：According to the formula and the corresponding result data generation statement form data of the formula.
- 7. a kind of device of formula manipulation, which is characterized in that including：Enquiry module is configured to parse formula, obtains the corresponding subformula of the formula, and inquire in the buffer whether There are the corresponding result datas of the subformula；Cache module is configured to obtain the corresponding result data of the subformula from caching, corresponding to calculate the formula Result data；Computing module is configured to obtain the operation relation of the subformula and the parameter of the subformula, is closed according to the operation System and the parameter determine the result data of the subformula, to calculate the corresponding result data of the formula.
- 8. device according to claim 7, which is characterized in that the enquiry module includes：Priority obtaining unit is configured to parse formula, obtains the corresponding subformula of the formula and the subformula Priority；Order determination unit is configured to determine the sequence of the subformula according to the corresponding priority of the subformula, with basis The sequence of the subformula inquires result data corresponding with the presence or absence of the subformula in the buffer.
- 9. device according to claim 7, which is characterized in that the computing module includes：Resolution unit is configured so that regular expression parses the subformula and obtains the operation relation of the subformula and described The parameter of subformula；Computing unit is configured to inquire the corresponding concrete numerical value of the parameter in the database, and the parameter is corresponding specific Numerical value substitutes into the operation relation and carries out arithmetic operation, obtains the result data of the subformula.
- 10. device according to claim 7, which is characterized in that the computing module is further configured to：The data base manipulation statement of operation can be carried out according to the operation relation and parameter generation；The data base manipulation statement of operation can be carried out described in execution, to obtain the result data of the subformula.
- 11. device according to claim 7, which is characterized in that cache module is further configured to：It will be in the corresponding result data storage to the caching of the subformula and the subformula.
- 12. device according to claim 7, which is characterized in that further include：Report generation module is configured to according to the formula and the corresponding result data generation statement form data of the formula.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611261774.5A CN108268437A (en) | 2016-12-30 | 2016-12-30 | The method and device of formula manipulation |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611261774.5A CN108268437A (en) | 2016-12-30 | 2016-12-30 | The method and device of formula manipulation |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108268437A true CN108268437A (en) | 2018-07-10 |
Family
ID=62754994
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611261774.5A Pending CN108268437A (en) | 2016-12-30 | 2016-12-30 | The method and device of formula manipulation |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108268437A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109189385A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Algorithm configuration method, apparatus, computer equipment and storage medium |
| CN110765151A (en) * | 2018-07-27 | 2020-02-07 | 北京国双科技有限公司 | Calculation formula processing method and device |
| CN110941634A (en) * | 2019-11-27 | 2020-03-31 | 北京明略软件***有限公司 | Data processing method and device, storage medium and electronic device |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101055569A (en) * | 2007-05-25 | 2007-10-17 | 金蝶软件（中国）有限公司 | Function collection method and device of electronic data table |
| CN102043758A (en) * | 2010-12-30 | 2011-05-04 | 畅捷通软件有限公司 | Method and device for automatically counting numerical values |
| CN102446164A (en) * | 2010-10-12 | 2012-05-09 | 金蝶软件（中国）有限公司 | Analytic method, device and operation system of report formula |
| CN103164393A (en) * | 2013-04-12 | 2013-06-19 | 中国农业银行股份有限公司 | Method and system of report formula processing |
| CN105630756A (en) * | 2014-10-31 | 2016-06-01 | 国际商业机器公司 | Data processing device and method |
-
2016
- 2016-12-30 CN CN201611261774.5A patent/CN108268437A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101055569A (en) * | 2007-05-25 | 2007-10-17 | 金蝶软件（中国）有限公司 | Function collection method and device of electronic data table |
| CN102446164A (en) * | 2010-10-12 | 2012-05-09 | 金蝶软件（中国）有限公司 | Analytic method, device and operation system of report formula |
| CN102043758A (en) * | 2010-12-30 | 2011-05-04 | 畅捷通软件有限公司 | Method and device for automatically counting numerical values |
| CN103164393A (en) * | 2013-04-12 | 2013-06-19 | 中国农业银行股份有限公司 | Method and system of report formula processing |
| CN105630756A (en) * | 2014-10-31 | 2016-06-01 | 国际商业机器公司 | Data processing device and method |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110765151A (en) * | 2018-07-27 | 2020-02-07 | 北京国双科技有限公司 | Calculation formula processing method and device |
| CN109189385A (en) * | 2018-08-14 | 2019-01-11 | 中国平安人寿保险股份有限公司 | Algorithm configuration method, apparatus, computer equipment and storage medium |
| CN110941634A (en) * | 2019-11-27 | 2020-03-31 | 北京明略软件***有限公司 | Data processing method and device, storage medium and electronic device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP2021534493A (en) | Techniques for building knowledge graphs within a limited knowledge domain | |
| CN109299458A (en) | Entity recognition method, device, equipment and storage medium | |
| US10325232B2 (en) | Allocating heritage information in data models | |
| EP2779056A1 (en) | Automated business system generation | |
| CN109582289B (en) | Method, system, storage medium and processor for processing rule flow in rule engine | |
| CN110134705A (en) | A kind of data query method, cache server and terminal | |
| CN108572963A (en) | Information acquisition method and device | |
| CN110162292A (en) | Voice broadcast method and device | |
| CN111177541B (en) | Data analysis method and device based on user tag generation time | |
| CN107239536A (en) | Business datum querying method, device, system, storage medium and electronic equipment | |
| CN108268437A (en) | The method and device of formula manipulation | |
| CN104102670A (en) | Performance indicator analytical framework | |
| MX2015004635A (en) | Techniques to present event information using an event timing visualization. | |
| CN105791080B (en) | Group sending message processing method and system, electronic equipment | |
| EP3472721A1 (en) | Systems and methods for building conversational understanding systems | |
| CN108446370A (en) | Voice data statistical method and system | |
| CN106227597A (en) | Task priority treating method and apparatus | |
| CN109299913A (en) | Employee's wages scheme generation method and device | |
| CN109697211A (en) | The processing method and system, computer readable storage medium of crosstab export data | |
| CN111522840B (en) | Label configuration method, device, equipment and computer readable storage medium | |
| CN116992092A (en) | Method and device for establishing flow model, storage medium and terminal equipment | |
| US9159052B2 (en) | Generalizing formats of business data queries and results | |
| Su et al. | Analysis decision-making system for aquaculture water quality based on deep learning | |
| CN108021589A (en) | The collocation method and device of the inquiry dimension of database | |
| CN109753708A (en) | A kind of payment amount prediction technique, device and readable storage medium storing program for executing |
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: 20180710 |