Patent ID: 9009101
Filing Date: 2015-04-14
Classification: G06F

Abstract:
1. A method for reducing contention of transaction logging in a database management system (DBMS) having a memory and a processor coupled to the memory, the method comprising: creating a dependency relationship among private log caches (PLCs) having individual associations with tasks in the DBMS, wherein the PLCs store log records of the tasks before the log records are posted in the DBMS and, controlling, using the synchronization markers, buffer pinning and unpinning among the PLCs without involving a flushing of the PLCs during transactions of the tasks, wherein the controlling buffer pinning and unpinning comprises annotating the PLC of the PLCs associated with the task with the synchronization marker as a flush point that synchronizes an order for flushing log records in the PLC associated with the task and the log records of the PLC unassociated with the task, at the time the log records are being flushed, and wherein the PLCs are stored in the memory and the pinning and unpinning among the PLCs uses the processor.