TW201828112A - Method and device for updating inventory system data capable of shortening data update response time - Google Patents

Abstract

The embodiment of the present invention discloses a method and a device for updating inventory system data, wherein an area input field and an area deduction field corresponding to an area inventory database are arranged in an inventory table. When the number of items in the area inventory database increases or decreases, only the area input field or the area deduction filed corresponding to the area inventory database is required to be updated, that is, even when inventory changes are made to a plurality of area inventory databases, only the area input fields or area deduction fields corresponding to each area inventory database are updated respectively. The situation of updating the same field at the same time is thus avoided from conflicts caused by data synchronization. Moreover, when inventory changes occur to each area inventory database, the corresponding area input field or area deduction field can be locally updated in the area inventory database, and then the inventory table is synchronized. As a result, the data update response time is short, which is beneficial to improve the processing volume and availability of the system.

Description

 Inventory system data updating method and device  

The invention relates to the technical field of database, in particular to a method and device for updating inventory system data.

There are websites with cross-regional transactions. Since the users of the website come from different regions, the geographical location is very different. In order to improve the speed of regional data processing and improve the user experience, a decentralized inventory system is usually adopted, that is, the partition inventory data is established in the areas where each user is concentrated. The library, each partition inventory database is connected, and each partition inventory database is used to store and process inventory data, which is convenient for local users to access quickly. In the partition inventory database, the inventory data structure exists in the form of a table, which is called an inventory table. In order to facilitate synchronization, the partition inventory database shares the inventory table, and the inventory data in the inventory table exists in the form of a field, including indicating inventory input. The input field of the value, the deduction field and the inventory balance field indicating the deduction value of the inventory, the inventory input means that the inventory provider inputs a new inventory value, which is equivalent to the inventory input, and the deduction of the inventory refers to the deduction of the inventory by the inventory consumer. Equivalent to inventory output.

When inventory input or deduction occurs in the inventory system, the inventory data of each partition inventory database needs to be updated simultaneously. Specifically, when a transaction occurs in a place, the input field of the inventory table of the local inventory database is generated (occurrence occurs) When the inventory is entered) or the deduction field (when inventory deduction occurs) is modified, the modification will synchronize the same field of the inventory table of the other partition inventory database. However, transactions in various places often occur at the same time. The same field of the inventory table in each partition inventory database changes concurrently. This concurrency will lead to conflicts in data synchronization, resulting in data errors in the inventory table, affecting real inventory. Data and transaction processing.

In order to avoid the conflict of data synchronization, a single point modification method is usually adopted, that is, only one inventory database is used to modify the inventory table, and then the modified inventory table is synchronized to each partition inventory database. However, in this way, the transaction information of each place must be sent to the inventory database used to modify the inventory table, and then the inventory database of the inventory table is modified in order of priority or time order to modify the inventory table. Data modification and synchronization have a long response time, reducing system throughput, availability, and user experience.

In order to overcome the problem of data synchronization in the inventory system data update in the related art, the present invention provides a method and device for updating inventory system data.

According to a first aspect of the present invention, a method for updating an inventory system data is provided, including: setting an area input field corresponding to a partition inventory database and an area deduction field in an inventory table, the area input field The value used to record the inventory increase in the partition inventory database, the regional deduction field is used to record the value of the inventory deduction in the partition inventory database; when the inventory inventory database increases, the partition inventory is updated The area corresponding to the database input field, and synchronize the inventory table of each partition inventory database; when the inventory inventory of the partition inventory database occurs, determine whether the inventory balance is greater than or equal to the value of the current inventory deduction, the inventory balance M=Σ(a1+a2+...+an)-Σ(b1+b2+...+bn), where a1 to an are the regional input fields of the respective partition inventory databases, and b1 to bn are the respective partition stocks respectively. The area deduction field of the database, where n is the number of the partition inventory database; when the inventory balance is greater than or equal to the value of the current inventory deduction, the pair is updated with the partition inventory database The region deductions fields, and synchronizing the various partitions inventory database inventory table.

