CN106557482A - A kind of inventory system data-updating method and device - Google Patents
A kind of inventory system data-updating method and device Download PDFInfo
- Publication number
- CN106557482A CN106557482A CN201510622287.6A CN201510622287A CN106557482A CN 106557482 A CN106557482 A CN 106557482A CN 201510622287 A CN201510622287 A CN 201510622287A CN 106557482 A CN106557482 A CN 106557482A
- Authority
- CN
- China
- Prior art keywords
- subregion
- stock
- field
- inventory database
- inventory
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 39
- 230000001360 synchronised effect Effects 0.000 claims abstract description 37
- 238000000638 solvent extraction Methods 0.000 claims description 13
- 230000004048 modification Effects 0.000 description 7
- 238000012986 modification Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 2
- 241000208340 Araliaceae Species 0.000 description 1
- 241000196324 Embryophyta Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000000151 deposition Methods 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 230000000977 initiatory effect Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000012163 sequencing technique Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2308—Concurrency control
- G06F16/2315—Optimistic concurrency control
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the present application discloses a kind of inventory system data-updating method and device.The scheme, region corresponding with subregion inventory database input field is set in cash statement and field is reduced in region, when there is stock's increase in subregion inventory database or stock reduces, region input field corresponding with the subregion inventory database need to be updated only or field is reduced in region, even if while there is multiple subregion inventory databases that inventory change occurs, also only field is reduced with renewal region input field corresponding with each subregion inventory database or region respectively, without occurring while updating the situation of same field, so as to avoid data synchronous conflict well.And during each subregion inventory database generation inventory change, field can be reduced in the corresponding region input field of subregion inventory database local update or region, resynchronisation cash statement, therefore the data renewal response time is short, is conducive to the handling capacity and availability of raising system.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of inventory system data-updating method and device.
Background technology
There is the website of trans-regional transaction, as website user is from zones of different, geographical position difference is huge, in order to carry
High area data processing speed and raising Consumer's Experience, generally adopt distributing inventory system, that is, collect in each user
In area set up subregion inventory database, each subregion inventory database is connected, and each subregion inventory database is used for
Storage and process inventory data, the quick access of convenient locality user.In subregion inventory database, inventory data structure
Then exist in the form of a table, referred to as cash statement, for convenience of synchronously, subregion inventory database shares cash statement, in cash statement
Inventory data is present in the form of fields, and the input field, expression stock including expression stock's input numerical value reduces numerical value
Field and balance in hand field are reduced, stock's input refers to that stock provider is input into new value of inventory, is input into equivalent to stock,
Stock reduces finger stock consumer and reduces stock, exports equivalent to stock.
When inventory system occurs stock's input or reduces, the inventory data of each subregion inventory database needs same stepping
Row updates, and specifically, when somewhere occurs to conclude the business, in the cash statement of the ground subregion inventory database, input field (is sent out
When raw stock is input into) or reduce field while reducing (stock occurs) and changed, the modification can synchronous other subregions stock's number
According to the same field of the cash statement in storehouse.But the transaction of various places is often simultaneous, each subregion inventory data library of libraries
The same field for depositing table concomitantly changes, and this complications can cause the conflict of data syn-chronization, cause cash statement
Generation error in data, affects real inventory data and trading processing.
To avoid the conflict of data syn-chronization, generally by the way of single-point modification, that is, only use an inventory database
To change cash statement, then amended cash statement is synchronized to into each subregion inventory database.But under this mode, various places
Transaction Information wants first cross-region to be sent at a distance for changing the inventory database of cash statement, then changes cash statement
Inventory database is sorted by priority or time-sequencing modification cash statement, when this mode data modification and synchronous response
Between it is long, reduce the handling capacity of system, availability and Consumer's Experience.
The content of the invention
There is data syn-chronization to overcome inventory system data in correlation technique to update, the application provides a kind of stock system
System data-updating method and device.
According to the first aspect of the embodiment of the present application, there is provided a kind of inventory system data-updating method, including：
Region corresponding with subregion inventory database input field is set in cash statement and field, the area are reduced in region
Domain input field be used for record partitioning inventory database in stock increase numerical value, the region reduce field for record divide
The numerical value that stock reduces in area's inventory database；
When subregion inventory database occurs stock to be increased, update region corresponding with the subregion inventory database and be input into word
Section, and the cash statement of synchronous each subregion inventory database；
When subregion inventory database occurs stock reduces, judge whether balance in hand is more than or equal to and work as what time stock reduced
Numerical value, the balance in hand M=∑ (a1+a2+ ...+an)-∑ (b1+b2+ ...+bn), wherein, a1 to an difference
For the region input field of each subregion inventory database, b1 to bn is respectively the region button of each subregion inventory database
Subtract field, numbers of the n for subregion inventory database；
When the balance in hand is more than or equal to when the numerical value that secondary stock reduces, then update and the subregion inventory database
Reduce field, and the cash statement of synchronous each subregion inventory database in corresponding region.
Optionally, described inventory system data-updating method, also includes：
Balance in hand field is set in cash statement, and the balance in hand field is used to record the balance in hand；
When subregion inventory database occurs stock to be increased, update region corresponding with the subregion inventory database and be input into word
Section, while updating the balance in hand field；And,
When subregion inventory database occurs stock reduces, update region corresponding with the subregion inventory database and reduce word
Section, while updating the balance in hand field.
Optionally, when subregion inventory database occurs stock reduces, judge whether the balance in hand field is more than or waits
In the numerical value reduced as time stock.
Optionally, described inventory system data-updating method, also includes：
When the balance in hand is less than when the numerical value that secondary stock reduces, shortage of stock message is shown.
Optionally, described inventory system data-updating method, using annular synchronous next synchronous each subregion inventory database
Cash statement.
Corresponding to the embodiment of the present application in a first aspect, according to the second aspect of the embodiment of the present application, there is provided a kind of stock system
System data update apparatus, including：
Field setting unit, for the area identification according to each subregion inventory database, arrange in cash statement with it is described
Field is reduced in the corresponding region input field of area identification and region, and the region input field is used for record partitioning stock
The numerical value that stock increases in database, field is reduced in the region is used for the number that stock reduces in record partitioning inventory database
Value；
First updating block, for when subregion inventory database occurs stock's increase, updating and the subregion inventory data
The corresponding region input field in storehouse, and the cash statement of synchronous each subregion inventory database；
Surplus judging unit, for when subregion inventory database occurs stock and reduces, judge balance in hand whether more than or
Equal to the numerical value reduced as time stock, the balance in hand M=∑ (a1+a2+ ...+an)-∑ (b1+b2+ ...+bn),
Wherein, a1 to an is respectively the region input field of each subregion inventory database, and b1 to bn is respectively each subregion
Reduce field, numbers of the n for subregion inventory database in the region of inventory database；
Second updating block, for when the balance in hand is more than or equal to when the numerical value that secondary stock reduces, updating and institute
State the corresponding region of subregion inventory database and reduce field, and the cash statement of synchronous each subregion inventory database.
Optionally, the field setting unit, is additionally operable to balance in hand field, the balance in hand are arranged in cash statement
Field is used to record the balance in hand；
First updating block, for when subregion inventory database occurs stock's increase, updating and the subregion stock
The corresponding region input field of database, while updating the balance in hand field；And,
Second updating block, for when subregion inventory database generation stock reduces, updating and the subregion stock
Field is reduced in the corresponding region of database, while updating the balance in hand field.
Optionally, the surplus judging unit, for when subregion inventory database generation stock reduces, judging the storehouse
Balance field is deposited whether more than or equal to the numerical value reduced as time stock.
Optionally, described inventory system data update apparatus, also include：
Tip element, for when the balance in hand is less than when the numerical value that secondary stock reduces, showing shortage of stock message.
Optionally, first updating block and second updating block are using annular synchronous next synchronous each subregion stock
The cash statement of database.
The technical scheme that the embodiment of the present application is provided, arranges region input corresponding with subregion inventory database in cash statement
Field is reduced in field and region, when certain subregion inventory database occurs stock to be increased, only need to be updated and subregion stock
The corresponding region input field of database, when certain subregion inventory database occurs stock reduces, only need to update and this point
Field is reduced in inventory database corresponding region in area's, accordingly even when while there is multiple subregion inventory databases that inventory changes occur,
Also only need while update corresponding with each subregion inventory database region input field respectively or field is reduced in region, and not
Occur while update the situation of same field, so as to avoid data synchronous conflict well.And each subregion storehouse
When deposit data storehouse occurs inventory change, field can be reduced in the corresponding region input field of local update or region, so
Synchronous cash statement, initiates remote stock's modification without other subregion inventory databases and accesses, therefore data update and ring afterwards
It is short between seasonable, be conducive to handling capacity, availability and the Consumer's Experience of raising system.
It should be appreciated that the general description of the above and detailed description hereinafter are only exemplary and explanatory, can not
Limit the application.
Description of the drawings
In order to be illustrated more clearly that the embodiment of the present application or technical scheme of the prior art, below will be to embodiment or existing
Accompanying drawing to be used needed for technology description is briefly described, it should be apparent that, for those of ordinary skill in the art
Speech, without having to pay creative labor, can be with according to these other accompanying drawings of accompanying drawings acquisition.
Fig. 1 is a kind of schematic flow sheet of the inventory system data-updating method shown in one exemplary embodiment of the application.
Fig. 2 is the schematic flow sheet of another kind of inventory system data-updating method shown in one exemplary embodiment of the application.
Fig. 3 is a kind of block diagram of the inventory system data update apparatus shown in one exemplary embodiment of the application.
Fig. 4 is the block diagram of another kind of inventory system data update apparatus shown in one exemplary embodiment of the application.
Specific embodiment
Here in detail exemplary embodiment will be illustrated, its example is illustrated in the accompanying drawings.Explained below is related to attached
During figure, unless otherwise indicated, the same numbers in different accompanying drawings represent same or analogous key element.Following exemplary is implemented
Embodiment described in example does not represent all embodiments consistent with the application.Conversely, they be only with such as
The example of consistent apparatus and method in terms of some described in detail in appended claims, the application.
For comprehensive understanding the application, numerous concrete details are refer in the following detailed description, but art technology
Personnel are it should be understood that the application can be realized without the need for these details.In other embodiments, public affairs are not described in detail
Method, process, component and the circuit known, in order to avoid undesirably result in embodiment obscure.
Fig. 1 is a kind of schematic flow sheet of the inventory system data-updating method shown in one exemplary embodiment of the application, such as
Shown in Fig. 1, methods described includes：
Step S101, in cash statement arranges region corresponding with subregion inventory database input field and word is reduced in region
Section, the region input field are used for the numerical value that stock increases in record partitioning inventory database, and field is reduced in the region
For the numerical value that stock in record partitioning inventory database reduces.
Wherein, it is described corresponding with subregion inventory database to be and the storehouse of subregion inventory database mark correspondence, Huo Zheyu
The area identification correspondence of subregion inventory database, correspondingly, in cash statement, the number of region input field and region are reduced
The number of field is identical with the number of subregion inventory database respectively.For example, it is provided with cash statement corresponding to subregion stock
Region input field a1, a2 of database W1, W2, W3 ... Wn, a3 ... an and region reduce field b1,
b2、b3……bn.Each subregion inventory database uses same set of table structure, that is, the cash statement of subregion inventory database
It is the same, and the synchronized update that can link.
Step S102, when subregion inventory database occurs stock to be increased, updates corresponding with the subregion inventory database
Region input field, and the cash statement of synchronous each subregion inventory database；
Whether step S103, when subregion inventory database occurs stock reduces, judge balance in hand more than or equal to when secondary
The numerical value that stock reduces；
Step S104, when the balance in hand is more than or equal to when the numerical value that secondary stock reduces, then updates and the subregion
Reduce field, and the cash statement of synchronous each subregion inventory database in the corresponding region of inventory database.
Under a kind of applied environment, when subregion inventory database occurs stock's increase or stock reduces, change right by user
The region input field answered or region are reduced field and reduce the renewal of field completing region input field or region；Another
Plant under applied environment, after subregion inventory database region occurs to conclude the business, area is automatically updated according to the Transaction Information
Field is reduced in domain input field or region, and for example to sell, stock reduces for transaction, then basis is sold volume update area and reduced
Field, if transaction is to buy in, stock increases, then basis buys in volume update area input field.
When subregion inventory database occurs stock to be increased, update region corresponding with the subregion inventory database and be input into word
Section, that is, in the original value of region input field on the numerical value that increases plus stock, at this moment in subregion inventory database
Cash statement change, according to the cash statement of synchronous each subregion inventory database of the change, thus each subregion stock
In the cash statement of database all there is identical in region input field corresponding with the subregion inventory database that stock's increase occurs
Change, completes synchronized update.
When subregion inventory database occurs stock reduces, update region corresponding with the subregion inventory database and reduce word
Section, that is, in the original value of region input field on deduct the numerical value of stock's increase.But if now balance in hand is not
Foot, then cannot complete stock and reduce.Therefore, when subregion inventory database occurs stock reduces, first judge that balance in hand is
It is no more than or equal to the numerical value reduced as time stock, balance in hand M=∑ (a1+a2+ ...+an)-∑
(b1+b2+ ...+bn), wherein, a1 to an is respectively the region input field of each subregion inventory database, and b1 is extremely
Bn is respectively the region of each subregion inventory database and reduces field, numbers of the n for subregion inventory database.If stock
Remaining sum can then carry out stock and reduce more than or equal to the numerical value reduced as time stock, update and the subregion inventory data
Field is reduced in the corresponding region in storehouse, and at this moment the cash statement in subregion inventory database changes, synchronous each according to the change
The cash statement of individual subregion inventory database, thus in the cash statement of each subregion inventory database with occur stock reduce point
Inventory database corresponding region in area's is reduced field and identical change all occurs, and completes synchronized update.If balance in hand is little
In the numerical value reduced as time stock, then can not carry out stock and reduce, also just not update corresponding with the subregion inventory database
Region reduce field, shortage of stock message can be shown in this case, to remind user's now shortage of stock, it is impossible to
Complete stock to reduce.
Wherein it is preferred to, there is stock when changing (increase or decrease) in subregion inventory database, update with it is described
After field is reduced in the corresponding region input field of subregion inventory database or region, the stock to each subregion inventory database
Mode of the synchronization of table using annular synchronization, this is because, each subregion inventory database in the application is made in synchronization
For many master libraries, using annular synchronous processing the synchronization of cash statement in many master library databases, compare general by multiple data
Storehouse is divided into principal and subordinate and carrys out synchronous method, with higher Performance And Reliability.
It should be noted that stock's input occurs and occurs to have no precedence relationship between stock reduces, therefore the application is provided
Technical scheme in do not limited by order is write between step S102 and step S103 (and step S104), also
Can be to first carry out step S102, then execution step S103 and step S104, it is also possible to first carry out step S103 and step
Rapid S104, then execution step S102, or step S102 and the execution simultaneously of step S103.
Fig. 2 is the schematic flow sheet of another kind of inventory system data-updating method shown in one exemplary embodiment of the application,
The method is based on the method shown in Fig. 1, as shown in Fig. 2 methods described includes：
Step S201, in cash statement arranges region corresponding with subregion inventory database input field and word is reduced in region
Section, and balance in hand field is set in cash statement, the region input field is used in record partitioning inventory database
The numerical value that stock increases, field is reduced in the region is used for the numerical value that stock reduces in record partitioning inventory database, described
Balance in hand field is used to record the balance in hand, balance in hand M=∑ (a1+a2+ ...+an)-∑
(b1+b2+ ...+bn), wherein, a1 to an is respectively the region input field of each subregion inventory database, and b1 is extremely
Bn is respectively the region of each subregion inventory database and reduces field, numbers of the n for subregion inventory database；
Step S202, when subregion inventory database occurs stock to be increased, when there is stock in subregion inventory database increase,
Region input field corresponding with the subregion inventory database is updated, while the balance in hand field is updated, and synchronously
The cash statement of each subregion inventory database；
Step S203, when there is stock in subregion inventory database reduce, judge the balance in hand field whether more than or
Equal to the numerical value reduced as time stock；
Step S204, when the balance in hand is more than or equal to when the numerical value that secondary stock reduces, updates and the subregion storehouse
Field is reduced in the corresponding region in deposit data storehouse, while the balance in hand field is updated, and synchronous each subregion inventory data
The cash statement in storehouse.
Step S205, when the balance in hand is less than when the numerical value that secondary stock reduces, shows shortage of stock message.
When subregion inventory database occurs stock reduces, above-mentioned embodiment is judging whether balance in hand is more than or waits
In the numerical value reduced as time stock, balance in hand value to be calculated, and during the generation stock's increase of subregion inventory database, not
Calculate and balance in hand value and balance in hand is updated, such case may be because of more than stock in the case of increasing to stock
The renewal of volume is blank and cause to make a mistake when balance in hand value is calculated in the case of stock reduces so that more than the stock for obtaining
Volume value and physical presence error, if balance in hand value mistake in computation, it is likely that cause system because the stock of mistake reduces
And there is collapse.
It is identical with the embodiment is schemed, in the present embodiment, between step S202 and step S203 (and step S204) simultaneously
Do not limited by order is write, that is, step S202 can be first carried out, then execution step S203 and step S204,
Step S203 and step S204, then execution step S202 can be first carried out, or step S202 is with step S203 simultaneously
Perform.
Therefore in the present embodiment, except in cash statement, field is reduced in setting area input field and region, also in stock
Balance in hand field is set in table, and the balance in hand field is used to record the balance in hand.When subregion inventory database
When generation stock increases, region input field corresponding with the subregion inventory database is updated, while updating the stock
Balance field, that is, the balance in hand after stock increases is calculated, balance in hand field is updated to result of calculation；And
When subregion inventory database occurs stock reduces, update region corresponding with the subregion inventory database and reduce field,
The balance in hand field is updated simultaneously, that is, calculates balance in hand value new after stock reduces, and balance in hand field
Update result of calculation.So, as balance in hand field is real-time update, when generation stock reduces, can not
Balance in hand need to be calculated again, and directly reads balance in hand field, judge whether the balance in hand field is more than or equal to
Current reduces value.
The technical scheme that the embodiment of the present application is provided, arranges region input corresponding with subregion inventory database in cash statement
Field is reduced in field and region, when subregion inventory database occurs stock's increase or stock reduces, need to only be updated and this
Field is reduced in the corresponding region input field of subregion inventory database or region, even if thus while there is multiple subregion stocks
There is inventory change in database, also only with renewal region input field corresponding with each subregion inventory database or area respectively
Field is reduced in domain, without occurring while updating the situation of same field such that it is able to avoid data syn-chronization to rush well
It is prominent.And during each subregion inventory database generation inventory change, can be corresponding in subregion inventory database local update
Field is reduced in region input field or region, resynchronizes cash statement, without initiating remote to other subregion inventory databases
Distance accesses to be updated modification, therefore the data renewal response time is short, is conducive to the handling capacity of raising system, can use
Property and Consumer's Experience.
The description of the embodiment of the method by more than, those skilled in the art can be understood that the application can be borrowed
Help software to add the mode of required general hardware platform to realize, naturally it is also possible to by hardware, but in many cases the former
It is more preferably embodiment.Based on such understanding, the technical scheme of the application is substantially made to prior art in other words
The part of contribution can be embodied in the form of software product, and is stored in a storage medium, including some instructions
With so that smart machine performs all or part of step of each embodiment methods described of the application.And aforesaid deposit
Storage media includes：Read-only storage (ROM), random access memory (RAM), magnetic disc or CD etc. are various can
With data storage and the medium of program code.
Fig. 3 is a kind of block diagram of the inventory system data update apparatus shown in one exemplary embodiment of the application.Such as Fig. 3 institutes
Show, described device includes：
Field setting unit U301, for the area identification according to each subregion inventory database, is arranged in cash statement
Field is reduced in region corresponding with area identification input field and region, and the region input field is used for record point
The numerical value that stock increases in area's inventory database, the region reduce field for stock's button in record partitioning inventory database
The numerical value for subtracting；
First updating block U302, for when subregion inventory database occurs stock's increase, updating and the subregion storehouse
The corresponding region input field in deposit data storehouse, and the cash statement of synchronous each subregion inventory database；
Surplus judging unit U303, for when subregion inventory database generation stock reduces, whether judging balance in hand
More than or equal to the numerical value reduced as time stock；
Second updating block U304, for when the balance in hand is more than or equal to when the numerical value that secondary stock reduces, more
Newly field, and the cash statement of synchronous each subregion inventory database are reduced in region corresponding with the subregion inventory database.
Wherein, the balance in hand M=∑ (a1+a2+ ...+an)-∑ (b1+b2+ ...+bn), wherein, a1 to an
The region input field of each subregion inventory database is respectively, b1 to bn is respectively the area of each subregion inventory database
Reduce field, numbers of the n for subregion inventory database in domain.
These, it is preferred to, first updating block and second updating block using it is annular it is synchronous come it is synchronous each
The cash statement of subregion inventory database.
Fig. 4 is the block diagram of another kind of inventory system data update apparatus shown in one exemplary embodiment of the application.Such as Fig. 4
Shown, described device includes：
Field setting unit U401, for the area identification according to each subregion inventory database, is arranged in cash statement
Field is reduced in region corresponding with area identification input field and region, and balance in hand is arranged in cash statement
Field, the region input field are used for the numerical value that stock increases in record partitioning inventory database, and word is reduced in the region
The numerical value that section is reduced for stock in record partitioning inventory database, the balance in hand field are used to record more than the stock
Volume, the balance in hand M=∑ (a1+a2+ ...+an)-∑ (b1+b2+ ...+bn), wherein, a1 to an is respectively
The region input field of each subregion inventory database, b1 to bn are respectively the region of each subregion inventory database and reduce
Field, numbers of the n for subregion inventory database；
First updating block U402, for when subregion inventory database occurs stock's increase, updating and the subregion storehouse
The corresponding region input field in deposit data storehouse, while the balance in hand field is updated, and synchronous each subregion inventory data
The cash statement in storehouse；
Surplus judging unit U403, for when subregion inventory database generation stock reduces, judging the balance in hand
Whether field is more than or equal to the numerical value reduced as time stock；
Second updating block U404, for when subregion inventory database generation stock reduces, updating and the subregion storehouse
Field is reduced in the corresponding region in deposit data storehouse, while the balance in hand field is updated, and synchronous each subregion inventory data
The cash statement in storehouse；
Tip element U405, for when the balance in hand is less than when the numerical value that secondary stock reduces, showing the shortage of stock
Message.
For convenience of description, it is divided into various units with function when describing apparatus above to describe respectively.Certainly, implementing this
The function of each unit can be realized in same or multiple softwares and/or hardware during application.
Each embodiment in this specification is described by the way of progressive, identical similar part between each embodiment
Mutually referring to what each embodiment was stressed is the difference with other embodiment.Especially for device
Or for system embodiment, as which is substantially similar to embodiment of the method, so describe fairly simple, related part ginseng
See the part explanation of embodiment of the method.Apparatus and system embodiment described above is only schematic, wherein
It is described as separating component explanation unit can be or may not be it is physically separate, as the portion that unit shows
Part can be or may not be physical location, you can local to be located at one, or can also be distributed to multiple networks
On unit.Some or all of module therein can be selected according to the actual needs to realize the purpose of this embodiment scheme.
Those of ordinary skill in the art are not in the case where creative work is paid, you can to understand and implement.
It should be noted that herein, the relational terms of such as " first " and " second " or the like be used merely to by
One entity or operation are made a distinction with another entity or operation, and are not necessarily required or implied these entities or behaviour
There is any this actual relation or backward between work.And, term " including ", "comprising" or its it is any its
His variant is intended to including for nonexcludability, so that process, method, device including a series of key elements or setting
It is standby not only to include those key elements, but also including other key elements being not expressly set out, or also include for this process,
The intrinsic key element of method, device or equipment.In the absence of more restrictions, by sentence "including a ..."
The key element of restriction, it is not excluded that also there is other phase in the process including the key element, method, device or equipment
Same key element.
The above is only the specific embodiment of the application, is made skilled artisans appreciate that or realizing the application.
Various modifications to these embodiments will be apparent to one skilled in the art, and as defined herein one
As principle can be realized in the case of without departing from spirit herein or scope in other embodiments.Therefore, this Shen
The embodiments shown herein please be not intended to be limited to, and be to fit to and principles disclosed herein and features of novelty
Consistent most wide scope.
Claims (12)
1. a kind of inventory system data-updating method, it is characterised in that include：
Region corresponding with subregion inventory database input field is set in cash statement and field, the area are reduced in region
Domain input field be used for record partitioning inventory database in stock increase numerical value, the region reduce field for record divide
The numerical value that stock reduces in area's inventory database；
When subregion inventory database occurs stock to be increased, update region corresponding with the subregion inventory database and be input into word
Section, and the cash statement of synchronous each subregion inventory database；
When subregion inventory database occurs stock reduces, judge whether balance in hand is more than or equal to and work as what time stock reduced
Numerical value；
When the balance in hand is more than or equal to when the numerical value that secondary stock reduces, then update and the subregion inventory database
Reduce field, and the cash statement of synchronous each subregion inventory database in corresponding region.
2. inventory system data-updating method according to claim 1, it is characterised in that the balance in hand
M=∑s (a1+a2+ ...+an)-∑ (b1+b2+ ...+bn), wherein, a1 to an is respectively each subregion inventory database
Region input field, b1 to bn is respectively the region of each subregion inventory database and reduces field, and n is subregion stock
The number of database.
3. inventory system data-updating method according to claim 1 and 2, it is characterised in that also include：
Balance in hand field is set in cash statement, and the balance in hand field is used to record the balance in hand；
When subregion inventory database occurs stock to be increased, update region corresponding with the subregion inventory database and be input into word
Section, while updating the balance in hand field；And,
When subregion inventory database occurs stock reduces, update region corresponding with the subregion inventory database and reduce word
Section, while updating the balance in hand field.
4. inventory system data-updating method according to claim 3, it is characterised in that
When subregion inventory database occurs stock reduces, judge the balance in hand field whether more than or equal to when time storehouse
Deposit the numerical value reduced.
5. inventory system data-updating method according to claim 1, it is characterised in that also include：
When the balance in hand is less than when the numerical value that secondary stock reduces, shortage of stock message is shown.
6. inventory system data-updating method according to claim 1, it is characterised in that using it is annular it is synchronous come it is same
Walk the cash statement of each subregion inventory database.
7. a kind of inventory system data update apparatus, it is characterised in that include：
Field setting unit, for the area identification according to each subregion inventory database, arrange in cash statement with it is described
Field is reduced in the corresponding region input field of area identification and region, and the region input field is used for record partitioning stock
The numerical value that stock increases in database, field is reduced in the region is used for the number that stock reduces in record partitioning inventory database
Value；
First updating block, for when subregion inventory database occurs stock's increase, updating and the subregion inventory data
The corresponding region input field in storehouse, and the cash statement of synchronous each subregion inventory database；
Surplus judging unit, for when subregion inventory database occurs stock and reduces, judge balance in hand whether more than or
Equal to the numerical value reduced as time stock；
Second updating block, for when the balance in hand is more than or equal to when the numerical value that secondary stock reduces, updating and institute
State the corresponding region of subregion inventory database and reduce field, and the cash statement of synchronous each subregion inventory database.
8. inventory system data update apparatus according to claim 7, it is characterised in that the balance in hand
M=∑s (a1+a2+ ...+an)-∑ (b1+b2+ ...+bn), wherein, a1 to an is respectively each subregion inventory database
Region input field, b1 to bn is respectively the region of each subregion inventory database and reduces field, and n is subregion stock
The number of database.
9. inventory system data update apparatus according to claim 7 or 8, it is characterised in that
The field setting unit, is additionally operable to balance in hand field is arranged in cash statement, and the balance in hand field is used for
Record the balance in hand；
First updating block, for when subregion inventory database occurs stock's increase, updating and the subregion stock
The corresponding region input field of database, while updating the balance in hand field；And,
Second updating block, for when subregion inventory database generation stock reduces, updating and the subregion stock
Field is reduced in the corresponding region of database, while updating the balance in hand field.
10. inventory system data update apparatus according to claim 9, it is characterised in that
The surplus judging unit, for when subregion inventory database generation stock reduces, judging the balance in hand word
Whether section is more than or equal to the numerical value reduced as time stock.
11. inventory system data update apparatus according to claim 7, it is characterised in that also include：
Tip element, for when the balance in hand is less than when the numerical value that secondary stock reduces, showing shortage of stock message.
12. inventory system data update apparatus according to claim 7, it is characterised in that described first updates single
Cash statement of first and described second updating block using annular synchronous next synchronous each subregion inventory database.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510622287.6A CN106557482B (en) | 2015-09-25 | 2015-09-25 | Inventory system data updating method and device |
| PCT/CN2016/099058 WO2017050179A1 (en) | 2015-09-25 | 2016-09-14 | Method and device for updating inventory system data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510622287.6A CN106557482B (en) | 2015-09-25 | 2015-09-25 | Inventory system data updating method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106557482A true CN106557482A (en) | 2017-04-05 |
| CN106557482B CN106557482B (en) | 2020-09-25 |
Family
ID=58385698
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510622287.6A Active CN106557482B (en) | 2015-09-25 | 2015-09-25 | Inventory system data updating method and device |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN106557482B (en) |
| WO (1) | WO2017050179A1 (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109558415A (en) * | 2018-11-20 | 2019-04-02 | 北京松鼠山科技有限公司 | Knowledge base update method and device |
| CN110188139A (en) * | 2019-05-05 | 2019-08-30 | 苏宁易购集团股份有限公司 | Inventory's number synchronous method, device, computer equipment and storage medium |
| CN110362581A (en) * | 2018-04-04 | 2019-10-22 | 阿里巴巴集团控股有限公司 | A kind of data processing method and device |
| CN110909978A (en) * | 2019-10-15 | 2020-03-24 | 京东数字科技控股有限公司 | Resource processing method, device, server and computer readable storage medium |
| CN111125104A (en) * | 2019-12-20 | 2020-05-08 | 北京每日优鲜电子商务有限公司 | Database table updating method and device, computer equipment and storage medium |
| CN113762827A (en) * | 2020-07-30 | 2021-12-07 | 北京京东振世信息技术有限公司 | Inventory difference hedging processing method and device |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110263050B (en) * | 2019-05-06 | 2023-10-27 | 创新先进技术有限公司 | Data processing method, device, equipment and storage medium |
| CN112764968B (en) * | 2020-12-29 | 2024-02-13 | 杭州海康威视***技术有限公司 | Data processing method, device, equipment and storage medium |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2636726A1 (en) * | 2007-07-03 | 2009-01-03 | Maritz Inc. | Instant zero inventory fulfillment redemption system and method |
| CN102054226A (en) * | 2010-12-28 | 2011-05-11 | 用友软件股份有限公司 | Inventory management method and system for line edge warehouse |
| CN102930410A (en) * | 2011-08-09 | 2013-02-13 | 鸿富锦精密工业（深圳）有限公司 | Warehouse inventory management system and management method |
| CN104077671A (en) * | 2013-03-25 | 2014-10-01 | 腾讯科技（深圳）有限公司 | Method and system for synchronizing stock information |
| CN104699712A (en) * | 2013-12-09 | 2015-06-10 | 阿里巴巴集团控股有限公司 | Method and device for updating stock record information in database |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| JP4183400B2 (en) * | 2001-06-27 | 2008-11-19 | 株式会社日立製作所 | Database system, database management method and program |
| US7870226B2 (en) * | 2006-03-24 | 2011-01-11 | International Business Machines Corporation | Method and system for an update synchronization of a domain information file |
| CN101441738A (en) * | 2007-12-24 | 2009-05-27 | 北京奥腾讯达科技有限公司 | Sectorization storage management system |
| CN102708529B (en) * | 2012-05-16 | 2015-01-14 | 北京航空航天大学 | Drug storage information managing system for pharmacy |
| CN103853748A (en) * | 2012-11-29 | 2014-06-11 | 天津书生投资有限公司 | Database synchronizing method |
| CN104794132B (en) * | 2014-01-21 | 2018-08-24 | 阿里巴巴集团控股有限公司 | Inventory information processing method and system |
| CN104598610B (en) * | 2015-01-29 | 2017-12-12 | 无锡江南计算技术研究所 | A kind of distributed data base data distribution uploads synchronous method |
-
2015
- 2015-09-25 CN CN201510622287.6A patent/CN106557482B/en active Active
-
2016
- 2016-09-14 WO PCT/CN2016/099058 patent/WO2017050179A1/en active Application Filing
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2636726A1 (en) * | 2007-07-03 | 2009-01-03 | Maritz Inc. | Instant zero inventory fulfillment redemption system and method |
| CN102054226A (en) * | 2010-12-28 | 2011-05-11 | 用友软件股份有限公司 | Inventory management method and system for line edge warehouse |
| CN102930410A (en) * | 2011-08-09 | 2013-02-13 | 鸿富锦精密工业（深圳）有限公司 | Warehouse inventory management system and management method |
| CN104077671A (en) * | 2013-03-25 | 2014-10-01 | 腾讯科技（深圳）有限公司 | Method and system for synchronizing stock information |
| CN104699712A (en) * | 2013-12-09 | 2015-06-10 | 阿里巴巴集团控股有限公司 | Method and device for updating stock record information in database |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110362581A (en) * | 2018-04-04 | 2019-10-22 | 阿里巴巴集团控股有限公司 | A kind of data processing method and device |
| CN109558415A (en) * | 2018-11-20 | 2019-04-02 | 北京松鼠山科技有限公司 | Knowledge base update method and device |
| CN110188139A (en) * | 2019-05-05 | 2019-08-30 | 苏宁易购集团股份有限公司 | Inventory's number synchronous method, device, computer equipment and storage medium |
| CN110188139B (en) * | 2019-05-05 | 2021-10-22 | 苏宁易购集团股份有限公司 | Stock number synchronization method and device, computer equipment and storage medium |
| CN110909978A (en) * | 2019-10-15 | 2020-03-24 | 京东数字科技控股有限公司 | Resource processing method, device, server and computer readable storage medium |
| CN111125104A (en) * | 2019-12-20 | 2020-05-08 | 北京每日优鲜电子商务有限公司 | Database table updating method and device, computer equipment and storage medium |
| CN113762827A (en) * | 2020-07-30 | 2021-12-07 | 北京京东振世信息技术有限公司 | Inventory difference hedging processing method and device |
| CN113762827B (en) * | 2020-07-30 | 2023-11-07 | 北京京东振世信息技术有限公司 | Inventory difference hedging processing method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| WO2017050179A1 (en) | 2017-03-30 |
| CN106557482B (en) | 2020-09-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106557482A (en) | A kind of inventory system data-updating method and device | |
| CN101268439B (en) | Database fragment cloning and management | |
| CN107040648A (en) | Information displaying method and device | |
| CN107302573A (en) | A kind of information-pushing method, device, electronic equipment and storage medium | |
| CN107248052A (en) | A kind of commodity stocks information determines method, apparatus and system | |
| CN102999586A (en) | Method and device for recommending website | |
| CN111858742A (en) | Data visualization method and device, storage medium and equipment | |
| JP6975153B2 (en) | Data storage service processing method and equipment | |
| US8977621B1 (en) | Search engine optimizer | |
| CN108520471A (en) | It is overlapped community discovery method, device, equipment and storage medium | |
| CN106547870A (en) | Point table method and device of data base | |
| CN107045413A (en) | Application program image target display methods and device | |
| CN106294611A (en) | Core banking system and the old and new's core system data exchange method | |
| CN106708842A (en) | Data loading method for application system, database and application system | |
| CN103955854B (en) | A kind of account management device and method | |
| CN110163402A (en) | Determine the method and device of keeper unit in order | |
| CN109636611A (en) | Clear acquisition methods, server, storage medium and the device of configuration information | |
| US10331627B2 (en) | Method and system for unified technological stack management for relational databases | |
| TWI734730B (en) | Method and device for updating inventory system data | |
| CN110502219A (en) | The enterprise-level IT architecture asset management system and method | |
| CN101657806A (en) | Assembly and associated method, for planning computer system resource requirements | |
| CN108961039A (en) | Transaction processing method, apparatus and system | |
| CN109872138A (en) | A kind of method, apparatus and storage medium of digital cash transaction | |
| CN105574728B (en) | A kind of Transaction Information method for tracing and device | |
| US20110138335A1 (en) | Thin analytics for enterprise mobile users |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20240306 Address after: # 04-08, Lai Zanda Building 1, 51 Belarusian Road, Singapore Patentee after: Alibaba Singapore Holdings Ltd. Country or region after: Singapore Address before: Grand Cayman Islands Patentee before: ALIBABA GROUP HOLDING Ltd. Country or region before: Cayman Islands |