TWI734730B - Method and device for updating inventory system data - Google Patents

Abstract

The embodiment of the present invention discloses a method and device for updating inventory system data. In the solution, the area input field and the area deduction field corresponding to the partition inventory database are set in the inventory table. When the inventory increase or inventory deduction occurs in the partition inventory database, only the partition inventory database needs to be updated. The corresponding area input field or area deduction field, even if there are inventory changes in multiple partition inventory databases at the same time, only the area input field or area deduction field corresponding to each partition inventory database is updated separately , And will not update the same field at the same time, which can avoid data synchronization conflicts. Moreover, when inventory changes occur in each partition inventory database, you can update the corresponding area input field or area deduction field locally in the partition inventory database, and then synchronize the inventory table, so the data update response time is short, which is beneficial to improve the system. Processing volume and availability.

Description

Method and device for updating inventory system data

The present 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. Because website users come from different regions and the geographical differences are huge, in order to increase the speed of regional data processing and improve user experience, a distributed inventory system is usually used, that is, to establish partitioned inventory data in areas where users are concentrated. Database, each partition inventory database is connected, each partition inventory database is used to store and process inventory data, which is convenient for local users to quickly access. In the partitioned inventory database, the inventory data structure exists in the form of a table, called an inventory table. In order to facilitate synchronization, the partitioned inventory database shares the inventory table. The inventory data in the inventory table exists in the form of fields, including the inventory input The value input field, the deduction field indicating the inventory deduction value, and the inventory balance field. Inventory input means that the inventory provider enters a new inventory value, which is equivalent to inventory entry. Inventory deduction means that the inventory consumer deducts inventory. 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 synchronously. Specifically, when a transaction occurs in a certain place, the input field (occurring When inventory is entered) or the deduction field (when inventory deduction occurs) is modified, the modification will synchronize the same field in the inventory table of other partition inventory databases. However, transactions in various places often occur at the same time. The same column of the inventory table in each partition inventory database changes concurrently. This concurrency will cause data synchronization conflicts, cause data errors in the inventory table, and affect the real inventory. Data and transaction processing.

In order to avoid conflicts in data synchronization, a single point of modification is usually used, that is, only one inventory database is used to modify the inventory table, and then the modified inventory table is synchronized to each partitioned inventory database. However, in this way, the transaction information from various places must be sent to the inventory database used to modify the inventory table from a long distance across the region, and then the inventory database of the modified inventory table is sorted by priority or time to modify the inventory table. This way The response time for data modification and synchronization is long, which reduces the processing capacity, usability and user experience of the system.

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

According to a first aspect of the embodiment of the present invention, a method for updating inventory system data is provided, including: setting an area input field and an area deduction field corresponding to a partitioned inventory database in an inventory table, the area input field It is used to record the increased value of inventory in the partition inventory database. The area deduction field is used to record the value of inventory deduction in the partition inventory database; when the inventory increase in the partition inventory database, it is updated with the partition inventory Enter the fields in the corresponding area of the database, and synchronize the inventory tables of each partition inventory database; when inventory deduction occurs in the partition inventory database, determine whether the inventory balance is greater than or equal to the current inventory deduction value, the inventory balance M=Σ(a1+a2+……+an)-Σ(b1+b2+……+bn), where a1 to an are the area input fields of each partition inventory database, and b1 to bn are each partition inventory respectively The area deduction field of the database, n is the number of the partition inventory database; when the inventory balance is greater than or equal to the current inventory deduction value, the area deduction corresponding to the partition inventory database is updated Field, and synchronize the inventory tables of each partition's inventory database.

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

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

Optionally, the inventory system data update method further includes: when the inventory balance is less than the current inventory deduction value, displaying an inventory shortage message.

Optionally, the inventory system data update method uses ring synchronization to synchronize the inventory tables of each partitioned inventory database.

Corresponding to the first aspect of the embodiment of the present invention, and according to the second aspect of the embodiment of the present invention, an inventory system data update device is provided, including: a field setting unit for identifying the area of each partitioned inventory database, An area input field and an area deduction field corresponding to the area identifier are set in the inventory table. The area input field is used to record the increase in inventory in the partition inventory database, and the area deduction field is used for To record the value of the inventory deduction in the partition inventory database; the first update unit is used to update the area input field corresponding to the partition inventory database when the inventory increase occurs in the partition inventory database, and synchronize the inventory of each partition The inventory table of the database; the inventory judgment unit is used to determine whether the inventory balance is greater than or equal to the current inventory deduction value when the inventory deduction occurs in the partitioned inventory database, the inventory balance M=Σ(a1+a2+ ……+an)-Σ(b1+b2+……+bn), where a1 to an are the area input fields of each partition inventory database, and b1 to bn are the area deduction fields of each partition inventory database. Bit, n is the number of the partition inventory database; the second update unit is used to update the area deduction column corresponding to the partition inventory database when the inventory balance is greater than or equal to the current inventory deduction value And synchronize the inventory tables of each partition's inventory database.

Optionally, the field setting unit is further used to set an inventory balance field in the inventory table, the inventory balance field is used to record the inventory balance; the first update unit is used to serve as a partition inventory When an inventory increase occurs in the database, update the area input field corresponding to the partitioned inventory database, and update the inventory balance field at the same time; and, the second update unit is used for when an inventory deduction occurs in the partitioned inventory database. When subtracting, update the area deduction field corresponding to the partition inventory database, and update the inventory balance field at the same time.

Optionally, the inventory determination unit is configured to determine whether the inventory balance field is greater than or equal to the current inventory deduction value when an inventory deduction occurs in the partitioned inventory database.

Optionally, the inventory system data update device further includes: a prompt unit for displaying an insufficient inventory message when the inventory balance is less than the current inventory deduction value.

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

In the technical solution provided by the embodiment of the present invention, the area input field and the area deduction field corresponding to the partition inventory database are set in the inventory table. When the inventory of a certain partition inventory database increases, only the partition is updated. The corresponding area input field of the inventory database. When an inventory deduction occurs in a partition inventory database, you only need to update the area deduction field corresponding to the partition inventory database, so that even if there are multiple partition inventory databases at the same time When inventory changes occur, you only need to update the area input fields or area deduction fields corresponding to each partition inventory database at the same time, instead of updating the same field at the same time, thus avoiding data synchronization. conflict. Moreover, when inventory changes occur in the inventory database of each partition, you can update the corresponding area input field or area deduction field locally, and then synchronize the inventory table, without the need for other partition inventory databases to initiate remote inventory modification access, so The data update response time is short, which is conducive to improving the processing capacity, usability and user experience of the system.

It should be understood that the above general description and the following detailed description are only exemplary and explanatory, and cannot limit the present invention.

U301‧‧‧Column Setting Unit

U302‧‧‧First update unit

U303‧‧‧Remaining Judgment Unit

U304‧‧‧Second update unit

U401‧‧‧Column Setting Unit

U402‧‧‧First update unit

U403‧‧‧Remaining Judgment Unit

U404‧‧‧Second update unit

U405‧‧‧Prompt unit

In order to explain the embodiments of the present invention or the technical solutions in the prior art more clearly, the following will briefly introduce the accompanying drawings that need to be used in the description of the embodiments or the prior art. Obviously, for those of ordinary skill in the art, Other drawings can be obtained based on these drawings without creative labor.

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

Fig. 2 is a schematic flowchart 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 updating device according to an exemplary embodiment of the present invention.

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

The exemplary embodiments will be described in detail here, and examples thereof are shown in the accompanying drawings. In the following description of related drawings, unless otherwise indicated, the same numbers in different drawings indicate the same or similar elements. The implementation modes described in the following exemplary embodiments do not represent all implementation modes consistent with the present invention. On the contrary, they are only examples of devices and methods consistent with some aspects of the present invention as detailed in the scope of the appended application.

In order to fully understand the present invention, many specific details are mentioned in the following detailed description, but those skilled in the art should understand that the present invention can be implemented without these specific details. In other embodiments, well-known methods, processes, elements, and circuits are not described in detail, so as not to unnecessarily obscure the embodiments.

Fig. 1 is a schematic flow chart of a method for updating 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 the partitioned inventory database in the inventory table The field and the area deduction field, 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.

Wherein, the correspondence with the partition inventory database may be corresponding to the library identifier of the partition inventory database, or corresponding to the area identifier of the partition inventory database. Accordingly, in the inventory table, the number of area input fields and the area deduction The number of subtracted fields is the same as the number of the partition inventory database. For example, the inventory table is provided with area input fields a1, a2, a3...an and area deduction fields b1, b2, b3...bn corresponding to the partitioned inventory databases W1, W2, W3...Wn. Each partition inventory database uses the same table structure, that is, the inventory tables of the partition inventory database are the same, and can be linked and updated synchronously.

