Execution of requests in a parallel database system
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.
2 Assignments
0 Petitions
Accused Products
Abstract
A database system is able to perform efficient execution of insert-select, join-delete, or join-update requests. The database system has plural access modules to manage access of respective portions of data in a storage of the database system. If certain predefined criteria are satisfied, the insert-select, join-delete, or join-update request can be executed by performing a single-access module merge and/or merge-delete step on a single one of the access modules with row-level locks (e.g., row-hash locks).
79 Citations
20 Claims
-
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 Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9, 10, 11)
-
-
12. An article comprising at least one storage medium containing instructions for use in a computer implemented database system having plural access modules that manage respective portions of data in a storage, the instructions when executed cause the database system to:
-
process a request invoking an operation that is one of an insert-select operation, join-delete operation, and join update, the operation to modify a target table; determine 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 the plural access modules having exclusive control over a portion of the target table to be modified and generating 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 generated step. - View Dependent Claims (13, 14, 15, 16)
-
-
17. A computer implemented database system, comprising:
-
plural storage modules to store respective portions of a target table; plural access modules to manage access data in of respective storage modules; and a controller adapted to determine if one or more predefined criteria are satisfied in response to a request that specifies an operation to modify the target table, the operation selected from the group consisting of an insert-select operation, a join-delete operation, and a join-update operation and in response to determining the one or more predefined criteria are satisfied, the controller adapted to determine a single one the plural access modules having exclusive control over a portion of the target table to be modified and to invoke a step executable one the single one of the plural access modules to modify the portion of the target table applying a row-hash level lock instead of a table-level lock. - View Dependent Claims (18, 19)
-
-
20. An article comprising at least one storage medium containing instructions for use in a computer implemented database system having plural access modules that manage respective portions of data in a storage, the instructions when executed causing the database system to:
-
process a request specifying one of an insert-select operation and join-delete operation on a target table; if the request specifies an insert-select operation, perform on a single one of the plural access modules determined to have exclusive control over a portion of the target table to be modified a merge step in the insert-select operation with a row-hash level lock in response to determining that the request directly or indirectly equates a primary index of the target table with a constant value; and if the request specifies a join-delete operation, perform on a single one of the plural access modules determined to have exclusive control over a portion of the target table to be modified a merge-delete step in the join-delete operation with a row-hash level lock in response to determining that the primary index of the target table is equated, directly or indirectly, with a constant value.
-
Specification