Patent ID: 7908257
Filing Date: 2011-03-15
Classification: G06F

Abstract:
1. In a computing environment, a method comprising: implementing a mechanism in a database management system to process read requests and write requests from a plurality of CPUs for a read-mostly database table including one or more resources, the mechanism using a plurality of locks controlling access to the one or more resources, the mechanism operable to partition a respective lock for each of the one or more resources, each lock partition of the respective lock operable to share access to a corresponding resource with other lock partitions of the respective lock; receiving a first read request from a first CPU and a second read request from a second CPU of the plurality of CPUs, both the first and second read requests requesting to access a first resource of the one or more resources; providing a first lock partition of a lock to the first read request accessing the first resource from the first CPU of the plurality of CPUs, wherein said providing the first lock partition comprises hashing a unique identifier of the first CPU and a unique identifier of the first resource to map to a first slot in a hash table that provides the first lock partition; providing a second lock partition of the lock to the second read request accessing the first resource from the second CPU, the first lock partition and the second lock partition operable to share the lock, wherein said providing the second lock partition comprises hashing a unique identifier of the second CPU and the unique identifier of the resource to map to a second slot in the hash table that provides the second lock partition; and processing the first and the second read requests to access the first resource by performing a read access by each of the first and the second read requests.