CN102354316A - Data updating device and data updating method - Google Patents
Data updating device and data updating method Download PDFInfo
- Publication number
- CN102354316A CN102354316A CN2011102845085A CN201110284508A CN102354316A CN 102354316 A CN102354316 A CN 102354316A CN 2011102845085 A CN2011102845085 A CN 2011102845085A CN 201110284508 A CN201110284508 A CN 201110284508A CN 102354316 A CN102354316 A CN 102354316A
- Authority
- CN
- China
- Prior art keywords
- data
- data item
- numerical value
- item
- inquires
- 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 provides a data updating device and a data updating method. The data updating device comprises a data item query unit, an associated query unit and a data updating unit, wherein the data item query unit is used for querying data items (subjected to numerical value changes after last numerical value updating) from a plurality of data items required to be updated; the associated query unit is used for querying other data items relevant to the data items according to an application generation relation relevant to the data items; and the data updating unit is used for computing the numerical values of the other data items according to the numerical values of the data items so as to carry out numerical value updating on the other items. By using the device and method disclosed by the invention, only the data items subjected to numerical value changes are subjected to numerical value updating, thereby ensuring the speediness and high efficiency of the data updating. The technical scheme of the invention is suitable to be applied to the operations of material requirements planning.
Description
Technical field
The present invention relates to field of computer technology, in particular to a kind of data update apparatus and a kind of data-updating method.
Background technology
In data handling procedure, operation is absolutely necessary to updating data, but when data volume is bigger, upgrades operation and tend to take a large amount of resources, needs the cost great amount of time, and influences the process of other operations.
With MRP common in the ERP system is example; MRP i.e. (Material Requirement Planning; MRP) be meant subordinate and quantitative relation according to each level article of product structure; With each article is the plan object; With completion period be the time reference back scheduling; By the time in advance length difference each article assign plans sequencings of time, be plan management of materials and quipment pattern in a kind of industrial manufacturing enterprise.MRP is the production schedule according to the market demand forecast and client's order formulation product; Generate schedule based on product then; Material structure table and the Inventory Performance of forming product; Through the demand and the required time of COMPUTER CALCULATION materials needed, thereby confirm the processing progress of material and a kind of practical technique of order schedule.
In the actual production process of enterprise, the modification plan is inevitable, regular work.No matter be planned change, product structure or process variations, Purchased Item is out of stock, and workpiece is scrapped, and all can revise MPS or MRP.So need frequent computing MRP, thereby obtain up-to-date, fabrication plan and procurement plan the most accurately.
The MRP algorithm of comparative maturity has two kinds at present:
Regenerative method (regeneration).MPS is reformulated fully, again unfolding detailed material list, the priority of layout material requirement again.The new layout of laying equal stress on is deleted in the fixed capital of original plan again.
The MRP of specified scope.This kind method is specially the requirement source scope of specifying MRP; Material according to the said scope of appointment relates to launches relevant Bill of Material (BOM); According to the Bill of Material (BOM) of launching, calculate demand and required time that there emerged a material.For example the specify arithmetic scope is calculating of sales order, at first finds the material relevant with sales order, as operand, carries out MRP with these materials.Another mode is directly to select the scope of material as MRP.
The relative merits of above-mentioned two kinds of methods such as following table:
As previously mentioned, frequently change for MRP, frequent execution is also wanted in computing, and above-mentioned two kinds of methods all have certain limitation.Therefore need a kind of new data refresh mode, when for example change takes place in the material requirement data, can be more accurate, to data change, upgrade corresponding material requirement data fast.
Summary of the invention
Technical matters to be solved by this invention is, a kind of new data refresh mode is provided, when for example change takes place in the material requirement data, can be more accurate, and to data change, upgrade corresponding material requirement data fast.
In view of this, the present invention provides a kind of data update apparatus, comprising: the data item query unit from a plurality of data item that needs upgrade, inquires the data item of numerical value generation change after last time, numerical value upgraded; The correlation inquiry unit generates relation according to the use relevant with said data item, inquires other data item relevant with said data item; Data updating unit according to the numerical value of said data item, calculates the numerical value of said other data item, upgrades said other data item are carried out numerical value.Through this technical scheme, only the data item of logarithm value change is carried out the numerical value renewal, has guaranteed that Data Update rapidly and efficiently.Technical scheme of the present invention is suitable for use in the computing of MRP.
In technique scheme, preferably, said data item query unit is with the current numerical value of said a plurality of data item, and the mirror image data contrast with after numerical value renewal last time inquires said data item; Said data update apparatus also comprises: mirror image is made the unit, and the numerical value of said data item and said other data item is made as mirror image data.Through this technical scheme, can inquire effectively needs the data updated item.
In technique scheme, preferably, also comprise: the change record unit when the numerical value of said data item produces change, is recorded in said data item in the database; Said data item query unit inquires said data item from said database.Through this technical scheme, can inquire effectively needs the data updated item.
In technique scheme, preferably, also comprise: the scope control module, from said a plurality of data item, to choose one or morely as query context, the data item query unit inquires said data item in said query context.Through this technical scheme, can carry out Data Update more targetedly.
In technique scheme, preferably, the type of said data item comprises material data, and the type that said use generates relation comprises Bill of Material (BOM).
The present invention also provides a kind of data-updating method, comprising: step 202 from a plurality of data item that needs upgrade, inquires the data item of numerical value generation change after last time, numerical value upgraded; Step 204 generates relation according to the use relevant with said data item, inquires other data item relevant with said data item; Step 206 according to the numerical value of said data item, calculates the numerical value of said other data item, upgrades said other data item are carried out numerical value.Through this technical scheme, only the data item of logarithm value change is carried out the numerical value renewal, has guaranteed that Data Update rapidly and efficiently.Technical scheme of the present invention is suitable for use in the computing of MRP.
In technique scheme, preferably, said step 202 specifically comprises: with the current numerical value of said a plurality of data item, the mirror image data contrast with after numerical value renewal last time inquires said data item; Said data-updating method also comprises: the numerical value of said data item and said other data item is made as mirror image data.Through this technical scheme, can inquire effectively needs the data updated item.
In technique scheme, preferably, before said step 202, also comprise: when the numerical value of said data item produces change, said data item is recorded in the database; Said step 202 specifically comprises: from said database, inquire said data item.Through this technical scheme, can inquire effectively needs the data updated item.
In technique scheme, preferably, before said step 202, also comprise: from said a plurality of data item, choose one or more as query context; In said step 202, in said query context, inquire said data item.Through this technical scheme, can carry out Data Update more targetedly.
In technique scheme, preferably, the type of said data item comprises material data, and the type that said use generates relation comprises Bill of Material (BOM).
Through above technical scheme; Can realize a kind of data update apparatus and a kind of data-updating method; Can find out the data item that to carry out Data Update; And only the data item that finds out is upgraded operation; Rapidly and efficiently; Save time and resource, be particularly useful for the computing of MRP in the ERP system.
Description of drawings
Fig. 1 is the block diagram of data update apparatus according to an embodiment of the invention;
Fig. 2 is the process flow diagram of data-updating method according to an embodiment of the invention;
Fig. 3 is the logical schematic of MRP;
Fig. 4 is the principle schematic of data-updating method according to an embodiment of the invention;
Fig. 5 is the principle schematic of data-updating method according to an embodiment of the invention;
Fig. 6 is the workflow diagram of data-updating method according to an embodiment of the invention;
Fig. 7 is the structural representation of Bill of Material (BOM);
Fig. 8 is the workflow diagram of data-updating method according to an embodiment of the invention.
Embodiment
In order more to be expressly understood above-mentioned purpose of the present invention, feature and advantage, the present invention is further described in detail below in conjunction with accompanying drawing and embodiment.
Set forth a lot of details in the following description so that make much of the present invention, still, the present invention can also adopt other to be different from other modes described here and implement, and therefore, the present invention is not limited to the restriction of following disclosed specific embodiment.
Fig. 1 is the block diagram of data update apparatus according to an embodiment of the invention.
As shown in Figure 1, the present invention provides a kind of data update apparatus 100, comprising: data item query unit 102 from a plurality of data item that needs upgrade, inquires the data item of numerical value generation change after last time, numerical value upgraded; Correlation inquiry unit 104 generates relation according to the use relevant with said data item, inquires other data item relevant with said data item; Data updating unit 106 according to the numerical value of said data item, calculates the numerical value of said other data item, upgrades said other data item are carried out numerical value.Through this technical scheme, only the data item of logarithm value change is carried out the numerical value renewal, has guaranteed that Data Update rapidly and efficiently.Technical scheme of the present invention is suitable for use in the computing of MRP.
In technique scheme, said data item query unit 102 is with the current numerical value of said a plurality of data item, and the mirror image data contrast with after numerical value renewal last time inquires said data item; Said data update apparatus also comprises: mirror image is made unit 108, and the numerical value of said data item and said other data item is made as mirror image data.Through this technical scheme, can inquire effectively needs the data updated item.
In technique scheme, also comprise: change record unit 110 when the numerical value of said data item produces change, is recorded in said data item in the database; Said data item query unit 102 inquires said data item from said database.Through this technical scheme, can inquire effectively needs the data updated item.
In technique scheme, preferably, also comprise: scope control module 112, from said a plurality of data item, to choose one or morely as query context, the data item query unit inquires said data item in said query context.Through this technical scheme, can carry out Data Update more targetedly.
In technique scheme, the type of said data item comprises material data, and the type that said use generates relation comprises Bill of Material (BOM).
Fig. 2 is the process flow diagram of data-updating method according to an embodiment of the invention.
As shown in Figure 2, the present invention also provides a kind of data-updating method, comprising: step 202 from a plurality of data item that needs upgrade, inquires the data item of numerical value generation change after last time, numerical value upgraded; Step 204 generates relation according to the use relevant with said data item, inquires other data item relevant with said data item; Step 206 according to the numerical value of said data item, calculates the numerical value of said other data item, upgrades said other data item are carried out numerical value.Through this technical scheme, only the data item of logarithm value change is carried out the numerical value renewal, has guaranteed that Data Update rapidly and efficiently.Technical scheme of the present invention is suitable for use in the computing of MRP.
In technique scheme, said step 202 specifically comprises: with the current numerical value of said a plurality of data item, the mirror image data contrast with after numerical value renewal last time inquires said data item; Said data-updating method also comprises: the numerical value of said data item and said other data item is made as mirror image data.Through this technical scheme, can inquire effectively needs the data updated item.
In technique scheme, before said step 202, also comprise: when the numerical value of said data item produces change, said data item is recorded in the database; Said step 202 specifically comprises: from said database, inquire said data item.Through this technical scheme, can inquire effectively needs the data updated item.
Before said step 202, also comprise: from said a plurality of data item, choose one or more as query context; In said step 202, in said query context, inquire said data item.Through this technical scheme, can carry out Data Update more targetedly.
In technique scheme, the type of said data item comprises material data, and the type that said use generates relation comprises Bill of Material (BOM).
Technical scheme of the present invention is particularly useful for the computing of MRP, below will describe in detail.
MRP i.e. (Material Requirement Planning; MRP) be meant subordinate and quantitative relation according to each level article of product structure; With each article is the plan object; With completion period be the time reference back scheduling; By the time in advance length difference each article assign plans sequencings of time, be plan management of materials and quipment pattern in a kind of industrial manufacturing enterprise.MRP is the production schedule according to the market demand forecast and client's order formulation product; Generate schedule based on product then; Material structure table and the Inventory Performance of forming product; Through the demand and the required time of COMPUTER CALCULATION materials needed, thereby confirm the processing progress of material and a kind of practical technique of order schedule.
Several problems below MRP has mainly been answered: what produced? What is used? What has been there? What also lacks? When assign plans? These several problems are that manufacturing industry all must answer and problem that have ubiquity, are called " manufacturing equation ".
Fig. 3 is the logical flow chart of MRP.To carry out detailed explanation to the input data that MRP relates to below.
First association is a MPS 302, and it indicates various products and the spare part of producing a certain planned time section planted agent, and it is the most important Data Source that MRP 300 is worked out.
Second association is a product information 304, wherein especially refers to Bill of Material (BOM) (BOM, Bill of Material), and it has indicated the structural relation between the material, and the quantity of every kind of material requirement, and it is data the most basic in the MRP system.
The 3rd association is an inventory information 306, and it reflects the virtual condition of each material article purpose storage on hand with the plan quantities received.
The time in advance that the 4th association being, not shown, determining when every kind of material goes into operation, when completing.
After the computing of MRP 300 is accomplished, can be used to instruct the enforcement of procurement plan 308 and fabrication plan 310.
The principle of technical scheme of the present invention is the clean algorithm that changes, and the classification of this algorithm comprises:
1, the clean change:
During computing for the first time, all be the object that changes computing only so the material data of demand is arranged, we can carry out MRP to the material that demand is arranged.After the computing first time finished, we had only revised a part of material input data (for example: MPS, Bill of Material (BOM) or the like).When we once more during the computing MRP, we at first find out the material data that change takes place, and carry out MRP to these material datas.After changing each like this, we only need do the sub-fraction computing, reduce the scope of computing, have increased the accuracy of computing, have improved the efficient of computing.
Concrete steps are as shown in Figure 4:
Step 402 is carried out the MRP computing first time;
Step 404 is revised the input information of certain material;
Step 408 is carried out the computing of MRP according to the material that changes, if the change of material input information takes place again, then returns step 404.
2, specified scope changes only:
As shown in Figure 5, specifically comprise:
Step 502 is carried out the MRP computing first time;
Step 504 is revised the input information of certain material;
Step 508 finds the material that input changes in the specified scope;
Step 510 is carried out the computing of MRP according to the material that changes, if the change of material input information takes place again, then returns step 504.
The clean change computing of specified scope and clean change computing shown in Figure 4 are similar, under the situation of specified scope, have increased the clean judgement that changes of material, have so both comprised the specific aim and the dirigibility of specified scope, have had the accuracy of clean change again.Further dwindle operating range, improve operation efficiency.
The concrete implementation of technical scheme of the present invention below is described.
1, image method
Image method is realized the clean main thought that changes algorithm as shown in Figure 6:
Step 602 is obtained the demand data of material;
Step 608 according to material data, is launched relevant Bill of Material (BOM) data;
Step 610 is according to the demand and the required time of each material of Bill of Material (BOM) data computation that launches;
Step 612 is used as details such as new demand and required times as mirror image data and is noted, and when next computing, we will use the mirror image data of this computing to compare, and find out the material data that changes.
The applicating example of image method is following:
Bill of Material (BOM) (Bill Of Material is called for short BOM) is the vital document of MRP (MRP).Material of its detail record used all following rank material and association attributeses, that is, the subordinate relation of father's item material and all subitem materials, unit consumption and other attributes etc.
The bottom sign indicating number is used for describing material place level, the only corresponding bottom sign indicating number of material, and when a material was among the different BOM, its bottom sign indicating number was the maximal value in the hierachy number.For example: the level of a material W in a BOM is 2, and the level in another BOM is 3, and the bottom sign indicating number of this material is 3 so.
Fig. 7 has described two Bill of Material (BOM).A1, A2 are finished products, and the bottom sign indicating number is 0; B1, B2 are semi-manufacture, and the bottom sign indicating number is 1; C1, C2 are materials, and the bottom sign indicating number is 2.A finished product A1 is obtained by a semi-manufacture B1 processing, and a semi-manufacture B 1 is obtained by a starting material C1 processing; A finished product A2 is obtained by a semi-manufacture B2 processing, and a semi-manufacture B2 is obtained by a starting material C2 processing.
May 1 computing date.
The demand document:
| The demand document | Order number | Product | Quantity required | Date Required |
| Sales order | SO01 | A1 | 10 | May 10 |
| Sales order | SO02 | A2 | 10 | May 10 |
As above shown in the table, it is respectively finished product A1, A2 that two kinds of demands were arranged May 10, and their quantity required is 10.
Computing last time demand mirror image:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
Computing bottom sign indicating number is 0 layer a material, and demand is a sales order, operation result:
Planned order:
| Supply with document | Order number | Product | Planned quantity | Date Required |
| Planned order | PO01 | A1 | 10 | May 10 |
| Planned order | PO02 | A2 | 10 | May 10 |
The demand mirror image:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Sales order | SO01 | A1 | 10 | May 10 | SO01 |
| Sales order | SO02 | A2 | 10 | May 10 | SO02 |
Related needs:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Related needs | RE01 | B1 | 10 | May 10 | SO01 |
| Related needs | RE02 | B2 | 10 | May 10 | SO02 |
Computing bottom sign indicating number is 1 layer a material, and demand is a related needs, operation result, and planned order:
| Supply with document | Order number | Product | Planned quantity | Date Required |
| Planned order | PO03 | B1 | 10 | May 10 |
| Planned order | PO04 | B2 | 10 | May 10 |
The demand mirror image:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Sales order | SO01 | A1 | 10 | May 10 | SO01 |
| Sales order | SO02 | A2 | 10 | May 10 | SO02 |
| Related needs | RE01 | B1 | 10 | May 10 | SO01 |
| Related needs | RE02 | B2 | 10 | May 10 | SO02 |
Related needs:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Related needs | RE03 | C1 | 10 | May 10 | SO01 |
| Related needs | RE04 | C2 | 10 | May 10 | SO02 |
Computing bottom sign indicating number is 2 layers a material, and demand is a related needs, operation result:
Planned order:
| Supply with document | Order number | Product | Planned quantity | Date Required |
| Planned order | PO05 | C1 | 10 | May 10 |
| Planned order | PO06 | C2 | 10 | May 10 |
The demand mirror image:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Sales order | SO01 | A1 | 10 | May 10 | SO01 |
| Sales order | SO02 | A2 | 10 | May 10 | SO02 |
| Related needs | RE01 | B1 | 10 | May 10 | SO01 |
| Related needs | RE02 | B2 | 10 | May 10 | SO02 |
| Related needs | RE03 | C1 | 10 | May 10 | SO01 |
| Related needs | RE04 | C2 | 10 | May 10 | SO02 |
The sales order of May 2, modification products A 1, quantity required 10 changes 15 into, carries out computing once more.
The demand document:
| The demand document | Order number | Product | Planned quantity | Date Required |
| Sales order | SO05 | A1 | 15 | May 10 |
| Sales order | SO06 | A2 | 10 | May 10 |
The demand mirror image:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Sales order | SO01 | A1 | 10 | May 10 | SO01 |
| Sales order | SO02 | A2 | 10 | May 10 | SO02 |
| Related needs | RE01 | B1 | 10 | May 10 | SO01 |
| Related needs | RE02 | B2 | 10 | May 10 | SO02 |
| Related needs | RE03 | C1 | 10 | May 10 | SO01 |
| Related needs | RE04 | C2 | 10 | May 10 | SO02 |
Computing bottom sign indicating number is 0 layer a material, and demand is a sales order.
Through the demand mirror image contrast of this demand and last time, the document of finding out this requirement change is SO1, and material is A1, so only A1 is calculated.
Planned order:
| Supply with document | Order number | Product | Planned quantity | Date Required |
| Planned order | PO01 | A1 | 15 | May 10 |
The demand mirror image:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Sales order | SO01 | A1 | 15 | May 10 | SO01 |
| Sales order | SO02 | A2 | 10 | May 10 | SO02 |
| Related needs | RE01 | B1 | 10 | May 10 | SO01 |
| Related needs | RE02 | B2 | 10 | May 10 | SO02 |
| Related needs | RE03 | C1 | 10 | May 10 | SO01 |
| Related needs | RE04 | C2 | 10 | May 10 | SO02 |
Related needs:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Related needs | RE01 | B1 | 15 | May 10 | SO01 |
Computing bottom sign indicating number is that 1 floor and source document number are the material of SO1, and demand is a related needs, operation result:
Planned order:
| Supply with document | Order number | Product | Planned quantity | Date Required |
| Planned order | PO03 | B1 | 15 | May 10 |
The demand mirror image:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Sales order | SO01 | A1 | 15 | May 10 | SO01 |
| Sales order | SO02 | A2 | 10 | May 10 | SO02 |
| Related needs | RE01 | B1 | 15 | May 10 | SO01 |
| Related needs | RE02 | B2 | 10 | May 10 | SO02 |
| Related needs | RE03 | C1 | 10 | May 10 | SO01 |
| Related needs | RE04 | C2 | 10 | May 10 | SO02 |
Related needs:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Related needs | RE03 | C1 | 15 | May 10 | SO01 |
Computing bottom sign indicating number is that 2 floor and source document number are the material of SO1, and demand is a related needs, operation result:
Planned order:
| Supply with document | Order number | Product | Planned quantity | Date Required |
| Planned order | PO05 | C1 | 15 | May 10 |
The demand mirror image:
| The demand document | Order number | Product | Quantity required | Date Required | The source document |
| Sales order | SO01 | A1 | 15 | May 10 | SO01 |
| Sales order | SO02 | A2 | 10 | May 10 | SO02 |
| Related needs | RE01 | B1 | 15 | May 10 | SO01 |
| Related needs | RE02 | B2 | 10 | May 10 | SO02 |
| Related needs | RE03 | C1 | 15 | May 10 | SO01 |
| Related needs | RE04 | C2 | 10 | May 10 | SO02 |
2, the change record method realizes that the clean main thought that changes algorithm is that database table of design writes down the change material data takes place, and directly from table, takes out material data when changing computing and carries out the MRP computing clean.Detailed process as shown in Figure 8.
Step 802 increases, revises, when deleting demand data, the material data that changes is recorded in the change record data;
Step 804 is obtained material data from material change record data, with the object of these material datas as this computing;
Step 806 according to material data, is launched relevant Bill of Material (BOM) data;
Step 808 is according to the demand and the required time of each material of Bill of Material (BOM) data computation that launches.
Same the change record method is when demand is changed to situation illustrated in fig. 6, the material that changes is write down then material is carried out the MRP computing.Example that continue to use image method to provide after computing on May 1 finishes, changes the quantity required of finished product A1 into 15 by 10, when modification is preserved, we with amendment record in the change record table.
| The change material | Explanation |
| A1 | Quantity required becomes 15 by 10 |
During May 2 computing, from the requirement change table, obtain operand A1 and carry out computing, the demand document:
| The demand document | Order number | Product | Quantity required | Date Required |
| Sales order | SO01 | A1 | 15 | May 10 |
Computing bottom sign indicating number is 0 layer a material, and demand is a sales order, planned order:
| Supply with document | Order number | Product | Planned quantity | Date Required |
| Planned order | PO01 | A1 | 15 | May 10 |
Related needs:
| The demand document | Order number | Product | Quantity required | Date Required |
| Related needs | RE01 | B1 | 15 | May 10 |
Computing bottom sign indicating number is 1 layer a material, and demand is a related needs, planned order:
| Supply with document | Order number | Product | Planned quantity | Date Required |
| Planned order | PO03 | B1 | 15 | May 10 |
Related needs:
| The demand document | Order number | Product | Quantity required | Date Required |
| Related needs | RE03 | C1 | 15 | May 10 |
Computing bottom sign indicating number is 2 layers a material, and demand is a related needs, operation result:
Planned order:
| Supply with document | Order number | Product | Planned quantity | Date Required |
| Planned order | PO05 | C1 | 15 | May 10 |
For top example, if do not adopt clean change algorithm, we will be to material A 1, and A2 carries out the material requirement computing.And adopt the clean material A 1 that only changes that changes to carry out the MRP computing to demand, and increased the accuracy of computing, reduced unnecessary double counting, improved the operation efficiency of MRP.In practice, we often only can change the demand of a small amount of material.In this case, it is just more obvious to change the advantage of algorithm only.
In sum; Through the present invention; Can realize a kind of data update apparatus and a kind of data-updating method; Can find out the data item that to carry out Data Update; And only the data item that finds out is upgraded operation; Rapidly and efficiently, save time and resource, be particularly useful for the computing of MRP in the ERP system.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.All within spirit of the present invention and principle, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. a data update apparatus is characterized in that, comprising:
The data item query unit from a plurality of data item that needs upgrade, inquires the data item of numerical value generation change after last time, numerical value upgraded;
The correlation inquiry unit generates relation according to the use relevant with said data item, inquires other data item relevant with said data item;
Data updating unit according to the numerical value of said data item, calculates the numerical value of said other data item, upgrades said other data item are carried out numerical value.
2. data update apparatus according to claim 1 is characterized in that, said data item query unit is with the current numerical value of said a plurality of data item, and the mirror image data contrast with after numerical value renewal last time inquires said data item;
Said data update apparatus also comprises: mirror image is made the unit, and the numerical value of said data item and said other data item is made as mirror image data.
3. data update apparatus according to claim 1 is characterized in that, also comprises: the change record unit when the numerical value of said data item produces change, is recorded in said data item in the database;
Said data item query unit inquires said data item from said database.
4. data update apparatus according to claim 1 is characterized in that, also comprises:
The scope control module is chosen one or morely as query context from said a plurality of data item, and the data item query unit inquires said data item in said query context.
5. according to each described data update apparatus in the claim 1 to 4, it is characterized in that the type of said data item comprises material data, the type that said use generates relation comprises Bill of Material (BOM).
6. a data-updating method is characterized in that, comprising:
Step 202 from a plurality of data item that needs upgrade, inquires the data item of numerical value generation change after last time, numerical value upgraded;
Step 204 generates relation according to the use relevant with said data item, inquires other data item relevant with said data item;
Step 206 according to the numerical value of said data item, calculates the numerical value of said other data item, upgrades said other data item are carried out numerical value.
7. data-updating method according to claim 6 is characterized in that, said step 202 specifically comprises: with the current numerical value of said a plurality of data item, the mirror image data contrast with after numerical value renewal last time inquires said data item;
Said data-updating method also comprises: the numerical value of said data item and said other data item is made as mirror image data.
8. data-updating method according to claim 6 is characterized in that, before said step 202, also comprises: when the numerical value of said data item produces change, said data item is recorded in the database;
Said step 202 specifically comprises: from said database, inquire said data item.
9. data-updating method according to claim 6 is characterized in that, before said step 202, also comprises: from said a plurality of data item, choose one or more as query context;
In said step 202, in said query context, inquire said data item.
10. according to each described data-updating method in the claim 6 to 9, it is characterized in that the type of said data item comprises material data, the type that said use generates relation comprises Bill of Material (BOM).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102845085A CN102354316A (en) | 2011-09-22 | 2011-09-22 | Data updating device and data updating method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011102845085A CN102354316A (en) | 2011-09-22 | 2011-09-22 | Data updating device and data updating method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102354316A true CN102354316A (en) | 2012-02-15 |
Family
ID=45577881
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011102845085A Pending CN102354316A (en) | 2011-09-22 | 2011-09-22 | Data updating device and data updating method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102354316A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102722796A (en) * | 2012-06-11 | 2012-10-10 | 东莞市闻誉实业有限公司 | Flow business management method and system based on network |
| CN104281902A (en) * | 2013-07-05 | 2015-01-14 | 航天信息软件技术有限公司 | Material requirement suggestion making method |
| CN105389315A (en) * | 2014-09-04 | 2016-03-09 | 阿里巴巴集团控股有限公司 | Dynamic webpage refreshing method and device |
| CN107229652A (en) * | 2016-03-25 | 2017-10-03 | 阿里巴巴集团控股有限公司 | A kind of account data and account asset data update method, apparatus and system |
| CN109284177A (en) * | 2017-07-20 | 2019-01-29 | 北京京东尚科信息技术有限公司 | A kind of data-updating method and device |
| CN109377055A (en) * | 2018-10-25 | 2019-02-22 | 金蝶软件（中国）有限公司 | A kind of method and device of business paper adjustment |
| CN109446205A (en) * | 2017-08-28 | 2019-03-08 | 中国电信股份有限公司 | Judge the device and method of data mode and the device and method that data update |
| TWI824222B (en) * | 2020-12-31 | 2023-12-01 | 鼎新電腦股份有限公司 | Enterprise resource planning system and automatic update method thereof |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101681344A (en) * | 2007-06-22 | 2010-03-24 | 微软公司 | Bi-directional data modification with synchronization |
| CN102004973A (en) * | 2010-12-30 | 2011-04-06 | 用友软件股份有限公司 | Task making method and device |
-
2011
- 2011-09-22 CN CN2011102845085A patent/CN102354316A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101681344A (en) * | 2007-06-22 | 2010-03-24 | 微软公司 | Bi-directional data modification with synchronization |
| CN102004973A (en) * | 2010-12-30 | 2011-04-06 | 用友软件股份有限公司 | Task making method and device |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102722796A (en) * | 2012-06-11 | 2012-10-10 | 东莞市闻誉实业有限公司 | Flow business management method and system based on network |
| CN104281902A (en) * | 2013-07-05 | 2015-01-14 | 航天信息软件技术有限公司 | Material requirement suggestion making method |
| CN105389315A (en) * | 2014-09-04 | 2016-03-09 | 阿里巴巴集团控股有限公司 | Dynamic webpage refreshing method and device |
| CN105389315B (en) * | 2014-09-04 | 2019-04-12 | 阿里巴巴集团控股有限公司 | A kind of dynamic web page update method and device |
| CN107229652A (en) * | 2016-03-25 | 2017-10-03 | 阿里巴巴集团控股有限公司 | A kind of account data and account asset data update method, apparatus and system |
| CN109284177A (en) * | 2017-07-20 | 2019-01-29 | 北京京东尚科信息技术有限公司 | A kind of data-updating method and device |
| CN109284177B (en) * | 2017-07-20 | 2021-03-30 | 北京京东尚科信息技术有限公司 | Data updating method and device |
| CN109446205A (en) * | 2017-08-28 | 2019-03-08 | 中国电信股份有限公司 | Judge the device and method of data mode and the device and method that data update |
| CN109446205B (en) * | 2017-08-28 | 2021-03-16 | 中国电信股份有限公司 | Device and method for judging data state and device and method for updating data |
| CN109377055A (en) * | 2018-10-25 | 2019-02-22 | 金蝶软件（中国）有限公司 | A kind of method and device of business paper adjustment |
| TWI824222B (en) * | 2020-12-31 | 2023-12-01 | 鼎新電腦股份有限公司 | Enterprise resource planning system and automatic update method thereof |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102354316A (en) | Data updating device and data updating method | |
| US11429668B2 (en) | Methods and systems for multidimensional analysis of interconnected data sets stored in a graph database | |
| Bhatnagar et al. | Role of logistics in enhancing competitive advantage: A value chain framework for global supply chains | |
| Tsai | Quality cost measurement under activity‐based costing | |
| Pullan et al. | Decision support tool for lean product and process development | |
| Rujirayanyong et al. | A project-oriented data warehouse for construction | |
| Masoud et al. | Integrated cost optimization in a two-stage, automotive supply chain | |
| Saidi-Mehrabad et al. | Production planning and worker training in dynamic manufacturing systems | |
| Radhakrishnan et al. | Inventory optimization in supply chain management using genetic algorithm | |
| Bohnen et al. | Systematic procedure for leveling of low volume and high mix production | |
| Groznik et al. | A process approach to distribution channel re‐engineering | |
| Makarova et al. | The role of reverse logistics in the transition to a circular economy | |
| US6856857B2 (en) | Method and system for planning disassembly and production of recyclable products and for planning procurement of parts for production | |
| Kaur et al. | Environmentally sustainable stochastic procurement model | |
| Wang et al. | The mobile production vehicle routing problem: Using 3D printing in last mile distribution | |
| Frenk et al. | An optimal stopping approach for the end-of-life inventory problem | |
| US20130041789A1 (en) | Production cost analysis system | |
| Zinser et al. | Best practice in reengineering: a successful example of the Porsche research and development center | |
| Ramya et al. | Optimization of production cost for integrating job shop scheduling with production resources | |
| Radhakrishnan et al. | Genetic algorithm based inventory optimization analysis in supply chain management | |
| CN107229996A (en) | A kind of integrated supply chain management platform | |
| CN102004972A (en) | Method and device for altering work breakdown structure (WBS) | |
| Tysseland | Spare parts optimization process and results: OPUS10 cases in the Norwegian Defence | |
| Kurbel et al. | MRP: material requirements planning | |
| TWI776139B (en) | Production method and production system |
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: 20120215 |