Priority-Based Database Recovery for Critical Application Continuity
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database recovery technologies recover multiple applications simultaneously, leading to excessively long recovery times for critical services due to their low efficiency.
Innovation Solution
A method and apparatus that determine object identifier sets and key indexes for applications, allowing sequential recovery of database object subsets based on importance, thereby improving recovery efficiency by recovering applications in a hierarchical manner.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If database recovery is performed simultaneously for all applications, then all applications can be recovered at the same time, but the recovery time becomes excessively long for critical services
Solution Approach 1:
The patent segments the database recovery process by dividing applications into different priority levels (first priority, second priority, etc.) based on their importance to business operations. Instead of recovering all applications simultaneously, the system recovers them in sequential batches according to their priority levels, allowing critical services to be restored first while non-critical services follow afterward.
Solution Approach 2:
The patent introduces a priority parameter (key index) for each application that determines the recovery sequence. By changing the recovery parameter from simultaneous execution to priority-based sequential execution, the system optimizes recovery time for critical services while maintaining overall database availability.
2Reliability
If database recovery is performed for the entire database, then all database objects are recovered, but the recovery efficiency is low and critical services cannot be prioritized
Solution Approach 1:
The patent segments the database into multiple object subsets, where each subset corresponds to applications at a specific priority level. The recovery process operates on these segmented subsets in sequence rather than on the entire database at once, improving recovery efficiency by focusing resources on critical services first.
Solution Approach 2:
The patent changes the recovery approach by introducing priority levels as a key parameter. Applications are assigned different priority levels based on their business criticality, and the recovery process uses this parameter to determine execution order, thereby improving both service continuity and recovery efficiency.
Data Source
AI summary
A database recovery method performed by an electronic device includes obtaining object identifier sets corresponding to a plurality of applications, respectively. Each object identifier set includes object identifiers corresponding to a plurality of database objects called during operation of the application corresponding to the object identifier set. The method further includes determining respective key indexes of the plurality of applications that indicate importance of the applications, and determining a recovery order of database object subsets corresponding to the object identifier sets based on an order indicated by the key indexes. Each database object subset is determined based on the database objects corresponding to the object identifiers in the object identifier set corresponding to the database object subset. The method also includes sequentially performing data recovery on the database object subsets based on the recovery order.