Method and system for reduced lock contention in SQL...

Details Method and system for reduced lock contention in SQL... Method and system for reduced lock contention in SQL...

2006-07-18

2006-07-18

Rones, Charles (Department: 2164)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C707S793000

Reexamination Certificate

active

07080074

ABSTRACT:
According to the method, apparatus, and computer readable medium of the present invention, a scan is performed by accessing all rows of a table in a relational database, evaluating each row to determine whether the row satifies a set of predicates of a database query, and returning the row if it satisfies the set of predicates. According to a preferred embodiment of the present invention, all rows are evaluated regardless of current locks. The scan is continued if the row does not satisfy the set of predicates regardless of the current lock on the row. The locking semantics according to the invention has the advantage that it completely removes the problem of lock contention on the rows that do not satisfy statement predicates.

REFERENCES:
patent: 6606626 (2003-08-01), Ponnekanti
patent: 2002/0038313 (2002-03-01), Klein et al.

Affiliated with

Also associated with

Rating

Method and system for reduced lock contention in SQL... 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 reduced lock contention in SQL..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Method and system for reduced lock contention in SQL... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3525700