CN101576979A - Method and device for ensuring data consistency in budgeting process - Google Patents
Method and device for ensuring data consistency in budgeting process Download PDFInfo
- Publication number
- CN101576979A CN101576979A CNA2009100870314A CN200910087031A CN101576979A CN 101576979 A CN101576979 A CN 101576979A CN A2009100870314 A CNA2009100870314 A CN A2009100870314A CN 200910087031 A CN200910087031 A CN 200910087031A CN 101576979 A CN101576979 A CN 101576979A
- Authority
- CN
- China
- Prior art keywords
- cell
- operation rule
- budget
- navigation
- budget table
- 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 discloses a method and a device for ensuring data consistency in a budgeting process. The method comprises the steps of: selecting an operational rule for all cells in all budget sheets; by implementing the operational rule selected for the cells, determining a navigation relationship among the budget sheets and a navigation relationship among the cells; and according to the navigation relationship among the budget sheets and the navigation relationship among the cells, implementing the operational rule selected for the cells and obtaining budget values of the cells in the budget sheets. The device and the method can ensure all the budget data to conform to the operational rule and ensure the consistency of the data.
Description
Technical field
The present invention relates to computer technology, particularly relate to a kind of method and apparatus that guarantees data consistency in the budgeting process.
Background technology
Budget management is meant that enterprise is under the guidance of strategic objective, business activities and corresponding financial result to future are carried out fully, comprehensively predict and are prepared, the compilation process that passes budgets is made corresponding budget compilation data, and by monitoring to implementation, with actual performance and constantly contrast and the analysis of budget compilation data, thereby the improvement and the adjustment of directing operational activities in time is to help supvr's management enterprise and farthest realize strategic objective more effectively.
In budgeting process, need the typing budget data, and have various incidence relations between the budget data.At present, budget data is normally organized by various budget tables, and the incidence relation between the budget data is to embody by various operation rules.Such as, comprise in the budget data that the A of enterprise was clerical cost in 2008, comprise various office appliance acquisition expenses in the clerical cost, trip expenses, projects such as house rent, so, in budgeting process, can set up one about the budget table Q001 of the A of enterprise clerical cost in 2008, use different cells to represent different clerical cost projects among this budget table Q001, wherein, the operation rule of various office appliance acquisition expenses projects can be 80% of this expense of previous year among the budget table Q001, and the transportation rule of house rent project can be for equaling these rental expenses of previous year.
At present, budgeting process is often at large enterprise or large corporation, the data volume of budget compilation is very big, incidence relation between the budget data is also very complicated, therefore, the quantity of corresponding budget table is also very many, operation rule between the cell is also very complicated, such as, the budget data value of cell 1 may need to use simultaneously the budget data value of other a plurality of cells in this budget table to calculate in budget table, and the budget data of cell 2 may need to use the budget data value of a cell in another budget table to calculate in this budget table.In addition, in budgeting process, the operation rule of the cell of a budget table may be worked out and revise in the different time by different users, and so, the change of this cell operation rule then may cause the operation rule of other cells of its association mistake to occur.
By above description as can be seen, in budgeting process, must carry out the overall situation to the establishment of the budget data of cell in the budget table considers, such as in order to guarantee that all data can both correctly be worked out and avoid endless loop, rule that should adopt between each cell and order of operation etc., order of operation between each budget table etc., thus make all budget datas can both meet all operation rules, guarantee the consistance of data.
Yet, the present method that does not also have a kind of effective assurance data consistency.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of method and apparatus that guarantees data consistency in budgeting process, meets all operation rules so that guarantee all budget datas, guarantees the consistance of data.
In order to achieve the above object, the technological means of the present invention's employing comprises:
A kind of method that in budgeting process, guarantees data consistency, this method comprises:
A, be that each cell in each budget table is selected operation rule;
B, by being implemented as the operation rule that each cell is selected, determine the navigation relation of each budget table and the navigation relation of each cell;
C, according to the navigation relation of the navigation of each budget table relation and each cell, be implemented as the operation rule that each cell is selected, obtain the budget data value of each cell in each budget table.
Wherein, described steps A comprises: for the cell that is provided with multiple operation rule, select one according to predefined selection strategy from this multiple operation rule.
Optionally, described predefined selection strategy comprises:
The operation rule that preferential selection uses the budget data value of other cells in the same budget table to calculate;
Perhaps,
The operation rule that preferential selection uses the budget data value of cell in the different budget tables to calculate;
Perhaps,
Preferential select except that gather with the decomposition operation rule an operation rule.
Optionally, in step B, be implemented as the operation rule that each cell is selected with random order.
Wherein, described step B comprises:
When being implemented as the operation rule of each cell selection, the budget table at other cell places that relate in the operation rule with the current cell carried out is as the leading budget table of current cell place budget table, and other cells that relate in the operation rule with the current cell carried out are as the pilot unit lattice of current cell; Obtain navigation relation between each budget table according to the leading budget table of each budget table, this navigation concerns the execution sequence information that has comprised between each budget table; Obtain navigation relation between each cell according to the pilot unit lattice of each cell, this navigation concerns the execution sequence information that has comprised between each cell.
Preferable, the step that described leading budget table according to each budget table obtains the navigation relation between each budget table comprises: the information of the leading budget table of all budget tables is gathered, draw the leading topological diagram that concerns between all overall budget tables, this leading topological diagram that concerns is carried out degree of depth traversal, obtain the navigation relation between each budget table;
The step that described pilot unit lattice according to each cell obtain the navigation relation between each cell comprises: the information of the pilot unit lattice of all cells is gathered, draw the leading topological diagram that concerns between all overall cells, this leading topological diagram that concerns is carried out degree of depth traversal, obtain the navigation relation between each cell.
Preferable, in step C, the described step that is implemented as the operation rule of each cell selection comprises:
According to the navigation relation of each budget table and the navigation relation of each cell, the operation rule that Simulation execution is selected for each cell upgrades the navigation relation of budget table and the navigation relation of each cell according to the Simulation execution result; Then according to the navigation relation of each budget table after upgrading and the navigation relation of each cell, the actual operation rule that is implemented as each cell selection.
Optionally, the described step of upgrading the navigation relation of the navigation relation of budget table and each cell according to the Simulation execution result comprises:
In the Simulation execution process, if be that the operation rule that a cell is selected can't be carried out, then select operation rule for this cell again, and upgrade the navigation relation of budget table and the navigation relation of each cell according to the operation rule of reselecting;
And/or,
In the Simulation execution process, if carry out out endless loop, then delete the operation rule of a cell in these a plurality of cells, and upgrade the navigation relation of budget table and the navigation relation of each cell according to the operation rule of selecting respectively for a plurality of cells.
A kind of device that in budgeting process, guarantees data consistency, this device comprises:
The operation rule selected cell is used to each cell in each budget table to select operation rule;
Navigation concerns determining unit, is used for by carrying out the operation rule that the operation rule selected cell is selected for each cell, determines the navigation relation of each budget table and the navigation relation of each cell;
The budget data computing unit is used for concerning the navigation relation of each budget table that determining unit is determined and the navigation relation of each cell according to navigation, is implemented as the operation rule that each cell is selected, and obtains the budget data value of each cell in each budget table.
Wherein, described operation rule selected cell is further used for preserving predefined selection strategy, for the cell that has multiple operation rule, selects an operation rule for this cell according to the selection strategy of preserving from this multiple operation rule.
Optionally, described navigation concerns determining unit, carries out the operation rule that described operation rule selected cell is selected for each cell with random order.
Wherein, described navigation concerns determining unit, when carrying out described operation rule selected cell for the operation rule of each cell selection, the budget table at other cell places that relate in the operation rule with the current cell carried out is as the leading budget table of current cell place budget table, and other cells that relate in the operation rule with the current cell carried out are as the pilot unit lattice of current cell; Obtain navigation relation between each budget table according to the leading budget table of each budget table, this navigation concerns the execution sequence information that has comprised between each budget table; Obtain navigation relation between each cell according to the pilot unit lattice of each cell, this navigation concerns the execution sequence information that has comprised between each cell.
Preferable, described budget data computing unit, according to the navigation relation of each budget table and the navigation relation of each cell, the operation rule that Simulation execution is selected for each cell upgrades the navigation relation of budget table and the navigation relation of each cell according to the Simulation execution result; Then according to the navigation relation of each budget table after upgrading and the navigation relation of each cell, the actual operation rule that is implemented as each cell selection.
This shows that the present invention has following beneficial effect:
1, in the present invention, because before the computation budget data value, can select operation rule for each cell, the shortcoming that causes budget data value contradiction when having avoided in the prior art cell according to multiple operation rule computation budget data value, guaranteed data consistency, and, navigation concerns due sequencing between the operation rule that has reflected each cell in each budget table objectively among the present invention, concern that according to navigation the computation budget data value can guarantee that then all budget datas meet all operation rules, guarantee the consistance of data.
2, in the present invention, according to predefined selection strategy is that cell with multiple operation rule is when selecting an actual operation rule that uses, can set selection strategy neatly according to client's actual business requirement, further increase the dirigibility that the present invention realizes.
3, in the present invention, after determining the navigation relation, the operation rule that can at first concern each cell of Simulation execution according to navigation, can find various mistakes by this Simulation execution process, such as, be that the operation rule that a cell is selected can't be carried out, the operation rule of a plurality of cells finally forms endless loop etc., thereby can in time upgrade the navigation relation of all operation rules of assurance and data correct execution according to the Simulation execution process, when concerning that according to the navigation after upgrading actual computation goes out the budget data value of each cell then, then avoided the defective of various data and operation rule, guaranteed that further all budget datas meet all operation rules, have guaranteed the consistance of data.
Description of drawings
Fig. 1 is the process flow diagram that guarantees data consistency in a preferred embodiment of the present invention;
Fig. 2 is the synoptic diagram of the leading budget table of each budget table in one embodiment of the invention;
Fig. 3 is the topological relation synoptic diagram of each budget table in one embodiment of the invention;
Fig. 4 is that the navigation between each budget table in one embodiment of the invention concerns synoptic diagram;
Fig. 5 is the synoptic diagram of the leading budget table of each cell in one embodiment of the invention;
Fig. 6 is the topological relation synoptic diagram of each cell in one embodiment of the invention;
Fig. 7 is that the navigation between each cell concerns synoptic diagram in one embodiment of the invention;
Fig. 8 is the synoptic diagram that endless loop appears in the relation of the navigation between a plurality of cells in one embodiment of the invention;
Fig. 9 is that the navigation after the renewal between a plurality of cells concerns synoptic diagram in one embodiment of the invention;
Figure 10 is the basic structure synoptic diagram of the device that proposes of the present invention.
Embodiment
The present invention proposes a kind of method that guarantees data consistency in budgeting process, the core concept of this method is: for each cell in each budget table is selected operation rule; By being implemented as the operation rule that each cell is selected, determine the navigation relation of each budget table and the navigation relation of each cell; According to the navigation relation of each budget table and the navigation relation of each cell, be implemented as the operation rule that each cell is selected, obtain the budget data value of each cell in each budget table.
As seen, among the present invention because before the computation budget data value, can select an operation rule for each cell, the shortcoming that causes budget data value contradiction when having avoided in the prior art cell according to multiple operation rule computation budget data value, guaranteed data consistency, and, navigation concerns due sequencing between the operation rule that has reflected each cell in each budget table objectively among the present invention, concern that according to navigation the computation budget data value can guarantee that then all budget datas meet all operation rules, guarantee the consistance of data.
For making the purpose, technical solutions and advantages of the present invention clearer, the present invention is described in further detail below in conjunction with drawings and the specific embodiments.
Fig. 1 is the process flow diagram that guarantees data consistency in a preferred embodiment of the present invention.Referring to Fig. 1, in a preferred embodiment of the present invention, guarantee that in budgeting process the process of data consistency specifically may further comprise the steps:
Step 101: for each cell in each budget table is selected an operation rule.
In this step, need select an operation rule for each cell, during follow-up operation rule computation budget data value according to this selection, only there is a budget data value in a cell, thereby when having avoided in the prior art existing on the cell multiple operation rule, calculate different budget data values according to multiple operation rule, make data the shortcoming of contradiction occur.
In this step, if only be provided with an operation rule on any one cell in the budget table, so, then directly select this operation rule for this cell.
If any one cell in the budget table is provided with multiple operation rule, so, then can from this multiple operation rule, select an operation rule according to predefined selection strategy for this cell.
Wherein, selection strategy can be provided with according to the service needed of self reality neatly by the user, and selection strategy can be exemplified as any one in following:
1, formula priority principle in the list, that is, and the operation rule that preferential selection uses the budget data value of other cells in the same budget table to calculate.
Such as, comprise two cell CellQ1 among the budget table Q, CellQ3, include a cell CellJ1 among another budget table J, cell CellQ1 is provided with two operation rules, operation rule 1 is CellQ1=CellQ3*5 (being to use the budget data value of other cells in the same budget table to calculate in the operation rule 1), operation rule 2 is cell CellQ1=CellJ1+10 (being to use the budget data value of other cells in the different budget tables to calculate in the operation rule 2), so, according to formula priority principle in the predefined list, the operation rule of selecting for the cell CellQ1 among the budget table Q is an operation rule 1.
2, formula priority principle between list, the operation rule that preferential selection uses the budget data value of cell in the different budget tables to calculate.
Such as, for the example of above-mentioned CellQ1, according to formula priority principle between predefined list, the operation rule of selecting for the cell CellQ1 among the budget table Q is an operation rule 2.
3, preferential select except that gather with the decomposition operation rule an operation rule.
Gathering operation rule is meant, the budget data value of cell in the budget data value of the cell in the budget table and other budget tables is gathered, if the budget data value of personnel's wage cell of the budget data value of personnel's wage cell of the A of subsidiary company and the B of subsidiary company is gathered; The decomposition operation rule is the anti-rule that gathers operation rule.Owing to gather and the decomposition rule rule of last execution normally, can can not influence the budget data value of cell own be calculated, therefore, for the cell that is provided with multiple operation rule, can preferentially select except that gather with the decomposition operation rule an operation rule.
Step 102: be implemented as the operation rule that each cell in each budget table is selected with random order.
Such as, the operation rule of selecting for the cell CellQ1 among the budget table Q is CellQ1=CellQ3*5, the operation rule of selecting for the cell CellJ1 among the budget table J is CellJ1=CellQ7+10, so, then can be according to the operation rule of any sequencing difference performance element lattice CellQ1 and cell CellJ1.
Need to prove, in this step, also can according to the order of other settings (such as, according to the number order of each cell in the size order of the table number of each budget table and the budget table) be implemented as the operation rule that each cell in each budget table is selected.
Step 103: when being implemented as the operation rule that each cell selects, the budget table at other cell places that relate in the operation rule with the current cell carried out is as the leading budget table of current cell place budget table.
Such as, when the operation rule CellJ1=CellQ7+10 of the cell CellJ1 among the J is shown in the performance of budget, wherein, the budget table at CellQ7 place is budget table Q, so, in this step, then with the budget table Q at CellQ7 place leading budget table as the budget table J at current cell CellJ1 place, that is, budget table Q is the leading budget table of budget table J.
Step 104: other cells that relate in the operation rule with the current cell carried out are as the pilot unit lattice of current cell.
Such as, when the operation rule CellJ1=CellQ7+10 of the cell CellJ1 among the J is shown in the performance of budget, with the pilot unit lattice of CellQ7 as current cell CellJ1.
Step 105: obtain navigation relation between each budget table according to the leading budget table of each budget table, this navigation concerns the execution sequence information that has comprised between each budget table.
In this step, the information of the leading budget table of all budget tables can be gathered, draw the leading topological diagram that concerns between all overall budget tables, this leading topological diagram that concerns is carried out degree of depth traversal, obtain the navigation relation between each budget table, this navigation relation is record in a variety of forms, such as sequence of calculation form etc.
Illustrate the implementation procedure of this step below.Such as, budget compilation relates to 8 budget tables, be respectively table 1 to table 8, referring to Fig. 2, after the processing procedure of step 103, gathering table 1 is respectively the leading budget table of table 2, table 3 and table 8, table 2 is respectively the leading budget table of table 5 and table 4, table 3 is leading budget tables of table 6, and table 6 is leading budget tables of table 7, and table 8 also is the leading budget table of table 7; So, according to leading relation shown in Figure 2, then can draw the leading topological diagram that concerns between all budget tables as shown in Figure 3, at last, the leading topological diagram that concerns shown in Figure 3 is carried out degree of depth traversal, then can draw the navigation relation between each budget table of sequence of calculation form as shown in Figure 4.
Step 106: obtain navigation relation between each cell according to the pilot unit lattice of each cell, this navigation concerns the execution sequence information that has comprised between each cell.
In this step, the information of the pilot unit lattice of all cells can be gathered, draw the leading topological diagram that concerns between all overall cells, this leading topological diagram that concerns is carried out degree of depth traversal, obtain the navigation relation between each cell, this navigation relation is record in a variety of forms, such as sequence of calculation form etc.
Illustrate the implementation procedure of this step below.Such as, budget compilation relates to 8 cells (describing for simplifying, is example to comprise a cell in the budget table 1 to 8 respectively) in 8 budget tables, the cell 2 in the cell 1 in the table 1, table 2, by that analogy, the cell 8 in table 8.After the processing procedure of step 104, gather the leading relation between the cell as shown in Figure 5, so, according to leading relation shown in Figure 5, then can draw the leading topological diagram that concerns between all cells as shown in Figure 6, at last, the leading topological diagram that concerns shown in Figure 6 is carried out degree of depth traversal, then can draw as shown in Figure 7 with the relation of the navigation between the cell of sequence of calculation form record.
Step 107: according to the navigation relation of each budget table and the navigation relation of each cell, the operation rule that Simulation execution is selected for each cell.
The specific implementation process of this step comprises: at first find the 1st budget table in the navigation relation of each budget table, carry out the operation rule of the 1st cell (being arranged in the 1st budget table) in the navigation relation of each cell; Next find next cell in the navigation relation of each cell according to the navigation of each budget table relation, and carry out the operation rule of this next one cell, by that analogy, until concerning according to the navigation relation of each budget table and the navigation of each cell, execute the operation rule of all cells, thereby finally obtained the budget data value of each cell in each budget table.
Step 108: upgrade the navigation relation of budget table and the navigation relation of each cell according to the Simulation execution result.
Step 107 is to the processing of step 108, the operation rule that concerns each cell of Simulation execution according to navigation, can find various budget compilation mistakes by this Simulation execution process, such as, be that the operation rule that a cell is selected can't be carried out, the operation rule of a plurality of cells finally forms endless loop etc., thereby can be in time upgrade the navigation relation that all operation rules of assurance and data can both correct execution according to the Simulation execution process, when concerning that according to the navigation after upgrading actual computation goes out the budget data value of each cell then, then avoided the defective of various data and operation rule, guaranteed that further all budget datas meet all operation rules, have guaranteed the consistance of data.
For instance, in step 107 to the Simulation execution process of step 108, be that the operation rule that a cell is selected can't be carried out, such as, the operation rule of selecting for cell CellA is CellA=(CellK+10), and cell CellK does not exist, so, this operation rule can't be carried out, and then selects operation rule for this cell again according to the disposal route of step 101, and upgrades the navigation relation of budget table and the navigation relation of each cell according to the operation rule of reselecting; For another example, carry out out endless loop according to the operation rule of selecting respectively for a plurality of cells, as shown in Figure 8, so, then delete the operation rule of a cell in these a plurality of cells, such as the budget data value that needs to use cell L in the operation rule of selecting for cell J, so, delete the transportation rule of this cell J, and the relation of the navigation between the renewal budget table, be the relation of the budget table at Delete Cells L place, and the pass of the navigation between the updating block lattice is shown in Figure 9 as the leading budget table of cell J place budget table.
Step 109: according to the navigation relation of each budget table after upgrading and the navigation relation of each cell, actually be implemented as the operation rule that each cell is selected, obtain the budget data value of each cell in each budget table.
The specific implementation process of this step comprises: at first find the 1st budget table in the navigation relation of each budget table, carry out the operation rule of the 1st cell (being arranged in the 1st budget table) in the navigation relation of each cell; Next find next cell in the navigation relation of each cell according to the navigation of each budget table relation, and carry out the operation rule of this next one cell, by that analogy, until concerning according to the navigation relation of each budget table and the navigation of each cell, execute the operation rule of all cells, thereby finally obtained the budget data value of each cell in each budget table.
For instance, such as, navigation relation between the budget table that finally obtains after the Simulation execution as shown in Figure 4, navigation relation between the cell as shown in Figure 7, so, in this step, can draw according to Fig. 4 and Fig. 7, the operation rule of the cell 1 in the execution list 1 at first calculates the budget data value of this cell 1; Then according to the navigation relation between the navigation of each budget table shown in Figure 4 relation and each cell shown in Figure 7, the operation rule of the cell 2 in the execution list 2, the budget data value of the cell 1 that positive good utilisation has calculated in this operation rule; Then according to the navigation relation between the navigation of each budget table shown in Figure 4 relation and each cell shown in Figure 7, the operation rule of the cell 4 in the execution list 4, the budget data value of the cell 2 that positive good utilisation has calculated in this operation rule; By that analogy, until the budget data value that calculates cell 8.
In addition, the invention allows for a kind of device that in budgeting process, guarantees data consistency.Referring to Figure 10, this device comprises:
The operation rule selected cell is used to each cell in each budget table to select operation rule;
Navigation concerns determining unit, is used for by carrying out the operation rule that the operation rule selected cell is selected for each cell, determines the navigation relation of each budget table and the navigation relation of each cell;
The budget data computing unit is used for concerning the navigation relation of each budget table that determining unit is determined and the navigation relation of each cell according to navigation, is implemented as the operation rule that each cell is selected, and obtains the budget data value of each cell in each budget table.
Wherein, described operation rule selected cell can be further used for preserving predefined selection strategy, for the cell that has multiple operation rule, selects an operation rule for this cell according to the selection strategy of preserving from this multiple operation rule.
When determining that navigation concern, described navigation concerns that determining unit can carry out the operation rule of described operation rule selected cell for each cell selection with random order.
A kind of specific implementation process of being determined navigation relation by apparatus of the present invention can comprise: described navigation concern that determining unit is when carrying out described operation rule selected cell for the operation rule of each cell selection, the budget table at other cell places that relate in the operation rule with the current cell carried out is as the leading budget table of current cell place budget table, and other cells that relate in the operation rule with the current cell carried out are as the pilot unit lattice of current cell; Obtain navigation relation between each budget table according to the leading budget table of each budget table, this navigation concerns the execution sequence information that has comprised between each budget table; Obtain navigation relation between each cell according to the pilot unit lattice of each cell, this navigation concerns the execution sequence information that has comprised between each cell.
In order further to avoid owing to the budget data value of a cell that exists budget compilation mistakes such as data flaw and endless loop to cause can't finally be determined, can carry out analog computation earlier by apparatus of the present invention, find the budget compilation mistake according to the analog computation process, and upgrade correct feasible navigation relation, concern that according to the navigation after upgrading actual computation goes out the budget data value of each cell by apparatus of the present invention again.Concrete implementation is: in apparatus of the present invention, described budget data computing unit is according to the navigation relation of each budget table and the navigation relation of each cell, the operation rule that Simulation execution is selected for each cell upgrades the navigation relation of budget table and the navigation relation of each cell according to the Simulation execution result; Then according to the navigation relation of each budget table after upgrading and the navigation relation of each cell, the actual operation rule that is implemented as each cell selection.
From the foregoing description, the invention belongs to the computer program invention (certainly, the present invention does not get rid of the embodiment of hardware), its essence will be presented as a computer program, it can be carried in the multiple storage medium, by above-mentioned introduction those skilled in the art know that the present invention can be a computer program it comprise some instructions, be used for allowing a hardware platform finish said method.The understanding of slave unit aspect, one can comprise an aforementioned calculation machine program product and the hardware platform that moves this computer program based on equipment of the present invention.
In a word, the above only is preferred embodiment of the present invention, and non-limiting protection scope of the present invention.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (13)
1. method that guarantees data consistency in budgeting process is characterized in that this method comprises:
A, be that each cell in each budget table is selected operation rule;
B, by being implemented as the operation rule that each cell is selected, determine the navigation relation of each budget table and the navigation relation of each cell;
C, according to the navigation relation of the navigation of each budget table relation and each cell, be implemented as the operation rule that each cell is selected, obtain the budget data value of each cell in each budget table.
2. method according to claim 1 is characterized in that, described steps A comprises: for the cell that is provided with multiple operation rule, select one according to predefined selection strategy from this multiple operation rule.
3. method according to claim 2 is characterized in that, described predefined selection strategy comprises:
The operation rule that preferential selection uses the budget data value of other cells in the same budget table to calculate;
Perhaps,
The operation rule that preferential selection uses the budget data value of cell in the different budget tables to calculate;
Perhaps,
Preferential select except that gather with the decomposition operation rule an operation rule.
4. method according to claim 1 is characterized in that, in step B, is implemented as the operation rule that each cell is selected with random order.
5. method according to claim 1 is characterized in that, described step B comprises:
When being implemented as the operation rule of each cell selection, the budget table at other cell places that relate in the operation rule with the current cell carried out is as the leading budget table of current cell place budget table, and other cells that relate in the operation rule with the current cell carried out are as the pilot unit lattice of current cell; Obtain navigation relation between each budget table according to the leading budget table of each budget table, this navigation concerns the execution sequence information that has comprised between each budget table; Obtain navigation relation between each cell according to the pilot unit lattice of each cell, this navigation concerns the execution sequence information that has comprised between each cell.
6, method according to claim 5 is characterized in that,
The step that described leading budget table according to each budget table obtains the navigation relation between each budget table comprises: the information of the leading budget table of all budget tables is gathered, draw the leading topological diagram that concerns between all overall budget tables, this leading topological diagram that concerns is carried out degree of depth traversal, obtain the navigation relation between each budget table;
The step that described pilot unit lattice according to each cell obtain the navigation relation between each cell comprises: the information of the pilot unit lattice of all cells is gathered, draw the leading topological diagram that concerns between all overall cells, this leading topological diagram that concerns is carried out degree of depth traversal, obtain the navigation relation between each cell.
7. according to any described method in the claim 1 to 6, it is characterized in that in step C, the described step that is implemented as the operation rule of each cell selection comprises:
According to the navigation relation of each budget table and the navigation relation of each cell, the operation rule that Simulation execution is selected for each cell upgrades the navigation relation of budget table and the navigation relation of each cell according to the Simulation execution result; Then according to the navigation relation of each budget table after upgrading and the navigation relation of each cell, the actual operation rule that is implemented as each cell selection.
8. method according to claim 7 is characterized in that, the described step of upgrading the navigation relation of the navigation relation of budget table and each cell according to the Simulation execution result comprises:
In the Simulation execution process, if be that the operation rule that a cell is selected can't be carried out, then select operation rule for this cell again, and upgrade the navigation relation of budget table and the navigation relation of each cell according to the operation rule of reselecting;
And/or,
In the Simulation execution process, if carry out out endless loop, then delete the operation rule of a cell in these a plurality of cells, and upgrade the navigation relation of budget table and the navigation relation of each cell according to the operation rule of selecting respectively for a plurality of cells.
9. device that guarantees data consistency in budgeting process is characterized in that this device comprises:
The operation rule selected cell is used to each cell in each budget table to select operation rule;
Navigation concerns determining unit, is used for by carrying out the operation rule that the operation rule selected cell is selected for each cell, determines the navigation relation of each budget table and the navigation relation of each cell;
The budget data computing unit is used for concerning the navigation relation of each budget table that determining unit is determined and the navigation relation of each cell according to navigation, is implemented as the operation rule that each cell is selected, and obtains the budget data value of each cell in each budget table.
10. device according to claim 9, it is characterized in that, described operation rule selected cell, be further used for preserving predefined selection strategy, for the cell that has multiple operation rule, from this multiple operation rule, select an operation rule for this cell according to the selection strategy of preserving.
11. device according to claim 9 is characterized in that, described navigation concerns determining unit, carries out the operation rule that described operation rule selected cell is selected for each cell with random order.
12, device according to claim 9, it is characterized in that, described navigation concerns determining unit, when carrying out described operation rule selected cell for the operation rule of each cell selection, the budget table at other cell places that relate in the operation rule with the current cell carried out is as the leading budget table of current cell place budget table, and other cells that relate in the operation rule with the current cell carried out are as the pilot unit lattice of current cell; Obtain navigation relation between each budget table according to the leading budget table of each budget table, this navigation concerns the execution sequence information that has comprised between each budget table; Obtain navigation relation between each cell according to the pilot unit lattice of each cell, this navigation concerns the execution sequence information that has comprised between each cell.
13, according to any described device in the claim 9 to 12, it is characterized in that, described budget data computing unit, according to the navigation relation of each budget table and the navigation relation of each cell, the operation rule that Simulation execution is selected for each cell upgrades the navigation relation of budget table and the navigation relation of each cell according to the Simulation execution result; Then according to the navigation relation of each budget table after upgrading and the navigation relation of each cell, the actual operation rule that is implemented as each cell selection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2009100870314A CN101576979A (en) | 2009-06-22 | 2009-06-22 | Method and device for ensuring data consistency in budgeting process |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2009100870314A CN101576979A (en) | 2009-06-22 | 2009-06-22 | Method and device for ensuring data consistency in budgeting process |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101576979A true CN101576979A (en) | 2009-11-11 |
Family
ID=41271912
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2009100870314A Pending CN101576979A (en) | 2009-06-22 | 2009-06-22 | Method and device for ensuring data consistency in budgeting process |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101576979A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102270226A (en) * | 2011-06-28 | 2011-12-07 | 用友软件股份有限公司 | Budget data summarization system |
| CN110134696A (en) * | 2019-05-21 | 2019-08-16 | 国网山东省电力公司 | A kind of comprehensive budget editing method, apparatus and system based on big data |
-
2009
- 2009-06-22 CN CNA2009100870314A patent/CN101576979A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102270226A (en) * | 2011-06-28 | 2011-12-07 | 用友软件股份有限公司 | Budget data summarization system |
| CN110134696A (en) * | 2019-05-21 | 2019-08-16 | 国网山东省电力公司 | A kind of comprehensive budget editing method, apparatus and system based on big data |
| CN110134696B (en) * | 2019-05-21 | 2022-05-06 | 国网山东省电力公司 | Comprehensive budget editing and reviewing method, device and system based on big data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11301136B2 (en) | Capacity forecasting based on capacity policies and transactions | |
| CA2845059C (en) | Test script generation system | |
| US20110295634A1 (en) | System and Method for Dynamic Optimal Resource Constraint Mapping in Business Process Models | |
| CN105335207A (en) | Method and apparatus for managing virtual machine instance | |
| Li et al. | Scheduling policies for the stochastic resource leveling problem | |
| US10963963B2 (en) | Rule based hierarchical configuration | |
| Ayub et al. | Dynamic management of cost contingency: Impact of KPIs and risk perception | |
| CN105074587A (en) | System development device, method, and program | |
| CN104715420A (en) | Method and device for processing electric power engineering data | |
| CN102640150A (en) | Automatic generation of a query lineage | |
| CN101576979A (en) | Method and device for ensuring data consistency in budgeting process | |
| US20200234241A1 (en) | Systems and Methods for Automated SDLC, Portfolio, Program and Project Management | |
| CN116860882A (en) | Cloud storage resource management and control method and system based on blockchain | |
| CN106779439A (en) | A kind of task distribution method and device | |
| CN105378709A (en) | Systems and methods for file management by mobile computing devices | |
| Lampasona et al. | Software quality modeling experiences at an oil company | |
| CN114860759A (en) | Data processing method, device and equipment and readable storage medium | |
| US8255881B2 (en) | System and method for calculating software certification risks | |
| CN105989434A (en) | Transaction information management method and system | |
| US20130238402A1 (en) | Personnel management systems and related methods | |
| CN104142863B (en) | Resource allocation method based on stream conservation | |
| Maruna et al. | Plan development process as a methodology for contemporary urban planning | |
| Koskinen et al. | Developing a human factors engineering process for control room upgrades | |
| Ding et al. | A Guide to Selecting Ecosystem Service Models for Decision-Making: Lessons from Sub-Saharan Africa | |
| Ahmad et al. | Maximizing Gas Production Using In-House Software-GIPS |
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: 20091111 |