Check patentability & draft patents in minutes with Patsnap Eureka AI!

Database log replay method, device and equipment and storage medium

A database and log technology, applied in the database field, can solve problems such as query errors and incomplete loading

Pending Publication Date: 2021-04-02
SHANGHAI DAMENG DATABASE
View PDF7 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The present invention provides a database log replay method, device, equipment and storage medium to solve the technical problem that the current replay method may load incomplete database dictionary objects when querying while replaying Redo logs, resulting in query errors

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
  • Database log replay method, device and equipment and storage medium
  • Database log replay method, device and equipment and storage medium
  • Database log replay method, device and equipment and storage medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0027] The present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, but not to limit the present invention. In addition, it should be noted that, for the convenience of description, only some structures related to the present invention are shown in the drawings but not all structures.

[0028] figure 1 It is a schematic structural diagram of physical transactions and redo log records in the embodiment of the database log replay method provided by the present invention. Such as figure 1 As shown, a PTX includes a PTX data header and n RRECs: RREC1, RREC2, ... RRECn. According to different record contents, RRECs can be divided into two types: physical RRECs and logical RRECs. A physical RREC includes a data header and data. The data header may include the type of the RREC, related address infor...

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 invention discloses a database log replay method, device and equipment and a storage medium. The method comprises the steps: determining whether a current redo log packet comprises a target redo log or not, wherein the target redo log is a preset blocked redo log containing an object identification; when it is determined that the current redo log packet comprises the target redo log, waiting for completion of replay of the redo log packet distributed to the replay thread; and when it is determined that the redo log packet distributed to the replay thread is replayed, distributing the current redo log packet to a preset replay thread, and controlling the preset replay thread to perform serial replay on the current redo log packet according to a redo log generation sequence included in the current redo log packet. The database log replay method can ensure that the loaded object dictionary information must be complete during query while replaying the redo log, thereby avoiding query errors.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular, relate to a database log replay method, device, equipment and storage medium. Background technique [0002] Redo (Redo) log is an important functional module in the database management system. The redo log contains the modified content of all physical data pages. Insert / delete / update and other data manipulation language (Data Manipulation Language, DML) operations, Create Table and other data definition language (Data Definition Language, DDL) operations will eventually be transformed into modifications to physical data pages, and these modifications will be reflected in the Redo log middle. Generally speaking, a structured query language (Structured Query Language, SQL) statement (such as Insert) that modifies data will be converted into multiple independent physical transactions in the database management system, and the redo log generated by the...

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): G06F11/14G06F11/16G06F16/27
CPCG06F11/1458G06F11/1675G06F16/273G06F2201/80G06F2201/82Y02D10/00
Inventor 王海龙王蒙蒙韩朱忠
Owner SHANGHAI DAMENG DATABASE
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2025 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com