Patent ID: 8260758
Filing Date: 2012-09-04
Classification: G06F,Y10S

Abstract:
1. A method for processing 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; 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 that 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; processing the first transaction and the second transaction concurrently using the shared numeric lock, wherein the shared numeric lock includes a shared numeric lock data structure that obtains, holds, and updates data for the first transaction and the second transaction during the concurrent processing, and wherein the shared numeric lock includes shared numeric lock transaction information that lists transactions using the shared numeric lock and associated pointers to the transactions; and releasing the shared numeric lock only after all the first transaction and the second transaction have been processed concurrently.