Step S102: When inventory increases in the partitioned inventory database, update the area input field corresponding to the partitioned inventory database, and synchronize the inventory tables of each partitioned inventory database; Step S103, when inventory deduction occurs in the partitioned inventory database When subtracting, determine whether the inventory balance is greater than or equal to the current inventory deduction value; step S104, when the inventory balance is greater than or equal to the current inventory deduction value, update the area corresponding to the partition inventory database Deduct fields and synchronize the inventory tables of each partition's inventory database.

In an application environment, when inventory increase or inventory deduction occurs in the partitioned inventory database, the user can modify the corresponding area input field or area deduction field to complete the update of the area input field or area deduction field; In another application environment, when a transaction occurs in the area where the partitioned inventory database is located, the area input field or area deduction field is automatically updated according to the transaction information. Update the regional deduction field based on the purchase amount. If the transaction is a purchase and the inventory increases, update the regional input field according to the purchase amount.

When an inventory increase occurs in the partition inventory database, update the area input field corresponding to the partition inventory database, that is, add the value of the inventory increase to the original value of the area input field, and then the partition inventory database The inventory table of, and the inventory table of each partition inventory database is synchronized according to the change. Therefore, the area input fields in the inventory table of each partition inventory database corresponding to the partition inventory database where the inventory increase occurs are the same Change, complete synchronization update.

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

Wherein, preferably, when the inventory of the partition inventory database changes (increases or decreases), after updating the area input field or the area deduction field corresponding to the partition inventory database, the data of each partition inventory database is updated. The synchronization of the inventory table uses the ring synchronization method. This is because each partitioned inventory database in the present invention is used as a multi-master database during synchronization, and the ring synchronization is used to process the synchronization of the inventory tables in the multi-master database. The method of dividing multiple databases into master and slave synchronization has higher performance and reliability.

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

FIG. 2 is a schematic flowchart 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: The area input field and area deduction field corresponding to the partition inventory database are set in, and the inventory balance field is set in the inventory table. 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 inventory deduction in the partition inventory database, 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 area input fields of each partition inventory database, b1 to bn are the area deduction fields of each partition inventory database, and n is The number of the partition inventory database; step S202, when the partition inventory database has an inventory increase, when the partition inventory database has an inventory increase, update the area input field corresponding to the partition inventory database, and update the Inventory balance field, and synchronize the inventory tables of each partition inventory database; step S203, when inventory deduction occurs in the partition inventory database, determine whether the inventory balance field is greater than or equal to the current inventory deduction value; step S204: When the inventory balance is greater than or equal to the current inventory deduction value, update the area deduction field corresponding to the partition inventory database, update the inventory balance field at the same time, and synchronize the inventory data of each partition The inventory table of the library.

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

When an inventory deduction occurs in a partitioned inventory database, the above implementation method determines whether the inventory balance is greater than or equal to the value of the current inventory deduction. The inventory balance value must be calculated, and when the inventory increase occurs in the partitioned inventory database, it is not calculated. Inventory balance value and inventory balance update. In this case, an error may occur in calculating inventory balance value under inventory deduction due to the blank update of inventory balance when inventory increases, making the obtained inventory balance value and actual There are errors. If the inventory balance value is calculated incorrectly, it is likely to cause the system to crash due to the wrong inventory deduction.

Similar to the embodiment described in the figure, in this embodiment, the writing sequence between step S202 and step S203 (and step S204) is not limited, that is, step S202 can be performed first, and then step S203 and step S204 can be performed. It is also possible to perform step S203 and step S204 first, and then perform step S202, or step S202 and step S203 can be performed simultaneously.

Therefore, in this embodiment, in addition to setting the area input field and the area deduction field in the inventory table, an inventory balance field is also set in the inventory table, and the inventory balance field is used to record the inventory balance. When an inventory increase occurs in the partition inventory database, update the area input field corresponding to the partition inventory database, and update the inventory balance field at the same time, that is, calculate the inventory balance after the inventory increase, and update the inventory balance field To the calculation result; and when inventory deduction occurs in the partition inventory database, update the area deduction field corresponding to the partition inventory database, and update the inventory balance field at the same time, that is, calculate the new inventory deduction The inventory balance value, and the inventory balance field is updated to the calculation result. In this way, since the inventory balance field is updated in real time, when inventory deduction occurs, there is no need to calculate the inventory balance, but directly read the inventory balance field to determine whether the inventory balance field is greater than or equal to the current deduction. Impairment.

