Reducing bottleneck of stock allocation by splitting record into multiple records having appropriate quantities
Original Publication Date: 2002-Oct-04
Included in the Prior Art Database: 2003-Jun-21
Disclosed is a method for reducing bottleneck in application systems which maintain a record for some kind of amount.(ex. an order allocation system) The main idea is to split a record into multiple records in order to have each record have a smaller amount than original one and keep total amount same as original one. By doing this, record lock scope for an allocation process becomes smaller and multiple allocation processes become to be able to run simultaneously. Fig.1 shows the problem this invention intends to solve. There are five "Allocation Modules,,,," running simultaneously but only one "Allocation Module" is able to get exclusive lock and update the record. Other four "Allocation Modules,,," must be waiting until the first "Allocation Module" releases the lock for the record, even if each "Allocation Modules,,,," needs to allocate only a few amount far below the total amount 1000.