Patent ID: 6418438
Filing Date: 2002-07-09
Classification: G06F,Y10S

Abstract:
A method of determining granularity of data locking for a selected transaction, the method comprising:determining the cost of multiple granularities of locking prior to execution of the transaction; determining the granularity of locking having the minimum cost; and executing the transaction while locking data at the determined granularity, wherein the cost of each granularity is a function of memory cost, CPU cost and concurrency exclusivity cost, and wherein the granularities comprise a row, page and table of a relational database and the costs are determined from one or more secondary factors comprising the number of rows to be scanned, the number of rows per page, the isolation level per scan, an update factor, a memory load factor, an over locking factor, and the number of active scans on the table.