Optionally, the method for updating the inventory system data further includes: setting an inventory balance field in the inventory table, wherein the inventory balance field is used to record the inventory balance; when the inventory of the partition inventory database increases, Updating an area input field corresponding to the partition inventory database, and updating the inventory balance field; and updating an area deduction corresponding to the partition inventory database when an inventory deduction occurs in the partition inventory database Field, and update the inventory balance field at the same time.

Optionally, when the inventory deduction occurs in the partition inventory database, it is determined whether the inventory balance field is greater than or equal to the value of the current inventory deduction.

Optionally, the method for updating the inventory system data further includes: displaying an insufficient inventory message when the inventory balance is less than the value of the current inventory deduction.

Optionally, the inventory system data update method uses a ring synchronization to synchronize an inventory table of each partition inventory database.

Corresponding to the first aspect of the embodiment of the present invention, according to the second aspect of the embodiment of the present invention, an inventory system data updating apparatus is provided, including: a field setting unit, configured to use the area identifier of each partition inventory database. An area input field corresponding to the area identifier and an area deduction field are set in the inventory table, where the area input field is used to record the value of the inventory increase in the partition inventory database, and the area deduction field is used. The value of the deduction of the inventory in the partition inventory database; the first update unit is configured to update the regional input field corresponding to the partition inventory database when the inventory inventory database increases, and synchronize the inventory of each partition. The inventory table of the database; the remaining judgment unit is configured to determine whether the inventory balance is greater than or equal to the value of the current inventory deduction when the inventory deduction occurs in the partition inventory database, the inventory balance M=Σ(a1+a2+ ......+an)-Σ(b1+b2+...+bn), where a1 to an are the regional input fields for each partition inventory database, and b1 to bn are the respective partition inventory databases. The area deduction field, n is the number of the partition inventory database; the second update unit is configured to update and correspond to the partition inventory database when the inventory balance is greater than or equal to the value of the current inventory deduction The area deducts the field and synchronizes the inventory table of each partition inventory database.

Optionally, the field setting unit is further configured to set an inventory balance field in the inventory table, the inventory balance field is used to record the inventory balance; and the first update unit is configured to use the partition inventory Updating the inventory input field corresponding to the partitioned inventory database and updating the inventory balance field; and the second update unit is configured to generate an inventory deduction when the inventory is generated in the partition inventory database. When the time is reduced, the area deduction field corresponding to the partition inventory database is updated, and the inventory balance field is updated.

Optionally, the remaining judgment unit is configured to determine, when the inventory deduction of the partition inventory database occurs, whether the inventory balance field is greater than or equal to a value of the current inventory deduction.

Optionally, the inventory system data updating device further includes: a prompting unit, configured to display an insufficient inventory message when the inventory balance is less than a value of the current inventory deduction.

Optionally, the first update unit and the second update unit use ring synchronization to synchronize the inventory tables of the respective partition inventory databases.

According to the technical solution provided by the embodiment of the present invention, an area input field and an area deduction field corresponding to the partition inventory database are set in the inventory table, and when the inventory of a certain partition inventory database increases, only the partition is updated. The area input field corresponding to the inventory database, when an inventory deduction for a partition inventory database occurs, only the regional deduction field corresponding to the partition inventory database is updated, so that even if there are multiple partition inventory databases at the same time In the event of inventory changes, it is only necessary to update the regional input fields or regional deduction fields corresponding to each partition inventory database at the same time, without the situation that the same field is updated at the same time, thus avoiding data synchronization. conflict. Moreover, when inventory changes occur in each partition inventory database, the corresponding regional input field or regional deduction field can be locally updated, and then the inventory table is synchronized, without requiring other partition inventory database to initiate remote inventory modification access, The short response time of the data update is beneficial to improve the processing capacity, availability and user experience of the system.

