Optimizing lock acquisition on transaction logs

Details Optimizing lock acquisition on transaction logs Optimizing lock acquisition on transaction logs

2011-03-01

2011-03-01

Mofiz, Apu M (Department: 2161)

Data processing: database and file management or data structures

File or database maintenance

Database recovery

C707S672000, C707S674000, C711S161000, C714S002000, C714S748000

Reexamination Certificate

active

07899794

ABSTRACT:
A system, method, and computer program product for improving physical lock acquisition for database transaction logs are described herein. In an embodiment, the method operates by receiving a request for a transaction log page and determining whether a requested log page is newly-allocated or already exists. A determination is made regarding whether the last log page is being modified. A physical lock is taken on the requested log page when it has been determined that the requested log page is not newly-allocated and that the last log page is not being modified. Operations on the last log page are synchronized without a physical lock when it is determined that the requested log page is newly-allocated or that the last log page is being modified.

REFERENCES:
patent: 6721765 (2004-04-01), Ghosh et al.
patent: 7107294 (2006-09-01), Romanufa et al.
patent: 7783610 (2010-08-01), Lin et al.

Affiliated with

Also associated with

Rating

Optimizing lock acquisition on transaction logs does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Optimizing lock acquisition on transaction logs, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Optimizing lock acquisition on transaction logs will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2651236