摘要 |
PROBLEM TO BE SOLVED: To achieve an optimistic lock system without having version information on a table side.SOLUTION: At the time of retrieval, an AP server 14 transmits an application for setting a temporary lock including specific information concerning a target table, record and user to a unique lock server 20. The unique lock server 20, if corresponding temporary lock information is not present on a memory, registers new temporary lock information and notifies the AP server 14 thereof, but, if present, adds a user ID to the existing temporary lock information and notifies the AP server 14 thereof. After completion of the temporary lock setting, the AP server 14 requests a DB server 22 to extract the record. At the time of data update, the AP server 14 transmits an application for setting a normal lock including specific information concerning the target table, record and user to the unique lock server 20. The unique lock server 20, if corresponding temporary lock information is present on the memory, shifts the temporary lock information to normal lock information and notifies the AP server 14 thereof, and the AP server 14 requests the DB server 22 to update the record.SELECTED DRAWING: Figure 3 |