The above general description and the following detailed description are intended to be illustrative and not restrictive.

U301‧‧‧Field setting unit

U302‧‧‧First update unit

U303‧‧‧Residual judgment unit

U304‧‧‧Second update unit

U401‧‧‧Field setting unit

U402‧‧‧First update unit

U403‧‧‧Residual judgment unit

U404‧‧‧Second update unit

U405‧‧‧Cue unit

In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the embodiments or the description of the prior art will be briefly described below. Obviously, for those skilled in the art, Other drawings may also be obtained from these drawings without paying for inventive labor.

FIG. 1 is a schematic flowchart of a method for updating an inventory system data according to an exemplary embodiment of the present invention.

FIG. 2 is a schematic flowchart diagram of another method for updating inventory system data according to an exemplary embodiment of the present invention.

FIG. 3 is a block diagram of an inventory system data update apparatus according to an exemplary embodiment of the present invention.

FIG. 4 is a block diagram of another inventory system data updating apparatus according to an exemplary embodiment of the present invention.

Exemplary embodiments will be described in detail herein, examples of which are illustrated in the accompanying drawings. The same numbers in the different figures represent the same or similar elements, unless otherwise indicated. The mode of implementation described in the following exemplary embodiments does not represent all implementation modes consistent with the present invention. On the contrary, they are merely examples of devices and methods consistent with aspects of the invention as detailed in the appended claims.

In order to fully understand the present invention, many specific details are described in the following detailed description, but those skilled in the art will understand that the invention may be practiced without the specific details. In other instances, well-known methods, procedures, components, and circuits are not described in detail to avoid unnecessarily obscuring the embodiments.

FIG. 1 is a schematic flowchart of a method for updating an inventory system data according to an exemplary embodiment of the present invention. As shown in FIG. 1 , the method includes: Step S101: setting an area input corresponding to a partition inventory database in an inventory table. A field and an area deduction field, wherein the area input field is used to record the value of the inventory increase in the partition inventory database, and the area deduction field is used to record the value of the inventory deduction in the partition inventory database.

The corresponding to the partition inventory database may correspond to the library identifier of the partition inventory database, or correspond to the region identifier of the partition inventory database, and correspondingly, the number of the region input fields and the region buckle in the inventory table The number of reduction fields is the same as the number of partition inventory databases. For example, the inventory table is provided with area input fields a1, a2, a3, ..., and area deduction fields b1, b2, b3, ... bn corresponding to the partition stock databases W1, W2, W3, ... Wn. Each partition inventory database uses the same set of table structure, that is, the inventory table of the partition inventory database is the same, and can be synchronized and updated simultaneously.

Step S102, when an inventory increase occurs in the partition inventory database, update an area input field corresponding to the partition inventory database, and synchronize an inventory table of each partition inventory database; in step S103, when the partition inventory database generates an inventory deduction If the time is reduced, it is determined whether the inventory balance is greater than or equal to the value of the current inventory deduction; and in step S104, when the inventory balance is greater than or equal to the value of the current deduction, the area corresponding to the partitioned inventory database is updated. Deduct the fields and synchronize the inventory table of each partition inventory database.

In an application environment, when an inventory increase or inventory deduction occurs in the partition inventory database, the user inputs the corresponding region input field or the regional deduction field to complete the update of the region input field or the regional deduction field; In another application environment, when a transaction occurs in the area where the partition inventory database is located, the regional input field or the regional deduction field is automatically updated according to the transaction information, for example, the transaction is sold, the inventory is deducted, and then the sale is based on To update the regional deduction field, if the transaction is buy and the inventory is increased, the regional input field is updated according to the purchase amount.

