Lock Management Method for Main Memory Database Management System

摘要

The present invention relates to an effective method of managing a lock for a main memory database management system (MDBMS), and more particularly, to a method for checking whether a lock is applied to a partition by accessing a target partition, If the lock is not locked by this check, lock information is filled in the lock request and linked to the lock header, then the lock request is included in the linked list indicated by the transaction entry, and then the latch is unpacked and returned. Checking the strength and lock of the acquired lock mode to determine whether the lock is shared with another transaction, if the lock is present and the partition is already locked, processing the information of the lock request, releasing the latch and returning, If the partition is not already locked, the lock is first requested by the transaction, If there are other locks in the lock request, lock information is filled in the lock request, and the lock request is linked to the lock header, and then the linked request is included in the linked list indicated by the transaction entry. It is possible to reduce the concurrency problem when the database is used as a unit of locking by performing the process of changing the information of the lock request by checking whether or not all of the records are read and then releasing the latch and returning it. Overhead problems can be solved at the same time.