CN102375802A - System and method for automatically creating calculation formula - Google Patents
System and method for automatically creating calculation formula Download PDFInfo
- Publication number
- CN102375802A CN102375802A CN2010102599495A CN201010259949A CN102375802A CN 102375802 A CN102375802 A CN 102375802A CN 2010102599495 A CN2010102599495 A CN 2010102599495A CN 201010259949 A CN201010259949 A CN 201010259949A CN 102375802 A CN102375802 A CN 102375802A
- Authority
- CN
- China
- Prior art keywords
- formula
- calculating
- expression formula
- weight
- expression
- 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
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a system for automatically creating a calculation formula. The system comprises a calculation factor storage unit, an expression formula storage unit, an expression formula weight storage unit and a calculation formula creation unit, wherein the calculation factor storage unit is used for storing calculation factor data which influences values of all service objects; the expression formula storage unit is used for storing a plurality of expression formulas; each expression formula comprises operation amount and operators; the operation amount comprises the calculation factor data; the expression formula weight storage unit is used for storing weight data corresponding to each expression formula; the calculation formula creation unit is used for generating the calculation formula for calculating the values of the service objects according to the expression formulas and the corresponding weight data; and the calculation formula is the quotient of the weighted sum and the weight sum of the expression formulas. The invention also provides a corresponding method. In the system and the method, the calculation formula can be automatically created through the expression formulas and the corresponding weight data, and different calculation formulas can be created without independent encoding.
Description
Technical field
The present invention relates to field of computer data processing, more specifically, the present invention relates to a kind of system and method for automatic establishment calculating formula.
Background technology
Usually adopt different formula to realize that promptly formula need change with the change of data conversion to the different pieces of information conversion at present.For example in graphic system, require conversion and the conversion from the view data of rgb space to yuv space of system's support from the view data of rgb space to the YIQ space; In finance or ERP system, need the statistics and analysis of various different types of data, these are handled and all need work out individual code to realize different formula calculating.
Owing to often have multiple different data conversion in a system, therefore need a large amount of different formula to realize these data conversions, and new data conversion demand of every increase, just need to increase new code and realize the corresponding calculated formula.For the data conversion demand of the heart, need the execution of interrupt routine usually and write code, recompilate then.This obviously is unfavorable for the expansion and the maintenance of system.
Summary of the invention
The technical matters that the present invention will solve is, thereby need write the problem that code is unfavorable for system extension and maintenance again during to above-mentioned newly-increased data conversion demand, provides a kind of formula self-defining system.
The technical scheme that the present invention solves the problems of the technologies described above is, a kind of system of automatic establishment calculating formula is provided, and comprises that the weight storage unit of calculating factor storage unit, expression formula storage unit, expression formula and calculating formula create the unit, wherein:
Said calculating factor storage unit, the calculating factor data that is used to store the score value that influences all business objects;
Said expression formula storage unit is used to store a plurality of expression formulas, and each expression formula includes operand and operational symbol, and wherein said operand comprises the calculating factor data;
Expression formula weight storage unit is used to store the corresponding weight data of each expression formula;
Calculating formula is created the unit, is used for generating the calculating formula that is used for computing service object score value according to expression formula and corresponding weight data, and said calculating formula is weighted sum and weight and both merchant of expression formula.
In the system of automatic establishment calculating formula of the present invention; Also comprise expression formula definition unit and weight definition unit; Said expression formula definition unit is used for creating expression formula according to input operand and operational symbol, and the expression formula of this establishment is stored in said expression formula storage unit; Said weight definition unit is used for creating the weight data and being stored in expression formula weight storage unit according to the weighted value of input.
In the system of automatic establishment calculating formula of the present invention, also comprise the expression formula verification unit, be used for the expression formula that verification expression formula definition unit created and when the expression formula verification is correct, store expression formula into said expression formula storage unit.
In the system of automatic establishment calculating formula of the present invention, also comprise calculating factor collector unit, be used to set the calculating factor of the score value that influences business object, said calculating factor is made up of essential information and score computation rule.
In the system of automatic establishment calculating formula of the present invention; Said weight data comprise that self weight and weight multiple are long-pending; Said calculating factor comprises determinative, said calculating formula create the unit comprises determinative and this expression formula in arbitrary expression formula result of calculation adjust in assign thresholds the time weight multiple of this expression formula make the weight data of this expression formula be 1 and the weight multiple of putting other all expression formulas be zero to create calculating formula.
In the system of automatic establishment calculating formula of the present invention; Said weight data comprise that self weight and weight multiple are long-pending; Said calculating factor comprises reference factor, said calculating formula create the unit comprises reference factor and this expression formula in arbitrary expression formula result of calculation adjust in assign thresholds the time weight multiple of this expression formula make the weight data of this expression formula be 0 and the weight multiple of revising other all expression formulas create calculating formula.
In the system of automatic establishment calculating formula of the present invention, said determinative has priority, and said calculating formula is created the unit and selected the determinative adjustment weight multiple of high priority to create calculating formula.
In the system of automatic establishment calculating formula of the present invention, the operand in the said expression formula also comprises constant and SQL statement.
The present invention also provides a kind of method of automatic establishment calculating formula, may further comprise the steps:
A, collection and storage influence the calculating factor data of the score value of all business objects;
B, establishment are also stored a plurality of expression formulas, and each expression formula includes operand and operational symbol, and wherein said operand comprises the calculating factor data;
C, establishment are also stored the corresponding weight data of each expression formula;
D, generate the calculating formula that is used for computing service object score value according to expression formula and corresponding weight data, said calculating formula is the weighted sum and weight and both merchants of expression formula.
In the method for automatic establishment calculating formula of the present invention; Said weight data comprise that self weight and weight multiple are long-pending; Said calculating factor comprises determinative, and said steps d comprises: the weight multiple that the result of calculation that in arbitrary expression formula, comprises determinative and this expression formula is adjusted this expression formula in assign thresholds the time make the weight data of this expression formula be 1 and the weight multiple of putting other all expression formulas be zero to create calculating formula.
The system and method for automatic establishment calculating formula of the present invention has been realized the establishment automatically of calculating formula ground through expression formula and corresponding weight data, need not independent coding and can realize the nonidentity operation formula.And the present invention has realized influencing each other between different factors through the weight data of each expression formula of weight multiple adjustment.
Description of drawings
Fig. 1 is the synoptic diagram that the present invention creates the system embodiment of calculating formula automatically;
Fig. 2 is the synoptic diagram that the present invention creates another embodiment of system of calculating formula automatically;
Fig. 3 is the process flow diagram that the present invention creates the method embodiment of calculating formula automatically.
Embodiment
The present invention has realized the establishment automatically of calculating formula ground through expression formula and corresponding weight data; Thereby when the logic that factor changes or the user calculates formula of business object has new requiring; Need not to remodify system program and can generate new operational formula, be convenient to the expansion and the maintenance of system.The part interface of program can be rewritten according to specific business object by the system of automatic establishment calculating formula of the present invention, can be integrated in the WEB application system based on J2EE, for the scalar quantization assessment of business object, the formulation of management decision provide foundation.
As shown in Figure 1, be the synoptic diagram that the present invention creates the system embodiment of calculating formula automatically.In the present embodiment, this system comprises calculating factor storage unit 11, expression formula storage unit 13, expression formula weight storage unit 14 and calculating formula establishment unit 12.Above-mentioned each unit can be by realizing based on the software of multi-purpose computer, also can be realized by the combination of hardware, software or the hardware and software of special use.
Calculating factor storage unit 11 is used to store the calculating factor data of the score value that influences all business objects.The aforementioned calculation factor data can be set according to concrete needs by the user, comprises definition essential information and score computation rule, for example calculates factor data and can comprise content and corresponding score value.This calculating factor data also can be collected by system automatically, promptly comprises all list items in the system database.
Expression formula storage unit 13 is used to store a plurality of expression formulas, and these expression formulas are set by the user as required.Each expression formula has essential informations such as title, priority, and it is specially by n (n＞=1) individual operand and n-1 the comprehensive arithmetic expression that the operational symbol series connection constitutes, for example f1 (x), f2 (x) etc.Wherein the operand in the expression formula is for constituting the base unit of expression formula; Can be concrete numerical value (constant), sql statement, be stored in calculating factor in the calculating factor storage unit 11 etc., and operational symbol can be arithmetical operation symbols such as "+", "-", " * ", " ÷ ".In above-mentioned expression formula, the priority of definable operational symbol is to confirm the computation sequence of operational symbol.
Expression formula weight storage unit 14 is used to store the corresponding weight data of each expression formula.These weight data can be set by the user as required.
Calculating formula is created unit 12, is used for generating the calculating formula that is used for computing service object score value according to expression formula and corresponding weight data, and this calculating formula is weighted sum and weight and both merchant of expression formula.For example, calculating formula establishment unit 12 can be created according to following formula:
Wherein O (e) is the calculating formula to single or a plurality of business object operations, and F (x) is an expression formula, is the important element that constitutes calculating formula, and W * M is that F (x) is the shared proportion of The whole calculations formula (being the weight data).
Through changing the weight data in the above-mentioned formula, can realize that various different business object score values calculate, and need not coding code again.
For realize a ticket under some special occasions negate with a ticket certainly, can the weight data be divided into self weight (be the W in the above-mentioned formula, this value can be set) and weight multiple (being above-mentioned M), the weight data are self weight and the weight multiple is amasss.Correspondingly; The calculating factor comprises determinative (through calculating the computation rule definition of factor), calculating formula create unit 12 comprises determinative and this expression formula in arbitrary expression formula result of calculation adjust in assign thresholds the time weight multiple of this expression formula make the weight data of this expression formula be 1 and the weight multiple of putting other all expression formulas be zero to create calculating formula.For example, the calculating factor x that comprises as f1 (x) is a determinative, and f1 (x) is 1 o'clock, and then calculating formula is created the calculating formula of creating unit 12 and is: O
(e)=f1 (x).
Especially, can be determinative priority is set, thereby calculating formula is created the determinative adjustment weight multiple establishment calculating formula that high priority is selected in unit 12, has embodied the importance of various computing factor in formula calculates.
In addition; When the calculating factor comprises reference factor, calculating formula create unit 12 comprises reference factor and this expression formula in arbitrary expression formula result of calculation adjust in assign thresholds the time weight multiple of this expression formula make the weight data of this expression formula be 0 and the weight multiple of revising other all expression formulas create calculating formula.The result of calculation of above-mentioned reference factor can not participated in the score of calculating formula and calculated, but has had influence on the actual weight of other factors in calculating formula is calculated.
As shown in Figure 2, be the synoptic diagram of another embodiment of the present invention system of creating calculating formula automatically.In the present embodiment, also comprise expression formula definition unit 28, weight definition unit 27, calculating factor collector unit 25 and expression formula verification unit 26.Above-mentioned expression formula definition unit 28, weight definition unit 27, calculate factor collector unit 25 and can obtain the data of user's input through the mode that graphical user interface is provided.
Calculating factor collector unit 25 is used to set the calculating factor of the score value that influences business object, and the calculating factor of its setting is stored in calculating factor storage unit 21; Expression formula definition unit 28 is used for creating expression formula according to the operand of input and operational symbol, and the expression formula of this establishment is stored in said expression formula storage unit 23; Weight definition unit 27 is used for creating the weight data and being stored in expression formula weight storage unit 24 according to the weighted value of input.
Expression formula verification unit 26 is used for the expression formula that verification expression formula definition unit 28 created and when the expression formula verification is correct, stores expression formula into said expression formula storage unit 23.Particularly, whether this expression formula verification unit to be used for legitimacy (value that for example whether can obtain confirming through sql statement or calculating factor), operational symbol legitimacy (operand AND operator number number whether differ 1) and the expression formula result of calculation of the definition of verification operand unusual etc.
As shown in Figure 3, be the process flow diagram that the present invention creates the method embodiment of calculating formula automatically.In the present embodiment, this method may further comprise the steps:
Step S31: the calculating factor data of collecting and storing the score value that influences all business objects.The aforementioned calculation factor data can be set according to concrete needs by the user, comprises definition essential information and score computation rule, for example calculates factor data and can comprise content and corresponding score value.
Step S32: create and store a plurality of expression formulas, these expression formulas are set by the user as required.Each expression formula can comprise essential informations such as title, priority, and it is specially by n (n＞=1) individual operand and n-1 the comprehensive arithmetic expression that the operational symbol series connection constitutes, for example f1 (x), f2 (x) etc.
Step S33: create and store the corresponding weight data of each expression formula.
Step S34: generate the calculating formula that is used for computing service object score value according to expression formula and corresponding weight data, said calculating formula is weighted sum and weight and both merchant of expression formula.Through changing the weight data, can realize that various different business object score values calculate, and need not coding code again.
For realize a ticket under some special occasions negate with a ticket certainly, can the weight data be divided into self weight (be the W in the above-mentioned formula, this value can be set) and weight multiple (being above-mentioned M), the weight data are self weight and the weight multiple is amasss.Correspondingly; The calculating factor comprises determinative (through calculating the computation rule definition of factor), calculating formula create unit 12 comprises determinative and this expression formula in arbitrary expression formula result of calculation adjust in assign thresholds the time weight multiple of this expression formula make the weight data of this expression formula be 1 and the weight multiple of putting other all expression formulas be zero to create calculating formula.
The above; Be merely the preferable embodiment of the present invention, but protection scope of the present invention is not limited thereto, any technician who is familiar with the present technique field is in the technical scope that the present invention discloses; The variation that can expect easily or replacement all should be encompassed within protection scope of the present invention.Therefore, protection scope of the present invention should be as the criterion with the protection domain of claim.
Claims (10)
1. a system of creating calculating formula automatically is characterized in that, comprises the weight storage unit and the calculating formula establishment unit of calculating factor storage unit, expression formula storage unit, expression formula, wherein:
Said calculating factor storage unit, the calculating factor data that is used to store the score value that influences all business objects;
Said expression formula storage unit is used to store a plurality of expression formulas, and each expression formula includes operand and operational symbol, and wherein said operand comprises the calculating factor data;
Expression formula weight storage unit is used to store the corresponding weight data of each expression formula;
Calculating formula is created the unit, is used for generating the calculating formula that is used for computing service object score value according to expression formula and corresponding weight data, and said calculating formula is weighted sum and weight and both merchant of expression formula.
2. the system of automatic establishment calculating formula according to claim 1; It is characterized in that; Also comprise expression formula definition unit and weight definition unit; Said expression formula definition unit is used for creating expression formula according to input operand and operational symbol, and the expression formula of this establishment is stored in said expression formula storage unit; Said weight definition unit is used for creating the weight data and being stored in expression formula weight storage unit according to the weighted value of input.
3. the system of automatic establishment calculating formula according to claim 2; It is characterized in that; Also comprise the expression formula verification unit, be used for the expression formula that verification expression formula definition unit created and when the expression formula verification is correct, store expression formula into said expression formula storage unit.
4. the system of automatic establishment calculating formula according to claim 1 is characterized in that, also comprises calculating factor collector unit, is used to set the calculating factor of the score value that influences business object, and said calculating factor is made up of essential information and score computation rule.
5. the system of automatic establishment calculating formula according to claim 1; It is characterized in that; Said weight data comprise that self weight and weight multiple are long-pending; Said calculating factor comprises determinative, said calculating formula create the unit comprises determinative and this expression formula in arbitrary expression formula result of calculation adjust in assign thresholds the time weight multiple of this expression formula make the weight data of this expression formula be 1 and the weight multiple of putting other all expression formulas be zero to create calculating formula.
6. the system of automatic establishment calculating formula according to claim 1; It is characterized in that; Said weight data comprise that self weight and weight multiple are long-pending; Said calculating factor comprises reference factor, said calculating formula create the unit comprises reference factor and this expression formula in arbitrary expression formula result of calculation adjust in assign thresholds the time weight multiple of this expression formula make the weight data of this expression formula be 0 and the weight multiple of revising other all expression formulas create calculating formula.
7. according to the system of claim 5 or 6 described automatic establishment calculating formulas, it is characterized in that said determinative has priority, said calculating formula is created the unit and is selected the determinative adjustment weight multiple of high priority to create calculating formula.
8. the system of automatic establishment calculating formula according to claim 1 is characterized in that, the operand in the said expression formula also comprises constant and SQL statement.
9. a method of creating calculating formula automatically is characterized in that, may further comprise the steps:
A, collection and storage influence the calculating factor data of the score value of all business objects;
B, establishment are also stored a plurality of expression formulas, and each expression formula includes operand and operational symbol, and wherein said operand comprises the calculating factor data;
C, establishment are also stored the corresponding weight data of each expression formula;
D, generate the calculating formula that is used for computing service object score value according to expression formula and corresponding weight data, said calculating formula is the weighted sum and weight and both merchants of expression formula.
10. the method for automatic establishment calculating formula according to claim 9; It is characterized in that; Said weight data comprise that self weight and weight multiple are long-pending; Said calculating factor comprises determinative, and said steps d comprises: the weight multiple that the result of calculation that in arbitrary expression formula, comprises determinative and this expression formula is adjusted this expression formula in assign thresholds the time make the weight data of this expression formula be 1 and the weight multiple of putting other all expression formulas be zero to create calculating formula.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102599495A CN102375802A (en) | 2010-08-23 | 2010-08-23 | System and method for automatically creating calculation formula |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010102599495A CN102375802A (en) | 2010-08-23 | 2010-08-23 | System and method for automatically creating calculation formula |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102375802A true CN102375802A (en) | 2012-03-14 |
Family
ID=45794428
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010102599495A Pending CN102375802A (en) | 2010-08-23 | 2010-08-23 | System and method for automatically creating calculation formula |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102375802A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1274128A (en) * | 1999-05-17 | 2000-11-22 | 日本电气株式会社 | Digital signal processor, filtering wave processing method and recording medium |
| JP2005353094A (en) * | 2005-07-25 | 2005-12-22 | Fujitsu Ltd | Product-sum computing unit |
| CN101187929A (en) * | 2007-12-05 | 2008-05-28 | 浪潮集团山东通用软件有限公司 | Formula definition assembly for flexible mathematical aiming at large data of database table |
-
2010
- 2010-08-23 CN CN2010102599495A patent/CN102375802A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1274128A (en) * | 1999-05-17 | 2000-11-22 | 日本电气株式会社 | Digital signal processor, filtering wave processing method and recording medium |
| JP2005353094A (en) * | 2005-07-25 | 2005-12-22 | Fujitsu Ltd | Product-sum computing unit |
| CN101187929A (en) * | 2007-12-05 | 2008-05-28 | 浪潮集团山东通用软件有限公司 | Formula definition assembly for flexible mathematical aiming at large data of database table |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP2011065626A (en) | Apparatus and method for supporting plant construction planning | |
| Zia et al. | Software cost estimation for component-based fourth-generation-language software applications | |
| Wan et al. | Multi‐level, multi‐stage lot‐sizing and scheduling in the flexible flow shop with demand information updating | |
| JP2008146105A (en) | System, method and program for evaluating power transaction | |
| CN110532534A (en) | The method and apparatus for generating engineering value document | |
| Framinan et al. | Guidelines for the deployment and implementation of manufacturing scheduling systems | |
| CN107491907A (en) | Cost for Electric Power Engineering control and analysis and system | |
| US8078599B2 (en) | Method and system for evaluating environmental impact occurring during an activity cycle | |
| Lee et al. | Stochastic project financing analysis system for construction | |
| JPWO2014129470A1 (en) | Energy management support device and energy management support program | |
| CN105653255A (en) | Method arranging report template to automatically generate report files in office frame | |
| CN111190814B (en) | Method and device for generating software test case, storage medium and terminal | |
| KR20220115357A (en) | A method and apparatus for generating future demand forecast data based on attention mechanism | |
| Wang et al. | Using value stream mapping to analyze an upholstery furniture engineering process | |
| CN111199308A (en) | Client prediction method and device for different overdue stages and electronic equipment | |
| CN103235847A (en) | Dynamic model allocating method based on matrix transformation | |
| US20120253998A1 (en) | Cost calculation device, cost calculation method, and cost calculation program | |
| JP2021077364A (en) | Project management system, project management method, and program | |
| JP2012029389A (en) | Electrical power supply-demand matching control system and electrical power supply-demand matching control method | |
| CN116049140A (en) | Data warehouse establishing method and system based on E-commerce data | |
| CN102375802A (en) | System and method for automatically creating calculation formula | |
| Li et al. | A unified model for the implementation of both CMMI and 6σ | |
| US20120066029A1 (en) | Computer system and method for determining a geographic region from which to source a resource | |
| Ding et al. | Supplier capacity analysis for a manufacturing firm with a case study | |
| Lu et al. | A new constructive cost model for software testing project management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20120314 |