Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Log sequence number generation method and device and readable storage medium

A serial number generation and serial number technology, applied in the database field, can solve the problem that exclusive locks are easy to become system bottlenecks, and achieve the effect of reducing competing operations and improving performance

Pending Publication Date: 2019-05-21
袁振南 +1
View PDF4 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical problem mainly solved by this application is to provide a log sequence number generation method, device and readable storage medium, which can solve the problem in the prior art that the exclusive lock used for LSN generation is likely to become a system bottleneck

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Log sequence number generation method and device and readable storage medium
  • Log sequence number generation method and device and readable storage medium
  • Log sequence number generation method and device and readable storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0017] The following will clearly and completely describe the technical solutions in the embodiments of the present application with reference to the accompanying drawings in the embodiments of the present application, and those of the following embodiments that do not conflict can be combined with each other. Apparently, the described embodiments are only some of the embodiments of this application, not all of them. Based on the embodiments in this application, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the scope of protection of this application.

[0018] like figure 1 As shown, an embodiment of the log serial number generation method of the present application includes:

[0019] S1: Use the lock manager to receive lock requests for operations on elements.

[0020] In the database system, in order to improve the operating efficiency of the system, multiple transactions are often executed concurrently. C...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The present application discloses a log sequence number generation method, which comprises: using a lock manager to receive a locking application for operating an element; determining whether an element is available; and if the element is available, using the lock manager to lock the element and generate a log sequence number corresponding to the operation. The present application also discloses alog sequence number generation device and a readable storage medium.

Description

technical field [0001] The present application relates to the field of databases, in particular to a log sequence number generation method, device and readable storage medium. Background technique [0002] A traditional log manager is a key component of a database management system (Data Base Management System, DBMS), and it adopts a centralized design method. All transactions append log records to a global buffer. Logs the sequence of all update operations for a given database system. The log sequence number (log sequence number, LSN) is the address of the log record on the disk. It can be used as a logical timestamp to indicate the sequence of update actions, and it is also the basis for replaying log records when the system is restored. [0003] In a traditional DBMS, when a transaction needs to operate on a database object, it needs to apply to the lock manager to block the database object, and the corresponding operation can only be performed after the application is ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F16/21G06F11/34
CPCG06F16/21G06F11/34
Inventor 袁振南朱阅岸简怀兵
Owner 袁振南
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products