When the inventory of the partition inventory database increases, the area input field corresponding to the partition inventory database is updated, that is, the value of the inventory increase is added to the original value of the area input field, and then the partition inventory database is The inventory table changes, and the inventory table of each partition inventory database is synchronized according to the change, so that the regional input fields corresponding to the partition inventory database in which the inventory increase occurs in the inventory table of each partition inventory database are the same. Change to complete the sync update.

When the inventory deduction of the partition inventory database occurs, the regional deduction field corresponding to the partition inventory database is updated, that is, the value of the inventory increase is subtracted from the original value of the regional input field. However, if the inventory balance is insufficient at this time, the inventory deduction cannot be completed. Therefore, when the inventory deduction of the partition inventory database occurs, it is first determined whether the inventory balance is greater than or equal to the value of the current inventory deduction, the inventory balance M=Σ(a1+a2+...+an)-Σ(b1+b2+ ......+bn), where a1 to an are the regional input fields of each partition inventory database, b1 to bn are the regional deduction fields of each partition inventory database, and n is the number of partition inventory databases. . If the inventory balance is greater than or equal to the value of the current inventory deduction, the inventory deduction may be performed, and the regional deduction field corresponding to the partition inventory database is updated, and the inventory table in the partition inventory database changes, according to The change synchronizes the inventory table of each partition inventory database, so that the regional deduction field corresponding to the partition inventory database in which the inventory deduction occurs in the inventory table of each partition inventory database changes the same, and the synchronization update is completed. If the inventory balance is less than the value of the current inventory deduction, the inventory deduction cannot be performed, and the regional deduction field corresponding to the partitioned inventory database is not updated. In this case, an insufficient inventory message can be displayed to remind The user is not in stock at this time and cannot complete the inventory deduction.

Preferably, when the inventory inventory database changes (increase or decrease), the regional input field or the regional deduction field corresponding to the partition inventory database is updated, and the inventory database of each partition is The synchronization of the inventory table uses the ring synchronization method, because the partition inventory database in the present invention is used as a multi-master library in synchronization, and the ring synchronization is used to process the synchronization of the inventory table in the multi-master database database, compared to the general The method of dividing multiple databases into primary and secondary synchronization has higher performance and reliability.

It should be noted that there is no relationship between the occurrence of the inventory input and the occurrence of the inventory deduction. Therefore, the technical solution provided by the present invention is not limited by the writing order between step S102 and step S103 (and step S104), that is, Step S102 and step S104 may be performed first, or step S103 and step S104 may be performed first, then step S102 may be performed, or step S102 and step S103 may be performed simultaneously.

FIG. 2 is a schematic flowchart diagram of another method for updating inventory system data according to an exemplary embodiment of the present invention. The method is based on the method shown in FIG. 1. As shown in FIG. 2, the method includes: step S201, in an inventory table. Setting an area input field corresponding to the partition inventory database and an area deduction field, and setting an inventory balance field in the inventory table, wherein the area input field is used to record the value of the inventory increase in the partition inventory database. The area deduction field is used to record the value of the deduction of the inventory in the partition inventory database, and the inventory balance field is used to record the inventory balance, and the inventory balance M=Σ(a1+a2+...+an )-Σ(b1+b2+...+bn), where a1 to an are the regional input fields of each partition inventory database, and b1 to bn are the regional deduction fields of each partition inventory database, respectively, n is The number of the partition inventory database; in step S202, when the inventory of the partition inventory database increases, when the inventory of the partition inventory database increases, the area input field corresponding to the partition inventory database is updated, and the location is updated. Inventory balance field, and synchronize the inventory table of each partition inventory database; step S203, when the inventory inventory deduction occurs in the partition inventory database, determine whether the inventory balance field is greater than or equal to the value of the current inventory deduction; S204. When the inventory balance is greater than or equal to the value of the current inventory deduction, update the regional deduction field corresponding to the partition inventory database, update the inventory balance field, and synchronize the inventory information of each partition. Library inventory table.

In step S205, when the inventory balance is less than the value of the current inventory deduction, an insufficient inventory message is displayed.

