Database File Recovery with Coordinated Process Access

Solution Overview

Problem

Electronic devices experience errors and data loss when processes access a damaged database during recovery, leading to conflicts and incomplete recovery operations.

Innovation Solution

The electronic device identifies database damage and controls applications to wait until recovery is complete, recording recovery state information to ensure safe access to the recovered database.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Reliability

If the electronic device performs database recovery operation while a process accesses the database, then the database can be restored, but errors occur in the recovery operation and data loss may happen

Engineering Contradiction:

Improvedatabase recovery reliabilityVSAvoiderrors and data loss

Core Design Contradiction:

ReliabilityVSObject-generated harmful factors

Solution Approach 1:

The system performs preliminary actions by setting a recovery flag and notifying waiting processes before the actual recovery operation begins. This preliminary notification mechanism ensures that no new access requests are initiated during recovery, preventing conflicts between read/write operations and recovery processes.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent introduces an intermediary mechanism (recovery flag and notification system) that mediates between processes seeking database access and the recovery operation. This intermediary controls and coordinates access requests, ensuring they are properly managed during recovery without direct conflict.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Productivity

If the process accesses the database being restored during recovery, then the process can continue operation, but database errors occur and recovery may be incomplete

Engineering Contradiction:

Improveprocess operation continuityVSAvoiddatabase access reliability

Core Design Contradiction:

ProductivityVSReliability

Solution Approach 1:

The system performs preliminary actions by setting a recovery flag and notifying waiting processes before the actual recovery operation begins. This preliminary notification mechanism ensures that no new access requests are initiated during recovery, preventing conflicts between read/write operations and recovery processes.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent implements dynamic control by allowing processes to wait dynamically for recovery completion rather than using static blocking. The waiting process can be notified and released once recovery is complete, providing flexibility in managing process access while ensuring database integrity.

Inventive Principle:

Principle #15Dynamics

3Productivity

If the electronic device allows multiple processes to access the database simultaneously during recovery, then system throughput is maintained, but conflicts occur and data integrity is compromised

Engineering Contradiction:

Improvesystem throughputVSAvoiddata integrity

Core Design Contradiction:

ProductivityVSStability of the object's composition

Solution Approach 1:

The system performs preliminary actions by setting a recovery flag and notifying waiting processes before the actual recovery operation begins. This preliminary notification mechanism ensures that no new access requests are initiated during recovery, preventing conflicts between read/write operations and recovery processes.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

The patent introduces an intermediary mechanism (recovery flag and notification system) that mediates between processes seeking database access and the recovery operation. This intermediary controls and coordinates access requests, ensuring they are properly managed during recovery without direct conflict.

Inventive Principle:

Principle #24Intermediary (Mediator)

Data Source

PatentUS12399862B2Method for recovering database file in electronic device

Publication Date: 2025.08.26 SAMSUNG ELECTRONICS CO LTD

AI summary

According to an embodiment, an electronic device includes a memory including a database file and at least one processor connected to the memory. The at least one processor may identify damage to the database file while a first application running on the electronic device accesses the database file. The at least one processor may control a second application running on the electronic device to wait without accessing the database file until recovery of the damaged database file is completed. The at least one processor may record recovery state information indicating that the database file is recovered if the recovery of the damaged database file is completed. The at least one processor may control the second application to access the recovered database file based on the recovery state information.