Method and system for utilizing shared numeric locks

Details Method and system for utilizing shared numeric locks Method and system for utilizing shared numeric locks

2006-01-31

2008-12-02

Alam, Hosain T (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C711S141000

Reexamination Certificate

active

07461065

ABSTRACT:
A method and system for performing at least one transaction on at least one column of a table in a database system is disclosed. The method and system include determining whether a first transaction of the at least one transaction fulfills all of the criteria and ensuring that the at least one column is in a shared numeric lock if the first transaction fulfills the at least one criteria. The shared numeric lock allows at least a second transaction fulfilling the at least one criteria to be processed concurrently with the first transaction without releasing the shared numeric lock. The method and system also include processing the first transaction. Thus, the method and system allow multiple transactions to be processed concurrently.

REFERENCES:
patent: 5355477 (1994-10-01), Strickland et al.
patent: 5761659 (1998-06-01), Bertoni
patent: 5940828 (1999-08-01), Anaya et al.
patent: 6240413 (2001-05-01), Learmont
patent: 6351744 (2002-02-01), Landresse
patent: 6363387 (2002-03-01), Ponnekanti et al.
patent: 6418438 (2002-07-01), Campbell
patent: 6560601 (2003-05-01), Bjornerstedt
patent: 6606626 (2003-08-01), Ponnekanti
patent: 6772155 (2004-08-01), Stegelmann
patent: 6807541 (2004-10-01), Bender et al.
patent: 6910039 (2005-06-01), Daynes
patent: 7149737 (2006-12-01), Luo et al.
patent: 7269588 (2007-09-01), Verma et al.
patent: 2004/0199512 (2004-10-01), Cornwell et al.
patent: 2004/0236744 (2004-11-01), Desai et al.
patent: 2004/0236746 (2004-11-01), Lomet
patent: 2006/0004758 (2006-01-01), Teng et al.
Andreas Reuter,Concurrency on High-Traffic Data Elements, ACM, 1982.
Patrick E. O'Neil,The Escrow Transactional Method, ACM Transactions on Database Systems, vol. 11, No. 4, Dec. 1986, pp. 405-430.

Affiliated with

Also associated with

Rating

Method and system for utilizing shared numeric locks does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Method and system for utilizing shared numeric locks, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for utilizing shared numeric locks will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4039801