When the inventory deduction of the zoning inventory database occurs, the above embodiment determines whether the inventory balance is greater than or equal to the value of the current inventory deduction, and the inventory balance value is calculated, and when the inventory inventory of the zoning inventory database increases, it is not calculated. The inventory balance value and the inventory balance are updated. This situation may result in an error in calculating the inventory balance value in the case of inventory deduction due to the update blank of the inventory balance, so that the obtained inventory balance value and the actual value There is an error, and if the inventory balance value is incorrectly calculated, it is likely to cause the system to crash due to a wrong inventory deduction.

In the embodiment, the step S202 and the step S203 (and the step S204) are not limited by the writing order, that is, the step S202 may be performed first, and then the steps S203 and S204 are performed. Step S203 and step S204 may be performed first, then step S202 may be performed, or step S202 and step S203 may be performed simultaneously.

Therefore, in the present embodiment, in addition to setting the area input field and the area deduction field in the stock table, an inventory balance field is also set in the stock table, and the stock balance field is used to record the stock balance. When the inventory of the partition inventory database increases, the area input field corresponding to the partition inventory database is updated, and the inventory balance field is updated, that is, the inventory balance after the inventory increase is calculated, and the inventory balance field is updated. To the calculation result; and when the inventory deduction of the partition inventory database occurs, updating the regional deduction field corresponding to the partition inventory database, and updating the inventory balance field, that is, calculating the new inventory deduction The inventory balance value and the inventory balance field are updated to the calculation result. In this way, since the inventory balance field is updated in real time, when the inventory deduction occurs, the inventory balance can be read without directly calculating the inventory balance field, and it is determined whether the inventory balance field is greater than or equal to the current deduction. Impairment.

According to the technical solution provided by the embodiment of the present invention, an area input field and an area deduction field corresponding to the partition inventory database are set in the inventory table, and when the inventory inventory of the partition inventory database increases or the inventory deduction occurs, only the update and the The area input field or the area deduction field corresponding to the partition inventory database, so that even if there are multiple partition inventory database inventory changes at the same time, only the regional input fields corresponding to each partition inventory database are updated separately or The area deducts the field without the simultaneous update of the same field, which can avoid data synchronization conflicts. Moreover, when inventory changes occur in each partition inventory database, the corresponding regional input field or regional deduction field can be locally updated in the partition inventory database, and the inventory table can be synchronized, without having to initiate long distance to other partition inventory databases. Access to update and modify, so the data update response time is short, which helps to improve the system's processing capacity, availability and user experience.

Through the description of the above method embodiments, those skilled in the art can clearly understand that the present invention can be implemented by means of a software plus a necessary universal hardware platform, and of course, can also be through hardware, but in many cases, the former is more Good implementation mode. Based on such understanding, the technical solution of the present invention, which is essential or contributes to the prior art, may be embodied in the form of a software product and stored in a storage medium, including a number of instructions for making a smart device. All or part of the steps of the method of the various embodiments of the invention are performed. The foregoing storage medium includes: a medium that can store data and a code, such as a read only memory (ROM), a random access memory (RAM), a magnetic disk, or an optical disk.

FIG. 3 is a block diagram of an inventory system data update apparatus according to an exemplary embodiment of the present invention. As shown in FIG. 3, the device includes: a field setting unit U301, configured to set an area input field corresponding to the area identifier and an area deduction column in the inventory table according to the area identifier of each partition inventory database. Bit, the area input field is used to record the value of the inventory increase in the partition inventory database, and the area deduction field is used to record the value of the inventory deduction in the partition inventory database; the first update unit U302 is used to When the inventory of the partition inventory database increases, the regional input field corresponding to the partition inventory database is updated, and the inventory table of each partition inventory database is synchronized; the deposit judging unit U303 is used to generate the partition inventory database. When the inventory is deducted, it is determined whether the inventory balance is greater than or equal to the value of the current inventory deduction; the second update unit U304 is configured to update the partition when the inventory balance is greater than or equal to the value of the current inventory deduction The area corresponding to the inventory database deducts the field and synchronizes the inventory table of each partition inventory database.

Wherein, the inventory balance M=Σ(a1+a2+...+an)-Σ(b1+b2+...++bn), wherein a1 to an are the regional input fields of the respective partition inventory databases, b1 to Bn is the regional deduction field for each partition inventory database, and n is the number of partition inventory databases.

Preferably, the first update unit and the second update unit use ring synchronization to synchronize the inventory tables of the respective partition inventory databases.

FIG. 4 is a block diagram of another inventory system data updating apparatus according to an exemplary embodiment of the present invention. As shown in FIG. 4, the device includes: a field setting unit U401, configured to set an area input field corresponding to the area identifier and an area deduction column in the inventory table according to the area identifier of each partition inventory database. Bit, and set the inventory balance field in the inventory table, the area input field is used to record the value of the inventory increase in the partition inventory database, and the regional deduction field is used to record the inventory deduction in the partition inventory database. The inventory balance field is used to record the inventory balance, the inventory balance M=Σ(a1+a2+...+an)-Σ(b1+b2+...++bn), where a1 to an Field input fields for each partition inventory database, b1 to bn are the regional deduction fields of each partition inventory database, n is the number of partition inventory database; first update unit U402 is used to partition When the inventory database increases, the area input field corresponding to the partition inventory database is updated, the inventory balance field is updated, and the inventory table of each partition inventory database is synchronized; the remaining judgment unit U403 is used. Take When the inventory deduction of the partition inventory database occurs, it is determined whether the inventory balance field is greater than or equal to the value of the current inventory deduction; the second update unit U404 is used to update the inventory deduction when the partition inventory database occurs. The area corresponding to the partition inventory database deducts the field, simultaneously updates the inventory balance field, and synchronizes the inventory table of each partition inventory database; the prompt unit U405 is used when the inventory balance is less than the current inventory deduction When the value is subtracted, the insufficient stock message is displayed.

For convenience of description, the above devices are described separately in terms of functions and are described separately for various units. Of course, the functions of the various units may be implemented in the same or multiple software and/or hardware in the practice of the invention.

The various embodiments in the present specification are described in a gradual manner, and the same or similar parts between the various embodiments may be referred to each other, and each embodiment focuses on differences from other embodiments. In particular, for a device or system embodiment, since it is substantially similar to the method embodiment, the description is relatively simple, and the relevant portions can be referred to the description of the method embodiments. The apparatus and system embodiments described above are merely illustrative, wherein the units described as separate components may or may not be physically separate, and the components displayed as units may or may not be physical units, ie It can be located in one place or it can be distributed to multiple network units. Some or all of the modules may be selected according to actual needs to achieve the objectives of the solution of the embodiment. Those of ordinary skill in the art can understand and implement without any creative effort.

It should be noted that, in this context, relational terms such as "first" and "second" are used merely to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply these There is any such actual relationship or reverse order between entities or operations. Furthermore, the term "comprises" or "comprises" or "comprises" or any other variations thereof is intended to encompass a non-exclusive inclusion, such that a process, method, apparatus, or device that includes a plurality of elements includes not only those elements but also Other elements, or elements that are inherent to such a process, method, device, or device. An element that is defined by the phrase "comprising a ..." does not exclude the presence of the same element in the process, method, apparatus, or device.

The above description is only illustrative of specific embodiments of the invention, which will enable those skilled in the art to understand or implement the invention. Various modifications to these embodiments are obvious to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the invention. Therefore, the present invention is not intended to be limited to the embodiments shown herein, but the scope of the invention.

