Invention Grant
- Patent Title: Optimizing lock acquisition on transaction logs
- Patent Title (中): 优化事务日志上的锁获取
-
Application No.: US12052417Application Date: 2008-03-20
-
Publication No.: US07899794B2Publication Date: 2011-03-01
- Inventor: Vadiraja Bhatt , Nitin Verma , Fei Zhou
- Applicant: Vadiraja Bhatt , Nitin Verma , Fei Zhou
- Applicant Address: US CA Dublin
- Assignee: Sybase, Inc.
- Current Assignee: Sybase, Inc.
- Current Assignee Address: US CA Dublin
- Agency: Sterne, Kessler, Goldstein & Fox PLLC
- Main IPC: G06F17/00
- IPC: G06F17/00

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.
Public/Granted literature
- US20090240739A1 Optimizing Lock Acquisition on Transaction Logs Public/Granted day:2009-09-24
Information query