In the technical solution provided by the embodiment of the present invention, the area input field and the area deduction field corresponding to the partition inventory database are set in the inventory table. When the inventory increase or inventory deduction occurs in the partition inventory database, only update and The area input field or area deduction field corresponding to the partition inventory database, so even if there are inventory changes in multiple partition inventory databases at the same time, only the area input field or area corresponding to each partition inventory database needs to be updated separately. The area deducts the field, and the situation of updating the same field at the same time does not occur, so as to avoid data synchronization conflicts. Moreover, when inventory changes occur in each partition inventory database, the corresponding area input field or area deduction field can be updated locally in the partition inventory database, and then the inventory table can be synchronized, without the need to initiate a long distance to other partition inventory databases Access to update and modify, so the data update response time is short, which is conducive to improving the processing capacity, usability and user experience of the system.

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 software plus the necessary universal hardware platform, of course, through hardware, but in many cases the former is better. The best implementation model. Based on this understanding, the technical solution of the present invention essentially or the part that contributes to the existing technology can be embodied in the form of a software product, and stored in a storage medium, including several instructions to make a smart device Perform all or part of the steps of the method described in each embodiment of the present invention. The aforementioned storage media include: read-only memory (ROM), random access memory (RAM), magnetic disks or optical disks and other media that can store data and program codes.

Fig. 3 is a block diagram of an inventory system data updating device according to an exemplary embodiment of the present invention. As shown in FIG. 3, the device includes: a field setting unit U301 for setting an area input field and an area deduction field corresponding to the area identifier in the inventory table according to the area identifier of each partitioned inventory database The area input field is used to record the value of inventory increase in the partition inventory database, and the area deduction field is used to record the value of inventory deduction in the partition inventory database; the first update unit U302 is used for When the inventory increase occurs in the partition inventory database, update the area input field corresponding to the partition inventory database, and synchronize the inventory tables of each partition inventory database; the inventory determination unit U303 is used for when the partition inventory database occurs When inventory is deducted, it is determined whether the inventory balance is greater than or equal to the current inventory deduction value; the second update unit U304 is used to update the partition with the partition when the inventory balance is greater than or equal to the current inventory deduction value. The area corresponding to the inventory database is deducted, and the inventory tables of each partition's inventory database are synchronized.

Among them, the inventory balance M=Σ(a1+a2+……+an)-Σ(b1+b2+……+bn), where a1 to an are the area input fields of each partition inventory database, and b1 to bn is the area deduction field of each partition inventory database, and n is the number of the partition inventory database.

Wherein, preferably, the first update unit and the second update unit use ring synchronization to synchronize the inventory tables of each partition inventory database.

Fig. 4 is a block diagram of another inventory system data updating device according to an exemplary embodiment of the present invention. As shown in FIG. 4, the device includes: a field setting unit U401, which is used to set an area input field and an area deduction field corresponding to the area identification in the inventory table according to the area identification of each partitioned inventory database In the inventory table, an inventory balance field is set. The area input field is used to record the increase in inventory in the partition inventory database, and the area 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 Enter the fields for the area of each partition inventory database, b1 to bn are the area deduction fields of each partition inventory database, n is the number of the partition inventory database; the first update unit U402 is used as the partition When inventory increases in the inventory database, update the area input field corresponding to the partition inventory database, update the inventory balance field at the same time, and synchronize the inventory tables of each partition inventory database; the inventory judgment unit U403 uses In order to determine whether the inventory balance field is greater than or equal to the value of the current inventory deduction when an inventory deduction occurs in the partitioned inventory database; the second update unit U404 is used for when an inventory deduction occurs in the partitioned inventory database, Update the area deduction field corresponding to the partition inventory database, update the inventory balance field at the same time, and synchronize the inventory tables of each partition inventory database; the prompt unit U405 is used for when the inventory balance is less than the current time When the value of inventory deduction, the message of insufficient inventory is displayed.

For the convenience of description, when describing the above devices, the various units are described separately in terms of functions. Of course, when implementing the present invention, the functions of each unit can be implemented in the same or multiple software and/or hardware.

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

It should be noted that in this article, relational terms such as "first" and "second" are only used 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. Moreover, the terms "include", "include" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, device, or device that includes a series of elements includes not only those elements, but also includes those that are not explicitly listed Other elements of, or also include elements inherent to this process, method, device, or equipment. If there are no more restrictions, the element defined by the sentence "including a..." does not exclude the existence of other identical elements in the process, method, device, or equipment that includes the element.

