×

Execution of requests in a parallel database system

  • US 6,952,692 B1
  • Filed: 05/17/2002
  • Issued: 10/04/2005
  • Est. Priority Date: 05/17/2002
  • Status: Active Grant
First Claim
Patent Images

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.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×