A database-level fine-grained isolation recovery method, system and medium

By configuring the target database OID and parsing the write-ahead log file, single-database targeted recovery of PostgreSQL databases is achieved, which solves the problem of cross-database data loss and interruption caused by instance-level recovery in existing technologies, and improves the data recovery security and operational flexibility of multi-tenant environments.

CN122363993APending Publication Date: 2026-07-10HIGHGO SOFTWARE
View PDF 0 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
HIGHGO SOFTWARE
Filing Date
2026-06-10
Publication Date
2026-07-10

AI Technical Summary

Technical Problem

The existing PostgreSQL database recovery method is coarse-grained at the instance level, which cannot achieve independent isolation and recovery of a single database, resulting in data loss of non-target databases, cross-business interruption, and difficulty in adapting to multi-tenant fine-grained operation and maintenance scenarios.

Method used

By configuring the target database OID in the database recovery command, and using the parsing of data change records in the write-ahead log file and OID matching, single-database targeted recovery can be achieved. The data change records of the target database are filtered out, and each record is recovered one by one according to the recovery target type until the recovery conditions are met.

Benefits of technology

It enables targeted recovery of a single database, avoids rollback of the entire instance, eliminates the risk of cross-database data interference and business interruption, and improves the security of data recovery and the flexibility of operation and maintenance.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN122363993A_ABST
    Figure CN122363993A_ABST
Patent Text Reader

Abstract

This invention discloses a database-level fine-grained isolation recovery method, system, and medium, belonging to the field of database recovery technology. It addresses the technical problem that existing PostgreSQL databases only support instance-level coarse-grained recovery, cannot achieve independent isolation recovery of a single database, easily leading to data loss in non-target databases, cross-service interruptions, and difficulty in adapting to multi-tenant fine-grained operation and maintenance scenarios. The method includes: reading the target database OID; obtaining the recovery starting point LSN value when entering the database recovery process and locating the corresponding write-ahead log file; reading data change records one by one in the write-ahead log file and extracting the corresponding home database OID of each data change record; matching the target database OID with the home database OID of each data change record to filter out the data change records of the target database; and recovering the data change records of the target database one by one until the recovery target conditions are met.
Need to check novelty before this filing date? Find Prior Art