Patent ID: 6952692
Filing Date: 2005-10-04
Classification: G06F,Y10S

Abstract:
1. A method for use in a computer implemented database system having plural access modules to manage concurrent access of data in respective portions of a storage in the database system, the method comprising: processing a request invoking an operation that is one of an insert-select operation, join-delete operation, and join-update operation, the operation to modify a target table; determining if one or more predefined criteria associated with the operation are satisfied; in response to determining that the one or more predefined criteria are satisfied, further determining a single one of the plural access modules having exclusive control over a portion of the target table to be modified and executing a step to modify the portion of the target table on the single one of the plural access modules; and applying a row-hash level lock instead of a table-level lock in the executing step.