Claims (12)

 An inventory system data updating method, comprising: setting an area input field corresponding to a partition inventory database and an area deduction field in an inventory table, wherein the input field of the area is used to record the inventory in the partition inventory database The added value, the area deduction field is used to record the value of the deduction of the inventory in the partition inventory database; when the inventory of the partition inventory database increases, the regional input field corresponding to the partition inventory database is updated and synchronized. The inventory table of each partition inventory database; when the inventory deduction of the partition inventory database occurs, it is judged whether the inventory balance is greater than or equal to the value of the current inventory deduction; and when the inventory balance is greater than or equal to the value of the current inventory deduction At the same time, the regional deduction field corresponding to the partition inventory database is updated, and the inventory table of each partition inventory database is synchronized.    According to the inventory system data updating method described in claim 1, wherein the stock balance M=Σ(a1+a2+...+an)-Σ(b1+b2+......+bn), wherein a1 to an The fields are respectively input into the area of each partition inventory database, and b1 to bn are the regional deduction fields of each partition inventory database, and n is the number of the partition inventory database.    The inventory system data updating method according to claim 1 or 2, further comprising: setting an inventory balance field in the inventory table, the inventory balance field is used to record the inventory balance; and when the partition inventory database When the inventory increase occurs, the area input field corresponding to the partition inventory database is updated, and the inventory balance field is updated; and when the inventory deduction of the partition inventory database occurs, the area corresponding to the partition inventory database is updated. Deduct the field and update the inventory balance field.    According to the inventory system data updating method described in claim 3, when the inventory deduction of the partition inventory database occurs, it is determined whether the inventory balance field is greater than or equal to the value of the current inventory deduction.    The method for updating inventory system data according to claim 1, wherein the method further comprises: displaying an insufficient inventory message when the inventory balance is less than the value of the current inventory deduction.    The inventory system data update method according to claim 1, wherein the ring synchronization is used to synchronize the inventory tables of the respective partition inventory databases.    An inventory system data updating device, comprising: a field setting unit, configured to set an area input field corresponding to the area identifier and an area deduction in the inventory table according to the area identifier of each partition inventory database; Field, the input field of the area is used to record the value of the inventory increase in the partition inventory database, and the deduction field of the area is used to record the value of the deduction of the inventory in the partition inventory database; the first update unit is used to be the partition When the inventory database increases, the area input field corresponding to the partition inventory database is updated, and the inventory table of each partition inventory database is synchronized; the remaining judgment unit is used when the inventory deduction of the partition inventory database occurs. And determining, by the second update unit, the area corresponding to the partition inventory database when the inventory balance is greater than or equal to the value of the current inventory deduction; Deduct the fields and synchronize the inventory table of each partition inventory database.    The inventory system data updating device according to item 7 of the patent application scope, wherein the inventory balance M=Σ(a1+a2+...+an)-Σ(b1+b2+...++bn), wherein a1 to an The fields are respectively input into the area of each partition inventory database, and b1 to bn are the regional deduction fields of each partition inventory database, and n is the number of the partition inventory database.    The inventory system data updating device according to claim 7 or 8, wherein the field setting unit is further configured to set an inventory balance field in the inventory table, wherein the inventory balance field is used to record the inventory balance The first update unit is configured to update an area input field corresponding to the partition inventory database when the inventory inventory database increases, and update the inventory balance field; and the second update unit is configured to: When the inventory deduction occurs in the partition inventory database, the regional deduction field corresponding to the partition inventory database is updated, and the inventory balance field is updated.    The inventory system data updating device according to claim 9, wherein the deposit determining unit is configured to determine whether the inventory balance field is greater than or equal to the current inventory when the inventory deduction occurs in the partition inventory database. The deduction value.    The inventory system data updating device according to the seventh aspect of the invention, further comprising: a prompting unit, configured to display an insufficient stock message when the stock balance is less than a value of the current stock deduction.    The inventory system data updating apparatus according to claim 7, wherein the first update unit and the second update unit synchronize the inventory table of each of the partition stock databases using ring synchronization.