The above are only specific embodiments of the present invention, so that those skilled in the art can understand or implement the present invention. Various modifications to these embodiments will be obvious to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to the embodiments shown in this document, but should conform to the widest scope consistent with the principles and novel features disclosed in this document.

Claims (12)

A method for updating inventory system data, which is characterized by comprising: setting an area input field and an area deduction field corresponding to the partition inventory database in the inventory table, and the area input field is used to record the inventory in the partition inventory database. Increased value, the area deduction field is used to record the value of inventory deduction in the partition inventory database; when the inventory increase occurs in the partition inventory database, update the area input field corresponding to the partition inventory database and synchronize The inventory table of each partition inventory database; when inventory deduction occurs in the partition inventory database, determine whether the inventory balance is greater than or equal to the current inventory deduction value; and when the inventory balance is greater than or equal to the current inventory deduction value At the time, update the area deduction field corresponding to the partition inventory database, and synchronize the inventory tables of each partition inventory database. According to the inventory system data update method described in item 1 of the scope of patent application, the inventory balance M=Σ(a1+a2+……+an)-Σ(b1+b2+……+bn), where a1 to an Enter the fields for the area of each partition inventory database, b1 to bn are the area deduction fields of each partition inventory database, and n is the number of the partition inventory database. The inventory system data update method according to item 1 or 2 of the scope of patent application, which further includes: setting an inventory balance field in the inventory table, and the inventory balance field is used to record the inventory balance; when the inventory database is partitioned When inventory increase occurs, update the area input field corresponding to the partition inventory database, and update the inventory balance field at the same time; and, when inventory deduction occurs in the partition inventory database, update the area corresponding to the partition inventory database Decrease the field and update the inventory balance field at the same time. According to the inventory system data update method described in item 3 of the scope of patent application, when inventory deduction occurs in the partitioned inventory database, it is determined whether the inventory balance field is greater than or equal to the current inventory deduction value. The method for updating inventory system data according to item 1 of the scope of patent application, which further includes: when the inventory balance is less than the current inventory deduction value, displaying an inventory shortage message. According to the inventory system data update method described in item 1 of the scope of patent application, ring synchronization is used to synchronize the inventory tables of each partition inventory database. An inventory system data update device, which is characterized by comprising: a field setting unit for setting an area input field and area deduction corresponding to the area identification in the inventory table according to the area identification of each partitioned inventory database Field, the input field in this area is used to record the value of inventory increase in the partition inventory database, and the area deduction field is used to record the value of inventory deduction in the partition inventory database; the first update unit is used as the partition When inventory increases in the inventory database, update the input field corresponding to the partition inventory database, and synchronize the inventory tables of each partition inventory database; the inventory judgment unit is used when inventory deduction occurs in the partition inventory database To determine whether the inventory balance is greater than or equal to the current inventory deduction value; and the second update unit is used to update the area corresponding to the partition inventory database when the inventory balance is greater than or equal to the current inventory deduction value Deduct fields and synchronize the inventory tables of each partition's inventory database. According to the inventory system data update device described in item 7 of the scope of patent application, the inventory balance M=Σ(a1+a2+……+an)-Σ(b1+b2+……+bn), where a1 to an Enter the fields for the area of each partition inventory database, b1 to bn are the area deduction fields of each partition inventory database, and n is the number of the partition inventory database. The inventory system data update device according to item 7 or 8 of the scope of patent application, wherein the field setting unit is also used to set an inventory balance field in the inventory table, and the inventory balance field is used to record the inventory balance ; The first update unit is used to update the area input field corresponding to the partition inventory database when the inventory increase occurs in the partition inventory database, and update the inventory balance field at the same time; and the second update unit is used for When an inventory deduction occurs in a partition inventory database, update the area deduction field corresponding to the partition inventory database, and update the inventory balance field at the same time. The inventory system data update device according to item 9 of the scope of patent application, wherein the inventory determination unit is used to determine whether the inventory balance field is greater than or equal to the current inventory when inventory deduction occurs in the partitioned inventory database The value of the deduction. The inventory system data update device according to item 7 of the scope of patent application further includes: a prompting unit for displaying an insufficient inventory message when the inventory balance is less than the current inventory deduction value. The inventory system data update device according to item 7 of the scope of patent application, wherein the first update unit and the second update unit use ring synchronization to synchronize the inventory tables of each partitioned inventory database.

Images