# US 10,311,157 B2 · Method for update processing, and apparatus > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 10,311,157 B2 - Document ID: US10311157B2 - Status: Granted - Kind: B2 - Application number: 14/810,973 - Filed: 2015-07-28 - Published: 2016-02-25 - Granted: 2019-06-04 - Earliest claimed: 2014-08-22 - Assignees: Fujitsu Limited - Applicants: Fujitsu Limited - Inventors: Kiichi Yamada; Naohiro Itou; Masahiko Nagata; Mitsuhiro Kinomura - Web page: https://patentgrep.com/patent/US10311157B2 ## CPC - G06F 16/2308: {Concurrency control (transaction processing G06F9/466)} - G06F 16/23: Updating - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) ## Abstract A method includes: upon receipt of a request of update processing for a first record including a numerical data item in a database, generating, by a processor, a second record by duplicating the first record while a value corresponding to an update content of the update processing is set to the numerical data item, the update processing being processing of updating the value of the numerical data item according to the update content; and executing the update processing for the second record in response to the request. ## Claims ### Claim 1 A method executed by a computer, the method comprising: storing a first record including a first numerical data in a database; receiving a subtraction request to subtract a second numerical data from the first numerical data of the first record; generating, in response to a reception of the subtraction request, a second record including the second numerical data indicated by the subtraction request and modifying the first numerical data of the first record to a third numerical data obtained by subtracting the second numerical data from the first numerical data, wherein the first record is set in an unlocked state to enable a process for another request and the second record is set in a locked state in which any requests other than the subtraction request is blocked; and deleting the second record in accordance with confirmation of the processing the subtraction request. ### Claim 2 (depends on 1) The method according to claim 1, further comprising: when the update content is subtracting, in a case where a plurality of records are generated by the generating, selecting one or more records selected from the generated records such that a sum of values of the numerical data item is equal to or larger than the second value; and setting the selected one or more records as records to be updated. ### Claim 3 (depends on 1) The method according to claim 1, further comprising: upon receipt a request of reference processing for the numerical data item in the first record, in a case where a plurality of records are generated by the generating, setting a sum of values of the numerical data item in the plurality of records to the numerical data item to be referred to. ### Claim 4 (depends on 1) The method according to claim 1, further comprising: calculating a sum of values of the numerical data item in a second plurality of records having the same state of the update processing among a first plurality of records generated by the generating in response to a request of a plurality of the update processings of a certain transaction; and merging the second plurality of records by generating a record in which the calculated sum is set to the numerical data item. ### Claim 5 (depends on 1) The method according to claim 1, wherein the generating is executed when a certain criterion about updating of the numerical data item by the update processing is satisfied, and the generating is kept from being executed when the certain criterion is not satisfied. ### Claim 6 (depends on 5) The method according to claim 5, wherein the certain criterion is that the value of the numerical data item does not fall below a predetermined value as a result of the update processing. ### Claim 7 An apparatus comprising: a memory configured to store a first record including a first numerical data in a database; and a processor coupled to the memory and configured to execute a process including: receiving a subtraction request to subtract a second numerical data from the first numerical data of the first record; generating, in response to a reception of the subtraction request, a second record including the second numerical data indicated by the subtraction request and modifying the first numerical data of the first record to a third numerical data obtained by subtracting the second numerical data from the first numerical data, wherein the first record is set in an unlocked state to enable a process for another request and the second record is set in a locked state in which any requests other than the subtraction request is blocked; and deleting the second record in accordance with confirmation of the processing the subtraction request. ### Claim 8 (depends on 7) The apparatus according to claim 7, wherein the process further including: selecting one or more records selected from the generated records such that a sum of values of the numerical data item is equal to or larger than the second value, and setting the selected one or more records as records to be updated. ### Claim 9 (depends on 7) The apparatus according to claim 7, wherein the process further including: upon receipt a request of reference processing for the numerical data item in the first record, in a case where a plurality of records are generated by the generating, setting a sum of values of the numerical data item in the plurality of records to the numerical data item to be referred to. ### Claim 10 (depends on 7) The apparatus according to claim 7, wherein the process further including: calculating a sum of values of the numerical data item in a second plurality of records having the same state of the update processing among a first plurality of records generated by the generating in response to a request of a plurality of the update processings of a certain transaction, and merging the second plurality of records by generating a record in which the calculated sum is set to the numerical data item. ### Claim 11 (depends on 7) The apparatus according to claim 7, wherein the generating is executed when a certain criterion about updating of the numerical data item by the update processing is satisfied, and the generating is kept from being executed when the certain criterion is not satisfied. ### Claim 12 (depends on 11) The apparatus according to claim 11, wherein the certain criterion is that the value of the numerical data item does not fall below a predetermined value as a result of the update processing.