Patent ID: 7461065
Filing Date: 2008-12-02
Classification: G06F,Y10S

Abstract:
1. A method for performing at least one transaction on at least one column of a table in a database system, the method comprising: determining whether a first transaction of the at least one transaction fulfills all of at least one criteria, wherein the at least one criteria includes the at least one transaction being an addition or a subtraction on at least one value only for the at least one column, the at least one transaction operating on data in a specified column for which a shared numeric lock is used, and the at least one transaction not modifying data in other columns that are not candidates for a shared numeric lock; ensuring that the at least one column is in a shared numeric lock if the first transaction fulfills all of the at least one criteria, wherein the shared numeric lock is a lock the allows at least a second transaction fulfilling all of the at least one criteria to access the same column concurrently with the first transaction without releasing the shared numeric lock between transactions, and wherein the shared numeric lock is released only after all of the transactions fulfilling all of the criteria have completed processing; and processing the first transaction, wherein processing the first transaction comprises: